55163: Preparing Your Data for Power BI

Key Features MONEY BACK GUARANTEE

How this works :

At Learnfly, we greatly value the trust of our patrons. Our courses are designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Instructor Led Training :

Raise refund request within 7 days of commencement of the first batch you are eligible to attend. Money back guarantee is void if the participant has accessed more than 25% content of an e-learning course or has attended Online Classrooms for more than 1 day.

  • Learn with practical projects and hands on real tools.
  • Official Curriculum & Courseware Content.
  • Online Interactive Lab's Access.
  • Adaptive e-Learning with trainer's support.
  • Access Class via PC, Mobile App or on a large screen.
  • Attend Live HD Training Sessions via Go To MeetingTM. Interact with trainer and peers like in a real classroom via voice, video conference and live chat.

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.

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

Course Curriculum

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

Drop us a query

Our alumni’s are hired by top brands

Hundreds of employers — have maximized their talent with us.

Ready to enroll for this Course? Book your slot now: