building your myth busting lab with power bi - julie koesmarno · set initial myth get the right...
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/1.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/2.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/3.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/4.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/5.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/6.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/7.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/8.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/9.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/10.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/11.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/12.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/13.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/14.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/15.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/16.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/17.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/18.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/19.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/20.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/21.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/22.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/23.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/24.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/25.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/26.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/27.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/28.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/29.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/30.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/31.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/32.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/33.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/34.jpg)
“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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/35.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/36.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/37.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/38.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/39.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/40.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/41.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/42.jpg)
![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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/43.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/44.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/45.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/46.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/47.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/48.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/49.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/50.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/51.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/52.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/53.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/54.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/55.jpg)
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](https://reader034.vdocuments.us/reader034/viewer/2022042221/5ec74a582f84eb1895630839/html5/thumbnails/56.jpg)
Thank youand please drive safely!