Work through our specifically designed Power BI Advanced training course to build and understand:

laptop

Data Analysis Expressions (Power BI DAX training)

browser-4

Data Sources (API – Gateway -Databases)

analytics-4

Calculated Columns and Measures

analytics-2

Date Dimension & Row Level Security

 


SydneyMelbourneBrisbanePerthAdelaideParramatta

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Thu 07-Jun-18 Power BI Advanced Sydney Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Wed 16-May-18 Power BI Advanced Melbourne Course confirmed to run. Trainer has been allocated.
Mon 28-May-18 Power BI Advanced Melbourne Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Fri 01-Jun-18 Power BI Advanced Brisbane Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Tue 19-Jun-18 Power BI Advanced Perth Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Thu 21-Jun-18 Power BI Advanced Adelaide Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $605dollar-bill
Duration: One Day
clockTime: 9am – 4pm (approx)
Class Size: 10 students (max)
teamReference manuals provided
Training computer provided

Course Outline
PDFPower BI Advanced

Upcoming Dates
Wed 06-Jun-18 Power BI Advanced Parramatta Course confirmed to run. Trainer has been allocated.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

Are you looking to understand the advantages of Power BI Pro?
student

Learn how to use the powerful modelling and data sourcing capabilities to become a Power BI power user in our one-day course. In this course we focus heavily on the complex theory of DAX and how to work with different Data sources. Take your Business Intelligence analysis to the next level with our Power BI Advanced course.

What do I need to know to attend?

This is an advanced course designed for people with previous knowledge or who have attended our Power BI Intermediate course. This course focusses heavily on DAX and Data Modelling.

tasks

Learning Outcomes -Power BI Advanced

On completion of this course you should be able to:

  • The Business Intelligence Process
  • Data Modelling for Business Intelligence
  • Foundation of Data Analysis Expression (DAX)
  • Import from a variety of Data Sources
  • Understand DAX Relationships
  • Work with Calculated Columns
  • Work with Time Intelligence Function
  • Understandable variables in DAX
Course Details
  • circular-clockCourses will run from 9am – 4pm (approx.)
  • network-1Classes limited to approx 10 people
  • Power BI Advanced costs $605
  • book-2Reference Manuals provided
  • maps-and-flags-1Central city locations
Each Student receives
  • book-1Reference Workbooks
  • e-Certificate of attendance
  • customer-service-2Complimentary post course training e-support
  • dart-boardTrained by a Microsoft Certified Expert
  • likeSatisfaction guarantee or repeat FREE within 6mths
Course Content

power-bi-icon_75The BI Process

  • Overview
  • Power Query
  • Data Model
  • Visualisation
  • Sharing


power-bi-icon_75Data Modelling

  • Star and Snow Flake Schema
  • Modelling for Business Intelligence
  • Fact and Dimension table objectives
  • Data Model efficiency & design objectives

power-bi-icon_75Intro to Data Analysis eXpression (DAX) 

  • Introduction to writing DAX
  • Tools to assist with DAX
  • Official References (Function, Specification)
  • Power BI Community
  • Other resources
  • Do’s and Don’t of DAX
  • The Rules to evaluation

power-bi-icon_75DAX – Contents

  • Filter context
  • Row context
  • The CALCULATE function
  • The FILTER function
  • Measures table

power-bi-icon_75DAX – Relationships

  • Measure using data relationship
  • Measure working against relationship direction
  • Modifying relationships to make measures work
  • Introducing CROSSFILTER to specify the relationship direction
  • Observing results and totals

power-bi-icon_75DAX – Modify Filter Context

  • Use CALCULATE on existing filtered column
  • Use FILTER on existing filtered
  • Observe the different behaviour
  • Use ALL and FILTER to achieve same as first measure
  • Perform same exercise on column from a slicer

power-bi-icon_75DAX – Context in Calculated Columns

  • Create calculated column to count fact table rows
  • Observe how filter context applies to calculated columns
  • Use CALCULATE to transform row context
  • Use RELATEDTABLE to change context
  • Create invalid calculated column to count in a related dimension table
  • Add an aggregator to make calculated help debug
  • Use LOOKUPVALUE to find match
  • Use RELATED to find match
  • Use table functions to find match
  • Recommended method for these scenarios

