Course Overview
- Course Title: Advanced Excel: Power Query, Power Pivot and DAX
- Instructor: Start-Tech Academy
- Target Audience: Business analysts, data enthusiasts, finance professionals, or anyone who works with data regularly
- Prerequisites: A PC with Excel installed and a basic understanding of Excel is helpful but not required, and a willingness to learn step by step
Curriculum Highlights
- Key Topics Covered:
- Importing data from multiple sources
- Mastering Power Query for data cleaning and transformation
- Building relationships and scalable data models using Power Pivot
- Creating pivot tables and charts
- Performing advanced calculations with DAX
- Key Skills Learned:
- Data import from CSV, SQL, folders, and XML sources
- Data cleaning, transformation, and shaping using Power Query
- Creating data models and building relationships using Power Pivot
- Using DAX formulas for advanced calculations
- Analyzing business trends using PivotTables and PivotCharts
- Automating reporting and enhancing insights in Excel
Course Format
- Duration: 4 hours on-demand video
- Format: Self-paced online course
- Resources:
- 2 articles
- 5 downloadable resources
- Access on mobile and TV
- Certificate of completion