5 Ways To Use Big Data In Small Businesses

Big data seems to be everywhere. I keep hearing quotes like data is the new oil. Even though I find this a bit exaggerated, it is beyond doubt that data and analytics have become extremely important for every business. Yet, the availability of big data for small businesses seems limited due to various factors. In […]

Continue Reading 0

Big Data & Analytics Treasures – Week 37

This week I’d like to share with you a couple of interesting posts about the uses of big data. Some posts are related to machine learning and analytics. These articles are going to show you some real, hands-on methods. Maybe they give you a few ideas how you could apply these technologies in your own […]

Continue Reading 0

Which Excel Versions Contain PowerPivot?

PowerPivot is one of the most premium features of Excel. At least if you believe Microsoft. Still, it is not obvious which Excel versions contain PowerPivot. If you are looking to do some serious big data analytics Excel, this is a good starting point to get the right version. (more…)

Continue Reading 0

Line Breaking in Excel Formulas

Imagine that you are creating a dashboard in Excel and you would like to do line breaking in Excel formulas. You’d like to put some data in a cell that looks like this: It’s easy when you simply type some text in a cell. You just click on the cell, type in Variance, then hit […]

Continue Reading 0

Budgeting with Excel and PowerPivot

Some time ago I published an article on LinkedIn about how we’ve redesigned the budgeting process with Excel and PowerPivot. I’m planning to share an update on this project. But before that, I’d like to give a short summary of what we’ve done already, and give you a quick introduction to our approach to budgeting […]

Continue Reading 0

Finding Data in Excel with INDEX-MATCH

The other day a colleague came to me with a special Excel challenge. She had a two-dimensional table and wanted to fetch values from it, a la VLOOKUP or HLOOKUP. But she had to search both vertically and horizontally to find the value she needed. Finding data in Excel is pretty easy with VLOOKUP and […]

Continue Reading 0