Analytix Camp

Live Online Data Analyst Course

Data AnalystWith AI+ AWS + Snowflake

Build The Skills To Turn Business Data Into Better Decisions.

Go from working with spreadsheets to building dashboards, querying databases and presenting insights with confidence. In this four-month live bootcamp, learn Excel, SQL, Power BI, Tableau and Python, then bring AI, AWS and Snowflake into your analytics workflow.

Practice on projects across retail, finance, healthcare and other industries. Learn to clean messy data, investigate business questions and communicate your findings—while building a portfolio that shows how you think and work as an analyst.

Saturday & Sunday06:30–09:00 PM · PKT
Microsoft Teams
Live OnlineMicrosoft Teams

Take The Next Step In Your Data Journey.

Enroll Now

Practical Skills. Business Context. Your Own Work.

From Learning Tools
To Solving Business Problems.

This live, project-based bootcamp connects the full analytics workflow: prepare messy data, ask the right questions, build clear dashboards and explain what the results mean. Start with spreadsheets and databases, develop your reporting and Python skills, and extend your analysis into cloud data platforms and AI-assisted workflows.

Practice across retail, banking, hospitality, healthcare and other business domains. Use the project collection to turn lessons into work you can discuss and present, while learning how different tools fit together. Whether you are building a foundation or broadening your existing skills, the course gives you a structured path from raw data to a business-ready analytical story.

Live Weekend LearningIndustry-Based ProjectsAnalytics + AI + Cloud

Build Practical Skills With Guided Learning.

Start Your Learning Journey

The Skills Behind The Work

Your New
Everyday Toolkit.

From a spreadsheet to a cloud warehouse.
Get familiar with the tools at every stage of the data journey.

Analyze

Microsoft Excel

Spreadsheets & analysis

Analyze

Power BI

Reports & dashboards

Analyze

SQL

Query & explore data

Analyze

Python

Analysis with code

Connect

Microsoft Fabric

Connected analytics

Connect

Snowflake

Cloud data warehouse

Connect

AWS

Cloud foundations

Automate

n8n

AI workflow automation

Automate

Make

No-code workflows

Automate

Claude

AI-assisted analysis

Learn the tool. Apply the skill. Build the business case.Explore the curriculum

Put These Tools To Work On Business Problems.

Learn These Skills

The Complete Learning Path

Explore The
Complete Curriculum.

From core analytics to cloud pipelines and AI automation. Review every module, topic and practical application.

9 Modules · 67 Topics
Microsoft Excel01. Microsoft Excel For Analytics, Reporting & Dashboards10 Topics
  1. 1.1 Excel Fundamentals & Functions

    Text, aggregation and conditional functions; SUMIFS, IF, SWITCH and FILTER; VLOOKUP, XLOOKUP and INDEX–MATCH; essential data cleaning.

  2. 1.2 Data Visualization

    Column, bar, line, pie, donut, histogram, waterfall and combination charts; formatting charts for business presentations.

  3. 1.3 Scenario & Sensitivity Analysis

    Data Tables, Goal Seek, Scenario Manager and Solver for comparing assumptions and business outcomes.

  4. 1.4 FMCG Company Case Study

    Apply spreadsheet analysis and reporting to a consumer-goods business scenario.

  5. 1.5 Data Analysis With PivotTables

    Structure source data; create, navigate, refresh and format PivotTables; use grouping and conditional formats.

  6. 1.6 Calculated Values & Fields

    Percentages, running totals, differences, rankings and calculated fields for analytical reporting.

  7. 1.7 Textile Business Case Study

    Practice business analysis and reporting with a textile-company dataset.

  8. 1.8 Data Transformation With Power Query

    Connect, clean, merge and transform data; add columns and load refreshable results into Excel.

  9. 1.9 Reporting With Power Pivot

    Build data models and DAX calculations; analyze business metrics, add targets and apply conditional formatting.

  10. 1.10 Multinational & Coffee-Sales Projects

    Create interactive Excel dashboards, dynamic PivotTable reports and the 365 Coffee Cafe analysis.

