Next LIVE 2 Day Classroom Training Starts In:

Days

:

Hours

:

Minutes

:

Seconds

The countdown is over!

For Students, Executives, Managers from all Verticals, Entrepreneurs & Career Transitioners

India's Leading Professional Career & Business Coach

How To Become A Data Analyst

Data Analysis and Visualization Using MS Excel and Google Sheet

CLICK TO REGISTER - 100 SEATS

Click on the link above and register if you are keen to becoming the next 100 future Data Analysts and cut your path to a high paying salary in half

Date: 25th August & 1st September 2023

Time: 09:45 AM to to 05.15 PM

15 Hours

Venue : Madras Management Association - Chennai

Class Room Session

Dedicated Q&A Session

Brief Overview

This training program offers a practical and hands-on approach to data analysis and visualization using MS Excel and Google Sheets. Over the course of two days, participants will develop proficiency in these powerful spreadsheet tools, gaining essential skills to clean, prepare, and analyse data. They will learn various techniques for exploratory data analysis and master the art of visualizing data through charts and graphs. The training covers advanced functions, statistical analysis, and dashboard creation, empowering participants to extract valuable insights and make informed decisions. With a real-world case study and emphasis on report out, participants will enhance their data analysis capabilities and effective communication skills.

What's inside this workshop?

Introduction to Data Analysis and Spreadsheet Basics

Data Cleaning & Preparation Techniques

Exploratory Data Analysis (EDA)

Data Visualization with MS Excel / GS

Advanced Data Analysis with MS Excel / GS

Case Study Introduction and Analysis

Report Out of the Case Study

Statistical Analysis with MS Excel / GS

Dashboard Creation and Reporting

Data Analysis Best Practices and Tips

Companies need Business Analysts who can:

Understand the business's problems. Work with executive leadership to uncover the multi-million dollar problems.

Communicate with leadership and engage the right people to solve the problem.

Solve the business problem leveraging data AND subject matter experts.

Build verified business solutions that solve those problems.

Deploy the verified business solutions along with IT, DevOps, and other teams in an agile manner

If you could correctly identify the biggest problems, analyse and visualize it for the Senior Management

What would happen to your portfolio?

What would happen to your income?

What would happen to your title?

What would happen when you wanted to switch jobs?

What would happen when layoffs came around?

Facilitator Profile:

Amir Nair is a charismatic personality, prolific speaker, consultant and highly sought-after leader in organization and professional circles. For two decades he has not only studied the science of success but also led large teams in Fortune 100 companies in various capacities to practically experiment and implement them in practice. Amir is a certified MBTI professional, a Leadership and Transformation Coach, besides being a Six Sigma MasterBlack Belt from Indian Statistical Institute and a Lean Practitioner from Cardiff University. He infuses the Lean principles along with the coaching tools to help bring the best out of the people and organizations he works with. In his last role he was the Sr Director and Chief Data Officer for India & Global Head of Transformation for Risk, Finance & Treasury with Barclays.

Amir Nair
CEO, Amanstra Consulting
Selvan is a Doctorate in Lean Six Sigma and Data science . He is a certified Lean Six Sigma Master Black Belt & an alumnus from Anna University with 25 Years of extensive experience in spearheading multiple fortune 100 organizations towards business transformation and excellence (including one of the biggest Hospital & Healthcare setup). Selvan has submitted 4 Patents and has set up and led the People Innovation Practice. His experience includes defining & accelerating business excellence in Automotive , Manufacturing, Banking Hospital, Healthcare, Insurance , ITES, Supply chain, Remote Infrastructure. Geographies of Deployment include Africa, Middle East, Europe, North America and India. Selvan managed complex transformative changes in organizations like RNTBCI, IBM, Merri Lynch, Bank of America, Mphasis , EDS , Cognizant Technology Solutions, HP.

He also has set up and guided Strategy and program management office, multiple Centres of Excellence (COE) towards transformation, IT deployment, Automation, Payroll and HR. Selvan guides organizations in Data Science , Information Systems and Security Management, Program and Project management, Strategy consulting, Transition, Transformation, Setting up of Shared Services, TQM and Lean ourneys. Selvan has conducted more than 100+ sessions on Data Science , 300 +Sessions in Lean Six Sigma & guided 3000+ participants towards Lean/Six sigma certification impacting 55+ Customers across 1,00,000 Employees.

Dr Selvan C
Data Scientist

You're one step away from accelerating your Data Analyst career.

What will you learn in the workshop?

Data Cleaning and Preparation

Proficiency in MS Excel and Google Sheets: Participants will gain a solid understanding ofthe essential features and functionalities of both MS Excel and Google Sheets, allowing them to effectively analyse and visualize data.

Data Cleaning and Preparation: Participants will learn techniques to clean and prepare data for analysis, including handling missing values, sorting, filtering, and linking data acrossmultiple worksheets.

Exploratory Data Analysis

Exploratory Data Analysis (EDA): Participants will be equipped with the skills to perform EDA tasks such as summarizing data using functions, creating PivotTables, and analysing data through filtering and sorting.

Statistical Analysis: Participants will understand how to apply statistical concepts using built-in functions, including descriptive statistics and hypothesis testing.

Data Visualization Techniques & Reporting

Data Visualization Techniques: Participants will learn how to create various charts and graphs in both Excel and Google Sheets, enabling them to effectively represent and communicate data visually.

Dashboard Creation and Reporting: Participants will be able to create interactive dashboards and user-friendly reports in both Excel and Google Sheets, facilitating data-driven decision-making.

CLICK TO REGISTER - 100 SEATS

5 course career path to a Data Scientist

Get 6 Bonuses Worth ₹ 19927 For Free

Some Training That We Have Conducted

Trusted by 100+ Happy Customers

This community is built to make a difference to the society!

Our focus is to help you get results.

Amir is one of the most experienced coaches I have met. He gets down to understanding to root of the problem and believes in fixing it right from there. He also believes in long term success and keep reiterating the fact that there is no short cuts to it. I see the results myself as he made sure I move out of my negative zone to life full of positivity !

Ankiit Gupta

Business Manager

Amir is a fantastic coach to work with! He is patient calm and composed during the sessions. He is a very good listener and excellent at bringing out main issues which need to be addressed at the core of the problem.

The best part of his approach i liked was he allowed me to find a solution to the issues i thought were bothering me, instead of him giving his ideas as solutions. I would love to work with him in future as well.

Ashwini Mohan

Leadership & Development

I have had the privilege of working with Amir Nair as my mentor for the past few months. Amir has been instrumental in helping me to identify my strengths and weaknesses, and has provided me with valuable feedback on my perfomance. I feel incredibly grateful for his help, and would highly recommend to anyone seeking to advance their career.