HumachLearn course
Data Analytics
Learn how to frame analytical questions, work in Excel/SQL/Python, clean and reshape tabular data, perform EDA, build visualisations and communicate evidence.
0/93 lessons complete
01Analytics Thinking & Problem Framing5 lessons
01What Data Analytics isOpen lesson · concept, visual, code, output and practice✓02Descriptive Diagnostic Predictive and Prescriptive AnalyticsOpen lesson · concept, visual, code, output and practice✓03Questions Stakeholders and DecisionsOpen lesson · concept, visual, code, output and practice✓04KPIs Dimensions and MeasuresOpen lesson · concept, visual, code, output and practice✓05The End to End Analytics WorkflowOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
02Python & pandas Essentials6 lessons
01Python Values Variables and ExpressionsOpen lesson · concept, visual, code, output and practice✓02Lists and DictionariesOpen lesson · concept, visual, code, output and practice✓03Dataframes and SeriesOpen lesson · concept, visual, code, output and practice✓04Selecting Rows and ColumnsOpen lesson · concept, visual, code, output and practice✓05Sorting and FilteringOpen lesson · concept, visual, code, output and practice✓06Creating and Renaming ColumnsOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
03Excel & Spreadsheet Analytics15 lessons
01Workbook Worksheet and Table AnatomyOpen lesson · concept, visual, code, output and practice✓02Cell References Relative Absolute and MixedOpen lesson · concept, visual, code, output and practice✓03Core Arithmetic and Aggregation FormulasOpen lesson · concept, visual, code, output and practice✓04Logical Formulas with IF IFS and and orOpen lesson · concept, visual, code, output and practice✓05Conditional Aggregation with SUMIFS COUNTIFS and AVERAGEIFSOpen lesson · concept, visual, code, output and practice✓06Lookup Analysis with XLOOKUPOpen lesson · concept, visual, code, output and practice✓07INDEX and MATCH for Flexible LookupsOpen lesson · concept, visual, code, output and practice✓08Text Cleaning with Trim Clean Textsplit and SubstituteOpen lesson · concept, visual, code, output and practice✓09Date and Time Analysis in ExcelOpen lesson · concept, visual, code, output and practice✓10Excel Tables and Structured ReferencesOpen lesson · concept, visual, code, output and practice✓11Pivottables for Grouped AnalysisOpen lesson · concept, visual, code, output and practice✓12Charts in Excel Choose Label and AuditOpen lesson · concept, visual, code, output and practice✓13Power Query FundamentalsOpen lesson · concept, visual, code, output and practice✓14Spreadsheet Error Handling and AuditingOpen lesson · concept, visual, code, output and practice✓15Spreadsheet Mini Project Sales Performance WorkbookOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
04Reading & Understanding Data6 lessons
01CSV JSON and Tabular File FormatsOpen lesson · concept, visual, code, output and practice✓02Inspect Shape Head and DtypesOpen lesson · concept, visual, code, output and practice✓03Schema and Data DictionaryOpen lesson · concept, visual, code, output and practice✓04Numeric vs Categorical VariablesOpen lesson · concept, visual, code, output and practice✓05Dates and Text FieldsOpen lesson · concept, visual, code, output and practice✓06Descriptive StatisticsOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
05SQL for Analytics7 lessons
01Select and WhereOpen lesson · concept, visual, code, output and practice✓02Order by and LimitOpen lesson · concept, visual, code, output and practice✓03Group by and Aggregate FunctionsOpen lesson · concept, visual, code, output and practice✓04Case ExpressionsOpen lesson · concept, visual, code, output and practice✓05Inner and Left JoinOpen lesson · concept, visual, code, output and practice✓06Window FunctionsOpen lesson · concept, visual, code, output and practice✓07CTEs and Readable QueriesOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
06Data Cleaning & Missing Data8 lessons
01Detect Missing ValuesOpen lesson · concept, visual, code, output and practice✓02Missingness PatternsOpen lesson · concept, visual, code, output and practice✓03Deletion vs ImputationOpen lesson · concept, visual, code, output and practice✓04Mean Median and Mode ImputationOpen lesson · concept, visual, code, output and practice✓05Forward Fill and InterpolationOpen lesson · concept, visual, code, output and practice✓06DuplicatesOpen lesson · concept, visual, code, output and practice✓07Category StandardisationOpen lesson · concept, visual, code, output and practice✓08Outlier ChecksOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
07Reshaping & Integration6 lessons
01Merge and Join DataframesOpen lesson · concept, visual, code, output and practice✓02Validate Join CardinalityOpen lesson · concept, visual, code, output and practice✓03Concatenate DatasetsOpen lesson · concept, visual, code, output and practice✓04Pivot TablesOpen lesson · concept, visual, code, output and practice✓05Melt Wide to LongOpen lesson · concept, visual, code, output and practice✓06Groupby Split Apply CombineOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
08Exploratory Data Analysis7 lessons
01Frequency TablesOpen lesson · concept, visual, code, output and practice✓02Distribution PlotsOpen lesson · concept, visual, code, output and practice✓03Boxplots and OutliersOpen lesson · concept, visual, code, output and practice✓04ScatterplotsOpen lesson · concept, visual, code, output and practice✓05CorrelationOpen lesson · concept, visual, code, output and practice✓06Grouped ComparisonsOpen lesson · concept, visual, code, output and practice✓07EDA ChecklistOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
09Visualisation & Storytelling8 lessons
01Chart SelectionOpen lesson · concept, visual, code, output and practice✓02Bar ChartsOpen lesson · concept, visual, code, output and practice✓03Line ChartsOpen lesson · concept, visual, code, output and practice✓04ScatterplotsOpen lesson · concept, visual, code, output and practice✓05HistogramsOpen lesson · concept, visual, code, output and practice✓06Labels and AnnotationsOpen lesson · concept, visual, code, output and practice✓07Colour and AccessibilityOpen lesson · concept, visual, code, output and practice✓08Avoid Misleading ChartsOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
10Business Analysis7 lessons
01Rates and RatiosOpen lesson · concept, visual, code, output and practice✓02Growth CalculationsOpen lesson · concept, visual, code, output and practice✓03Cohort IntuitionOpen lesson · concept, visual, code, output and practice✓04SegmentationOpen lesson · concept, visual, code, output and practice✓05Funnel AnalysisOpen lesson · concept, visual, code, output and practice✓06Retention and Churn BasicsOpen lesson · concept, visual, code, output and practice✓07Time Series Trend and SeasonalityOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
11Statistical Reasoning6 lessons
01Population vs SampleOpen lesson · concept, visual, code, output and practice✓02Mean Median and VariabilityOpen lesson · concept, visual, code, output and practice✓03Probability IntuitionOpen lesson · concept, visual, code, output and practice✓04Confidence Intervals IntuitionOpen lesson · concept, visual, code, output and practice✓05Hypothesis Tests IntuitionOpen lesson · concept, visual, code, output and practice✓06Correlation vs CausationOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
12Reporting & Reproducibility6 lessons
01From Notebook to ReportOpen lesson · concept, visual, code, output and practice✓02Executive SummaryOpen lesson · concept, visual, code, output and practice✓03Tables That Answer QuestionsOpen lesson · concept, visual, code, output and practice✓04Uncertainty and LimitationsOpen lesson · concept, visual, code, output and practice✓05Reproducible ScriptsOpen lesson · concept, visual, code, output and practice✓06Data and Metric DefinitionsOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→
13Capstone Analytics Project6 lessons
01Frame a Business QuestionOpen lesson · concept, visual, code, output and practice✓02Audit and Clean the DatasetOpen lesson · concept, visual, code, output and practice✓03Perform EDAOpen lesson · concept, visual, code, output and practice✓04Build KPI TablesOpen lesson · concept, visual, code, output and practice✓05Create Final VisualsOpen lesson · concept, visual, code, output and practice✓06Write an Evidence Based RecommendationOpen lesson · concept, visual, code, output and practice✓Section test5 questions · check your understanding before moving on→