Description

This Power BI Course allows learners to understand how to use Power BI. This is a growing Microsoft Office product that is used across numerous companies.

What is Power BI?

Microsoft Power BI is a Business Intelligence software. It can generate interactive visual reports and create a dashboard. The Power BI System enables the analysis and manipulation of data sets. Additionally, the programme allows for the creation of automated and high-quality business analyses. It is a tool used to create insights for management using data sets. The programme can cleanse organisational data, recognise patterns and produce easily understood reports and charts. BI platforms are set to become part of the future going forward.

Power BI Course

This course contains several Power BI learning areas. It gives the full range of training and can be taken by anyone interested in Power BI.

Connecting and preparing data with Excel and other sources

  • Connecting Power BI to an Excel workbook
  • Managing the imported Excel data
  • Importing an Excel file
  • Cross-tables from Excel
  • Connecting Power BI to a database
  • Extracting, organising and filtering data from the imported base
  • Creating columns from examples and adding conditional columns
  • Connecting to other data sources (txt, csv, pdf, SharePoint list)
  • Practical exercises with solutions to consolidate learning

Setting up a model in Power BI

  • Setting up the relationships within the model
  • Creating the calendar table
  • Developing the explicit measures in your model
  • Organising the fields in the Model view
  • Practical exercises with solutions to consolidate learning

How to create Dashboards and Interactive Visuals

  • Develop a dashboard
  • Create a bar chart / line chart / pie chart
  • Use a card to show summary data
  • Illustrating geographical data
  • Creating a table and cross-table
  • Using slicers
  • Practical exercises with solutions to consolidate learning

DAX Formulas

  • What is the DAX concept?
  • How to apply the CALCULATE function
  • The ALL function
  • Counting items using the COUNTROWS or the DISTINCTCOUNT functions
  • Trend analysis using the DATEADD function
  • Practical exercises to consolidate learning

Interactions within Power BI

  • How to build natural interactions
  • Drilling down into more detailed data
  • Practical exercises to consolidate learning

Applicative Designs within dashboards and models

  • Principles of applicative design
  • User experience design
  • Develop the page backgrounds
  • Create the theme
  • Adding visuals and buttons to the tabs
  • Using bookmarks
  • Adding slicers, tooltips  and dynamic titles
  • Conditional formatting in tables
  • Overview of the process
  • Practical exercises to consolidate learning

Publication

  • Power BI Publishing Service
  • Publish a dashboard
  • Use a Published Dashboard
  • Practical exercises to consolidate learning

Dates and Duration

The average learning hours based on thousands of past students is 5-6. You have access to the course for one year and can complete the course anytime during that period.

Course Requirements

You will need to have strong Excel skills to benefit from this training. Please consider our Microsoft Excel and Power BI Diploma to enable you to gain the skills required.

Benefits of the Power BI Course

  • An expert developed this Power BI Course at a Microsoft Platinum Partner.
  • Our training programs are set to an international standard
  • Our qualifications are CPD Accredited, and they are internationally recognised.
  • The training is highly practical to ensure learners can transfer what they have learnt back to the workplace.

Outcome

Certificate of the CPD Accredited Microsoft Power BI at a Microsoft Academy.