Preview

55163: Preparing Your Data for Power BI

 

55163: Preparing Your Data for Power BI

Key Features

  • Learn from anywhere in the world. Connect with an Instructor in real time.
  • Attend Live Class from a PC or Mobile.
  • Ask questions from an Instructor in real time over voice & chat.
  • Includes Certificate of Completion.
  • Official Exam & Certification Assitance.
  • Get 30 Days free after class support.

Join a next available Live Class:

This course training is available on request only. Send us your request with preferred date & timings & our training advisor will get back to you within 24 business hours.


Request for a Live Class

as per your availability

Course Description

About the Course

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

Course Curriculum

Course # : 55163
Exam : Preparing Your Data for Power BI

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

Target Audience

  • The course is targeted towards business analysts, business intelligence developers, and SQL Professionals.

Prerequisites

  • Required: A working knowledge of SQL Server

Enquire for more information

Be Amazed with Online Learning Experience
Future is fast forwarding towards online learning & now it’s becoming easy for everyone to take a world class training from anywhere in the world. Listen from Learnfly Live recent alumni’s studying around the globe.

Get an e-Certificate of Completion

Get a e-Certificate of Course Completion after successfully completing your live class with Learnfly. Share & showcase your proud achievement with your friends & colleagues. Join a live class today & start learning online from anywhere: