close

Deep-Dive of Microsoft’s Power BI for Office 365

Posted by Errin O'Connor on May, 10, 2015 06:05

Microsoft Office 365’s Power BI contains a collection of features and services that enables organization to visualize data and share these discoveries in a very similar manner as SharePoint 2013’s on-premise business intelligence  environmental capabilities.

Power BI is cloud-based and can also be configured in a hybrid cloud scenario for organizations who have both SharePoint 2013 on-premise as well as Office 365 in the cloud for seamless reporting of data of different classification types (i.e. PII, PHI, HIPAA and/or less confidential data) to limit risk and compliance concerns.

Power BI provides organizations with a cloud based self-service business intelligence (BI) infrastructure and brings the Excel workbook sharing together with online collaboration. Power BI allows team to work together on analyzing sets of data in “Shared Queries”, as shown in the image below:

 

Note: There is a centralized Power BI Admin Center for managing your organization’s Power BI infrastructure.

In the new “hybrid cloud” environment that is developing in most organization’s throughout the globe, the Data Management Gateway is a feature that will connect on-premises data to the cloud.

 

Power BI works seamlessly with Excel to create content, data models, and visualizations which also providing the capability to share, collaborate, and extend those insights.

Note: It is important to review your licensing model to ensure you have this capability available. For example, Excel is not part of Power BI for Office 365, but your organization’s licensing model more than likely already provides you with Microsoft Excel.

Power BI’s features and functionality are robust and are as follows:

  • Power Query allows users to easily discover and connect to data from public and corporate data sources.
  • Power Pivot allows users the ability to create a sophisticated Data Model directly in Excel.
  • PowerView creates reports and analytical views with interactive data visualizations and search your data, as shown in the image below:

 

  • Power Map provides for users to explore and navigate geospatial data on a 3D map experience in Excel.
  • Power BI Site(s), as shown in screen shot below, allow users to share, view, and interact with reports in these collaborative Power BI sites.
  • Power BI Q&A is a feature that uses natural language queries to find, explore, and report over your data.
  • Query and Data Management provides for users to share and manage queries and data sources, and view query usage analytics.

A Power BI Site for users to share, view, and interact with the available reports

  • Power BI app, available via the Power BI Windows Store, allows you to view reports on the go with your mobile device, as shown in the image below:

SharePoint & Office 365 Business Intelligence “From the Consulting Trenches”

EPC Group will continue our SharePoint & Office 365 Business Intelligence (BI) deep-dive blog series in the weeks to come to touch on the real-world “from the consulting trenches” approach that EPC Group has successfully implemented for hundreds of organizations throughout North America.

[gravityforms id=41 title=”true” description=”false”]
<div class='gf_browser_unknown 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='/deep-dive-of-microsofts-power-bi-for-office-365/' > <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/deep-dive-of-microsofts-power-bi-for-office-365/' /></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="90"/><script>document.getElementById( "ak_js" ).setAttribute( "value", ( new Date() ).getTime() );</script></p></form> </div>