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

Category

Power BI

Rating
4.4
(4.4)
Price

$1150

Course Description

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

This training is designed based on the objectives of the course variant 55163A.

Objectives
  • 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?

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

Course Details
  • Start Date: Apr 29, 2021
  • Duration: 2 Days
  • More Schedules: Click
  • Certification: NO
  • Enrolled: 1212
Get In Touch
Are you being sponsored by your employer to take this class?
* I authorize Microtek Learning to contact me via Phone/Email