Telicon Academy™ · 12 weeks · 48 lessons
Data Analytics Professional Certificate
Statistics, SQL, spreadsheets, Python, visualization and forecasting, applied to realistic business questions and finished with an executive-ready engagement.
Who it's for
Professionals who work with reports or spreadsheets and want an analyst role.
Prerequisites
- Confident spreadsheet user
- High-school algebra
- About 12–15 hours per week
You'll be able to
- Query relational data with SQL
- Clean and validate datasets
- Design clear dashboards
- Present evidence-based recommendations
12-week curriculum
Week 1
Data Literacy, Analytical Thinking & Data Ethics
What analysts actually do · Framing a business question · Data types and structures · Privacy and data ethics
Week 2
Statistics & Probability for Analysts
Descriptive statistics · Distributions and variability · Probability basics · Sampling and confidence
Week 3
SQL & Relational Data
Tables, keys and relationships · Filtering and aggregation · Joins · Subqueries and window functions
Week 4
Excel / Spreadsheet Analytics & Business Models
Formulas and lookups · Pivot tables · What-if and scenario models · Spreadsheet quality controls
Week 5
Python for Data Analysis
Python essentials for analysts · Working with pandas · Grouping and reshaping · Notebooks and reproducibility
Week 6
Data Cleaning, Transformation & Quality
Profiling a dataset · Missing values and outliers · Transforming and joining sources · Data quality rules
Week 7
Data Visualization & Dashboard Design
Choosing the right chart · Visual perception and clarity · Dashboard layout · Storytelling with data
Week 8
Exploratory Analysis, Experiments & A/B Testing
Exploratory workflow · Correlation versus causation · Designing an A/B test · Reading test results
Week 9
Forecasting & Time-Series Fundamentals
Time-series components · Moving averages and smoothing · Simple forecasting models · Forecast accuracy
Week 10
Business Analytics, KPIs & Decision Support
Defining KPIs · Metric trees · Cohort and funnel analysis · Decision memos
Week 11
Analytics Automation, Reproducibility & Intro Predictive Methods
Automating recurring reports · Version control for analysts · Regression basics · Classification basics
Week 12
Data Analytics Capstone & Executive Presentation
Capstone scoping · Analysis sprint · Building the executive deck · Executive presentation
Projects
Week 2 · Applied project
Clean and analyze messy business data
Profile and clean a fictional retailer's sales export.
Week 4 · Applied project
SQL insight report
Answer five business questions with documented SQL.
Week 6 · Mid-program project
Integrated analysis checkpoint
Combine SQL, spreadsheets and Python into one reproducible analysis.
Week 7 · Applied project
KPI dashboard
Design an operations dashboard for a fictional client.
Week 9 · Applied project
Forecasting study
Forecast demand and explain uncertainty.
Week 12 · Capstone · expert panel
End-to-end analytics engagement
Deliver an analysis and executive presentation to a panel.
Admissions readiness check
- Numeracy
- Spreadsheet skills
- Data interpretation
- Logical reasoning
- Data ethics scenarios
Advisory only; staff make the final decision.
Trainer expectations
SQL, spreadsheet/BI and Python analytics experience, working knowledge of statistics and a portfolio of analytics work.
Career directions
- Data Analyst
- BI Analyst
- Reporting Analyst
- Operations Analyst
Not a job guarantee.
Learning and tools
Guided lessons, applied practice and a portfolio of work aligned to this pathway.
Expert review and certificate
The capstone is reviewed by an assigned expert panel. Panel assignments depend on verified reviewer availability; no staff credentials are implied by a seat description.
Published lesson completion and an approved capstone are required. See your learner portal for individual status.
Start dates, financial options and admission decisions are confirmed by staff. A certificate does not guarantee employment.