Designing Data Models in Excel for Power BI Reports Training

Nivå: Intermediate
Snittbetyg: 4,8/5 4,75/5 Based on 65 Reviews

This course focuses on designing BI Data Models to display in either an interactive Power BI report or in an interactive Excel dashboard. This advanced Microsoft Excel/fundamental Power BI course will take you through a data journey from importing, cleansing and merging large amounts of data to analysing the data to presenting strategic data in a Power BI dashboard. This is a practical course designed to provide flexibility and to empower you to choose how you want to present your business insights to help management make informed decisions.


  • After-course instructor coaching benefit
  • Learning Tree end-of-course exam included
  • After-course computing sandbox included

Du kommer lära dig att:

  • Transform and present sophisticated data to provide Business Intelligence (BI)
  • Actualise a data model from multiple sources
  • Shape and filter tables to prepare for analyses by fixing common issues
  • Mine and expose hidden information with Data Analysis eXpressions
  • Communicate business and data insights with Power BI reports and dashboards

Välj den utbildningsform som passar dig bäst


I klass & Live, Online-utbildning

  • 2-day instructor-led training course
  • Earn 11 NASBA credits (live, in-class training only)
  • One-on-one after-course instructor coaching
  • After-course computing sandbox
  • Tuition fee can be paid later by invoice -OR- at the time of checkout by credit card



  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodellerSkräddarsytt innehåll
  • Coaching av ett expertteam

Anpassa kurs och innehåll efter teamets behov

Kontakta oss

Utveckla dig och ditt team med anpassade eller öppna kurser alternativt e-learning

Learning Tree erbjuder kundanpassad utbildning hos er, öppna kurser i Stockholm, London eller Washington, möjlighet att delta via våra Anywhere centers (Malmö, Göteborg, Linköping, Stockholm eller Borlänge) eller olika former av e-learning med lärarstöd. Läs mer på .

I klass & Live, Online-utbildning

Note: This course runs for 2 dagar

  • 1 - 2 dec 9:00 - 16:30 GMT Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 9 - 10 mar 9:00 - 16:30 GMT Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 8 - 9 jun 9:00 - 16:30 BST Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 7 - 8 sep 9:00 - 16:30 BST Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 7 - 8 feb 15:00 - 22:30 CCET Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 25 - 26 apr 15:00 - 22:30 CCST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 8 - 9 aug 15:00 - 22:30 CCST Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

Kurs med startgaranti

När du ser symbolen för “Guaranteed to Run” vid ett kurstillfälle vet du att kursen blir av. Garanterat.

Important Power Pivot Course Information

Power Pivot Course Outline

  • Identifying the Role of Power Pivot in Business Intelligence (BI)

    Introducing the Business Intelligence Tools

    • Exploring the Microsoft Business Intelligence tools
    • Defining the requirements for a collaborative solution
    • Identifying the steps to create a Power BI dashboard

    Familiarisation with Power Pivot

    • Navigating the Power Pivot interface
    • Extracting information from data with Power Pivot
    • Uncovering data interpretation issues
    • Creating a dashboard
  • Building the Data Model with Power Pivot

    Defining a consolidated view of data

    • Generating a data mashup from structured and unstructured data sources into a data model
    • Deriving relationships from data sources with the Relationships tool and the Diagram View

    Denormalising data to simplify usage within other BI reporting tools

    • Acquiring data from related tables
    • Defining calculated columns
    • Consolidating information available to BI tools

    Querying SQL Server data

    • Designing queries to import data from SQL Server
    • Relating tables with outer joins

    Fixing common data issues with Power Query

    • Extracting, Transforming and Loading (ETL) data
    • Converting data formats with Power Query steps
    • Parsing columns to aid analysis
    • Removing duplicates from a data set
    • Constructing a single data set from multiple sources with the same field headings
  • Manipulating and Analysing Data with the Data Analysis eXpressions (DAX) Language

    Defining measures for business performance

    • Distinguishing the role of measures
    • Translating key business concepts into measures
    • Providing context for measures within a PivotTable
    • Determining between implicit and explicit measures

    Implementing DAX functions in Power Pivot

    • Expressing information with measures
    • Exposing hidden information from data
    • Troubleshooting and debugging DAX calculations

    Exploiting data analytics with aggregation

    • Quantifying and mining information with DAX functions
    • Summarising and aggregating data from other tables with the X functions
    • Evaluating expressions with the CALCULATE() function and filter functions
    • Substituting values with the SWITCH() function

    Mining for information with date and time analysis

    • Grouping dates for time analysis
    • Comparing and categorising time periods with Time Intelligence functions

    Setting key business targets with KPIs

    • Analysing performance with measures
    • Gauging performance against goals
  • Designing effective Power BI dashboards

    Familiarisation with the Power BI Architecture

    • Deciding on where to develop a dashboard
    • Importing an Excel data model into Power BI Desktop
    • Developing a data model in the Power BI Desktop
    • Crafting visualisations from the analytics

    Building a Power BI dashboard

    • Constructing Power BI Reports
    • Planning a Power BI Dashboard
    • Assembling a Power BI Dashboard


Power Pivot Training FAQs

  • Why are you using Excel to develop your data models?

    Most participants attending a Power BI have worked in Excel. The Excel BI tools are the same as those found in Power BI. Thus, this course enables participants to expand their Excel knowledge and develop analytics that can be used in both Excel or Power BI.
  • How much time will we spend on developing Reports?

    About 2 hours. This course will provide a fundamental understanding on how to develop visualisations in Power BI. For those who are Power Excel users, this will be like producing charts.
  • What version of Excel is this course applicable to?

    The current version (2010) is used in this course.

Questions about which training is right for you?

call 08-506 668 00

Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

100% Satisfaction Guaranteed

Your Training Comes with a 100% Satisfaction Guarantee!*

*Partner-delivered courses may have different terms that apply. Ask for details.

Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
Ottawa / Online (AnyWare)
Why do we require your location?

It allows us to direct your request to the appropriate Customer Care team.

Hur föredrar du att bli kontaktad:

Please Choose a Language

Canada - English

Canada - Français