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.

Bike sharing systems are a means of renting bicycles. The goal of the Bike Sharing Demand competition is to predict demand by combining historical usage patterns with weather data. For this project I Explored the effect of features on the bike rental count using line and point plots Tested a variety of Regression models, including Linear regression, Ridge regression, Random forest regression, KNN and XGBoost Optimized the performance of the best performing models using GridSearch CV Used a voting ensemble on the optimized models to boost model performance resulting in a top 5% score Click here to view this project on GitHub.