Microsoft Power BI E-Learning Training

• Language: English
• Audience: Beginners with basic computer skills who want to master the functionalities of Microsoft Power BI
• Level: Basic
• Required knowledge level: Basic computer skills
• Course duration: 4 hours (depending on personal speed)
• Contact with trainer by e-mail and chat
• Online access: 24/7, 365 days after activation
• Online book included
• Certificate of Attendance included

Power BI Training

The amount of information available today can only be used effectively if it can be displayed in a well-arranged and summarized way. Important decisions can be made if this information is displayed correctly and simply. Microsoft Power BI helps with this. In this collection of courses you learn to use Power Bi in the right way.

Today's large volumes of data can provide insights that are visible only when data is transformed, summarized, and visualized correctly. Important decisions can then be made from relevant and compact information.

Course content

Introduction to Business Intelligence

Course: 19 Minutes

• Course Introduction
• Business Intelligence Overview
• Data Analysis Overview
• Data Visualization Overview
• Self-service Business Intelligence
• Excel and Power BI Desktop

Getting Started with Microsoft Power BI

Course: 32 Minutes

• Microsoft Power BI Overview
• The Power BI Service
• Sign up for the Power BI Service
• Power BI Desktop
• Download and Install Power BI Desktop
• Power BI Mobile Apps
• Install Power BI App on Windows 10
• Power BI Tenancy
• Power BI Groups

Practice: Understand Power BI Concepts

Course: 2 Minutes

• Exercise: Power BI Concepts

Getting Data Into Power BI

Course: 59 Minutes

• Course Introduction
• Power BI Data Overview
• File Data Sources
• Database Data Sources
• Online Data Sources
• Quick Insights
• Import a File Data Source
• Import a Database Data Source
• Import a Web URL Source
• Data Gateway Overview
• Configure an On-premises Gateway

Data Preparation

Course: 45 Minutes

• Data Shaping Overview
• Querying with Power BI
• Data Amalgamation
• Working with Rows and Columns
• Creating an Append Query
• Creating a Merge Query
• Filtering Rows
• Adding a Calculated Column

Practice: Prepare Data for Visualization

Course: 4 Minutes

• Exercise: Source and transform datas

Data Modeling

Course: 33 Minutes

• Course Introduction
• Data View
• Relationship View
• Working in Desktop View
• Working Relationship View
• Data Analysis Expressions (DAX) Overview
• Create a DAX Measure Formula

Data Visualization

Course: 42 Minutes

• Power BI Visualization Overview
• Key Performance Indicators (KPIs)
• Power BI Reports Overview
• Create a Custom Power BI Report
• Power BI Dashboards
• Create a Power BI Dashboard
• Dashboard Pinning and Sharing
• Filtering Visualizations with Slicers

Practice: Prepare Data for Visualizations

Course: 7 Minutes

• Exercise: Model and Visualize Data

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.