Data Analyst (Batch-07) Certification Program – Zero to Hero in Excel, SQL, Power BI, Tableau and Python

About Course

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.

The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.

Some responsibilities of a data analyst includes:

Developing records management processes and policies
identify areas to increase efficiency and automation of processes
set up and maintain automated data processes
identify, evaluate and implement external services and tools to support data validation and cleansing
produce and track key performance indicators
develop and support reporting processes
monitor and audit data quality
liaise with internal and external clients to fully understand data content
gather, understand and document detailed business requirements using appropriate tools and techniques
design and carry out surveys and analyse survey data
manipulate, analyse and interpret complex data sets relating to the employer’s business
prepare reports for internal and external audiences using business analytics reporting tools
create data dashboards, graphs and visualisations
provide sector and competitor benchmarking
mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool

In this course we will perform some task of a Data Analyst using Python ,Excel, Tableau, SQL, and Power BI. We will connect to a variety of data sources, perform data transformation ,cleaning and exploration . We will create dashboards to visual data

Course Content

Class 01 – Introduction of Excel | Overview of Interface | Text Functions | Navigation and Shortcuts | Aggregation Functions (SUM, MAX, MIN, COUNT, AVERAGE) | Basic Formulas | Lookup Functions (VLOOKUP, XLOOKUP, INDEX & MATCH)

Data Analyst (Batch-07) – Session 01

01:50:39

Class 02 – Data Types | Custom Formats | Freeze Panels | Groupings | Formatting the Data | Duplicate and Removal | CONCETENATE Function | Go to Special | Flash Fill | SUBSTITUTE Function | Trim and Text to Columns

Class 03 – Working with Large Data Sets: Single/Multi-Column Sorting | Filter Options | Custom Filters | Text Functions (LEFT, RIGHT, LEN) | Data Cleaning | Activity Performance

Class 04 – Data Validation and Conditional Formatting

Class 5: IF Statements and Logical Functions IF, AND, OR, NOT, Nested Ifs, Conditional Summing and Counting SUMIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS, Lookup Functions VLOOKUP, Ranking and Rounding RANK, ROUND, SUMPRODUCT and Text Functions TEXTJOIN

Class 06 – Introduction of Pivot Table | Basic and Advanced Analysis using Pivot Tables

Class 07 – Data Analysis with Advanced Pivot Table and Calculated Fields

Class 08 – Data Visualization with Excel Charts (Column, Bar, Line, Area, Histogram, Pareto, Pie, Donut, Heatmap, Pareto)

Class 09 – Data Visualization with Excel Charts (Waterfall, Funnel, Binary) | Dynamic Excel Charts | Charts with Drop Downs

Class 10 – Modern Design Interactive Excel Dashboard (Part 01)

Class 11 – Modern Design Interactive Excel Dashboard (Part 02)

Class 12 – End your journey MS Excel with the Visualization Masterclass, Exploring Creative Design techniques | Final Project Discussion: Insights, Planning

Class 13 – Introduction to Power BI | Introduction to Ribbons | Exploring Data Sources | Power Query Overview

Class 14 – ETL (Extraction, Transform, Load) | Data Cleaning with Power Query: Advanced Techniques and Best Practices

Class 15 – Power Query | Conditional Columns | Columns for Examples | Data Tools | Subtract Days | Group By | Advanced Filtering & Sorting

Class 16 – Power Query | Parameter | Append Queries | Select from Folder | Data Normalization Concept | Data Modeling

Class 17 | Data Modeling: Star & Snowflake Schema | Data Formatting | DAX Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT, &)

Class 18 – Presentation: Excel Interactive Dashboard and Reporting

Class 19 | Date Functions: DAY, MONTH, YEAR, DATEDIFF, TODAY, WEEKDAY, WEEKNUM | Text Functions: SUBSTITUTE, FIND, SEARCH, Dynamic RIGHT & LEFT | Logical Operators and Functions

Class 20 – Logical Functions: Nested IF, SWITCH (with TRUE), AND, OR | Dynamic Formula Applications

Class 21 – Measures: Implicit vs Explicit | Filter Context | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Class 22 – Filter Flow Concepts: Examples of Calculated Functions and Multi-Dimensional Analysis

Class 23 – Advanced Calculated Functions: ALL Conditions, Variables, and Practical Examples

Class 24 – Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Introduction to Iterator Functions

Class 25 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions (DATEADD, Previous Month, Previous Year, DATESYTD, DATESMTD, DATESQTD & DATESINPERIOD)

Class 26 – Handling Errors | Data Visualizations (Navigation Bar, Images, Cards and Visual Formatting)

