Training on Demand

Microsoft on Demand Training 20779 - Analyzing Data with Excel (90 Day) Packaged Set inkl Kursunterlagen

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.

von Learning 1st
Fortgeschritten Englisch

Beschreibung

Course OutlineModule 1: Data Analysis in ExcelThis module looks at the classic Excel dashboard and at ways to extend it.Lessons

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

Lab : Building a Classic Excel Dashboard

Filtering and Formatting Data
Building a Pivot Table
Building a Pivot Chart
Building a Dashboard

After completing this module, students will be able to:

Describe classic data...

alles anzeigen

Ziel

After completing this course, students will be able to:

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.

Anforderungen an die Teilnehmer

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.

Teilnehmer

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.

Problem melden


Danke

für Ihr Interesse an diesem Produkt.

Wir setzen uns umgehend mit dem Anbieter in Verbindung und werden in Kürze neue Termine anbieten.
Spätestens in 14 Tagen werden wir Sie über die neuen Termine informieren.

Solange finden Sie das Produkt in Ihrer Wunschliste wieder.