15+ Hours of Immersive Training
at IIT Madras for 2 days.

Interactive sessions
by professors of IIT.

An industry-leading IITM
Pravartak Certificate.

Who should do Data Analyst Course - ExcelR

Upcoming Batches

Select Your City

Click Here

Live Virtual Classroom

Without IITM Certification
$ 1100
$ 950
With IITM Certification
$ 1599
  • Top class trainers from various MNCs
  • 60+ case studies/assignments to ensure hands on experience
  • Real life data projects
  • Dedicated placement assistance
  • Network of 350+ corporate companies
  • Jumbo pass - Attend unlimited number of classroom/Live online batches for 1 year
  • Steinbeis Certification cost is additional

 

 

 

Upcoming Batches
17th

June

21st

June

22nd

June

Show All Batches Enroll Now
Combo Offer

  • Data Analyst + Data Science
    $ 1800
    $ 1400
  • Data Analyst + AWS
    $ 1300
    $ 1150
  • Data Science + Data Analyst + AWS
    $ 2200
    $ 1800
  • Data Analyst + Core Python
    $ 1150
    $ 875
Upcoming Batches
21st

December

21st

January

Enquire Now Enroll Now

Course Description

What does the course offer ?

The Data Analyst Course covers technologies like Excel, Advanced Excel, Tableau, SQL, Power BI, Basics of R & Python. Apart from the theory classes, there are hands-on assignments and projects that help you apply the concepts that are learnt by a student.

Advanced Certification Program in Data Science and AI for Digital Transformation from IITM Pravartak:

ExcelR, in association with IIT Madras, brings to you an add-on certification for your Data Science Course.

This certification program provides you with:

  1. 15+ Hours of Interactive Live-Virtual Sessions by professors of IIT Madras.
  2. Optional 2-day Campus Immersion in the beautiful, state-of-the-art IIT Madras.
  3. A prestigious IIT Madras Pravartak Certificate.

What is the certification process?

During the period of your course, interactive live-virtual sessions will be conducted by professors of IIT Madras. An optional campus immersion will also be planned, whereby a slot will be created, and you will travel to Chennai for a two-day experience at the IIT Madras campus. Post training, you will take a short quiz on the topics discussed in the session, which will unlock your Advanced Certification Program in Data Science and AI for Digital Transformation from IITM Pravartak.

Program Highlights

ExcelR DevOPs training

Top-Notch Faculty

Trainers at ExcelR are passionate about training, and carry 12+ years of industry experience.

ExcelR DevOPs training

Exhaustive Course Curriculum

Our industry-relevant course curriculum is tailored to provide practical exposure with the theory.

ExcelR Data Analyst training

Real-life Projects and Bootcamps

Learners will work on real-life data analytics scenarios from various domains to get application knowledge.

ExcelR DevOPs training

Job Readiness

Intensive interview preparation from Day 1 to prepare candidates for interviews with our network of 2000+ hiring partners.

 

Skills Covered

Skills covered in Data Analytics - ExcelR
Skills covered in Data Analytics - ExcelR

 

Tools and Technologies

Tools covered in Data Analyst course - ExcelR

 

Data Analyst Project Life Cycle

  • After carefully evaluating the business case in a particular domain, data will be collected surrounding it.
  • Using SQL, a database will be created to store the data collected in the previous step.
  • Establish a connection between the database and Tableau/Python/R tools to extract the required data. Generate user-friendly reports according to the business needs and develop the dashboard using Tableau/Power BI.

 

Projects

  • This project requires learners to analyze the patient data of those suffering from different diseases across various summaries. The facility, chain organizations, and dialysis stations analysis is required to be carried out where the patients are undergoing dialysis. The project also focuses on the payment mode aspect wherein if any discounts or reduction in payments have happened then those are analyzed.
  • In this project, learners analyze the loan given by a financial institution to different customers of varied grades and sub-grade levels. The analysis needs to consider the loan disbursement reasons, funded amount, and revolving balance values for every customer in different states and geolocations. The project requires the customers payment modes and the last payment values.
  • This HR-related project considers the attrition rate of employees working at an organization at different levels. The attrition rate analysis is done with respect to different factors such as monthly income, last promotion year, job role, and work-life balance of every employee of different departments.
  • The project requires learners to analyze the usage of different fuels in different facilities in different applications by finding the MMBTu and GWHt values. The fuels used for different geo-locations and for different primary titles are also taken into consideration while doing analysis.
  • The primary aim of the project is to determine the different reasons behind the delay of flights of various airlines. The analysis needs to consider the number of flights in operation, the number of flights cancelled, and the statistical summary of week-wise, state-wise, and city-wise flight distributions.
  • The market for a certain product is analyzed by considering a particular retail outlet which sells these products. The project involves statistical analysis on the payment distribution from different customers with the different modes of transactions across different product categories. The feedback from customers with respect to shipping days and other factors also needs to be considered while carrying out the analysis.

 

