×

Search our courses

Course Duration:  1 day

Overview: With Power BI, you get a report authoring tool that enables you to connect to and transform data from a wide variety of sources. This allows you to then produce detailed reports through a comprehensive range of visualizations.

The reward is to then be able to share those reports with your team inside or outside of your organisation, simply by publishing them to Power BI online service.

This course allows you to gain a thorough understanding of the complete Power BI cycle by working with real-world examples and will equip you with the necessary skills to start applying your knowledge straight away.

Pre-requisites:   There are no specific technical pre-requisites for this course, but a familiarity with Excel and/or Relational Database Technologies may be beneficial. The main pre-requisite is to have a basic understanding of your business’s need to collect, cleanse, analyse and deliver insights and visualisations of your business data.

Subject Areas:

  • Getting Started
    • The Power BI process
    • Launch Power BI Desktop
    • Power BI Desktop views
  • Getting Data
    • Connect to data sources
    • Connect to an Excel file
    • Connect to a CSV file
    • Connect to a Web source
  • Transform Data in the Query Editor
    • Clean data in the query editor
    • Data types and replace values
    • Fill data up and down
    • Split column by delimiter
    • Add conditional and custom columns
    • Pivot data in the query editor
    • Pivot and append data
    • Insert a custom column
    • Append data to a query
    • Add an index column
  • Build a Data Model
    • Relate tables in a data model
    • Manage table relationships
  • Merge Queries
    • Table join kinds
    • Table merge process
  • Create Report Visualisations
    • Create and format visuals
    • Create map visuals
    • Format map visuals
    • Create chart visuals
    • Format chart visuals
    • Table, matrix and card visuals
    • Control number formats
    • Format chart visuals continued
    • Use slicers to filter data
    • Visuals from the marketplace
    • Map latitude and longitude
    • Export report data to Excel
  • Introduction to Calculated Column
    • Two kinds of power BI formulas
    • Add your first calculated column
    • The SWITCH function
  • Introduction to DAX Measures
    • COUNTROWS and DISINCTCOUNT
    • DAX rules
    • The CALCULATE function
    • Three things about CALCULATE
  • Introduction to Time Intelligence
    • Standard vs. custom calendar
    • Calendar: a special lookup table
    • Time intelligence functions
    • The TOTALYTD function
  • Hierarchy and Conditional Formatting
    • Create a hierarchy to “drill” data
    • Add conditional formatting
  • Publish and Share Your Report Online
    • Publish to the online Power BI Service
    • Get quick insights
    • What is Q&A?
    • Share your report