Data Analytics Fundamentals
How to turn a messy spreadsheet into an answer someone can act on: the thinking, the cleaning, and the charts. The free first step toward the Data Analytics career track.
- 6 lessons
- about 18 minutes (estimate)
- Free
- Free BvLogic Certificate of Completion
- Video in اردو
- Exercises in اردو
- 17 quiz questions
- 6 exercises
- 1 graded lab
Earn your free BvLogic Certificate of Completion.
A digital credential issued by BvLogic Academy to recognize successful completion of this introductory learning activity.
Not a government qualification or regulatory certification.
That was a one-minute preview. The full course video is for signed-in learners. Sign in to watch it here, or create a free BvLogic ID; it takes a minute, and this course is added to it.
What you'll be able to do
- Understand the analyst's real job, turning questions into answers with data, and where those jobs are in Pakistan.
- Turn vague requests into answerable questions, and choose the right comparison, the move that makes analysis meaningful.
- Find and fix the standard defects in real Pakistani office data, duplicates, inconsistent names, wrong types, missing values, before they poison the analysis.
- Use pivot tables, the core formulas and lookups to answer per-something questions from hundreds of rows in minutes.
- Choose the right chart for the message, and avoid the standard ways charts mislead, including in your own work.
- Present analysis so decisions actually happen, state limits honestly, and leave with a portfolio plan toward analyst roles.
Skills covered
- Data Preparation
- Data Visualisation
- Microsoft Excel
Course content
- 1 What an analyst actually does Understand the analyst's real job, turning questions into answers with data, and where those jobs are in Pakistan.
- 2 The question comes first Turn vague requests into answerable questions, and choose the right comparison, the move that makes analysis meaningful. Sign in to open
- 3 Cleaning: the half of the job nobody advertises Find and fix the standard defects in real Pakistani office data, duplicates, inconsistent names, wrong types, missing values, before they poison the analysis. Sign in to open
- 4 The analyst's toolkit in Excel: pivots, formulas, and the questions they answer Use pivot tables, the core formulas and lookups to answer per-something questions from hundreds of rows in minutes. Sign in to open
- 5 Charts that tell the truth Choose the right chart for the message, and avoid the standard ways charts mislead, including in your own work. Sign in to open
- 6 Delivering findings: and the road into the career Present analysis so decisions actually happen, state limits honestly, and leave with a portfolio plan toward analyst roles. Sign in to open
Course lab
Graded lab · optional practice One question, answered honestly, on one page Open the lab →Data Analytics
Data Analytics
This free course is the introduction to the full Data Analytics programme. The programme is taught by a trainer, marked by the academy, and carries the syllabus in full: the part an employer asks about.
See the full syllabus and feeRelated free courses
- AI AgentsUrdu video
- AI Ethics, Disclosure and SafetyUrdu video
- AI for AccountantsUrdu video
- AI for Clinics and DoctorsUrdu video
- AI for Everyday WorkUrdu video
- AI for TeachersUrdu video
Data Science courses in Pakistan · All free courses · Government free courses open now