Data Analysis

About the Program

Unlock the power of data with our comprehensive Data Analysis Course at LeadTecno. Designed for beginners and professionals alike, this course equips you with essential analytical skills using industry-standard tools. You’ll learn data analysis using MS-Excel, gain insights through data visualization with Power BI and Tableau, and build a strong foundation in SQL, Python, and R Programming. Whether you aim to enhance your decision-making skills or step into a data-driven career, this course provides hands-on training to turn raw data into meaningful insights.

Data Analysis using MS-Excel

Duration – 9 Hours (Each day is 3 Hours)

Module 1: Excel Basics
Module 2: Working with Cells and Sheets
Module 3: Formulas and Functions
Module 4: Working with Data
Module 5: Data Visualisation Tools
Module 6: Advance Functions in Excel
Module 7: Reporting Tools
Module 8: Capstone Project

Introduction to Data Visualisation using MS-Power BI

Duration – 9 Hours (Each day is 3 Hours)

Module 1: Creating Excel Dashboards using multiple data sources
Module 2:Introduction to Data Literacy Module
Module 3: Get started with Microsoft data analytics
Module 4: Prepare data for Analysis
Module 5: Model data with Power BI
Module 6: Build Power BI visuals and reports
Case Study 1 - GSS Dataset
Case Study 2 - Printer Sales Data
Capstone Project

Introduction to Data Visualisation using Tableau

Duration – 6 Hours (Each day is 3 Hours)

Module 1: Connect to and Customize Data
Module 2: Organize Data and Create Filters
Module 3: Build Common Views
Module 4: Map Geographic Data
Module 5: Create Calculated Fields
Module 6: Apply Table Calculations
Module 7: Apply Analytics
Module 8: Work with Multiple Data Sources
Module 9: Create Dashboards and Stories
Module 10: Share and Publish Content
Capstone Project

Introduction to SQL

Duration – 6 Hours (Each day is 3 Hours)

Module 1: Introduction to Transact-SQL
Module 2: Sort and filter results in T-SQL
Module 3: Combine multiple tables with JOINs in T-SQL
Module 4: Use built-in functions and GROUP BY in Transact-SQL
Module 5: Write Subqueries in T-SQL
Module 6: Use built-in functions and GROUP BY in Transact-SQL
Module 7: Modify data with T-SQL

Introduction to Python

Duration – 9 Hours (Each day is 3 Hours)

Module 1: Set up of Python Environment
Module 2: Data Structures in Python
Module 3: Conditional Statements and Loops
Module 4: Strings in Python - Handling Strings and Files in Python
Module 5: Regex Expressions in Python
Module 6: Introduction to NUMPY Library
Module 7: Introduction to PANDAS Library
Capstone Project

Introduction to R Programming

Duration – 9 Hours (Each day is 3 Hours)

Module 1: Set up of R and R Studio Environment
Module 2: Data Structures in R
Module 3: Conditional Statements and Loops
Module 4: Strings in Python - Handling Strings and Files in R
Module 5: Regex Expressions in R
Module 6: Introduction to DPLYR Library
Module 7: Introduction to DPLYR Library
Module 8: Introduction to TIDYR Library
Capstone Project

Other Courses

View All Courses >

ServiceNow IT- Business Analyst

Use ServiceNow to design workflows and manage IT systems as a business analyst.

Cyber Security

Learn security fundamentals and start a career in SOC, risk, and compliance.

AWS Cloud Engineer

Deploy, secure, and automate on AWS with live instructor support.

Frequently Asked Questions

Before you dive in, let’s clear up the things you’re probably wondering about.

Yes! Every student who completes their program will receive a professional certificate, perfect for your resume, portfolio, or LinkedIn.

Life happens — we get it. That’s why every session is recorded and uploaded so you can catch up at your own pace.

Once enrolled, you’ll have lifetime access to course content, resources, and future updates — no extra cost.

Definitely. Our career support includes resume help, mock interviews, portfolio reviews, and job placement guidance.

Yes! You can book a free 15-minute career call with one of our advisors. We’ll help you find the path that fits you best.

IT Staffing

IT Career Mentoring

IT Consulting

Data Science

Azure Cloud Data Engineering

AWS Cloud Engineer

Cybersecurity

ServiceNow – Business Analyst

Data Analyst

Data Analysis

About the Program

Data Analysis using MS-Excel

Introduction to Data Visualisation using MS-Power BI

Introduction to Data Visualisation using Tableau

Introduction to SQL

Introduction to Python

Introduction to R Programming

Other Courses

ServiceNow IT- Business Analyst

Cyber Security

AWS Cloud Engineer

What Our Student's Says

Frequently Asked Questions

Ready to Upskill or Hire Talent?

Have Questions? Let’s Chat!

Get in touch with us

Quick Links

Courses

Let’s Connect!