Power BI Online Training

This course offers a complete, in-depth introduction to Microsoft Power BI tool by providing hands-on experience using Excel spreadsheets. During this course, users will be introduced to Power BI products and features essential to develop a BI solution.

Explore Upcoming Training

About Power BI Advanced Training

Mastering Power BI training session consist of two interactive sessions in which users are introduced to the latest developments in Microsoft Power BI. These extensive sessions cover all the concepts needed to create compelling reports from Power Query to Data Modeling, AI-Based visualizations and Infographics. Some useful features such as Fuzzy Matching and clustering have been discussed in detail with real-time usage. This course also develops a sound knowledge of DAX functions, Data Modeling and Advanced Analytics. It is suitable for users who want to learn how to implement Business Intelligence solutions using the top-notch modeling and visualization techniques.

Power BI Training Key Features

✅ 2 Days of enriched learning

✅ Course completion certificate

✅ Lifetime access to self-paced learning

Skills Covered

✅ Desktop layout

✅ Builtin aggregations

✅ Reports and dashboards

✅ DAX commands and functions

Benefits

The global business intelligence (BI) market is expected to grow at a compound annual growth rate (CAGR) of 12% by 2024. Also, Gartner predicts the business intelligence market alone to go from $18.3 billion in 2017 to $22.8 billion by 2021.

Prerequisite :

This course is the suitable for users who are familiar to Power BI tool. The users are expected to have completed the Power BI Basics course or have equivalent skills. An experience in Excel with Basic VLOOKUP and Pivot table is a plus.

Who should take This Training Course?

This course is suitable for users who want to learn how to implement Business Intelligence solutions using the top-notch modeling and visualization techniques. This course is also a perfect choice for users who have developed SQL reports and are looking for ways to develop visually appealing and best performing dashboards.

 ✅ Our representative will get back to you with the updates on the upcoming sessions. 

 

Power BI Basic Advanced

50 % off as Corona Relief

$999
$450

2 Day Course (Online tRAINING)

  • Skill Level: Advanced
  • Developed and Guided learning content
  • Latest Features
  • Completion certificate
  • Sound Foundation of Data Modeling & DAX
  • Free re-sit
  • Email support
  • Member card for hackathon events
Register Now

Contact Us

0410171609

Register Yourself

[contact-form-7 id="3526" title="Power BI Advanced Online"]

Requirements

Requirements:

  • Microsoft Power BI Desktop installed.
  • A valid zoom ID to support interactive session.
  • Familiarization with basic excel functions.
  • Completed the Power BI Basic training and/or has equivalent knowledge.

Add-ons:

  • Fully Interactive Session.
  • Hands on training.
  • Instructor-led Training.
  • Microsoft Certified Trainers.

