Microsoft Excel Data Modeling + Business Intelligence Online Bootcamp

Learn how to model data from various data sources with this Excel BI Bootcamp

All Bootcamps are held online due to COVID-19
This Online Bootcamp is live and instructor led
Price $99
What is data modeling in Microsoft Excel?
Data modeling allows you to connect and extract data from multiple data sources into Microsoft Excel. Once the data is imported, you are now able to analyze the data in Power Pivots. Let's break it down some more.....what if you would like to extract a large amount of data from a database such as SQL and then analyze and manipulate that data in Excel. You would need to master data modeling to do so, and that's what eXcelerate is here to teach you.

Course Schedule
Course Dates: February 8th - February 25th
Days of the week: Weeknights (Monday - Wednesday)
Time (EST): 730p - 830p EST

 

 

Course 1: Fact vs. Dimension Tables

Monday, February 8th | 7:30p - 8:30p

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

Course 2: Building Data Models

Tuesday, February 9th | 7:30p - 8:30p

  • Create and add tables to data model
  • Relate created tables
  • Cardinality and filter direction

Course 3: Creating Relationships (Part 1)

Wednesday, February 10th | 7:30p - 8:30p

  • Create relationships between multiple tables in Excel

Course 4: Creating Relationships (Part 2)

Monday, February 15th | 7:30p - 8:30p

  • Create relationships between multiple tables in Excel

Course 5: Creating Power Pivots

Tuesday, February 16th | 7:30p - 8:30p

  • Create pivot tables from related data models

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

Wednesday, February 17th | 7:30p - 8:30p

  • Transform imported text data via Power Query

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

Monday, February 22nd | 7:30p - 8:30p


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

Tuesday, February 23rd | 7:30p - 8:30p


Course 9: Power Pivots + DAX (Part 1)

Wednesday, February 24th | 7:30p - 8:30p

  • Create calculated fields within Power Pivots via DAX

Course 10: Power Pivots + DAX (Part 2)

Thursday, February 25th | 7:30p - 8:30p

  • Overview of DAX measures

 

Microsoft Excel 2020 or newer required for PC Laptops. MACs are not allowed for this Bootcamp.
Course materials, access codes, and reminders will be sent 7 days prior to the start of the first course of the 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
$99.00