Project 1 - Data Cleaning and Transformation using Pivot table and Charts for the Report on requirement of Team Hiring

Aim The aim of this presentation is to demonstrate the insights and findings obtained from analyzing the Super Mart sales data using Power BI. By exploring various charts and visualizations, we aim to provide a comprehensive understanding of the sales performance by category and subcategory, sales trends by region and…

Power BI: I have used Power BI to analyze and visualize the COVID-19 vaccination data. I imported the data into Power BI, handled duplicates and null values using Power Query, and used various visualization options to represent the data in an easy-to-understand format.   Presentation Slides: I have created presentation…

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 representation…

   # 1.Create new schema as alumniCREATE DATABASE alumni;# 2.Import all .csv files into MySQLUSE alumni;# 3. Run SQL command to see the structure of six tablesDESC college_a_hs;DESC college_a_se;DESC college_a_sj;DESC college_b_hs;DESC college_b_se;DESC college_b_sj;select * from college_a_hs;# 4. Display first…

Business model Customer to Customer   -- 1. Create new schema as ecommerceCREATE DATABASE ecommerce;-- 2.Import .csv file users_data into MySQLuse ecommerce;-- 3.Run SQL command to see the structure of tableDESC users_data;-- 4.Run SQL command to select first 100 rows of the databaseSELECT *FROM users_dataLIMIT 100;--…

Done with the project2  ##STEP 1: Reading Dataimport pandas table1 = pandas.read_csv("customer_details.csv")table2 = pandas.read_csv("customer_policy_details.csv")print(table1.head())print('*'*100)print(table2.head()) ##STEP 2: Checking and Cleaning the data table1_labels={'0':'customer_id', '1':'gender', '2':'age',…

project 1 is done ## ENGLISH DICTINORY APP import osimport json def saveDictionary(tmp_dict):try:with open('word.txt','w') as dictionary:json.dump(tmp_dict,dictionary)print('Successfully entered')except Exception as e:print(f"ERROR:{e}") def getDictionary():try:with open('word.txt','r') as dictionary:tmp_dict=json.load(dictionary)print('Successfully…