Description
AdventureWorks Sales Project is a hands-on project focused on building automated business analytics reports with MS Power BI. Students will develop a complete project for professional portfolio using a real-world scenario and dataset. Students will improve technical skillset in MS Power Query, Relationships, DAX, Visuals, and MS Excel as well as conceptional understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics.
Benefits
• Complete project for professional portfolio
• Technical skillset in MS Power Query, Relationships, DAX, Visuals, and MS Excel
• Conceptual understanding of data transformations, data modeling, calculated measures, data visualizations, and data analytics
Topics
1. Data Transformations using MS Power Query
2. Data Modeling using Relationships
3. Calculated Measures using DAX
4. Data Visualizations using Reports, Dashboards, and Narratives
5. Data Analytics using MS Excel or Google Sheets
Downloadables
• 1 ZIP file containing 1 Scenario (PDF), 1 Dataset (MS Excel), and 1 Demo (MS Power BI)
Requirements
• MS Power BI Desktop
• MS Excel Desktop or Google Sheets
