The aim of the project was to create a report using default visuals, AI visuals, etc., to get key insights from the business which helps in strategic planning for the future.
Extracted data from Excel, performed various transformations in Power Query and injected it into the Power BI Desktop.
Designed a Star Schema data model, performed calculations using DAX functions created Quick Measures also Implemented Row-level-Security, and published BI report to Power BI Service in order to create a Dashboard.
Based on the report, the United States, Canada, and Australia were the top 3 countries with the highest number of sales, and bikes are the highest-selling category