In preparation for my DA-100 exam, I retook the Power BI course from Maven Analytics on Udemy. Less than a year ago, I created a dynamic dashboard in Excel. In comparison to some of the formulas I wrote then to make the dashboard perform the way I needed it, I can say that Power BI and Dax are an absolute delight.

For this project I

• Created a Sales Report in Power BI giving detailed insights on best-selling products and customers
• Imported data from Excel and used Power Query to transform the data
• Created a data model in Power BI and used DAX to create calculated columns and measures
• Improved user experience by applying conditional formatting, drillthrough filters and visual interactions

Click here to view this project on GitHub.

• scene