Download - Future of BI Deck
![Page 1: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/1.jpg)
The Future of Business Intelligence
Helping yourself to insightIan Pepper, 27/03/17
![Page 2: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/2.jpg)
What I’m going to cover
• Me • Future of BI?– Data Lakes– Self-service
![Page 3: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/3.jpg)
Who is Ian Pepper?• Head of Strategy and Integration for Novartis– Big Data, Analytics, Blockchain, RPA and IoT
• Previously was CTO and co-founder of a bunch of companies
@ianpepper linkedin.com/in/ianpepper
![Page 4: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/4.jpg)
DisclaimerThis presentation was prepared in a
personal capacity. The opinions expressed here are my own and do not
reflect the views of Novartis.
![Page 5: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/5.jpg)
Data Lakes
![Page 6: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/6.jpg)
The future of data management and BI?
![Page 7: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/7.jpg)
Often more of a Data Swamp
![Page 8: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/8.jpg)
Why?
![Page 9: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/9.jpg)
As business leaders what do you really need to
know?Really?
![Page 10: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/10.jpg)
Tips from the Field• Don’t ingest data unless you are sure you’re going to use
it• Governance is a must• Metadata is key, repeat metadata is key!• Deploy multiple SQL-on-Hadoop tools for flexibility (Drill,
Impala, ...) – Logical warehouse• Use Spark for processing (inc. SparkSQL)• Data warehouses and marts are not dead!
![Page 11: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/11.jpg)
We have a Data Lake. So, how do we extractreal value?
![Page 12: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/12.jpg)
Often that’s this guys responsibility
Introducing the Data Wizard or Data Scientist
![Page 13: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/13.jpg)
Jargon Buster• How to talk to a Data Scientist– Data Extraction, Preparation, Model Building,
Testing, Validation and Deployment, Rinse and Repeat
– Leading to Actionable Insight (Value)
![Page 14: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/14.jpg)
Flavours of Analytics/BI
The Advanced Stuff or the Future!
![Page 15: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/15.jpg)
But, we have a problem where are all the data
scientists?
Can we do without them?
![Page 16: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/16.jpg)
![Page 17: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/17.jpg)
![Page 18: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/18.jpg)
Data Availability and Tooling are key to success
![Page 19: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/19.jpg)
Self-Service tools do the heavy lifting.
So we can focus on the problem
![Page 20: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/20.jpg)
Characteristics of Self-Serve• Point and click (code optional)• ML and Model Library• Seamless data blending and preparation• In-database joins (server side push down)• Auto-create MapReduce and Spark jobs• Visualization (e.g. produce Tableau output)
![Page 21: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/21.jpg)
![Page 22: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/22.jpg)
Remember – data with a
lot of information
![Page 23: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/23.jpg)
… and a lot of noise.
![Page 24: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/24.jpg)
The ability to hear the signalfrom the noise is the key…
![Page 25: Future of BI Deck](https://reader036.vdocuments.us/reader036/viewer/2022062523/58edabeb1a28ab98118b457d/html5/thumbnails/25.jpg)
Thank you!