In this project 1 I learned about the following: 1. importing data from CSV files 2. creating a database 3. working on a database 4. using various functions in SQL 5. using select statements and working on a query used from week1 to week6
Vikas gupta
updated on 05 Nov 2022
Project Details
Leave a comment
Thanks for choosing to leave a comment. Please keep in mind that all the comments are moderated as per our comment policy, and your email will not be published for privacy reasons. Please leave a personal & meaningful conversation.
Other comments...
Read more Projects by Vikas gupta (10)
Project 1 - COVID-19 Vaccinations Trend Analysis
COVID-19 VACCINATION TREND ANALYSIS I. AIM: The aim of this project is to get a detailed analysis on covid-19 vaccination trends by analyzing vaccinated people and fully vaccinated by year and country II. INTRODUCTION:…
19 Mar 2024 03:18 PM IST
Project 1 - Analyzing the Education trends in Tamilnadu
In this following project i have learned about the following: Hands on working of tableau for creating data Getting insight of data Please find the link of my project: https://public.tableau.com/views/GenderbiasinSTEMjobs/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link
05 Feb 2023 05:17 PM IST
Project 2 - Gender Bias in Science and Technical field
Tableau public link: https://public.tableau.com/views/TAMILNADULITERACYRATE/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link
29 Jan 2023 07:55 AM IST
Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies
In the following project I have learned about: 1. Working with pivot charts and tables 2. Working with various functions like DCOUNT,SUMIF, etc 3. Working with VBA codes Please find the drive link for this project https://drive.google.com/file/d/1zVl6_31_a3dRQm0v0PWuagpBpUid1IwU/view?usp=share_link THANKS
24 Dec 2022 07:44 AM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
1. CONDITIONAL FORMATTING 2. FIND AND REPLACE 3. PIVOT CHART AND PIVOT TABLES 4. CUSTOMISED RIBBON
17 Dec 2022 10:03 AM IST
Project 2
In this working of the project I have learned about the following: 1. Working on different SQL query 2. Working of Query on different platforms(excel,python) Q4. Display first 1000 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) with Python. 5.Import first…
05 Dec 2022 05:36 PM IST
Project 1
In this project 1 I learned about the following: 1. importing data from CSV files 2. creating a database 3. working on a database 4. using various functions in SQL 5. using select statements and working on a query used from week1 to week6
05 Nov 2022 06:52 AM IST
Project 2 - EDA on Vehicle Insurance Customer Data
In the following project I learned about the following: 1. Hands-on experience working on a pandas data frame 2. Cleaning and extracting the data from the files 3. Exploring describe the function 4. Take out duplicates and white spaces 5. Taking out Data based on requirements
09 Oct 2022 02:13 PM IST
Project 1 - English Dictionary App & Library Book Management System
In the following project, I learned about the working of user-interface 1. working on the Tkinter application 2. programming and working of code 3. It was an exciting and great learning experience
05 Oct 2022 01:03 PM IST