Data Analysis

Program Overview

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

Contact us for more details

Download our brochure to discover our course offerings and details

× Live Chat With Us