Module 1: Data Analysis in Excel
- This module looks at the classic Excel dashboard and at ways to extend it.
- Classic Data Analysis with Excel
- Excel Pivot Tables
- Limitations of Classic Data Analysis
Module 2: The Excel Data Model
- This module looks at the classic Excel data model and at ways to extend it.
- Using an Excel Data Model
- DAX
Module 3: Importing Data from Files
- This module looks at pre-formatting and importing CSV files.
- Importing Data into Excel
- Shaping and Transforming Data
- Loading Data
Module 4: Importing Data from Databases
- This module looks at how to import data into Excel from a SQL Server database.
- Available Data Sources
- Previewing, Shaping, and Transforming Data
- Table Relationships and Hierarchies
- Loading Data
Module 5: Importing Data from Excel Reports
- This module describes how to import data from a report.
- Importing Data from Excel Reports
- Transforming Excel report Data
Module 6: Creating and Formatting Measures
- This module describes how to create and format measures.
- DAX
- Measures
- Advanced DAX Functions
Module 7: Visualizing Data in Excel
- This module describes how to visualize data in Excel.
- Pivot Charts
- Cube Functions
- Charts for Cube Functions
Module 8: Using Excel with Power BI
- This module describes how to use Excel with Power BI.
- Power BI
- Uploading Excel Data to Power BI
- Power BI Mobile App
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama putem Interneta 180 dana od kraja obuke
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
- Mogućnost korišćenja Microsoft SA vaučera za plaćanje ove obuke
Poželjno predznanje:
Before attending this course, students must have:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Good Knowledge of Excel spreadsheets, functions, and charts.
- Working knowledge of relational databases.
Dalje usavršavanje:
Master Data Services, Data Quality Services with SQL 2012 -2014 and Excel
Analyzing Data with Power BI