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

Download Course Contents

Analyzing Data with Excel 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.
  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
Live Online Training (Duration : 24 Hours)
Group Training 1050 Per Participant Incl. Official Courseware
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 2100 1200 + If you accept merging of other students. Incl. Official Courseware
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Can’t Attend Live Online? Buy Flexi For Only $99 (Video Recording of Live Online)
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 960

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

Trending Technologies

 Microsoft Azure
 Cloud Computing
 Microsoft Cloud
 Microsoft Dynamics 365
 Microsoft Role-based Certifications
 Microsoft Dynamics
 Fundamentals
 Azure Infrastructure
 Azure Development
 Microsoft Power Platform

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's