Got a question? Call  +640800835835    |   
Contact usCheckoutContact us
Microsoft Power BI - Intermediate
Main menu
Got a question? Contact us
or call  +64 0800 835 835
Data and Analytics - Category Banner

Microsoft Power BI - Intermediate

  • Length 1 day
  • Price  NZD 685 exc GST
Course overview
View dates &
book now

Why study this course

Power BI is Microsoft's powerful data visualisation tool that is commonly used for business analytics. With the ability to connect to data, clean and transform it, and create interactive dashboards, users can gain valuable insights to support informed decision-making. In our courses, you will gain hands-on experience using both Power BI Desktop and the Power BI service to create compelling visualisations. Learning Power BI has never been easier, and our courses will provide you with the skills you need to leverage this powerful tool effectively.

Learn how to enrich data models to produce powerful interactive dashboards with this one-day course. You will work on data transformations, measures, DAX, using Power Query and creating Advanced Visualisations. Our Microsoft-certified trainers make it easy to learn how to manipulate data in Power BI.

Request Course Information

What you’ll learn

At the completion of this course you should be able to:

  • Work with data from many sources

  • Build calculations in the data model to produce intelligent, interactive dashboards in one of the premier BI tools on the market

  • Collaborate with colleagues and publish to the web

Microsoft Solutions Partner - Cloud - Training Services Logo

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level.  We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ. 

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This intermediate course is designed for individuals who want to explore data analytics and data models necessary for data transformation.

Course subjects

Data Model & Transformation

  • Data transformation principles

  • Fact and dimension tables

  • The data model

  • Star schema

  • Snowflake schema

  • Optimising the data model

Get Data

  • Data sources

  • The dataset from Excel

  • From Folder

  • Power Query Editor

  • Power Query user interface

  • Queries pane

  • Data pane

  • Ribbon

  • Query Settings

Data Transformations

  • Data Model in Desktop

  • Filter data

  • Rename queries

  • Remove columns

  • Unpivot columns

  • Conditional columns

  • Fill values

  • Reorder columns

  • Combine queries

  • Append

  • Merge

  • Replace values

  • Custom columns

  • Evaluate and change column data types

Date Transformations

  • Auto Date/Time

  • Create a date dimension table

  • Dynamic date dimension tables

  • Extract date components as columns

  • Fiscal quarter and fiscal year

Load Data

  • Include in report refresh

  • Enable load

  • Close and Apply

Data Modelling

  • The importance of a good data model

  • Manage relationships

  • Relationship cardinality

  • Cross-filter direction

  • Typical cardinality and cross filtering

  • Modify data formats

Data Analysis Expressions (DAX)

  • What is DAX?

  • M (Power Query) language vs DAX

  • Create and use a calculated column

  • Create and use measures

  • Simple DAX functions

The X Functions

  • Calculating values row-by-row in a measure

  • X functions vs aggregators and calculated columns

Quick Measures

  • Quick measure categories

  • Aggregate per category

  • Filters / CALCULATE

  • Mathematical operations

  • Text

Time Intelligence Quick Measures

  • Auto date/time option

  • Mark as date table

  • Visuals for date/time reporting

  • Quick measure using an existing measure

Field Parameters

  • Create 2 Field parameters

  • Change the slicer setting to single select

  • Add a bar chart using the parameters as fields

Bookmarks

  • Format the buttons and assign bookmarks

Power BI Service

  • Select Workspaces → create new workspace → Add people

  • Explore different Access Rights

  • Return to PBI Desktop

  • Save and Publish report to your workspace

Prerequisites

Students should have completed the Power BI Beginner course or have a basic understanding of Power BI Desktop, including sourcing and preparing data.

Familiarity with building visuals and dashboards in Power BI is helpful but not essential.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Select and book a course

June

Can't find a date you like?

Contact sales

Looking for more course options?

View all Microsoft Apps coursesView all Data and Analytics coursesView all End User Applications courses

