Next Batch: July 1, 2026Level: Beginner to Advanced

Data Analytics: Zero to Remote Job

Name: Data Analytics: Zero to Remote Job
Price: 1000 PKR
Availability: InStock

Become a job-ready data professional in 3 months. Master Advanced Microsoft Excel, SQL Databases, Power BI Reports, and Python Basics. Built specifically for students and professionals in Pakistan wanting remote work or local upskilling.

4.9/5(120+ students)

200+graduates

Enroll in Course — PKR 1,000/mo Ask a Question on WhatsApp

Course Highlights

Duration:3 Months (12 Weeks)

Classes:3 sessions / week

Instruction:Urdu & English (Bilingual)

Platform:Google Meet / Zoom

Certificate:Yes (Govt Verified)

Monthly Fee:PKR 1,000

What You Will Be Able to Do

By the end of these 12 weeks, you will have the technical skills to handle senior-level data reporting tasks independently.

Write clean, complex Excel formulas (VLOOKUP, XLOOKUP, INDEX-MATCH) to clean dirty company datasets.

Build interactive executive dashboards in Microsoft Excel using pivot charts, tables, and slicers.

Write optimized SQL database queries to extract, filter, and group data from multiple tables.

Create relational databases using tables, primary keys, and foreign keys.

Design automated interactive business reports in Power BI from raw files and SQL queries.

Write custom DAX measures (Data Analysis Expressions) for complex business metrics.

Use Python Pandas & NumPy libraries to automate manual Excel reporting steps.

Build a professional portfolio of 4 real-world data projects to show to prospective hiring managers.

Toolbox

Industry-Standard Tools You Will Master

We do not just teach theory. You will get hands-on experience using the exact same software stack that global analytics teams rely on daily.

Data Wrangling

Microsoft Excel

Used by 99% of businesses worldwide. You will master formulas, pivot tables, lookup methods, conditional styling, and layout planning.

Data Querying

SQL Databases

The standard language for databases. You will write queries to join tables, aggregate metrics, group findings, and structure schemas.

Data Visualization

Microsoft Power BI

Build complex, automated, and interactive sales, inventory, and customer dashboard portals that auto-refresh from SQL data.

Automation Scripts

Python Programming

Understand the power of code. Write Python scripts using Pandas, NumPy, and Matplotlib libraries to automate daily reporting workflows.

Weekly Breakdown

Curriculum Details

Explore the step-by-step 12-week roadmap. Every week contains 3 live lectures, hands-on code-alongs, and practical homework assignments.

• Introduction to the Excel Interface & cell formatting • Math operators, SUM, AVERAGE, COUNT, and percentage calculations • Logical formulas: IF, AND, OR, and Nested IF statements • Lookup formulas: VLOOKUP, HLOOKUP, and XLOOKUP in depth • Cleaning raw data: Text-to-Columns, removing duplicates, trimming spaces, handling blank cells • Project 1: Cleaning and preparing a messy retail sales spreadsheet

• Pivot Tables & Pivot Charts from scratch • Creating interactive slicers and timelines for executives • Data validation drop-downs and conditional formatting rules • Introduction to basic Excel Macros and automation shortcuts • Project 2: Building a functional HR employee attendance & salary dashboard

• Relational databases concepts: Tables, rows, columns, and data types • SELECT, DISTINCT, WHERE clauses, and logical filters • Ordering and limiting query results (ORDER BY, LIMIT) • SQL Aggregations: SUM, COUNT, AVG, MIN, MAX, and GROUP BY • Connecting tables: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN • Project 3: Querying an e-commerce database to find top-selling products

• Filtering grouped data using HAVING • Writing nested queries (Subqueries) and temporary tables • Using CTEs (Common Table Expressions) for cleaner query files • Basics of Window Functions (ROW_NUMBER, RANK, DENSE_RANK) • Project 4: Generating monthly sales retention reports using CTEs

• Installing Power BI Desktop & connecting to Excel/SQL sources • Power Query Editor: cleaning, transforming, and merging tables • Understanding Star Schema, dimensions, facts, and relationships • Designing standard report pages, layouts, and page navigation • Using standard cards, line charts, bar charts, maps, and matrices

• Calculated columns vs. DAX measures • Writing basic DAX: CALCULATE, SUM, DIVIDE, RELATED • Time Intelligence DAX functions (YTD, MTD, Same Period Last Year) • Project 5: Developing an interactive sales dashboard and publishing reports

• Python setup: Jupyter Notebooks & basic syntax • Variables, lists, loops, and custom functions • Introduction to Pandas Library: loading CSVs and inspecting DataFrames • Filtering, grouping, and calculating averages with Pandas • Basic visualizations using Matplotlib and Seaborn libraries • Project 6: Automating a monthly Excel PDF report compile with Python

• Selecting a real-world database (e.g. Sales, Finance, or Call Center) • Performing complete ETL (Extract, Clean, Load, Model, Visualize) • Building a multi-page Power BI dashboard • CV building tips: how to list data analytics skills and projects • Freelancing setup: how to write proposals on Upwork/Fiverr

Cohort Details

Class Schedule & Logistical Info

Everything you need to plan your study schedule. Live attendance is encouraged but not mandatory.

Class Days

Monday, Wednesday, Friday

3 sessions per week, scheduled to fit after office and university hours.

Class Timing

8:00 PM - 9:30 PM (PKT)

Pakistan Standard Time. Interactive 90-minute lectures including Q&A.

Platform & Recordings

Google Meet & Zoom

Attend live classes. Recorded sessions are uploaded to the portal within 2 hours.

Class Size

Max 30 Students

Limited cohort size to ensure every student gets direct attention from the mentor.

Cohort Reviews

What Our Alumni Say

Detailed reviews from students who completed the data analytics bootcamps and upskilled their career profile.

Average Rating

4.9

Based on 124 verified student reviews

5 star

92%

4 star

3 star

2 star

1 star

Muhammad HarisVerified Student

Rawalpindi • May 12, 2026

"This is the best course I have taken. The instructor Engr. Hamza explains everything step-by-step. I learned SQL queries from scratch. The lessons are in Urdu which made it extremely easy to understand query logic. Already earned $200 on Fiverr doing simple dashboard adjustments."

Kanza FatimaVerified Student

Lahore • April 28, 2026

"As a non-tech graduate, I was scared of coding. But starting with Excel formulas and pivot tables built my confidence. The Power BI lessons were the highlight of the course. Creating interactive charts feels like magic!"

Bilal KhanVerified Student

Karachi • March 15, 2026

"Very practical course. We built dashboards using real sales databases. The schedule was convenient for me since I work during the day. WhatsApp support was quick whenever I got stuck on SQL joins."

Coming Soon

Advanced Bootcamps (Under Preparation)

Interested in Machine Learning, Business Intelligence, or Tableau? Join our newsletter/WhatsApp lists to get notified when we open registrations.

Notify Me on WhatsApp

Monthly TuitionPKR 1,000

Enroll Now