Data Analysis Private Class

INTRODUCTION TO DATA ANALYSIS

Data analysis refer to the process of inspecting, cleaning and modelling data with the goal of extracting useful information and making informed decisions.

It involves applying statistical and mathematical techniques to uncover patterns, trends, and insight within data set.

1.  EXCEL

Introduction to Excel for Data Analytics:

Overview of Excel’s capabilities for data analysis

Introduction to Excel’s interface: ribbons, worksheets, cells, rows

columns, etc.

Differences between Excel desktop version and Excel Online (web version)

Data Import and Preparation:

 Importing data from various sources: CSV, text files, databases, web queries, etc.

 Data cleaning and manipulation techniques: sorting, filtering, removing duplicates,

fill, split, transpose, table, drop-down list, etc.

 Data types and formatting in Excel

 Data validation and error handling

Data Analysis Techniques in Excel:

Basic formulas and functions: SUM, AVERAGE, COUNT, IF, VLOOKUP, etc.

Advanced functions for data analysis: SUMIFS, COUNTIFS, etc.

PivotTables and Pivot Charts for summarizing and analyzing data

Advanced data analysis tools: Goal Seek, What-If Analysis, etc.

Data Visualization in Excel:

Creating basic charts: column, bar, line, pie, scatter, etc.

Formatting and customizing charts for better visualization

Creating interactive dashboards with slicers and timelines

Advanced Data Analysis Features:

Data modeling with Excel Tables and Relationships

Using Power Query for data transformation and cleaning

Introduction to Power Pivot for data modeling and DAX calculations

Advanced charting techniques: combination charts, waterfall charts, etc.

Statistical Analysis in Excel:

Descriptive statistics: mean, median, mode, standard deviation, etc.

Hypothesis testing: t-tests, ANOVA, etc.

Regression analysis and correlation

Forecasting techniques: moving averages, etc.

Real-world Projects and Case Studies:

Analyzing real-world datasets

Solving business problems with Excel