Description
AdventureWorks Sales Project is a hands-on project focused on building automated business analytics reports with MS Excel. 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, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables 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, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables
• 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 MS Power Pivot
3. Calculated Measures using DAX
4. Data Visualizations using Pivot Charts
5. Data Analytics using Pivot Tables
Downloadables
• 1 ZIP file containing 1 Scenario (PDF), 1 Dataset (MS Excel), and 1 Demo (MS Excel)
Requirements
• MS Excel Desktop
