Analyzing and Visualizing Data with Microsoft Excel Certification Course (70-799)

Analyzing Data with Excel Certification Training Course Overview

The main purpose of Analyzing Data with Excel 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.

Audience:
  • Students who are experienced with analyzing data with Excel and who wish to add BI techniques.
  • SQL Server report creators who are interested in alternative methods of presenting data.
Test your current knowledge Qubits42

Analyzing and Visualizing Data with Microsoft Excel Certification Course (70-799) (Duration : 24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1050
04 - 06 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 03 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1200
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1
  • Data Analysis in Excel
  • Contents:
  • Module Overview 1-1
  • Lesson 1: Classic Data Analysis with Excel 1-2
  • Lesson 2: Excel PivotTables 1-7
  • Lesson 3: Limitations of Classic Data Analysis 1-10
  • Lab: Building a Classic Excel Dashboard 1-12
  • Module Review and Takeaways
Module 2
  • The Excel Data Model
  • Contents:
  • Module Overview 2-1
  • Lesson 1: Using an Excel Data Model 2-2
  • Lesson 2: DAX 2-7
  • Lab: Explore an Excel Data Model 2-15
  • Module Review and Takeaways
Module 3
  • Importing Data from Files
  • Contents:
  • Module Overview 3-1
  • Lesson 1: Importing Data into Excel 3-2
  • Lesson 2: Shaping and Transforming Data 3-7
  • Lesson 3: Loading Data 3-13
  • Lab: Importing Data 3-17
  • Module Review and Takeaways
Module 4
  • Importing Data from Databases
  • Contents:
  • Module Overview 4-1
  • Lesson 1: Available Data Sources 4-2
  • Lesson 2: Previewing, Shaping, and Transforming Data 4-5
  • Lesson 3: Loading Data 4-10
  • Lesson 4: Table Relationships and Hierarchies 4-14
  • Lab: Importing Data from Multiple Sources 4-18
  • Module Review and Takeaways
Module 5
  • Importing Data from Excel Reports
  • Contents:
  • Module Overview 5-1
  • Lesson 1: Importing Data from Excel Reports 5-2
  • Lesson 2: Transforming Excel Report Data 5-9
  • Lab: Importing Data from a Report 5-17
  • Module Review and Takeaways
Module 6
  • Creating and Formatting Measures
  • Contents:
  • Module Overview 6-1
  • Lesson 1: Data Analysis Expressions 6-2
  • Lesson 2: Measures 6-6
  • Lesson 3: Advanced DAX Functions 6-11
  • Lab: Creating Measures by Using Advanced DAX Functions 6-17
  • Module Review and Takeaways
Module 7
  • Visualizing Data in Excel
  • Contents:
  • Module Overview 7-1
  • Lesson 1: Using PivotCharts 7-2
  • Lesson 2: Using Cube Functions 7-12
  • Lesson 3: Creating Charts for Cube Functions 7-20
  • Lab: Data Visualizations in Excel 7-30
  • Module Review and Takeaways
Module 8
  • Using Excel with Power BI
  • Contents:
  • Module Overview 8-1
  • Lesson 1: Power BI 8-2
  • Lesson 2: Using Excel As a Data Source in Power BI 8-7
  • Lesson 3: Power BI Mobile App 8-12
  • Lab: Creating a Power BI Dashboard with Excel 8-15
Download Course Contents

Request More Information

Course Prerequisites
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.

Upon Completion of this Course, you will accomplish following:-

  • 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