Author
Sparsh Upadhyay
Lessons (45)
- Bar chart best practices: sorting, baselines, labels
- Line chart best practices for time series data
- Histograms, box plots and violin plots explained
- Scatter plots: show relationships and correlation
- Excel formulas: relative vs absolute cell references
- Excel Tables, sort and filter for clean data
- Power BI Desktop tutorial for beginners
- Power BI get data and Power Query transformations
- How to install Python and run your first script
- Python strings and numbers: f-strings, slicing, rounding
- Python lists and tuples: slicing, sorting, comprehensions
- Python dictionaries and sets with real examples
- Python if, for and while loops explained
- Python loops: the lesson nobody teaches you
- What is SQL? Databases, tables and your first query
- SQL NULL values: IS NULL, COALESCE and three-valued logic
- SQL data types and CAST: numbers, text, dates
- SQL LIKE, IN and BETWEEN with wildcards and ranges
- SQL CASE WHEN: conditional logic and buckets
- SQL FULL OUTER JOIN, CROSS JOIN and SELF JOIN
- SQL join fan-out: avoid double counting rows
- SQL subqueries: IN, EXISTS and correlated subqueries
- SQL percentiles and median: PERCENTILE_CONT and NTILE
- Remove duplicate rows in SQL with ROW_NUMBER
- SQL date functions: DATE_TRUNC, EXTRACT and intervals
- SQL string functions: TRIM, SUBSTRING, REPLACE and regex
- SQL pivot: rows to columns and unpivot
- SQL funnel analysis: conversion rates step by step
- SQL composite indexes and covering indexes
- Hash join vs nested loop vs merge join
- SQL query optimization: rewrite slow queries
- SQL isolation levels, locks and deadlocks
- Variance and standard deviation explained
- Correlation vs causation: Pearson and Spearman
- Lol
- Probability basics: rules and conditional probability
- Bayes theorem explained with real examples
- Binomial and Poisson distributions with examples
- Normal distribution and z-scores
- SQL CREATE TABLE with primary keys and foreign keys
- SQL INSERT, UPDATE and DELETE without breaking data
- Database normalization: 1NF, 2NF, 3NF with examples
- SQL transactions and ACID: COMMIT and ROLLBACK
- SQL UPSERT and MERGE: insert or update rows
- SQL views vs materialized views