MOC 20779: Analyzing Data with Excel

Seminarinformationen

Seminar - Ziel

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.

Teilnehmer - Zielgruppe

This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Kurs - Voraussetzungen

Before attending this course, students must have:

  • 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.
  • Basic knowledge of data analytics equivalent to having attended course 10994.

Seminardauer

  • 3 Tage
  • 09:00 Uhr bis 17:00 Uhr

Schulungsunterlagen

  • nach Absprache

Seminar-Inhalt / Agenda

Module 1: Data Analysis in Excel

  • Classic Data Analysis with Excel
  • Excel Pivot Tables
  • Limitations of Classic Data Analysis

Module 2: The Excel Data Model

  • Using an Excel Data Model
  • DAX

Module 3: Importing Data from Files

  • Importing Data into Excel
  • Shaping and Transforming Data
  • Loading Data


Module 4: Importing Data from Databases

  • Available Data Sources
  • Previewing, Shaping, and Transforming Data
  • Table Relationships and Hierarchies
  • Loading Data

Module 5: Importing Data from Excel Reports

  • Importing Data from Excel Reports
  • Transforming Excel report Data

Module 6: Creating and Formatting Measures

  • DAX
  • Measures
  • Advanced DAX Functions

Module 7: Visualizing Data in Excel

  • Pivot Charts
  • Cube Functions
  • Charts for Cube Functions

Module 8: Using Excel with Power BI

  • Power BI
  • Uploading Excel Data to Power BI
  • Power BI Mobile App

Weitere Schulungen zu Thema Power BI

DA-100: Analyzing Data with Power BI

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including ...

MOC 10994: Data Analysis Fundamentals using Excel

- u.a. in Nürnberg, Berlin, Stuttgart, München, Köln

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.