A PHP Error was encountered Severity: Warning Message: include(/var/www/html/excelr/application/views/index.php): failed to open stream: No such file or directory Filename: common/header_t2.php Line Number: 670 Backtrace: File: /var/www/html/excelr/application/views/common/header_t2.php Line: 670 Function: _error_handler File: /var/www/html/excelr/application/views/common/header_t2.php Line: 670 Function: include File: /var/www/html/excelr/application/controllers/Home.php Line: 215 Function: view File: /var/www/html/excelr/index.php Line: 326 Function: require_once A PHP Error was encountered Severity: Warning Message: include(): Failed opening '/var/www/html/excelr/application/views/index.php' for inclusion (include_path='.:/usr/share/php') Filename: common/header_t2.php Line Number: 670 Backtrace: File: /var/www/html/excelr/application/views/common/header_t2.php Line: 670 Function: _error_handler File: /var/www/html/excelr/application/views/common/header_t2.php Line: 670 Function: include File: /var/www/html/excelr/application/controllers/Home.php Line: 215 Function: view File: /var/www/html/excelr/index.php Line: 326 Function: require_once

*15+ Hours of Immersive Training at IITM Research Park campus for 2 days.

Interactive sessions by professors of IIT.

An industry-leading IIT Certificate.

Our Alumni Works at

Program Highlights

Top-Notch
Faculty

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

Exhaustive Course
Curriculum

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

Real-life Projects and
Bootcamps

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

Job
Readiness

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

Who Should Do The Data Analyst Course?

Desktop Image
Mobile Image

Skills Covered

Tools and Technologies

3 in 1 Certificate

Data Analyst Project Life Cycle

Phase-1:- Data Collection

After carefully evaluating the business case in a particular domain, data will be collected surrounding it.

Phase 2 :- Data Preparation

Using SQL, a database will be created to store the data collected in the previous step.

Phase 3:- Insights Generation and Dashboard Building

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

Analysis of Patient Data (Domain: Healthcare)

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.

Loan of Customers (Domain: Banking and Finance)

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.

Employee Retention (Domain: HR analytics)

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.

Industrial Combustion Energy Use (Domain: Energy)

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.

Flights delay analysis (Domain: Aviation)

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.

Olist Store Analysis (Domain: eCommerce)

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

Why ExcelR?

Industry-Based Course Curriculum

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

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

Dedicated Placement Cell

Support through WhatsApp, Calls, & Emails

Lifetime eLearning Access

Live Virtual Classroom

₹ 51999 ₹ 44999
  • Faculty are working data scientists, alumni of IIT, IIM, ISB & PhD qualified
  • Earn certification from IBM
  • Steinbeis certification cost is additional
  • Avail monthly EMI At zero interest rate on all major credit cards
Upcoming Batches
31st

December

Show All Batches Enroll Now

Google Reviews

Do You Want To Know How Dаta Analyst Will Be Great For Your Career ?

Register for the webinar