# Analytics Accelerator

{% hint style="success" %}
If you are interested in learning more about whether the Analytics Accelerator is right for you, please [**book an office hours**](https://scheduler.zoom.us/d/uh6r95wu/office-hours---odi-s-analytics-accelerator) appointment with our team to learn more about the service. 
{% endhint %}

The Analytics Accelerator is a holistic approach to help your department or program move from manual, high effort reporting to streamlined and automated reporting.

<figure><img src="https://3380877943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkuHwvN7GKtzQ52TOWxrU%2Fuploads%2FXHwNv99uftKD8CfrzhAp%2FCleanShot%202023-01-12%20at%2019.06.53%402x.png?alt=media&#x26;token=0fc15525-f7da-4c01-a9e5-5d320305efc5" alt=""><figcaption><p>Move from manual to automated reporting in order to free up your data teams time for more meaningful tasks</p></figcaption></figure>

ODI's Analytics Accelerator aims to both free up analyst's time and provide them with new skills to tackle new analytic challenges. During a 3 month engagement, we will train a cohort of department analysts in PowerBI.&#x20;

{% hint style="info" %}
PowerBI is a dashboarding tool included in the latest statewide Microsoft Office licensing contract. This means that there is no cost for most departments to use this tool. Not familiar with PowerBI? See this [brief overview video](https://youtu.be/Vqz2d7pTOV8?t=23).
{% endhint %}

This service moves beyond the limitations of individual ‘tool based’ training to a more holistic approach:

* **We use a cohort training model** to allow groups of data staff to learn together
* **We provide wraparound support** so that training doesn’t end in the classroom but includes consultation, office hours, and documentation.
* **We include IT engagement.** Special engagement is available for IT staff interested in leveraging and governing PowerBI.
* **We use a train the trainer model** to allow staff to use our materials to train other staff after their engagement has ended.

{% hint style="success" %}
Visit our [showcase](https://docs.data.ca.gov/odi-data-services-dif/analytics-accelerator/showcase-analytics-accelerator) to see past public sector analytics accelerator engagements.
{% endhint %}

## How this service can help your department

This service can help your department:

* **Automate your reporting** using dashboard tools
* **Upskill data teams** by teaching them PowerBI
* **Develop user friendly data tools** for your leadership and management
* **Create accessible, enticing public reporting**

## Who is a good fit for this service

This service is a good fit for:

* **Data & analytic teams or program team leads** who want to upskill an entire team or group
* **Department leadership and management** who wants to have dashboards for key operational areas
* **Analytics, reporting, or program staff** who want access to tools to make their day to day life easier and learn new workflow practices to maximize data work
* **IT staff** who want to empower their program side to better use their data in a secure and governed reporting tool

This service may not be a good fit for:

* **Programs that have already automated their reports.** If you have already automated all of your reports and key measures (e.g. no manual prep in Excel etc), you probably don’t need this service.  NOTE: But if you are interested in migrating to PowerBI, this service will help you do that quickly.
* **Programs that need to change or automate data collection.** The service helps automate the analytics portion of the report process. It is designed to work with existing data that is already collected in the format or structure you need.
* **A la carte training.** This service requires that analysts complete each training module. The trainings build on each other and are meant to be taken holistically not a la carte.
* **Individual training.** This service is designed to train whole teams together as a cohort. We’ve learned that this is the best way to make an enduring department impact.
* **Departments without data or analyst staff.** The training assumes a baseline analytical ability. More in our section on expectations.

## What this service includes

The Analytics Accelerator is more than traditional training, and includes wrap around support:

<figure><img src="https://3380877943-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkuHwvN7GKtzQ52TOWxrU%2Fuploads%2FsIW70h4tlTs8TricHQ8C%2FCleanShot%202023-01-20%20at%2015.17.29.png?alt=media&#x26;token=cef97efa-46d8-4d74-9666-0f46521f5da7" alt=""><figcaption></figcaption></figure>

{% hint style="success" %}
All analytics accelerator engagements will involve working on actual department work products (report, dashboard, etc) in parallel to the training.  Successful completion of the Accelerator involves the successful completion of these reports. Read below for more
{% endhint %}

During the 3 month engagement period participants will participate in:

<table><thead><tr><th width="210"></th><th></th></tr></thead><tbody><tr><td>Scoping Session</td><td>Needs assessment meeting to identify how to structure the training and which components to prioritize.  Identification of pilot reports to be working on in parallel to course work.</td></tr><tr><td>Program Staff Training/Offerings</td><td><p>Courses/Workshops/Other group engagements</p><ul><li>Intro to PowerBI (10 hrs)</li><li>Intermediate PowerBI: Data Structure and Modeling (10 hrs)</li><li>Intermediate PowerBI: DAX (10 hrs)</li></ul></td></tr><tr><td>(Optional) IT staff Training/Offerings</td><td><ul><li>Curated Selection of Program Staff Trainings</li><li>PowerBI tenant settings check up mtg</li></ul></td></tr><tr><td>Project Review Sessions</td><td>Targeted application of learnings on a priority department dashboard(s) and report(s), with extensive consulting and coaching from the CalData team.  Dashboard will be selected at beginning of engagement during scoping session and worked on until engagement ends via special Project Review sessions</td></tr><tr><td>Train the Trainer</td><td>Extra training for department PowerBI champions so they continue to support onboarding new staff to PowerBI</td></tr><tr><td>Office Hours &#x26; Consulting Appointments</td><td>1:1 Consulting to support completion of pilot dashboards.  As well as assessment of absorption and application of data concepts and learning to pilot reports. </td></tr></tbody></table>

After the engagement, staff will have access to:

|                                                       |                                                                                                                     |                                                                |
| ----------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------- |
| Enduring recorded  training materials & documentation | Extended Access to Office Hours for Department PowerBI Champions for advanced consultation and technical assistance | PowerBI Champion access to special advanced training materials |

## Expectations of department partners

### Types of participants

The engagement can be tailored to a wide range of staff familiarity with PowerBI

* **Beginners** - Perfect for the accelerator
* **Intermediate** - Maybe your department already had staff attend an '8-hour bootcamp' for PowerBI. There is still enormous value in scoping an engagement. Often those bootcamps dont teach best practices and this gap ends up holding back teams from their full potential.
* **Advanced** - maybe you are Advanced PowerBI whiz, but want to help bring along others in your department but it feels overwhelming. Lets partner!

{% hint style="info" %}
There are no restrictions to staff based on group affiliation or classification.  Data Teams, Program Teams, IT teams etc are welcome.  But there are some things we do require.  See below section for more
{% endhint %}

### Expectations

Below are the expectations departments will need to meet to use this service:

* [ ] **Staff cohort.** Department teams must identify a group of staff to participate.&#x20;
* [ ] **Existing staff skill level.** Our program assumes a baseline analytic competency and moves at a quick pace to maximize analyst time. It is not designed to take non-data staff and teach them data skills. As a rule-of-thumb, we ask that staff interested in participating should, at a minimum, be experienced and comfortable with Excel pivot tables. &#x20;
* [ ] **Data ready for reporting.** This service does not help create new data, or turn manual data collection processes into automatic ones. The traditional applicant will have a data source (ex. csv file, Excel file, SQL table, or database) pulled from a source system that they have access to for processing in their existing reporting tool (e.g. Excel).
* [ ] **Data leadership participation.** Data or program leaders should be active participants in the process. They will help shape the engagement at an initial Analytics Assessment meeting and will be required to participate in a regular progress meeting to ensure alignment.&#x20;
* [ ] **PowerBI Champions.** CalData will work with you to identify department PowerBI leaders for additional training and investment.&#x20;
* [ ] **Organizational commitment and prioritization.**
  * **Dedicated staff time.** The program consists of a mix of training, course work, project work. This will involve a significant time investment (\~80 hours) spread out over 3 months.&#x20;
  * **Department reporting project.** Departments will need to identify reports with business impact for staff to build as they go through the course.
  * **IT partnership (or participation).** This program is designed for partnership (and ideally) participation with department IT departments. At a minimum, IT should be willing partners to install PowerBI, enable PowerBI licenses, and establish workspaces ahead of the training to enable department participation. CalData can walk them through this process.
* [ ] **Presenting and Disseminating.** Part of our goal is to document and communicate what we learn and accomplish so both other departments and jurisdictions can benefit. We will need input and feedback and some participation from departments in this process. See examples in the showcase section.