Posts

Sales optimisation and Cohort analysis

Image
Achieving sustainable growth is one of the foremost concerns of modern businesses One popular framework used by business people when analysing the impact on strategies aimed at improving revenue and achieving sustainable growth is the old chestnut of price and volume: Source: Beautiful.ai This works great, but one analysis I like to do is called cohort analysis. This really helps sharpen the focus and helps us zoom in on managerial actions that can move the dial. You can think of these as levers of value: Source:  Beautiful.ai Cohort analysis in Tableau With three, easily re-used formula, we can replicate a cohort analysis on new data sets with relative ease when we've deployed Tableau in our analytical toolkit: // A fixed LoD to set the Customer Acquisition Date [Customer Acquisition Date] {FIXED [Customer Name] : MIN ([Order Date]) } // A fixed LoD to set the Customer Lost Date [Customer Last Date] {FIXED [Customer Name] : MAX ([...

The changing landscape for analytical talent

Image
Pythonistas! Everywhere! eFinancialCareers have hit the nail on the head with their aptly titled: " Forget Excel: banks want Python monkeys now " which has this data point in it: "around 50% of incoming analyst classes have some knowledge of Python coding". Meanwhile, in other recent news, Accountancy Age, in their article " PwC’s rising star " acknowledge this year's Britihs Accountancy Award winner, Harry Pampiglione, as having developed a proprietary Python model for optimising pricing. This analysis earned the firm a six-figure fee, and has subsequently been productised. Harry's qualifications include Alteryx Core and Udemy's Python for Data Science and Machine Learning. So what's the moral of the story here? A knee-jerk, instant reaction might say … "Go enrol in Python for Financiers"! But that is kind of losing sight of the wood for the trees. Take a moment and step back … with this diagram: Source: Beauti...

The importance of being data-driven

Competing in today's VUCA world calls for new skills in strategy, finance and analytics I posit to you that: this volatile, uncertain, complex and ambiguous market we find ourselves in calls for both, a new set of skills and a not-so-new set of skills. What do I mean by "not-so-new"? Robust strategic problem-solving skills and the ability to lead diverse teams in managing change in an unpredictable environment. Financial nous and being able to read a report and being able to articulate managerial decisions in financial terms: efficiency, effectiveness ... position (sufficiency) and performance (sometimes, the lack of it!). These core skills of strategy and finance are well understood by our business and leadership community ... But at the same time, the 21st century has seen an exponential increase in the volumes of data generated and its availability. We've seen this growth in the ability of systems to process that information, but at the same time, there ...