power-bi and sharepoint
DESCRIPTION
Power-BI and SharePoint session at #DevConnections 2014, September 17th in Las Vegas by Martina Grom @magrom and Toni Pohl @atworkTRANSCRIPT
![Page 1: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/1.jpg)
Power BI and SharePoint Online
#devconnections
![Page 2: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/2.jpg)
POWER BI AND SHAREPOINT ONLINE
MARTINA GROM@magromOFFICE 365MVP
TONI POHL@atworkWin. Platform Dev. MVP
Knowledge increases by sharing. So, pass it on!
![Page 3: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/3.jpg)
POWER BI AND SHAREPOINT ONLINE
In this demo focused session we show how the new PowerBI functions within SharePoint Online works and we build a nice demo portal with some custom Datasilos. How can this be automated and what are the most interesting things around PowerBI.
![Page 4: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/4.jpg)
POWER BI AND SHAREPOINT ONLINE
Agenda
1. Data Collection2. Data Preparation3. Built-in Features4. Set-up PowerBI within O3655. Prepare your BI Portal6. Usage and Queries
#devconnections
![Page 5: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/5.jpg)
POWER BI AND SHAREPOINT ONLINE
You cannot manage what you cannot measure
![Page 6: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/6.jpg)
POWER BI AND SHAREPOINT ONLINE
Which Data to use
• Mailreports from Exchange Online• Enterprise Social (Yammer)• Twitter• ERP Systems• …
![Page 7: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/7.jpg)
Mail Reporting
#devconnections
![Page 8: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/8.jpg)
POWER BI AND SHAREPOINT ONLINE
Analyse your Maildata• Built-In• Mailprotection Reports for Office 365
http://www.microsoft.com/en-us/download/details.aspx?id=30716
![Page 9: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/9.jpg)
SESSION TITLE
#devconnections
Demo
![Page 10: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/10.jpg)
Enterprise Social
#devconnections
![Page 11: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/11.jpg)
POWER BI AND SHAREPOINT ONLINE
Analyse Yammer
• Inbound Analytics Dashboard• Inbound Top Users / Top Groups• Export only for verified admins
![Page 12: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/12.jpg)
SESSION TITLE
#devconnections
Demo
![Page 13: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/13.jpg)
POWER BI AND SHAREPOINT ONLINE
https://yammer.azurewebsites.net/
http://blogs.msdn.com/b/richard_dizeregas_blog/archive/2014/04/09/yammer-analytics-with-excel-and-power-bi.aspx
![Page 14: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/14.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 15: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/15.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 16: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/16.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 17: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/17.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 18: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/18.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 19: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/19.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 20: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/20.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 21: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/21.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 22: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/22.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 23: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/23.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 24: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/24.jpg)
POWER BI AND SHAREPOINT ONLINE
You get…
![Page 25: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/25.jpg)
Social Media
#devconnections
![Page 26: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/26.jpg)
POWER BI AND SHAREPOINT ONLINE
Twitter Analysis
• Excel Tool (Retired): http://husting.com/twitter-analytics-for-excel/
• New Tool (in Beta): http://www.plusonesocial.com/
![Page 27: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/27.jpg)
SESSION TITLE
#devconnections
Demo
#devconnections
![Page 28: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/28.jpg)
Set-up Power BI
#devconnections
![Page 29: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/29.jpg)
POWER BI AND SHAREPOINT ONLINE
Power-BI in Office 365
• Set-up Account• Activate BI• Fill in Data• Do your numbers…
![Page 30: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/30.jpg)
POWER BI AND SHAREPOINT ONLINE
In case of…
#devconnections
![Page 31: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/31.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 32: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/32.jpg)
POWER BI AND SHAREPOINT ONLINE
![Page 33: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/33.jpg)
POWER BI AND SHAREPOINT ONLINE
Links• Office 365 Trial
• Mailprotection Reports for Office 365http://www.microsoft.com/en-us/download/details.aspx?id=30716
• https://yammer.azurewebsites.net/ • http://
blogs.msdn.com/b/richard_dizeregas_blog/archive/2014/04/09/yammer-analytics-with-excel-and-power-bi.aspx
• Excel Tool (Retired)http://husting.com/twitter-analytics-for-excel/
• New Tool (in Beta)http://www.plusonesocial.com/
• http://blog.atwork.at/ • http://Delegate365.com #devconnections
![Page 34: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/34.jpg)
Summary
#devconnections
![Page 35: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/35.jpg)
POWER BI AND SHAREPOINT ONLINE
Power BI Summary
…like it?
#devconnections
![Page 36: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/36.jpg)
POWER BI AND SHAREPOINT ONLINE
MARTINA GROM@magromOFFICE 365MVP
TONI POHL@atworkWin. Platform Dev. MVP
Resources:
atwork.atblog.atwork.atdelegate365.com
Thank you!
![Page 37: Power-BI and SharePoint](https://reader037.vdocuments.us/reader037/viewer/2022102716/549a0824b479590a4a8b45a7/html5/thumbnails/37.jpg)
SESSION TITLE
#devconnections
Rate This Session Now!Rate with Mobile App:1. Select the session from the
Agenda or Speakers menus
2. Select the Actions tab
3. Click Rate Session
Rate Using Our Website:1. Register at www.devconnections.com/logintoratesession
2. Go to www.devconnections.com/ratesession
3. Select this session from the list and rate it
Tell Us What You Thought
of This Session
Be Entered to
WIN
Prizes!