Practical project with a goal of creating an architecture, developing and analyzing insurance company data during the years 2011-2013 with various tools and languages
This project aim to:
- populate data
- developing sturctures and architectures
- analyzing the data
- understanding the business
- managing errors
The following steps will be done-
-
uploade the data to an SQL platform- both from SQL queries and CSV files
-
import the data to Power Query
-
preform ETL with M-Language
-
transform the DB to a star scheme
-
develope a tabular model with Power Pivot- for an easy use by the end users
-
create measures, calculated columns and KPI measures
-
create hierarchies
-
import the tabular model to Power BI- preform ETL there too- inclusing sorting the data, formatting the data types, hide columns, creating hierarchies
-
create multiple dashboards in Power BI platform to answer on business questions
-
create DAX measures and queries on DAX Studio
-
create KPI dynamic measures using Tabular Editor external tool for PBI
