1 / 27

Make Cloud BI Work for You

Make Cloud BI Work for You. Gilad Elyashar Chuck Heinzelman David Magar. Please silence cell phones. Abstract.

shilah
Download Presentation

Make Cloud BI Work for You

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Make Cloud BI Work for You Gilad Elyashar Chuck Heinzelman David Magar

  2. Please silence cell phones

  3. Abstract • Not all business intelligence needs are the same; if they were, this world would be a very boring place. With Microsoft's BI offerings in Azure, you have the flexibility to create the BI environment that best fits your needs. Whether you need traditional SQL Server Reporting Services, PowerPivot, or full-blown Power View, Azure provides the building blocks for your solution. Join this scenario-based, demo-driven presentation to learn how you can build and leverage Azure-based Reporting Services, PowerPivot, and full Infrastructure as a Service BI options.

  4. Welcome to the Azure Playhouse • The Businesses in Your Neighborhood • A Play in Three Acts

  5. Act 1 – It Mashes, It Slices, It Dices • The Setting You are a catalog retailer. You’ve been experiencing problems with your shipping pipeline that is causing customer dissatisfaction. You are not sure exactly which carriers are causing the problems, but you believe that most of your problems are geographically isolated.

  6. Traditional Business Intelligence Traditional BI Provision Dashboards and scorecards Analysis Reports Data Staging Analysis cubes Datawarehouse ETL/Data Quality IT Professional Existing Data LOB applications Data marts Files

  7. Meet Anna

  8. Anna’s Day to Day

  9. Evolution of Business Intelligence Traditional BI Self-service BI Provision End Users Dashboards and scorecards Analysis Reports Data Staging Analysis cubes Datawarehouse Spreadsheets ETL/Data Quality Existing Data IT Professional LOB applications Data marts Files Specialized tools

  10. 2010 Self-service Modeling Prepare Data

  11. 2012 Self-service Modeling Create Reports

  12. 2012 Sharing

  13. Install BI Features with SharePoint

  14. 2013 Self-service Sharing

  15. BI with SharePoint Online

  16. Demo Mashing up Data and Hosting in O365

  17. Act II – It’s Centralized…Of Course We Can Grant You Permissions • The Setting I own 3 local pizza restaurants, each with a stand-alone Point of Sale system. There’s no easy way to get an overall view of my entire company The Need Make the overall Pizza operations more efficient The Solution You, a BI-Selling consultant, specializing in Point of Sale solutions, offer me an affordable centralized viewpoint for my Pizza business data

  18. Demo Presenting a global View of Data with Windows Azure SQL Reporting

  19. Act II Cont’d – A Pizza Business problem • The Setting Prices for ingredients keep changing, I keep some track of what I bought and when but I wish I could understand my profitability … The Need Mash-up my purchase tracking with my ongoing operational data. The Solution You, my BI consultant, import additional data into the data store and show me what I need on a dedicated report!

  20. Demo Adding more data and drilling through…

  21. Cost Effectiveness Analysis - Pricing model: 0.16$/hr per 0-30 renders Volatility is LOW Peak production @ ~24/hr usage  600$ • No machine management • No specialized tools • No extra licensing fees • Fast time to production • Global reach through any device • Monthly Costs: • Azure SQL DB (5 Gb) – ~26$ • Azure SQL Reporting – ~115$ • Total: <150$/month

  22. But Hey… What do we know… • Check out how an IT reseller spun up a new business on the RS Team blog

  23. Act III – We Need It, But They Won’t Build It • The Setting You work in the marketing department at a regional retail chain that recently ran a major marketing campaign. You need to analyze the data from your campaign, but your IT department doesn’t have a suitable environment – and they told you building one would take 6 – 12 months!

  24. Windows Azure Virtual Machines • Virtual Machines (just like on-prem) hosted in Azure • Gallery Images • Bring Your Own Image • Bring Your Own VM • Integrates Into Windows Azure Virtual Networks • Can Be Joined To On-Prem Domains • Storage to Suit Your Needs • VHDs Stored in Azure Blob Storage • Up to 16TB of Storage Per VM

  25. Demo Running SharePoint BI in Windows Azure Virtual Machines

  26. Conclusion • Not all business intelligence needs are the same; if they were, this world would be a very boring place. With Microsoft's BI offerings in Azure, you have the flexibility to create the BI environment that best fits your needs. Whether you need traditional SQL Server Reporting Services, PowerPivot, or full-blown Power View, Azure provides the building blocks for your solution. Join this scenario-based, demo-driven presentation to learn how you can build and leverage Azure-based Reporting Services, PowerPivot, and full Infrastructure as a Service BI options.

  27. Thank you! Diamond Sponsor

More Related