Welcome to my GitHub profile! I am Lakhan Jadam
a passionate Data Analyst with a keen interest in transforming raw data into actionable insights. My journey in the world of data analysis has equipped me with a diverse skill set and hands-on experience with various tools and technologies. This profile showcases my work and projects in the realm of data analysis and visualization.
As a dedicated Data Analyst, I thrive on discovering patterns and trends within data to help businesses make informed decisions. My expertise spans across several key areas:
- Data Analysis: Proficient in data cleaning, processing, and statistical analysis using Python, R, and SQL.
- Data Visualization: Skilled in creating compelling visualizations and dashboards with tools like Tableau, Power BI, and Matplotlib.
- Statistical Techniques: Experienced with various statistical techniques and models to extract meaningful insights and predict future trends.
- Data Management: Competent in database management, including designing and querying relational databases with SQL.
-
Programming Languages:
- Python
- SQL (MySQL)
-
Data Analysis & Visualization Tools:
- Power BI
- Excel
-
Libraries & Frameworks:
- NumPy
- Pandas
- BeautifulSoup
Here are some of the projects I've worked on:
- Description: Created a database and imported purchase data with SQL, transforming and normalizing it. Analyzed data with Python to calculate totals, identify top customers, and analyze trends. Built an interactive PowerBI dashboard to visualize purchase trends, top customers, and product performance.
- Skills Used: Python, Pandas, MySQL,PowerBi
- Details: View Project
- Description: Cleaned the data by removing missing, duplicate, and inconsistent entries. Used Excel formulas like SUM, AVERAGE, and COUNT to calculate key metrics. Added clear titles, axis labels, and legends to make charts easy to understand and observe churn rate of customers. Analyzed customer churn rate to identify patterns and trends in customer retention and attrition. This involved creating charts that visually represented churn metrics over time, providing insights into customer behavior and retention strategies.
- Skills Used: MS Excel
- Details: View Project
- Description: Used the requests library to send HTTP requests and retrieve HTML content from URLs. Parsed HTML with BeautifulSoup to navigate and extract desired elements. Extracted data using BeautifulSoup methods like find and find_all. Implemented data validation checks to ensure accuracy and completeness.
- Skills Used: BeautifulSoup,selenium
- Details: View Project
- Description: Analyzed the CARS24 dataset using SQL to generate meaningful business insights. Optimized SQL queries for efficiency and performance. Utilized functions, subqueries, and aggregations to complete analysis tasks. Added comments to SQL queries to explain the approach and logic used.
- Skills Used: MySQL
- Details: View Project
Thanks for visiting my profile! Feel free to reach out if you have any questions or just want to discuss data analytics.