Power BI Desktop Introduction
From: £695.00 Plus VAT
Have more than 2 delegates? Talk to us about our closed group courses.
Delivery Method
Open Public Courses – Virtual Delivery Only Closed Group Courses – Face To Face and Virtual Delivery
Business Benefit
During this interactive Power BI training course, our engaging trainers will educate you of how to produce visually compelling and informative dashboards of your business’s performance data.
Who Should Attend
The Microsoft Power BI course is a comprehensive course designed to equip delegates with the skills and knowledge needed to effectively use Microsoft Power BI, a powerful business intelligence and data visualisation tool.
Delegates must be comfortable doing formulas as a minimum requirement with Intermediate Excel skills desired but not required.
Learning Outcomes
Learning Basic Data Preparation and Data Cleaning:
Data Collection: Understanding how to gather and collect data from various sources, such as databases, spreadsheets, or external systems.
Data Cleaning: Learning how to identify and handle missing or inconsistent data, including techniques for data imputation and validation.
Data Transformation: Exploring methods to reshape and reformat data to make it suitable for analysis and visualisation. This includes tasks like pivoting, aggregating, and merging datasets.
Data Quality Assurance: Ensuring data accuracy and reliability by applying data validation rules and addressing anomalies.
Data Integration: Combining data from multiple sources to create a unified dataset for analysis and reporting.
Data Profiling: Profiling data to gain insights into its characteristics, such as data distributions, patterns, and outliers.
Using DAX Functions and Metrics for Dashboards:
DAX (Data Analysis Expressions): Learning the fundamentals of DAX, a powerful formula language used for data analysis in tools like Microsoft Power BI and Excel.
Creating Metrics: Understanding how to define and calculate key performance indicators (KPIs) and metrics relevant to your specific business or analytical objectives.
Aggregating Data: Using DAX functions to aggregate and summarise data, which is essential for creating meaningful visualisations in dashboards.
Time Intelligence Functions: Exploring DAX time intelligence functions to analyse data trends over time, such as year-to-date calculations and moving averages.
Data Modeling: Developing data models that optimize data relationships for dashboard creation, including defining hierarchies and relationships between tables.
Visualization: Designing and creating visually appealing and interactive dashboards using tools like Power BI, Tableau, or Excel. This includes selecting appropriate charts, graphs, and widgets for data representation.
Dashboard Interactivity: Implementing interactive features like slicers, filters, and drill-through functionality to allow users to explore and analyse data dynamically.
Performance Optimization: Optimising dashboard performance for efficient data loading and responsiveness, particularly when dealing with large datasets.
Course Content
What is Power BI?
What are the benefits of Power BI?
Creating reports and dashboards with Microsoft Power BI
Importing Data
Datasets and connecting data
Reading and Editing Data
Creating graphs and visualisations
Managing Schema and Relating Tables
Power BIÂ Business Intelligence
Creating calculations, metrics and KPI’s
Data Analysis Expressions
DAX Syntax
DAX Functions
Query Editing
Presenting using Power BI
Logical and Insightful Data Analytics Presentation
Rules and Limitations of Data
Calculated Columns
Shaping Data
Transferring your Data to the Cloud
Presenting in Cloud
Visualising Data
How to Book
Dates below represent open public courses only. To book this course, please select an available date and click the book now button below to complete the booking by Credit Card or via Invoice. Have two or more people to train – you may consider a closed group course. Contact us on [email protected] to discuss specific date and delivery requirements.
The purpose of your training is learning new skills and/or changing behaviour. We can help you measure this!
Post-course, to evaluate how successfully the attendees are doing this, delegates can attend a Workplace Implementation session during the skills transfer period. This additional session lasts for 2.5 hours.
During the Workplace Implementation session the individuals will either on a 1-2-1 basis or as a group discuss the challenges and successes they have experienced during their skills transfer period.
This will include what they are doing differently as a direct result of the training and how this has positively impacted the organisation.
This is an excellent way to encourage the learning, support the skills transfer into the workplace and act as a measure to evaluate the training.
We compile this information into a report so that you have evidence of your return on investment.