automating microsoft power bi creations 2015
TRANSCRIPT
![Page 1: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/1.jpg)
©2015 DesignMind. All Rights Reserved.
April 2015 San Francisco, CA
Angel AbundezVP Business Intelligence, DesignMind
![Page 2: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/2.jpg)
2
What we’ll cover
http://www.sqlpass.org/summit/2014/Sessions/Details.aspx?sid=6465
![Page 3: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/3.jpg)
3
Excel 2013 Power BI (v1)• Data formatter (ETL)• Import from Web, Flat Files, Database, or SaaS
• Extensible with M query language
Power Query
• Import, Model and Analyze data with high performance
• Create new Fields and Metrics w/ Excel-like formulas (DAX)
• Join Excel data with SQL
Power Pivot
• Interactive Data Visualization
• Scatter Plots• Maps• Free form dashboard design
Power View
• 3D rendered Map imaging• Record time-lapse videos of how data changes in geographies
Power Map
![Page 4: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/4.jpg)
4
Power BI Designer (v2)
(Power Query/Power Pivot) (Power View)
![Page 5: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/5.jpg)
Data Analyst Production Cycle
Design Validate Update
![Page 6: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/6.jpg)
Design Validate Update
We’ll focus on this end of the Cycle in this session
Data Analyst Production Cycle
![Page 7: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/7.jpg)
7
Power BI Creation Complete
![Page 8: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/8.jpg)
8
©2014 DesignMind. All Rights Reserved.
![Page 9: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/9.jpg)
9
Typical End User Requests post-report dev
![Page 10: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/10.jpg)
Patrick developed a report that shows week over week Margins and wants to share that with the rest of his group
![Page 11: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/11.jpg)
What do we use?
Office 365
• Data Management Gateway• PowerPivot• PowerQuery
Power BI Preview
• SSAS Connector
• OneDrive
Something else?
• ?
![Page 12: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/12.jpg)
Data Management Gateway
![Page 13: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/13.jpg)
Refreshing Data in Power BI v11. Setup Data Management Gateway and Data
Source(s) in Power BI Admin Center2. Use published OData Feeds in Power Query
![Page 14: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/14.jpg)
14
Reference: http://www.sqlchick.com/entries/2014/4/29/data-source-connectivity-for-scheduled-data-refresh-in-power-bi
Data Management Gateway in Office 365
![Page 15: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/15.jpg)
15
Refresh Data in Power BI v2 (in Preview)
1.2.
![Page 16: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/16.jpg)
16
Power BI SSAS Connector
Reference: http://sqlmag.com/sql-server/how-configure-power-bi-preview-premise-analysis-services-data-sources
![Page 17: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/17.jpg)
17
One Drive
Reference: http://support.powerbi.com/knowledgebase/articles/471009-excel-data-stored-in-onedrive-for-business
![Page 18: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/18.jpg)
What does Patrick use?
Office 365
• Data Management Gateway• PowerPivot• PowerQuery
Power BI Preview
• SSAS Connector
• OneDrive
Something else?
• Powershell
![Page 19: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/19.jpg)
Power BI refresh with PowerShell
Create a Power BI Dashboard from One Drive
![Page 20: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/20.jpg)
Kate’s made a cool Power View dashboard with SalesForce data and wants to keep it refreshed in DropBox for others to use.
![Page 21: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/21.jpg)
What does Kate use?
Office 365
• Data Management Gateway• PowerPivot• PowerQuery
Power BI Preview
• SSAS Connector
• OneDrive
Something else?
• ?
![Page 22: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/22.jpg)
22
![Page 23: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/23.jpg)
23
Power Update
![Page 24: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/24.jpg)
24
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 25: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/25.jpg)
25
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 26: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/26.jpg)
26
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 27: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/27.jpg)
27
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 28: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/28.jpg)
28
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 29: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/29.jpg)
29
Power Update
Reference: http:/ /www.powerpivotpro.com/2015/02/ introducing-power-update/
![Page 30: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/30.jpg)
30
Power Update Additional Features
![Page 31: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/31.jpg)
31
©2014 DesignMind. All Rights Reserved.
This changes everything
DOUBLE CUP!!!!
![Page 32: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/32.jpg)
What does Kate use?
Office 365
• Data Management Gateway• PowerPivot• PowerQuery
Power BI Preview
• SSAS Connector
• OneDrive
Something else?
• Power Update
![Page 33: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/33.jpg)
Power Update Demo
![Page 34: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/34.jpg)
34
Recap
![Page 35: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/35.jpg)
35
Contact Info
![Page 36: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/36.jpg)
36
About DesignMind
![Page 37: Automating Microsoft Power BI Creations 2015](https://reader037.vdocuments.us/reader037/viewer/2022103018/55a8a0361a28abfc588b46c9/html5/thumbnails/37.jpg)
37
©2015 DesignMind. All Rights Reserved.
Our Clients