DBI-B304 Large-Scale Data Warehousing and Big Data ….pptx

Large-Scale Data Warehousing and Big Data with SQL Server 2012 Parallel Data Warehouse DBI-B304Brian MitchellLead Senior ConsultantMicrosoft Big Data COEBrian by the Numbers…14+ Years working with SQL Server7+ Years at MicrosoftMicrosoft Certified Master – SQL Server 2008Analysis Services Maestro – SSAS 20083+ Years working with SQL Server PDWFacebook Big Data Research 68% Brian 30% Bryan 2% OtherBlog: (#1 blog on SQL PDW)Twitter: @brianwmitchell (Woeful mid-200’s followers)Microsoft’s DW Business Momentum#1 Unit Share for DW All-up (SQL Server)SQL Server Enterprise Revenue Growing > 30% PDW Volume Grew 6x Year Over YearStrategic PDW Customer Wins in Fortune 1000 CompaniesUpgrading SQL Server to PDW Gains 100x Improvement“…basic queries that previously took 20 minutes only took seconds using the SQL Server 2008 R2 Parallel Data Warehouse.” -Tom Settle, Assistant VP, Data Warehousing, Hy-VeeLarge US Grocery Store chain needed an MPP Data Warehouse to improve performance, scale and provide timely data to its Executives and AnalystsPDW offered 100X Query Performance gain over conventional SQL Server, Faster Data loads and more scale with 7 instead of 2 years of purchasing dataPDW will scale to meet future growth and support more functional areas at Hy-VeeBenefitsGartner Magic QuadrantData WarehousingBusiness IntelligenceAbility to ExecuteLeadersChallengersChallengersLeadersAbility to ExecuteMicrosoftMicrosoftNiche playersVisionariesNiche playersVisionariesCompleteness of VisionCompleteness of VisionAs of February 2013“Microsoft exhibits one of the best value propositions on the market with a low cost and a highly favourable price/performance ratio”- Gartner, February 2012Leader in Gartner MQ for DW and BIThe World of Data HAS CHANGEDDataexplosionConsumerization of IT 10x increase every five years4.3 connected devices per adult85% from new data types27%using social media input By 2015, organizations integrating high-value, diverse, new information type