20211007- Power BI Developers - Use Cases , Examples

Owned by Ann Crawford (Unlicensed)
Last updated: Oct 07, 2021
1 min read

Meeting Details

Date/Time/Location


Attendees

AttendeePresentNotes
Eric Johnstone

(tick)


Adam Sottosanti (Deactivated)

(error)


Mike Smith

(tick)

Mara Morrison

(tick)
Ann Crawford (Unlicensed)(tick)
Mark Norstedt(tick)

Amy Pasko

(error)


Kam Kunimoto

(error)


Kevin Wu

(error)
Michael Nesbit (Unlicensed)(tick)
Darshan Etz

(tick)


Anna Lin

(error)


ajhinojosa@ucsb.edu

(error)


Dawn Gregory(tick)
Bruce Miller

(error)


Ankit Chhalotre

(error)


Kara Nowell

(error)


Susan Harris(tick)
Roger Chen

(error)


Diana Antova

(tick)


Tedi Tehrani(error)
Nathan Yee(tick)
Katie Mankins(error)
@Gajender Singh(error)
Pam Layton(tick)
Julie Inami(tick)
Lisa Goto

(tick)


Alyssa Keehan (Unlicensed)(tick)

Brian Shivliey

(error)
@mihoko Jones

(error)


Elise Meyer(error)


Meeting Goals and Expected Preparation

Goals

  • Push the use cases and processes for Power BI

Helpful Preparation

  1. Review your content in PBI usage  Usage Report 

Agenda


TimeTopicOwner
5Welcome - questionsGroup Discussion 
5

Power BI Adoption - Usage Report 

  • usage category review for dev, admin, user
  • Ideas for promotion



15

Report Questions/Examples

Darshan Etz - share

Julie Inami - sahre

Susan Harris - share




Group
15

Incremental Refresh

  • How to do it
  • Is it faster more reliable?

Michael Nesbit (Unlicensed), Mark Norstedt

Group

10

Working through report examples

  1. Drill through  ???
  2. Using today() in a dataflow(eg. Is student in housing today?)
  3. Other questions/ examples

Group Discussion 


15

Other questions 

All

Discussion

Julie Inami showed the dataflow promotion error.  Team suggested deleted dataflow from test and retrying promote from dev.  PBI was spinning so it could not finish.

Susan Harris showed the report on units and courses.  Added measures total units per quarter. Added  quarter filter.  This is good progress

Darshan Etz showed the ETS report on SQL datawarehouse accounts. 

Where should we get the employee data? Currently PBI uses three separate sources: SQL datawarehouse db, indentity staging db and ETS API.  Ann Crawford (Unlicensed) is working on a definition. Darshan Etz mentioned that this data is probably owned by HR and may need to be joined with identity data. 

Several people had performance issues this week.  Next week we can review  dataflow incremental refresh. 



 Action Items

  •  Post a comment here stating the result of the dataflow promotion - Julie Inami