Reporting at Motorola - Predictive analytics & business insights 2014

50 %
50 %
Information about Reporting at Motorola - Predictive analytics & business insights 2014
Technology

Published on March 6, 2014

Author: PatrickDeglon

Source: slideshare.net

Description

In this presentation, Patrick Deglon will share his learnings and provide best practices when using open Google tools & API. He will present his daily email report that hundreds of key Motorola stakeholders are receiving to drive the business, as well as a mobile solution based on the latest web technologies, including Google Visualization, Bootstrap CSS and many of the Google APIs (Gmail, BigQuery, Analytics, Drive, App Engine, Users authentication, etc.).

Dr Patrick Deglon Director of Engineering, Analytics Area Tech Lead Motorola Mobility pdeglon@motorola.com pdeglon Reporting at Motorola Predictive Analytics & Business Insights 2014 http://www.gatewayanalyticsnetwork.com/b122-home motorola confidential

Overview of Motorola Business ... About Us Motorola exists to invent, build and deliver the best mobile devices on the planet, improving the lives of millions of people. motorola confidential

Motorola “Galvin Manufacturing Corporation” created, producing battery eliminators 1928 First walkietalkie which was vital to Allied communication 1940 world's first handset to combine a Linux operating system and Java technology first private handheld mobile phone call; world's first commercial cellular device 1969 “one small step for man, one giant leap for mankind” through a Motorola transceiver 1973 1983 1986 2003 2011 2014 Invented six sigma quality improvement process Motorola splits into Motorola Mobility & Motorola Solutions Source: Wikipedia motorola confidential

Key Performance Indicators Simplified Business Flow Motorola Factory # Shipments Distribution Channels # Sales First Usage # Activations motorola confidential

Data Flow Motorola Factory # Shipments Distribution Channels # Sales ... First Usage # Activations Motorola Cloud Google BigQuery Insights motorola confidential

Agenda • Business overview • Demos • Daily Activations Report • Moto Insights • Drive Insights motorola confidential

Daily Activations Report Existing Situation - Numerous (conflicting) sources of truth - Too many variations of same data cube - “Table in your face” approach - No global business definition - No curation of manually entered data points - Report accessible on an internal portal (through VPN) - No mobile form factor How to provide a global source of truth and start to provide insights on data points? motorola confidential

Demo Daily Report: Final Email motorola confidential

Data Store Cloud Storage Cloud SQL Drive BACKUP Google: A galaxy of open APIs and Tools… the good, the bad and the ugly Big Query App Engine Users Cloud Messaging Analytics Java Python Go Mail Translate Docs Data Store Task Queue Memcache Maps Predict Visualization and many more ... Compute Engine URL Fetch Cloud End Point Channel Mail motorola confidential

Demo Daily Report ● Get data (pivot) from BigQuery ● Spreadsheet magic ● Insights: WoW trends with statistics test, Key driver for growth, Key milestone, internal QA tests ● Email ● Embedded Chart ● Scheduler https://docs.google.com/a/motorola.com/spreadsheet/ccc?key=0AgldkCMfisBTdF83VVJqdFVEZFZiZjgyTWJNdzRNblE&usp=drive_web#gid=21 motorola confidential

Description of the illustrative simulation • Assume sales follow a diffusion S-shape, i.e. ΔN ΔN = a (Nmax - N) + b N (Nmax - N) Marketing • • Nmax Word of mouth Add random noise to theoretical daily activations (Poisson) N Simulated daily activations (sales) for United States, Canada, Brazil, India, Russia, China, Germany and United Kingdom with various launch date per region motorola confidential

BACKUP Step 1: Create a backbone table motorola.com:sandbox:demo.backbone: SELECT CAL_DT, Country FROM ( SELECT CAL_DT, 1 AS Dummy FROM [motorola.com:sandbox:pdeglon.calendar] ) AS A ON A.Dummy=B.Dummy WHERE B.CAL_DT>=A.Launch_Date X INNER JOIN ( SELECT Country, CASE WHEN Country IN ('United States','Canada') THEN '2013-08-01' WHEN Country IN ('Brazil','Russia','India','China') THEN '2013-10-01' ELSE '2013-12-01' END AS Launch_Date, GDP_USD/1e7 AS Scale, 1 AS Dummy FROM [motorola.com:sandbox:pdeglon.countries] WHERE Country IN ('United States','Canada','Brazil','Russia','India', 'China','Germany','United Kingdom') ) AS B motorola confidential

