excel
data cleaning
data pre-processing
data analysis
statistical analysis
data visualization
- Excel
Spreadsheets
Basics Data Analysis
in Nutshell- Data
Cleaning
&Pre-Processing
- Data Analysis in
Excel
Statistical
Analysis
- Data
Visualization
Manipulation
dataAnalyze
dataVisulize
data- Limited number of users
- Not for
big data
/large datasets
butHadoop
orSpark
can
Tidy
data (Tabular /meaningful
data)- Unique
ID
- Remove
duplicates
Missing
data- Validate data
types
Homogeneity
of data
- Data Manipulation
- Updating, Sorting & Filtering data
- Statistics Functions in Excel
- SUM/AVERAGE/MEDIAN/MODE
- MIN/MAX/RANGE/IQR
- VARIANC/STANDARD DEVIATION
- Z.TEST, T.TEST
- Conditional Functions
- COUNTIF/SUMIF/AVERAGEIF
- VLOOKUP
- PIVOT Table may be a course alone
- Excel workbook is considered as a
book
includes sheets or pages. - Tidy data how to arrange and organize data?
- Clear format
- Remove duplicates
- Unique IDs
- Validate data types
- Dealing with missing data
- Homogeneity of data التناغم
GIGO
Garbage In Grabage Out
Concept So The data to enter analysis phase must be cleaned- analyze data
- Sort data A-Z Or Z-A
- Filter data data tap
- Descriptive statistics
- Variance of population
VARP
- Instructor Mustofa Osman
- course https://www.youtube.com/watch?v=9Z5MPeyuLhg