Analyzing Data with Excel

Elevate your data analysis skills with our 'Analyzing Data with Excel' course, designed for professionals and SQL Server report creators looking to harness advanced BI techniques using Power Query, PivotTables, and Power BI.

Course Category Icon

Essential Skills Gained

Checkmark

Design and extend Excel dashboards and data models.

Checkmark

Implement data import and transformation from various files and databases.

Checkmark

Create advanced measures using DAX functions.

Checkmark

Visualize data effectively using Excel and Power BI.

Format

  • Instructor-led
  • 3 days with lectures and hands-on labs.

Audience

  • Data Analysts
  • SQL Server Report Creators
  • Business Intelligence Professionals
  • Excel Users Seeking Advanced Skills

Description

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Power Query Power Pivot Tables, Pivot Charts, the Excel Data Model, and Power BI.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Module 1: Data Analysis in Excel

  1. Classic Data Analysis with Excel

  2. Excel Pivot Tables

  3. Limitations of Classic Data Analysis

  4. Lab: Building a Classic Excel Dashboard

Module 2: The Excel Data Model

  1. Using an Excel Data Model

  2. DAX

  3. Lab: Explore an Excel Data Model

Module 3: Importing Data from Files

  1. Importing Data into Excel

  2. Shaping and Transforming Data

  3. Loading Data

  4. Lab: Importing Data from a CSV File

Module 4: Importing Data from Databases

  1. Available Data Sources

  2. Previewing, Shaping, and Transforming Data

  3. Table Relationships and Hierarchies

  4. Loading Data

  5. Lab: Import Data from Multiple Sources

Module 5: Importing Data from Excel Reports

  1. Importing Data from Excel Reports

  2. Transforming Excel report Data

  3. Lab: Importing Data from a Report

Module 6: Creating and Formatting Measures

  1. DAX

  2. Measures

  3. Advanced DAX Functions

  4. Lab: Creating Measures using Advanced DAX Functions

Module 7: Visualizing Data in Excel

  1. Pivot Charts

  2. Cube Functions

  3. Charts for Cube Functions

  4. Lab: Data Visualization in Excel

Module 8: Using Excel with Power BI

  1. Power BI

  2. Uploading Excel Data to Power BI

  3. Power BI Mobile App

  4. Lab: Creating a Power BI Dashboard with Excel

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.