Class 27 – Data Visualizations (Line Chart, Forecasting, Reference line, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting, Report Level Filters , TOPN Filters

Class 28 – Data Visualization (Donut Chart , Pie Chart, Visual Pages, Card Visuals | Slicers | Area Chart and Others | Gauge Charts | Area Chart)

Class 29 | Data Visualization (Advanced Line Chart) | Darling (up, Down Through) Bookmarks | Page Navigation | Customer Tooltips Conational Formatting

Class 30 | Introduction of SQL & Database | Clauses (Select, From, Where, Group By Statements) | TOP N | TOP N PERCENT Keywords

About Course

Course Content

Class 01 – Introduction of Excel | Overview of Interface | Text Functions | Navigation and Shortcuts | Aggregation Functions (SUM, MAX, MIN, COUNT, AVERAGE) | Basic Formulas | Lookup Functions (VLOOKUP, XLOOKUP, INDEX & MATCH)

Data Analyst (Batch-07) – Session 01

Class 02 – Data Types | Custom Formats | Freeze Panels | Groupings | Formatting the Data | Duplicate and Removal | CONCETENATE Function | Go to Special | Flash Fill | SUBSTITUTE Function | Trim and Text to Columns

Data Analyst (Batch-07) – Session 02

Class 03 – Working with Large Data Sets: Single/Multi-Column Sorting | Filter Options | Custom Filters | Text Functions (LEFT, RIGHT, LEN) | Data Cleaning | Activity Performance

Data Analyst (Batch-07) – Session 03

Class 04 – Data Validation and Conditional Formatting

Data Analyst (Batch-07) – Session 04

Class 5: IF Statements and Logical Functions IF, AND, OR, NOT, Nested Ifs, Conditional Summing and Counting SUMIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS, Lookup Functions VLOOKUP, Ranking and Rounding RANK, ROUND, SUMPRODUCT and Text Functions TEXTJOIN

Data Analyst (Batch-07) – Session 05

Class 06 – Introduction of Pivot Table | Basic and Advanced Analysis using Pivot Tables

Data Analyst (Batch-07) – Session 06

Class 07 – Data Analysis with Advanced Pivot Table and Calculated Fields

Data Analyst (Batch-07) – Session 07

Class 08 – Data Visualization with Excel Charts (Column, Bar, Line, Area, Histogram, Pareto, Pie, Donut, Heatmap, Pareto)

Data Analyst (Batch-07) – Session 08

Class 09 – Data Visualization with Excel Charts (Waterfall, Funnel, Binary) | Dynamic Excel Charts | Charts with Drop Downs

Data Analyst (Batch-07) – Session 09

Class 10 – Modern Design Interactive Excel Dashboard (Part 01)

Data Analyst (Batch-07) – Session 10

Class 11 – Modern Design Interactive Excel Dashboard (Part 02)

Data Analyst (Batch-07) – Session 11

Class 12 – End your journey MS Excel with the Visualization Masterclass, Exploring Creative Design techniques | Final Project Discussion: Insights, Planning

Data Analyst (Batch-07) – Session 12

Class 13 – Introduction to Power BI | Introduction to Ribbons | Exploring Data Sources | Power Query Overview

Data Analyst (Batch-07) – Session 13

Class 14 – ETL (Extraction, Transform, Load) | Data Cleaning with Power Query: Advanced Techniques and Best Practices

Data Analyst (Batch-07) – Session 14

Class 15 – Power Query | Conditional Columns | Columns for Examples | Data Tools | Subtract Days | Group By | Advanced Filtering & Sorting

Data Analyst (Batch-07) – Session 15

Class 16 – Power Query | Parameter | Append Queries | Select from Folder | Data Normalization Concept | Data Modeling

Data Analyst (Batch-07) – Session 16

Class 17 | Data Modeling: Star & Snowflake Schema | Data Formatting | DAX Calculated Columns | Text Functions (LEFT, RIGHT, UPPER, LOWER, CONCAT, &)

Data Analyst (Batch-07) – Session 17

Class 18 – Presentation: Excel Interactive Dashboard and Reporting

Data Analyst (Batch-07) – Session 18

Class 19 | Date Functions: DAY, MONTH, YEAR, DATEDIFF, TODAY, WEEKDAY, WEEKNUM | Text Functions: SUBSTITUTE, FIND, SEARCH, Dynamic RIGHT & LEFT | Logical Operators and Functions

Data Analyst (Batch-07) – Session 19

Class 20 – Logical Functions: Nested IF, SWITCH (with TRUE), AND, OR | Dynamic Formula Applications

Data Analyst (Batch-06) – Session 20

Class 21 – Measures: Implicit vs Explicit | Filter Context | Aggregation Functions (SUM, COUNT, COUNTROWS, AVERAGE, DISTINCTCOUNT, DIVIDE, MAX, MIN)

Data Analyst (Batch-07) – Session 21

Class 22 – Filter Flow Concepts: Examples of Calculated Functions and Multi-Dimensional Analysis

Data Analyst (Batch-07) – Session 22

Class 23 – Advanced Calculated Functions: ALL Conditions, Variables, and Practical Examples

Data Analyst (Batch-07) – Session 23

Class 24 – Filter Functions with Explicit Measures | Merging Measures into a Single Calculated Measure | Introduction to Iterator Functions

Data Analyst (Batch-07) – Session 24

Class 25 – Iterator Functions (SUMX, AVERAGEX, MINX, MAXX) | Time Intelligence Functions (DATEADD, Previous Month, Previous Year, DATESYTD, DATESMTD, DATESQTD & DATESINPERIOD)

Data Analyst (Batch-07) – Session 25

Class 26 – Handling Errors | Data Visualizations (Navigation Bar, Images, Cards and Visual Formatting)

Data Analyst (Batch-07) – Session 26

Class 27 – Data Visualizations (Line Chart, Forecasting, Reference line, Bar Chart, KPI Chart, Table and Metrix Visual & Formatting, Report Level Filters , TOPN Filters

Data Analyst (Batch-07) – Session 27

Class 28 – Data Visualization (Donut Chart , Pie Chart, Visual Pages, Card Visuals | Slicers | Area Chart and Others | Gauge Charts | Area Chart)

Data Analyst (Batch-07) – Session 28

Class 29 | Data Visualization (Advanced Line Chart) | Darling (up, Down Through) Bookmarks | Page Navigation | Customer Tooltips Conational Formatting

Data Analyst (Batch-07) – Session 29

Class 30 | Introduction of SQL & Database | Clauses (Select, From, Where, Group By Statements) | TOP N | TOP N PERCENT Keywords

Data Analyst (Batch-07) – Session 30