Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
B. i. Total Sum of Sales 10032628.9 ii. Average of Sales 3553.88907 iii. Standard Deviation of Sales 1841.53885 iv. Variance of Sales 3391265.34 v. Maximum Sales 14082.8 vi. Minimum Sales 482.13 PLEASE FIND THE ATTACHMENTS FOR THE SOLUTIONS
shalini kanagasabapathy
updated on 18 May 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...
Be the first to add a comment
Read more Projects by shalini kanagasabapathy (7)
Project 2 - EDA on Vehicle Insurance Customer Data
done
08 Sep 2023 11:20 AM IST
Project 2
#Answer 1 create database alumni; # Answer 2-Table imported #Answer 3 desc college_a_hs;desc college_a_se;desc college_a_sj;desc college_b_hs;desc college_b_se;desc college_b_sj; # Answer 4 import mysql.connectortesdb=mysql.connector.connect(host="localhost",user="root",password="12345",database="alumni")tescursor=tesdb.cursor()tescursor.execute("select…
19 May 2023 08:45 AM IST
Project 1
# Answer 1create database ecommerce;# Answer 2use ecommerce;SHOW TABLES; # Answer 3DESCRIBE USERS_DATA; # Answer 4SELECT * FROM USERS_DATA LIMIT 100; # Answer 5SELECT DISTINCT COUNTRY,LANGUAGE FROM USERS_DATA;SELECT COUNT(DISTINCT COUNTRY) FROM USERS_DATA;SELECT COUNT(DISTINCT LANGUAGE) FROM USERS_DATA;SELECT COUNT(DISTINCT…
25 Apr 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
here i have attached the drive link for the worksheet. https://docs.google.com/spreadsheets/d/1fa_wMlEQPd9dGNFB7jiGVdyp6BhXeRQD/edit?usp=sharing&ouid=111124802796664593507&rtpof=true&sd=true 3b) VBA Code to convert selected data into pdf from applicant data: Sub PDFconversion()Dim r As RangeDim s As String…
26 May 2022 01:11 PM IST
Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring
B. i. Total Sum of Sales 10032628.9 ii. Average of Sales 3553.88907 iii. Standard Deviation of Sales 1841.53885 iv. Variance of Sales 3391265.34 v. Maximum Sales 14082.8 vi. Minimum Sales 482.13 PLEASE FIND THE ATTACHMENTS FOR THE SOLUTIONS
18 May 2022 04:51 AM IST
Project 2 - Gender Bias in Science and Technical field
Project 2 completed.Here I have attached tableau workbook & pdf for your reference.
12 May 2022 04:46 PM IST
Project 1 - Analyzing the Education trends in Tamilnadu
Project completed i have attached tableau file & pdf for your reference.
11 May 2022 01:43 PM IST