Skip to Section
Submitter's Information
Sabrina Aguilar
Program Director
Central/Mother Lode
Bakersfield College
CTE Dean
Anthony Cordova
Log in to view CTE Dean's Email.
Program Details
Data Analyst
New Program
Information Technology, General (070100)
08/21/23
Over the course of this training program, we'll teach you a variety of skills, including how to:
· Collect, compile, and clean raw data (often from multiple different sources).
· Tell stories by helping analyze, interpret, visualize, and report on what secrets are in the data.
· Draw conclusions and make recommendations that will help your business to grow.
· Organize and manage how your company stores, archives, and deletes data securely, and legally.
· Help predict the future by modeling, forecasting, and anticipating what might come next.
In addition to these technical skills, you will learn “soft” skills, which will help you grow as a software developer and allow you to progress in your career.
Learn to use the most in-demand tools and programming languages: Excel, Tableau and/or Microsoft Power BI, Python and SQL.
The program anticipates approximately two to five completions annually.
Program Proposal Attributes
- Certificate of Achievement: 16 or greater semester (or 24 or greater quarter) units (C)
The goal of the program is to provide students the opportunity to pursue a career as a data analyst as well as prepare for related employment opportunities. Students will also receive an apprenticeship certification with the United States Department of Labor (DOL) and the California Division of Apprenticeship Standards (DAS).
Course Units and Hours
20
n/a
n/a
Course Report
Throughout the duration of the program, students will learn the following:
- Perform database searches using SQL queries to retrieve relevant data.
- Transform data into valuable information.
- Create informative data visualizations.
- Create dashboards and reports to facilitate the decision making process.
- Apply key mathematical concepts for data analysis.
Course | Title | Units | Year/Semester (Y1 or S1) |
---|---|---|---|
Dive into your Data Analyst Apprenticeship | APPR-72A | 1 | Y1 |
Analyze Requirements and Plan a Data Analysis Project | APPR-72B | 3 | Y1 |
Perform an Initial Data Analysis on Sales Data | APPR-72C | 3 | Y1 |
Produce a Dashboard which Visualizes Data | APPR-72D | 4 | Y1 |
Assess Data Quality and Prepare it for Analysis | APPR-72E | 4 | Y1 |
Set up a Database and Retrieve Data | APPR-72F | 4 | Y1 |
Keep Track of Emerging Industry and Technology Trends in Data Analysis | APPR-72G | 1 | Y1 |
Supporting Documents
Central/Mother Lode Regional Questions
Submission Details
04/11/23 - 09:00 AM
Recommended
Return to Drafts
Please list the reason(s) for returning "Data Analyst". to Sabrina Aguilar's drafts. This message will be sent to sabrina.aguilar@bakersfieldcollege.edu
Comments, Documents, Voting
Comments
All Comments
Shelly Conner · 05/03/23
It is helpful to determine the need for a program if the Advisory committee meeting notes or minutes includes information on who is at the meeting. Also, the LMI data provided is not definitively demonstrating a need for this program (39 openings/year)