Overview

This 1-day workshop (which can be delivered face-to-face or virtually) will give you a good understanding of how to connect to data, clean it up, write formulas (measures) to do the calculations you need and to how to present your data in compelling graphics (visualizations). To do this, you will get a good understanding of Power Query and Power BI Desktop, the two applications that do all the work. You will also be introduced the DAX (Data Analysis Expressions), the formula language for Power BI Desktop and you will have a brief look at “M”, the formula language for Power Query.

Workshop Outcomes

Understand the family of Microsoft Power products
Navigate around Power BI Desktop
Get data and clean it up
Understand the data model and improve it
Create formulas (measures) to analyze your data
Present the data with visualizations

Topics Covered

The Microsoft family of Power products
Various data sources and ways of connecting to them
Power Query and "M" formula language
Power BI Desktop tables and their relationships
DAX (Data Analysis Expressions) formula language
The principles of good data presentation design

Who is this workshop for

If you work with data, in any role (from administrative/support to data analyst to business analyst) and need to present it to others, this workshop is for you.

Handouts/materials provided

The workshop uses a generic dataset provided by Microsoft and obviEnce©(www.obvience.com). But do bring a sample of your data if you would like to talk about it. You will also be given a manual to follow during training and for future reference.

What to bring

A laptop running Windows 10 or 11 with the latest version of Power BI Desktop installed and set up. Optionally, bring a mouse. Using a mouse is more efficient than the touchpad (but that it up to you).

Facilitator

Pamela Beddow MS Office & Project Manage

Having been a senior executive (Wing Commander) in the Royal Australian Air Force, Pam is an experienced leader, manager and project manager. During her military career, Pam recognized that computers would be a great productivity tool if used well and quickly gained her qualifications as a Microsoft Office Master (Excel, Word, PowerPoint, Access), a Microsoft Certified Technology Specialist (MS Project) and as a business programmer. In 2016, following the advent of “big data”, Pam realized that data workers needed to know how to present their findings. So she became proficient in Power BI Desktop and data visualization design.
Throughout her three careers – as a military officer, as a database designer and developer, and as a learning and development facilitator – Pam has applied her project management and computing skills to “get the job done” with a minimum of wasted effort. She understands the issues and effort workers face and how to use computers to help.
In addition, the basis for all Pam’s professional achievements is excellent communication. She is able to explain complex concepts in plain and simple terms which makes the learning journey an enjoyable experience.

Back to Overview

Pamela Beddow MS Office & Project Manage

About the facilitator

Having been a senior executive (Wing Commander) in the Royal Australian Air Force, Pam is an experienced leader, manager and project manager. During her military career, Pam recognized that computers would be a great productivity tool if used well and quickly gained her qualifications as a Microsoft Office Master (Excel, Word, PowerPoint, Access), a Microsoft Certified Technology Specialist (MS Project) and as a business programmer. In 2016, following the advent of “big data”, Pam realized that data workers needed to know how to present their findings. So she became proficient in Power BI Desktop and data visualization design.
Throughout her three careers – as a military officer, as a database designer and developer, and as a learning and development facilitator – Pam has applied her project management and computing skills to “get the job done” with a minimum of wasted effort. She understands the issues and effort workers face and how to use computers to help.
In addition, the basis for all Pam’s professional achievements is excellent communication. She is able to explain complex concepts in plain and simple terms which makes the learning journey an enjoyable experience.

Based in:

Ask a Question

Pamela Beddow MS Office & Project Manage

About the facilitator

Having been a senior executive (Wing Commander) in the Royal Australian Air Force, Pam is an experienced leader, manager and project manager. During her military career, Pam recognized that computers would be a great productivity tool if used well and quickly gained her qualifications as a Microsoft Office Master (Excel, Word, PowerPoint, Access), a Microsoft Certified Technology Specialist (MS Project) and as a business programmer. In 2016, following the advent of “big data”, Pam realized that data workers needed to know how to present their findings. So she became proficient in Power BI Desktop and data visualization design.
Throughout her three careers – as a military officer, as a database designer and developer, and as a learning and development facilitator – Pam has applied her project management and computing skills to “get the job done” with a minimum of wasted effort. She understands the issues and effort workers face and how to use computers to help.
In addition, the basis for all Pam’s professional achievements is excellent communication. She is able to explain complex concepts in plain and simple terms which makes the learning journey an enjoyable experience.

Based in:

Ask a Question

Power BI Desktop - Presenting data for your boss (and others)