Select Page
Click here to search in website

Overview

The main purpose of the Power BI Course is to give students a good understanding of data analysis with Power BI. The Power Bi course includes creating visualisations, the Power BI Service, and the Power BI Mobile App. It starts by introducing you to Business Intelligence concepts, building a report, and dashboard, moving on to importing and modelling data. You will also learn how to create and manage interactive data visualisations.

Course Objectives

To become truly proficient in Power BI and confidently create, manage, and maintain complex reports and interactive dashboards, participants need a comprehensive understanding of the platform’s core and advanced capabilities. This Power BI course is designed to equip learners with practical, hands-on skills to efficiently import, clean, and transform data from multiple sources. Participants will learn how to build insightful visualisations, craft dynamic dashboards, and utilize powerful tools like DAX (Data Analysis Expressions) for in-depth data analysis. The Power BI course goes beyond the basics, delving into advanced features such as row-level security, role-based access, and custom visuals. It also explores how Power BI integrates seamlessly with Microsoft 365 tools, enabling users to enhance collaboration and streamline business intelligence workflows. By the end of the course, attendees will be capable of designing, deploying, and managing impactful BI solutions that support smarter, data-driven decision-making across an organisation.

Content

Introduction to Power BI

  • Overview of Power BI
  • Components and workflow

Power BI Desktop Data Transformation

  • Power Query Editor
  • Importing, cleaning, and transforming data

Power BI Desktop Modelling

Power BI Desktop Visualization

  • Building basic and advanced visualizations
  • Customizing visualizations
  • Using slicers and filters

Implementing the Power BI Service

  • Publishing reports to Power BI Service
  • Creating & managing dashboards

Connecting to Excel Data

  • Importing data from Excel
  • Maintaining live connections to Excel files

Collaborating with Power BI Data

  • Sharing reports and dashboards
  • Working with Power BI workspaces
  • Using Power BI apps

Connecting Directly to Data Stores

  • Connecting to databases and online services

Power BI Developer API

  • Overview of Power BI API
  • Embedding Power BI content
  • Customizing Power BI with APIs

Power BI Mobile App

  • Accessing and interacting with reports on mobile devices
  • Offline capabilities and notifications

You will learn how to

  • Master data transformation using Power BI Desktop.
  • Understand and implement data modelling in Power BI Desktop.
  • Create effective visualizations in Power BI Desktop.
  • Utilize the Power BI Service for sharing and collaboration.
  • Connect and import data from Excel into Power BI.
  • Connect directly to various data stores for real-time analysis.
  • Understand and use the Power BI Developer API.
  • Use the Power BI mobile app for on-the-go data access and analysis.
  • … and much more.

Audience

This Power BI Course is aimed at SQL Server report creators who are interested in alternative methods of presenting data. Essential to have a good understanding of Excel before attending this course.

Classroom and Virtual training options

Online Course Materials

Duration

2 Days or 4 x 3 Hour Sessions

Contact us...

  • This field is for validation purposes and should be left unchanged.

Relevant, industry-focused learning and development

Our expert trainers have a wealth of experience in providing corporate training. Whether you pick off-the-shelf professional diplomas or a customised online L&D Program, we provide relevant, engaging content for all employees.

Bespoke Private Training at IACT
0
YOUR CART
  • No products in the cart.