Learning Path

DA Learning Path - ExcelR

 

Why ExcelR

ExcelR DevOPs training

Industry-Based Course Curriculum

ExcelR DevOPs training

Value Adds: Python Programming, Fundamentals of R, Business Statistics, SAS

ExcelR DevOPs training

Work Hands-on With 50+ Labs, 30+ Assignments, and 1500+ Interview Preparation Questions

 

ExcelR DevOPs training

Dedicated Placement Cell

ExcelR DevOPs training

Support through WhatsApp, Calls, & Emails

ExcelR DevOPs training

Lifetime eLearning Access

 

Course Curriculum

What does the course offer ?

The Data Analyst Course covers technologies like Excel, Advanced Excel, Tableau, SQL, Power BI, Basics of R & Python. Apart from the theory classes, there are hands-on assignments and projects that help you apply the concepts that are learnt by a student.

 

Program Highlights

ExcelR DevOPs training

Top-Notch Faculty

Trainers at ExcelR are passionate about training, and carry 12+ years of industry experience.

ExcelR DevOPs training

Exhaustive Course Curriculum

Our industry-relevant course curriculum is tailored to provide practical exposure with the theory.

ExcelR Data Analyst training

Real-life Projects and Bootcamps

Learners will work on real-life data analytics scenarios from various domains to get application knowledge.

ExcelR DevOPs training

Job Readiness

Intensive interview preparation from Day 1 to prepare candidates for interviews with our network of 2000+ hiring partners.

 

Skills Covered

Skills covered in Data Analytics - ExcelR
Skills covered in Data Analytics - ExcelR

 

Tools and Technologies

Tools covered in Data Analyst course - ExcelR

 

Data Analyst Project Life Cycle

  • After carefully evaluating the business case in a particular domain, data will be collected surrounding it.
  • Using SQL, a database will be created to store the data collected in the previous step.
  • Establish a connection between the database and Tableau/Python/R tools to extract the required data. Generate user-friendly reports according to the business needs and develop the dashboard using Tableau/Power BI.

 

Projects

  • This project requires learners to analyze the patient data of those suffering from different diseases across various summaries. The facility, chain organizations, and dialysis stations analysis is required to be carried out where the patients are undergoing dialysis. The project also focuses on the payment mode aspect wherein if any discounts or reduction in payments have happened then those are analyzed.
  • In this project, learners analyze the loan given by a financial institution to different customers of varied grades and sub-grade levels. The analysis needs to consider the loan disbursement reasons, funded amount, and revolving balance values for every customer in different states and geolocations. The project requires the customers payment modes and the last payment values.
  • This HR-related project considers the attrition rate of employees working at an organization at different levels. The attrition rate analysis is done with respect to different factors such as monthly income, last promotion year, job role, and work-life balance of every employee of different departments.
  • The project requires learners to analyze the usage of different fuels in different facilities in different applications by finding the MMBTu and GWHt values. The fuels used for different geo-locations and for different primary titles are also taken into consideration while doing analysis.
  • The primary aim of the project is to determine the different reasons behind the delay of flights of various airlines. The analysis needs to consider the number of flights in operation, the number of flights cancelled, and the statistical summary of week-wise, state-wise, and city-wise flight distributions.
  • The market for a certain product is analyzed by considering a particular retail outlet which sells these products. The project involves statistical analysis on the payment distribution from different customers with the different modes of transactions across different product categories. The feedback from customers with respect to shipping days and other factors also needs to be considered while carrying out the analysis.

 

Learning Path

DA Learning Path - ExcelR

 

Why ExcelR

ExcelR DevOPs training

Industry-Based Course Curriculum

ExcelR DevOPs training

Value Adds: Python Programming, Fundamentals of R, Business Statistics, SAS and ChatGPT

ExcelR DevOPs training

Work Hands-on With 50+ Labs, 30+ Assignments, and 1500+ Interview Preparation Questions

 

ExcelR DevOPs training

Dedicated Placement Cell

ExcelR DevOPs training

Support through WhatsApp, Calls, & Emails

ExcelR DevOPs training

Lifetime eLearning Access

 

Contact Our Team of Experts

Participants Placed Through ExcelR

FAQs

Global Presence

ExcelR is a training and consulting firm with its global headquarters in Houston, Texas, USA. Alongside to catering to the tailored needs of students, professionals, corporates and educational institutions across multiple locations, ExcelR opened its offices in multiple strategic locations such as Australia, Malaysia for the ASEAN market, Canada, UK, Romania taking into account the Eastern Europe and South Africa. In addition to these offices, ExcelR believes in building and nurturing future entrepreneurs through its Franchise verticals and hence has awarded in excess of 30 franchises across the globe. This ensures that our quality education and related services reach out to all corners of the world. Furthermore, this resonates with our global strategy of catering to the needs of bridging the gap between the industry and academia globally.

ExcelR's Global Presence

 

Call Us