The Webcast will begin at 1:00pm EST.

Power Business Intelligence for

SharePoint Online and Office 365

Today’s Presentation:

• Introduction & About Gig Werks

• Gig Werks Experience with SharePoint & Business Intelligence • Advantages of Cloud and On Premise

• SharePoint Overview

• What is Power Business Intelligence

• Power Business Intelligence Demonstration • Q&A

• Please type any questions during the webcast into GoToWebinar and we will answer at the end

• Survey

SharePoint

Packaged Offers

Power Business Intelligence Quick Start SharePoint Planning – Save 20% Premium Advisory Services Plan

SharePoint Staging & Development Workshop SharePoint & Business Intelligence Quick Start

Nintex Workflows Quick Start SharePoint & Branding Quick Start

SharePoint & Line of Business Integration Quick Start

Upcoming SharePoint

Webcasts & Events

Webcast – Friday, 09/05

SharePoint 2013 & SharePoint Online: Search

Webcast – Tuesday, 09/30

Project Management Workflow in SharePoint (BrightWork and Nintex)

Webcast – Wednesday, 10/01

SharePoint 2013 & SharePoint Online: ECM

Webcast – Thursday, 10/02

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

Gig Werks ISV Partner Ecosystem

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 Pharmaceutical / Healthcare Solutions •Intelledox •HiSoftware •Metalogix •Workshare •Macroview Enterprise Content Management •Intelledox •Collabware •Metalogix •HiSoftware •Accusoft •BA Insight •IGC •Colligo •Workshare •Macroview •CADtoWIN •Nintex Workflow •Nintex •HiSoftware •Intelledox Search •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

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

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

Microsoft SharePoint

The Business Collaboration Platform for the Enterprise and the Web

What is Power Business Intelligence

Microsoft Power BI for Office 365 delivers a cloud based solution that allows your organization to easily deploy advanced tools and feature that provide Reporting,

Analysis and Secure Self-Service Business Intelligence for all your users. With Power BI for Office 365 you can:

Discover and Combine Data Visualize Data

Get Answers and insights

Model and Analyze Data

Discover and Combine Data

Discover and Combine 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

Discover and Combine Data

Power Query allows you to extract data from all sorts of compatible sources:

• 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

Model and Analyze Data

Model and Analyze with Power Pivot 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

Visualize Data

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

Visualize Data

Visualize Data

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

Share and Collaborate

• 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

Share and Collaborate

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

Anywhere Access

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

Office 365 & SharePoint Online

Pricing and Options

User Maximum 25 users 25 users 300 Users Unlimited Unlimited Unlimited Unlimited

Demonstration

Q & A

www.Gig-Werks.com [email protected]

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