cool dashboards and visualizations for sharepoint power users

20
by Benjamin Niaulin, a SharePoint GEEK Cool Dashboards, Charts & Visualizations Power Users for

Upload: benjamin-niaulin

Post on 25-May-2015

1.978 views

Category:

Technology


2 download

DESCRIPTION

With the introduction of SharePoint 2013, the Business Intelligence layer changed a little. Office 365 introduces Power Bi and Excel is now the main dashboard creation tool combined with Excel Services to provide a Web Based access to the information. This session shows the different possibilities offered by: Power Query Power Pivot Power View Power Map As well as Office 365's Power BI and the differences with On-Premises.

TRANSCRIPT

Page 1: Cool Dashboards and Visualizations for SharePoint Power Users

by Benjamin Niaulin, a SharePoint GEEK

Cool Dashboards, Charts & Visualizations

PowerUsers

for

Page 2: Cool Dashboards and Visualizations for SharePoint Power Users

@bniaulin

share-gate.com/blog

by Benjamin Niaulin, a SharePoint GEEK

Page 3: Cool Dashboards and Visualizations for SharePoint Power Users

Why are

YOUhere?

Page 4: Cool Dashboards and Visualizations for SharePoint Power Users

…to build « cool »Dashboards and « stuff »

Page 5: Cool Dashboards and Visualizations for SharePoint Power Users

But what

EXACTLYled you here?

Page 6: Cool Dashboards and Visualizations for SharePoint Power Users

« What if we made Power Users

do all the work? »

Page 7: Cool Dashboards and Visualizations for SharePoint Power Users
Page 8: Cool Dashboards and Visualizations for SharePoint Power Users

Thanks, but I am good

with SharePoint Designer

Page 9: Cool Dashboards and Visualizations for SharePoint Power Users

SharePoint Designer 2013

Page 10: Cool Dashboards and Visualizations for SharePoint Power Users

I JUST got used to

using it! Along with

XSLT

Page 11: Cool Dashboards and Visualizations for SharePoint Power Users

What we did before

Conditional Formatting

KPIs SharePoint List

Performance Point

InfoPath Forms

SharePoint Designer Creativity

Custom Dev

Page 12: Cool Dashboards and Visualizations for SharePoint Power Users

Let’s see what we

can do now

Page 13: Cool Dashboards and Visualizations for SharePoint Power Users

Power BIvsSelf Service BI

Power Query

Power Pivot

Power View

Power Map*

Power BI Sites

Power BI Q&A

Query & Data Mgmt.

Windows App

Page 14: Cool Dashboards and Visualizations for SharePoint Power Users

Power Query

Makes it easy to discover the right information

Search & Find

Many Data Sources

Save and Transform

Page 15: Cool Dashboards and Visualizations for SharePoint Power Users

Power PivotAnalyze the content from Queries

Build your own model

Relationships with Data Sources

Calculated Fields & KPIs

Page 16: Cool Dashboards and Visualizations for SharePoint Power Users

Power ViewVisualize

Create Explore Interact

with Graphs, Charts and

other things you’ve built

with Excel on the web as a

report

Page 17: Cool Dashboards and Visualizations for SharePoint Power Users

Power MapCreate cool 3D maps visuals with

your Data!

Page 18: Cool Dashboards and Visualizations for SharePoint Power Users

Power BIPower BI SitesPower BI Q&A

Query & Data Mgmt.

Windows App

Page 19: Cool Dashboards and Visualizations for SharePoint Power Users

Power BIPricing

http://officeimg.vo.msecnd.net/en-001/files/500/002/AF104215773.pdf

Page 20: Cool Dashboards and Visualizations for SharePoint Power Users

by Benjamin Niaulin, a SharePoint GEEK

@bniaulin

share-gate.com/blog

THANK YOU!