As we explained in a previous post, a dashboard consists of a collection of charts and other visuals combined into a single screen interface. The choice of charts to use can have a big impact on the effectiveness of a dashboard. In this ... Read more
Excel has been the dominant software for data analysis for many years. Although people like to complain about Excel, there has to be some reason why it obtained that level of popularity in the first place, and in reality it is pretty useful for most ... Read more
When you're modeling a business problem, it's generally tempting to start the analytics as quickly as possible. Whether you're using Excel or another promising new tool, this can be a bad idea. You should always spend some time structuring your model in order to understand the variables and how ... Read more
Dashboards are a popular, effective tool for managers and other business people to better understand their companies through data analytics. In recent years, the development and the growing popularity of visualization tools like Tableau and Power BI has facilitated the expansion of business ... Read more
Microsoft’s Power BI has been shaking up the market for self-service business intelligence applications. However, it doesn’t follow the usual Microsoft pricing model. Historically, Microsoft products have been sold as a large upfront purchase, or as a monthly or ... Read more
GDPR is coming soon. The General Data Protection Regulation is being introduced by the European Union on 25th May 2018. The new law on data privacy and data protection significantly strengthens European citizen’s rights to online privacy and control of their ... Read more
They say that a picture is worth a thousand words.
Graphs and charts are wonderful things. They give you the power to explain what’s in your dataset while requiring you to write only a small amount of dreary text. However, ... Read more
When you are modelling a business problem in Excel, you will often want to know how the output of your model is affected by changes in some of the input variables. To do this you use sensitivity analysis, which is so called because you are ... Read more
When I initially started writing this post, I intended to focus on the most widely used Excel formulas for business. All I could think of was very basic formulas like SUM, AVG, IF, AND and so on. Of course, these are very ... Read more
The formula for standard deviation is a common statistical function that many Excel users will come across. The standard deviation numerically measures the spread, or deviation, of numerical data from the mean. In Excel, there are actually four standard deviation functions available, so it can ... Read more