SQL Server02. SQL For Data Analysis8 Topics
  1. 2.1 SQL Foundations

    Databases, data lakes, warehouses and data marts; SQL Server, MySQL and PostgreSQL; query tools and basic SQL syntax.

  2. 2.2 Querying & Filtering

    SELECT, FROM, WHERE and ORDER BY; aliases, GROUP BY, TOP N, DISTINCT and OFFSET FETCH.

  3. 2.3 SQL Functions & Conditional Logic

    Numeric, string and date-time functions; counting rows, comparisons, logical operators, IIF, CASE and NULL handling.

  4. 2.4 Working With Multiple Tables

    Relationships and ER diagrams; INNER, OUTER, LEFT, RIGHT and CROSS joins; UNION, views, self joins and natural joins.

  5. 2.5 Subqueries & Derived Tables

    Scalar, multi-row and correlated subqueries; derived tables and common table expressions (CTEs).

  6. 2.6 Window Functions

    ROW_NUMBER, RANK, DENSE_RANK, LAG and LEAD; partitioning results and troubleshooting analytical queries.

  7. 2.7 Data Cleaning

    Remove duplicates, handle missing values, split and standardize columns, and prepare datasets for analysis.

  8. 2.8 SQL Business Projects

    World Life Expectancy, 365 Super Mart, financial-statement analysis with Power BI, and 365 Technologies.

Power BI03. Power BI For Business Intelligence8 Topics
  1. 3.1 Power BI Desktop

    Installation, configuration, interface, workflow and core settings.

  2. 3.2 Power Query

    Data connectors, table profiling, text/number/date transformations, conditional columns, grouping, aggregation, merge, append and parameters.

  3. 3.3 Data Modeling

    Normalization, fact and dimension tables, active/inactive relationships, cardinality, star and snowflake schemas, evaluation order, expanded tables and context transition.

  4. 3.4 Calculated Columns With DAX

    Text, date, logical and conditional functions, including SWITCH for dynamic calculations.

  5. 3.5 DAX Measures

    Implicit and explicit measures; filter context; math, statistics, counting, filtering and iterator functions; variables, time intelligence, CALCULATE, ALL and FILTER.

  6. 3.6 Visualization & Data Storytelling

    Advanced charts, filtering, slicing, drilling, numeric/field parameters, navigation and tooltips; anomaly detection, smart narratives, Q&A, decomposition trees and key influencers.

  7. 3.7 Guided & Independent Projects

    365 Super Market, Granny’s Cafe, Media Feathers, redesigned Media Feathers and Retail Inc.; explore the larger cohort project collection below.

  8. 3.8 Additional Connectivity Practice

    Power BI Projects 11–20 demonstrate web, cloud, database and file connections, plus sales-data modeling.

Python04. Python For Data Analysis8 Topics
  1. 4.1 Python Introduction & Setup

    Python applications, Anaconda, Jupyter Notebook, notebook comments and the development environment.

  2. 4.2 Objects, Variables & Data Types

    Numbers, strings, lists, dictionaries, tuples, sets and booleans; string methods, concatenation and formatting.

  3. 4.3 Control Flow & Loops

    Operators, if/else, for and while loops, break, continue, pass, list comprehensions, IN and NOT IN.

  4. 4.4 Functions & Error Handling

    Built-in and user-defined functions, arguments, keyword arguments, lambda, map, filter and exceptions.

  5. 4.5 NumPy

    Array creation, slicing, indexing, arithmetic, mathematical functions and input/output operations.

  6. 4.6 Pandas

    Series and DataFrames; selection, aggregation, grouping, cleaning and combining data; Excel, CSV, HTML and database input/output.

  7. 4.7 Matplotlib

    Bar, line, scatter, histogram and box plots; selecting appropriate charts and improving their presentation.

  8. 4.8 Seaborn

    Categorical, relational, distribution, regression and matrix plots; multi-plot grids and visual styling.

