Business Intelligence Overview
Business Intelligence Visualisations
Analytics From a bird’s-eye view to deep insights
Trademarks Pronto Software, Pronto, Pronto Xi, the Pronto interrobang logo, the P interrobang logo, Pronto Woven, Pronto iQ and Pronto Cloud are all registered trademarks of Pronto Software Limited. All other marks are the property of their respective owners. Copyright © 2023 Pronto Software Limited (ABN 47001337248).
Disclaimer This document contains statements related to our current and future developments that may constitute forward-looking statements. They are subject to changes and may be available in a Pronto Xi 770 service pack or future release of Pronto Xi. All diagrams, drawings, product screenshots and any other types of visualisations in this document, use demo or synthetic data created for display purposes only.
Analytics Contents From a bird’s-eye view to deep insights
4
Authoring Tools
6
User tools Data tools
6 6 7 7
8
9 10 11 11 11 11 11
12
13 13 13 13 13 13
14 14 14
From a bird’s-eye view to deep insights Create smart and interactive visualisations with Pronto Xi data to tell rich, engaging business performance stories
Pronto Xi fully integrates with IBM™ Cognos™ Analytics*, an enterprise-level solution for report authoring and distribution. Providing an enhanced understanding of your data, Pronto Xi and IBM Cognos Analytics empower you to make smart, informed decisions on your business strategies. Create beautiful interactive reports and dashboards that can be consumed both on the web and on mobile devices. As a result, everyone receives the information they need – while only being able to access to the information you want them to see. Run reports on demand or schedule them in advance so they are delivered at the right time with actionable insights. Business Intelligence (BI) delivers out-of-thebox operational and financial reports, while IBM Cognos Analytics provides the tools to build custom reports and dashboards that are specific to your requirements.
The Pronto iQ team can also help you to uncover the more advanced features of IBM Cognos Analytics, such as data exploration, to optimise data-driven decisions. Visualise your data in dashboards, reports, and stories. There are a plethora of widgets available – including charts, tables, key performance indicator (KPI) figures and more – as well as the ability to drill down to the underlying data. Visualisations use underlying Pronto Xi data as a source, including the KPI Library and Data Intelligence reports. Other sources include Excel, databases and more. These sources can be merged into data models, datasets or specialised Analytics Cubes to create optimised data sources for high-performing visualisations. Made for the enterprise, IBM Cognos Analytics also comes with in-built access control and security to protect one of your most precious assets – your business data.
Create meaningful visualisations with figures and charts
*IBM and Cognos are trade marks of International Business Machines Corporation, and are registered in many jurisdictions
5
Authoring Tools Create and deliver the most compelling datadriven stories about your business with Pronto Xi’s out-of-thebox tools and IBM’s leading data analysis platform, IBM Cognos Analytics IBM Cognos Analytics has multiple components, all playing a specialised role to help you manage and get the most out of your data. When IBM Cognos Analytics is combined with Business Intelligence, users have the ultimate power to get the most out of their data. With our BI licences, your team can run reports and view dashboards with BI essentials, or create reports and dashboards through BI Designer. Also manage all your server, user and schedule administration tasks with BI administer. Advance your analytics with our BI Unlimited licence and garner unparalleled insights into every aspect of your business by reporting on all your data together regardless of its source alongside your Pronto Xi data in IBM Cognos Analytics.
6
User tools BI’s dashboarding capabilities make it easy to explore your data. Create visualisations simply by dragging fields onto the canvas and letting Cognos Artificial Intelligence (AI) automatically determine the best way to display that information. Similarly, map creation is as easy as dropping data onto the authoring canvas. With in-built Global Map Intelligence, BI allows you to report at a global level or even at an Australian postcode level. The ability to zoom right down to the street level helps you go from eagle’s eye view to a more localised view on your business data – in one screen. A simple interface makes deploying insightful dashboards to your organisation faster than ever, while Cognos Functions gives you the ability to craft your own custom calculations. Through BI Administration, you can set reporting date ranges, user roles, and even security policies for Mobile BI users such as time expiry on cached mobile report content.
Data tools Enrich your Pronto Xi business transactions data by uploading your own information. Using IBM Cognos Analytics datasets, external data – such as GPS, weather and foot traffic – can be dragged and dropped into your reports as easily as your Pronto Xi data, providing you with a deeper understanding of trends and analyses.
Data Modules and Datasets
Data Models and AI
A dataset is a smaller subset of your entire business data that can be used in a dashboard or report. Using a dataset as a source makes it significantly easier to retrieve data on the dashboard. By requiring fewer queries, datasets also reduce the burden on your business database. When datasets are combined with other sources such as existing packages and uploaded data, they are grouped into data modules to be used on dashboards or reports.
BI’s enhanced modelling components enable you to aggregate multiple sources of data, ranging from Excel spreadsheets, relational databases, text files and more. These fused models can then become the source, allowing you to create meaningful visualisations in the form of reports, dashboards and stories.
Upgrade your business intelligence capabilities by creating and modelling new data packages with our Data Module and Data Explorer licenses. With this toolset, you can create repeatable and consistent data modules to publish to your users, giving them everything they require. Data Explorer harnesses the depth of the IBM Watson AI engine to derive forecasts and key data drivers to rapidly uncover hidden insights.
Gain meaningful insights from data you can trust with AI-powered automation and insights in IBM Cognos Analytics. With its natural language AI assistant, just describe the question you need the answer to or a hypothesis you want to test and let the AI build stunning visualising providing you the needed insights.
7
Visualisations Packed with data visualisation tools and in-built artificial intelligence (AI), Pronto Xi easily surfaces the most appropriate visualisation for the data being explored
20/20 vision
8
Business Intelligence (BI) enables you to analyse data faster and produce stunning dashboards that are easy to create and customise, giving you a powerful view across your business.
Workspaces KPI Workspaces is an interactive canvas that displays relevant business key performance indicators (KPIs) to each staff member.
Select from pre-defined measures in the KPI Library to easily see how your business is performing. Designing your own KPI Workspaces canvas is simple, with a user-friendly layout that makes it easy to add the widgets you need and change them as your information requirements evolve. Quickly alter the layout of the widgets, select different chart types and more.
KPI Workspaces is customisable, allowing you to include only what you need right now, while aggregated data makes for fast performance. Choose from a wide range of visualisations to display your insights.
View real-time streaming dashboards
9
Visualisations | Analytics
Create customised charts using fused data models
10
Key performance indicators KPI Analysis tools allow you to go deeper into your business data, giving you the insights to understand your business performance and to determine exactly how you are tracking against critical business goals. Choose your drill path, and slice and dice the data to explore the relationships that matter to you, including performance by territory, categories, time period and more. Apply
custom filters to focus only on the most important data, add multiple variables, and analyse trends over time. BI offers a range of visualisations to help you display the data in a meaningful way, making it easy to share your vision with other users, while powerful drill-downs allow you to get to the source of the data for more in-depth analysis.
Powerful drill-downs Dashboards allow you to access and interact with high-level data in the form of visualisations. When more detail is needed, it is easy to drill down to the reports that the visualisations were based on and, in turn, drill down further to the underlying data. This can enhance your understanding of the visualisation and help you to consider the impact of a number of variables.
Data stories Data stories help to improve your audiences’ understanding of business data. Data widgets can be sequenced in a scene template, and multiple scenes can be created to help tell a business story. You can share and play back these animated story scenes to highlight the light-bulb moments – giving you the power to link data insights to desired outcomes.
IBM Cognos Analytics custom reports BI is fully integrated with IBM Cognos Analytics, giving you to ability to create a wide range of custom materials. Run, schedule, export, and share reports as required – all in the format you need them in. You can even specify the scope and type of information presented in each report, tailoring it to individual audiences’ needs. Cognos® custom reporting allows you to author meaningful data displays at any level of the business, homing in on the areas that matter to you. Combine data from different reports to give you a more complete business performance picture – without losing any of the details. Create custom reports for real-time performance monitoring, and schedule regular content for presentations and board packs.
Mobile access
Real-time operational reports
In an increasingly mobile business environment, it’s vital to have the same level of access to your data, no matter where you are.
BI delivers ready-to-go operational reports, providing awareness of the day-to-day performance of the business. These include a suite of financial reports, as well as commonly accessed reporting on Pronto Xi’s Sales, Purchasing and Service modules, among others. Instantly check inventory history, revenues, engineer allocations or any other key reports.
With Pronto Xi’s Mobile BI app, you can stay connected on the go, giving you access to your data and the ability to receive alerts on your phone.
You can create real-time reports from live transactional data, or schedule and deliver them via email. Report data can be exported in a wide range of formats to cater to the needs of all users.
Thanks to IBM Cognos Analytics, Pronto Xi users can enjoy the same rich visualisations on their smart devices. The responsive layout allows you to view multiple chart types on your smartphones and tablets, and drill into data levels as required. The IBM Cognos Analytics interface was specifically designed with touch screens in mind and adapts to smaller screen sizes.
11
Data Behind Pronto Xi’s rich visualisations, a vast amount of data drives the reports you use to make daily decisions Whether you are accessing KPI snapshots via Workspaces or building real-time reports from transactional data, Business Intelligence (BI) delivers all the answers you are looking for.
For large dataset analytics, Analytics Cubes is a powerful tool that processes high volumes of data at a rapid rate, meaning you no longer need to spend time waiting for your reports to run.
From numbers to insights
Create insightful data stories
12
Key performance indicators KPI Library includes a large number of industry-standard key performance indicators (KPIs) and business metrics. Data is aggregated across most Pronto Xi modules – including General Ledger, Accounts Receivable, Sales, Inventory and more – and stored based on pre-defined drill paths, delivering fast access to your critical data. Choosing your own snapshot frequency means the data is as fresh as you need it to be.
Transactional data Access your operational data and build reports and dashboards with IBM Cognos Analytics. View real-time data when you need it, improving the accuracy and timeliness of your operational reports and monitoring. Real-time operational reports are equipped with in-built filters, giving you greater control over the information that is displayed.
External data IBM Cognos Analytics makes it easy to upload data from external sources, cleanse it and then use it to create datasets and data modules. By linking this data directly to the Pronto Xi transactional information, you gain deep insights into trends.
Data quality When you rely on your data to make critical decisions about your business, its quality and integrity of data are of the utmost importance.
DQM also has a range of advanced data correction tools to help with system migrations, poor quality data from legacy systems, and more. In addition, DQM can be run in the background, ensuring the quality of the data without impacting on users.
Data tables Data Intelligence (DI) simplifies the creation of your own data tables. A user-friendly interface makes it easy to create, filter and sort data tables, without the need for advanced technical skills. In addition, DI Objects allows you to effortlessly merge existing tables, input calculations and other rules, and combine data from multiple tables. Schedule data populations to happen in the background, and then automatically create list-style IBM Cognos reports or author more complex reports.
Data exploration You do not have to be an data scientist to uncover insights from interconnected data. IBM Cognos Analytics’ exploration functionality helps you to discover hidden relationships and patterns in complex data. With this information, you can create insightful, simple and easy-to-understand data relationships, which you can then harness in your reports and dashboards.
Data Quality Management (DQM) provides you with visibility of, and confidence about, the integrity of your data. DQM monitors your data’s integrity and relationships, and highlights areas that require attention. You will receive alerts and can access a dashboard of exceptions to review and act on.
13
Next Level Analytics Make informed strategic decisions quickly with Pronto Xi Business Intelligence (BI) offers advanced business analytics, with supercharged infrastructure options – using Microsoft Analysis Services and SQL server data warehousing technology – that make reporting on large volumes of complex data even faster. Get your data in seconds, and consolidate multiple servers, datasets and complex company structures to reveal the full picture of your enterprise.
Analytics Cubes Analytics Cubes is a fast and efficient way to deploy advanced business intelligence infrastructure, for a fraction of the cost of other solutions. Analytics Cubes supports snapshot data, allowing you to analyse past performance trends and multi-dataset reporting at an enterprise level. Importantly, Analytics Cubes is designed to analyse data, not just store it – and it can do this at a rapid rate. With this powerful tool, you have the power to combine and consolidate multiple instances of Pronto Xi data, giving you a complete overview of complex business structures and scenarios. You gain the ability to create dynamic “what-if” reporting forecasts, which can help you make decisions and set your business strategy.
14
From data to diamonds
ETL Express ETL Express makes it easy to blend Pronto Xi transactional data with existing data warehousing solutions. ETL Express only extracts data that has changed, which makes the extract, transform and load (ETL) process as quick as possible. Fully compatible with Microsoft SQL Server, ETL Express leverages the power of the SQL Server Integration Services platform to efficiently integrate Pronto Xi data.
About us
We are an Australian developer of award winning business management and analytics solutions. Pronto Xi, our Enterprise Resource Planning (ERP) software, integrates accounting, operational and mobile features in a single system – optimising business processes and unlocking actionable insights. That’s why for more than 40 years, over 1,500 Australian and global organisations, across a wide range of industries, have trusted Pronto Xi to simplify their most complex challenges. With headquarters and our Development Centre located in Melbourne, we have support offices and consultants based across Australia, as well as a global network of Resellers and Solution Partners. Specialised business units within Pronto Software have the expertise to assist you with pivotal technology – Digital Transformation with Pronto Woven, Cloud and Hosting services with Pronto Cloud and Business Intelligence solutions with Pronto iQ. When you choose Pronto Software, you gain a team with deep industry experience, giving us the ability to understand your specific needs and build innovative solutions that drive business growth and revenue.
pronto.net
Pronto-Software
@ProntoSoftware
ProntoSoftware
P_AO_Analytics_02_1023
info@pronto.net 1300 PRONTO (1300 77 66 86)