55163: Preparing Your Data for Power BI

Objectives

• 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 drillthrough
• Understand perspectives
• Understand and utilize PowerPivot
• Understand and utilze Pivot Tables
• Understand and utilize Power View