Course Outline

  • Overview of BI Process
  • Overview of Different Power BI Products
    • Power BI Desktop
    • Power BI Service
    • Power BI Mobile Apps
  • Latest Features and Top Enhancements in Power BI
  • Why is Data Transformation Important?Data Transformation Principle
  • Getting Started
  • Transforming Pivot Tables
  • Using Basic “Group by” Functionality
  • Using Advanced Group by Functionality
  • Choosing Columns
  • Duplicating a Query
  • Referencing a Query
  • Difference between Duplicating and Referencing a Query
    • Characteristics of a Duplicate Query
    • Characteristics of a Referenced Query
  • Viewing Query Dependency
  • Copying Queries across the Reports
  • Appending Queries
  • Merging Queries
    • Left Outer
    • Right Outer
    • Full Outer
    • Right Anti
    • Left Anti
  • What is Fuzzy Matching?
    • How is fuzzy Merge different from simple merge?
  • Getting started
  • Using Fuzzy Matching to Merge Queries
  • Changing Similarity Threshold
  • Working with Fuzzy Merge Options
    • Similarity Threshold
    • Ignore Case
    • Match by combining Text Parts
    • Maximum number of Matches
    • Transformation Table
  • Creating and Using Transformation Tables
    • What is a Transformation Table
  • What is Query Editor
    • Power Query
    • Power Pivot
    • Power View
  • Getting Started
  • Creating Index Column
    • From 0
    • From 1
    • Custom
  • Creating Date Column
  • Creating Conditional Column
  • Creating Information Column
    • Even values
    • Odd Values
    • Signs
  • Creating Custom Column
  • Creating Standard Column
  • Creating Statistical Column
  • Creating Scientific Column
  • Creating Column by Example
  • Extracting Column
  • Formatting Column
  • Why is Data Profiling?
  • Getting Started
  • Visualizing Column Profile
    • Column statistics
    • Column distribution
  • Visualizing Column Quality
  • Visualizing Column Distributions
  • Displaying Preview Using Monospace
  • Displaying Preview Using White Space
  • How is Flat File Different from Data Model?
    • Fact tables
    • Dimension Tables
    • Key
  • Getting Started
  • Duplicating Queries
  • Removing Columns
  • Removing Duplicates
  • Build Relationships
  • What is Data Visualization?
  • Getting Started
  • Setting the Color Theme
  • Creating and Using Unichar characters
  • Synchronizing slicers across the report
  • Using Selection Pane
  • Using Bookmark Pane
  • Using Conditional Formatting based on Slicer Selection
  • Drilling through Pages in the Report
  • Drilling across Reports
  • What are Map Visualizations?
  • Getting Started
  • Data Transformation needed for accurate mapping
  • Setting appropriate Data Types for Spatial Data
  • Creating Bubble Map Visuals using Bing Maps
  • Formatting Options available with Bing Maps:
    • Bubbles
    • Category Labels
    • Map Controls
    • Map Styles
  • Creating Filled Maps
  • Creating Map Visual by using ArcGIS by ESRI
  • Using Mapbox visual to create Map visualizations
  • Creating Choropleth Maps using Mapbox visual
  • Creating Heat Maps using Mapbox visual
  • Creating a Globe Map
  • Why are Info graphics?
  • Getting Started
  • Creating Ultimate Decomposition Tree
  • Creating Bubble Chart
  • Visualizing Changing Rankings
  • Using Infographics Designer
  • What is Performance Analyzer?
  • Getting Started
  • Start Recording
  • Understanding the Results
    • DAX Query
    • Visual Display
    • Others
  • Drill Down into the Visual
  • Renaming Visuals using Selection Pane
  • Analyze Results to Refresh Visuals
  • Analyze Results to Refresh a Particular Query
  • Analyzing the Performance on Switching between Pages
  • What is Row Level Security?
    • Static Row Level Security
    • Dynamic Row Level Security
    • Row Level Security using URL
  • Getting Started
  • Creating Roles
  • Writing Table Filter Expressions for a Single Field
  • Writing Table Filter Expressions for Multiple Fields
    • OR Operator
    • AND Operator
  • Viewing as Roles
    • Viewing Multiple Roles
  • Creating Dynamic Row Level Security
  • Creating Dynamic Row Level Security based on Reporting Lines
  • Assigning Members to Roles
  • Testing Scenarios in Power BI service
  • URL Filtering
    • Filtering URL Using a Single Field
    • Filtering URL Using Multiple Field
  • Dynamic URL Filtering
  • What is a Workspace App?
    • Content Management
    • Targeted Audience
    • Different Levels of Access for the same Content
  • Creating a App Workspace
  • Assigning Permissions in an App Workspace
  • Collaborating on Shared Reports
  • Sharing Reports Using App
  • What is Data Model in Microsoft Power BI?
  • What is not a Data Model
    • Data Warehouse is NOT a Data Model
    • Flat File is NOT a Data Model
  • Tables in a Data Model
    • Fact Table / Data Table
    • Dimension Table / Lookup Table
    • Fact Table vs. Dimension Table
  • Types of Schema
    • Star Schema
    • Snowflake Schema
  • Relationship Characteristics
    • Cardinality
    • Filter Direction
    • Apply Security Filter in Both Directions
    • Active
    • Assume Referential Integrity
  • Good Data modelling practices and some useful functions
  • Filter Propagation in Action
  • Interpreting the Mechanism for Filtering in Power BI
  • Using Multiple Filters Together
  • Summarization Using Relationships
  • Using Bi-Directional Cross Filtering
  • Getting Started
  • Importing Data
  • Data Preparation
  • Creating Date Table
  • Setting Model Design
  • Creating Surrogate Key
  • Merging Queries
  • Creating Calculated Columns
  • Flattening the Product Table
  • Creating Product Hierarchy
  • Active vs. Inactive Relationship
  • Working with Role Playing Dimensions
  • Adding Higher Levels of Details
  • Cater for Misleading Interpretations
  • Creating Bridge Table
  • Circular References
  • What is DAX?
    • Difference between Excel and DAX
    • Difference between M Language and DAX
  • The Concept of Calculated Column and Calculated Measures
    • Calculated Columns
    • Calculated Measures
  • What are two broad categories of functions in DAX
    • Regular Functions
    • Iterator Functions
  • What is Evaluation Context?
    • Row Context
    • Filter Context
    • Initial or Incoming Filter Context
    • Filter Context vs. Row Context
  • The Rules for Evaluation
  • Advice When Creating DAX
  • Functions from Excel
  • A Little Bit of Everything
  • Calculated Columns and Calculated Measures
  • Getting Started
  • Creating Calculated Column
  • Using the RELATEDTABLE() function
    • Fixing the formula
  • Forcing the Filter Context using CALCULATED function
  • Pulling the data into the table using the RELATED() function
  • Creating Calculated Measures
    • Deleting Calculated Columns
  • Using Iterative Functions
  • Over riding the Initial Filter Context
  • Working with Time Intelligence
  • Creating Quick Measure
  • What are AI Visuals?
  • Getting Started
  • Using Key Influencer Visual
  • Using Q&A to Explore Data
  • Using Power BI’s Recommendation Engine for Questions
  • Creating Visuals with Q&A
  • Creating Featured Questions with Q&A
  • Clustering using Scatter Charts
    • Editing Clusters
  • Clustering using Tables
  • Why is Conditional Formatting needed?
  • Getting Started
  • Conditional Formatting by Background Color
    • Removing Background Color Formatting
  • Conditional Formatting by Font Color
  • Conditional Formatting Using Data Bars
  • Conditional Formatting Using Icon
  • Conditional Formatting by Rule
  • Conditional Formatting by Another Column/Measure
  • Dynamic Chart Tiles
  • Switch DAX Function
  • Introduction to Parameters and Functions
  • Getting Started
  • Creating New Parameter
  • Importing Web Query Using Parameter
  • Creating & Invoking Functions
  • Defining a List
  • Converting List to Table
  • Add Column by Invoking Functions
  • Getting Started with Python Scripting
    • Install Python
    • Install Python Packages
    • Add Python Folder Path
    • Verify Installation in Power BI
  • Import Data
  • Data Manipulation using Python Scripts
  • Creating Visuals using Python
    • Creating a Box Plot
    • Creating Plot Visualization
    • Create a Violin Plot
    • Create a Joint Plot
    • Creating a Heatmap

