Web Age Solutions Inc
Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887
Course #:TP2969

Data Modelling and Analysis with Power BI and Analysis Services Training

After completing this course, students will be able to:

  • Describe self-service BI.
  • Describe the Power BI suite of products.
  • Connect to data sources and optimize data models.
  • Shape and combine data from different sources.
  • Model data.
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Create reports and dashboards

Audience

The audience of this Power BI Training course includes power business users, BI professionals, and database professionals who are interested in modeling data and designing reports/dashboards. Power business users can utilize self-service (DIY) BI features of Power BI to create their data models. BI professionals and database professionals can create reusable data models for their organization so other users can connect to the model to create reports and dashboards.

Duration

Five Days

Outline of Data Modelling and Analysis with Power BI and Analysis Services Training

Module 1 - Introduction to Self-Service BI Solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI
  • Lab : Exploring an Enterprise BI solution
  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

Module 2 - Introducing Power BI

  • Power BI
  • The Power BI service
  • Lab : Creating a Power BI dashboard
  • Connecting to Power BI data
  • Create a Power BI dashboard

Module 3 - Power BI

  • Using Excel as a data source for Power BI -
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service
  • Lab : Importing data into Power BI
  • Importing Excel files into Power BI
  • Viewing reports from Excel files

Module 4 - Shaping and Combining Data -

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Lab : Shaping and combining data
  • Shape power BI data
  • Combine Power BI data

Module 5 - Modeling data

  • Relationships
  • DAX queries
  • Calculations and measures
  • Lab : Modeling Data
  • Create relationships
  • Calculations

Module 6 - Interactive Data Visualizations -

  • Creating Power BI reports
  • Managing a Power BI solution
  • Lab : Creating a Power BI report
  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

Module 7: Introduction to Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
  • Lab : Creating Calculated Columns and Measures by using DAX
  • Creating Calculated Columns
  • Creating Measures
  • Creating a KPI
  • Creating a Parent – Child Hierarchy

Module 8 - Direct Connectivity -

  • Cloud data
  • Connecting to analysis services
  • Lab : Direct Connectivity
  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

Module 9: Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Data Sources and Data Source Views
  • Cubes
  • Overview of Cube Security
  • Configure SSAS
  • Monitoring SSAS
  • Lab : Creating a multidimensional database
  • Creating a Data Source
  • Creating and Configuring a data Source View
  • Creating and Configuring a Cube
  • Adding a Dimension to a Cube

Module 10: Introduction to MDX

  • MDX fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube
  • Lab : Using MDX
  • Querying a cube using MDX
  • Adding a Calculated Member

Module 11: Implementing a Tabular Data Model by Using Analysis Services

  • Introduction to Tabular Data Models
  • Exploring SSDT
  • Creating a Tabular Data Model with SSDT
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution
  • Lab : Working with an Analysis Services Tabular Data Model
  • Creating an Analysis Services Tabular Data Model
  • Configure Relationships and Attributes
  • Configuring Data Model for an Enterprise BI Solution.



We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887