Data Analysis 2026 (Batch B)

Data: a representation of information or material recorded and known or assumed as facts and used as a basis of reasoning, discussion or calculation represented especially in the form of numbers

          Formula are users made (it is defined by a user’s without excel instructions) When a user uses any kind of logic to get an answer is called formula. 

We clarified the difference between formulas and functions, highlighting how they're often used interchangeably in everyday usage.

The term ‘Look up’ as used in the context, means to look up (search) from a list.

There are two main LOOKUP functions that can be used within Excel. These are:

HLOOKUP

VLOOKUP

XLOOKUP

An IF statement in Excel is a logical function that tests a condition and returns one value if true and another value if false.

Sorts: Arrange data in a specific order (ascending, descending, alphabetical, etc.) to organize and analyze it.

Filters: Show only specific data that meets certain conditions, hiding the rest. This helps focus on relevant information

Power Query Editor, also known as "Get & Transform" in some versions of Microsoft Excel, is a data analysis tool that allows users to efficiently import, transform, and combine data from various sources.

Pivot tables are a powerful tool for data manipulation.

Data Manipulation with Pivot Tables:

1. Summarize large datasets: Pivot tables help you summarize large datasets by grouping and aggregating data.

2. Analyze data from different angles: Pivot tables enable you to rotate and pivot your data to analyze it from different perspectives.

3. Create custom calculations: Pivot tables allow you to create custom calculations, such as calculated fields and measures.

 BUILDING OF DASHBOARD AND SLICERS

A dashboard is a visual representation of data that's designed to provide an at-a-glance overview of key metrics. A dashboard can include a variety of visualizations, like charts, tables, and graphs. 

It's a great way to get a quick overview of your data and identify areas that need attention. Dashboards are often used in business intelligence and data analytics applications. 

Metrics in a dashboard refer to the quantifiable measures used to track and analyze performance, progress, or trends. These metrics are often displayed in a visual format, such as charts, graphs, or tables, to provide insights and facilitate decision-making.

A dashboard is a visual representation of data that's designed to provide an at-a-glance overview of key metrics. A dashboard can include a variety of visualizations, like charts, tables, and graphs. 

Metrics in a dashboard refer to the quantifiable measures used to track and analyze performance, progress, or trends. These metrics are often displayed in a visual format, such as charts, graphs, or tables, to provide insights and facilitate decision-making

Calculating the correlation between two variables can tell you a lot about the relationship between those variables. If two variables have a strong positive correlation, it means that when one variable increases, the other variable tends to increase as well

A moving average (MA) is a statistical technique used to smooth out short-term fluctuations in a time series data, highlighting longer-term trends and patterns.

A hypothesis test for a sample mean is a statistical procedure used to determine whether a sample mean is significantly different from a known or hypothesized population mean.