close

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.”

[gravityforms id=41 title=”true” description=”false”]
<div class='gf_browser_chrome gform_wrapper exit_intent_popup_wrapper gform_legacy_markup_wrapper' id='gform_wrapper_41' > <div class='gform_heading'> <h3 class="gform_title">Exit Intent</h3> <span class='gform_description'></span> </div><form method='post' enctype='multipart/form-data' id='gform_41' class='exit_intent_popup gform_legacy_markup' action='/power-bi-for-office-365-consulting-experts/' > <div class='gform_body gform-body'><ul id='gform_fields_41' class='gform_fields top_label form_sublabel_below description_below'><li id="field_41_1" class="gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" ><div class='ginput_container ginput_container_text'><input name='input_1' id='input_41_1' type='hidden' class='gform_hidden' aria-invalid="false" value='https://www.epcgroup.net/power-bi-for-office-365-consulting-experts/' /></div></li><li id="field_41_11" class="gfield gfield--width-full gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" ><div class='ginput_container ginput_container_text'><input name='input_11' id='input_41_11' type='hidden' class='gform_hidden' aria-invalid="false" value='ddd01b75-d4fc-ea11-a816-000d3a591fb8' /></div></li><li id="field_41_12" class="gfield gfield--width-full gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" ><div class='ginput_container ginput_container_text'><input name='input_12' id='input_41_12' type='hidden' class='gform_hidden' aria-invalid="false" value='' /></div></li><li id="field_41_13" class="gfield gfield--width-full gform_hidden field_sublabel_below field_description_below gfield_visibility_visible" ><div class='ginput_container ginput_container_text'><input name='input_13' id='input_41_13' type='hidden' class='gform_hidden' aria-invalid="false" value='' /></div></li><li id="field_41_9" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_9' >Full Name<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_text'><input name='input_9' id='input_41_9' type='text' value='' class='medium' placeholder='Full Name' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_6" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_6' >Email<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_email'> <input name='input_6' id='input_41_6' type='text' value='' class='medium' placeholder='Email Address' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_7" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_7' >Phone<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_phone'><input name='input_7' id='input_41_7' type='text' value='' class='medium' placeholder='Phone Number' aria-required="true" aria-invalid="false" /></div></li><li id="field_41_10" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_10' >Company Name<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_41_10' type='text' value='' class='medium' placeholder='Company Name' aria-required="true" aria-invalid="false" /> </div></li><li id="field_41_8" class="gfield gfield_contains_required field_sublabel_below field_description_below gfield_visibility_visible" ><label class='gfield_label' for='input_41_8' >Message<span class="gfield_required"><span class="gfield_required gfield_required_asterisk">*</span></span></label><div class='ginput_container ginput_container_textarea'><textarea name='input_8' id='input_41_8' class='textarea medium' placeholder='Type your message here...' aria-required="true" aria-invalid="false" rows='10' cols='50'></textarea></div></li></ul></div> <div class='gform_footer top_label'> <input type='submit' id='gform_submit_button_41' class='gform_button button' value='Submit' onclick='if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_41"]){return false;} window["gf_submitting_41"]=true; jQuery("#gform_41").trigger("submit",[true]); }' /> <input type='hidden' class='gform_hidden' name='is_submit_41' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='41' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_41' value='WyJbXSIsIjEwNTJhNGVmMWMyNzI3YTJmMjdiZTA1NjU4ZDMzYzY3Il0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_41' id='gform_target_page_number_41' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_41' id='gform_source_page_number_41' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> <p style="display: none !important;"><label>&#916;<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js" name="ak_js" value="204"/><script>document.getElementById( "ak_js" ).setAttribute( "value", ( new Date() ).getTime() );</script></p></form> </div>