Self-Service BI synergies, Tableau Software supplements versus replaces the Microsoft BI Stack. Fast rapid analytics and visualizations, ease of use, any data..
Presented @ DevTeach Conference in Vancouver, BC December 4, 2013
I’m a Database & Business Intelligence Professional and Founder | CEO of and also a SQL Server MVP. I have a passion for architecFng, designing and building soluFons that ma2er. Self proclaimed Open Data Hacker/Advocate I founded GaFneau Ouverte a ciFzen led iniFaFve which aims to promote open access to civic data of the city of GaFneau. Twi2er: @sfreche2e Blog: stephanefreche2e.com Email: [email protected]
• Self-‐Service Business Intelligence in Excel – Power BI • Power Pivot, Power Query, Power View, Power Map – Power BI Office 365 • Tableau SoRware • Versions • Core Technologies • MicrosoR Data Sources • Business IntegraFon • SharePoint, PowerPoint • Demos • Summary • Resources
Services Master Data Services SharePoint Collaboration Excel Workbooks Power Pivot Applications SharePoint Dashboards & Scorecards Data Quality Services OData Feeds Line of Business ApplicaFons Hadoop Big Data Microso0 Business Intelligence
intuiFve capabiliFes for self-‐service BI § Power Query (codename Data Explorer) § Power Pivot (previously PowerPivot) § Power View § Power Map (codename GeoFlow) (That’s A Lot of Power!)
add-‐in that enhances the self-‐service Business Intelligence experience in Excel by simplifying data discovery and access. Enable self-‐service data discovery, query, transformaFon and mashup experiences for InformaFon Workers, via Excel and Power Pivot • Discovery and connecFvity to a wide range of data sources, spanning volume as well as variety of data. • Highly interacFve and intuiFve experience for rapidly and iteraFvely building queries over any data source, any size. • Consistency of experience, and parity of query capabiliFes over all data sources. • Joins across different data sources; ability to create custom views over data that can then be shared with team/department.
storage and provide fast querying and reporFng from tabular data • xVelocity in-‐memory analyFcs engine (formerly VerFPaq) • Highlights; • Load data from a variety of sources • Extremely large volumes can be stored • Data Analysis Expressions (DAX) • Can be enriched with Hierarchies, KPIs, PerspecFves and ReporFng metadata • First introduced as an add-‐in with SQL Server 2008 R2
exploraFon, visualizaFon and presentaFon experience • Strong visual design experience (WYSIWYG) • Rich meta-‐driven interacFons • First introduced with SQL Server 2012 ReporFng Services in SharePoint Mode (BI and Enterprise ediFons) • Now part of Excel 2013 (need to enable add-‐in) • Power View sheets can be added to Workbook • Can be based on a Workbook Data Model, or SSAS Tabular Data Model, *SSAS MulFdimensional Model (SQL Server 2012 SP1 CTP3) • Requires Silverlight 5 to be installed
sheets can connect to different data models in one workbook • Modify the internal Data Model without leaving the Power View sheet • Power View in Excel Services, Excel Web App and Office 365 • SharePoint Server • Pie charts • Maps • Key Performance Indicators (KPIs) • Hierarchies • Drill up and drill down • Hyperlinks
you to plot geographic and temporal data visually, analyze that data in 3D, and create interacFve tours to share with others. h#ps://www.microso/.com/en-‐us/download/details.aspx?id=38395 *Requires Microso/ Office Professional Plus 2013 or Office 365 ProPlus.
• Self-‐service analyFcs for everyone • Ease of use to ease your mind • 10-‐100x Faster • Perform mashups • Smart, fit and beauFful dashboards (Personal and Professional EdiFons)
• Mobile Business Intelligence • Blazing speed against massive data • Blend disparate data with a click • Secure informaFon management • Enterprise scalability
• Embed live visualizaFons, no programming needed • Go Mobile • Drive traffic via sharing • Publish updates in seconds (Public Premium – Suppress underlying data)
• Allowing simple drag and drop funcFons to create sophisFcated visualizaFons • In-‐memory Data Engine • Breakthrough in-‐memory data engine • Column storage, architecture aware • Fast performance with massive data • Live Query Engine • A2aches directly to corporate data stores • CompaFble with data of all formats and sizes
• Data Extract API • Administrator Views • Data Source Filters • SharePoint Web Part • Custom User Interfaces • Web Site IntegraFon • PowerPoint Live Views Info: h2p://www.tableausoRware.com/new-‐features/8.0?Fd=1821#feature-‐list
BI provides the tools you need to find data, shape and filter it how you want, model it, and visualize it. • All users can transform data into insight… with the tools they already know Tableau • True Best of Class Visual AnalyFcs and Dashboards • Mobile BI for a wide variety of mobile device types • Strong ApplicaFon IntegraFon, APIs and SharePoint Web Part • Supplements, complements instead of replacing MicrosoR… Try them yourself today!