Welcome. Thank you for registering. Next group begins soon. Look out for further instructions in your email inbox.
Robert Hernandez
Instructor
Course Outline
Module 1: Sources of Useful Data
The business world is swimming in data, but not all of it is useful for intelligent decision making. Discover where you can find the data points that lead to better decision making within your transaction databases and on the internet. Understand how the data is stored, how you can retrieve it, and how you can filter through the noise.
Module 2: Preparing Data for Analysis with Excel
The best analysis is always a direct result of the amount of time spent on data preparation. You will master the best techniques for taking any transaction data file and transforming it into a useful tool. Learn how to combine data from different sources to create a complete view of your business activity.
Module 3: Accounting vs. Analytics
While Profit & Loss statements are the leading source of performance information for small businesses, they have all but been completely discarded as a source of business insights in this predictive analytics age. Using real business data, you will escape the “Accounting” mindset and learn to “Think Analytics-ly”, which will transform the way that you think about the breadth and depth of the questions that you need to answer in order to make more profit.
Module 4: Demand and Pricing
The easiest and most efficient way to create profit is through strategic pricing. Gain new perspectives by looking at your pricing from different points-of-view. Explore sources of data that will help you better determine market demand and use that information to mathematically calculate the optimal price.
Module 5A: Sales and Revenue Analysis
Dive into every data point that reveals hidden truths about your Revenue performance. Understand your drivers of revenue growth from multi-dimensional angles. Gain the knowledge of Mathematical Revenue Analysis. Learn to optimize your sales efforts by prioritizing efficiency while ensuring effectiveness.
Module 5B: Salesperson Performance Analysis
Dive into every data point that reveals hidden truths about your Revenue performance. Understand your drivers of revenue growth from multi-dimensional angles. Gain the knowledge of Mathematical Revenue Analysis. Learn to optimize your sales efforts by prioritizing efficiency while ensuring effectiveness.
Module 6: Performance Ratios Analysis for Benchmarking
Discover the data that is available for you to compare your performance to your industry. You will build and understand how to interpret the most useful financial and operational ratios. Then, you will learn how to create your own Key Performance Ratios so that you can outsmart the competition.
Module 7: Labor Cost Analysis
You’ve heard that “all expenses walk in on two feet.” Take a data-driven approach to eliminating waste and optimizing workforce output. You will learn labor analytics techniques that will allow you to make more sophisticated decisions about hiring, scheduling, and compensating. Learn to use mathematical models of different labor scenarios to discover the optimal mix.
Module 8: Cash and Break-even Analysis
Cash is King! Shine a light on the vulnerabilities in your business model. You will understand how to leverage data from different sources to discover and continuously monitor the activities that are creating liquidity, stability and wealth versus those that are creating risk.
Module 9: Annual Budgeting
The discipline to adhere to a process of annual planning is critical to the growth of any small business. Sharpen your business model by formulating a budget that incorporates mathematical insights from your transaction data. Learn multi-scenario budgeting, from best-case to crisis.
Module 10: Statistical Variance Analysis
Learn how to incorporate probability and statistics into the analysis of year-over-year, month-over-month, and actual-vs-budgeted performance. You will be able to master the use of mathematical concepts that help reveal the true sources of variances in your results.
Module 11. Short and Long-Term Forecasting
The most powerful skill any business owner should develop is the ability to predict. Learn how to apply different forecasting techniques to different business activities. Go from simple Naive forecasting to Monte-Carlo simulations in just a few hours.
Module 12: Analysis of Marketing Effectiveness
Learn how to create a market response model to be able to identify the marketing efforts that are creating additional profit versus those that are a waste of money.
Module 13: Product Level Analysis
Take your understanding of your business to the ultimate level by creating Single Product Profit and Loss Statements. Get into the most granular level of profit analysis to reveal which products and services will help you grow and which will weigh you down.
Module 14: Customer Behavior Analysis
Learn to follow the customer journey using all available data points. You will dive into an exhaustive small business case study of customer segmentation and using the most popular analytics techniques. Master the concepts of clustering, scoring, and value analysis.
Module 15: Designing Your Analytics Reports
You will master the best-in-class techniques for data visualizations so that you can design reports that will allow you to see the information that you need quickly and clearly.