Advanced Excel: Power Query, Power Pivot and DAX

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