april 10-12, chicago, il make cloud bi work for you gilad elyashar chuck heinzelman david magar
TRANSCRIPT
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.
5
Act 1 – It Mashes, It Slices, It Dices
The SettingYou 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
Existing Data
LOB applications FilesData marts
Analysis Reports Dashboardsand scorecards
Provision
ETL/Data Quality
Analysis cubes
Datawarehous
e
Data Staging
Traditional BI
IT Professional
9
Evolution of Business Intelligence
Spreadsheets
Specialized tools
Self-service BI
End Users
Existing Data
LOB applications FilesData marts
Analysis Reports Dashboardsand scorecards
Provision
ETL/Data Quality
Analysis cubes
Datawarehous
e
Data Staging
Traditional BI
IT Professional
13
Verify PrerequisitesInstall SQL Server PowerPivot for SharePoint and configure
it
Install Analysis Services OLE DB provider on Excel Service
application servers
Verify a PowerPivot for SharePoint installation• Verify central administration
integration• Verify integration at site level• Verify data access on the
server
Install Reporting Services SharePoint mode as a single
server farm
Install and start the reporting services SharePoint service
Create a reporting services service application
Activate the Power View site collection feature
Install BI Features with SharePoint
17
Act II – It’s Centralized…Of Course We Can Grant You PermissionsThe 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 NeedMake the overall Pizza operations more efficient
The SolutionYou, a BI-Selling consultant, specializing in Point of Sale solutions, offer me an affordable centralized viewpoint for my Pizza business data
19
Act II Cont’d – A Pizza Business problemThe 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 NeedMash-up my purchase tracking with my ongoing operational data.
The SolutionYou, my BI consultant, import additional data into the data store and show me what I need on a dedicated report!
21
Cost Effectiveness Analysis - - 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
- Pricing model: 0.16$/hr per 0-30 renders
- Volatility is LOW- Peak production @ ~24/hr usage
600$
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 ItThe 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
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.