Microsoft Excel Business Intelligence Self Paced Bootcamp (Power Query + Power Pivots + DAX)

excel icon$49

 

 

 

 

What is covered in the Bootcamp?

This Bootcamp covers creating relational data within Microsoft Excel and SQL using Power Queries. Power Queries allow you to analyze large amounts of relational  via primary and foreign keyed data.

 

 

Prerequisite: Microsoft Excel Pivot Table and SQL Beginner Bootcamp knowledge

Release Date: January 11th, 2021

 

Course 1: Fact vs. Dimension Tables 

  • Import data
  • Establish fact and dimension tables
  • Foreign vs. primary keys

Course 2: Building Data Models

  • Connect SQL databases to Microsoft Excel to build data models
  • Write SQL queries from Data Model in Excel

Course 3: Transforming Data via Power Query (Part 1)

  • Transform imported text data via Power Query

Course 4: Transforming Data via Power Query (Part 2)

  • Transform imported date data via Power Query

Course 5: Transforming Data via Power Query (Part 3)

  • Combine multiple queries via Power Query

Course 6: Creating Relationships (Part 1)

  • Create relationships between multiple tables in Excel

Course 7: Creating Relationships (Part 2)

  • Create relationships between multiple tables in Excel

Course 8: Creating Power Pivots

  • Create pivot tables from related data models

Course 9: Power Pivots + DAX (Part 1)

  • Create calculated fields within Power Pivots via DAX

Course 10: Power Pivots + DAX (Part 3)

  • Overview of DAX measures

Course 11: Power Pivots + DAX (Part 4)

  • Overview of DAX measures

 

Microsoft Excel 2020 or newer required for PC Laptops. MACs are not allowed for this Bootcamp.

 

What's Included:

Certificate of Completion

You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.

 

 

Refund Policy: No Refunds

 

 

$49.00