7 ways of Reporting & Analytics
There are different ways of Reporting and Analytics meant for different purpose. 1KEY has range of reporting and analytics capabilities, from the simplest to the most advanced. Given below are seven ways of reporting and analytics:
1KEY View provides users the flexibility of analyzing data and creating reports of great business value. 1KEY View has been engineered to fully address the BI needs and reporting requirements of your organization helping you to compete and win in the marketplace without much effort or compromise.
1KEY View provides two-dimensional tables for runtime analysis, grouping and column customizations with Parent-Child Relationships, Drill Down and Drill Back functionalities, etc. A two-dimensional, extremely intuitive report formatting and analysis tool for Business users.
![]()
1KEY Cube is a comprehensive data analysis, data mining, and multi-dimensional visual reporting solution.
With its powerful data architecture, 1KEY Cube is able to slice and dice information efficiently and provide customers with an extremely intuitive experience. Regardless of the perspective, data can be rendered to answer business questions – and best of all – it allows business users to focus on business rules rather than creating dozens and dozens of reports.
It is a powerful tool conceived to help the business user to understand their data, to compare and contrast scenarios, and to deliver this information inside and outside of their organization.
With 1KEY Cube, user can visualize multiple Charts within cubes based on selected data. 1KEY Agile has the rapid in memory cube which represents raw data for multi dimensional analysis.
It has numerous runtime customization options that help users to create on the fly report / layouts with various permutations of dimensions for runtime analysis.
With 1KEY Cube, users can drill down raw data in any manner they require using the easy-to-understand pivot table functionality like excel and instantly render the desired output. By incorporating 1KEY Cube in your application, you can deliver an almost endless array of reports – without hassles.
![]()
1KEY Chart is a graphical representation and visual reporting which represents business performance via stunning and meaningful diagrams. It helps to drive organizational achievements by giving information in a much consolidated and easy to understand manner.
Users can do filtering & change the chart type (column, bar, line, pie, dial gauges, speedometers, heat maps and many more data visualization methods) on run time to derive more value from data.
Runtime user definable drill down & drill back functionality available direct from the graphic representations. Customer segmentation, forecasting, trend analysis, etc. is all made easy for proactively managing and monitoring business processes.
![]()
Using wizards of 1KEY Dashboard, users can define their own Dashboards having combination of multiple reports like View, Gauge, Chart, KPI’s, RSS Feeds etc, on one single screen.
1KEY Dashboard gives single window to view all types of nos., facts & figures in multiple-way, multi data presentation. E.g. CEO requires complete performance of Sales, Orders in hand, revenue v/s budget, its outstanding, Cash Flow, Salesman performance, Product wise stock in hand, Budget & Expenses etc.
1KEY Dashboard is lightweight and valuable extensions of 1KEY BI deployments. They are lightweight because they access only the portions of data needed by a particular user and can be rapidly built by either consultants or internal IT staff. They are valuable because they immediately disseminate data to a large number of employees and eliminate labor-intensive data gathering workflows.
![]()
Key Performance Indicators (KPIs) are high-level snapshots of a business or organization based on specific predefined measures. KPIs typically consist of any combination of multiple reports.
They may include global or regional sales figures, personnel stats, real-time supply chain information, or anything else that is deemed critical to a corporation’s success.
- Visualize key performance data effectively with graphical pointers
- Convey performance results quickly with visuals
- Monitor red zones & define threshold levels to set indicators & trigger alert deliveries
- Link individual KPIs to corporate goals
1KEY KPI allows goals to be observed with different warning colors that will be switched on as defined giving the user a quick view of how well or how poorly each goal is met.
1KEY KPI can give a business executive a high-level, real-time view of the health of a company by visually displaying vital statistical information about that company. In developing KPIs, a user or developer defines target performance levels and then decides the best way to represent variance from that target.
Business users are empowered to set the KPI values on their own without depending on the IT team.
1KEY Reporter is a client side application that builds report based on query model. Using a simplified interface you can link multiple queries & create on-demand reports.
![]()
Using 1KEY Reporter’s interface, developers can drag & drop fields to arrange data fields on a page intuitively.
1KEY Reporter is a generic report writer for designing compliance reports, pre printed forms, vouchers printing and viewing. It gives freedom to create a range of simple to complex reports.
Thanks to intuitive reporting integrated development environment.
Developer can do multiple event formatting, runtime scripting for each cell with J#,C#, VB.net. It has formula & function editors which can be embedded with reports. It has enhanced formula builder having VB Functions, Financial, Math, Conversional, String, Aggregate with advanced conditions & multiple operators
![]()
1KEY Agile has intuitive visual data representation of OLAP and raw data in hierarchical tree based drill down expandable structure. 1KEY Tree allows users to read MAIA OLAP models, SSAS’s cubes, Query based OLAPs. It is built on concept of On-Demand Load which increases performance.
1KEY Tree is used to drill down into a number and see the relative importance of each of its constituent parts. When you drill down into any dimension at any node in the tree, the OLAP client ranks the next level of detail from left to right by value and percentage of the total. In this way the user can readily grasp the relative importance of any group of products, sales regions, customers, or any other dimension of the cube.
It allows users to do further filters, displaying results in charts, setting other aggregates like %age, Min, Max, counts, etc. and also export & email. User can save their own layouts for what they drilled from any of the model.
Posted on December 29th, 2008 by Vikram Kole
Filed under: Business Intelligence, Emerging Trends







Hi,
I found this article very informative and it gives good idea of how reporting and anlaytics can be used for competitive edge! keep it up.
Regards,
Shahid,
http://www.bi-dwh.com