Business intelligence reporting tools using data cubes

Data cubes and reporting software - Analyse your data with bisTrack’s data cubes

Data cubes (or OLAP* cubes) are an excellent visual tool for looking at your data. The data cube builder can be used whenever you need to filter and aggregate your bisTrack data and build a business intelligence report.

Visual tools make all the difference when looking at KPIsA 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 Excel, or any familiar reporting and analysis tool. Date cubes are a terrific way of presenting your sales data visually. Every copy of bisTrack’s business management software ships 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 trading patterns. Because it is so easy to look at the figures in so many ways, this means you can quickly pick up patterns that would take a very sharp mind to spot with 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!

Example ways you might report your data:

  • Rep by product group
  • Customer by product group
  • Branch by product group
  • Branch by customer by product group
  • Area by product group
  • and so on...

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 timber, total cubic metres can be reported on, whilst for steel a tonne measure is used.

Analyse 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.

Your choice of reporting tool

Typical reporting tools might be Crystal Reports, Microsoft Access, iSQL Query Analyser, Excel pivot tables, or Cognos. bisTrack uses meaningful names for tables and fields to make querying easier. The whole data architecture is as open as possible.

Reports library or custom — you choose

bisTrack ships with a huge library of standards reports. The chances are there’s a standard report for your needs, but you always have the option of building your own – customise an existing report or start from scratch with bisTrack’s using open data policy.

Benefits: Examine your data in novel ways, query it, graph it, flip it. New ways of slicing the data are achieved instantly, revealing new patterns to your figures without costly overhead. High-level business intelligence reports and understanding are now at your finger tips with the help of bisTrack’s data cubes.

*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.

