Introduction to Power-BI

Our Introduction To Power BI training course covers the following modules:

Module 1: Power BI Overview

• Visual analysis and visual analytics
• Power BI Infrastructure
• Loading Data
• Introduction to Power BI Desktop
• Hands-On Exercise 1.1 Loading and Visualising data

Module 2: Transforming Data

• Using Power Query to clean, transform and load data
• Profiling your data
• Resolve data quality issues
• Apply user-friendly names to Queries, tables, and columns
• Import data from an Excel formatted report
• Hands-On Exercise 2.1 Transforming Data with Power Query
• Hands-On Exercise 2.2 Appending, Merging, and Combining Queries

Module 3: Creating a Data Model

• Understand the role of the Data Model in Power BI
• Create table relationships
• Understand Cardinality and Cross Filtering
• Discuss Star and Snowflake schema
• Create a Date Dimension
• Build a Data Model from multiple Data sources
• Hands-On Exercise 3.1 Creating a Data Model

Module 4: Visualising your Data

• Discuss Report settings
• Choosing the right visualisations
• Creating, formatting, and styling your reports
• Using Hierarchies and Drilldown
• Utilising Slicers and Filters
• Adding Custom Visualisations
• Hands-On Exercise 4.1 Creating Reports Part 1
• Hands-On Exercise 4.2 Creating Reports Part 2
• Hands-On Exercise 4.3 Creating Reports Part 3

Module 5: Introduction to DAX, Calculated Columns and Measures

• Gain an Introduction to DAX
• Differentiate between Calculated Columns and Measures
• Create Calculated Columns
• Create Measures
• Understand Filter and Row context
• Understand the power of the Calculate function
• Hands-on Exercise 5.1 Introduction to DAX
• Optional Hands-on Exercise 5.2 Intermediate Level DAX

Module 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)

• Discuss the Power BI Service and Power BI Server
• Understand the main components of the Power BI Service
• Publish a Power BI Project to the Power BI Service
• Share Reports
• Build and Share Dashboards
• Hands-On Exercise 6.1 Collaboration and Sharing in the Power BI Service

Our Introduction To Power BI training course is open to individuals and professionals from various backgrounds who have an interest in learning Power BI. Including but not limited to:

• Business Analysts
• Data Analysts
• Data Scientists
• IT Professionals
• Managers and Executives
• Students and Researchers

Our three-day Introduction to Power-BI training course contains the following:

• Pre-reading
• Course Manual
• Quizzes
• Exercises

There are no entry-level requirements for our Introduction To Power BI training course.

There is no recommended reading for our Introduction To Power BI training course.

Introduction To Power BI training course Exam:

• Format: Multiple Choice
• Questions: 40
• Pass Score: 70%.

You might enjoy our three-day BCS AI Foundation: Data Visualisation training course.

This course is designed for anyone wishing to gain an understanding of how data is used to make decisions in an organisation and the importance of presenting accurate data in a way that enables decision making to happen.

Our BCS Foundation Award - Data Visualisation training course will enable you to understand these concepts at a Foundation Level, incorporating processes, frameworks and techniques used. It also looks towards the future use of data and how AI can present data in different ways to help organisations better understand their data.

Power BI offers numerous benefits for organisations and individuals seeking to analyse data and make data-driven decisions. Including but nor limited to:

• Data Visualisation: Power BI allows users to create visually appealing and interactive reports and dashboards.
• Data Exploration and Analysis: Power BI provides powerful tools for exploring and analysing data.
• Data Integration: Power BI supports a wide range of data connectors, enabling users to connect to various data sources, both on-premises and in the cloud.
• Data Modeling and Transformation: Power BI offers robust data modeling capabilities.
• Mobile Accessibility: Power BI provides mobile applications for iOS and Android devices, allowing users to access their reports and dashboards on the go.
• Scalability and Performance: Power BI is designed to handle large volumes of data and provides fast and efficient querying and processing capabilities.