This project uses the skills learnt from week 1 to week 6. The aim of this project is to create an English Dictionary app that returns definitions of English words. When the application is started, it displays a menu as follows: Main Menu Add a new word Find the meaning Update a word Exit Enter Choice: '''If item 1 is…

'''A company has customer data that contains 8 columns of customer details and another table having name customer_policy data contains the policy details of the customer. ​ The company intends to offer some discount in premium for certain customers. To do that they ask their Data scientist team to get some information.…

1. Create new schema as ecommerce - Created 2. Import .csv file users_data into MySQL(right click on ecommerce schema -> Table Data import Wizard -> Give path of the file -> Next -> choose options : Create a new table , select delete if exist -> next -> next) - imported # 3. Run SQL command to see the…

# 1. Create new schema as alumniCREATE DATABASE alumni;# 2. Import all .csv files into MySQL# imported# 3. Run SQL command to see the structure of six tablesUSE alumniDESC college_a_hs;DESC college_a_se;DESC college_a_sj;DESC college_b_hs;DESC college_b_se;DESC college_b_sj; (Same procedure for all other table) # Import…

a. Do proper formatting of the data with using borders, font size and appropriate alignment of the content. b. Make summary of Products Sales by providing Total Sum of Sales Average of Sales Standard Deviation of Sales Variance of Sales Maximum Sales Minimum Sales  c. Make worksheet from the given Data for categorical…

https://docs.google.com/spreadsheets/d/1uRh7a80Zud2c_4D-RcDivs1hFARMWbeW/edit?usp=sharing&ouid=116839531282335157395&rtpof=true&sd=true VBA Code to convert selected data into pdf from applicant data: Sub Pdf_conversion()Dim r As RangeDim s As String If Selection.Count = 1 ThenSet r = Application.InputBox("Select…

This dashboard empowers mission driven organizations to harness the power of data visualization for social change. Women are tracked away from science and mathematics throughout their education, limiting their training and options to go into these fields as adults. The data set contains the data of women graduated by years,…

This dashboard empowers mission driven organizations to harness the power of data visualization for social change. The data set talks about the literacy rates in Tamilnadu. It is distributed according to the cities and their ranks. It contains the population, as per the gender. This dashboard gives us the insight about…