Data and Analytics - Category Banner

Power BI Fundamentals

  • Length 2 days
Course overview
View dates &
book now

Why study this course

Power BI is an industry leader and one of the largest and fastest-growing business intelligence cloud solutions, used by over 35,000 companies worldwide.

Power BI is a suite of Microsoft tools used for business analytics, visualization, and reporting, forming part of the broader Power Platform ecosystem. Power BI delivers supported decision-making through actionable insights, empowering users to conduct thorough data analytics and data analysis. It provides interactive reporting and business intelligence capabilities, allowing users to easily connect to, model, and visualize organisational and public data. This capability enables users to create compelling data visualizations that facilitate informed decision-making based on organizational and public data, thereby enabling the creation of robust data models for informed decision-making.

Key components of the Power BI suite include Power BI Desktop, Power BI Service, Power BI Mobile Apps, and Power BI Gateway, among others.

Power BI training is designed to give participants a fundamental understanding of the tools. Participants will learn how to use the Power BI tools by following a simple workflow that can be used to design, develop, deploy, and share Power BI reports and dashboards. Microsoft Power BI courses, such as this course from Lumify Work, help you learn how to use these tools effectively and efficiently.

The Microsoft Power BI fundamentals course is an entry-level workshop for professionals in the Philippines. If you are looking for a more in-depth technical course on advanced Power BI, see our Microsoft PL-300T00 - Design and Manage Analytics Solutions using Power BI course.

Important note: Power BI is a Microsoft App that is not currently supported on non-Windows systems (such as Apple Mac).

Request Course Information


What you’ll learn

After completing this workshop, participants will be able to:

  • Connect to various data sources and extract data

  • Shape data to ensure that all data is necessary, clean, and transformed appropriately

  • Model data to add any necessary derived calculations, columns, and tables

  • Utilise out-of-the-box and custom visualisations to display data appropriately

  • Publish reports and datasets to the Power BI service

  • Create dashboards, and use workspaces and apps to share Power BI objects


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. 


Who is the course for?

Microsoft Power BI Fundamentals training is an entry-level two-day workshop designed for anyone who needs to be able to analyse and visualise data using Power BI.

Students can attend this Power BI course online or at one of our campuses across Australia and New Zealand.


Course subjects

Module 1: Introduction to Power BI

  • What is Power BI?

  • A brief history of Power BI

  • Power BI components

    • Power BI Report Server

  • Power BI architecture

  • Power BI Workflow

  • Getting started with Power BI

    • Power BI Desktop

    • Power BI Service

    • Power BI Help

Module 2: Getting Data

  • Power BI Workflow

  • Get data process flow

  • Data Sources

  • Data Base Data Sources

  • Data Base Queries

  • File Sources

  • Web Pages

Module 3: Shaping Data

  • Shaping vs Transforming Data

  • Shaping Data Overview

  • Where should I do the Shaping?

    • Shaping Data in SQL

    • Shaping Data in DAX

    • Shaping Data in Power Query

  • The Power Query Editor

  • First Pass at Shaping

  • Applied Steps

  • The Advanced Editor

    • Advanced Shaping

Module 4: Modelling Data

  • Relationships

    • Cardinality

    • Cross Filter Direction

    • Role Playing Dimensions

  • Optimising the Model

    • Configuring Data for Q&A

  • Hierarchies

  • Introduction to DAX

    • Calculated Columns

    • Calculated Measures

Module 5: Visualising Data

  • Visualisations

    • Charts

    • Filters

    • Slicers

    • Maps

    • Tables

    • Tree Maps

  • Formatting Visuals

    • Page Layout and Formatting

    • Mobile Layout

    • Custom Visuals

    • Report Themes

Module 6: Publishing to Power BI

  • Publishing to the service

  • Dashboards

    • Dashboards vs Reports

  • Q&A

  • Power BI Insights

  • Apps

    • Creating Workspaces and Apps

    • What can you do with an App?


Prerequisites

In order to attend this course you must have Power BI Desktop installed on your local desktop or laptop prior to attendance. Download Power BI Desktop from Microsoft here. Power BI accessed through a browser or Microsoft Teams does not have the features and functionality needed to complete this course. Remote connection to your work desktop or laptop is also not suitable.

In addition you will need to be able to extract compressed (ZIP) files to your desktop or laptop.

We recommend dual monitors, especially if your primary monitor is a laptop screen.


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

May
June
July
August
September
October
November
December
January
February
March

Can't find a date you like?

Contact sales


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 Duration: 7 days of courses, plus 2-3 hours per week Inclusions: 7 x courses, Unlimited support, Practice exam, Exam plus 1 resit
  • 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
  • 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 Duration: 3 days of courses Plus home practice Inclusions: 3 x courses + Practice exam
  • 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 Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • 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 Duration: 4 - 6 weeks Inclusions: 6 Instructor-led courses
  • 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 Duration: 2 days of courses Plus home practice Inclusions: 2 x courses + Practice exam
  • 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 Duration: 2 days of courses Plus 2-3 hours per week Inclusions: 2 x courses + Practice exam
  • 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 Duration: 3 days of courses Plus 2-3 hours per week Inclusions: 3 x courses + Practice exam
  • 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 Duration: 4 days of courses Plus 2-3 hours per week Inclusions: 4 x courses + Practice exam
  • 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 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
  • 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 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
  • 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 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
  • Microsoft Bundles
    Master Microsoft skills, from fundamentals to advanced levels. Choose from bundles or private class options and SAVE up to 35% on training costs.