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

Business Analytics: Intermediate

Go from analyst to business partner: driver modelling, pricing analytics, experimentation, forecasting, and AI powered strategic analytics.

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

What you'll learn

Structure ambiguous business problems like a consultant and build hypothesis driven analyses
Write advanced analytical SQL using window functions, CTEs, and analytical data modelling
Build driver trees, margin analysis, and pricing elasticity models
Design and analyze rigorous A/B tests and quasi experiments for causal evidence
Deliver a pricing and profitability recommendation with a driver model and scenario testing
Build forecasting and predictive models for churn, demand, and customer behaviour
Automate reporting with Python and eliminate manual analytical work
Build text to SQL natural language querying and RAG powered AI agents over business data
Deliver a full strategic analytics product with a predictive model, financial case, and executive defense

Who this course is for

  • Beginner level graduates ready to move into strategic business partner roles
  • Business analysts who want structured, consultant level analytical skills
  • Professionals preparing for mid level analytics and consulting case interviews
  • Anyone who wants hands on experience with pricing analytics and AI powered analytics products

Skills you'll gain

Intermediate Business AnalyticsBusiness PartnerAdvanced SQLWindow FunctionsAnalytical ModellingDriver TreeMargin AnalysisPricing AnalyticsPrice ElasticityCustomer Lifetime ValueScenario ModellingSensitivity AnalysisAB TestingExperimentationCausal InferenceForecastingRegression AnalysisPredictive AnalyticsChurn PredictionPython for AnalystsAutomated ReportingPower BI DAXText to SQLRAGAI AgentsFinancial Impact ModellingExecutive Communication

This course includes

Live mentor led Ucanly sessions plus self paced recorded content
A minor project delivering a real pricing and profitability recommendation by week five
A major project delivering a full strategic analytics product by week ten
Ucanly portfolio review, mock analytics and consulting case interviews, and a personalized roadmap to Advanced
Lifetime access to course materials and future updates
Certificate of Completion from Ucanly

Course content

8 modules · 48 lessons · 15 h 23 min

Analytics that changes decisions, advanced SQL and analytical modelling, business drivers pricing and profitability, experimentation and causal evidence, a minor project fixing pricing and profitability, forecasting and predictive analytics, Python automation and Generative AI for analytics, and a major project delivering a strategic analytics product.

Requirements

  • Completion of the Beginner level, or working knowledge of Excel, SQL, business metrics, dashboards, and basic statistics
  • A computer with a reliable internet connection
  • Comfort with basic SQL queries and Excel formulas

About this course

Level up from analyst to business partner. This intermediate program from Ucanly takes practitioners with working knowledge of Excel, SQL, business metrics, dashboards, and basic statistics into strategic analytics: structuring problems like a consultant, advanced SQL with window functions and analytical data modelling, and driver tree decomposition for pricing and profitability. In your minor project in week five, you will deliver a complete pricing and profitability engagement with segmentation, elasticity analysis, a driver model, scenario testing, and a quantified margin recommendation. You will run rigorous A/B tests and causal analysis, build forecasting and predictive models for churn and demand, and automate reporting with Python. On the AI side, you will build text to SQL natural language querying, RAG over business documents, and AI agents that investigate data. You will graduate having delivered a full strategic analytics product in your week ten major project, with an automated pipeline, a predictive model, an experiment design, a financial impact case, an AI powered insight assistant, and a live executive defense.

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 Excel, SQL, business metrics, dashboards, and basic statistics is sufficient to start.

Yes, your minor project is a complete pricing and profitability engagement with segmentation, elasticity analysis, a driver model, scenario testing, and a quantified margin recommendation defended in front of your mentor.

You will build text to SQL natural language querying, RAG over business documents, and AI agents that investigate and explain data, culminating in a full AI powered insight assistant.

A full strategic analytics product with an automated pipeline, a predictive model, an experiment design, a financial impact case, an AI powered insight assistant, and a live executive defense to Ucanly mentors.