This was a project working with MySQL and PowerBI. This project transfers my knowledge of Tableau from my Master’s degree into Power BI. I had to take on many typical data analytics life cycle tasks including:
- Loading a SQL database
- Connecting Power BI to the SQL database
- Exploring the data
- Cleaning the data (duplicates, null values, and incorrect values)
- Creating visualizations
I learned how to use Power Bi to make interactive dashboards which can quickly show important information of different types. Below is a screenshot of part of the dashboard for reference.