In this project, I created a data model and Power BI report for Seven Sages Brewing Company that combines information from all over the company The data model created in this project made it possible for the company's CFO to quickly review and analyze what product sell well and which ones generate the highest profitability. Combined and centralize data that was previously soiled, solving a very common issue facing many companies. More importantly, requirements for more complex reporting visualization demands, advanced DAX requirements, or larger data models. Main Steps Here are the main steps.
Source files. Downloaded and familiarized myself with the source files provided by SSBC. Sketch the data model. Sketched out the data model that I intend to build. Used Get Data. Used Get Data to load the data from the starter materials into Power BI. Structure, combine, and clean the data. Cleaned and formaedt data so that it will work well in our data model. Create date table. Created a date table to support time intelligence. Build relationships between tables. Build a relationship from each dimension to the relevant key on the fact table. Wrote my measures. To satisfy the CFO's requirements, I wrote six measures—to calculate Sales, Cost of Sales and Gross Profit Margin in two different currencies. Create a report. Build a basic visual report to display my findings.