Skip to content
Ucanlyfor Education
Back to courses
IntermediateData Analytics8 weeks
Certificate IncludedCertificate EligibleUcanly certificate

Data Analytics with Python: Intermediate

Go from analyst to insight driven professional: advanced SQL, experimentation, cohort and forecasting analysis, and Generative AI over business data.

Duration
8 weeks
Level
Intermediate
Content
47 lessons
8 modules · 14 h 58 min
Certificate
Included
On completion
Access
Fee by email
Or take the free aptitude test

What you'll learn

Handle advanced Pandas operations, large datasets, and reusable, reproducible analysis pipelines
Write advanced analytical SQL using window functions, CTEs, and query optimization
Design and analyze rigorous experiments using confidence intervals, A/B testing, and regression analysis
Run cohort analysis, funnel analysis, customer segmentation, and lifetime value calculations
Build time series forecasting systems using ARIMA, Prophet, and rolling window techniques
Apply predictive analytics for churn and demand modelling, explained to non technical stakeholders
Build embeddings, vector search, and RAG systems over your own business data
Build text to SQL and AI agents that query, chart, and summarize data automatically
Ship a complete business analytics product with an automated pipeline, an executive dashboard, and an AI insight assistant

Who this course is for

  • Beginner level graduates ready to move into insight driven analytics roles
  • Data analysts who want structured, advanced business analytics skills
  • Junior analysts preparing for mid level interviews and case studies
  • Anyone who wants hands on experience building AI powered analytics products

Skills you'll gain

Intermediate Data AnalyticsAdvanced SQLWindow FunctionsPandasStatistical AnalysisAB TestingRegression AnalysisCohort AnalysisFunnel AnalysisCustomer SegmentationTime Series ForecastingProphetPredictive AnalyticsPower BITableauRAGText to SQLAI AgentsBusiness Analytics

This course includes

Live mentor led Ucanly sessions plus self paced recorded content
Production style projects in every module
Ucanly portfolio review, mock analytics and case study interviews, and a personalized roadmap to Advanced
Lifetime access to course materials and future updates
Certificate of Completion from Ucanly

Course content

8 modules · 47 lessons · 14 h 58 min

Advanced data wrangling with Python, advanced SQL for analysts, statistical analysis and experimentation, business analytics with cohorts and customer insight, time series analysis and forecasting, predictive analytics and applied machine learning, Generative AI for data analytics, and a capstone complete analytics product.

Requirements

  • Completion of the Beginner level, or working knowledge of Python, Pandas, SQL, and basic statistics and visualization
  • A computer capable of running Python and common data analytics libraries
  • Comfort cleaning data and running a simple analysis or dashboard

About this course

Level up from analyst to insight driven professional. This intermediate program from Ucanly takes practitioners with working knowledge of Python, Pandas, SQL, and basic statistics and visualization into advanced business analytics: reproducible pipelines, analytical SQL with window functions and CTEs, rigorous A/B testing and regression analysis, and cohort, funnel, and RFM based customer analytics. You will build time series forecasting systems with ARIMA and Prophet, apply predictive analytics for churn and demand modelling, and build embeddings, RAG systems, and text to SQL natural language analytics over your own business data. You will graduate having shipped a complete business analytics product with an automated pipeline, cohort and forecasting analysis, an executive dashboard, and an AI powered insight assistant.

Earn a Ucanly certificate

Complete this course to earn a Ucanly certificate with its own page and QR code. Save it as a PDF, share its link, or add it to the certifications on your LinkedIn profile.

Certificate IncludedCertificate EligibleUcanly certificate

Frequently asked questions

It is recommended, but working knowledge of Python, Pandas, SQL, and basic statistics and visualization is sufficient to start.

Yes, you will design and analyze a complete A/B test, covering sample size, power, confidence intervals, and regression based business insight.

You will build embeddings and vector search over business data, RAG systems on your own reports, text to SQL natural language analytics, and AI agents that analyze and explain data.

A complete business analytics product with an automated pipeline, cohort and forecasting analysis, an executive dashboard, and an AI powered insight assistant, mentored by Ucanly.