Power BI for Office 365 Consulting Experts

Posted by Errin O'Connor on Jan, 26, 2015 03:01

The following blog post cover’s EPC Group’s Business Intelligence Consulting Offerings around Office 365’s Power BI. EPC Group is the nation’s leading Power BI Consultant with over 400 successful BI deployments completed.

Microsoft’s new cloud-based BI platform includes features such as:

  • Online service in the cloud (SharePoint Online)
  • Self-service BI features on-premise (Excel)

Power BI for Office 365 Provides:

  • Data discovery and modeling
  • Analysis and visualization
  • Insights and collaboration
  • Access from anywhere

Power BI for Office 365 Provisioning

  • Setup Office 365 account (Plan E3)
  • Assign user licenses
  • Create a Team Site
  • Add Power BI app (or download it from the Store if it’s not already there)
  • Optionally add samples
  • Optionally assign additional users.

What is the Power BI App?

  • A business intelligence service for sharing and viewing large Excel workbooks and data views
  • What are Power BI’s Features:
  • Data refresh from on-premises data sources
  • Q&A (get instant answers and explore data by typing questions)
  • Data Catalogue (enable data discovery and search across your organization)
  • Support for HTML 5
  • Power BI Mobile app in Windows Store
  • Note: A Power BI for Office 365 license is required

The Power BI Admin Center

  • System health
  • Data sources
  • Gateways
  • Role management
  • Settings

Understanding Power BI Add-ins

  • Power Query: download and install
  • Power Pivot:  built-in, enable
  • Power View: built-in
  • Power Map: download and install

Power Query Feature Overview

  • Search and access data
  • Clean, transform, merge

PowerPivot Feature Overview

  • In-memory analytics and modeling
  • Relationships
  • Calculations
  • Hierarchies
  • KPIs
  • Security
  • High speed, columnar, in-memory data storage and calculation engine
  • It is actually SQL Analysis Services (SSAS)
  • Three forms
  • PowerPivot in Excel
  • PowerPivot for SharePoint
  • SSAS Tabular

PowerView Feature Overview

  • Visualize and analyze the data:
  • Tables
  • Charts
  • Slicers
  • Filters
  • Interaction
  • Browser-based Silverlight application launched from SharePoint 2013 (and 2010)
  • Provides intuitive, visual ad-hoc reporting aimed at business users
  • In Excel 2013 Power View is built in

PowerView High Value Features

  • Let’s reproduce the teaser dashboard
  • Drill Down
  • KPIs
  • Bing Maps Geospatial Integration
  • Scatter Plot Animation
  • Export to PowerPoint
  • Can Print

Limitations of Current Power Viw

  • No drilldown
  • No pie slices
  • No Bing Map integration
  • No support for KPIs and Hierarchies from the model
  • Silverlight = no formal mobile support even in SharePoint 2013

Compatibility Considerations for PowerView

  • You can upgrade existing PowerPivot workbooks in Excel 2013 and deploy them to SharePoint 2013
  • You can use Power View in SharePoint 2010 (i.e. v1) to report against Excel 2013 models with the usual limitations
  • However, PowerPivot Models built in Excel 2013 will not work in SharePoint 2010

Power Map Feature Overview

  • Visualize the data on the map
  • 3D geospatial analysis
  • Interactive views and tours

Power BI Implementations Allows For

  • Provides new ways to work with data in Excel and Office 365
  • Search, discover, access, shape and transform data
  • Analyze and create interactive visualizations
  • Share and collaborate from anywhere, on any device

EPC Group’s Nationally Recognized Practice Areas

EPC Group leading Custom Application DevelopmentSharePointOffice 365, Infrastructure Design and Business Intelligence Practice areas continue to lead the way in providing our clients with the most up-to-date and relevant information that is tailored to their individual business and functional needs.

Additional “From the Consulting Trenches” strategies and methodologies are covered in EPC Group’s new book, “SharePoint 2013 Field Guide: Advice from the Consulting Trenches” covering not only SharePoint 2013, Office 365 and SharePoint Online but Information Management, ECM\RM and overall compliance strategies in this ever changing world of “Hybrid IT.”