Project 2 - Create a report using PowerQuery, Macro VBA, List Functions and Data Validation functions for Data Reporting of Supply Chain Management companies

Docs link: https://docs.google.com/document/d/1nCUNcQLU9bzb4e3mKTd2oIFzsCuosXy3zsUYImTlguo/edit?usp=sharing   Aim: To collect and analyze the data of Trip Pricing with Taxi Mobility Analytics site data and analyze it in detail by each Destination type, Gender, Type of Cab and Customer Rating, trip destination, etc.…

docs link: https://docs.google.com/document/d/1L19gLGe3xD1gROfO8vija_aYQoco261nL4W1wxiWYnQ/edit?usp=sharing   Aim: The aim of the project is to collect data from the data source clean and analyze the data on Covid-19 vaccinations and find some insights.   Introduction: The main objective of the project is to…

From the given Large datasets power query and power pivot is used to extract required data,summary,visualization and formed a dashboard for the visualization.list function and now function operation is done in excel to find its function. Macros and vba code is created to do conditional formatting and to create a PDF File.…

From the given raw datasets table creation and other formatting are done in excel. From the given table data summary is done using pivot table.

From the given Data source certain data is extracted in a visualization tool and presented in the form of Graphs to find the outcome.KPI is used to find the status of education in each District. Dashboard link: https://public.tableau.com/views/Project2_16724643889740/LiteracyRateInTamilNadu?:language=en-US&:display_count=n&:origin=viz_share_link…

From the given Data source certain data is extracted in a visualization tool and presented in the form of Graphs to find the outcome. Dashboard link: https://public.tableau.com/views/Project1_16723172095450/WomeninSTEMFields?:language=en-US&:display_count=n&:origin=viz_share_link    

Based on the requirements Data analysis is done on Alumni Datasets and extracted required data by passing Complex/Advanced SQL Queries

Based on the requirements Data analysis is done on E-Commerce Datasets andextracted required data by passing Simple and complex SQL Queries in MySQLSoftware.

Exploratory Data Analysis is done to the given datasets using Pandas andNumpy module in python

In the English Dictionary App JSON module is used to load and dump in json fileformat for easy access to data in python. In Library Book Management System tkinter and sqlite3 module is used to buildGUI to Manage the library book database. Sqlite3 is used to manage the databasein python.