power bi showcase - microsoft azure · financial reporting/planning tailored business intelligence...

15
Power BI Showcase Integrated Financial Planning & Analytics (Agility Planning)

Upload: others

Post on 19-Jul-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Po w e r B I S h o w c a s e

Integrated Financial Planning & Analytics (Agility Planning)

Page 2: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

2004

Financial Reporting/Planning

Tailored Business Intelligence Solutions

Cloud Solutions

Predictive Customer Analytics

Founded

Focus

Offices Chicago, Sydney, Brisbane, Kolkata, Zurich

Clients:

Managility Solutions:

Page 3: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Integrated Approach on ONE Platform

Proprietary planning Tool

Specialised Dashboard Software

Read Only Data Warehouse

Data Discovery Tools

Report Writer

Page 4: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Architecture

Page 5: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Power BI and SQL Server have revolutionised Business intelligence…

• Market Leading Data Platform

• Interactive Dashboards and Data Discovery

• Extensive Visualisation Options

• Wide Range of Source Connectors

• Natural Language Query

• Web, Desktop, Excel

• Disruptive Pricing

• Cloud/On-Premise

Page 6: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Agility Planning/Clear Jelly Extend Offering

• One Click Add-on For Accounting

• Business User Controlled Modelling

• Multi User Write Back On Any Level

• Web, Power BI Visual, Excel Frontends

• Superfast in Memory Engine

• Proven, Highly Scalable MS SQL Platform

• Advanced/Predictive Analytics

• Workflow/Notification

• Exact Audit Trails

• Extend/Tailor Solutions With Native API

Page 7: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Excel Add-On, Power

BI Visual, Web App

One Click/Native

Connectors Source

Agility Planning Features

Business User Driven

Modelling

“Single Version Of The

Truth” Data Model on

Standard RDBMS

High Performance

Write Back/Planning

Page 8: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Tailored Dashboards

and Reports

Add Any Source Excel Add-On, Power

BI Visual, Web AppAt a Click Start

Clear Jelly Features

Simple Consolidation

Page 9: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Announced

MS SQL Server Proprietary Proprietary Proprietary Proprietary Proprietary SQL Server

~1k

Minimum

Investment

~$20k

Minimum

Investment

~$20k

Minimum

Investment

~$20k

Minimum

Investment

$140-$170 per

Power User

>$50k

Minimum

Investment

~$100k

Minimum

Investment

BOARD PREVEROCognos TM1JEDOXAdaptiveAnaPlan

PRICING

Agility Planning/Clear Jelly

NAME

EXCELINTEGRATION

MODELLING

SELF SERVICEPROVISION

IN MEMORYENGINE

POWER BIINTEGRATION

The Market

ENGINE

Page 10: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

The Business User In Charge:

• Easy to Use Business Modelling

• Multi User Write Back On Any Level

• Web, Power BI Visual, Excel Frontends

• Superfast in Memory Engine

• Advanced/Predictive Analytics

• Workflow/Notification

• Exact Audit Trails

• Extend/Tailor Solutions With Native API

Page 11: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

It Only Takes 2 Minutes to Get Started:

Page 12: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Business Modelling

Advanced financial

consolidation

Identify driving factors and

use in responsive models

Add new calculations with

powerful rules engine

Simulate introduction of

new product, acquisitions etc.

Page 13: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Power BI Visual Integration

Native Power BI Visuals:

Data Entry (Top Down/

Bottom Up In Matrix

IBCS Visualizations

Comments

Page 14: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

Live Link for flexible reporting and writeback from Excel

Writeback from Pivot Table

Flexibility through Cell Based

Reporting

Modelling

Page 15: Power BI Showcase - Microsoft Azure · Financial Reporting/Planning Tailored Business Intelligence Solutions Cloud Solutions Predictive Customer Analytics ... MS SQL Server Proprietary

16