Best Practices
Articles on Best Practices in OLAP, Business Intelligence, Planning and Forecasting.
Best Practices
OLAP & BI Solutions
Data management
Finance and Business Use Cases
Dashboards
Predictive Analytics
Subscribe
Get the latest on OLAP and Business Intelligence straight in your inbox.
Tips for Choosing a Real-Time Business Intelligence Solution
The value of having a Business Intelligence (BI) tool in 2013 is inevitable however; many businesses may be faced with the ultimate business dilemma of having to choose the right BI tool. With every Business Intelligence solution provider claiming access to real-time...
What’s a ‘Deprecated’ Function in Excel?
Microsoft tells us that many worksheet functions are 'deprecated.' So what does that mean, exactly? Wikipedia tells us that deprecation is a status applied to a computer software feature, characteristic, or practice indicating it should be avoided, typically...
Introducing Excel’s Three Types of Spreadsheet Databases
Excel offers at least three ways to set up data so your reports and analyses can use it easily as a reliable data source. by Charley Kyd, MBA Microsoft Excel MVP Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with...
Five Really Useful Excel Keyboard Shortcuts
These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way. by Charley Kyd, MBA Microsoft Excel MVP Several years ago, I created my Complete Excel Shortcuts Workbook. It contains more that 250 keyboard shortcuts...
Performance Management: Top 5 Tips for Managers and Employees
A few years ago I had the great opportunity to work with a Canadian owned, privately held corporation which had hit a home run with the design and manufacture of an unique product which had taken its industry by storm. The company had grown quickly and substantially...
Data Visualization for Human Perception
Data visualization is the graphical display of abstract information for two purposes: sense-making (also called data analysis) and communication. Important stories live in our data and data visualization is a powerful means to discover and understand these stories,...
Learn OLAP
Resources
Types of OLAP Systems
MOLAP, ROLAP, HOLAP... what's the difference? And modern OLAP for this century.
History of OLAP and BI
Learn about the history of OLAP technology with this comprehensive inforgraphic