Kaviya P G

A result-oriented and self-driven analyst with practical experience through multiple projects using SQL, Excel, Power BI, and Python. Highly skilled in collecting, analyzing and visualizing data.

Library Management System: 

(SQL Lite) Designed and developed a Library Management System to efficiently organize library resources. Implemented features for book cataloging, member management, and borrowing/returning processes. Enhanced user experience through intuitive interfaces for librarians and patrons, improving overall library functionality.

Bike Sales Dashboard using Excel: Data Visualization and Insights

 Analyzed a diverse real-world Bike Sale dataset consisting of over 1000+ people's data in Excel, expertly  utilizing a wide range of formulas, functions, and pivot tables.  Cleaned, organized, and visualized 100% of data. Developed impactful Excel dashboards to communicate crucial insights, driving a 60% increase in business  growth.

Adventure works Dashboard using PowerBI: Data Shaping, Data modeling and Data Visualization.

 Executed: Developed an end-to-end data analysis solution using Power BI, importing data from CSV files  into Power BI using Power Query Editor. Transformed and Shaped: Cleansed, transformed, and structured the data, ensuring data quality and  consistency. Constructed: Designed a robust data model, establishing relationships between tables for optimal  performance. Leveraged: Utilized DAX (Data Analysis Expressions) to create calculated fields and measures. Visualized: Created interactive dashboards and reports, conveying insights through charts and graphs.

Nashville Housing Data in SQL: SQL, Data Cleansing and Data Analysis.  

I executed an end-to-end data cleaning solution by importing a dataset from GitHub into SQL  Workbench. I meticulously identified and corrected errors, handled missing values, and removed duplicates.  02/2023  Additionally, I standardized date formats, parsed property addresses, and gained a deeper understanding of  the critical role data cleaning plays in accurate analysis.

[Data Analysis with Python] Training -

I've been pursuing my course at Besant Technologies for the past 6 months, where I have successfully completed the Data Analytics program and earned my certification. During this time, I have also accomplished the following:

• Python: Developed a project on traffic light control systems.
• Power BI: Created a comprehensive data visualization project.
• Tableau: Conducted advanced data visualization and analytics.
• Predictive Modeling: Built models to forecast customer behavior.
• SQL: Completed a project on an insurance database.
• Advanced Excel: Gained advanced proficiency.