Course Details close

Course Details

Price:
(inc GST)
$ 385
Application:Power BI
Level:Level 1
Version:All-Versions
Duration:1 day
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

   (4.8 out of 5)
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$

Quick links

Power BI Training Courses | Raising the Bar

Course Overview

This 1-day course has been professionally created to teach students how to plan, design and build dashboards to create and share reports using Microsoft's extremely powerful Power BI software. During the course, students will use a variety of data sources such as Excel spreadsheets, Access tables and queries and plain text files to explore the various tools and techniques supplied within the Power BI environment. This course provides a solid introduction to Power BI and its capabilities.

Who Should Attend This Course

This course is designed to introduce students to the powerful suite of tools encompassed within the Power BI software that will allow you to create interactive, dynamic reports far beyond your expectations. If a student is wanting to learn a better way of presenting data, this course is definitely for you.

Course Prerequisites

Students require no prior knowledge of Power BI however a solid understanding of Microsoft Excel and good computer skills would be advantageous.

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

With each course we provide you with a comprehensive course manual for you to practice post course.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status

There are currently no virtual course dates scheduled for this course.

Call us today to discuss - 1300 937 782.

Public Course Dates

Course Date Price Add Course Qty Status

There are currently no public dates scheduled for this course.

If you have 3 or more people interested in this course, call us today to discuss group training - 1300 937 782.

Course Outline

Connect to Data with Power BI

  • What is Power BI?
  • Components of Power BI
  • A Crash-Course in Databases
  • Connect to Excel
  • Select Which Data to Load
  • View the Data
  • Clean Data in Data View
  • Clean Data in the Query Editor
  • Undo Applied Steps in Query Editor
  • Choose Columns
  • Close the Query Editor
  • Save and Close the Report
  • Connect to a Database Query
  • Connect Directly to Access Tables
  • View the Relationship in Model View
  • Select the Required Fields
  • Connect to a CSV file
  • Combine Files from a Folder
  • Add Internet Data to a Report Relate the Tables using Model View

Data Manipulation

  • Open an Existing Report
  • Add a Calculated Custom Column
  • View Query Formulae
  • Rename an Applied Step
  • Remove a Custom Column
  • Group Rows
  • Add another Aggregation Add a Grouping
  • Pivot a Column
  • Select Pivoted Columns
  • Sort and Filter Data
  • Use Inbuilt Functions in a Custom Column Change the DataType of a Column

Visualizations

  • A Note on Design
  • Add a Simple Chart Visualization
  • Format the Chart
  • Change the Chart Type
  • Create a Table Visualization
  • Add a Map Visualization
  • Cross Filtering
  • Add and Rename a New Page
  • Add a Gauge Visualization
  • Format Numbers on the Gauge
  • Add Timescaled Data
  • Drill Mode
  • Add a Slicer

Data Analysis Expressions (DAX)

  • DAX and Measures
  • DAX Syntax
  • Create a Measure
  • Use Measures in Visualisations
  • Link Another Data Source
  • Create a Hierarchy
  • CALCULATE Function using ALL
  • CALCULATE Function using FILTER
  • RELATED Function
  • PREVIOUSQUARTER Function
  • TOTALYTD Function

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us