MPP On-Demand: Analyzing and Visualizing Data with Excel (DAT206x) Course Outline

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

*** Note: This is an On-Demand Self Study Class ***
You can take this class at any time; there are no set dates. It features hands-on labs so you can practice new skills at your workstation. Other parts of the course include video lectures that you can view on-the-go from your phone or tablet. In all cases, customers must call us directly to register this class at 800-288-8221.

MPP On-Demand Series
This course is part of the Microsoft Professional Program Series, MPP: Data Science Track and MPP: Big Data Track. It can be taken individually or as part of either 9-course series, plus a capstone project. You will need to purchase a validated certificate to get credit for this class as part of the MPP. Request the certificate at time of registration.

On-Demand Learner Profiles
MPP On-Demand is a self-study training solution that was designed for two types of learners. First, MPP On-Demand is a great fit for experienced IT professionals who don't need traditional 5-day classes to upgrade their existing skills. They can pick and choose topics to make the most effective use of their time. Second, MPP On-Demand is perfect for highly-motivated individuals who are new to a technology and need to space their learning over a period of weeks or months. These learners can take their time and repeat sections as needed until they master the new concepts.


Overview
Explore tools in Excel that enable the analysis of more data than ever before, with improved visualizations and more sophisticated business logic. Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis.

Duration
This Microsoft authorized class is an online elearning course that should take between 12 to 24 hours of effort, depending on your background.

Course Outline

Data Analysis in Excel
Lab: Explore and Extend a Classic Excel Dashboard

The Excel Data Model
Basic DAX
Lab: Explore an Excel Data Model

Importing Data from a CSV File
Lab: Importing Data from a CSV File

Importing Data from Databases
Importing Data from Multiple Files
Create a Date Table in Excel Data Model
Lab: Creating Mash-ups of Data from Multiple Sources

Creating and Formatting Measures
Using Advanced DAX Functions
Lab: Creating Measures using Advanced DAX Functions

Importing Data from a Formatted Excel Report
Lab: Advanced Text Query

Visualizing Data in Excel
Lab: Data Visualizations in Excel

Using Excel with Power BI
Power BI Mobile App

DAT206x
View outline in Word

ED206X

Attend hands-on, instructor-led MPP On-Demand: Analyzing and Visualizing Data with Excel (DAT206x) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.