Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Business Intelligence Demo VHD (Part 10 of 10) – Awesome Demos!

Finally, with all the required software loaded we are ready to show awesome demos of Business Intelligence running on SharePoint 2013 and SQL 2012.  Woohoo!  

Open-mouthed smile

   

Please leave a comment below if you found these posts helpful.   I’d like to send a major thank you to Ivan Sander (@iasanders) for his work on https://sharepointdemobuilds.codeplex.com/ to provide these great BI examples to the SharePoint community.

If a picture is word a thousand words, this VHD takes that to a whole new level.

 

 


Visio Data Diagrams

Below are .VDW files (Visio Web Drawing) which are included in the http://intranet.contoso.com/Sites/Visio/ sample site.  There are many great examples here to give an idea of how Visio can be used to improve Business Intelligence at your organization.

Examples components include:

  • Pivot Shape (one shape per row)
  • Color shading (driven by threshold.  think  stoplight Red, Yellow, Green)
  • Data icons (driven by threshold.  think  stoplight Red, Yellow, Green)
  • Percent background shading
  • Gauges (thermometer dial)

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/Network_Diagram.vdw?Web=1

image
image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/Web_Site.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/HR%20Process%20Library/

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/HR%20Process%20Library/Hiring_Process.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/Room_Vacancy.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/Casino_Floor.vdw?Web=1

image
image
image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/Data%20Center.vdw?Web=1

image
image
image
image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/HVAC_Security.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/ValueStreamMap_Final.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/User%20Mailbox%20Monitoring.vdw?Web=1

image
image

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/ValueStreamMap_Final.vdw?Web=1

image
image

Multiple Visio web parts can be combined on a page for an executive overview to quickly glance at key data and diagrams for context. 

http://intranet.contoso.com/Sites/Visio/SiteAssets/Hotel%20Rooms.aspx

image

Web part connections can be used to provide a filter into the Data Diagram.  That allows to easily interact and navigate the diagram.  Pretty cool.

http://intranet.contoso.com/Sites/Visio/SiteAssets/NetworkStatus.aspx

image

http://intranet.contoso.com/Sites/Visio/VGS/SitePages/Home.aspx

image

http://intranet.contoso.com/Sites/Visio/Contoso%20Processes/Approved%20Contracts/SupplyChain_v3.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Loan_Consolidation.vdw?Web=1

image
image
image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Sales_Team.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Ski_Map.vdw?Web=1

image
image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Floorplan.vdw?Web=1

image
image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Insurance_Claims.vdw?Web=1

image
image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Manufacturing_Plant.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Supply_Chain_Diagram.vdw?Web=1

image

http://intranet.contoso.com/Sites/Visio/VGS/Shared%20Documents/Visio_Ribbon_Visualization.vdw?Web=1

image
image

 

 


Dashboards

http://intranet.contoso.com/Sites/Visio/Visio%20BI/Pages/ExecutiveDashboard.aspx

I use the word Dashboard loosely for any page with multiple BI components.    Here we have Excel Web Part and Visio Web Part for a merger of table data with org chart.  Good for executive summary.

image

http://intranet.contoso.com/Sites/Visio/Visio%20BI/Pages/RetailOperationsDashboard.aspx

 

image

http://intranet.contoso.com/Sites/Visio/Visio%20BI/Pages/Analyst%20Dashboard.aspx

 

image

http://intranet.contoso.com/Sites/Visio/Visio%20BI/Pages/Store%20Manager%20Dashboard.aspx

image

http://intranet.contoso.com/Sites/Visio/videos/SitePages/Home.aspx

The demo site even includes videos on how to configure Visio Services with intro, web part connections, and more.

image

Excel Services

Web based charts can be quickly created in Excel and published by any end user for wider consumption.  Thumbnails on the right pane help users navigate to relevant pages quickly.

http://intranet.contoso.com/Sites/Visio/Shared%20Documents/SlotMachines.xlsx?Web=1

image
image
image

Data Connection Library

Multiple BI presentation layers can display from a common source.   Shared data with ODC files can be a smart way to reuse a connections.

http://intranet.contoso.com/Sites/Visio/DataConnectionLibrary/

image

PowerView

My understanding is that PowerView is the new SQL Reporting Services 2012 file format RDLX (4 letter) for looking at data in more interactive ways.   This is a very compelling display.   The ability to adjust filters, navigate data, and integrate with PowerPoint are just fantastic.   The new interface even works great on tablets and touchscreen UI.

http://intranet.contoso.com/SelfService%20BI/Forms/Gallery.aspx

“Discover new insights with a highly interactive, familiar, browser-based data exploration, visualization, and presentation tool” http://www.microsoft.com/en-us/bi/Products/PowerView.aspx

image
image
image
image
image
image
image
image
image

Thanks for browsing this blog post series.  I hope it was helpful to see Business Intelligence on SharePoint 2013 and how to build a working virtual machine for your own demos.   The best way to learn is hands-on with a real working site.  Please leave a comment if you found this helpful.  

Smile

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