power-bi-icon_75DAX – Time Intelligence

  • Create a YTD measure using time intelligence function
  • Create YTD measure with alternate FYE
  • Observe 3rd /4th argument of TOTALYTD
  • Create measures using PREVIOUSxxx and SAMEPERIODLASTYEAR functions
  • Observe outputs in visuals, drill up on dates
  • Remove unwanted totals from output
  • Create own YTD function without time intelligence function

power-bi-icon_75DAX – Multiple Date Columns

  • Overview of how to handle multiple date columns in fact table
  • Import additional date data into existing dataset
  • Establish new relationships
  • Create measures on inactive relationships using USERELATIONSHIP
  • Create time intelligence measures using the same inactive relationships

power-bi-icon_75DAX – Row Context

  • Create a calculated column
  • Use aggregator in calculated column
  • Use CALCULATE to transform row context
  • Modify the filter context in CALCULATE
  • Use FILTER to modify the filter context
  • Use EARLIER to get value of previous row context
  • Similar ways to use EARLIER

power-bi-icon_75DAX – Variables

  • Overview of variables in DAX
  • Use variable to help with nested row contexts
  • Create measure with repetitive expression
  • Use variable to evaluate expression once
  • Create measure with hard coded value
  • Adjust measure to use calculated average
  • Use variables to improve measure
  • Fix where variables are used to obtain correct result

power-bi-icon_75DAX – Unrelated Table

  • Overview of using unrelated tables
  • Create separate table using basic DAX expression or DATATABLE function
  • Create measure using TREATAS to filter from unrelated table

power-bi-icon_75Data Sources – Databases

  • Overview of Import and Direct Query
  • Data Refresh in Power BI
  • Dataset credentials in Power BI Service
  • Import SQL Server Data
  • Observe data refresh in Import mode
  • Setup data refresh schedule
  • Direct Query SQL Server data
  • Observe data refresh in Direct Query mode
  • Review Direct Query refresh options
  • Combine other data sources with Direct Query
  • Change from Direct Query to Import
  • Observations of Direct Query limitations (transform /model)

power-bi-icon_75Data Sources – App/ API

  • Overview of Web and API data sources
  • Query an API data source
  • Transform a JSON response
  • Publish to Power BI Service and setup refresh schedule
  • Query frequently updating website data

power-bi-icon_75Data Sources – Data Gateway

  • Overview of Data Gateway
  • Data Gateway modes
  • Observe Data Gateway on PC and connected to Power BI Service
  • Query web data
  • Transform data from web
  • Add refresh timestamp to report
  • Publish to Power BI Service and refresh
  • Setup dataset credentials
  • Observe frequent data updates

power-bi-icon_75Data Sources – Streaming

  • Overview of real time streaming data sources
  • Query data from PubNub stream
  • Configure Dashboard tile to show streaming data from PubNub
  • Create a REST API to push data into Power BI
  • Create JSON object to insert data via this API
  • Push data to create API using web based HTTP Post
  • Create Dashboard tile to show updating data

power-bi-icon_75Data Sources – Folder

  • Query a folder containing multiple source files
  • Specify a template file to define columns
  • View created queries / functions and dependencies
  • Understand the created process of querying the folder

power-bi-icon_75Date Dimension Table

  • Overview of Date Dimension in BI
  • Power BI Desktop settings
  • Mark as Date table

power-bi-icon_75Row Level Security

  • Overview of RLS in Power BI
  • Create dynamic RLS using USERNAME
  • Publish and assign roles in Power BI Service
  • Publish and assign roles in Power BI Service
  • Allow super users to access all data
  • Allow data access according to organisation hierarchy

power-bi-icon_75Additional Study – Power Query M Formula Language

  • Overview of Power Query M Formula Language
  • Foundations of the language of M

student_sat
Average rating:  
 5407 reviews

very good trainer - Excel Intermediate Parramatta

Page 1 of 5407:
«
 
 
1
2
3
 
»
 
Download Course Content Here