using power bi to make projects more “powerful” in your organization

10

10

5

30

15

0 5 10 15 20 25 30 35

Questions and Answer

Product Demo

Power BI and Project Online

Project Managment With Microsoft

Introductions

Minutes

10

15

10

10

5

0 2 4 6 8 10 12 14 16

Questions and Answer

Product Demo

Power BI and Project Online

Project Managment With Microsoft

Introductions

Minutes

mmclean@microsoft.com

http://blogs.office.com/planner

http://blogs.office.com/project

Project Management with Microsoft

Project

Our world is changing

TodayPast

Long product cycles

Email

Traditional workplace

Less data

Rapid innovation

Social collaboration

Telecommuting

Big data

58%of companies

do not have

an innovation

strategy

— Capgemini

17%higher 5-year

CAGR for

highly aligned

companies

— Booz & Co.,

71%of well-

aligned

projects

completed

— PMI

89%of projects

successful in

high-

performing

companies— PMI

14Xmore

investments

at risk

— PMI

58%of projects

are not highly

aligned to

strategy

— PMI

Microsoft philosophyA comprehensive set of tools delivered to almost any device through cloud or on-premise

Comprehensive

Toolset

Cloud and

On-Premise

Devices

Task

Management

Work

Management

Project

Management

Level of Complexity

Individuals

Adhoc Teams

Project Teams

Portfolio

ManagementPMO/Executives

Low Medium High

Work, Project and Portfolio Management in the cloud

A C C E L E R AT E D PA C E

O F F E AT U R E D E L I V E R Y

N E W S E R V E R R E L E A S E S

E V E R Y 3 Y E A R S

T R A D I T I O N A L D E V E L O P M E N T C Y C L E I N N O V A T I O N I N T H E C L O U D

C O N S I S T E N C Y

W I T H O F F I C E

S H A R E P O I N T

I N T E G R A T I O N

C O N S O L I D A T E D

P P M S O L U T I O N

P P M I N

T H E C L O U D

GETTING

STARTED

EXPERIENCE

ODATA IN

SSIS

PROJECT

LITE

INCREASED PWA

INSTANCES

SSIS DELTA

UPDATES

RESOURCE

ENGAGEMENTS

CAPACITY

MANAGEMENT

A STRONG DECADE OF INNOVATIONS

Self-service reporting

Visualization

Natural language query capabilities in Power BI deliver

self-service analytics solution for the PMO and

executive teams.

Screenshot from Power BI

Rich visual reporting capabilities in Power BI help

customers easily build and share program and portfolio

performance dashboards.

Screenshot from PowerView

Power BI and Project Online

P R O J E C T S E R V E R

D i r e c t D a t a b a s e

P R O J E C T O N L I N E

O D a t a S e r v i c e

P R O J E C T O N L I N E

D e l t a U p d a t e s

P R O J E C T O N L I N E

S S I S I n t e g r a t i o n

P R O J E C T O N L I N E

P o w e r B I i n O 3 6 5

B

EVOLUTION OF BI IN PROJECT

Power View

Power Pivot

Question & Answer

Power Query

PROJECT ONLINE AND POWER BI

LIFECYCLE

OData

Power BI Content Packs

Creation of out-of-the-box content

Content is primarily focused on business users

Dataset contains queries back to the source

Allow users to immediately gain insights

Automatically refreshed on a schedule

List of data sources is growing every week!

DemoProject Online Power BI Content Pack

Embed scenario – need more info

Microsoft Project

Import and analyze data from Project Online in Power BI.

The content pack is designed to help you quickly connect to

your Project Online tenant in Office 365 and download a

variety of data to visually explore and monitor all the key

aspects of your PPM deployment such as Projects, Issues,

Risks and much more.

Microsoft Project

User is navigated to powerbi.com content pack gallery with the Project content pack selected

Microsoft Project

Microsoft ProjectTo start using Microsoft Project data in Power BI, follow

the prompts below.

Need help connecting? Learn more

Project Web App URL:

https://contoso.sharepoint.com/sites/pwa

Clicking connect will land users on the Dashboard for the Project content pack

#ProjectVConf www.projectvirtualconference.com#ProjectVConf www.projectvirtualconference.com

But wait, there’s more!

The Excel workbook used to create

the Project Online content pack

will be available for download!

https://microsoft.eventcore.com/Ignite2016/Contact

mmclean@microsoft.com

http://blogs.office.com/planner

http://blogs.office.com/project

Appendix

Datasets

Each dataset represents a single data source

Excel workbook

Salesforce

Google Analytics

Etc

One dataset can be used in many different reports

All datasets supported by Power BI

ReportsOne or more pages of visualizations (charts and graphs)

Reports can be interacted with using Reading View and Editing View

One report:Can be associated with multiple dashboards

Can be created using data from one dataset

DashboardsSingle canvas that displays one or more tiles.

Can display visualizations from many different datasets and reports

Power BI Dashboards (For Partners)

Content Packs unlock the data in their serviceAdhoc analysis without investing heavily in reporting infrastructure

Domain experts provide vertical solutionsEnable analysts to mashup data with other data that’s important to them

Drive awareness of solution/serviceGenerate leads to your other services