20779 Analyzing Data with Excel

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 Pivot Charts, the Excel Data Model, and Power BI.

Learning Objectives

After completing this course, students 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.
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.

Course Outline

1 - DATA ANALYSIS IN EXCEL

Classic Data Analysis with Excel
Excel Pivot Tables
Limitations of Classic Data Analysis
Lab: Building a Classic Excel Dashboard

2 - THE EXCEL DATA MODEL

Using an Excel Data Model
DAX
Lab: Explore an Excel Data Model

3 - IMPORTING DATA FROM FILES

Importing Data into Excel
Shaping and Transforming Data
Loading Data
Lab: Importing Data from a CSV File

4 - IMPORTING DATA FROM DATABASES

Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data
Lab: Import Data from Multiple Sources

5 - IMPORTING DATA FROM EXCEL REPORTS

Importing Data from Excel Reports
Transforming Excel report Data
Lab: Importing Data from a Report

6 - CREATING AND FORMATTING MEASURES

DAX
Measures
Advanced DAX Functions
Lab: Creating Measures using Advanced DAX Functions

7 - VISUALIZING DATA IN EXCEL

Pivot Charts
Cube Functions
Charts for Cube Functions
Lab: Data Visualization in Excel

8 - USING EXCEL WITH POWER BI

Power BI
Uploading Excel Data to Power BI
Power BI Mobile App
Lab: Creating a Power BI Dashboard with Excel

Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Contact Us For Price

Course Length: 3 Days

1. Choose a Date | 2. Click Enroll Now

Jan 20

Online LIVE, 8:00 am - 4:00 pm
NHCLC G2R

Apr 28

Online LIVE, 6:00 am - 2:00 pm
NHCLC G2R

Need Help Picking the Right Course? Give us a call! 781-388-0026