yoann clombe : fail fast, iterate quickly with power bi and google analytics
TRANSCRIPT
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.