yoann clombe : fail fast, iterate quickly with power bi and google analytics

Fail Fast, Iterate Quickly with Power BI & Google Analytics

Yoann Jeffrey CLOMBE

Agenda

I) Introduction & concepts : Self-service BI

architecture.

II) Real life example : BDC return on

experience of a self service BI project.

III) DEMO – Deeper Dive into Power BI:

- Dashboards Google Fabrics - BDC Mobile.

- Dashboards DAX Calculations & Running

Totals.

- Dashboards Google Analytics Data / Geo

Map BDC.

- Dashboards from Web Service.

Yoann CLOMBE

Data Analyst @SII – Canada / Business France (IEC Program)

Blogger @ExcelTrail : exceltrail.wordpress.com

Twitter @DataZouk

About the Speaker

About the Business Development Bank of Canada (BDC)

I) Introduction & ConceptsModel, tools, processes, methods

Steps to prepare Data !

1. Discover

2. Structure

3. Clean

4. Enrich

5. Validate

6. Publish

Six steps to implement self-service

Step 1 : Classify Business Users

Six steps to implement self-service

Step 2 : Define Self-service Workflows

Six steps to implement self-service

Step 3 : Define Permissions

Six steps to implement self-service

Step 4 : Create a data governance committee

Six steps to implement self-service

Step 5 : Establish Reporting Workflows

Six steps to implement self-service

Step 6 : Continuously educate, train and support

Self service solutions actors

Benchmark of Self Service BI Solutions

Power BI Tableau Qlik MicroStrategy

Data Capacity 10 Go per

user

N/A 10 Go per

user

Data

Sources

Mobility

Security Azure AD,

Identity

Mgmt

SAML 2.0

Auth

End to end

data encrypt

SAML 2.0 ,

SSO

Free version 1Go per

user

limitation

Free 14

days

version

250 Mo

Data

limitation ( 5

users)

1 year

evaluation

version

Price 10 $ / user /

months

500$ / user /

year

20$ / user /

months

600$/ user/

year

Why consider Power BI ?

Data

discovery

Data

preparation

Data

visualization

Publish,

share,

collaborate

Power BI desktop Power BI 365

Free License required

Schedule data refresh

Quick insights

R integration soon integration with Python

Price : 10$ per user per months.

Integration with Office 365 (Excel, Active Directory)

Open Source Community (Python, R, D3.js)

II) Real Life Example: Mobile Client Facing Employees with Power BIReturn on experience

Objectives :

Who ? To identify who’s using the applications

Where ? To identify in which region and which area employees are using the applications.

Why? How ? To monitor employees usage metrics to improve best practices.

Context

Problem / Solution / Results

Problem Solution Results

Siloed data across BDC’s

Mobile Department made it

difficult for BDC’s mobile &

finance teams to intelligently

analyze Mobile Apps Usage &

Retention to deliver statistics to

the business (Sales / Marketing

/ Change Management).

BDC needs to increase

revenue coming from actions

delivered by certain

applications.

How to retain adoption with

other applications by increasing

the number of interaction with

Mobile Apps ?

Leveraged Power BI rich

analytics capabilities & features

to create maps & operational

reports that deliver real-time

insights and value for the

business.

Cost effective : after Power BI

Cloud assessment it have been

decided to move from

standalone version to Power BI

Prenium ( 6100$ / months for

the Mobility Team).

Used Power BI flexible Data

Model to build a unified view of

the bank’s Mobile Operation

that brings together Google

Analytics Data, On premises

Data & other data sources.

A single views of Mobility Client

Facing Team is now available

to all Business Analysts to help

them analyze & monitor

applications’ usage & adoption

towards BDC’s surcursales.

Adoption of Power BI Self-

service Solution for other

departments.

Organisation of Power Users

Teams { Data Analysts – Data

Scientists }

By the Data Management /

Governance team.

Power BI Premium cost estimate for Mobile Client Facing & Finance

Self-service analytic platformBefore MCFE Project

Sources Sandbox Self-serviceExternal

data

BI

DataMart's

ExcelPower

BISSIS R Microstrategy

SAP

B.O.Others…

Data

discovery

Data

preparation

Data

visualization

Publish/

collaborate

Self-service

needs

Analytic platform

Operationalize

Business units IT/BI

TIDAL

Email ExcelPDF

SSIS Informatica

Source

systems

Business units

Consume

Power BI

365

Power BI 365

content packs

Governance

Previous BI solutions architectureBefore MCFE Project

Self-service ETLFind, Explore, Profile, Transform

Publish, ShareETL

Self-service Visualization

Publish, Shareresults

Self-service Analytics

SANDBOXManual refresh

Manual refresh

x VDI

SQL Server Management

Studio

Self-service analytic platformAfter MCFE Project

Sources Sandbox Self-serviceExternal

data

BI

DataMart's

Data

discovery

Data

preparation

Data

visualizationOperationalize

Self-service

needs

Analytic

platform

Publish/ collaborate/

consume

Governance

Business units

One solution

(POWER BI)

Current Self-service BI solutions architecture

PrepareFind, Explore, Profile, Transform

Store

Publish

Analytics

sandbox

Self-service BI solutions architecture for mobility

DiscoverFind, Explore, Profile, Transform

Store Visualize

S A N D B OX

Fabric

Doc+Meeting

RSLProposal FastTrack

Client 360

Mobile apps

Data sources

Desktop client

Web

API development No backup

Self Service BI Solution architecture

BI Solutionarchitecture

27

Deeper Dive into Power BI

DEMO

Power Query

Dashboards Google Fabrics with Power BI

Dashboards Google Fabrics BDC Mobile.

Dashboards DAX Calculations & Running Totals.

Dashboards Google Analytics Data / Geo Map BDC

Shazal GOMES : Architect of analytical solutions

@Business Development Bank of Canada (BDC).

SQLbi.com team (Marco Russo , Alberto Ferrari) books and workshops.

Exceleratorbi.com.au, Matt Allington and his book : Learn to write DAX.

Special Thanks to

bdc.ca1-888-INFO-BDC

BDC

BDC_ca

BDC

Thank you.What questions would you like to ask

me now ?

Yoann Jeffrey CLOMBE

The key to success is failure.