Data Analytics

Alignment

The explosion of data has led to advancements in data analytics and the tools that accompany it. There is no end in sight, and the human race will continue to expand the scope and extent of data analysis indefinitely. Every service provider now offers data analytics in some shape or form, and we want to be part of this journey - KPI included.

We can’t do everything, so KPI has decided to focus on data analytics on things we have succeeded in the past or know that we have the IP to go really deep into:

1. Analytics that the office of finance is concerned with as part of the month-end process:
2. Budget analysis
3. Forecast analysis
4. Variance analysis
5. Margin analysis
6. Working capital movements.
7. Data analytics focused on key assets where there is often potential to unlock profitability that flows straight through to the bottom line:
8. .Customers profitably / Activity-based costing
9. Balance Sheet Analysis / Asset Utilization & Performance
10. People productivity
11. Analysis of key data directly linked to the business strategy:
12. Business KPIs
13. Projects and Portfolios
14. Analysis of OKRs and cascading action plans
15. Key data that lives outside of ERP and CRM uncovered during the strategy execution process.

Analysis

Many users don’t know how to analyse data. However, data literacy is becoming as important as financial or English literacy. There is tool training which shows users how to use the tool to analyse data, but for the most part, users don’t have a simple framework to apply. At KPI, we have developed 10 Tips to Get insights from any set of data. We impart this knowledge through:

1. Workshops
2. Training courses
3. Data literacy programmes
4. Graduate Programmes

Coming soon: Download the cheat sheet here or attend a 30-minute free online course where you can get an introduction to the 10 principles. Maybe that’s all you need to take your data analysis skills to a new level.

Automation

In terms of data analytics automation, we use Qlik and Power BI.

Power BI

Power BI is part of the Microsoft suite of products. We use it when:

1. The data sets are simple, or there is an existing data warehouse.
2. High-end visualisations are required.
3. The client has it as a corporate standard.
4. More in-depth analysis is required from the Smartsheet application that we built to address a pain point.

We have certified Power BI consultants and partners who add capacity and capability when required.



Qlik Sense

Qlik Sense is a versatile platform designed to meet various analytics needs, ensuring top-notch performance, trust, and governance. It is particularly powerful with large and complex data sets.

The agility of the product is unmatched. Its user-friendly interface offers a modern and intuitive experience, featuring self-service capabilities within a governed framework, centralized application deployment, and the ability to create customised analytics apps and mashups.

With Qlik Sense, you can empower your mobile workforce, thanks to its responsive design that adapts seamlessly to any device. Additionally, Qlik Sense leverages a scalable cloud-based architecture for the rapid deployment of a wide spectrum of analytics.

It incorporates cutting-edge AI capabilities driven by the Cognitive Engine, enhancing your analytics experience by providing context-aware suggestions and automation.

At KPI, we offer a comprehensive suite of Qlik implementation, support, and optimisation services to help you make the most of Qlik Sense and transform your data into actionable insights.

We have certified consultants and are an authorised reseller of the product suite.