Description

Our Microsoft Excel and Power BI Diploma provide the ability to develop Excel skills to a high level that will complement your ability to use Power BI effectively. This is the ideal mix of skills needed for anyone involved in data analysis, creating dashboards and building managerial reports.

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.

Why are Advanced Excel Skills?

Power BI and Excel are closely related. The base data for Power BI most commonly comes from Excel. Additionally, knowledge of advanced Excel functions and formulas is an ideal foundation for learning how to do Power BI.

Excel and Power BI Diploma

The Diploma combines two main learning modules. One is the Power BI Course, and the other is the Microsoft Excel Diploma. Both components are CPD Accredited. The Microsoft Excel Diploma must be completed first, as advanced Excel skills are needed to learn Power BI effectively.

  1. Microsoft Excel Diploma

  • Beginner Excel Course
  • Intermediate Excel Course
  • Advanced Excel Course

  2. Power BI Course

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 20-25. You have access to the course for one year and can complete the course anytime during that period.

Course Requirements

There are no prerequisites because the Microsoft Excel Diploma commences at Beginner Level. When you complete the Advanced Excel Course, you gain the foundation to proceed to the Power BI Course.

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
  • The Excel Diploma has been developed by Excel experts from a Microsoft Certified Academy
  • 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

CPD Accredited Diploma in Microsoft Excel and Power BI at a Microsoft Academy.