cross

BIGGEST CHRISTMAS SALE !

red-starWHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course Information

Microsoft Power BI for End Users 55400AC course outline

Module 1: Introduction to Power BI

  • What is Business Intelligence?
  • Introducing Power BI
  • Power BI Tools and Services
  • Power BI Report Server
  • Power BI (Online)
  • Power BI Desktop
  • Case Studies
  • Support and Information
  • Data Stories

Lab: Getting Ready

  • Sign in to Office 365
  • Download Course Files
  • Place Data Sources into OneDrive
  • Create Further User Accounts

Module 2: Requirements Gathering

  • Welcome to House Rules Board Games
  • Beginning a BI Project
  • Grain Statements
  • Data Discovery
  • Refining Information
  • Modeling Data
  • Building Reports
  • Roles
  • Publishing
  • Creating Dashboards
  • Choosing Workspaces
  • Create and Share a Report in Power BI

Lab: Build a Report in Power BI Web

  • Connect to an Excel Spreadsheet
  • Build Visualisations
  • Create a Dashboard for Desktop and Mobile Users
  • Share Your Report and Dashboard

Module 3: Extract, Transform, and Load Data

  • Creating a Project with Power BI Desktop
  • Pinning an Active Project
  • What is in a PBIX File?
  • Connecting to Data Sources
  • Managing Data Connections
  • Refine Data with Power Query
  • Applied Steps
  • M Code Language
  • Designing Your Query
  • Choose Columns
  • Rename Columns
  • Moving Columns
  • Formatting Columns
  • Replacing Values
  • Expanding Related Columns
  • Star Schemas
  • Merge Columns
  • Split Columns
  • Custom and Conditional Columns

Lab: Starting a Project in Power BI Desktop

  • Creating a New PBIX Project File
  • Connecting to Data Sources
  • Use the Query Editor to Refine Data
  • Review the Table Relationships
  • Optional – Connect to an Azure SQL Database

Module 4: Creating a Data Model

  • Understanding Relationships
  • Cardinality
  • Cross Filter Direction
  • Hiding Tables and Columns
  • Formatting Columns
  • Introducing DAX
  • Designing Calculated Columns
  • Creating Measures
  • Adding Lookup Tables
  • Structuring Data with Dimensional Hierarchies
  • Roles and Row Level Security

Lab: Designing a Data Model

  • Hide and Format Table Columns
  • Create Calculated Columns
  • Create Measures
  • Using Geographical Data and Lookup Tables
  • Create a Dimensional Hierarchy

Module 5: Designing Reports

  • Adding Pages and Navigation Buttons
  • Using Shapes, Text, and Images
  • Creating a Theme
  • Adding Visualisations
  • Using Filters and Slicers
  • Controlling Filters
  • Adding Drill Throughs
  • Adding Custom Visualisations
  • Configure Phone Layouts
  • Report Tips

Lab: Creating a Report

  • Creating New Pages and Adding Basic Content
  • Adding and Configuring Visualisations
  • Design Slicers
  • Create Bookmarks and Navigational Buttons

Module 6: Using Workspaces and Dashboards

  • Power BI Licensing
  • My Workspaces
  • App Workspaces
  • Premium Capacity Workspaces
  • Creating a New Workspace
  • Publishing a Project
  • Parallels with Microsoft Excel
  • Publishers and Viewers
  • Reconnecting with Data Sources
  • Introducing the On-Premises Data Gateway
  • Scheduling the Data Refresh Frequency
  • Assigning Security Roles
  • Creating and Populating Dashboards
  • Customising Dashboard Tiles
  • Creating Tiles Using Q&A and Quick Insights
  • Creating a Mobile Dashboard
  • Sharing Reports and Dashboards
  • Publishing Apps in a Workspace
  • Publishing Content to Websites

Lab: Publish and Share Reports and Dashboards

  • Publish Your Project to Power BI
  • Create a Dashboard
  • Use Quick Insights and Pin Visuals
  • Use Q&A to Query Your Data Source
  • Share Your Dashboard with Marketing

Show moredowndown

Who should attend this Microsoft Power BI for End Users 55400AC Training?

The Microsoft Power BI for End Users 55400AC Training is designed to be accessible, making it a good fit for professionals at various levels of an organisation who are looking to make data-driven decisions.

The following professionals will benefit the most from this course:

  • Business Analysts
  • Data Enthusiasts
  • Excel Users
  • Non-technical Staff
  • Managers and Executives
  • Sales and Marketing Professionals
  • HR Professionals

Prerequisites of the Microsoft Power BI for End Users 55400AC Training

For the Microsoft Power BI for End Users 55400AC Training, prerequisites generally include basic computer literacy, familiarity with Microsoft Office applications like Excel, and an understanding of fundamental data concepts like tables and charts.

Microsoft Power BI for End Users 55400AC course overview

This course is for individuals that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. You will be taken on a journey from the concepts of a Power BI project right through to the result in an engaging and structured format. You will get hands on with a wealth of data to practise the techniques taught by this course.

After taking this course you will be able to:

  • You will know which Power BI tool to use for different projects.
  • You will be able to connect to and maintain connections to data sources.
  • You can query your data sources to refine the data you are pulling into your project.
  • You can optimise a data model to enhance the performance of your reports.
  • You will know how to use Data Analyses eXpression (DAX) language to create columns and measures.
  • You can create dimensional hierarchies and plot geographical data.
  • You can create engaging, visual reports from your data model.
  • You’ll be able to publish your project to a workspace and manage it from the Power BI web service.
  • You will be able to build dashboard to aggregate essential visuals from reports.
  • You well be able to share your reports to colleagues.

Show moredowndown

What’s included in this Microsoft Power BI for End Users 55400AC Training?

  • World-Class Training Sessions from Experienced Instructors
  • Digital Delegate Pack

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

best_trainers

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.

venues

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

small_classes

Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

value_for_money

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

tailored_learning_experience

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

budget

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

team_building

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

monitor_progress

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Microsoft Power BI for End Users 55400AC FAQs

Please arrive at the venue at 8:45am.
No previous experience of Power BI is required
This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 2 days'
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Microsoft Power BI for End Users 55400AC certification in the United Kingdom starts from £1995
The Knowledge Academy is the Leading global training provider for Microsoft Power BI for End Users 55400AC.

Why choose us

icon

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

icon

Trusted & Approved

Microsoft Gold Learning Partner

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Microsoft SQL Server Training?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.