Using Power BI to Automate Data Cleaning and

conchita-marotz

Published 2026-08-12 · 35 slides · 0 views

↓ Download

Using Power BI to Automate Data Cleaning and

Using Power BI to Automate Data Cleaning and - slide 1 of 35

Using Power BI to Automate Data Cleaning and - slide 2 of 35

Using Power BI to Automate Data Cleaning and - slide 3 of 35

Using Power BI to Automate Data Cleaning and - slide 4 of 35

Using Power BI to Automate Data Cleaning and - slide 5 of 35

Using Power BI to Automate Data Cleaning and - slide 6 of 35

Using Power BI to Automate Data Cleaning and - slide 7 of 35

Using Power BI to Automate Data Cleaning and - slide 8 of 35

Using Power BI to Automate Data Cleaning and - slide 9 of 35

Using Power BI to Automate Data Cleaning and - slide 10 of 35

Using Power BI to Automate Data Cleaning and - slide 11 of 35

Using Power BI to Automate Data Cleaning and - slide 12 of 35

Using Power BI to Automate Data Cleaning and - slide 13 of 35

Using Power BI to Automate Data Cleaning and - slide 14 of 35

Using Power BI to Automate Data Cleaning and - slide 15 of 35

Using Power BI to Automate Data Cleaning and - slide 16 of 35

Using Power BI to Automate Data Cleaning and - slide 17 of 35

Using Power BI to Automate Data Cleaning and - slide 18 of 35

Using Power BI to Automate Data Cleaning and - slide 19 of 35

Using Power BI to Automate Data Cleaning and - slide 20 of 35

Using Power BI to Automate Data Cleaning and - slide 21 of 35

Using Power BI to Automate Data Cleaning and - slide 22 of 35

Using Power BI to Automate Data Cleaning and - slide 23 of 35

Using Power BI to Automate Data Cleaning and - slide 24 of 35

Using Power BI to Automate Data Cleaning and - slide 25 of 35

Using Power BI to Automate Data Cleaning and - slide 26 of 35

Using Power BI to Automate Data Cleaning and - slide 27 of 35

Using Power BI to Automate Data Cleaning and - slide 28 of 35

Using Power BI to Automate Data Cleaning and - slide 29 of 35

Using Power BI to Automate Data Cleaning and - slide 30 of 35

Using Power BI to Automate Data Cleaning and - slide 31 of 35

Using Power BI to Automate Data Cleaning and - slide 32 of 35

Using Power BI to Automate Data Cleaning and - slide 33 of 35

Using Power BI to Automate Data Cleaning and - slide 34 of 35

Using Power BI to Automate Data Cleaning and - slide 35 of 35

Description

Using Power BI to Automate Data Cleaning and Visualization Chris Urban Assistant Director of Data Analytics Planning Analysis Frederick Burrack Director of Assessment Office of Assessment Visualizing Data through Interactive Reports in

Download this presentation From Below

"Using Power BI to Automate Data Cleaning and" is the property of its rightful owner. Permission is granted to download and print the materials on this website for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.

Presentation Transcript

Using Power BI to Automate Data Cleaning and Visualization

Chris Urban
Assistant Director of Data Analytics
Planning & Analysis Frederick Burrack
Director of Assessment
Office of Assessment

Visualizing Data through Interactive Reports in Power BI

Data Dashboards

Relational Data Modeling

Facts Contains fields to break down a Fact Table Dimensions Contains items you want to identify: Sum, average, count, etc.

Long and narrow Duplicated Short and wide Unduplicated Facts Dimensions

Facts FactResponses[StudentID] Dimensions DimStudent[StudentID] Dimensions relate to Facts.
Used as a filter via Key Fields.

Dimensions that surround a
Fact Table are called a “Star Schema”

Automating Data Processes

Power BI Suite Query and Report Creation Power BI Desktop Power BI Service Power BI Gateways Your Institution’s Data ACCESS PUBLISH Adapted from Microsoft.com

Step-by-Step Demonstration

An Introduction to DAX Data Analysis Expressions

Data Analysis Expressions (DAX) Functions used to create reusable measures that analyze data
Basic commands such as COUNT, SUM, AVERAGE, etc.
Generally used in Fact tables to aggregate
Can reference other DAX formulas – no need to re-enter data

Count Responses = COUNT(FactResponses[Response]) Name of the Measure Function Table used to calculate Column Used to Calculate A Basic Measure using DAX

Count Responses = COUNT(FactResponses[Response])

Count All Responses = CALCULATE([Count Responses], ALL(DimResponse))

%Responses = [Count Responses] / [Count All Responses]

Step-by-Step Demonstration

DAX Measures to count Responses Count Responses = COUNT(FactResponses[Response]) Count All Responses = CALCULATE([Count Responses], ALL(DimResponse)) %Responses = [Count Responses] / [Count All Responses]

DAX Measures to count students Count Students = DISTINCTCOUNT(FactResponses[student id]) Count All Students = CALCULATE([Count Students], ALL(DimStudent)) %Students = [Count Students] / [Count All Students]

Publishing and Sharing Query and Report Creation Power BI Desktop Power BI Service Power BI Gateways Your Institution’s Data ACCESS PUBLISH Adapted from Microsoft.com

Sharing Options

Request a Pro License ($25/user/yr):https://www.k-state.edu/its/software/software-licenses/ms-power-bi/

K-State Power BI Users Groupemail Chuck Gould – chuck@ksu.edu K-State Power BI Slack Channel
ksupowerbi.slack.com

What about the data warehouse?

Resource Documents

Questions & Discussion Using Power BI to Automate Data Cleaning and Visualization Thanks for coming!

Using Power BI to Automate Data Cleaning and

Related Topics

Share

Embed code

Download this presentation From Below

Presentation Transcript