Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel BI Tools: Get and Transform Data Training Course

Excel BI Tools: Get and Transform Data Training Course


Course Description:  The Excel BI Tools: Get and Transform Data course will train students on how to convert raw data into actionable business intelligence solutions.

Upon completion of the course, users will be able to:

  • Explore and extend a classic Excel dashboard
  • Explore and extend an Excel data model
  • Pre-format and import a .CSV file
  • Creating the Data Model
  • Import data from a SQL Server database
  • Import data from a report
  • Create measures using advanced DAX functions
  • Create data visualizations in Excel
  • Create a Power BI dashboard with Excel

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel BI Tools: Get and Transform Data
Locations: Available Nationwide and Online
Class Date(s): 7/31/2020 - 7/31/2020
Course Fee : $495


Excel BI Tools: Get and Transform Data
Locations: Available Nationwide and Online
Class Date(s): 9/4/2020 - 9/4/2020
Course Fee : $495


Course Syllabus

Power Query Review
Power Query and Power BI
Power Query and Excel
Power Query Concepts
Power Query Walkthrough

Data Sources
Querying Relational Databases
Extracting Data from Files
Using Other Data Sources

Transforming Data with Power Query
Understanding Query Steps
Work with Columns
Filter Rows
Sorta Table
Change Values in a Table
Unpivot Columns and Rows
Transpose a Table
Create Custom Columns

Introducing M
Writing M in the Query Editor
Understanding M Language Concepts
Create Relationships between Tables in the Model
Lists Records and Tables
Functions

Working with Multiple Queries
Use One Query as a Source for Another
Work with Data from Different External data Sources
Append Data from One Query to Another
Merge Two Queries
Explicit Calculated Field

Appendix: Power Query Recipes
Calculations
Table Transformations
Work with Data from the Web

Excel Analytics On-Site Group Training
Arrange a private Excel Analytics training class for your team with one of our Certified Instructors. Private instruction for your team members at a lower per-student price than attending the public courses. Learn More or complete the quote request form below.



Data Analysis On-Demand Training

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile