340 likes | 347 Views
EiB Analytics 2018 Excel in Business. Any Data ………. Packaged As Reporting Apps. Delivered From Your Tool Of Choice. EiB Financial Analytics – The Start Point. Reports & Dashboards. Data. MI Database. EiB AppStudio - Open Visual MI Applications Platform. D O C U M E N T A T I O
E N D
EiB Analytics 2018 Excel in Business
EiB Financial Analytics – The Start Point Reports & Dashboards Data MI Database
EiB AppStudio - Open Visual MI Applications Platform 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 Information On Demand Pivot Tables Deployed Anyway Cleansed Information Data Warehouse With Reusable 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
Themes For Development Business Logic Data Validation
What’s New In EiB Analytics 2018 • Application Hosting • Budgeting & Forecasting • Power BI Integration • User Interface Enhancements • A La Carte -> EiB • General Dialogue Boxes Improved & More Information • Report Headers Single Line • PCI Compliance • TLS 1.2 • Train Of Thought Analysis • Multi Versioning Of All Reports etc • Pivot Table Synchronisation • Better Navigation - Large Dimensions • Support SQL Server 2017 • New Menu Creator Packaging • EiB AppStudio
Why the need for Budgeting and Forecasting? • Report from PWC – 69% of financial executives surveyed named budgeting and forecasting an improvement priority in finance • “most finance executives heartily agree that the time and effort expended on the most mechanical tasks associated with budgeting and forecasting—tasks like data-gathering, reconciliation, and consolidation—would be better spent on more valuable activities.” PWC • “A fully integrated performance management framework is essential to provide corporate visibility of the activities that directly deliver growth, and provide a clear framework for determining how to continuously allocate resources to support the strategy.” KPMG
Budgeting / Forecasting Process Audit trail of changes written back to EiB Analytics including user / date time / dimensions / values & member details EiB Analytics Audit Trail Table MS writeback gets recreated using audit records. Committed changes written back to SQL writeback table EiB Financial Analytics Cube Data capture in reports MS Writeback Table SQL writeback table used in subsequent cube updates (gets recreated from EiB Analytics audit table) Committed changes written directly to cube Writeback Partition
Power BI – Reusability & Standards NOTE : Needs SQL Server 2017
Larger Dimension Handling A La Carte 2015 EiB Analytics 2018
Summary Of EiB Analytics 2018 • Big Release • Hosting One Of The Biggest Elements & You Can’t See This ! • Budgeting & Forecasting Important Evolution • Power BI Offers More Analytical Features Plus Web / Mobile Deployment • Commercially Available Since December 2017 • Plan Your Release • Talk To Us • Support Wise (Current Release + Current Release -1) • EiB Analytics 2018 and A La Carte 2015 Supported • A La Carte 2014 and 2013 No Longer Supported • Longer Left = Higher Cost
EiB Analytics 2018 Excel in Business