Skip to main content

Cracking the Code: A Comprehensive Data Analysis Journey

Image
on

 The data analysis process

1- Prepare the data

2- Model

3- Analyze

- Descriptive Analysis: Describe what the data looks like in its basic form.

- Exploratory Analysis: Dig deeper to try and find interesting patterns or relationships between different parts of the data.

- Inferential Analysis: Use available data to make guesses or predictons about things outside the data.

- Predictive Analysis: Use statistics to predict what might happen in the future based on what's happened in the past.

4- Visualize

5- Manage


Gathering the right data

1- Identify the Analysis Purpose

for example: Drive product development

2- Type of Data

for example: Market trends data

                               Competitor data

                               Sales Data

3- Scope of Data

For example: Dates: last 5 years

                               Products: Mountain and road bikes

                               Regions: Europe


Processing and Analzing the data 

Define Analysis Purpose

Data collection ; "Raw data" For example: Sales

                                 Customer

                                 Manufacturing

                                                                                                                       Purchasing

                                                                                                         Inventory

                                                                                                         Marketing

Data Processing

Data exploration and analysis

Data reporting


Example issues of raw data

1- Duplicate entries

2- Missing values

3- Different format

4- Multiple sources

We can fix these issues with ETL Process:

Extract

Transform

Load



Labels:

Comments

Post a Comment

Popular posts from this blog

Stored Procedure in SQL

on
 What is a stored procedure?    -> A set of of SQL statements stored and executed on the database server. Benefits of stored procedures : 1- Reduction in network traffic 2- Improvement in performance 3- Reuse of code 4- Increase in security How to work with stored procedures: Call from: a) Dynamic SQL statements b) External applications For example: CALL UPDATE_SAL("E1001", 1)
Post a Comment
Read more »

Excel functions that you ACTUALLY need

on
 Text Functions   LEFT,RIGHT AND MID: These functions help extract specific parts of text from a cell . For instance, if you have a dataset with full names in a single column, you can use these functions to separate first and last names into different columns. TRIM: This function removes extra spaces from a text string. UPPER,LOWER AND PROPER: These functions convert text to uppercase, lowercase, or proper case(proper case being where the first letter is capitalized, and the rest are in lowercase). This can be helpful when dealing with data that has inconsistent capitalization. Lookup Functions Lookup functions help you find and retrieve data from other parts of the worksheet or other worksheets based on specific criteria.  VLOOKUP AND HLOOKUP: These functions search for a value in the first column or row of a table and return a corresponding value from another column or row. They're useful for merging data from multiple sources or filling in missing data. INDEX AND MAT...
Post a Comment
Read more »