collab 365 session

 Online Conference

 June 17th and 18th 2015

WWW.COLLAB365.EVENTS

Easily create appealing dashboards using Excel 2016 and SharePoint Online

Luc LabelleKabesa

WWW.COLLAB365.EVENTS

Luc LabelleKabesa

Email : luc.labelle@kabesa.caTwitter : @Luc_Labelle

• Owner and consultant • Working in IT for 15 years• Working with SharePoint for 8

years

WWW.COLLAB365.EVENTS

About this sessionEnd users and power usersQuick overview of what is Self Service BIWhere does Excel 2016 fits in the Microsoft BI stack

WWW.COLLAB365.EVENTS

What’s new in Excel 2016What’s new in Excel 2016

What exactly is Self-Service BI ?

 Online Conference

 June 17th and 18th 2015

The journey of corporate DataGather

Clean

Transform

Explore

Visualize

Share

WWW.COLLAB365.EVENTS

Gather: SQL, LOB Application, Excel, Internet …

Clean: Power Query 

Transform: Power Pivot 

Explore: Excel, Power Pivot

Visualize: Power View, Power Map, Excel Charts

Share: SharePoint, Power BI

With Excel 2016

 Online Conference

 June 17th and 18th 2015

Data Source Excel 2013 Excel 2016

File From File (Text, CSV, XML) √ √Excel workbook, Folder √

Database  From Database Access, SQL Server, Analysis Services √ √Oracle, IBM DB2, MySQL, PostgreSQL, Sybase, ODBC √OLEDB Wizard √ √*

Other Sources MS Query √ √*Online Search √Hadoop (HDFS), Azure HDInsight, Azure Blob Storage, Azure Table Storage √

SharePoint List,Active Directory, Microsoft Exchange √

Facebook √SAP Business Objects √Salesforce Objects & Reports √

WWW.COLLAB365.EVENTS

Demo prerequisitesOffice 365 tenant (E3)Excel 2016

WWW.COLLAB365.EVENTS

Stay tuned for more great sessions …

Demo

Web part Dashboard

WWW.COLLAB365.EVENTS

Stay tuned for more great sessions …

Demo

Basic Excel Dashboard

WWW.COLLAB365.EVENTS

Stay tuned for more great sessions …

Demo

Power View Dashboard

WWW.COLLAB365.EVENTS

To sum it upCreate dashboard using web part pagesCreate dashboard using Power Query and Power Pivot Create dashboard using Power View

WWW.COLLAB365.EVENTS

Stay tuned for more great sessions …

Thanks for watching