Forecasting Revenue Using Predictive Analytics: An Interactive Case Study

Think fancy quantitative techniques like predictive analytics are out of your reach? Think again.

Much has been written about using fancy technologies like artificial intelligence, machine learning, and predictive analytics in the workplace to do everything from identifying the most effective project managers to making recommendations on Netflix. Too often, the reader is left with the impression that the technology is only available in high-end, hard-to-implement, black box systems attainable only by businesses willing to hire a small army of very specialized data scientists.

To help dispel the myth, we built an interactive case study that explains how we used nothing more than some data analysis in Microsoft Excel to build a predictive analytics-based revenue forecasting model for one of our clients. It uses some interesting animations to illustrate how run-of-the-mill resource scheduling data can be transformed into a dynamic, self-adjusting model capable of providing more trustworthy revenue forecasts:

If you’re interested in the full animation and the rest of the story, check out the article on Projector’s Professional Services Automation Blog at:

Originally published at