FROG Software Training: Power BI


This course will benefit those who analyse data and create reports. Getting data from different sources and producing dashboards and reports.  On completion of this course, attendees will be able to use Power BI Desktop to create effective reports and publish/share it in different ways. Attendees must have an advanced working knowledge of Excel.  

Dates Tuesday, March 31, 2020 to Wednesday, April 1, 2020 - Download as vCalendar
Venue Online training via Microsoft Teams
Contact Name Rachel Crew
Email rachel.crew@frog.co.uk
Contact Phone 01223 841848
Website Event website

Event details:

What is Power BI? 

  • Power Query 
  • The Data Model/Power Pivot 
  • Rich interactive visualisations
  • Power BI Desktop and Power BI Service

The Power BI Desktop Interface

  • Different Views
  • Visualisation and Fields pane
  • Power BI Desktop Options

Getting Data into Power BI  

  • From Text Files 
  • From CSV files 
  • From Web
  • From Folder
  • From Excel ranges and sheets

Understanding Power Query  

  • Understanding the Power Query interface 
  • Renaming and deleting steps 
  • Cleaning messy data example
  • Refreshing a query
  • Power Query Options

Common Power Query Features  

  • Unpivot Columns 
  • Setting Data Types 
  • Append Queries
  • Merge Queries

Creating the Data Model  

  • Create table relationships 
  • Edit and delete relationships  
  • Understand filter context

Getting Started with DAX 

  • How is DAX different to Excel Formulas  
  • Calculated Columns vs Measures  
  • Creating a Calculated Column  
  • Creating Measures 
  • Using Common DAX Functions 

Getting Started with DAX 

  • How is DAX different to Excel Formulas  
  • Calculated Columns vs Measures  
  • Creating a Calculated Column  
  • Creating Measures 
  • Using Common DAX Functions 

Lookup and Filter DAX Functions 

  • Why these functions are useful?  
  • RELATED Function 
  • CALCUALTE Function  
  • FILTER Function 

Interactive Visualisations 

  • Adding tiles to a Report 
  • Creating Charts 
  • Using Geographic Data 
  • Creating Matrixes
  • Using Slicers
    • Other Filter tools (Report, Pages, Visualisations)
    • Editing Interactions 
    • Highlight vs Filter
    • Formatting Visualisations
    • Drill Down

Power BI Service

  • Publishing your Report
  • Mobile Layout
  • Reports and Dashboards
  • Bookmarks
  • Understanding Gateways
  • Refreshing your Reports

Founded in 1986 The FROG Group is recognised for the quality of its services. FROG has been providing computer and personal development training along with consultancy and room hire for over 30 years. The training centre in Cambridge offers a wide range of courses including the latest Microsoft Office, Personal Development, Adobe Creative Suite and many others, and together with partners across the UK FROG can provide all your training needs.