most of them were done in Excel. a. Proper formatting is done in the below attachment. A comparison is shown in the tabs named Skill lync data and another tab named Sales_data. b. All the mentioned functions are shown in the 'Product Sales Summary' tab. c. Pivot Table 1 tab in the attached sheet.  d. Customized Tab…

The "Attachment" is shown below: https://drive.google.com/drive/folders/154c_LnObLtnENSKvLH912T8NEKOafMr5 Most of the part is done in Excel except for the VBA and a few other functions like unique which can be theoretically written here. To create Pivot Table first Select the necessary data from the data source and then…

All are done in Tableau Desktop and the link to Tableau Public is shown below: https://public.tableau.com/app/profile/potnuru.sriya/viz/TableauProject2_17123787051840/Dashboard1?publish=yes  

All are done in Tableau Desktop and Tableau Public. The link in Tableau Public is shown below: https://public.tableau.com/app/profile/potnuru.sriya/viz/TableauProject1_17124075539130/Dashboard1?publish=yes A preview of the dashboard is shown below:    

Unlocking Insights: Understanding C2C E-Commerce Through User Data:C2C e-commerce connects customers for transactions. Sellers may pay fees, buyers don't. By analyzing user data, we grasp business insights and track user behavior.1. Creating a new schema from e-commerce: create database ecommerce;2. Import .csv…

Once a student is passed out from an Institute or College, he/she is known as Alumni of the Institute. Alumni’s career growth plays important role in Institute’s ranking and other networking activities. In this project, career choices of alumni of two Universities will be analyzed with respect to their passing year as…

The remaining are done in .ipynb formatThe result is shown below:

EDA on Vehicle Insurance Customer Data Aim: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…

Project COVID-19 Vaccinations Trend Analysis using Power BiAim:  This project focuses on a detailed analysis of vaccination and full vaccination data, categorized by year and country.Introduction:  The primary goal of this project is to analyze data on COVID-19 vaccinations, aiming to uncover key insights through…