introduction to advanced analytics with sharepoint composites
TRANSCRIPT
Introduction to Advanced Analytics with SharePoint Composites
Mark Tabladillo Ph.D. – SQL Server MVP
June 21, 2014
About MarkTab
2
• Atlanta 20 Years
• Georgia Institute of Technology
• SAS and Microsoft SQL Server – Training and Consulting
• Currently employed by SolidQ http://solidq.com
• Website: marktab.net
• Twitter @marktabnet
• Today’s slides were derived from Microsoft’s SQL Server 2014 Developer Training Kit
Today’s Slides
3
• Heavily borrowed from Microsoft’s SQL Server 2014 Developer Training Kit: http://www.microsoft.com/en-us/download/details.aspx?id=41704
• See my past slidedecks: http://slideshare.net/marktab
Source: Big Data & CIO Adoption Quantitative Research, Sept 2012, Microsoft
Challenges to unlocking data insights
Integration with existing tools
41%
Security & manageability
37%
Lack of skills & knowledge
59%
Connected devices per adult
4.3
Self-service BICorporate BI
Evolution of BI
Evolution of BI
Niche Startups
Self-service BICorporate BI
15 years of innovation
SharePoint Composites
9
SharePoint Composites
10
SharePoint Composites
11
“Like T-Shirts:
Small, Medium and Large”
SharePoint Composites
12
Version Number of employees
Type Amount of Code
Expense report features
Time to complete
Comments
1.0 1 to 25 Small Business
EnterpriseTeam
None Mileage re-
imbursement
automatically calculated
based on a list, list form, and formulas
Two days A quick solution
1.1 26 to 50 Small Business
EnterpriseWorkgroup
None Trip re-imbursement
based on an InfoPath
form with validation and rules
Two weeks An enhanced
solution
1.2 51 to 200 Midsize Business
EnterpriseDepartment
Low InfoPath form
converted to an Excel
template; Document
Information Panel;
reporting with Excel Services.
Two weeks A further enhanced
solution
2.0 201 to 500 Midsize Business
EnterpriseDivision
Custom Web
Part and Workflow action.
Enhanced user interface
with advanced approval workflow.
One month A major
improvement
expanded to more employees
3.0 1,001 plus Large Enterprise A complete,
managed code solution
Integrated, company-
wide expense report system
Four months A robust, scalable solution
Powerful, familiar BI tools for everyone
Connect your data across premises, cloud, and devices
Powerful, familiar BI tools for everyone
Q&A
Self-service BIThe familiarity of Office and the power of the cloud
Empower users with self service in Excel
Powerful, familiar BI tools for everyone
Advanced analytic tools for data scientists
• Advanced descriptive analytics (e.g. clustering algorithm in SQL Server Analysis Services)
• Predictive analytics (Neural Nets, Regression, Decision Tree, Time Series, Naïve Bayes algorithms in SQL Server Analysis Services)
• Further advanced analytics (Semantic Search and Geospatial Data and functions in SQL Server 2012)
• Big Data analytics(Hadoop integration)
Data mining add-in for business analysts
• Ease of use
• Rich data mining
• Scalable
Leader in business intelligence and analytics
Microsoft Azure Machine Learning
28
Power Query
Powerful self-service BI with Excel 2013
Power Query
Enable self-service data discovery, query, transformation and mashup experiences for Information
Workers, via Excel and PowerPivot
Discovery and connectivity to a wide range of data sources, spanning volume as well as variety of data.
Highly interactive and intuitive experience for rapidly and iteratively building queries over any data source, any size.
Consistency of experience, and parity of query capabilities over all data sources.
Joins across different data sources; ability to create custom views over data that can then be shared with team/department.
Power Query
• Excel add-in to enhance self-service BI
• Identify and import external data:• Relational dB
• Excel
• Text
• XML
• OData
• Web pages
• Hadoop HDFS
• Discover relevant data by using search
• Combine and transform multiple data sources
Discover, combine, and refine Big Data, small data,
and any data with Data Explorer for Excel
S
Data sources
Windows Azure
Marketplace
Windows Active
Directory
Azure SQL
DatabaseAzure HDInsight
PowerPivot
Powerful self-service BI with Excel 2013
Introducing PowerPivot
• PowerPivot empowers business users to create self-service BI data models in Excel
‐ Achieved with a client-side version of SQL Server Analysis Services, known as the In-Memory Analytics Engine
‐ Can efficiently store data volumes far greater than what Excel worksheets can achieve
• A separate window can be used to load, explore, relate, and enrich data with calculations
• Can import and relate data from corporate, local, and ad hoc data stores
• In Excel 2013 Professional Plus edition, PowerPivot is installed, but not enabled
PowerPivot for SharePoint
• PowerPivot for SharePoint extends SharePoint 2013 and Excel Services to add server-side processing, collaboration, and document management support for the PowerPivot workbooks published to SharePoint
• The PowerPivot Gallery, a special type of document library, is provided to browse published PowerPivot workbooks and to configure automatic data refresh
• The PowerPivot Service deploys the embedded data model to an Analysis Service instance within the SharePoint farm, and Excel Services is used to query the deployed data model
• Data connections can be defined to query the PowerPivot data model by using the document URL
Power Map
Power Map for Microsoft Excel enables information workers to discover and share new insights
from geographical and temporal data through three-dimensional storytelling.
What is Power Map?
Powerful self-service BI with Excel 2013
Power View
Powerful self-service BI with Excel 2013
Introducing Power View
• Power View is an interactive data exploration, visualization, and presentation experience
‐ Highly visual design experience
‐ Rich meta-driven interactivity
‐ Presentation-ready at all times
• It delivers intuitive ad-hoc reporting for business users
• Reports can be based on tabular data models, including PowerPivot data models
• It is now also available in Excel 2013, and with new features:
Power View for multidimensional models
• Power View on Analysis Services via
BISM
• Native support for DAX in Analysis
Services
• Better flexibility: Choice of DAX on
Tabular or Multidimensional
(cubes)
Give people powerful, familiar BI tools
Demo
The
Microsoft
Data
Platform
Complete and consistent data platform