Testimonials

  • "At Complete we have a responsibility to the environment. That’s why we’re trying to lower our Carbon Footprint. We introduced e-commerce cut down on paper receipts & are introducing electronic billing through bisTrack for customers."

    Richard Moody, Director, Complete Building Materials

  • "The time was right for a change of software at Alsford's and we selected bisTrack from a shortlist of three. The key criteria was 'business fit'. We wanted a Microsoft Windows, intuitive solution which would best serve our claim to be 'The Timber Experts' in all our 20 branches."

    Neil Fuller, MD, Alsford Timber

  • "I was working with 2.7 in our test environment and looking at all the work you have done. Just wanted to let you know how much we appreciate all you do to make this a great technology partnership."

    Brian King, Lumber USA

  • "The great thing is we can always export information to Excel and produce any report we need — such as an aged debt report by sales rep, or our bespoke ‘exposure’ report, which helps us assess potential credit risk and protect ourselves."

    Damien Cosgrove, Credit Control Manager, Noyeks Newmans

  • "The time was right for a change of software at Alsford's and we selected bisTrack from a shortlist of three. The key criteria was 'business fit'. We wanted a Microsoft Windows, intuitive solution which would best serve our claim to be 'The Timber Experts' in all our 20 branches."

    Neil Fuller, MD, Alsford Timber

  • "I can export information into Excel by right-clicking and manipulate it to my heart's content."

  • "The great thing is we can always export information to Excel and produce any report we need — such as an aged debt report by sales rep, or our bespoke ‘exposure’ report, which helps us assess potential credit risk and protect ourselves."

    Damien Cosgrove, Credit Control Manager, Noyeks Newmans

  • "The great thing is we can always export information to Excel and produce any report we need — such as an aged debt report by sales rep, or our bespoke ‘exposure’ report, which helps us assess potential credit risk and protect ourselves."

    Damien Cosgrove, Credit Control Manager, Noyeks Newmans

  • "We helped ourselves by getting bisTrack on board quickly and painlessly while business was slow, so we won't have disruption as we start to implement a very aggressive three year strategic plan."

    Neil Fuller, Managing Director, Alsford Timber

  • "Our relationship with PSI has been transformed this year. This is due almost entirely to having an Account Manager as a single point of contact, who knows our system and our business."

    Eric Jones, IT Manager, Alsford Timber

  • "To stand out from the crowd, you need great customer service. Really great customer service."

    Progressive Solutions' guest blog, Builders Merchants Journal

  • "bisTrack was a big investment for us but it's the best change we've ever made. We've grown so much over the last four or five years, we simply couldn't have carried on using a manual system."

    Gerwyn Thomas, partner, TL Thomas (builders' merchant)

  • "At Complete we have a responsibility to the environment. That’s why we’re trying to lower our Carbon Footprint. We introduced e-commerce cut down on paper receipts & are introducing electronic billing through bisTrack for customers."

    Richard Moody, Director, Complete Building Materials

  • "I can drop-down and drill into any business information easily, which enables me to analyse a situation very quickly. It gives me complete control."

    Mark Congdon, Financial Director, Noyeks Newmans

  • "We saw benefits straight away, particularly with the time we saved on monthly stock takes and sourcing information for management reports."

    Nigel Williams, Chairman, Premier Forest Products

  • "The decision to go with bisTrack was based on the relationship we were developing with the Progressive team, a confidence in deliverability and their aggressive approach to overall cost."

    Stephen Mulhall, FD, McMahon

  • "We spent a long time evaluating several systems and I'm confident that bisTrack is the best available."

    Andrew Laver, Arnold Laver Timberworld

  • “A member of our buying group told us about bisTrack, although we looked at four or five other software packages. Key factors in the eventual selection of bisTrack were its SQL platform and our confidence in the people we dealt with.”

    Gordon Rothwell, James Hargreaves (Plumbers Merchants)

  • “Hargeaves are ideally placed to take advantage of the offer – whilst we plan to continue using e-Xact to update our product file we also want much better control over special product sales and purchases."

    Gordon Rothwell, James Hargreaves MD

  • "We helped ourselves by getting bisTrack on board quickly and painlessly while business was slow, so we won't have disruption as we start to implement a very aggressive three year strategic plan."

    Neil Fuller, Managing Director, Alsford Timber

  • "I'm happy bisTrack will grow with us. If we find we need something which isn't already incorporated, I'm confident Progressive will work with us to fill the gap."

    Operations Director, CF Anderson

  • "Once we started building up information we could trust, we started seeing real benefits. If stock accuracy was the main benefit, then quality of management information was next."

    Peter Kerr, FD, Palmer Timber

  • "We looked at several systems, but most of them were using the same out-of-date technology as the system we were replacing!"

    Rodney Scoles, Director, T Brewer & Co

  • "I'm happy bisTrack will grow with us. If we find we need something which isn't already incorporated, I'm confident Progressive will work with us to fill the gap."

    Operations Director, CF Anderson

  • "The time was right for a change of software at Alsford's and we selected bisTrack from a shortlist of three. The key criteria was 'business fit'. We wanted a Microsoft Windows, intuitive solution which would best serve our claim to be 'The Timber Experts' in all our 20 branches."

    Neil Fuller, MD, Alsford Timber

  • "bisTrack is an excellent piece of software and getting better. Their approach to meeting our needs is excellent. eBusiness is not going to be big for another 12 months but PSI are there already, which means we’re ahead. They're very open to ideas and keep getting better at turnaround."

    Adam Myers, Beesley & Fildes

  • "To stand out from the crowd, you need great customer service. Really great customer service."

    Progressive Solutions' guest blog, Builders Merchants Journal

  • "At Complete we have a responsibility to the environment. That’s why we’re trying to lower our Carbon Footprint. We introduced e-commerce cut down on paper receipts & are introducing electronic billing through bisTrack for customers."

    Richard Moody, Director, Complete Building Materials

  • "I can drop-down and drill into any business information easily, which enables me to analyse a situation very quickly. It gives me complete control."

    Mark Congdon, Financial Director, Noyeks Newmans

  • "With bisTrack we now have real-time information on our profitability, which allows us to continually optimise and make decisions on our business plan."

    Stuart Hall, General Manager, Lawcris Panel Products

  • “Hargeaves are ideally placed to take advantage of the offer – whilst we plan to continue using e-Xact to update our product file we also want much better control over special product sales and purchases."

    Gordon Rothwell, James Hargreaves MD

  • "We looked at several systems, but most of them were using the same out-of-date technology as the system we were replacing!"

    Rodney Scoles, Director, T Brewer & Co

  • "We spent a long time evaluating several systems and I'm confident that bisTrack is the best available."

    Andrew Laver, Arnold Laver Timberworld

  • "Progressive's experience was important, as was the link with Microsoft. We think that's the way ahead for all merchant systems."

    Stephen Fairbairn, MD, Henry Alty

  • "Progressive's experience was important, as was the link with Microsoft. We think that's the way ahead for all merchant systems."

    Stephen Fairbairn, MD, Henry Alty

  • “Hargeaves are ideally placed to take advantage of the offer – whilst we plan to continue using e-Xact to update our product file we also want much better control over special product sales and purchases."

    Gordon Rothwell, James Hargreaves MD

  • "I was working with 2.7 in our test environment and looking at all the work you have done. Just wanted to let you know how much we appreciate all you do to make this a great technology partnership."

    Brian King, Lumber USA

  • "The great thing is we can always export information to Excel and produce any report we need — such as an aged debt report by sales rep, or our bespoke ‘exposure’ report, which helps us assess potential credit risk and protect ourselves."

    Damien Cosgrove, Credit Control Manager, Noyeks Newmans

  • "I was working with 2.7 in our test environment and looking at all the work you have done. Just wanted to let you know how much we appreciate all you do to make this a great technology partnership."

    Brian King, Lumber USA

  • "bisTrack is an excellent piece of software and getting better. Their approach to meeting our needs is excellent. eBusiness is not going to be big for another 12 months but PSI are there already, which means we’re ahead. They're very open to ideas and keep getting better at turnaround."

    Adam Myers, Beesley & Fildes

  • "bisTrack was a big investment for us but it's the best change we've ever made. We've grown so much over the last four or five years, we simply couldn't have carried on using a manual system."

    Gerwyn Thomas, partner, TL Thomas (builders' merchant)

  • "I can export information into Excel by right-clicking and manipulate it to my heart's content."

  • "The reporting capabilities of bisTrack really help the sales department answer day to day enquiries. It gives them instant access to information about purchasing volumes and when timber is due to come in."

    Wayne Abrams, Project Leader, Arbor Forest Products

  • "We spent a long time evaluating several systems and I'm confident that bisTrack is the best available."

    Andrew Laver, Arnold Laver Timberworld

  • "To stand out from the crowd, you need great customer service. Really great customer service."

    Progressive Solutions' guest blog, Builders Merchants Journal

  • "We improved net margin by 3% within 6 weeks of going live on bisTrack."

    Andy Halpin, Payne Timber

  • "I'm happy bisTrack will grow with us. If we find we need something which isn't already incorporated, I'm confident Progressive will work with us to fill the gap."

    Operations Director, CF Anderson

  • "Our computer system impacts on every aspect of the business. Buying, selling, importing, transport planning, as well as accounts. If you install the wrong software, without the right level of performance or functionality, it will cause significant problems throughout your business."

  • "We looked at several systems, but most of them were using the same out-of-date technology as the system we were replacing!"

    Rodney Scoles, Director, T Brewer & Co

  • "With bisTrack we now have real-time information on our profitability, which allows us to continually optimise and make decisions on our business plan."

    Stuart Hall, General Manager, Lawcris Panel Products

  • "We chose bisTrack because we needed to move on to the next generation of software."

    Stephen Fairbairn, MD, Henry Alty

  • "Our staff have margin figures right in front of them now, so they're much more aware of the profit they are making."

    Robert Blumsom, Blumsom Fine Timber

  • "At Complete we have a responsibility to the environment. That’s why we’re trying to lower our Carbon Footprint. We introduced e-commerce cut down on paper receipts & are introducing electronic billing through bisTrack for customers."

    Richard Moody, Director, Complete Building Materials

  • "Inventory accuracy is higher because everyone is more focused and our staff can see the benefit of getting it right."

    Ian Murchie, Operations Director, Howie Forest Products

  • "We were drowning in paper and, as a business turning over £2.2 million, the time had come for us to invest in business management software."

    David Biddle, MD, Huntingdon Timber & Roofing

  • "I'm happy bisTrack will grow with us. If we find we need something which isn't already incorporated, I'm confident Progressive will work with us to fill the gap."

    Operations Director, CF Anderson

  • "We were drowning in paper and, as a business turning over £2.2 million, the time had come for us to invest in business management software."

    David Biddle, MD, Huntingdon Timber & Roofing

  • "bisTrack was a big investment for us but it's the best change we've ever made. We've grown so much over the last four or five years, we simply couldn't have carried on using a manual system."

    Gerwyn Thomas, partner, TL Thomas (builders' merchant)

  • "We improved net margin by 3% within 6 weeks of going live on bisTrack."

    Andy Halpin, Payne Timber

  • "I'm happy bisTrack will grow with us. If we find we need something which isn't already incorporated, I'm confident Progressive will work with us to fill the gap."

    Operations Director, CF Anderson

  • "We looked at several systems, but most of them were using the same out-of-date technology as the system we were replacing!"

    Rodney Scoles, Director, T Brewer & Co

  • “A member of our buying group told us about bisTrack, although we looked at four or five other software packages. Key factors in the eventual selection of bisTrack were its SQL platform and our confidence in the people we dealt with.”

    Gordon Rothwell, James Hargreaves (Plumbers Merchants)

  • What will YOU do with your week off?

    "With the time saved we've carried out branch refurbishments and I've taken my first holiday!"

    John Cavanagh, MD, Cavanagh Timber

  • "bisTrack was a big investment for us but it's the best change we've ever made. We've grown so much over the last four or five years, we simply couldn't have carried on using a manual system."

    Gerwyn Thomas, partner, TL Thomas (builders' merchant)

  • "bisTrack was a big investment for us but it's the best change we've ever made. We've grown so much over the last four or five years, we simply couldn't have carried on using a manual system."

    Gerwyn Thomas, partner, TL Thomas (builders' merchant)

  • "The time was right for a change of software at Alsford's and we selected bisTrack from a shortlist of three. The key criteria was 'business fit'. We wanted a Microsoft Windows, intuitive solution which would best serve our claim to be 'The Timber Experts' in all our 20 branches."

    Neil Fuller, MD, Alsford Timber

  • "It was obvious the company was being held back by the limitations of the old system."

    Operations Director, CF Anderson

  • "Performance across the system is continuously enhanced too. Since our last release, finding products is now significantly faster ...by up to 30%."

    Gary Brookshaw, Product Director, Progressive Solutions

  • "It was obvious the company was being held back by the limitations of the old system."

    Operations Director, CF Anderson

  • "We were drowning in paper and, as a business turning over £2.2 million, the time had come for us to invest in business management software."

    David Biddle, MD, Huntingdon Timber & Roofing

  • "If we hadn't changed to bisTrack we simply couldn't have grown like this."

    Nigel Williams, Chairman, Premier Forest Products

  • “Hargeaves are ideally placed to take advantage of the offer – whilst we plan to continue using e-Xact to update our product file we also want much better control over special product sales and purchases."

    Gordon Rothwell, James Hargreaves MD

  • "We helped ourselves by getting bisTrack on board quickly and painlessly while business was slow, so we won't have disruption as we start to implement a very aggressive three year strategic plan."

    Neil Fuller, Managing Director, Alsford Timber

  • "Performance across the system is continuously enhanced too. Since our last release, finding products is now significantly faster ...by up to 30%."

    Gary Brookshaw, Product Director, Progressive Solutions

  • "We helped ourselves by getting bisTrack on board quickly and painlessly while business was slow, so we won't have disruption as we start to implement a very aggressive three year strategic plan."

    Neil Fuller, Managing Director, Alsford Timber

  • "We improved net margin by 3% within 6 weeks of going live on bisTrack."

    Andy Halpin, Payne Timber

  • “Hargeaves are ideally placed to take advantage of the offer – whilst we plan to continue using e-Xact to update our product file we also want much better control over special product sales and purchases."

    Gordon Rothwell, James Hargreaves MD

  • "The people at Progressive Solutions are likeable, straight_

    talking individuals who have a

    commitment to continuously develop and push the software forward."

    Joe Tipper, Walter Tippers Ltd

bistrack Customer Portal | Progressive Solutions UK

Newsletter

Register for newsletter