Power query and power Pivots

Last Update September 16, 2023
0 already enrolled

About This Course

This training course is designed to equip participants with the essential skills and knowledge to effectively utilize Power Query and Power Pivot in Microsoft Excel. Participants will learn how to harness the power of data transformation and analysis to make informed business decisions. This course covers a range of topics, from data importation and transformation using Power Query to advanced data modeling and analysis using Power Pivot.

Learning Objectives

By the end of this course, participants will be able to:
Explore the fundamentals of Power Query and Power Pivot.
Import and transform data from various sources using Power Query.
Clean and prepare data for analysis with Power Query.
Create data models using Power Pivot.
Build relationships between data tables for comprehensive analysis.
Write DAX (Data Analysis Expressions) formulas for custom calculations.
Create interactive and dynamic reports and dashboards.
Enhance data visualization and storytelling in Excel.
Troubleshoot common issues and optimize data models.
Automate data refresh and update processes.

Target Audience

  • M&E professionals
  • Professionals involved in data reporting and analysis
  • Business Analysts
  • Financial Analysts
  • Data Analysts
  • Data Scientists

Curriculum

28 Lessons

Module 1: Introduction to Power Query

What is Power Query?
Installing and enabling Power Query
Importing data from various sources
Basic data transformations

Module 2: Advanced Power Query Techniques

Module 3: Introduction to Power Pivot

Module 4: Data Analysis Expressions (DAX)

Module 5: Building Interactive Dashboards

Module 6: Data Refresh and Automation

Module 7: Real-world Applications and Case Studies

Module 8: Final Projects and Presentations

Your Instructors

admin

0/5
16 Courses
0 Reviews
1 Student
See more
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare
No apps configured. Please contact your administrator.
No apps configured. Please contact your administrator.