Power BI project using Power Query and DAX
- Dashboard for Adventure Works Cycles, a global manufacturing company using PowerBI Desktop to track KPIs (Sales, Revenue, Profit and Returns), compared regional performance, analyzed product-level trends and forecasts by using raw CSV files containing information about transactions, returns, products and territories.
Steps followed to build dashboard:
- Connecting Data with Power BI Desktop.
- Data Cleaning using Power Query Editor.
- Build a relational data model.
- Create new calculated columns and DAX measures.
- Design an interactive report to analyze and visualize the data.
- Dashboard for Maven Market, a multi-national grocery chain with locations in Canada, Mexico and the United States.
Worked through the entire business intelligence workflow:
- Connecting and shaping the source data
- Building a relational model
- Adding calculated columns and measures
- Designing an interactive report