Portfolio - Sanjit Cyrus R

Sanjit Cyrus R

Data Analyst

Resume

1

Excel Project

2

PowerBI Projects

1

SQL Project

1

Python Project

About Me

Hello! I'm Sanjit Cyrus R, an aspiring Data Analyst passionate about transforming raw data into compelling insights. With a solid foundation in Mechanical Engineering and a Master's degree in Computer Science and Engineering, I discovered my natural affinity for data analysis and honed my skills in Excel, Power BI, SQL, and Python.My journey into data analytics has been driven by a series of hands-on projects that allowed me to develop and showcase my abilities in data modeling, predictive analysis, and visualization. While my formal experience comes from my role as a Project Engineer at Liku Tech Environmental Solutions, where I streamlined processes and optimized operations, my heart lies in the power of data.I specialize in creating dynamic Power BI dashboards, managing databases with SQL, and applying Python for sophisticated predictive models. These tools enable me to deliver actionable insights and support data-driven decision-making.

Key Skills

Python

Project Management

Tableau

SQL

My Projects

Predictive Regression Analysis for Sustainable Air Quality Management

Business Insights 360

Atliq Sales and Finance

Crop Production Analysis

Adhoc Insights for consumer goods

Domain/Function: Consumer Goods

Awards & Certificate

Best Paper Award at IEEE sponsored ICNWC - 2024 Conference

Python for Data Science AI and Development

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Download Resume

Resume

Mail Me

[email protected]

https://www.linkedin.com/in/sanjit-cyrus/

Call Me

+91 7904027768

GitHub

https://github.com/Sanjit-Cyrus-R

Python Project

Predictive Regression Analysis for Sustainable Air Quality Management

Utilized Python to predict Chennai's Velachery and Manali Air Quality Indexes. This also involves Selection of Features statistically with Correlation Coefficient.

View Project
Engagement

View Project
on GitHUB

Jupyter Notebook

Hyperparameter Tuning is done for XGBoost Model

Project Details

The importance of predicting and forecasting the Air Quality Index (AQI) using machine learning approaches is growing due to the negative health impacts of air pollution. Monitoring and predicting air pollution is crucial to empower individuals to make informed decisions that protect their health. This project presents a comprehensive comparative analysis focused on air quality prediction using different regression techniques. It also focus on the variables that affect air quality so that we or the government authorities can make an informed decisions. It explores many features that are important or relevant or affect the air quality.

Learnings:
Air Quality Index
Using Pandas, Matplotlib and Seaborn for Data manipulation and Visualization
Scikit learn for Building Machine Learning Models

Project video

PowerBI Project

Business Insights 360

Business insights 360 is a comprehensive presentation of power BI dashboards/reports telling us the important metrics of different aspects of business to enable data driven decision making.

View Project
Engagement

View Project
on GitHUB

The landing page of this report navigates to all the pages of the report

Data Model used, it has 10 + tables and use snowflake schema of Data Modeling

Project Details

Atliq manufactures and sells personal computers, laptops, and peripherals worldwide. They operate multiple manufacturing units, distributing products globally. Rapid growth highlights the need for enhanced data-driven decision making. Dashboards highlighting the key areas of business such as Finance, Sales, Marketing and Supply Chain are made. An executive view highlighting key areas of all business is also made.

𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗟𝗲𝗮𝗿𝗻𝗶𝗻𝗴𝘀:

Data collection from sources like MySQL Server, Excel, and CSV files
Data transformation using Power Query
Snowflake Data Modeling in Power BI
Advanced DAX
Using Bookmarks to toggle between visuals
Creating links for navigation between views
Designing visually appealing and functional dashboards

𝗕𝘂𝘀𝗶𝗻𝗲𝘀𝘀 𝗧𝗲𝗿𝗺𝗶𝗻𝗼𝗹𝗼𝗴𝗶𝗲𝘀 𝗟𝗲𝗮𝗿𝗻𝗲𝗱:

Gross Sales
Net Sales
Gross Margin & Gross Margin%
Net Profit & Net Profit%
Cost of Goods Sold
YTD & YTG
Fiscal Year and Quarter
Net Error, Forecast Error, Absolute Error
Market Share

Project video

Live Interactive Dashboard

Excel Project

Atliq Sales and Finance

The aim is to create comprehensive sales and finance reports for Atliq hardware in Excel using Power Query for data transformation and Power Pivot for data modeling, enabling dynamic analysis and insightful visualizations.

View Project
on GitHUB

Customer Net Sales Performance

Market performance vs target

Project Details

Atliq Hardware is a computer hardware manufacturing company that manufactures hardware products like Keyboard, Mouse, Monitor Etc. Their business model is to manufacture the goods in their manufacturing unit and sell it to various types of customers. Atilq is now a developing company and there is a lot of data in the company. The company is moving towards data analysis in order to make sense of the data. This project aims to use excel to create a sales and Finance report in order to make data driven decisions.

Reports Explanation

Sales Report - A sales report is a document that analyzes a company's sales activity over a specific period. It's a deep dive into how business is going and helps inform future decisions.
Finance Report - A financial report is document that summarizes a company's financial activities and health over a specific period. It's like a financial checkup for the business.

PowerBI Project

Crop Production Analysis

The project focuses on the variables that affect crop production using correlation coefficient and ANOVA analysis (Using Python). The EDA is done in power BI Another focus is also on building a machine learning model that accurately predicts the crop production.

View Project
on GitHUB

Other Tools

Python

Power BI Visuals for Exploratory Data Analysis

Crop Production Prediction Code in Python

Project Details

The need to increase agricultural output is more important than ever because of the world's population growth and the threat posed by climate change. The foundation of this effort is crop production, which is essential to global economic stability and food security. Understanding how crucial it is to maximize crop yields, our study sets out to examine, evaluate, and ultimately enhance the complexities of agricultural production.

The power BI dashboard for exploratory data analysis has 4 pages and each page is titled as followed.

Crop Production
Crop Production when top two crops are removed
Crop Production area
Crop production area when top crop is removed

The pages Crop production and Crop Production when top two crops are removed has the following visuals

Crop production by type of crop
Crop production by year
Crop production by State
Crop production by District
Crop production by Season

Live Interactive Dashboard

SQL Project

Adhoc Insights for consumer goods

Domain/Function: Consumer Goods

Atliq Hardwares is one of the leading computer hardware producers in India and well expanded in other countries too. However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. Hence, the adhoc requests will help to make a smart decision

View Project
Engagement

View Project
on GitHUB

Project process flow SQL -> CSV -> Python ->Visual

Ploty map visual answering adhoc query

Project Details

Atliq Hardwares, a leading computer hardware manufacturer in India with a significant international presence, has identified a need for enhanced insights to support swift and informed decision-making. To address this, the company plans to expand its data analytics team by hiring several junior data analysts. Tony Sharma, the Data Analytics Director, seeks candidates who excel in both technical and soft skills. To evaluate these abilities, he has decided to conduct a SQL challenge.

The SQL challenge is to create 10 ad hoc queries for infomed decision making. The queries are written in MySQL and the visuals are plotted in python using matplotlib, seaborn, ploty libraries.