email us
 training@pcworkshopsLondon .co.uk
contact us
 020-7164-6359

Power BI Advanced Course, 2 Days

Course Details - Outline - Book the course
Power BI Course, 2 Days
Course details

Power BI Course, 2 Days

Power BI Course Course Summary.


This excellent Power BI covers the Query Editor and Dax Calculations in detail
Online Instructor-led, 10am - 5pm
Classroom sessions available on request
Practical, Hands-on, Interactive

Where is the Power BI Course?

Online: Gotomeeting.com
Classroom: Personal is best! Request per email

Included with the Power BI Course
  • Course Exercises
  • Code examples
  • Course Notes
  • PCWorkshoips Power BI Certificate
  • Personalised attention: max 4 people in the class
Financials
  • Power BI Course Price: £580, Follow the booking link to make an online payment
  • Email us to arrange installments or BACS paymenta
Power BI Course Topics


    The Power BI Query Editor
  • Overview and Introduction to The Query Editor
  • Perform Data Transformations
  • Introduction to Transformations
  • Data Transformations
  • Conditional IF


    • Advanced Transformations
  • Introduction to Advanced Transformations
  • Merge Function
  • Append Data
  • Custom Calculations
  • Group By Function


    • Cleanse Data and Parameters
  • Introduction to Cleanse Data
  • Download the Training Data Files
  • Query Editor Diagnostics
  • Cleansing Data Files
  • Parameters


    • Connect to Power BI Connections and Data Sources
  • Introduction to Power BI Data Connections and Sources
  • Loading Data from SQL Server
  • Loading Data from CSV and TXT
  • Practical Activity - Load Data from a CSV file
  • Loading Data from the Web
  • Practical Activity - Connect to Data on the Web
  • Loading Excel Data from One Drive for Business
  • Loading Data from XML files
  • Loading Data from JSON
  • Loading Data from the Power BI Service


    • Build a Relational Data Model
  • Intro to Database Normalization
  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables
  • Creating Power BI Table Relationships
  • "Star" vs. "Snowflake" Schemas
  • Active vs. Inactive Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filtering & Cross-Filtering
  • Hiding Fields from the Power BI Report View
  • Data Modeling & Power BI best Practices


    • Add Calculated Fields with DAX
  • Introduction
  • Meet Data Analysis Expressions (DAX)
  • Intro to DAX Calculated Columns
  • Intro to DAX Measures
  • Adding Columns & DAX Measures in Power BI Desktop
  • Implicit vs. Explicit DAX Measures
  • Filter Context Examples in Power BI
  • Step-by-Step DAX Measure Calculation
  • Understanding DAX Syntax & Operators
  • Common DAX Function Categories
  • Basic Date & Time Functions
  • Conditional & Logical Functions (IF/AND/OR)
  • Common Text Functions
  • Joining Data with RELATED
  • Basic Math & Stats Functions
  • COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)
  • CALCULATE
  • CALCULATE & ALL
  • CALCULATE & FILTER
  • Iterator Functions (SUMX, RANKX)
  • Time Intelligence Formulas
  • DAX Best Practices in Power BI Desktop

Book the Power BI Course


Online, Instructor-led:



In classroom:



About us
Learn Power BI
What is Power BI? Power BI is a Microsoft product that works together to turn your data sources into coherent, visually immersive, interactive business intelligence.
Is Power BI Worth Learning? Power BI has evolved to an excellent product, proud of a number of outstanding features making it a very competitive and popular data visualisation tool. Anyone who wishes to learn a marketable skill, would find studying Power BI is an excellent choice.
What's good about Power BI? Microsoft has a proven track record in the field of technology, and is a reliable software provider.
What's good about Power BI? Power BI is as easy as impressive drag-and-drop features to create spectacular data visualisations. It can be used on both on-premise and on-cloud platforms.
Power BI Course uk
Power BI Course uk

Request a Free Power BI Demo

Try a 30 minutes training session free. Choose you own topic from our course list.

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.
About Us
  • About PCWorkshops
    •
  • Awards
    •
  • Locations
    •
  • Terms and Conditions
    •
  • Contact Us
    •
  • Client Comments
    •
    Quick Links
  • Software development jobs
    •
  • Python Courses
    •
  • Power BI Courses
    •
  • SQL Courses
    •
  • Database Courses
    •
  • MS Project Courses
    •
    Contact Us
  • Call: 020-7164-6359
  • Email: training@pcworkshopsLondon .co.uk
    • Connect with Us

    Copyright © PCWorkshops 2019. All Rights Reserved.