Power BI Course E-Learning

• Language: English
• Audience: Anyone who processes and analyses large amounts of data to create efficient and relevant dashboards with Power BI Desktop.
• Level: Basic
• Required knowledge level: Good Excel skills are a useful prerequisite for this course.
• Course duration: 5 hours (depending on personal speed)
• Online access: 24/7, 365 days after activation
• Certificate of Attendance included

Power BI Desktop Training

The goal of this video course is to learn to connect to one or more data sources, prepare the raw data, extract something meaningful from it and build a modern-looking and attractive dashboard. At the end of the main modules, you can practice and go through one or more exercises. The files needed to create the exercises and the solution files can be downloaded.

Course Content

Estimated time to study the essential module
Duration of the videos: 3 hours and 22 minutes Duration of the practical exercises: 1 hour and 45 minutes

This module provides educational videos of a total duration of 2 minutes.

• Presentation of the course

This module provides educational videos of a total duration of 6 minutes.

• Power BI Desktop presentation
• Work process and key concepts
• How this course is organised

This module provides educational videos of a total duration of 56 minutes.

• Connecting to an Excel workbook
• Preparing the imported Excel data
• Importing an Excel file cross-table
• Exercise 1: Importing orders from an Excel file
• Connecting to a database
• Extracting, cleansing 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)
• Exercise 2: Importing the tables from the French Books Sales file
• Solution 1: Importing orders from an Excel file
• Solution 2: Importing the tables from the French Books Sales file

This module provides educational videos of a total duration of 44 minutes.

• Introduction and steps
• Setting up the relationships
• Creating the calendar table
• Creating the explicit measures
• Organising the fields in the Model view
• Exercise 3: Setting up the Financial file model
• Exercise 4: Setting up the Fench Books Sales file model
• Solution 3: Setting up the Financial file model
• Solution 4: Setting up the Fench Books Sales file model

This module provides educational videos of a total duration of 48 minutes.

• Creating a dashboard page
• Creating a bar chart
• Creating a line chart
• Creating a pie chart
• Displaying summary data with a card
• Displaying geographical data
• Creating a table
• Creating a cross-table
• Using slicers
• Exercise 5: Creating charts using the French Books Sales file
• Exercise 6: Creating a table and a cross-table using the French Books Sales file
• Solution 5: Creating charts using the French Books Sales file
• Solution 6: Creating a table and a cross-table using the French Books Sales file

This module provides educational videos of a total duration of 31 minutes.

• The filter context and its propagation: Dax's key concept
• Using the CALCULATE function
• Using the ALL function
• Counting with the COUNTROWS and the DISTINCTCOUNT functions
• Analysing trends using the DATEADD function
• Exercise 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table
• using the French Books Sales file
• Solution 7: Use the CALCULATE, COUNTROWS and DATEADD functions to create a table
• using the French Books Sales file

This module provides educational videos of a total duration of 8 minutes.

• Mastering natural interactions
• Drilling into detailled data
• Exercise 8: Adjusting interactions in the French Books Sales file dashboard
• Solution 8: Adjusting interactions in the French Books Sales file dashboard

This module provides educational videos of a total duration of 51 minutes.

• The principles of applicative design (user experience design)
• Preparing the page backgrounds and the theme
• Adding visuals
• Adding buttons to the tabs
• Using bookmarks
• Adding slicers and dynamic titles
• Adding tooltips
• Using conditional formatting in tables
• Overview of the process

This module provides educational videos of a total duration of 9 minutes.

• An overview of publishing on Power BI Service
• Publishing a dashboard and using it

What is Power BI?

Power BI is a powerful business intelligence tool developed by Microsoft. It enables users to visualise and analyse data from various sources to gain insights and make informed business decisions. With Power BI, interactive dashboards, reports and data visualisations can be created and shared across an organisation.

Power BI allows users to integrate data from various sources, both locally and in the cloud. It offers built-in data preparation tools, which allow raw data to be transformed and modified. Users can also create relationships between different data tables to make meaningful connections.

An important aspect of Power BI is its ability to present data in a visually appealing and understandable way. It offers a wide range of visual elements, such as charts, tables, maps and custom visuals, to display data in an intuitive way.

In addition, Power BI includes advanced analytics capabilities, such as built-in machine learning algorithms and natural language processing (NLP). This allows users to perform complex analysis, identify patterns and derive insights from the data.

Power BI also supports collaboration and sharing of reports and dashboards. Users can publish and share their results with others within their organisation. In addition, Power BI offers mobile apps for iOS and Android, allowing users to access their reports and dashboards on the go.

Overall, Power BI is designed to provide users with autonomous analysis and data-driven decision-making capabilities. It is a popular choice for businesses of all sizes.

10 benefits of Power BI

1. Data visualisation: Power BI offers powerful visualisation capabilities that allow data to be presented in an intuitive and attractive way. This helps in understanding complex data and identifying patterns and trends.
2. Interactive dashboards: With Power BI, interactive dashboards can be created, allowing users to quickly and easily navigate through data and view the most relevant information. This enables users to gain real-time insights and make faster decisions.
3. Data integration: Power BI can integrate data from different sources, such as databases, spreadsheets and cloud services. This enables users to combine and analyse data from different sources, leading to a more complete picture and better decision-making.
4. Self-service analysis: Power BI is designed for self-service analysis, meaning users can perform complex analysis and gain insights without a technical background. This reduces reliance on IT teams and speeds up the analytical process.
5. Real-time data: Power BI can update data in real time, meaning users always have access to the most up-to-date information. This is especially useful when monitoring business performance and making decisions based on real-time data.
6. Advanced analytics capabilities: Power BI offers advanced analytics capabilities, such as machine learning integration and natural language processing. This enables users to perform complex analysis, build predictive models and extract deeper insights from their data.
7. Mobile accessibility: With the Power BI mobile app, users can view and analyse reports and dashboards from their smartphones and tablets. This ensures flexibility and access to data even when users are on the move.
8. Collaboration and sharing: Power BI makes collaboration and sharing of data and insights easy. Users can easily share reports and dashboards with colleagues and stakeholders, promoting collaboration and making better decisions based on shared insights.
9. Scalability: Power BI is scalable and can be used by individuals, small teams and large organisations. It can be easily adapted to a company's growing needs and supports a large number of users and data sources.
10. Integration with other Microsoft tools: Power BI integrates seamlessly with other Microsoft tools, such as Excel, SharePoint and Azure. This provides additional capabilities and makes it easier to leverage existing data sources and workflows.

Why is Power BI important?

Power BI is important because it enables organisations to visualise, analyse data and gain insights for data-driven decision-making. It provides powerful and intuitive tools for data integration, visualisation and analysis, allowing users to quickly and easily access valuable information and gain real-time insights. Power BI also promotes collaboration and data sharing, enabling teams to work together more effectively and make better decisions based on shared insights.

Why OEM Office Elearning Menu?

OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more. 

OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.

Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.

OEM - Learn to Work

Choose from 1000+ training courses from 200+ brands for your personal and business development. 

An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.

We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.