Power bI advanced training course

This course helps the business users to meet their work challenges by introducing them to the latest features such as the fuzzy matching, AI visuals and Row Level Security. This course is a complete walk-through the BI process from data modeling, data cleaning, data manipulation, data wrangling to data visualization using AI enhanced visuals and infographics.

Register Yourself

What is Included With The Microsoft Power BI Course

Small Class Size

Developed and Guided Learning Content

Certificate of Attendance

Highly Skilled Trainers

Our Price Beat Guarantee

Email Support

About This Course?

This course helps the business users to meet their work challenges by introducing them to the latest features such as the fuzzy matching, AI visuals and Row Level Security. This course is a complete walk-through the BI process from data modeling, data cleaning, data manipulation, data wrangling to data visualization using AI enhanced visuals and infographics. This course also introduces you to DAX and helps you build a sound foundation of DAX in Power BI based on your Excel/SQL knowledge.

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 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. 

Course Duration: 2 Days

Skill Level:  Advanced

Add-ons:

  • Small Class size
  • Developed and Guided learning content
  • Completion certificate
  • Taught by Industry Pros
  • Free re-sit
  • Email support
  • Printed Manual
  • Member card to participate in hackathon event

Training Cities:

  • Sydney, Melbourne, Brisbane, Canberra, Adelaide, Perth

Ticket Price:  

  • $990 Including Tax

Early Bird Discount

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.

Register now

Course Outline

  • Overview of BI Process
  • Overview of Different Power BI Products
  1. Power BI Desktop
  2. Power BI Service
  3. 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
  1. Characteristics of a Duplicate Query
  2. Characteristics of a Referenced Query
  • Viewing Query Dependency
  • Copying Queries across the Reports
  • Appending Queries
  • Merging Queries
  1. Left Outer
  2. Right Outer
  3. Full Outer
  4. Right Anti
  5. Left Anti
  • What is Fuzzy Matching?
  1. How is fuzzy Merge different from simple merge?
  • Getting started
  • Using Fuzzy Matching to Merge Queries
  • Changing Similarity Threshold
  • Working with Fuzzy Merge Options
  1. Similarity Threshold
  2. Ignore Case
  3. Match by combining Text Parts
  4. Maximum number of Matches
  5. Transformation Table
  • Creating and Using Transformation Tables
  1. What is a Transformation Table
  • What is Query Editor
  1. Power Query
  2. Power Pivot
  3. Power View
  • Getting Started
  • Creating Index Column
  1. From 0
  2. From 1
  3. Custom
  • Creating Date Column
  • Creating Conditional Column
  • Creating Information Column
  1. Even values
  2. Odd Values
  3. 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
  1. Column statistics
  2. 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?
  1. Fact tables
  2. Dimension Tables
  3. 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:
  1. Bubbles
  2. Category Labels
  3. Map Controls
  4. 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
  • Anthropology (ANTH)
  • Archaeology (ARCHY)
  • Biological Anthropology (BIO A)
  • 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
  1. DAX Query
  2. Visual Display
  3. 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?
  1. Static Row Level Security
  2. Dynamic Row Level Security
  3. Row Level Security using URL
  • Getting Started
  • Creating Roles
  • Writing Table Filter Expressions for a Single Field
  • Writing Table Filter Expressions for Multiple Fields
  1. OR Operator
  2. AND Operator
  • Viewing as Roles
  1. 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
  1. Filtering URL Using a Single Field
  2. Filtering URL Using Multiple Field
  • Dynamic URL Filtering
  • What is a Workspace App?
  1. Content Management
  2. Targeted Audience
  3. 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
  1. Data Warehouse is NOT a Data Model
  2. Flat File is NOT a Data Model
  • Tables in a Data Model
  1. Fact Table / Data Table
  2. Dimension Table / Lookup Table
  3. Fact Table vs. Dimension Table
  • Types of Schema
  1. Star Schema
  2. Snowflake Schema
  • Relationship Characteristics
  1. Cardinality
  2. Filter Direction
  3. Apply Security Filter in Both Directions
  4. Active
  5. 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?
  1. Difference between Excel and DAX
  2. Difference between M Language and DAX
  • The Concept of Calculated Column and Calculated Measures
  1. Calculated Columns
  2. Calculated Measures
  • What are two broad categories of functions in DAX
  1. Regular Functions
  2. Iterator Functions
  • What is Evaluation Context?
  1. Row Context
  2. Filter Context
  3. Initial or Incoming Filter Context
  4. 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
  1. Fixing the formula
  • Forcing the Filter Context using CALCULATED function
  • Pulling the data into the table using the RELATED() function
  • Creating Calculated Measures
  1. 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
  1. Editing Clusters
  • Clustering using Tables
  • Why is Conditional Formatting needed?
  • Getting Started
  • Conditional Formatting by Background Color
  1. 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
  1. Install Python
  2. Install Python Packages
  3. Add Python Folder Path
  4. Verify Installation in Power BI
  • Import Data
  • Data Manipulation using Python Scripts
  • Creating Visuals using Python
  1. Creating a Box Plot
  2. Creating Plot Visualization
  3. Create a Violin Plot
  4. Create a Joint Plot
  5. Creating a Heatmap

