Learn what data analytics is, how businesses use data to make decisions, and the core skills required to begin a career in data analytics. The course ends with your first small analytics project.
About 6 hours
10 modules
1 badge
Final project
Optional verified certificate
Curriculum
01What is Data Analytics?What analysts actually do: data, information and insight, the four kinds of analytics, the data jobs and tools, and the six steps every analysis follows.20 min
02How Businesses Use DataWhere company data comes from, what makes a good KPI, leading and lagging indicators, and how a KPI tree shows why a number moved.20 min
03Types of DataStructured and unstructured data, numbers and categories, what you can calculate with each type, identifiers, dates, and the grain of a table.15 min
04Understanding DatabasesSpreadsheets versus databases, tables, primary and foreign keys, kinds of relationship, entity-relationship diagrams, normalisation, and a first look at SQL.20 min
05Data CleaningThe six sides of data quality, profiling before you fix, mapping tables, missing values and outliers, and a safe, logged cleaning plan.20 min
06Data AnalysisThe calculations behind most business analysis, one at a time: totals, distinct counts, mean, median and mode, shares, growth, percentage points and rates, and the traps in each.25 min
07Data VisualizationHow people read charts, which chart answers which question, the parts of a chart, colour, misleading charts, and the habits that make a chart clear in five seconds.20 min
08Business IntelligenceAnalytics versus BI, the pipeline from source systems to dashboards, a single source of truth, dashboard design, and self-service with governance.15 min
09From Question to InsightA repeatable method from a vague worry to a recommendation: clarify, make it measurable, break the total down, test and rule out explanations, and tell the story answer-first.10 min
10Your First Analytics ProjectRun the whole cycle on Kolanut's staff data, from question to recommendation, and prepare for the final project.15 min
Final assessmentPass it (60% or more) to earn the Data Analytics Foundations course completion badge.