Advanced Data Modelling and Shaping with Power BI Training

Nivå: Advanced

This 1-day course will cover, using Power BI Desktop to import and shape data from a variety of different sources. It will also walk through Power BI capabilities to enhance the data model for your business users. The course covers key aspects of creating a great data model to meet your business needs, various features in Power BI to enhance data model for you and your organisation to build great reports and introduction to DAX to create calculations.

After completing this training, the attendees should be able to learn how to import data, from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model.

NEW! POWER BI BUNDLES NOW AVAILABLE

This course is now available as part of a multi-course, blended learning premium training bundle for a limited time! Take your Power BI skills and career to the next level with multi-modal learning path bundles that lead to certification.

Explore Power BI Bundles

Nyckelfunktioner:

  • Microsoft official course content
  • Hands-on learning labs included

Du kommer lära dig att:

  • Understand the Power BI Desktop data model
  • The components of effective schemas
  • Gain an understanding of the Power Query M language
  • Import data from a variety of sources (including XLS and CSV files)
  • Create queries using toolbar navigations and Advanced Editor
  • Understand parameters
  • Organise queries using folders

Välj den utbildningsform som passar dig bäst

LIVE, LÄRARLEDD

I klass & Live, Online-utbildning

  • 1-day instructor-led training course
  • Microsoft official course content
  • Hands-on learning labs included
  • After-course instructor coaching included

UTBILDNING PÅ DIN ARBETSPLATS

Teamträning

  • Använd denna eller någon annan utbildning i ditt företag
  • Fullskalig programutveckling
  • Levereras när, var och hur du vill
  • Blandade utbildningsmodeller
  • Skrä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å www.learningtree.se/priser .

I klass & Live, Online-utbildning

Note: This course runs for 1 dag

  • 25 okt 9:00 - 16:30 CEST Stockholm / Online (AnyWare) Stockholm / Online (AnyWare) Boka Din Kursplats

  • 14 feb 9:00 - 16:30 CET Stockholm / Online (AnyWare) Stockholm / Online (AnyWare) Boka Din Kursplats

  • 27 jun 9:00 - 16:30 CEST Stockholm / Online (AnyWare) Stockholm / Online (AnyWare) Boka Din Kursplats

  • 13 okt 9:00 - 16:30 BST Online (AnyWare) Online (AnyWare) Boka Din Kursplats

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

  • 11 apr 9:00 - 16:30 BST Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 4 jul 9:00 - 16:30 BST Online (AnyWare) Online (AnyWare) Boka Din Kursplats

  • 13 okt 15:00 - 22:30 CCST Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

  • 10 nov 15:00 - 22:30 CCET New York / Online (AnyWare) New York / Online (AnyWare) Boka Din Kursplats

  • 6 dec 15:00 - 22:30 CCET Ottawa / Online (AnyWare) Ottawa / Online (AnyWare) Boka Din Kursplats

  • 10 jan 15:00 - 22:30 CCET Herndon, VA / Online (AnyWare) Herndon, VA / Online (AnyWare) Boka Din Kursplats

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

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

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

  • 18 maj 15:00 - 22:30 CCST New York / Online (AnyWare) New York / Online (AnyWare) Boka Din Kursplats

  • 15 jun 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.

Advanced Data Modelling and Shaping with Power BI Training Information

Advanced Data Modelling and Shaping with Power BI Training Outline

  • Module 1

    Data Modelling Basics – Getting the Data

  • Module 2

    Getting started with M (Power Query Language)& Relationship between tables

  • Module 3

    Fact Table, introduction to DAX Calculated Columns & Measures

  • Module 4

    Working With Parameters and introduction to DAX

  • Module 5

    Working with functions - DAX CALCULATE Function, custom functions & Time Intelligence Functions

  • Module 6

    Modelling with Power BI & DAX best practise Data Modelling, Optimisation techniques

  • Module 7

    Summary

    Wrap-up & Questions

Teamträning

Advanced Data Shaping with Power BI Training FAQs

  • Does this class prepare an attendee for a Microsoft Exam?

    No, this class is not an exam prep class.

Data Science
Bundled Training

Extend learning beyond a single event with bundled content designed for real-world application.

Har du frågor om vilken utbildning som är rätt för dig?

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

100 % nöjd. Eller få pengarna tillbaks!*

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

Stockholm / Online (AnyWare)
Stockholm / Online (AnyWare)
Stockholm / Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / Online (AnyWare)
Ottawa / Online (AnyWare)
Herndon, VA / Online (AnyWare)
New York / 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