Analytics

Analytics encompasses a wide range of practices, from simple statistics to predictive models and everything in between. Which method or methods to use is driven by business need, organizational maturity, and desired outcomes. At the end of the day, the end result must be user-friendly as much as it is accurate and insightful.

To achieve this balance, I always begin with the end in mind and work closely with clients to align intention and approach. In our conversations, we will walk through a problem-solving process with emphasis on the steps on the left.

Click each step to learn more.

  • In order to ensure we are solving the right problem, we must define it. This means determining what “done” looks like, what is an acceptable timeframe, what is in and out of scope, and so forth - and actually writing it down. This helps ensure everyone is on the same page and triggers us to come back together if the project starts to drift from the agreed upon parameters.

  • What would have to be true to achieve our goal? What are the component parts? For example, if our project goal is to maximize donor retention, we could break this down by fund, by years of consecutive giving, by giving method. This helps me understand how the organization thinks about their problem and what levers may be available to impact it.

  • A fleshed-out goal breakdown will result in more opportunities than we can realistically tackle at once. Furthermore, some may be outside of our control or unlikely to yield much fruit. So, we eliminate those and focus on the areas the initial data suggest will be the most impactful.

  • Once the priorities are established, we can develop a more detailed working timeline, including roles and responsibilities for all parties involved, and start working the plan.

  • Now for the good stuff. We start to gather data, do summary analysis, and digging deeper as the situation warrants. This may involve data science and machine learning methods such as regression analysis, time series, clustering, decision trees, text analytics, and more.

  • We review the results of our analysis and translate them into business insights and potential recommendations.

  • Throughout the project, we will have regular client communications updating on project status and findings. At project end, I will package the findings and recommendations into a document that the organization can reference and share, along with any technical collateral such as reports, spreadsheets, and decision models.

This is not a linear process. As we proceed through the steps, we may need to revise our scope and understanding of the problem. Analysis may identify that a prioritized lever is not as useful as originally thought, and we need to explore previously deprioritized avenues.

Next
Next

Power BI