Business Intelligence and Data Analytics Blog

Information and Discussions on Business Intelligence, Data Analysis, and Management featuring: Strategies, Best Practices, PARIS Product Tips and News

But, Does it Export to Excel?

But, Does it Export to Excel?

A consulting colleague and I were discussing the failure of a software that advertises its strengths in Visual Analytics. He said a customer that had bought one such product had effectively wasted $50,000. His customer ultimately had a question about the visual...

read more
Alternatives to the Bar Graph and When to Use Them

Alternatives to the Bar Graph and When to Use Them

  Who is tired of bar graphs? Everyone! They are so common, it is as if there weren't other options for displaying business data.  The fact remains, people choose bar graphs because they are safe and can display a wide range of data sets in a useful way.  With...

read more
6 Reasons PARIS Products are for You

6 Reasons PARIS Products are for You

  PARIS products are right for you if: You tried a Big Name solution… and you still have the original problems you were trying to address. You believe that it is time to evolve the way reporting and budgeting gets done–without throwing away what you know you can...

read more
Collecting and Analyzing Data in Sports is Here to Stay

Collecting and Analyzing Data in Sports is Here to Stay

Millions of dollars and the hopes and dreams of sports fans worldwide now more than ever depend on Big Data. Collecting data, crunching numbers and generating detailed reports is now a very big part of every sports franchise. No longer does all the action take place on the field, track, pitch or court.

read more
How to Automate Reports and Perform Analytics in Excel – the PowerExcel way!

How to Automate Reports and Perform Analytics in Excel – the PowerExcel way!

Crunching numbers, generating reports, consolidating data across departments—these are always very lengthy and cumbersome when done manually. To make matters worse, reports that take so lo-o-o-o-ng to complete of course turn out to have outdated information …and so, managers are faced with the issue of not having real-time data to make critical decisions.

read more
Escaping Excel Hell Without Abandoning Excel

Escaping Excel Hell Without Abandoning Excel

Due to frustrated Excel Users who constantly have to merge changes and don’t have the needed flexibility with Excel Spreadsheets, many users choose to leave Excel to avoid Excel Hell. PowerOLAP presents an Add in solution that works with Excel Spreadsheets to allow users to escape Excel Hell while still using Excel.

read more
OLAP VS OLTP

OLAP VS OLTP

Comparison between two Business Intelligence (BI) technologies: OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing).

read more
The Future of Data Management With Olation

The Future of Data Management With Olation

The future of data management lies in the fusion of database technologies. Olation has pioneered this by joining relational and multidimensional database technologies (OLTP and OLAP) to serve as a one-stop solution for all data management needs. OLAP or Online Analytical Processing is an approach to answering multi-dimensional analytical queries swiftly.

read more
Why do you need a Business Intelligence (BI) Solution?

Why do you need a Business Intelligence (BI) Solution?

With the amount of data stored by companies growing exponentially, it is no surprise that finding the right data management solution continues to show up on the priority list of Chief Information Officers (CIO). Data has to be secure and distributed efficiently for important up-to-date business decisions.

read more