Blog
Categories
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.
FROM OUR SPONSORS
Featured Story
The Importance of Planning and Forecasting in BI
From PARIS Technologies
The budgeting and forecasting process for most organizations is long and tedious and occurs on an annual basis, at least. Companies try to do it more often to improve accuracy and aim to ultimately implement a procedure for continuous planning, rolling forecasts, and driver-based planning.
Unlike any other business process, budgeting and forecasting is unique because it is forward thinking. Business processes like accounting, inventory tracking, invoicing, shipping, etc. are based on actual events from the past and present.
This is a fundamental difference as it also defines how the data from these processes are managed. Essentially, actual events are captured as transactions in ERPs, supply chain systems, invoicing and accounting systems, etc., and data related to it is effectively stored in its databases. On the other hand, budgets and forecasts typically reside in spreadsheets where aggregate data is entered by several people in the organization.
Latest Posts
Hot
What Really Is Big Data? And Why It Will Change the World
Big Data is THE biggest buzzword around at the moment, and I guess it makes sense to start my new ‘The Big Data Guru’ column with a post that goes back to basics and establishes what big data really is, what is isn’t and why it matters to everyone. One thing is...
Map Your Financial Health With an Excel DuPont Dashboard
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display. by Charley Kyd, MBA Microsoft Excel MVP Management reporting is all about communication. Reporting Return On Equity...
Create Variable-Length, Dynamic Reports Linked to Excel Tables
When you change a criteria value in a cell, Excel can use formulas and conditional formatting to expand or contract your report automatically, without macros. Here's how. by Charley Kyd, MBA Microsoft Excel MVP Excel Tables are a powerful feature introduced in Excel...
When Big Data Meets Tablets
Big Data and mobility are converging offering mobile workers access to real time data via mobile dashboard apps. An interview published in Tech Republic with the Forerunner Group’s managing director Dwight deVera. Big Data and mobility are converging offering...
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...
Business Analytics – Opposition or Proposition?
Metaphorically, belief and disbelief in business analytics as a competitive edge - and not just a passing fad - meet at a door. On one side is passion, and on the other, fear. Passion always lives with fear. Those with passion for a methodology, like embracing...
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