Scribd
Upload
7 views2 pages

Data Analyst Notes

The document provides an overview of data analysis, detailing its definition, types of data, and the analysis process. It highlights essential tools such as Excel, SQL, and Python, along with basic statistics, data cleaning techniques, and visualization methods. Additionally, it outlines project ideas and required skills for data analysts.

Uploaded by

adorablebinu
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

Data Analyst Notes

The document provides an overview of data analysis, detailing its definition, types of data, and the analysis process. It highlights essential tools such as Excel, SQL, and Python, along with basic statistics, data cleaning techniques, and visualization methods. Additionally, it outlines project ideas and required skills for data analysts.

Uploaded by

adorablebinu
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DATA ANALYST NOTES (Beginner to Advanced)

1. What is Data Analysis?


Data Analysis means converting raw data into useful information.

1 Sales data → find profit


2 Customer data → understand behavior

2. Types of Data

1 Structured Data – Table format (Excel, SQL)


2 Unstructured Data – Text, images, videos

3. Data Analysis Process

1 Data Collection
2 Data Cleaning
3 Data Analysis
4 Data Visualization
5 Decision Making

4. Important Tools

1 Excel – SUM, IF, VLOOKUP, Pivot Tables


2 SQL – SELECT, WHERE, JOIN, GROUP BY
3 Python – pandas, NumPy
4 Power BI / Tableau – Dashboards

5. Basic Statistics

1 Mean = average
2 Median = middle value
3 Mode = most frequent

6. Data Cleaning

1 Remove duplicates
2 Fill missing values
3 Fix errors

7. Data Visualization

1 Bar chart
2 Line chart
3 Pie chart
8. SQL Example
SELECT name FROM students WHERE marks > 50;

9. Python Example
import pandas as pd
data = pd.read_csv('[Link]')
print([Link]())

10. Projects

1 Sales analysis
2 Student data analysis
3 Expense tracker

11. Skills Required

1 Problem solving
2 Logical thinking
3 Basic math
4 Communication

You might also like