Description
AdventureWorks Sales Project is a hands-on project focused on solving practical trainings needs. Throughout the training, students will build complete MS Excel demos using real-world scenarios and datasets. At the completion of training, students will have developed tangible demos for work portfolios as well as improved technical skillsets in MS Excel and enhanced conceptional understandings of data science.
Benefits
• Tangible demos for work portfolios
• Technical skillsets in MS Power Query, MS Power Pivot, DAX, Pivot Charts, and Pivot Tables
• Conceptual understandings of data transformations, data modeling, calculated measures, data visualizations, and data analytics
• Self paced trainings
• Continuous learning resources
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
Deliverables
• Download to 1 Scenario (PDF), 1 Dataset (MS Excel), and 1 Demo (MS Excel)
Requirements
• MS Excel Desktop
Policies
• Cancellation Policy – Ineligible for exchange or refund
