Microsoft Power BI
This course is suitable for those wanting to gain an understanding of how to build Reports and dashboards using Power BI Desktop.
Business Intelligence techniques such as data modelling, manipulation and calculation to visualise data gathered from corporate data sources such as Excel are covered as well as publishing the finished Report to Power BI Online to share with others. Attendees should have a basic understanding of using business programs such as Excel and other Office programs.
Power BI Overview
- Introduction, Outline & Objectives
- Power BI Terminology
- Data Sources, DataSets, Fields, Measures, Tiles Visualisations, Pages and Reports
- Power BI Process
- Connecting to Data
- Manipulating and Modelling Data
- Creating Visualisations on the Report Page
- Formatting and Filtering Visualisations
- Creating and Publishing Reports in Power BI
Getting Data
- Connecting to File based Data
- Connecting to Excel Spreadsheets
- Access Databases
- Text Files
- Connecting to Service based Data
- Cloud Based Data Sources (OData)
- SharePoint Lists
- Other Web Sources
Query Editing (desktop only)
- Data Manipulations
- Column Transformations
- Using Query Editor
- Grouping within Columns
- Appending Queries
- Applied Steps
- Closing and Applying Changes
Data Modelling and Relationships
- Data Modelling
- Relationships in Data (desktop only)
- Viewing Relationships
- Creating new Relationships
- Editing Relationships
Calculating Data using DAX (desktop only)
- Creating a calculated column
- Completing DAX Formulae
- DAX Language
- DAX Data Types, operators
- DAX Functions
- Date, Time Intelligence Functions
- Mathematical, Logical, Text and Statistical Functions
- Showing RELATED Columns
- Date Calculations
- Debugging Expressions
- Conversion Errors
- Empty or missing values
- Adding Measures
- Setting the Measure’s Home Table
- Columns vs. Measures
- Creating New Calculated Tables
Visualisations
- Visualising Data
- Adding Visualisations to Report Page
- Types of Visualisation
- Tables and Conditional Formatting
- Pie, Line, Combination Charts
- Maps and Geographic data
- KPI Cards
- Slicers and Filtering
- Adding and Formatting Slicers
- Filtering at Page, Report and Tile Level
- Drill Through Filters
- Formatting Visualisations
- Formatting Options
- Tile Properties
- Manipulating Tiles
- Tile Menu, moving and deleting
- Viewing, Spotlighting and exporting Tile data
- Report Pages
- Adding and Formatting Report Page
- Duplicating Report Pages
- Adding Shapes to the Report Page
- Text boxes, images and buttons
Publishing Power BI and Dashboards
- Publishing Power BI Reports
- Create and Share Internally and Externally
- Creating a Workspace
- Publishing Reports to Power BI from Desktop
- Dashboards in Power BI Online
- Dashboards vs Reports
- Creating a Dashboard
- Dashboard Menu
- Duplicating an Open Dashboard
- Adding Tiles to a Dashboard
- Adding Web Content
- Adding an Image, Text Box & Video
- Pinning Tiles and Report Pages
- Printing a Dashboard
- Dashboard Options
- Sharing Dashboards
- Sharing Process
- Stopping Sharing
- Sharing Outside the Organisation
- Limitations and considerations
- Troubleshoot sharing
Data Refresh
- Refreshing Datasets
- Refresh Strategies
- Refresh Local Files
- Refresh Cloud Files
- Refresh internal Data Connections
- Refresh Cloud Data
- Scheduled Refresh
- Manual Refresh
Q&A Session
- Questions
- Editions and Licenses
- Getting Data
- Internal DB & Excel data
- Cloud and Web Services
- Desktop or Power BI?
- Visualisations
- Dashboards
- Sharing
- Refreshing
- Sharing and Publishing
Programme Delivery
This course is delivered over 1 day from 9.30am to 4.30pm.
Next Course Dates
Next course start dates:
17/06/2024
24/02/2025
Further Information and Booking
If you're interested in this course then please contact us:
Business Partnerships, York College, Sim Balk Lane, York, YO23 2BB
Email: businesspartnerships@yorkcollege.ac.uk
Tel: 01904 770368 option 1
Fee:
£110
Microsoft Word Intermediate
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Level 1
Unconscious Bias, Diversity and Inclusion
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2025
Duration
1/2 day
Level
Level 1
Social Media Basics for your Business
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
April 2025
Duration
1 day
Level
Level 5
Introduction to MS Teams in Office 365
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Facilitation Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2025
Duration
1 day
Level
Email Etiquette
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1/2 a day
Level
Disciplinary and Investigation skills training for Managers
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2025
Duration
1 day
Level
Social Media Strategy Building and Blogging Tips
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 day
Level
Social Media Strategy Building with Google Business Profile
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 day
Level
18th Edition
A Level
Access to HE
Short courses
Subject Area
Business & Professional Short Courses, Digital Technologies
Study Mode
Apprenticeship, Various Available
Start Date
Variable
Duration
TBC
Level
Level 1, Level 2
Intermediate Management and Supervisory Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2024
Duration
2 Days
Level
Microsoft SharePoint
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
Introduction to Coaching
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2024
Duration
1 day
Level
IOSH Managing Safely
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
July 2024
Duration
3 days
Level
Presentation Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
2 Days
Level
Microsoft Office365 for Homeworkers
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 Day
Level
Excel Intermediate
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2024
Duration
1 Day
Level
Excel Advanced
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2024
Duration
1 day
Level
Excel Introduction
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
April 2024
Duration
1 Day
Level
Managing Difficult Conversations
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
-
Duration
-
Level
Introduction to Management and Supervisory Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
July 2024
Duration
2 Days
Level
Assertiveness
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
November 2024
Duration
1 Day
Level
