Description
MS Excel for Business Analytics is a project-based workshop 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
• Live group training
• 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
• 60-min live group training via Google Meet
Requirements
• MS Excel Desktop
• Private information secured during screensharing
Policies
• Cancellation Policy – Cancelled or Missed attendance without 7-day notice will be charged in full and ineligible for rescheduling, exchange, or refund. Late arrival over 15-min will be considered Missed.
