Too often do we focus on the frontend technology features and benefits. The real genius is in the data engineering skills required to extract the data


Services Around the Microsoft BI Ecosystem

Microsoft has a dominant strong position in nearly all aspects of business intelligence platform technologies. Excel and SQL Server are already deployed in many organisations and offer tremendous analytics power. Particularly with the Analysis Services multi-dimensional data store and since Office version 2010 with the addition of PowerPivot and the cloud based Power BI solution in 2014. The Managility team includes some of the most competent specialists for the Microsoft BI ecosystem who support our clients with the implementation of effective solutions. In particular we offer expertise in:


Data Warehouse
Data Integration
Analytical Databases (OLAP)
Data Mining
Data Discovery
Geo Spatial Analysis
Data Analysis

Microsoft Solution

SQL Server Data Warehouse Design
SQL Server Integration Services
SQL Server Analysis Services
SQL Server Data Mining
Microsoft PowerPivot and Power BI
Microsoft Power BI
Microsoft Power Map
Microsoft Power Query

To learn more about how Microsoft Business Intelligence solutions were successfully implemented at our clients visit our Results Section.

For the quickest start to experience the power of Microsoft BI ecosystem we offer the Managility Fast Start Program 

For further details us:

Contact Managility  

Asia Pacific: +61 1300 007256)

US:  +1 800 270 0691

Microsoft Power BI is a set of technologies that transforms your company’s data into a broad range of modern data visualizations, using an easy-to-use report authoring experience. Stay in the know, spot trends as they happen, and push your business further.

Managility has worked with Power BI since its inception among others responsible for developing some of the initial Power BI demo models (Public Company Financials). In addition, we are using the technology as part of our own Clear Jelly offering and have had a variety of successful implementation in the Asia Pacific region. All this enables us to help our clients implement Power BI in the fastest possible time and realise the benefits from one of the most innovative data discovery solutions on the market.

Experience Power BI the fastest way with our Fast Start program that combines:

• Requirements Analysis
• On the Job Training
• Building Working Prototype With Your Data

Watch a short introduction of Power BI in combination with data from cloud based accounting solutions here:


• Integrate OLAP/Data warehouse and cloud based data streams
• Better control of backup and restore and audit: trace every transactions
• Expands analysis options to any business intelligence tools that is compatible:
e.g. latest Microsoft BI components (Power BI, PowerPivot, PowerView and Power Map)

Different BI requirements typically require different database architectures. These fall broadly into two categories: transactional/relational data warehouses and multidimensional.

A transactional data store (e.g. MS SQL Server, Oracle, etc.) typically handles high data volumes and enables flexible analysis, whereas multi-dimensional architectures (like Jedox, TM1, etc.) are optimised for write back, simulation and modelling.

This multi-tiered approach typically results in integration challenges, when a combined view is required. Extensive ETL (Extraction, Transformation and Loading) processes have to be developed which require extensive consulting or internal development efforts.

The new Managility PowerSync framework addresses this challenge with a one click solution that converts and synchronises OLAP sources into a relational dimensional model.

This enables:

• A one version of the truth Data warehouse that integrates all BI architectures for example easily create a Power BI dashboard with your Jedox data
• Complete control of of all transactions for audit and restore purposes
• Access with nearly any BI front end/ reporting tool that supports relational access (Power BI, YellowFin, Tableau, etc.)
• An easy integration of external cloud based data streams
The PowerSync framework is currently available to Managility clients with every project implementation. A stand-alone, public available software version will be released soon. Please contact Managility to discuss partnership and early adopter options.


Platform: Windows .NET Server component or Python Service for Linux

Supported RDBMS: MS SQL Server, Oracle

Supported OLAP: Microsoft Analysis Services, Power BI, Jedox Base and Premium and Palo. TM1 support coming soon.



Please fill the form below to access your resource.

Please note that by submitting your personal data in this form, you consent to receiving electronic messages and other communications from Managility. You may opt-out of receiving further communications at any time. For further information please see our Privacy Policy.


Your Cart