Best Practices
Categories
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.
Excel is Not a one Stop Shop for your Data Needs
Excel is everywhere and it has proven to be a valuable resource to every company across the globe. The problem is that many companies are using spreadsheets as their main line of communication internally. Excel is great at displaying all of the raw data you could possibly dream of, just ask any Data Analyst, who eats, sleeps and dreams of never-ending spreadsheets.
28% of a Data Analyst’s Time is Spent on Data Prep
As stated by James Haight, “At Blue Hill, we recently published a benchmark report in which we made the case that dedicated data preparation solutions can produce significant efficiency gains over traditional methods such as custom scripts or Microsoft Excel.”
OLAP and Excel
Excel reports are just not cutting in today’s world of even larger and more complex organizations. Thankfully, there is a solution that not only gives companies the capability to access large amounts of data at the speed in which there is no “waiting around” time, but it enhances the every day use of Excel. Let’s take a look at how this is possible.
Take a Moment to Reconsider OLAP
We are loving this article by Neil Raden on diginomica.com, I'm Feeling Sentimental about OLAP and You Should Too. In it Raden makes the case that the OLAP tech that existed in the 90's plus the new strides that have been made in recent years as far as scale, speed,...
Infographic: 5 Signs You are in Excel Hell
Check out this cool infographic! Submitted to OLAP.com by the folks at Business Intelligence Technologies. They've mapped here 5 warning signs that you and your professional team are living in Excel Hell. Perhaps it's just been accepted that your Excel Hell is what it...
Boost Your Business Intelligence Career With Data Science
According to research by LinkedIn, data science and machine learning jobs are the hottest and most in-demand career paths in the world. Data scientists hold some of the most sought-after positions in the world, and if you want to boost your business intelligence or graduate career, it’s important that you boost your resume with big data.
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