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.

CBS (Statistics Netherlands) provides reliable statistical information and data to provide insights into social issues. The 0DATA API allows users to consistently access this data. The Breeding bird dataset provides insights into the breeding trends of endemic species that regularly breed in The Netherlands. My goal was to use the CBS API to explore this dataset and determine which birds show the strongest positive and negative trend over the past 12 years.