Power BI, Excel and Office 365: Unlocking the Value of your Enterprise Data

2. Power BI, Excel and Office 365: Unlocking the Value of your Enterprise Data Olav Hubel Ken Puls Yana Terukhova Miguel Martinez BRK3252

3. The story begins in 1440…

4. Printing press Forerunner of the Industrial Age Books became more accessible to more people more accessible to more people

5. Literacy rates Took off with the Industrial Revolution Because reading was required to succeed,creating a literacy culture literacy culture

6. Big Data Helped launch the Digital Age Data became more accessible to more people more accessible to more people

7. Digital Transformation is the next Industrial Revolution Industrial Revolution 4.0

8. Data literacy Is in its infancy, but will explode in just a few years Because business insights are now required to succeed,creating a data culture data culture

9. 18% 80% Companies that use data effectively experience 18% higher gross margins than those that don’t1 80% of all enterprise reporting will be based on modern BI and analytics platforms by 20202 1Keystone Strategy. Sponsored by Microsoft. “The Digital Business Divide.” 2016. 2Gartner: Market Share: Analytics and Business Intelligence, Worldwide, 2016” Jim Hare, Alys Woodward, June 15, 2017

10. Customers want to gain business insights to make better data-driven decisions

11. Customer pain points What’s stopping you from making better decisions? Employees can’t make informed, data-driven decisions fast enough Employees miss key insights due to lack of analytical expertise Old technologies hamper successful collaboration Data security and complianceare big concerns

12. Modern BI

13. Lifecycle of modern BI Get data Collaborate Analyze Publish Visualize

14. Microsoft 365 addresses customer pain points Power BI Office 365Teamwork at enterprise scale with real-time collaboration, versioning, security, and compliance ExcelAnalysis in a familiar environment with the flexibility to connect, shape, and model data to fit your needs Excel Power BIPublish reports securely to your organization and access them from anywhere on any device Power BIVisual data exploration and interactive reporting with a freeform canvas for drag-and-drop exploration

15. Demo Olaf Hubel Miguel Martinez

16. Better together

17. One cloud platform for data visualization Power Query & Power Pivot Power BI Power BI Desktop SharePoint Excel Datamodel Reportdesign

18. Excel and Power BI: better together Microsoft 365 E5 Better together Power BI + Excel Common foundationmeans you’re ahead Familiar user experience Securityand compliance Governance of data

19. Deep into Get and Transform Ken Puls

20. Customer road blocks Everyone will have their own files and data We are not ready to move to the cloud for security concerns Reports won’t scale using Excel and Power BI Our organization doesn’t have time or resources to learn a new tool

21. Stay connected and learn more Learn more about Excel Excel blog on Tech Community Making Excel work for FP&A Guide What Is New in Excel Office Training Center Excel Analytics Capabilities Answers to your Excel questions Office.com/Excel/Help Give us feedback • UserVoice • Share Feedback on Excel Join us • Excel User Community • Excel on Facebook and Twitter

22. Related sessions

23. Please evaluate this sessionYour feedback is important to us! Please evaluate this session through MyEvaluations on the mobile appor website. Download the app:https://aka.ms/ignite.mobileApp Go to the website: https://myignite.techcommunity.microsoft.com/evaluations