440 likes | 460 Views
Welcome To The EiB Analytics 2018 Conference. Presented by Paul Martin, Managing Director EiB. The Day “Wills and Won’ts”. Will Be Thought Provoking You Are Out Of The Office – Time To THINK About Your MI Others Have Done It - EiB , Our Customers, Our Partners
E N D
Welcome To The EiB Analytics 2018 Conference Presented by Paul Martin, Managing Director EiB
The Day “Wills and Won’ts” • Will Be Thought Provoking • You Are Out Of The Office – Time To THINK About Your MI • Others Have Done It - EiB, Our Customers, Our Partners • Ask Them What Works And What Doesn’t ? • Angles On Competitive Advantage ? • Discuss Your Thoughts & MI Concerns / Opportunities / Ideas • Will Be Business & Technically Focused • Hope We Get The Balance Right • If Not, Tell Us • Won’t Be Pure Product Based • Sure We Are Proud Of EiB Analytics & Will Tell You ! • But There Are Many Challenges To Embrace With MI • EiB Will Be Honest About Those Challenges • As Business Users That Does Not Exclude You From Thinking Things Through ! • If You Don’t, You Won’t Get ROI / Maximum ROI
The Dramatically Changing World Of Analytics The Key Challenges We Need to Address Presented by Paul Martin, Managing Director EiB
Key Issues Agenda • Intro To EiB & Rebrand 2018 • MI - The “Three” Things You Need To Get Right • Data Quality, Business Logic and Visualisation • No Silver Bullet ! • Key Issues • How Does EiB Analytics 2018 Help ? • Delivering Automated Applications Now ! • Applications Not Tools • Inherent Error Handling & Correction Mechanisms • Centralised Business Logic • Delivering More With Microsoft’s Power BI • Consider The Way We Interact With Data • Web & Mobile • New Possibilities • Hosting • Access From Anywhere v Access Bolted Down
Who & Why Excel in Business • Performance • Management Team Gentia IPO – $26M • Seed Funding IntelligentApps • ProClarity (UK) -> Microsoft • IntelligentApps Trade Sale • People • Over 600 MIS / BI projects • 15 years R&D, Consultancy • Small, experienced team • Product • First commercial Balanced Scorecard product with David Norton • 4 Excel based BI / Reporting products • First Excel Dashboard product • Pricing • Simple pricing per annum • All costs known upfront • Unlimited user options, no per author / user complexities • Virtual services and training minimizes cost
Rebrand & Product Coverage Today Company / Product Branding 2017 Single EiB Brand 2018 Onwards
Power BI – Think Of The App – Do It Right ! 2 x Models 2 x Sets of Calcs 2 x Maint You’ve just Doubled your Workload ! And Repeated The Excel WorkbookNightmare !
More Data -> More Bad Data !!! Less / Same MI Personnel -> Need For Greater Automation More Complexity -> Need For Simplification
The Incredible Cost & Risk Of Bad Data ! https://hbr.org/2016/09/bad-data-costs-the-u-s-3-trillion-per-year
MI Data Considerations Source SAS Institute • Machine Learning • Works From Sampling Data • No Audit – You Trust The Algorithms • Insurance Example • 24% ALL Information Invalid • 32% Of Location Information Missing • Possible Conclusion • “it is better to do business where the location does not exist !” • Really ??? • Need To Follow Basics • Automated Collection & Error Handling The Start Point • Document The Error Rules • Automate, Correct & Be Confident With Basic MI • Drive Your Business On What You Know & Trust • Then Add Value • Big Data & Machine Learning The Answer ? • Not Until Data Correct / Confident • False Silver Bullet • Great Value Add Potential
MI Data Considerations • What If The Data Needs To Be Substituted ? • Financial Services • Hotels • Important Level Of Complexity • Understanding Ramifications • What If The Data Needs To Be Reconstructed ? • London, Aylesbury, Sussex, England, United Kingdom ??? • Post Codes -> Regions • What If The Data Needs Augmentation ? • Post Codes -> Lat Long • Ages -> Age Bands
Does Your Business Logic Match BI Products • So Often Ignored, So Often High Price To Pay • Time An Obvious Example In Insurance • KPI Analysis In Finance Another • Does Rolling 3 Months Average Over The Last 24 Months Cause A Power Outage ? • Can The Calculation Engine Handle Your Needs ? • Fleet Pooling And Optimisation In Shipping • Earned Premium In Insurance • Stand Back & Think From A User’s Perspective • What Would I Expect At Each Stage Of The App ? • Effort (Cost x 2) v ROI • Interdependencies On Data With Regards To Errors
Need For Thinking Through Business Logic From An Analytics MI Perspective, Is This Earned Premium Against The Metro Or The Jaguar ?
Internal Data / Audience No Longer Adequate ? • Ahead Of Your Target – So What ? • Measurement Against Your Peers • Understanding Ramifications • Integrating External Data • Credit Checking The Data ? • Live Exchange Rates For Impact
EiB AnaIytics 2018 Is A Complete MI Platform Everything You Need To Deliver MS BI Apps 10 Years R&D Real World Focused
EiB Analytics Visual MI Apps Platform • Visual MI Apps for MS BI • Any source • Any output • Automation • Documentation • Grouping • Cleansing • Excel Reporting Addin • SQL / Cube / Tabular • Formatted Reports • Unstructured Reports • Dashboards • Distribution
How It Works In Finance Reports & Dashboards Data MI Database
Open Visual MI Applications Platform Information On Demand D O C U M E N T A T I O N A U T O M A T I O N H O S T E D O P T I O N Pivot Tables Deployed Anyway Cleansed Information Data Warehouse With Reusable Centralised Business Logic Calculations – Time, KPI User Groupings, Data Augmentation Error Handling & Data Quality GDPR Data Encryption Data Acquisition Extract, Load, Transform Web Feed Live Data Files Manual Data Back Office Apps
The Power BI Software – New Opportunities • Why Power BI ? • Best Mobile and Web Data Visualisation Experience • Works On All EiB Analytics 2018 Apps • Out Of The Box • Complements Excel EiBReportStudio • Power BI Desktop • Windows Authoring Tool • Power BI App • iOS, Android, WP 10, Windows 10 • Power BI Full Web Client • Any Browser
Biggest Issue We See With Customers • Access From Anywhere • Cloud System Driver • Azure Is The Answer ? • Not For Everything ? • Controlling Cost As A Constant • Security Is Everything • Access / Hacker Proof • Firewalls On Firewalls • GDPR & General Privacy • Facebook
EiBAnalytics.com - First Multi Tenanted Fully Hosted Microsoft Analytics Platform
EiB Analytics – The Hosted Platform Connections Firewall Routing • Key Strengths • Access from anywhere • Desktop like experience • Full customer segregation • Support for both Dev / Live • Dynamic app / customer • Infra scalable at each level • Affordable (Uptime / DR) • Hosted with advanced local D/E PowerBI Domain License Gateways Backups Automation A/D DNS File Services O/P D/E Snapshots
Summary • EiB Launch Services • Personnel With Combined 120 Year + MI Expertise • Will Challenge You & Your Requirements To Drive ROI • End User Business And Detailed Technical Knowledge • Results Focused • EiB Analytics • Single, Visual MI Platform For Analytical Applications • Handles Real World Applications Data & Business Logic Requirements • Helps Identify & Correct Bad Data • Proven In Vertical Industries & Horizontal MI Applications • Low Risk – Based On The Leading Technology Microsoft Stack • Low Cost • Full Hosting Solution
The Dramatically Changing World Of Analytics The Key Challenges We Need to Address Presented by Paul Martin, Managing Director EiB