Learn and Earn
A paid learning experience toward tech enabled careers for Ramsey County residents
Data Analytics
With AI
Elevate your expertise with our immersive bootcamp training sessions, taking your tech skills to new heights.
January 12th - March 26th
Data Analytics
What is Data Analytics?
Data analytics is about examining data to find useful patterns and insights. It helps make informed decisions and solve problems by using statistical and computational methods. From understanding customer preferences to improving operations, data analytics is crucial for smart decision-making.
Core Focus
-
Foundational Data Skills
Learn key analytical skills and tools: data cleaning, analysis, visualization (spreadsheets, SQL, R, Tableau).
-
Data Organization
Understand data cleaning, organization, and analysis techniques with spreadsheets, SQL, and R programming.
-
Present Data
Develop proficiency in visualizing and presenting data findings through dashboards and popular visualization platforms.
Data Analytics Program
Our Fall 2025 Data Analytics program has opened applications.
Apply below today!
In today's data-driven world, the demand for skilled data analysts continues to rise. To address this need and empower aspiring data professionals, we offer a comprehensive Data Analytics Training and Apprenticeship Program. This program is designed to equip participants with the fundamental skills, tools, and knowledge required to excel in the field of data analytics. By focusing on practical hands-on training and real-world case studies, this program aims to bridge the gap between theoretical knowledge and practical application, fostering the growth of the next generation of data analysts.
Dates: Training from January 12th - March 26th
Monday - Wednesday: 9am - 12pm, Thursday: 9am - 2pm
Internships April/May-July
Time Commitment: Around 20 hours a week, including class time and personal work time on assignments.
Please note that this is a hybrid program and will require meeting in-person in Saint Paul once a week (subject to change).
This program is part a Learn and Earn program, meaning that stipends are offered during the program and the opportunity to do a paid internship after completion of the program.
Data Analytics Curriculum
-
Understanding key data analytics concepts
Role of spreadsheets, query languages, and data visualization tools
Introduction to the role of a data analyst
-
Application of problem-solving roadmaps
Incorporating data into decision-making processes
Basic spreadsheet tasks for data organization
-
Factors influencing data collection decisions
Addressing bias in data
Introduction to databases and their components
Best practices for data organization
-
Understanding data integrity and risks
Basic SQL functions for data cleaning
Crafting effective SQL queries
Verifying data cleaning results
-
Importance of data organization for analysis
Data conversion and formatting essentials
Utilizing SQL queries to combine data from multiple tables
Conducting basic calculations in spreadsheets
-
Leveraging data visualizations to communicate findings
Introduction to Tableau for data visualization
Exploring data-driven storytelling
Principles of effective data presentation
-
Introduction to the R programming language
Core concepts of R programming
Creating visualizations in R
Formatting content using R Markdown
-
Distinguishing capstone, case study, and portfolio projects
Key attributes of a complete case study
Application of data analysis process to real-world data
Leveraging case studies/portfolios in job communication