18756 Stone Oak Park Way, Suite200, San Antonio TX 78258 USA
100 Queen St W, Brampton, ON L6X 1A4, Canada
country flagUnited States
share button

55163: Preparing Your Data for Power BI Training


What 55163: Preparing Your Data for Power BI training is all about?

The course introduces Learners to SQL BISM (Business Intelligence Semantic Model) Tabular model, DAX and data modelling

2 SATVs applicable


Schedule
  • Delivery Format:
Date: Oct 08, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1150 USD
  • Delivery Format:
Date: Oct 14, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1150 USD
  • Delivery Format:
Date: Oct 20, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1150 USD
  • Delivery Format:
Date: Oct 28, 2020 | 9:00 am - 5:00 pm EST
Location: Online
$1150 USD
What are the course objectives for 55163: Preparing Your Data for Power BI training?
  • Understanding Installation and Architecture of Analysis Services: One Product, Two Models.
  • Understanding version changes in SQL SAS.
  • Understanding important terms.
  • Understanding and utilizing SSDT for Tabular.
  • Understanding and utilizing projects.
  • Understanding and utilizing importing.
  • Understanding and utilizing loading data.
  • Understanding and utilizing examining views.
  • Understanding and utilizing deployment.
  • Understanding and utilizing data sources.
  • Understanding and utilizing data credentials.
  • Understanding and utilizing SQL as a source.
  • Understanding and utilizing Excel as a source.
  • Understanding and utilizing Flat Files as a source.
  • Understanding and utilizing Azure as a source.
  • Understanding and utilizing SharePoint as a source.
  • Understanding and utilizing sorting during load.
  • Understanding querying with MDX.
  • Understanding and utilizing DAX syntax.
  • Understanding and utilizing operator overloading and DAX data types.
  • Understanding and utilizing DAX operators.
  • Understanding and utilizing DAX values.
  • Understanding and utilizing measures.
  • Understanding and utilizing calculated columns.
  • Understanding evaluation contexts.
  • Understanding and utilizing date calculations.
  • Understanding and utilizing importing related tables.
  • Understanding and utilizing creating relationships.
  • Understanding and utilizing hierarchies.
  • Understanding Direct Query.
  • Understanding and utilizing KPIs.
  • Understanding drill-through.
  • Understanding perspectives.
  • Understanding and utilizing PowerPivot.
  • Understanding and utilizing Pivot Tables.
  • Understanding and utilizing Power View.
Who should attend 55163: Preparing Your Data for Power BI training?

The course is created for business intelligence developers, analysts and SQL professionals.

What is the course outline for 55163: Preparing Your Data for Power BI training?
  • 1. Course Overview
  • a). Introduction
  • b). Course Materials
  • c). Facilities
  • d). Prerequisites
  • e). What We'll Be Discussing
  • f). Lab: Course Overview
  • 2. What is the Tabular Model?
  • a). Analysis Services Installation and Architecture: One Product, Two Models
  • b). Version Changes: SQL Server Analysis Services
  • c). Important Terms
  • d). SQL Server Data Tools for Tabular
  • e). Lab: What is the Tabular Model?
  • 3. Working in Tabular
  • a). Projects
  • b). Importing
  • c). Loading Data
  • d). Examining Views
  • e). Deployment
  • f). Lab: Working in Tabular
  • 4. Understanding Loading Data From Different Sources
  • a). Data Sources
  • b). Data Credentials
  • c). SQL as a Source
  • d). Excel as a Source
  • e). Flat Files as a Source
  • f). Azure as a Source
  • g). SharePoint as a Source
  • h). Sorting During Load
  • i). Lab: Understanding Loading Data From Different Sources
  • 5. Using DAX and MDX
  • a). Querying with MDX
  • b). Basic DAX Syntax
  • c). Evaluation Context
  • d). Calculate Function
  • e). Time Intelligence
  • f). Lab: Using DAX and MDX
  • 6. Building Data Models
  • a). Importing Related Tables
  • b). Creating Relationships
  • c). Hierarchies
  • d). Direct Query
  • e). KPIs
  • f). Drillthrough
  • g). Perspectives
  • h). Lab: Building Data Models
  • 7. Excel PowerPivot and Tabular
  • a). Working with PowerPivot
  • b). Working with Pivot Tables
  • c). Working with PowerView
  • d). Lab: Excel PowerPivot and Tabular
2 Days | $ 1150
4.4
  234 Ratings

1212 Learners

Get In Touch

Are you being sponsored by your employer to take this class?
* I authorize Microtek Learning to contact me via Phone/Email