Power BI: Adventure Works Project

For this project, I built a dashboard using Power BI. My inspiration came from Microsoft's Customer Profitability sample. For data, I downloaded the AdventureWorks 2014 bakup file for SQL Server from Microsoft. I restored the backup to SQL Server and then linked to it from within Power BI. I modified the data to help with the goal of the reports.

The tables and relationships used for this project are below. To the right is a sample of the main reporting (Fact) table used and the measures created for the report.