Power BI Advanced Training Schedule

Events Schedule:

Location: Level 11, 32 Walker Street, North Sydney , NSW 2060

Time: 9:00 Am to 5:00 PM

Training Dates: 

  • 6-7 February 2020
  • 19 -20 March 2020
  • 23 -24 April 2020
  • 4-5 June 2020
  • 25-26 June 2020
  • 20-21 July 2020

Register Now For Training in Sydney

Events Schedule :

Location: Level 12, 379 Collins Street, Melbourne , VIC 3000

Time: 09:00 AM to 5:00 PM

Training Dates: 

  • 13-14 February 2020
  • 12-13 March 2020
  • 20-21 April 2020
  • 21-22 May 2020
  • 18-19 June 2020
  • 16-17 July 2020

Register Now For Training in Melbourne

Event Schedule For Brisbane: 

Location: Level 6, 371 Queen Street, Brisbane , QLD 4000

Time: 09:00 AM to 05:00 PM

Training Dates: 

  • 20-21 February 2020
  • 26-27 March 2020
  •  07-08 May 2020
  • 15-16 June 2020

Register Now For  Training in Brisbane

Events Schedule in Adelaide :

Location: 19 Young Street, Adelaide , SA 5000

Time: 09:00AM to 5:00 PM

Training Dates: 

  • 14-15 May 2020
  •  9-10 July 2020

Register Now For Training in Adelaide

Events Schedule: 

Location: Level 4, 54 Marcus Clarke Street, Canberra , ACT 2601

Time: 09:00 AM to 5:00 PM

Training Dates: 

  • 2-3 April 2020
  • 25-26 May 2020
  •  02-03 July 2020

Register Now For Training in Canberra

Register For Sydney
Register For Melbourne
Register For Brisbane
Register For Adelaide
Register For Canberra
Call Us: 041071609

Why Power BI?

Business Intelligence Market

Worldwide Business Intelligence and Analytics market to grow to $22.8 billion in revenue in the next two years – Gartner

Jobs Opportunities

70 percent of the leading companies say that Analytics is integral to how they make decisions – IBM Survey

Career Growth

A Senior Business Intelligence Analyst can earn $89,000 in the United States – PayScale

Some of the companies that experienced Power BI Training With Our Trainers

1280px-Fujitsu-Logo.svg
schneider-electric-vector-logo
Department-of-Defence-Australian-Government
14cy-oil_search_reject
exxon-mobil-logo
C10000554
Previous
Next

Contact Us

Got Any Question? Fill this Form & one of our representative will get in touch with you.

Contact Info

  • 38 Lucas Cct, Kellyville NSW 2155, Australia
  • 0410171609
  • info@amzconsulting.com.au
Facebook Linkedin

Public Training

What We Offer

We believe in catching up with the technological demands of industry by providing solution packs in the form of training.  We Offer Power Bi Training Courses In Sydney, Melbourne, Brisbane, Adelaide, Canberra, Perth And In-House Across Australia.

Close Menu
×
×

Cart