Analyze your data with bisTrack’s data cubes
Data cubes (or OLAP* cubes) are an excellent visual tool for looking at your company’s data and KPIs. The data cube builder can be used whenever you need to filter and aggregate your bisTrack data and build a business intelligence report.
A simple wizard guides you through the data cube building. For example, you could select sales and margin by branch, by rep and by major product group.
You can then build the cube. Further on, you can work with the results in Microsoft Excel, or any familiar reporting and analysis tool. Data cubes are a terrific way of presenting your sales data visually. Every copy of bisTrack ships complete with the data cube creator and viewer.
Working and reporting with data cubes
You can sort the data in your cubes in as many ways as you like. The query you first build is just an initial view — you can ‘slice and dice’ the data any way you like, once the cube has been built.
Cubes give you new insights into your sales and purchasing patterns and because it is so easy to look at the figures in so many ways, you can quickly pick up patterns that would require hours of analysis using traditional printed reports.
Extended reporting
Your unique needs demand flexible analysis and reporting. bisTrack gives you access to well-structured tables for custom reporting and queries. We use standard SQL database tables, so your data is all fully accessible. It’s your business data – do what you like with it!
Data structures
Product group coding can be up to five levels deep, and is not limited to a simple product analysis code. Analysis measures may be sales value, cost and margin. For lumber and building material you can get statistics by piece, board foot, square foot or lineal foot.
Analyze ALL your business data
Any other bisTrack table can be used as source data for reports or queries. For example, stock movements, sales order header/lines, purchase order header/lines and invoice lines, to name a few. Reporting on business trading patterns and performance is all the more easily communicated to people in your business.
Reports library or custom — you choose
bisTrack ships with a huge library of standard reports, so the chances are there’s a standard report for your needs. Access to your data doesn’t have to stop there. We also provide a copy of Crystal Reports to create your own or modify those provided to you. Plus you can use any other tool in the marketplace, such as Microsoft Access and Microsoft Excel pivot tables connected directly to your bisTrack data source. The whole data architecture is as open as possible.
Schedule and deliver
bisTrack comes with a powerful and flexible report scheduler to deliver the reports where you want them, when you want them. Weekly sales reports can be compiled at night and emailed to sales managers. Inventory shortages can be sent to the purchasing agents on set schedules. Produce and save reports automatically for audit purposes during month and year ends.
Benefits: Make informed decisions based on historical data. Deliver the data to the people that need to know, when they need to know it. Grow your business by mining your data.
*What is an OLAP data cube?
OLAP cubes – OLAP stands for Online Analytical Processing, and the cube reference is the 3-dimensional cross-referencing of the data in question. A spreadsheet is a good example of a 2-dimensional representation of data. The 3rd dimension comes from an additional matrix of data behind that layer.
What’s more, you can also visualize KPIs using the business dashboard and smart view that each help to report on various areas of your builder materials or lumber business. Thanks to this hard working functionality, managers of lumber and builders material companies now can have exactly the right information at exactly the right time.
