Skip to main content

Analyzing and Visualizing Data with Excel

¡Inscríbete ahora al curso gratuito! Haz click en el botón ENROLL IN y adicionalmente agrega opciones Premium para mejorar tu experiencia de aprendizaje.



About this course

This course is part of the Microsoft Professional Program Certificate in Big Data, and the Microsoft Professional Program Certificate in Data Science.

Excel is one of the most widely used solutions for analyzing and visualizing data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.

Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualized and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.

Do you feel that the contents of this course is a bit too advanced for you and you need to fill some gaps in your Excel knowledge? Do you need a better understanding of how pivot tables, pivot charts and slicers work together, and help in creating dashboards? If so, check out DAT205x: Introduction to Data Analysis using Excel.

This course is also a part of the Microsoft Excel for the Data Analyst XSeries.

Prerequisites

Understanding of Excel analytic tools such as tables, pivot tables and pivot charts. Also, some experience in working with data from databases and also from text files will be helpful.

System Requirements:

  1. Windows operating system: Windows 7 or later.
  2. Microsoft Excel on Windows operating system:
  • Microsoft Excel 2016 Professional Plus or standalone edition
  • Microsoft Excel 2013 Professional Plus or standalone edition
  • Microsoft Excel 2010
  • Other versions of Microsoft Excel are not supported

What you'll learn

  • Gather and transform data from multiple sources
  • Discover and combine data in mashups
  • Learn about data model creation
  • Explore, analyze, and visualize data

Syllabus

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

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

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

Module 4
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

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

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

Module 7
Visualizing Data in Excel
Lab: Data Visualizations in Excel

Module 8
Using Excel with Power BI
Power BI Mobile App

  1. Course Number

    DAT206x
  2. Classes Start

  3. Classes End

  4. Estimated Effort

    12 -24 horas en total
Enroll