Data Warehousing 101 What is a Data Warehouse

Data Warehousing 101: What is a Data Warehouse and Why do I Care? If your company is struggling with effective reporting because data isn't readily available, or isn't consistent, accurate, or up-to-date, or if gathering data for reports causes slowdowns in operational systems - then you may need a Data Warehouse. Join this webinar to learn what a Data Warehouse is, in the context of BI and Reporting for D 365 F&O and Dynamics AX.

Agenda • Introduction • What is the challenge? • Easy BI & Reporting from AX/D 365 FO • Why is it a problem? • Is there a solution? • Data Warehouse – What is it? • How does it work? • Summary • Contact Details • Q&A

Introduction

Problem we solve Other BI Analytics Role-based, embedded, on any device. Unlimited exploration. Design and collaboration tools. Data visualization and analytics. Central data repository. Single sign-on with dynamic security from ERP. Four security configuration layers. Central analytics library. Governance at risk due to manual project. Pre-packaged data model and analytics. Flexible drag-and-drop data modeling. Automated warehouse and semantic layer. No pre-packaged data model or analytics— manual project. Pre-packaged Smart data connectors. Rich data connectivity. Automated data merging. No pre-packaged data connectivity—manual project. Governance Modeling Integration

Challenge

Journey of your reporting environment • Stage 1: I love Excel • Pro – flexibility…. I can do what I want • Con – I can do what I want!! (Data Integrity/ Data Governance) • Stage 2: Buy a popular BI tool like Power. BI • Pro – Reasonable structure to build on • Con – Data preparation is a pain, Responsiveness, Scalability • Stage 3: Should I build a ‘Data Warehouse’

What is the challenge? Data Visualisation / BI Data Source TRANSFORMATION No understanding of table structures Lack of trust in data What if there is more data? Are you allowed to look at this data?

Solution

When to consider a Data Warehouse? • Struggling to report effectively because required data isn't readily available i. e. limited understanding of the table structures of the source system • Data is being copied separately by different departments for analysis in excel that aren't necessarily consistent with one another • Lack of trust in the accuracy of data produced on the reports • BI reporting against production databases causes nightly or monthly processing of transaction data to be very time consuming • Running ad hoc queries against live databases slows down operational systems • Nightmare to ‘unify’ data from multiple systems – Finance system, CRM, HR, ERP, Excel, Historical data etc.

What is a Data Warehouse? A Data Warehouse works as a central repository where information arrives from one or more data sources – Extract (E), Transform (T) and Load (L); ETL.

Data Warehouse relevance to AX/D 365 FO • Data in one place, independent of the source application • Quick response to reporting queries • Ability to transform data for easy consumption • Ability to maximise the capabilities of self-service BI tools like Power. BI • Unify data from AX/D 365 FO with other sources like – CRM, HR, Excel, SQL Database etc. i. e. Scalability • ‘One version’ of your data - TRUST

Summary

Summary • Introduction – Data Management + Reporting • Challenge • Reporting journey – Excel, Power. BI, Data Warehouse • Solution • When – Data Warehouse • What – Data Warehouse • Relevance – Data Warehouse

Contact Details ROHIT KANWARA Sales Executive – ZAP E: rohit. kanwara@zapbi. com P: +44 (0)203 858 7501 M: +44 (0)7985 626 804 W: www. zapbi. com/