building your myth busting lab with power bi - julie koesmarno · set initial myth get the right...

56
Building Your Myth Busting Lab with Power BI julie koesmarno (@MsSQLGirl) LobsterPot Solutions 19 July 2014

Upload: others

Post on 21-May-2020

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Building Your Myth Busting Lab

with Power BI

julie koesmarno (@MsSQLGirl)

LobsterPot Solutions

19 July 2014

Page 2: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

2 | 2 |

Don’t try this at home

Failure is an option

Holy Crap, that’s cool!

I reject your reality and substitute my own

What could go wrong?

Busted, Confirmed, Plausible

Page 3: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

about me10 years experience with SQL Server

Power BI & Tabular Model Enthusiast

Improving your data story

Co-chapter Leader of

Volunteer at &

PASS Virtual Chapter Mentor

Page 4: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Accidental learning of some myths

around Driving may be unavoidable

Page 5: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Myth Bustingand Data Professionals

Page 6: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Gather data,

set initial myth

Construct

objects to test

myths

Plan

repeatable

tests

Perform the

tests and

record results

Expand

circumstances

Share with

others

Draw

conclusion

7/22/2014 |6 |

Page 7: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Gather data,

set initial myth

Construct

objects to test

myths

Plan

repeatable

tests

Perform the

tests and

record results

Expand

circumstances

Share with

others

Draw

conclusion

7/22/2014 |7 |

Business

performance,

Speculations

Search for new

/ use existing

data

Create a data

model if

needed

Query the data

modelAnalyse /

explore results

Share with

others

Draw

conclusion

Page 8: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

myths on driving

Page 9: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

minutes

Page 10: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

workshop / lab

Page 11: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Power BIOffice 365

Page 12: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Myth #1:Sunday Drivers

Page 13: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Sunday

Page 14: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 15: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 16: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 17: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 18: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Saturday has higher fatalities

and volume of driver incidents

Page 19: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

We have not compared percentage

of fatalities over volume of traffic

Page 20: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Myth #2:Highway Phobia

Page 21: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Highway

Page 22: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 23: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 24: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 25: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 26: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

CA, TX and GA have highest fatalities,

and have either wide or more

highways than other states

Page 27: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Further research on Fatalities over

each Road Type Volume

Page 28: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Myth #3:Lunatic drivers

Page 29: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Lunatic

Page 30: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 31: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 32: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 33: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 34: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

“Lunatic” related to Lunar phase.

There are more fatalities around

New Moon!

Page 35: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

People avoid driving on Full Moon?

Page 36: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Beyond Mythbusting

Page 37: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

try this!Power BI Q&A

Page 38: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

7/22/2014 |39 |

Page 39: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

show timePower Map

Page 40: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

7/22/2014 |41 |

Page 41: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

forecastingPower View on Office 365

Page 42: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions
Page 43: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

collaborateOffice 365 Power BI Site

Page 44: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

7/22/2014 |45 |

Page 45: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

portablePower BI App, Office 365 Online

Page 46: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

7/22/2014 |47 |

Page 47: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Wrap it up!

Page 48: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Power BI

Page 49: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Self Service BI

Page 50: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Collaborative BI

Page 51: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Mythbusting BI

Page 52: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Gather data,

set initial myth

Get the right tools / platform

for testing

Design

repeatable

tests

Perform the

tests

Ask questions

/ explore more

myths

Share with

others

Draw

conclusion

7/22/2014 |54 |

Page 53: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Gather data,

set initial myth

Get the right tools / platform

for testing

Design

repeatable

tests

Perform the

tests

Ask questions

/ explore more

myths

Share with

others

Draw

conclusion

7/22/2014 |55 |

Power Query

Power BI

Office 365

Power Pivot

Power View

Power Map

Pivot Table / Charts

Power View

Power BI Q&A

Power BI Site

Power BI App

Office 365

you + team

Page 54: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

further reading

Power BI -

http://powerbi.com/

Chris Webb’s Power BI articles

https://cwebbbi.wordpress.com/category/power-bi/

Power BI Getting Started

http://www.microsoft.com/en-us/powerBI/support/default.aspx?topic=getting-started

Matt Masson’s Power Query blogs

http://www.mattmasson.com/category/power-query/

Myth Busting Driver Fatalities Using Power BI

https://www.youtube.com/watch?v=hSig8_TKsyo

56 | 56 |

Page 55: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

contact me

7/22/2014 |57 | 57 |

Email [email protected]

Blog http://www.mssqlgirl.com

Twitter @mssqlgirl

LinkedIn http://www.linkedin.com/in/juliekoesmarno

Page 56: Building Your Myth Busting Lab With Power BI - Julie Koesmarno · set initial myth Get the right tools / platform for testing Design repeatable tests Perform the tests Ask questions

Thank youand please drive safely!