Tableau05. Tableau Fundamentals8 Topics
  1. 5.1 Getting Started With Tableau

    Installation, interface, first charts, color, formatting and filters.

  2. 5.2 Calculations, Groups, Bins & Parameters

    Time series and categorical aggregation; calculated fields, table calculations and interactive parameters.

  3. 5.3 Interactive Dashboard Mini Project

    Build and format dashboards; add filters and highlighting; share an interactive analytical story.

  4. 5.4 Joins, Relationships & Unions

    Connect multiple datasets and combine sources for analysis.

  5. 5.5 Storytelling, Maps & Hierarchies

    Create hierarchies, geographical maps and visuals that communicate business findings.

  6. 5.6 Advanced Visualizations

    Histograms, box-and-whisker plots, area and dual-combination charts, Gantt charts, treemaps and packed bubbles.

  7. 5.7 Data Interpretation & Cleaning

    Data Interpreter, pivots, splitting and combining columns, the Analytics tab, clustering and forecasting.

  8. 5.8 KPI Dashboard Project

    Combine Tableau techniques in a business-performance dashboard.

Microsoft Fabric06. Microsoft Fabric For Data Analysts5 Topics
  1. 6.1 Fabric Overview & Architecture

    Understand the platform, storage options, data transformations and enterprise analytics use cases.

  2. 6.2 Core Concepts

    Explore Fabric through the Power BI interface, its architectural framework and approaches to handling enterprise data.

  3. 6.3 The Fabric Pilot Initiative

    Define the challenge and plan a pilot for the 365 Enterprises scenario.

  4. 6.4 Executing The Pilot

    Integrate external sources, transition existing BI content, publish reporting and automate refreshes with pipelines.

  5. 6.5 Supply Chain Excellence Project

    Apply Fabric to supply-chain operations and business reporting.

Scikit-learn07. Machine Learning & AI For Analysts7 Topics
  1. 7.1 Machine Learning Foundations

    Classification and regression; supervised and unsupervised learning; key algorithms and analyst tools.

  2. 7.2 The AI Project Lifecycle

    Requirements, scope, collection, preparation, feature engineering, model selection, training, evaluation, tuning, deployment and MLOps.

  3. 7.3 Model Evaluation

    Interpret accuracy, precision, recall and F1 score when assessing model performance.

  4. 7.4 Data Foundations For AI

    Data infrastructure, collection, storage and transformation; privacy, ethics and governance.

  5. 7.5 AI-Powered Technical Workflows

    Use AI to support collection, cleaning, transformation, insight generation and visualization.

  6. 7.6 Stakeholder Communication

    Use AI to improve analytical explanations, emails and presentations while retaining human judgment.

  7. 7.7 Career Growth & Job Search

    Resume customization, professional networking and AI-assisted technical, case-study and behavioral interview practice.

AWS08. AWS & Snowflake: Data Flows And Pipelines7 Topics
  1. 8.1 Cloud Orientation & Learner Essentials

    Course outcomes, prerequisites, learning routines and the practical workflow for analysts moving into cloud data.

  2. 8.2 Core BI Concepts & Architectures

    OLAP versus OLTP; Data Engineer, Data Analyst and AI Engineer roles; data lakes, warehouses and lakehouses; ETL versus ELT.

  3. 8.3 Medallion Layers & File Formats

    Bronze, silver and gold layers; CSV/JSON versus columnar Parquet and their use cases.

  4. 8.4 AWS & Snowflake Setup

    Cloud accounts, S3 storage, IAM roles and policies, Snowflake trial setup, integration objects, trust relationships and external stages.

  5. 8.5 Your First ETL Pipeline

    Create a repeatable flow from raw files into S3 and Snowflake, then validate the loaded data.

  6. 8.6 Transformations & BI Connections

    Explore and transform data with Snowflake SQL; connect Power BI through Import/DirectQuery and connect Tableau.

  7. 8.7 End-To-End Capstone

    Build reporting for rainfall, monthly usage and cost savings; complete an S3 → Snowflake → BI workflow with a repeatable delivery checklist.

n8n09. AI Automation With n8n, Make & Claude6 Topics
  1. 9.1 AI-Assisted Analysis

    Use Claude to support the analytical tasks introduced in the course, with review of generated queries and explanations.

  2. 9.2 Make & Google Sheets Workflow

    Practice the web-data collection and Google Sheets scenario in the cohort project collection.

  3. 9.3 n8n Email Data Workflow

    Explore the Gmail data-extraction automation scenario.

  4. 9.4 SQL Query Agent

    Build and examine an agent workflow for working with SQL queries.

  5. 9.5 Insight Generation & Data Governance

    Apply the n8n Insight Generator and Data Governance With AI Agents project scenarios.

  6. 9.6 Power Automate Scenario

    The Power Automate AI Automation project is planned; project materials are not yet available.

The technical outline follows the course brochure. AI automation scenarios reflect the current cohort project collection; planned project materials are labeled.

Follow The Complete Learning Path With Us.

Join The Course
Muhammad Abbas
YOUR GUIDE THROUGH THE DATA
RevolutSenior Data Specialist
Revolut Inc. · UK

Who’s Your Instructor?

Industry Experience.
In Your Classroom.

Muhammad Abbas

Senior Data Specialist - Revolut Inc. UK

Founder of Analytix Camp, Muhammad combines analytics, business intelligence and finance. His teaching connects technical skills with the business questions behind the numbers.

Through case studies and hands-on exercises, he makes complex ideas easier to apply. He also shares practical learning through the Abbas Imami YouTube channel.

9+Years in analytics
200+Trainings delivered
25,000+Learners worldwide
EXPERIENCE BEHIND THE CLASSROOM
Current Role

Revolut Inc. · UK

Senior Data Specialist

Previous Experience

TechFlow

Business intelligence & valuation

Founder

Analytix Camp

Practical training for data professionals

Learn With Muhammad Abbas.

Learn With Your Instructor

Your Work. Your Portfolio.

Small Beginnings.
Real Business Impact.

34 core scenarios across different industries.
Explore the businesses you’ll learn with.

Core Projects

365 Super Market IncProject 01

365 Super Market Inc

Super MarketPower BI
365 Media FeathersProject 02

365 Media Feathers

Digital marketingPower BI
365 Granny CafeProject 03

365 Granny Cafe

CaféPower BI
365 Cosmetics IncProject 04

365 Cosmetics Inc

CosmeticsPower BI
365 Retail IncProject 05

365 Retail Inc

RetailPower BI
Sports retail iconProject 06

Adventure Works

Sports retailPower BI
Finance iconProject 07

365 Financial Statement

FinancePower BI
Real Estate iconProject 08

365 Real Estate

Real EstatePower BI
Banking iconProject 09

365 Banking Group

BankingPower BI
Insurance iconProject 10

365 Insurance

InsurancePower BI
365 Boot CampProject 11

365 Boot Camp

SalesExcel
365 CorporationProject 12

365 Corporation

Business operationsExcel
365 Coffee Cafe IncProject 13

365 Coffee Cafe Inc

CaféExcel
365 Creative IncProject 14

365 Creative Inc

Creative businessExcel
Consumer research iconProject 15

American Coffee Taste Test

Consumer researchExcel
Confectionery iconProject 16

365 Chocolate Cafe

ConfectioneryExcel
365 VenturesProject 17

365 Ventures

SalesSQL
365 BakeryProject 18

365 Bakery

BakerySQL
365 TechnologiesProject 19

365 Technologies

Technology hardwareSQL
Restaurant iconProject 20

365 Pizza Parlor

RestaurantSQL
E-commerce iconProject 21

365 Website Analytics

E-commerceSQL
365 HospitalityProject 22

365 Hospitality

HospitalityPython
365 Food And BeveragesProject 23

365 Food And Beverages

Food & beveragesPython
Fashion retail iconProject 24

365 Men'S Clothing Store

Fashion retailPython
Pharmaceuticals iconProject 25

365 Emirates Pharma

PharmaceuticalsPython
Insurance iconProject 26

365 Noor Takaful Premium

InsuranceMachine Learning
Real Estate iconProject 27

365 Real Estate

Real EstateMachine Learning
Data collection iconProject 28

Make.AI Web Scrapping And Google Sheet

Data collectionAI Automation
Sales operations iconProject 29

n8n Automation Gmail Data Scrap

Sales operationsAI Automation
Business intelligence iconProject 30

n8n SQL Query Agent

Business intelligenceAI Automation
Business automation iconProject 31

Power Automate AI Automation

Business automationAI Automation
Business intelligence iconProject 32

n8n Insight Generator

Business intelligenceAI Automation
Data governance iconProject 33

Data Governance With AI Agents

Data governanceAI Automation
Food & beverages iconProject 34

365 Pepsi Co. Inc

Food & beveragesSnowflake

Connectivity & Data Model Projects

Sports iconProject 35

365 Cricket Analytics

SportsPower BI
Healthcare iconProject 36

365 Hospital Inc

HealthcarePower BI
Real Estate iconProject 37

365 Real Estate Inc

Real EstatePower BI
Consumer technology iconProject 38

365 Mobile Tech Inc

Consumer technologyPower BI
Healthcare iconProject 39

365 Health Care Inc

HealthcarePower BI
Lending iconProject 40

365 Loan Default

LendingPower BI
Inventory iconProject 41

365 Inventory Management

InventoryPower BI
Food & beverages iconProject 42

365 Fruita Vitals

Food & beveragesPower BI
Insurance iconProject 43

365 Insurance

InsurancePower BI
Sales iconProject 44

365 Sales Analytics

SalesPower BI

Logos represent course project brands. 32 core scenarios include materials; 2 are marked as planned. Fabric, Tableau and AWS project details will be added separately.

Build A Portfolio Across Business Domains.

Start Building Your Portfolio

More Than A List Of Tools

Turn What You Learn
Into What You Can Do.

Build a foundation in analysis, then connect reporting, cloud data and automation into a practical workflow.

Understand The Business.

Clean and query data, ask useful questions, and translate patterns into decisions.

Build The Whole Picture.

Connect sources, model data, and create reports people can explore and use.

Make Your Workflow Smarter.

Explore AI agents and automation to collect data, query information and generate insights.

A course for your next move.

Students & graduates

Working professionals

Career switchers

Freelancers

Bring These Skills Into Your Work.

Take The Next Step

Put Your Skills To Work

Build Skills That
Businesses Can Use.

Bring analytical thinking to your job, strengthen your portfolio, or explore services you could offer as a freelancer.

Dashboards & Reporting

Turn business data into clear, interactive views.

Data Cleaning & SQL Analysis

Prepare datasets and answer business questions.

Connected Workflows

Bring data sources together and automate recurring tasks.

AI-Assisted Insights

Explore agents and practical automation for reporting.

Build Skills For Your Next Client Project.

Start Learning

A Community Across Industries

Professionals
We’Ve Trained.

Our participants come from organizations across banking, technology, healthcare, retail and more. Meet the 35 organizations represented in our Data Analyst course brochure.

Organizations Of Our Participants · From The Data Analyst Course Brochure Logo Sources.

Become Part Of Our Learning Community.

Join The Community

From Our Data Analyst Learners

Real People.
Practical Progress.

Explore All Reviews ↗
Muhammad furqan
Muhammad FurqanData Analyst with AI learner
The course was highly informative, well-structured, and directly applicable to practical work scenarios. The instructor demonstrated exceptional knowledge of the subject, explained concepts clearly, and encouraged active participation throughout the sessions. Their engaging teaching…
View Published Reviews ↗
Muhammad Asad Siddiqui
Muhammad Asad SiddiquiData Analyst with AI learner
My honest review will be both the instructor and course literally improved my knowledge for real time. I gained real experience from projects as well as the instructor is very very efficient in delivering his education.
View Published Reviews ↗
Mubeen ejaz
Mubeen EjazData Analyst with AI learner
This data analytics course exceeded my expectations with its well-structured and highly detailed content. Every concept was explained clearly, making even complex topics easy to understand and apply practically. Sir Abbas deserves special appreciation for his exceptional knowledge,…
View Published Reviews ↗
Hamza Ahmed Siddiquie
Hamza Ahmed SiddiquieData Analyst with AI learner
One of the best teachers who connected industry and academics for better recruition, bridging the gap students face to gain jobs not taught in universities. I learnt many formulas, techniques, and industrywide specifics.
View Published Reviews ↗
Ridaa Fatima
Ridaa FatimaData Analyst with AI learner
The Data Analytics course conducted by Sir Mohd Abbas was well-structured, informative, and engaging throughout. The instructor explained concepts clearly and maintained good interaction with students, making the learning environment comfortable and effective. Overall, it was a…
View Published Reviews ↗
Muhammad Yousif
Muhammad YousifData Analyst with AI learner
The Data Analyst course was very informative and well-structured. Sir Abbas explained every topic clearly and made complex concepts easy to understand. I learned many practical skills and had a great learning experience overall. I would definitely recommend this course to others.
View Published Reviews ↗
Muhammad Soman Khan
Muhammad Soman KhanData Analyst with AI learner
The Data Analysis course was very informative and well-structured. The instructor explained complex concepts in a simple and clear way, making learning easy and interesting. The practical examples and hands-on activities helped me understand the topics better. I really appreciated…
View Published Reviews ↗
Umer Bin Abdul Aziz
Umer Bin Abdul AzizData Analyst with AI learner
Sir Abbas is truly a gem, I mean I got my first job based on what he taught. It just not only course, it's professional development. Sir Abbas teaches with his great energy and make the class interesting.
View Published Reviews ↗

Selected published Data Analyst with AI reviews. Original wording and ratings retained.

4th year anniversary celebration ANALYTIX CAMP
4 YEARS OF LEARNING

Four Years of Learning.
A Bigger Reason to Begin.

We’re celebrating our 4th year with 75% off the Data Analyst with AI + AWS + Snowflake course.

75%OFF
COURSE FEE

4 Months. 100+ Hours of Training.
Build Skills Across Analytics, AI and Cloud.

YOUR ANNIVERSARY OFFER

Regular Course Fee Rs. 40,000

Enroll ForRs. 10,000
Valid Until 30 November · 11:59 PM PKT15Days00Hours35Minutes04Seconds
You Save Rs. 30,00075% OFF
Start My Next Chapter
  • 4 Months · 100+ Hours of Training
  • Live Weekend Classes on Microsoft Teams/ Zoom
  • Data Analytics, AI, AWS and Snowflake
  • Core Projects and Extra Connectivity Showcases

Register your interest. Admissions will guide you through enrollment and payment.

May We Help You?

Frequently Asked
Questions.

Select a topic to find the answers you need.

Are the Classes Live?

Yes. the Course follows a live online format, so you can learn with instructors and fellow learners. The enrollment team will share joining instructions before classes begin.

How Long Is the Course?

The Course runs for 4 Months and includes 100+ Hours of Live Training. Classes take place on Saturday and Sunday, 06:30–09:00 PM Pakistan time, via Microsoft Teams.

What Skills Will I Learn?

The course covers Excel, SQL, Power BI, Python, Snowflake, AWS fundamentals, Microsoft Fabric, and AI-assisted workflows with Claude, n8n, and Make.

What Projects Will I Work on?

You will work through business cases across retail, finance, hospitality, and other industries, plus an end-to-end capstone connecting analysis, dashboards, and AI-assisted reporting.

Can I Take the Course While Working Full-time?

Review the class timetable with Admissions before enrolling so you can plan around Live Classes and Project Work.

Will Recordings and a Virtual Internship Be Included?

Please confirm recording access and any virtual internship arrangements with Admissions before enrolling.

Ready To Take The Next Step?

Enroll Now

Your Next Step Starts Here

Register Your Interest.
Let’S Plan Your Next Step.

Interested in Data Analyst with AI + AWS + Snowflake? Share your details and learning goals. Our admissions team will guide you through the course and enrollment options.

✦ 4th Year Anniversary · 75% OFFRs. 40,000Rs. 10,000

After your registration is saved, we’ll open WhatsApp so you can speak with admissions. No payment is collected through this form.

COURSE REGISTRATIONQuick Registration

Your Contact Details

Share your details and we’ll help you complete your registration.

Numbers from any country are welcome. Use the number where you receive WhatsApp messages; +92 is not required.

Your details are used to respond to your registration. No eligibility screening or payment is required to submit.

Location lists: Countries States Cities Database · ODbL
Register in the Course