Data Analytics / Beginner

Job Guarantee Data Analytics Course

Skillcept's flagship guided program. Live morning classes (10 AM – 1 PM) on SQL / Python / Excel / Power BI in rotation, plus daily Azure deep-dives in the afternoon (2 PM – 8 PM). Includes mock interviews, technical tests, and HR rounds with hiring partners.

sqlpythonexcelpower-biazurejob-guarantee
Curriculum

What you’ll cover.

92 lessons. Each one stands alone but builds on the last. Read in order or jump to what you need.

  1. L0101 — Program orientation & roadmap
    12 minLocked
  2. L0202 — SQL: the analyst's primary language
    12 minLocked
  3. L0303 — Python for analysts: pandas-first
    12 minLocked
  4. L0404 — Excel & Power BI: the dashboard stack
    12 minLocked
  5. L0505 — Azure & cloud-native analytics
    12 minLocked
  6. L0606 — SELECT, WHERE, ORDER BY in depth
    10 minLocked
  7. L0707 — GROUP BY & aggregate functions
    10 minLocked
  8. L0808 — INNER and LEFT JOIN
    10 minLocked
  9. L0909 — Self joins & EXISTS
    10 minLocked
  10. L1010 — Subqueries & CTEs
    10 minLocked
  11. L1111 — Window functions: ROW_NUMBER & RANK
    10 minLocked
  12. L1212 — Window functions: LAG, LEAD & running totals
    10 minLocked
  13. L1313 — Date/time functions across dialects
    10 minLocked
  14. L1414 — String manipulation
    10 minLocked
  15. L1515 — CASE expressions & conditional aggregation
    10 minLocked
  16. L1616 — Set operations: UNION, INTERSECT, EXCEPT
    10 minLocked
  17. L1717 — Indexes & query performance basics
    10 minLocked
  18. L1818 — Transactions & isolation levels
    10 minLocked
  19. L1919 — SQL interview pattern: top-N per group
    10 minLocked
  20. L2020 — SQL interview pattern: gaps & islands
    10 minLocked
  21. L2121 — SQL capstone — analytics on a real dataset
    10 minLocked
  22. L2222 — Python syntax fast track for analysts
    10 minLocked
  23. L2323 — Jupyter & notebook hygiene
    10 minLocked
  24. L2424 — pandas Series & DataFrame fundamentals
    10 minLocked
  25. L2525 — Selecting & filtering with .loc and .iloc
    10 minLocked
  26. L2626 — groupby and agg recipes
    10 minLocked
  27. L2727 — Joining DataFrames with merge
    10 minLocked
  28. L2828 — Pivot, melt and reshape
    10 minLocked
  29. L2929 — Datetime in pandas
    10 minLocked
  30. L3030 — Cleaning text columns
    10 minLocked
  31. L3131 — Handling missing data
    10 minLocked
  32. L3232 — Working with large CSVs efficiently
    10 minLocked
  33. L3333 — numpy crash course
    10 minLocked
  34. L3434 — Visualising with matplotlib & seaborn
    10 minLocked
  35. L3535 — Reading from databases with SQLAlchemy
    10 minLocked
  36. L3636 — Notebook to script: refactoring for production
    10 minLocked
  37. L3737 — Python capstone — customer churn analysis
    10 minLocked
  38. L3838 — Excel power moves: XLOOKUP & dynamic arrays
    10 minLocked
  39. L3939 — Pivot tables & slicers
    10 minLocked
  40. L4040 — Power Query for self-service ETL
    10 minLocked
  41. L4141 — Power Query advanced: M language basics
    10 minLocked
  42. L4242 — Conditional formatting that tells a story
    10 minLocked
  43. L4343 — Excel charts that don't lie
    10 minLocked
  44. L4444 — Forecasting with FORECAST.ETS
    10 minLocked
  45. L4545 — Excel for stakeholder reports
    10 minLocked
  46. L4646 — Power BI Desktop tour
    10 minLocked
  47. L4747 — Star schemas & relationships
    10 minLocked
  48. L4848 — DAX fundamentals: calculated columns vs measures
    10 minLocked
  49. L4949 — CALCULATE: the heart of DAX
    10 minLocked
  50. L5050 — Time intelligence in DAX
    10 minLocked
  51. L5151 — Bookmarks, drill-through & tooltip pages
    10 minLocked
  52. L5252 — Row-level security
    10 minLocked
  53. L5353 — Publishing to the Service & gateways
    10 minLocked
  54. L5454 — Azure portal orientation
    10 minLocked
  55. L5555 — Azure Storage essentials
    10 minLocked
  56. L5656 — Azure Data Lake Storage Gen2
    10 minLocked
  57. L5757 — Azure SQL Database basics
    10 minLocked
  58. L5858 — Azure Synapse Analytics overview
    10 minLocked
  59. L5959 — Azure Data Factory pipelines
    10 minLocked
  60. L6060 — Mapping data flows
    10 minLocked
  61. L6161 — Linked services & integration runtimes
    10 minLocked
  62. L6262 — Azure Key Vault & secret management
    10 minLocked
  63. L6363 — Azure Databricks fundamentals
    10 minLocked
  64. L6464 — Reading from Lake into Synapse
    10 minLocked
  65. L6565 — Azure Monitor & Log Analytics
    10 minLocked
  66. L6666 — DevOps for analytics
    10 minLocked
  67. L6767 — Cost management on Azure
    10 minLocked
  68. L6868 — Azure ML — analyst's view
    10 minLocked
  69. L6969 — Mock Azure technical test
    10 minLocked
  70. L7070 — Building your portfolio repo
    10 minLocked
  71. L7171 — Resume that lands interviews
    10 minLocked
  72. L7272 — LinkedIn for analysts
    10 minLocked
  73. L7373 — Mock aptitude test — quants
    10 minLocked
  74. L7474 — Mock aptitude test — logical reasoning
    10 minLocked
  75. L7575 — Behavioural interview prep
    10 minLocked
  76. L7676 — Salary negotiation basics
    10 minLocked
  77. L7777 — HR round practice & feedback
    10 minLocked
  78. L7878 — Weekly review session 78
    10 minLocked
  79. L7979 — Weekly review session 79
    10 minLocked
  80. L8080 — Weekly review session 80
    10 minLocked
  81. L8181 — Weekly review session 81
    10 minLocked
  82. L8282 — Weekly review session 82
    10 minLocked
  83. L8383 — Weekly review session 83
    10 minLocked
  84. L8484 — Weekly review session 84
    10 minLocked
  85. L8585 — Weekly review session 85
    10 minLocked
  86. L8686 — Weekly review session 86
    10 minLocked
  87. L8787 — Weekly review session 87
    10 minLocked
  88. L8888 — Weekly review session 88
    10 minLocked
  89. L8989 — Weekly review session 89
    10 minLocked
  90. L9090 — Weekly review session 90
    10 minLocked
  91. L9191 — Weekly review session 91
    10 minLocked
  92. L9292 — Weekly review session 92
    10 minLocked
Skillcept.

A modern academy for aspiring data analysts and business analysts. Tight, opinionated courses taught by working professionals — not influencers.

Tracks
  • Data Analytics
  • Business Analytics
  • Web Development
  • Job Guarantee Programs
Skillcept
  • About
  • Manifesto
  • Careers
  • Contact
© 2023 Skillcept Academy.v1.1 · build 2026-06-27

Made with Emergent