Frequently Asked Question

Our training courses are suitable for users who have a good Excel/SQL background and feel comfortable with using EXCEL functions such as VLOOKUP. We provide provide basic and advanced level courses to develop skills in Power BI tool. 

Our Power BI basic training course is suitable for users having experience in EXCEL concepts such as VLOOKUP and Pivot table. No prior Power BI knowledge is required. However, for the advanced training course, one must have completed the basic course and/or has basic level skills in Power BI. 

Australia’s job market is skill driven in general. Our training courses are conducted by industry Pros using business data for training.  This is a perfect opportunity for anyone who wants to get a real insight of how businesses function.

It is a BI tool developed my Microsoft. It is tailored to meet the requirements of self-service BI solution.  

Power BI now has more than 5 million subscribers, who are using the service to take in business data and create dashboards they can use to better understand their businesses.

While this varies from session to session, we typically have 5 – 7 students in our classes. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.

Yes, Book and pay 1 month in advance to save 10%.Register and pay for 3 or more people at the same time to receive 25%+ disc.

Trainer’s Information:

Ali Asghar Noorani is Business Intelligence Consultant and Director at AMZ Consulting Pty Ltd, a company founded to help business users understand what their business data is telling them and use the Power of Data. He is Microsoft Certified Solutions Associate (MCSA) and Microsoft Certified Trainer (MCT) with years of Industrial and Training Experience in Australia, UAE and Pakistan. He is the author of 2 courses on Power BI for business users comprising of 600+ pages and 100+ exercise files.

Ali possesses years of practical experience in querying, transforming, modeling, enriching & visualizing data, using latest technologies and languages such as T-SQL (Transact-SQL), VBA Macros, Power BI, Power Query, Power Pivot and DAX and then producing fabulous reports & dashboards to deliver actionable insights to businesses. 

Call Us Now