In this first lesson we learn meaning and importance and benefits of data analysis, processes in data analysis and concepts in data analysis

Introduction to Data Analysis

Data cleaning with MS Excel: Handling errors, outliers, removing duplicates etc

Install MySQL and Setup Local Server Database

Work on cleaning data in Excel as a project

Creating Tables for your Database

Review of data cleaning techniques in Excel and Introduction to SQL.

Wildcards, and Functions in Databases Queries Advanced

Practice Engine that takes you through various lessons in data exploration with SQL

ER Diagrams, Entities and Relations

Assessing your knowledge in data analysis concepts and techniques

Data Analysis Pre-Test

This course provides a comprehensive introduction to the principles and techniques of data analysis. Students will learn essential skills for collecting, cleaning, analyzing, and interpreting data to extract meaningful insights. Through hands-on projects, DIY seesions and live classes, participants will gain proficiency in using tools such as MS Excel, SQL, Tableau for data cleaning, data exploration, data visualization and data storytelling to approach real-world data analysis challenges effectively.

Data Analysis - DBMS

Lesson 5

Assessing your knowledge in data cleaning in Excel

Data Cleaning Project in Excel

Lesson 3

Lesson 7

Marketing data to be used in sql for analysis

{time()}-purchase_history.csv

{time()}-marketing_specific.csv

Marketing data files to be used in sql analysis

{time()}-customer_engagement 2.csv

{time()}-Customer_demo 2.csv

Data file for Data Cleaning Project in Excel

{time()}-online_retail.csv

Second Live-In Session Recording 
https://drive.google.com/file/d/1ySOuUPr9ywzt1aZ9q7ZUZRaQXgNR6DZH/view?usp=sharing

{time()}-Data science - session II.sql

{time()}-Data Science in - ad.png

Recoding of first Session Available Here
https://drive.google.com/file/d/1KaGZHZgCgmkpTPNPi_yfLdxAUT4X9ERt/view?usp=sharing

{time()}-Renee M Teate - SQL for Data Scientists_ A Beginner's Guide for Building Datasets for Analysis-Wiley (2021).pdf

Advanced Techniques for Transforming Data Into Insights

{time()}-Cathy Tanimura - SQL for Data Analysis_ Advanced Techniques for Transforming Data into Insights-O'Reilly Media (2021).pdf

{time()}-Upom Malik, Matt Goldwasser, Benjamin Johnston - SQL for Data Analytics_ Perform fast and efficient data analysis with the power of SQL-Packt Publishing (2019).pdf