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

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

Integrated Financial Planning & Analytics (Agility Planning)

2004

Financial Reporting/Planning

Tailored Business Intelligence Solutions

Cloud Solutions

Predictive Customer Analytics

Founded

Focus

Offices Chicago, Sydney, Brisbane, Kolkata, Zurich

Clients:

Managility Solutions:

Integrated Approach on ONE Platform

Proprietary planning Tool

Specialised Dashboard Software

Read Only Data Warehouse

Data Discovery Tools

Report Writer

Architecture

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

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

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

Tailored Dashboards

and Reports

Add Any Source Excel Add-On, Power

BI Visual, Web AppAt a Click Start

Clear Jelly Features

Simple Consolidation

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

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

It Only Takes 2 Minutes to Get Started:

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.

Power BI Visual Integration

Native Power BI Visuals:

Data Entry (Top Down/

Bottom Up In Matrix

IBCS Visualizations

Comments

Live Link for flexible reporting and writeback from Excel

Writeback from Pivot Table

Flexibility through Cell Based

Reporting

Modelling

16