Offers

  • Power Platform 7 Course Program
    Become Microsoft Certified with the PL-900 exam Access 7 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Cost: $4,589.00 incl GST Duration: 7 days of courses, plus 2-3 hours per week Inclusions: 7 x courses, Unlimited support, Practice exam, Exam plus 1 resit
    Find out more
  • Power Platform 4 Course Program
    Become Microsoft Certified with the PL-900 exam Access 4 courses in our Microsoft Power Platform Training package. Microsoft's Power Platform enables users to analyse data, build apps, automate processes and create virtual agents. Learn to use the Power Platform to solve business problems by pulling the capabilities of many apps together. Demonstrate your skill and capability with the PL-900 Power Platform Certification. Our Power Platform Certification Package brings together seven of Nexacu's highly successful courses, along with Microsoft's official exam and certification, to deliver exceptional value. For the same price as the seven courses, you'll also receive the official exam, a free re-sit, unlimited practice tests, unlimited study support and, upon successfully passing the exam, the official Microsoft certification: Power Platform Fundamentals. Certification: Microsoft Certified: Power Platform Fundamentals Exam: PL-900: Microsoft Power Platform Fundamentals Cost: $3,114.00 incl GST Duration: 4 days of courses, plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Exam plus 1 resit
    Find out more
  • Microsoft Word 3 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 3 Microsoft Word Training Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Cost: $1,684.00 incl. GST Duration: 3 days of courses Plus home practice Inclusions: 3 x courses + Practice exam
    Find out more
  • Microsoft Word 2 Course Program
    Certification: Microsoft Certified: Word Specialist or Word Expert Explore the package for 2 Microsoft Word Courses. Demonstrate your Word knowledge with a Microsoft Certified achievement. Word skills are highly sought after. Be confident in your knowledge and skill level. Gain an upper hand in a competitive workforce with specialised skills and expertise in Word. Our flexible packages allow you to choose your level of certification between associate or expert. The MO-100 and MO-101 exams and their respective credentials demonstrate to employers your extensive knowledge of Word. Our successful courses, combined with Microsoft's official exams and certifications, deliver exceptional value. For the same price, our bundle courses will provide you with all of the perks of our Word package, including a Microsoft practice exam, the official exam, a free re-sit, and, upon successfully passing the exam, the official Microsoft certification. Exam: MO-100 or MO-101 Cost: $1,254.00 incl. GST Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
    Find out more
  • Digital Literacy Certification
    Earn your Digital Literacy Certification Access the Microsoft Office 365 Training Package. Elevate your core competencies from Word to PowerPoint, Excel and Power BI. Attend our instructor-led courses in-person or join remotely and learn from our team of experienced Microsoft Certified Trainers. Digital literacy training builds confidence across a range of areas. The courses provide foundational to intermediate knowledge of the most widely used applications in today’s workplace. Showcase your achievements and build your professional profile with this verifiable digital credential. Certification: Nexacu Digital Literacy Exam: Course Attendance Cost: $2,664.00 incl. GST Duration: 4 - 6 weeks Inclusions: 6 Instructor-led courses
    Find out more
  • PowerPoint 2 Course Program
    Become Microsoft PowerPoint certified and stand out from the crowd Validate your specialised skills with PowerPoint Level 1 and 2. Our two courses are jam-packed with tips and tricks that will revolutionise how you create presentations. The MO-300 exam and PowerPoint Associate certification will demonstration to employers your extensive knowledge of PowerPoint. We deliver great value by combining our two PowerPoint courses and the Microsoft certification into one package. In your certification package you will receive a Microsoft practice exam, the official exam, a free re-sit, and upon successfully passing the exam, the official Microsoft certification. Certification: Microsoft Certified: PowerPoint Associate Exam: MO-300 Cost: $1,224.00 incl. GST Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
    Find out more
  • Excel 2 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,394.00 incl. GST Duration: 2 days of courses Plus 2-3 hours per week Inclusions: 2 x courses + Practice exam
    Find out more
  • Excel 3 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $1,909.00 incl. GST Duration: 3 days of courses Plus 2-3 hours per week Inclusions: 3 x courses + Practice exam
    Find out more
  • Excel 4 Course Program
    Become a Microsoft Excel certified expert with MO-200 or MO-201 Embark on the journey with Excel Beginner, Intermediate, Advanced & Expert Courses. Proficiency in Excel is a valuable asset that can open doors to countless opportunities. Our comprehensive training programs will equip you with the necessary skills and knowledge to excel in Excel. Choose between the Excel Specialist or Excel Expert exam options, and upon successful completion, earn one of the prestigious Microsoft Certifications. Certification: Microsoft Certified: Excel Specialist or Excel Expert Exam: MO-201 Cost: $2,369.00 incl. GST Duration: 4 days of courses Plus 2-3 hours per week Inclusions: 4 x courses + Practice exam
    Find out more
  • Power BI 3 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2509.00 incl. GST Duration: 3 days of courses + Plus 2-3 hours per week Inclusions: 3 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
    Find out more
  • Power BI 4 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit Beginner, Intermediate, Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $2899.00 incl. GST Duration: 4 days of courses + Plus 2-3 hours per week Inclusions: 4 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
    Find out more
  • Power BI 2 Course Program
    Become Microsoft Certified and stand out from the crowd Demonstrate your Power BI knowledge with a Microsoft Certified achievement. Book and sit the Advanced & Dax Power BI Courses. Power BI skills are highly sought after by business intelligence professionals. Gain confidence in your knowledge and skill level in business intelligence tools by getting a Power BI certification. PL-300 has replaced DA-100. As Microsoft Power BI use starts to become more widespread across industries, employers are seeking specialised skills and expertise in performing technical tasks such as creating customised visual reports and utilising the essential features of the Power BI desktop. Certification: Microsoft Certified: Data Analyst Associate Exam: PL-300: Microsoft Power BI Data Analyst Cost: $1,934.00 incl. GST Duration: 2 days of courses + Plus 2-3 hours per week Inclusions: 2 x courses, Unlimited support, Practice exam, Certification exam + 1 free resit of the exam only
    Find out more