LoomView's   Online   Do-It-Yourself B.I. Curriculum:

Stage 1 – Foundational Setup:   first 6 months

Month 1 

  1. Software – 1-2 weeks
  2. Accounting: Creating your chart of accounts – 1-3 weeks
  3. Identifying the right data to track – 2-3 week

Month 2

  1. Identify Initial Results Indicators and begin to track–1 week to identify & 1-2 weeks to implement along with other indicators
  2. Identify performance indicators and begin to track – 1 week
  3. Identify Initial Key Performance Indicators and begin to track – 2 weeks

Month 3

  1. Construct interface to accounting and other data sources – 2-3 weeks
  2. Profit Margin Analysis – 1-2 weeks

Month 4

  1. CRM analysis – 2 weeks
  2. Sales process analysis – 3 weeks

Month 5

  1. Create initial budgets – 1-2 weeks
  2. Getting all data entry processes in place – 3 weeks

Month 6

  1. Automate financial management – 2-3 weeks
  2. Verify financial data integrity – 1-2 weeks – on going

 

Stage 2 – Implementing Proactive Financial Management:   4 months

Month 7

  1. All data entry and financial entry are updated daily – 2 weeks
  2. Proactive inventory – 1 week
  3. Detailed analysis of costs of goods, operating overhead, identify opportunities to lower costs and improve efficiencies – 2 weeks

Month 8

  1. Marketing Analysis – 3 weeks – then on-going tracking
  2. Potential business alliances – 1 week – additional opportunities all the time

Month 9

  1. Cash Flow Budget and Forecasting creation – 2-weeks
  2. Formalizing all processes and tracking associated metrics – 2-4 weeks

Month 10

  1. Work on ideal/high value patient identification and effectiveness at selling them–2 weeks
  2. Analyzing your key metrics for hourly, daily, and weekly reporting and projections (As opposed to doing so monthly, quarterly or yearly) – 1 week to implement and then consistently
  3. All administrative systems are automated – 3 weeks

 

Stage 3 – Business Intelligence:   3+ weeks and on going management

Month 11

  1. Fully operational and daily updated Dashboards – 1-2 weeks to create and then another 2 weeks to get updating practices in place
  2. Training all management team/necessary team member in how to use dashboard data to inform them of necessary needs – 1 week to train another 2+ to get practices in place
  3. Demographic and socio-graphic analysis – 1 week

Month 12 + every month onwards

  1. On-going test and measures to consistently improve profitability and effectiveness in:
    1. Marketing
    2. Profit margins
    3. Budget
    4. Forecasts
    5. Productivity
    6. Efficiency
    7. KPI’s and other relevant metrics