SharePoint 2013 & SharePoint Online Business Intelligence
The Webcast will begin at 1:00pm EST www.Gig-Werks.com
Today’s Presentation: • • • • • • •
Introduction & About Gig Werks Gig Werks Experience with SharePoint & Business Intelligence Advantages of Cloud and On Premise SharePoint Overview Understanding Business Intelligence in SharePoint Demonstration Q&A • Please type any questions during the webcast into GoToWebinar and we will answer at the end
• Survey • When leaving the webcast you will be prompted with a survey, please fill out for access to the PowerPoint and Webcast Recording
www.Gig-Werks.com
SharePoint Packaged Offers
Upcoming SharePoint Webcasts & Events
Power Business Intelligence Quick Start
Special NYC SPUG Event – Tuesday, 10/07 eDiscovery in SharePoint 2013
SharePoint Planning Webcast – Tuesday, 10/28 Project Management Workflow in SharePoint
Premium Advisory Services Plan
(BrightWork and Nintex)
SharePoint Staging & Development Workshop SharePoint & Business Intelligence Quick Start
Webcast – Tuesday, 10/29 Boost Performance and Shatter Storage Limitations in SharePoint (Metalogix)
Nintex Workflows Quick Start Webcast – Tuesday, 10/30 SharePoint 2013 vs. SharePoint Online: Security, Compliance and eDiscovery
SharePoint & Branding Quick Start SharePoint & Line of Business Integration Quick Start www.Gig-Werks.com
About Gig Werks • Company began and has been a Microsoft Gold Partner since 2002 • Deep relationship with Microsoft • • • •
Virtual Technology Specialists for the Microsoft New York Enterprise Group Microsoft SharePoint Partner Award Winner 2010, 2011, 2012 & 2013 Various other Microsoft Awards and Tech Forum Award Winner 2008 Invited into the Partner Evidence Program for SharePoint 2007, 2010 & 2013
• Market Focus • From 100 seats to 150,000+ with clients across North America
• • • • •
Have focused on SharePoint since 2003 Deep Industry Experience in: Financial Services, AEC, Healthcare/Pharma, Legal & Professional Services Approved Vendor of Microsoft LCA Expertise around Full Capabilities of SharePoint, Business Intelligence, Office 365 and Microsoft Stack Uniquely partner and offer expertise on the Best SharePoint ISV’s in the channel www.Gig-Werks.com
Gig Werks ISV Partner Ecosystem Advanced Functionality Enterprise Content Management
•Nintex •HiSoftware
•Intelledox •Collabware
•Intelledox
•Metalogix •HiSoftware
Search
Workflow
•Accusoft •BA Insight •IGC •Colligo •Workshare •Macroview •CADtoWIN •Nintex
•BA Insight •Accusoft •IGC •Colligo •Workshare •Macroview
Business Intelligence / Reporting •HiSoftware •BrightWork •Nintex •Metalogix
Project Management •BrightWork
Governance / Compliance
•Intelledox •Collabware
•Metalogix •HiSoftware •IGC •Colligo •Workshare •Macroview
Advanced Industry Solutions AEC Solutions •Intelledox •Nintex •CADtoWIN •BrightWork •Accusoft •Colligo •IGC •Metalogix •HiSoftware
Financial Services Solutions •Intelledox •Collabware •HiSoftware •Metalogix •Workshare •Macroview •Accusoft
Legal Solutions •Intelledox •BA Insight •Workshare •Macroview •Accusoft •Collabware •IGC •HiSoftware
•Metalogix •Colligo
www.Gig-Werks.com
Pharmaceutical / Healthcare Solutions •Intelledox •HiSoftware •Metalogix •Workshare •Macroview
Advantages of Office 365 & The Cloud • • • • • • • • • •
No Infrastructure Cost or Support Needed Automatic Updates and Maintenance Always have the latest version of Microsoft Products Accessibility from Anywhere Community and Phone Support Guaranteed 99.9% Uptime (Financially backed SLA from Microsoft) Predictable Cost Flexible Bandwidth Security, Compliance, and Privacy from Microsoft Speed to Market
www.Gig-Werks.com
Office 365 & SharePoint Online Pricing and Options
User Maximum
25 users
25 users
300 Users
Unlimited
Unlimited
Unlimited
Unlimited
Need Plan 2 for Certain Business Intelligence & Workflow Features
www.Gig-Werks.com
Advantages of On-Premise • Complete control of your environment and data
• Supports heavy customization (ex - Visual Studio Workflows) • Keep Sensitive information in-house • Easier integration into Line of Business systems • Full development options for developers • Improved Records Management
www.Gig-Werks.com
Microsoft SharePoint The Business Collaboration Platform for the Enterprise and the Web
Insights
www.Gig-Werks.com
Microsoft Excel Services • Excel Services enables people to view and interact with Excel workbooks that have been published to SharePoint sites • Use Excel Services to share centrally managed workbooks that are published to SharePoint Server, enable people to view and explore workbooks in a browser window similar to using the Excel client, and display pieces and parts of workbooks in individual SharePoint Web Parts
www.Gig-Werks.com
Excel 2013
Complete and Powerful Self-Service BI Tool Access
• • •
Share
Clean
Visualize
Mash-up Explore www.Gig-Werks.com
• • •
Discover and Combine Data with Power Query for Excel • • • •
Easily Discover and Connect to data from public and corporate data sources Transform and merge data from multiple sources to analyze in Excel View & Transform your data and clean it up even before loading it into a spreadsheet Create queries that you can save and use again later to refresh your data
www.Gig-Werks.com
PowerPivot in Excel
Access and mash up data from virtually any source to create powerful reports
www.Gig-Werks.com
Model and Analyze Data with PowerPivot for Excel • • • • • •
Create sophisticated data models in Excel by creating relationships, custom measures, hierarchies, and KPI's Create your own data model from various data sources, modeled and structured precisely to fit your needs Format and filter your data, create calculated fields, define key performance indicators (KPIs) to use in PivotTables and create user-defined hierarchies to use throughout a workbook Author your own calculations by writing advanced formulas that use the Data Analysis Expressions (DAX) expression language No need to be a SQL expert: manage the model and create relationships using drag and drop in the Diagram View Power Pivot models run in-memory so that users can analyze 100’s of millions of rows of data with lightning fast performance
www.Gig-Werks.com
Power View in Excel
Visually discover and share insights across all levels of the organization
www.Gig-Werks.com
Visualize with Power View and Power Map for Excel • • • • •
Create reports and analytical views through interactive charts and graphs that help you explore and present your data visually in Excel Work with real data and present it at any time Power View reports are fully interactive, with filtering and highlighting capabilities Power Map is a three-dimensional (3D) data visualization tool for Excel which enables data discoveries that might not be seen in traditional two-dimensional (2D) tables and charts With Power Map you can plot geographic and temporal data visually, analyze that data on a 3D globe and over time
www.Gig-Werks.com
Built in Forecasting • • •
Apply predictive forecasting, and hindcasting, when visualizing and exploring your data in your browser Power View utilizes built-in predictive forecasting models to automatically detect seasonality in the data to provide forecast results from a time series Explore forecast results by adjusting the desired confidence interval or by adjusting outlier data to see how they affect results
www.Gig-Werks.com
Microsoft PerformancePoint • PerformancePoint Services enables users to create and view interactive dashboard that display key performance indicators (KPIs) and data visualizations in the form of scorecards, reports, and filters. • Use PerformancePoint Services to define KPIs, custom aggregations, weightings, and threshold configurations, create items that are reusable across multiple dashboards, create a variety of reports using multiple data sources, and view and interact with dashboards on iPad devices by using the Safari web browser. www.Gig-Werks.com
Microsoft Reporting Services (SSRS) • SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality. • The deep reporting capabilities in SQL Server Reporting Services integrate with SharePoint Server to provide a comprehensive reporting environment.
www.Gig-Werks.com
Get suggestions on chart types based on your data
Preview your graphs, formatting and KPIs
www.Gig-Werks.com
Analyze trends and timelines
Quickly navigate through your data
www.Gig-Werks.com
Visualize your insights with interactive charts
Fine tune your reports with chart and view filters
www.Gig-Werks.com
Use slicer targets to optionally filter dashboard items
Share your Excel workbooks in the web
Interact with your workbook with all of the rich features of the Excel client in the browser
Preview reports for quick reference
Search for reports and expertise
www.Gig-Werks.com
Manage your BI assets with powerful tools
Simplify IT tasks with centralized settings
www.Gig-Werks.com
Assess your workbook for errors and risks
Track changes for regulatory compliance
www.Gig-Werks.com
Power BI for Office 365 and SharePoint Online
Microsoft Power BI fro Office 365 Features Self-Service BI Features in Excel •
• • •
Power Query – easily discover and connect to data from public and corporate data sources Power Pivot – create a sophisticated Data Model directly in Excel Power View– create reports and analytical views with interactive data visualizations Power Map – explore and navigate geospatial data on a 3D map experience in Excel
Power BI for Office 365 • • • •
Power BI Sites – share, view, and interact with reports in these collaborative Power BI sites Power BI Q&A – use natural language queries to find, explore, and report over your data Query and Data Management – share and manage queries and data sources, and view query usage analytics Power BI Windows Store App – view reports on the go, with the Power BI app
IT Infrastructure Services for Power BI • • •
©2012 Microsoft Corporation. All rights reserved.
Provision Power BI for Office 365 – create a tenant, and get Power BI for your organization Power BI Admin Center – manage your organization’s Power BI infrastructure from a site Data Management Gateway – connect on-premises data to the cloud, seamlessly and securely
www.Gig-Werks.com
Power BI Compatible Data Sources With Office 365 Power BI you can extract data from compatible sources including: • • • • • • • • •
Web page Excel or CSV file XML file Text file Folder SQL Server database Windows Azure SQL Database HDInsight Access database
• • • • • • • • • •
Oracle database IBM DB2 database MySQL database SharePoint List OData feed Hadoop Distributed File System (HDFS) Windows Azure Marketplace Active Directory Facebook SAP BusinessObjects BI Universe
www.Gig-Werks.com
Share and Collaborate with Power BI Use SharePoint Online and Power BI Sites to share & view workbooks • •
• •
Power BI Sites enable you to transform a basic SharePoint site into a visual, dynamic way to view and share Excel workbooks With Power BI Sites Workbooks are displayed in thumbnail images so it’s easy for people to see and select the workbooks they want to use Display Workbooks in SharePoint Online with gallery view, worksheet view or in an Excel Web Access Web Part Easily view and interact with the workbook in a browser window with SharePoint Online
www.Gig-Werks.com
Share and Collaborate with Power BI Share and Collaborate with Power BI Sites, Data Management & the Admin Center • •
• • • •
Share your queries directly from Power Query in Excel Monitor the usage of queries and decide which users can access what directly through the Data Management portal With Admin Center monitor the overall system health in the cloud and on-premises IT Administrators can use the Power BI Admin Center and the Data Management Gateway to expose data from on-premises sources as feeds that can be consumed from Power Query for Excel Connect to on-premises data sources and schedule refreshes for your reports Users get the same dashboard interactivity through the browser, making it easier to consume data and insights www.Gig-Werks.com
Anywhere Access with Power BI Take your data with you • •
•
Microsoft Power BI Windows Store app provides live mobile access to the important business information stored in your Office 365 account View and interact with Excel and Power View content on any Windows 8 or Windows RT tablet or PC, including Surface HTML5 support for Power BI Sites allows users to consume Power BI reports virtually anywhere, on any device
www.Gig-Werks.com
Power Business Intelligence Pricing and Options
www.Gig-Werks.com
Business Intelligence Features Not Available in Power BI for Office 365 PerformancePoint PerformancePoint Services enables you to create and view interactive dashboards that display key performance indicators (KPIs) and data visualizations in the form of scorecards, reports, and filters. • Define KPIs, custom aggregations, weightings, and threshold configurations • Create items that are reusable across multiple dashboards and pages • Create a variety of reports and scorecards using multiple data sources
Custom Data Sources On Premise allows for any data source
Refresh Schedule Restrictions Limited to settings in Power BI for data refresh schedule as opposed to unlimited options with On Premise setup.
www.Gig-Werks.com
Business Intelligence Demonstration Neil Barkhina Solutions Architect Gig Werks
www.Gig-Werks.com
Q&A Go to the Question Tab on your GoToWebinar Control Panel and Type Your Questions to be Answered Please Do Not Forget to fill out the survey as you leave the webcast to receive Todays PowerPoint & Webcast Recording Contact Us www.Gig-Werks.com
[email protected] 914-207-1110 @GigWerks www.YouTube.com/GigWerks www.Facebook.com/GigWerks