BACKUP Step 2: Calculate KPI value over time motorola.com:sandbox:demo.baseline: DATEDIFF(TIMESTAMP(CAL_DT),TIMESTAMP(Launch_Date)) SELECT CAL_DT, Country, ‘Phone 123’ AS Model, INTEGER(Scale* EXP(-POW( ... -150,2)/2/POW(75,2)) /(75*SQRT(2*PI())) ) AS Daily_Activations FROM [motorola.com:sandbox:demo.backbone] Normal Distribution: motorola confidential

BACKUP Step 3: Add Random Noise motorola.com:sandbox:demo.simulation: SELECT CAL_DT, Model, Country, INTEGER( Daily_Activations + SQRT(Daily_Activations) * SQRT(-2*LN(RAND()))*COS(2*PI()*RAND()) ) AS Daily_Activations FROM [motorola.com:sandbox:demo.baseline] (pseudo) Poisson distribution for N=Daily_activation Normal (Gaussian) Random Number (mu=0, sigma=1) motorola confidential

BACKUP Step 4: Final Pivot for report SELECT CAL_DT, SUM(Daily_Activations) AS Total, SUM(CASE WHEN Country IN ('United States','Canada') THEN Daily_Activations ELSE 0 END) AS NA, SUM(CASE WHEN Country IN ('Brazil','Russia','India','China') THEN Daily_Activations ELSE 0 END) AS BRIC, SUM(CASE WHEN Country IN ('Germany','United Kingdom') THEN Daily_Activations ELSE 0 END) AS EU, SUM(CASE WHEN Country='United States' THEN Daily_Activations ELSE 0 END) AS UnitedStates, SUM(CASE WHEN Country='Canada' THEN Daily_Activations ELSE 0 END) AS Canada, SUM(CASE WHEN Country='Brazil' THEN Daily_Activations ELSE 0 END) AS Brazil, SUM(CASE WHEN Country='Russia' THEN Daily_Activations ELSE 0 END) AS Russia, SUM(CASE WHEN Country='India' THEN Daily_Activations ELSE 0 END) AS India, SUM(CASE WHEN Country='China' THEN Daily_Activations ELSE 0 END) AS China, SUM(CASE WHEN Country='Germany' THEN Daily_Activations ELSE 0 END) AS Germany, SUM(CASE WHEN Country='United Kingdom' THEN Daily_Activations ELSE 0 END) AS UnitedKingdom FROM [motorola.com:sandbox:demo.simulation] WHERE CAL_DT<CURRENT_DATE() GROUP BY 1 ORDER BY 1 DESC motorola confidential

Demo Daily Report: New Menu Item motorola confidential

Demo Daily Report: Edit Code (App Script) motorola confidential

Demo Daily Report: Example for adding a new menu item motorola confidential

Demo Daily Report: Key Query (pivot) motorola confidential

Demo Daily Report: Running the query motorola confidential

Demo Daily Report: Parsing the results motorola confidential

Demo Daily Report: Data Sheet motorola confidential

Demo Daily Report: Summary sheet motorola confidential

Demo Daily Report: Preparing email motorola confidential

Demo Daily Report: Email template sheet motorola confidential

Demo Daily Report: Preparing email motorola confidential

Demo Daily Report: Sending email motorola confidential

Demo Daily Report: Signal vs Noise and Main Drivers motorola confidential

Demo Daily Report: Key Milestones motorola confidential

Demo Daily Report: Final Email motorola confidential

Demo Daily Report: Scheduling motorola confidential

Agenda • Business overview • Demos • Daily Activations Report • Moto Insights • Drive Insights motorola confidential

Moto Insights Existing Situation - Require VPN - New Report take weeks - New features take months - Issue Tickets come weekly How to provide insights to executive-on-the-go with a robust system where new report take seconds to create? motorola confidential

Demo Moto Insights Moto Insights Web portal Moto Insights App Engine Data Source: Big Query Moto Insights Android App Users Access: Google Users (email) + Datastore (role) Report Meta Data: Datastore Tracking: Datastore motorola confidential

Demo Moto Insights: Main menu & Responsive Design responsive design motorola confidential

