This notebook records the entire BI development cycle including all the steps and explanations that went into the creation of the Power BI Report.
Perform BI development and analysis for a global manufacturing company that produces cycling equipment and accessories.
The management of the company needs a way to track business critical KPIs (such as sales, revenue, profit and returns), in order to compare regional performance, analyze product-level trends, and identify high-value customers.
The business can only provide raw .csv files.
The BI development workflow can be summarized as follows:
<aside> <img src="/icons/gears_yellow.svg" alt="/icons/gears_yellow.svg" width="40px" />
ETL ↴
Data Modelling ↴
Developing Measures with DAX ↴
Inserting Custom Visualizations ↴
Optimizing Report Performance
</aside>
The steps are broken down into individual pages (click page to view). Each page explains the associated stage of the BI development process in detail: