Microsoft Excel
Spreadsheets & analysis
Live Online Data Analyst Course
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.
Take The Next Step In Your Data Journey.
Enroll NowPractical Skills. Business Context. Your Own Work.
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.
Build Practical Skills With Guided Learning.
Start Your Learning JourneyThe Skills Behind The Work
From a spreadsheet to a cloud warehouse.
Get familiar with the tools at every stage of the data journey.
Spreadsheets & analysis
Reports & dashboards
Query & explore data
Analysis with code

Connected analytics
Cloud data warehouse
Cloud foundations
AI workflow automation
No-code workflows
AI-assisted analysis
Put These Tools To Work On Business Problems.
Learn These SkillsThe Complete Learning Path
From core analytics to cloud pipelines and AI automation. Review every module, topic and practical application.
Text, aggregation and conditional functions; SUMIFS, IF, SWITCH and FILTER; VLOOKUP, XLOOKUP and INDEX–MATCH; essential data cleaning.
Column, bar, line, pie, donut, histogram, waterfall and combination charts; formatting charts for business presentations.
Data Tables, Goal Seek, Scenario Manager and Solver for comparing assumptions and business outcomes.
Apply spreadsheet analysis and reporting to a consumer-goods business scenario.
Structure source data; create, navigate, refresh and format PivotTables; use grouping and conditional formats.
Percentages, running totals, differences, rankings and calculated fields for analytical reporting.
Practice business analysis and reporting with a textile-company dataset.
Connect, clean, merge and transform data; add columns and load refreshable results into Excel.
Build data models and DAX calculations; analyze business metrics, add targets and apply conditional formatting.
Create interactive Excel dashboards, dynamic PivotTable reports and the 365 Coffee Cafe analysis.
Databases, data lakes, warehouses and data marts; SQL Server, MySQL and PostgreSQL; query tools and basic SQL syntax.
SELECT, FROM, WHERE and ORDER BY; aliases, GROUP BY, TOP N, DISTINCT and OFFSET FETCH.
Numeric, string and date-time functions; counting rows, comparisons, logical operators, IIF, CASE and NULL handling.
Relationships and ER diagrams; INNER, OUTER, LEFT, RIGHT and CROSS joins; UNION, views, self joins and natural joins.
Scalar, multi-row and correlated subqueries; derived tables and common table expressions (CTEs).
ROW_NUMBER, RANK, DENSE_RANK, LAG and LEAD; partitioning results and troubleshooting analytical queries.
Remove duplicates, handle missing values, split and standardize columns, and prepare datasets for analysis.
World Life Expectancy, 365 Super Mart, financial-statement analysis with Power BI, and 365 Technologies.
Installation, configuration, interface, workflow and core settings.
Data connectors, table profiling, text/number/date transformations, conditional columns, grouping, aggregation, merge, append and parameters.
Normalization, fact and dimension tables, active/inactive relationships, cardinality, star and snowflake schemas, evaluation order, expanded tables and context transition.
Text, date, logical and conditional functions, including SWITCH for dynamic calculations.
Implicit and explicit measures; filter context; math, statistics, counting, filtering and iterator functions; variables, time intelligence, CALCULATE, ALL and FILTER.
Advanced charts, filtering, slicing, drilling, numeric/field parameters, navigation and tooltips; anomaly detection, smart narratives, Q&A, decomposition trees and key influencers.
365 Super Market, Granny’s Cafe, Media Feathers, redesigned Media Feathers and Retail Inc.; explore the larger cohort project collection below.
Power BI Projects 11–20 demonstrate web, cloud, database and file connections, plus sales-data modeling.
Python applications, Anaconda, Jupyter Notebook, notebook comments and the development environment.
Numbers, strings, lists, dictionaries, tuples, sets and booleans; string methods, concatenation and formatting.
Operators, if/else, for and while loops, break, continue, pass, list comprehensions, IN and NOT IN.
Built-in and user-defined functions, arguments, keyword arguments, lambda, map, filter and exceptions.
Array creation, slicing, indexing, arithmetic, mathematical functions and input/output operations.
Series and DataFrames; selection, aggregation, grouping, cleaning and combining data; Excel, CSV, HTML and database input/output.
Bar, line, scatter, histogram and box plots; selecting appropriate charts and improving their presentation.
Categorical, relational, distribution, regression and matrix plots; multi-plot grids and visual styling.
Installation, interface, first charts, color, formatting and filters.
Time series and categorical aggregation; calculated fields, table calculations and interactive parameters.
Build and format dashboards; add filters and highlighting; share an interactive analytical story.
Connect multiple datasets and combine sources for analysis.
Create hierarchies, geographical maps and visuals that communicate business findings.
Histograms, box-and-whisker plots, area and dual-combination charts, Gantt charts, treemaps and packed bubbles.
Data Interpreter, pivots, splitting and combining columns, the Analytics tab, clustering and forecasting.
Combine Tableau techniques in a business-performance dashboard.
Understand the platform, storage options, data transformations and enterprise analytics use cases.
Explore Fabric through the Power BI interface, its architectural framework and approaches to handling enterprise data.
Define the challenge and plan a pilot for the 365 Enterprises scenario.
Integrate external sources, transition existing BI content, publish reporting and automate refreshes with pipelines.
Apply Fabric to supply-chain operations and business reporting.
Classification and regression; supervised and unsupervised learning; key algorithms and analyst tools.
Requirements, scope, collection, preparation, feature engineering, model selection, training, evaluation, tuning, deployment and MLOps.
Interpret accuracy, precision, recall and F1 score when assessing model performance.
Data infrastructure, collection, storage and transformation; privacy, ethics and governance.
Use AI to support collection, cleaning, transformation, insight generation and visualization.
Use AI to improve analytical explanations, emails and presentations while retaining human judgment.
Resume customization, professional networking and AI-assisted technical, case-study and behavioral interview practice.
Course outcomes, prerequisites, learning routines and the practical workflow for analysts moving into cloud data.
OLAP versus OLTP; Data Engineer, Data Analyst and AI Engineer roles; data lakes, warehouses and lakehouses; ETL versus ELT.
Bronze, silver and gold layers; CSV/JSON versus columnar Parquet and their use cases.
Cloud accounts, S3 storage, IAM roles and policies, Snowflake trial setup, integration objects, trust relationships and external stages.
Create a repeatable flow from raw files into S3 and Snowflake, then validate the loaded data.
Explore and transform data with Snowflake SQL; connect Power BI through Import/DirectQuery and connect Tableau.
Build reporting for rainfall, monthly usage and cost savings; complete an S3 → Snowflake → BI workflow with a repeatable delivery checklist.
Use Claude to support the analytical tasks introduced in the course, with review of generated queries and explanations.
Practice the web-data collection and Google Sheets scenario in the cohort project collection.
Explore the Gmail data-extraction automation scenario.
Build and examine an agent workflow for working with SQL queries.
Apply the n8n Insight Generator and Data Governance With AI Agents project scenarios.
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
Who’s Your Instructor?
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.
Senior Data Specialist

Business intelligence & valuation
Practical training for data professionals
Learn With Muhammad Abbas.
Learn With Your InstructorYour Work. Your Portfolio.
34 core scenarios across different industries.
Explore the businesses you’ll learn with.
Project 01
Project 02
Project 03
Project 04
Project 05
Project 11
Project 12
Project 13
Project 14
Project 17
Project 18
Project 19
Project 22
Project 23Logos 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 PortfolioMore Than A List Of Tools
Build a foundation in analysis, then connect reporting, cloud data and automation into a practical workflow.
Clean and query data, ask useful questions, and translate patterns into decisions.
Connect sources, model data, and create reports people can explore and use.
Explore AI agents and automation to collect data, query information and generate insights.
Students & graduates
Working professionals
Career switchers
Freelancers
Bring These Skills Into Your Work.
Take The Next StepPut Your Skills To Work
Bring analytical thinking to your job, strengthen your portfolio, or explore services you could offer as a freelancer.
Turn business data into clear, interactive views.
Prepare datasets and answer business questions.
Bring data sources together and automate recurring tasks.
Explore agents and practical automation for reporting.
Build Skills For Your Next Client Project.
Start LearningA Community Across Industries
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 CommunityFrom Our Data Analyst Learners

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…
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 style and real-world examples significantly enhanced the learning experience and overall understandingView Published Reviews ↗

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 ↗

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,…
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, professional teaching style, and engaging presentation skills. His ability to simplify difficult analytical concepts and explain real-world applications made the learning experience both valuable and enjoyable. The course provided strong practical insights, hands-on learning, and clear guidance throughout. I highly recommend this course to anyone interested in building a solid foundation in data analytics and improving their analytical and technical skills effectively.View Published Reviews ↗

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 ↗

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…
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 valuable course that enhanced both theoretical understanding and practical knowledge of data analytics.View Published Reviews ↗

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 ↗

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…
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 the instructor’s support, teaching style, and dedication throughout the course. Overall, it was a valuable learning experience that improved my analytical skills and knowledge.View Published Reviews ↗

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.
ANALYTIX CAMPWe’re celebrating our 4th year with 75% off the Data Analyst with AI + AWS + Snowflake course.
4 Months. 100+ Hours of Training.
Build Skills Across Analytics, AI and Cloud.
Regular Course Fee Rs. 40,000
Register your interest. Admissions will guide you through enrollment and payment.
May We Help You?
Select a topic to find the answers you need.
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.
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.
The course covers Excel, SQL, Power BI, Python, Snowflake, AWS fundamentals, Microsoft Fabric, and AI-assisted workflows with Claude, n8n, and Make.
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.
Review the class timetable with Admissions before enrolling so you can plan around Live Classes and Project Work.
Please confirm recording access and any virtual internship arrangements with Admissions before enrolling.
The Course begins with Excel and analytical foundations before progressing to SQL, Python, Cloud Platforms, and AI. Share your background with Admissions if you would like help deciding whether the Course fits your goals.
The course is designed for students and graduates, working professionals, career switchers, and freelancers who want practical data analytics skills.
The learning journey starts with the fundamentals. If you already use Excel or reporting tools, share that experience with Admissions.
Ask Admissions to confirm the Course Certificate and completion requirements before enrolling.
AWS and Snowflake are included as learning topics. An external certification exam or exam voucher has not been included in the Course offer; confirm any separate exam arrangements with the team.
The Anniversary Course Fee is Rs. 10,000 after a 75% discount on the regular Rs. 40,000 fee. The offer is valid through 30 November 2026, 11:59 PM Pakistan time. Contact Admissions for payment and enrollment details.
The Anniversary Fee is Rs. 10,000. Contact Admissions for the available payment methods and enrollment steps.
No. The form starts an enrollment enquiry and does not collect payment. The team will contact you about availability and payment steps before confirming your seat.
The course focuses on practical skills and portfolio projects. It does not promise or guarantee employment.
Ask Admissions to confirm the career-support services included with the Course, such as Resume Reviews, Interview Preparation, and Portfolio Guidance.
Submit the application with your email and WhatsApp number. The enrollment team can help you confirm the course fit, timetable, and next steps.
Ready To Take The Next Step?
Enroll NowYour Next Step Starts Here
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.
Thank you for your interest in Data Analyst with AI + AWS + Snowflake. Continue to WhatsApp to speak with admissions.
Follow along for lessons, ideas and the next chapter of your learning journey.
Let’s Talk