MUDE CHARAN NAIK
Interests
- Data Analysis
- Data Science
- Machine Learning
- Business Intelligence
- Data Visualization
- Predictive Modeling
ABOUT ME
I am a 5th-year Integrated M.Tech student at IIT Roorkee, specializing in Geophysical Technology. Alongside my academic journey, I have personally learned and developed strong skills in data analysis, machine learning, and data visualization tools like Power BI and Tableau. I have successfully completed projects such as Sales Analysis using SQL and Power BI, and Lending Club Loan Data Analysis using Python and Pandas. I am passionate about leveraging data to uncover insights and drive business growth. My goal is to help organizations make informed decisions by providing actionable insights through data analysis and visualization. I am eager to apply my skills to real-world problems and contribute to data-driven decision-making processes.
SKILLS
Power BI
Microsoft Excel
mySQL (Structured Query Language)
Python
Tableau
KPI Dashboard
PROJECTS
Sales Analysis Project [SQL | Power BI]
- GitHub Repo: SALES_ANALYSIS
- Analyzed overall sales trends, sales by category and sub-category, and profit analysis by customer segments.
- Identified top 10 products by sales, most selling products, and the most preferred ship mode.
- Evaluated the most profitable category and sub-category to provide actionable insights for business decisions.
Lending Club Loan Data Analysis [Python | Pandas | Matplotlib]
- Kaggle Notebook: Lending Club Loan Data
- Performed exploratory data analysis on Lending Club loan data to uncover insights and trends.
- Visualized key metrics and patterns using Matplotlib and Seaborn to aid in data-driven decision making.
- Cleaned and preprocessed the data using Pandas to ensure accuracy and reliability of the analysis.
Business Insights 360 - Brick & mortar and ecommerce [Power BI | SQL | Excel | Dax Studio]
- GitHub Repo | Project Presentation | Live Dashboard
- Customized a multi-functional Power BI dashboard to analyze Atliq hardware's sales trends over the global market by gathering data from 2 different sources (Excel/CSV files and a SQL database).
- Built data model and visualizations in Power BI and optimized the report with DAX studio which improved the performance of the report by 5%.
- The dashboard enabled Atliq hardware to analyze different department sales trends and make data-driven decisions, leading to a projected 10% revenue acceleration and 20% reduction in data-related expenses.
Portfolio Website Design [HTML | CSS | JavaScript]
- Website: Portfolio Website
- Designed and developed a personal portfolio website to showcase projects and skills.
- Implemented responsive design using HTML, CSS, and JavaScript to ensure compatibility across devices.
- Integrated interactive elements such as real-time clock, weather updates, and random quotes to enhance user experience.
LANGUAGES
Telugu
Hindi
English
Education
Integrated M.Tech in Geophysical Technology
Indian Institute of Technology Roorkee (2020-2025)
CGPA: 6.5/10
Department: Earth Sciences
Expected Graduation: May 2025
Relevant Courses: Data Structures, Algorithms, Machine Learning, Geophysical Data Analysis, Numericl Modeling
12th Grade
Sri Chaitanya Junior College, Tirupati (2018-2020)
CGPA: 9.0/10
Subjects: Mathematics, Physics, Chemistry
10th Grade
Narayana EM School, Tirupati, Andhra Pradesh (2018)
CGPA: 9.7/10
Blogs
BLOG 1
As a data analyst, understanding the fundamentals of data analysis is crucial. This blog covers the basics of data analysis, including data cleaning, transformation, and visualization techniques.
The Algorithms - Python
Explore a comprehensive collection of algorithms implemented in Python. This repository is a great resource for learning and understanding various algorithms through practical examples.
BLOG 2
Machine learning is an essential skill for data analysts. This blog explores various machine learning algorithms and their applications in real-world scenarios.
FireDucks Dev
Dive into the world of machine learning with FireDucks Dev. This blog provides tutorials, guides, and insights into machine learning algorithms and their practical applications.
BLOG 3
Data visualization helps in communicating insights effectively. This blog discusses different data visualization tools and techniques to create impactful visualizations.
Data Scientist Handbook
A comprehensive handbook for data scientists, covering various data visualization tools and techniques. Learn how to create impactful visualizations to communicate insights effectively.
BLOG 4
Exploring the importance of data quality in data analysis and how to ensure your data is accurate and reliable.
The Big Book of Data Science
Discover the importance of data quality in data analysis with The Big Book of Data Science. This resource provides insights and techniques to ensure your data is accurate and reliable.
BLOG 5
A comprehensive guide to using SQL for data analysis, including tips and tricks for writing efficient queries.
AI Data Scientist
Explore the intersection of AI and data science with this comprehensive guide. Learn about various AI techniques and how they can be applied to data science projects.
BLOG 6
How to leverage Python libraries like Pandas and NumPy for data manipulation and analysis.
Pandas AI: The Future of Data Analysis
Discover the power of Pandas AI, a revolutionary tool that enhances data analysis capabilities. Learn how to integrate AI with Pandas to automate data processing and gain deeper insights.
BLOG 7
The role of data visualization in storytelling and how to create compelling visual narratives.
Data Science Projects
Explore a variety of data science projects that showcase the power of data visualization in storytelling. Learn how to create compelling visual narratives to communicate insights effectively.
BLOG 8
An introduction to machine learning for data analysts, including key concepts and practical applications.
Data Science by Mehdee
Discover key concepts and practical applications of machine learning for data analysts. This repository provides a comprehensive introduction to machine learning techniques and their real-world applications.
BLOG 9
Best practices for data cleaning and preparation to ensure your analysis is based on high-quality data.
Efficient Python Tricks and Tools for Data Scientists
Learn best practices for data cleaning and preparation with efficient Python tricks and tools. This repository provides valuable insights and techniques to ensure your data analysis is based on high-quality data.