The Maven Market Project

The project involved transforming and cleaning the data for analysis. This process utilized a blend of M calculations in Power Query for effective data transformation and cleaning, coupled with DAX calculations for diverse measures. The primary goal was to create an interactive Power BI dashboard that Maven Market owners can use for dynamic exploration of key performance indicators, regional insights and revenue trends. The main points of analysis were:

• Monthly transactions, profits and returns vs the set targets
• Geographical analysis
• Performance by product brand
• A weekly revenue trend