55163 Preparing Your Data for Power BI

Course Details

• At Course Completion
• Understand Analysis Services Installation and Architecture: One Product, Two Models.
• Understand version changes: SQL Server Analysis Services.
• Understand important terms, Understand and utilize SQL Server Data Tools for Tabular
• Understand and utilize projects, Understand and utilize importing.
• Understand and utilize loading data
• Understand and utilize examining views
• Understand and utilize deployment, Understand and utilize data sources
• Understand and utilize data credentials, Understand and utilize SQL as a source
• Understand and utilize Excel as a source, Understand and utilize Flat Files as a source
• Understand and utilize Azure as a source, Understand and utilize SharePoint as a source
• Understand and utilize sorting during load, Understand querying with MDX
• Understand and utilize DAX syntax
• .
• Understand and utilize DAX data types and operator overloading
• Understand and utilize DAX operators
• Understand and utilize DAX values, Understand and utilize measures
• Understand and utilize calculated columns
• Understand evaluation contexts
• Understand and utilize date calculations
• Understand and utilize importing related tables
• Understand and utilize creating relationships, Understand and utilize hierarchies
• Understand Direct Query, Understand and utilize KPIs
• Understand drill through, Understand perspectives
• Understand and utilize PowerPivot, Understand and utilize Pivot Tables
• Understand and utilize Power View
• Module 1: Course Overview
• Introduction
• Course Materials
• Facilities
• Prerequisites
• What We'll Be Discussing
• Lab 1: Course Overview
• Module 2: What is the Tabular Model?
• Analysis Services Installation and Architecture: One Product, Two Models
• Version Changes: SQL Server Analysis Services
• Important Terms
• SQL Server Data Tools for Tabular
• Lab 1: What is the Tabular Model?
• Module 3: Working in Tabular
• Projects
• Importing
• Loading Data
• Examining Views
• Deployment
• Lab 1: Working in Tabular
• Module 4: Working in Tabular
• Understand and utilize projects.
• Understand and utilize importing.
• Understand and utilize loading data
• Understand and utilize examining views
• Understand and utilize deployment
• Module 5: Understanding Loading Data From Different Sources
• Data Sources
• Data Credentials
• SQL as a Source
• Excel as a Source
• Flat Files as a Source
• Azure as a Source
• SharePoint as a Source
• Sorting During Load
• Lab 1: Understanding Loading Data From Different Sources
• Module 6: Using DAX and MDX
• Querying with MDX
• Basic DAX Syntax
• Evaluation Context
• Calculate Function
• Time Intelligence
• Lab 1: Using DAX and MDX
• Module 7: Building Data Models
• Importing Related Tables
• Creating Relationships
• Hierarchies
• Direct Query
• KPIs
• Drill through
• Perspectives
• Lab 1: Building Data Models
• Module 8: Excel PowerPivot and Tabular
• Working with PowerPivot
• Working with Pivot Tables
• Working with PowerView
• Lab 1: Excel PowerPivot and Tabular