Demo Moto Insights: Report Details motorola confidential

Demo Moto Insights: 1st Chart Details motorola confidential

Demo Moto Insights: Chart Types motorola confidential

Demo Moto Insights: Dummy Example motorola confidential

Agenda • Business overview • Demos • Daily Activations Report • Moto Insights • Drive Insights motorola confidential

Drive Insights Existing Situation - Reports are produce by a centralized team - Role management is becoming out of control - Product teams are complaining to have to run SQL repeatedly on BigQuery console How to democratize Analytics within the company while maintaining quality (data & insights) as well as maintain Big Data usage under control? motorola confidential

Demo Drive Insights (v2) Data Source: Big Query Google Drive Drive Insights App Engine Moto Insights Android App Data Source: Google Analytics Drive Insights Web portal Users Access Control: Google Users + Drive Sharing Data Source: Spreadsheet & CSV Report Meta Data: Google Drive Report Meta Data: Datastore (Text file with JSON) (Report copy & usage tracking) iFrame Source: Tableau Server iFrame Source: Google Documents motorola confidential

Demo Drive Insights: New document type motorola confidential

Demo Drive Insights: Report creation motorola confidential

Demo Drive Insights: 1st Chart Details motorola confidential

Demo Drive Insights: 2nd Chart Details motorola confidential

Demo Drive Insights: Chart Types motorola confidential

Demo Drive Insights: SQL Editor (CodeMirror) motorola confidential

Demo Drive Insights: Report document in your Google Drive motorola confidential

Demo Drive Insights: Dummy Example motorola confidential

Demo Drive Insights: Drive Sharing motorola confidential

Q&A ? Dr Patrick Deglon Director of Engineering, Analytics Area Tech Lead Motorola Mobility pdeglon@motorola.com pdeglon motorola confidential

Abstract In this presentation, Patrick Deglon will share his learnings and provide best practices when using open Google tools & API. He will present his daily email report that hundreds of key Motorola stakeholders are receiving to drive the business, as well as a mobile solution based on the latest web technologies, including Google Visualization, Bootstrap CSS and many of the Google APIs (Gmail, BigQuery, Analytics, Drive, App Engine, Users authentication, etc.). motorola confidential

Bio Dr Patrick Deglon Director of Engineering, Analytics Area Tech Lead Motorola Mobility With a PhD in Particle Physics, Patrick Deglon spent the last decade driving business insights at eBay and at Motorola Mobility, a Google company. At eBay, he led significant improvements in marketing effectiveness by developing methods to measure incremental sales, and by running large scale experiments on Internet marketing channels. He joined Motorola Mobility in 2013 to help raise the bar in Analytics and on-board open Google tools and technologies. He is now the Area Tech Lead for Analytics within the Cloud Services organization. He is married with two kids and enjoys his town of Campbell, CA. motorola confidential

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Agenda - Analytics, Business Intelligence and Data ...

... of Predictive Analytics John Elder, ... Reporting and Analytics Ryan Marcum, ... & Business Insight and GM
Read more

Analytics 2015

Topics at this summit include predictive, ... marketing and customer analytics, ... Home; About; Events; Analytics 2015 Home; About; Events; Menu; Prev ...
Read more

What's driving big data and predictive analytics in 2014 ...

What's driving big data and predictive analytics in 2014? ... business to be able to interpret data and feed that insight back into the wider business. ...
Read more

Business Analytics & Insights | VADS

Business Analytics & Insights services help ... using predictive analytics to anticipate maintenance needs ... Promote greater business insight, ...
Read more

Predictive Analytics: What it is and why it matters | SAS

Drive your business with predictive analytics ... A 2014 TDWI report found that the top ... Connect with the latest insights on analytics through related ...
Read more

MCIS - Analytics

MCIS Insights™ incorporates evidence-based guidelines to drive ... Business Intelligence. You ... MCIS, Inc. integrating real-time analytics at the point ...
Read more

Going beyond the data - KPMG US LLP | KPMG | US

KPMG Insight. Moving to predictive analytics. ... Going beyond the data: ... properly exploited through predictive analytics; and that business flexibility
Read more

Analytics Reporting , Simplified. - Megalytic | Better ...

Analytics Reporting, Simplified. Megalytic is used ... producing valuable insight for ... Business Owners. Business owners use Megalytic to set up the ...
Read more