to dashboards - vlamis software...
TRANSCRIPT
![Page 1: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/1.jpg)
TO DASHBOARDS
TUESDAY MARCH 12, 2019 | REDWOOD CITY, CA
DEREK HAYDENVP, APPLICATION DEVELOPMENTOUTFRONT MEDIA
TIM VLAMISVP & ANALYTICS STRATEGISTVLAMIS SOFTWARE SOLUTIONS
HOW OUTFRONT MEDIA IS USING OAC TO ANALYZE MODERN MARKETING
![Page 2: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/2.jpg)
2
MEDIA
ONE OF THE LARGETST OOH COMPANIES IN NORTH AMERICA
CONNECT BRANDS WITH CUSTOMERS
BRAND IMPRESSIONS DELIVERED THROUGH BEST ASSET PORTFOLIO
![Page 3: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/3.jpg)
3
![Page 4: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/4.jpg)
4
![Page 5: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/5.jpg)
5
CREATE BUSINESS INSIGHTS FROM TRANSACTIONAL DATA
REDUCE IT REPORTING INTERVENTION
CONSOLIDATE CROSS PLATFORM REPORTING REQUESTS
REDUCE DEPENDENCY ON LEGACY REPORTING TOOLS
CREATE READILY AVAILABLE ACCESS TO REPORTING
![Page 6: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/6.jpg)
6
PROOF OF CONCEPT DELIVERED IN 5 WEEKS
QUICK WINS TO FACILITATE USER ADOPTION
SINGLE SOURCE FOR CROSS PLATFORM REPORTING
700 USERS BY YEAR 2
SIGNIFICANT IT RESOURCE SHIFT
![Page 7: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/7.jpg)
7
2.0 VERSION OF BICS DASHBOARD
![Page 8: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/8.jpg)
8
STRENGTHS
HIGHLY DESIGNED DASHBOARDS
QUERY DEFINITION POWER
PROMPTS AND SELECTIONS
GOOD CONTROL OF TABLE FORMATS
DECENT SELECTION OF GRAPHS
OPPORTUNITIES
ABILITY TO SET STANDARDS
WEAKNESSES
DYNAMIC LAYOUT - WYSIWYG
HIGH TRAINING COSTS
ENDLESSLY DEEP MENUS
POOR DASHBOARD LAYOUT TOOL
THREATS
VISUAL ANALYTICS AND DATA DISCOVERY
TOOLS
POORLY DESIGNED REPOSITORIES
![Page 9: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/9.jpg)
9
STRENGTHS
EXTREMELY INTERACTIVE
FRAMEWORK FOR BRUSHING
MASHUP
NO RPD REQUIRED
DATA SOURCE CONNECTIONS
LEVERAGES ORACLE SECURITY
OPPORTUNITIES
MACHINE LEARNING IS PROMISING
DATA FLOWS TRANSFORM DATA
WEAKNESSES
HIGHLY DESIGNED DASHBOARDS
WEAK DOCUMENTATION
THREATS
STARTING FROM BEHIND
USERS LOVE TABLEAU
![Page 10: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/10.jpg)
10
INVESTMENT IN CURRENT DASHBOARDS AND REPORTS
ANSWERS ALLOWS MORE CONTROL – E.G. FONT CONTROL
HIGHLY CUSTOMIZED REPORTS – CUSTOM QUERIES
PROMPTS HAVE ADDITIONAL CAPABILITIES (NOT IN DV YET)
MORE CONTROL OVER LAYOUT, ESPECIALLY OF TABLES
ANSWERS OFFERS HIERARCHICAL COLUMNS (NOT IN DV YET)
SELECTION STEPS AND CUSTOM GROUPS – POST-AGGREGATION
![Page 11: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/11.jpg)
11
NEW IN OBIEE 12C – AREA OF ORACLE INVESTMENT
MORE MODERN INTERFACE
SIMPLER INTERFACE FOR AD-HOC USE
MORE INTERACTIVE – E.G. BRUSHING
COMPETES WITH TABLEAU AND OTHER MORE MODERN BI TOOLS
ABILITY TO USE EXTERNAL DATA – NO RPD MAPPING REQUIRED!
MASH UP WITH EXTERNAL DATA (INCLUDING SPREADSHEETS AND CLOUD)
EXTEND WITH CUSTOM VISUALIZATIONS
EMPHASIS ON SELF-SERVICE
![Page 12: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/12.jpg)
OUTFRONT
12
ECONOMICS OF UCC
BICS DASHBOARD MIGRATION
IMPROVED DATA VISUALIZATION
MORE ROBUST SELF SERVICE PLATFORM
ENHANCED MAP VISUALIZATIONS
![Page 13: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/13.jpg)
13
SERVICE MANAGED BY ORACLE
IN DATABASE ANALYTICS & MACHINE LEARNING ALGORITHMS
SCALE ON DEMAND
ECONOMICAL
ADW?
![Page 14: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/14.jpg)
ANALYTICS NEED
14
CHANGING MEDIA LANDSCAPE
OUTFRONT AS A MEDIA PARTNER
TECHNOLOGY AND DATA INVESTMENT
![Page 15: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/15.jpg)
OOH ONLY TRADITIONAL MEDIA EXPECTED TO GROW
COMPLIMENTARY MEDIA TO DIGITAL
15SOURCE: MAGNA GLOBAL, 2018
![Page 16: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/16.jpg)
16
ANALYZE MEDIA SPEND DATA BY DMA
HIGHLY MANUAL EXCERCISE
LIMITED BY EXCEL DATA LIMITS
![Page 17: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/17.jpg)
17
![Page 18: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/18.jpg)
18
ON DEMAND SEARCH FOR
CATEGORIES, ADVERTISERS, AND
MARKETS
IDENTIFY LOCAL AND REGIONAL
ADVERSTIER TARGETS
NATIONAL ADVERTISER SPEND
PROFILES
MEDIA MIX MODELS
HELP SALES ‘CALL PLAYS’
![Page 19: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/19.jpg)
19
UCC CONVERSION EFFECTIVE 1/1
ACTIVATE SERVICES 1/2 ~ 15 MIN
CREATE ADW AND OAC ENVIRONMENT ~30 MIN
DEPLOYMENT
![Page 20: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/20.jpg)
20
1/7 – PROJECT KICKOFF
1/8 – 20 MILLION+ ROWS DATA
1/9 – FIRST PROTOTYPE IN OAC
2/11 – PILOT RELEASE
DELIVERY
![Page 21: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/21.jpg)
21
![Page 22: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/22.jpg)
22
INTRODUCE ADDITIONAL DATA SOURCES
MEDIA MIX COLLATERAL FOR CUSTOMERS FROM OAC
DAY BY DAY FOR TARGETED ANALYTICS VIA MOBILE
MACHINE LEARNING
PREDICTIVE ANALYTICS
![Page 23: TO DASHBOARDS - Vlamis Software Solutionsvlamiscdn.com/papers2019/OUTFRONTBillboardstoDashboards.pdf · 2019. 3. 13. · ooh only traditional media expected to grow complimentary](https://reader033.vdocuments.us/reader033/viewer/2022051814/603a286ccdb49120eb56bdd3/html5/thumbnails/23.jpg)
TO DASHBOARDS
TUESDAY MARCH 12, 2019 | REDWOOD CITY, CA
HOW OUTFRONT MEDIA IS USING OAC TO ANALYZE MODERN MARKETING