Module 1: Course Overview
- Introduction
- Course Materials
- Facilities
- Prerequisites
- What We’ll Be Discussing
Module 2: Microsoft Business Intelligence Vision
- What is Business Intelligence?
- Enterprise Business Intelligence
- Team Business Intelligence
- Self-Service Business Intelligence
Mobile 3: Excel 2013 PowerPivot
- Best Things That PowerPivot Brings to Excel
- What Will PowerPivot Do for the Analyst?
- Introduction to PivotTables (Optional)
- PowerPivot Versions
- New 2013 PowerPivot Features
- VLOOKUP Not Required (Use Relationships)
- Architectural Changes in Excel 2013
- PowerPivot and Excel 2013
- PowerPivot and SharePoint
- Enterprise Business Intelligence and PowerPivot
- Importing Data
- Data Models
- Relationships
- Simple PivotTable Reports
- Calculated Columns and Calculated Fields
- Refreshing Data
- Calculations
- SharePoint Sharing
Module 4: Power View
- Report Design Principles
- New 2013 Power View Features
- Microsoft Power View User Interface
- Tables
- Charts
- BI Semantic Models
- Saving and Sharing
Mobile 5: Power Query
- Power Query and Power Query Formulas
- ETL with Power Query
- Online Search
- Data Refresh
- Managing Data Sources and Queries
Module 6: Power Map
- What is Power Map and How Does It Work?
- Data Visualizations and 3D Mapping Using Power Map
- What is a Tour?
Module 7: Summary Lab Exercises
- Summary Scenario 1
- Summary Scenario 2
- Summary Scenario 3 (Extra Credit)
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama u toku trajanja kursa
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
Poželjno predznanje:
Experience working with Excel.
Dalje usavršavanje:
Analyzing Data with Excel (MS20779)
Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX) (MS55108)