Master data visualisation with Power BI. Learn from experts to create insightful reports, optimise business intelligence and enhance analytical skills effectively and efficiently.
3 day course 10am - 5pm Live Online or Classroom-based
What you will learn
- Exploring business techniques to improve design opportunity.
- How to use dashboards, reporting and marketing using a range of new commercial methods.
- Understanding how to make marketing design effective through data presentation and design-led data opportunities.
- How to produce design insights.
- Exploring opportunities to produce effective design insights, improving client brand awareness.
- How to take data and turn it into visual design opportunities, delivering new creative solutions to potential clients.
- Understanding design driven leads and how these have an impact for client success.
We can tailor this course to you
If you have specific requirements, talk to us about customising this course to meet your exact needs.
This Power BI Introduction course includes
-
Authorised Certificate
-
Lifetime support after your course
-
Course materials
-
Live Instructor-led training
-
Refreshments all day
-
Latest Mac or PC ready to go
-
Authorised Trainers
-
Hands-on exercises
Book this course
We offer Power BI Introduction as a private course.
You can select a date which suits you or your team.
The course content can be fully customised to your exact learning requirements.
Request datesCourse Outline for Power BI Introduction
Introduction To Power BI
- Microsoft Self-Service Business Intelligence
- Importing data
- Modelling Data
- Creating Dashboards & Reports
- Installing Power BI Desktop
- Creating your First Power BI Project
Discovering & Loading Data with Power BI Desktop
- Data Sources: Files, Databases, Azure, Web Pages, Other Sources
- Refreshing Data & Queries
Transforming Datasets
- Power BI Desktop Queries
- Transforming Source Data: Cleansing, De-duplicating, Merging, Deriving new Columns, Removing Rows and Columns, Transposing Columns, Unpivoting Columns, Filtering Rows
Data Cleansing
- Query editor context Menus
- Data Typing Columns
- Replacing Values
- Filling Down
- Using First Rows as Headers
- Grouping Records
Data Mashup
- Power BI Desktop View Ribbon
- Duplicating Columns
- Splitting Columns
- Merging Columns
- Creating Custom Columns
- Adding Index Columns
- Merging and Adding Data
- Aggregating Data on Merging
- Appending Data
- Un-pivoting & Pivoting Data
- Transposing Rows and Columns
- Removing Error and Blank Rows
- Duplicating Queries
- Managing The Transformation Process with Applie Steps
- Applying Changes to Queries
Creating a Data Model
- Data Modelling in the Power BI Desktop Environment
- The Power BI Desktop Data View
- How We Decide Whether to make our changes in the Data Model or Query
- The Modelling Ribbon
- Manipulating Tables
- Manipulating Columns
- Data Types
- Formatting
- Categorising
- Default Summarisation Function: Sum, Count, Max, Min, Average, etc
- Column Sort Orders
- Relationships
- Data View and Relationship View
Extending the Data Model with Calculated Columns
- Types of Calculations
- New Columns
- Naming Columns
- String Expressions
- Arithmetic Expressions
- Calculating Across Tables
- Refreshing Data
- Using DAX Functions
- Simple Logic: IF () Function
Adding Measures to the Data Model
- Basic Aggregations in Measures: Sum, Count, Max, Min, Average, etc
- Cross-Table Measures
- Advanced Aggregations: CALCULATE
- Filtering Data in Measures: Column Filters, ALL, ALLEXCEPT, ALLSELECTED, FILTER
- Ranking
Analysiing Data Over Time
- Simple Date Calculations
- Date & Time Formatting
- Calculating Age and Difference
- Adding Time Intelligence to a Data Model
- Date Tables
- Time Intelligence DAX Functions: TOTALMTD, TOTALQTD, TOTALYTD, PREVIOUSQUARTER, PREVIOUSMONTH, PREVIOUSYEAR, PARALLELPERIOD, DATEADD, DATEDIFF, DATESBETWEEN
- Data as a Ration Over Time
- Comparisons With Previous Periods
- Rolling Aggregations
Text-Based Visualisations
- Power BI Desktop Dashboards
- Switching to Report View
- Creating Tables
- Enhancing Tables: Totals, Formatting, Titles, Fonts, Colours, etc
- Creating a Matrix
- Row Matrix
- Column Matrix
- Creating Cards
- Switching Between Table Types
Charts in Power BI Desktop
- Creating Charts
- Basic Chart Modification
- Basic Chart Types: Line, Pie, Column, Bar
- Enhancing Charts
- Other Chart Types: Donut, Funnel, Stacked Column and Bar, Scatter, Bubble, Waterfall, Dual-Axis, Clustered
- Drill Down
Other Types of Visuals
- Maps
- Bing Maps
- Using Geographical Data Types
- Enhancing Maps
- Tree Maps
- Guages
- Additional Visuals: The Power BI Visuals Gallery
Filtering Data
- Visual-Level Filters
- Page Filters
- Report Filters
- Text Filters
- Numeric Filters
- Date Filters
Using Slicers
- Adding Slicers
- Applying Slicers
- Formatting Slicers
- Using Charts as Slicers
- Cross Chart Highlighting
- Charts as Filters
Enhancing Dashboards
- Adding Text Boxes
- Adding Hyperlinks
- Adding Images
- Adding Shapes
- Layering Visuals
PowerBI.com
- Publishing Reports to PowerBI.com
- Creating a Power BI Account
- Interacting With Reports in PowerBI.com
- Creating PowerBI.com Dashboards
- Adding Tiles to Dashboards
- Sharing Dashboards
- App Dashboards
- Creating New Reports in PowerBI.com
- PowerBI.com Gateways
- Ad-hoc and Scheduled Data Refresh
FAQs about the Power BI Introduction course
Is this Power BI Introduction course suitable for me?
This course is designed for people who are new to Power BI or have been using Power BI for a while but have never had formal training or who would like to learn best practice in Power BI. If you are have any questions about whether the course could meet your needs, please speak to our customer service team. They will be delighted to advise you.
Will I receive a certificate upon completion of my Power BI Introduction course?
Yes, you'll receive a certificate of completion from Transmedia, demonstrating your knowledge and attendance on our Power BI Introduction course. Our certificates note our Authorised Training Centre status.
How is the content taught throughout the Power BI Introduction course?
Our Power BI Introduction course is extremely interactive. You will be using Power BI throughout the day, working through examples and live projects under the guidance of our trainer, who will be supporting you through each step.
What is the recommended number of people for the class when I attend the Power BI Introduction course?
For private classes in Power BI Introduction, we recommend a maximum of 8 to 10 people from the same company in the class. Please ask our customer service team to help you find the right balance of people per class and the number of days training you need.
Should I attend the Power BI Introduction course in person or live online?
For in-person courses at our London training centre, you will receive a warm personal welcome, your choice of the latest Mac or PC and morning and afternoon refreshments. If you prefer to attend remotely, rest assured that you will be taught live by the same experts that deliver our in-person courses, covering the same training content, using the same exercises and materials. A second monitor is recommended but not essential.
What support is available after I attend the Power BI Introduction course?
We offer ongoing support to our Power BI Introduction course attendees through email and by arrangement, phone calls. You are welcome to ask any questions on topics covered during training. Our trainer will always do their best to explain principles and help you with any issues you encounter.
Power BI Introduction — Team and Bespoke Training
Booking a private training session allows you to focus on your exact needs on dates that work best for you or your team.
- Sessions can be run online or in person, on your site or at our London training centre.
- We manage training for many of the UK’s largest companies, taking care of all the admin, working with you to ensure the perfect course.
- Our expert trainers will first understand your requirements and then tailor each session to your exact specification.
- We offer a free consultation service to work out every detail of your course.
Prices for bespoke sessions with our expert trainers start at £595 + VAT, depending on the course and number of people.
Costs include all preparation time to customise the course to your exact requirements.
Private One-to-One Training
One-to-one tuition tailored to your exact requirements. Your choice of duration, dates and content.
Book NowTeam Training for Companies
Group bookings provide you with the most cost-effective way to train your team.
Book Now
Our Clients
Latest Blog Articles
From Static to Dynamic: Transforming Your Designs with After Effects
Which Text-AI Should You Use for Your Business?
Easy Motion Graphics Using LottieLabWhy Transmedia?
Unlimited Training Support
We offer unlimited training support after your course.
Bespoke Training Solutions
Customised training and software solutions based on your exact requirements.
Worldwide Creative Skills Training
Join our authorised training courses live online from anywhere in the world.
Authorised Training Professionals
Our experts are accredited by Adobe, Apple and Claris and bring years of experience and real-world expertise.