Corso attualmente non disponibile
MOC 20779 - Analizing Data with Excel
Corso
A Villafranca di Verona ()
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
Descrizione
-
Tipologia
Corso
-
Ore di lezione
21h
-
Durata
3 Giorni
Esplorare ed estendere una dashboard classico di Excel.
Esplorare ed estendere un modello di dati Excel.
Pre-formattare e importare un file CSV.
Importare i dati da un database di SQL Server
Importare i dati da un report.
Creare misure utilizzando funzioni avanzate DAX.
Creare visualizzazioni di dati in Excel.
Creare una dashboard Power BI con Excel.
Opinioni
Materie
- Database
- Power BI
- Excel
- Analisi
- DAX
- SQL Server
- Pivoting
- Mobile
- CSV
- Analytics
Programma
Module 1: Data Analysis in Excel
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 analysis with Excel
Describe Excel pivot tables
Describe the limitations of classic data analysis with Excel
Module 2: The Excel Data Model
Using an Excel Data Model
DAX
Lab : Explore an Excel Data Model
Create Calculated Columns
Format Data Model Data
Create Measures
Analyze the Data
After completing this module, students will be able to:
Describe an Excel data model
View data within an Excel data table
Describe DAX
Module 3: Importing Data from Files
Importing Data into Excel
Shaping and Transforming Data
Loading Data
Lab : Importing Data from a CSV File
Import and Transform Data from a CSV File
Add Data from a Folder
After completing this module, students will be able to:
Import data into excel.
Shape and transform data.
Load data.
Module 4: Importing Data from Databases
Available Data Sources
Previewing, Shaping, and Transforming Data
Table Relationships and Hierarchies
Loading Data
Lab : Import Data from Multiple Sources
Import Data from SQL Server
Import Data from a CSV File
Create a Data Table
After completing this module, students will be able to:
Identify available data sources.
Preview, shape, and transform data.
Explain table relationships and hierarchies.
Load data from various sources.
Module 5: Importing Data from Excel Reports
Importing Data from Excel Reports
Transforming Excel report Data
Lab : Importing Data from a Report
Import Data from Excel
Transform the Excel Data
Load the Data into an Excel Data Model
After completing this module, students will be able to:
Import data from Excel reports.
Transform Excel report data.
Module 6: Creating and Formatting Measures
DAX
Measures
Advanced DAX Functions
Lab : Creating Measures using Advanced DAX Functions
Last year comparison
Year to date
Market Share
After completing this module, students will be able to:
Explain what DAX is and when to use it.
Describe a measure.
Use some of the advanced functions within DAX.
Module 7: Visualizing Data in Excel
Pivot Charts
Cube Functions
Charts for Cube Functions
Lab : Data Visualization in Excel
Create a Tabular Report
Create a Pivot Chart
Add Slicers to Charts
After completing this module, students will be able to:
Create and refine a pivot chart.
Describe cube functions and when to use them.
Describe a number of charts for use with cube functions.
Module 8: Using Excel with Power BI
Power BI
Uploading Excel Data to Power BI
Power BI Mobile App
Lab : Creating a Power BI Dashboard with Excel
Uploading Excel Data
Creating a Power BI Dashboard
After completing this module, students will be able to:
Describe Power Bi and the various versions available.
Upload Excel data to Power BI.
Describe the Power BI App.
Hai bisogno di un coach per la formazione?
Ti aiuterà a confrontare vari corsi e trovare l'offerta formativa più conveniente.
MOC 20779 - Analizing Data with Excel