Microsoft Training Course

Table of Contents

, Microsoft Power Bi Training Course

Power BI Introduction Overview

Microsoft Power BI helps you extract, analyse and comprehend large quantities of data – ensuring that you can present data in a logical manner and make informed business decisions. Microsoft Power BI is a user-friendly report-based analytical tool that is transforming the way that businesses read their performance data.

This 1 day, hands-on course will show you how to link and model data in Power BI and then create and share visual reports that reveal data insights.

, Microsoft Power Bi Training Course

Power BI Introduction Five Key Topics

  1. Creating Power BI data models
  2. Understanding table relationships
  3. Creating engaging visuals
  4. Understanding the role of DAX formulas
  5. Publishing and sharing dashboards
, Microsoft Power Bi Training Course

Course Details

Course Duration: 1 day
Course Availability: Monday – Saturday
Course Types: Group booking, 1-2-1 sessions, Bespoke & Public Courses
Course Availability: Monday – Saturday

, Microsoft Power Bi Training Course

Power BI Introduction Training Course Details

Course Location: Our Microsoft Power BI Introduction training courses can be delivered either at our London training venue or at your offices.

Tailored Course Content: Course content can be customised to meet your specific requirements, with scheduled dates to suit you.

Tailored Courses: We offer a free consultancy service to help tailor your course to meet your requirements.

Rate: £220 + VAT

Next Public Course: 1st September 2020

Days
Hours
Minutes
Seconds

Centre and Services

Comfortable & modern facilities
Unlimited access to our online training manuals
Complimentary lunch
Courses delivered by Certified Trainers
Microsoft & CPD courses available

Back to contents

On completion of Microsoft Power BI Introduction

  • Understand the Power BI workflow
  • Connect to various data sources
  • Shape and combine data using the Query Editor
  • Create relationships in the Data model
  • DAX formulas in Power BI
  • Creating visuals on report pages
  • Designing well presented reports
  • Publishing and sharing your dashboards

Microsoft Power BI Introduction Course Outline

  • Power BI Desktop
  • The Power BI service
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Q&A; Natural Language Queries
  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • Data Refresh
  • The Power BI Data Model
  • Optimising the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • Configuring Data for Q&A
  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming Data
  • Combining Data
  • Merging Data
  • Understanding Relationships
  • Viewing Relationships
  • Creating Relationships
  • Cardinality
  • Cross Filter Direction
  • Why do we need DAX?
  • Functions
  • Context
  • Calculated Columns
  • Calculated Tables
  • Measures
  • Managing your Measures
  • Power BI Reports: Page Layout and Formatting
  • Multiple pages
  • Tables and Matrices
  • Creating Charts
  • Using Geographic Data
  • Cards, Gauges and KPI’s
  • Slicers
  • Drillthrough options
  • Report Page Tooltips
  • Buttons and Bookmarks
  • Focus and Spotlight
  • Power BI Themes
  • Create and deploy a custom theme
  • Changing the font size for all visuals and pages
  • Changing the number format for visuals
  • Inserting Pictures, Text Boxes and Shapes
  • Using DAX formulas on Cards to display the current filter value
  • Adding Row-Level Security
  • Publish to Web
  • Publish to the Power BI service
  • Creating a dashboard
  • Content Packs
  • Power BI Apps and Workspaces
, Microsoft Power Bi Training Course
, Microsoft Power Bi Training Course