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.