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

Aim: The aim of this analysis is to identify the supply and demand gap in the Uber network and provide recommendations to improve the efficiency of their service. Introduction: Uber is a ride-hailing platform that connects passengers with drivers through a mobile app. The company has revolutionized the transportation industry…

Aim The aim of this report is to analyze the vaccination data for various countries and vaccine types and provide insights and recommendations for improving vaccination efforts. Introduction Vaccination is an important tool in preventing the spread of infectious diseases and protecting public health. With the ongoing COVID-19…

Link to the Excel File is below: https://drive.google.com/file/d/1cQHJ0eiA47Tf9xFVaur1z6_5h0RdfVki/view?usp=share_link   Project Report: Analysis of Loan Applicant Data at IJS Bank Limited Introduction: The purpose of this project is to analyze the data of loan applicants at IJS Bank Limited for the current…

PLEASE CHECK THE EXCEL FILE ATTACHED BELOW I HAVE ANSWERED ALL THE QUESTIONS. b. d.    

.

Possible issues on the gender gap in STEM Jobs would be: As we can see from the dashboard that more women are interested in health sciences rather than STEM fields. There can be many reasons for this like  Lack of role models: Women may not have as many female role models in STEM fields, which can make it more difficult…

5. Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.          

In this project, I have used all the topics from week 1 to week 6.

In this project, I have applied all the concepts which I have learned about data frames.

I worked on two projects English dictionary app and a Library Management system. In this project, I have used functions, loops, and conditional statements. I have also applied the learnings of GUI Tkinter.

MODELLING OF SUNSEEKER PREDATOR YACHT USING SOLIDWORKS   OBJECTIVE: To design various parts of a Sunseeker yacht and assemble them using Solidworks software. INTRODUCTION: A yacht is a vessel used for both leisure and competition. The term is derived from the Dutch word jaght, which means "hunter" and refers to a…

AIM:  1. To design all the parts of the American chopper using solid works part workbench. 2. To assemble all the parts designed using an assembly workbench following a bottom-up or top-down approach. 3. To create a photorealistic photo rendering using solid works visualize and photo view 360. OBJECTIVE: To get familiar…

AIM : To write a python program for the simulation of movement of simple pendulum. OBJECTIVE : 1.To generate the combined graph between velocity,displacement and time.                    2.To simulate the movement of simple pendulum which moves according to second order…

AIM : To plot a graph between temperature and cp(coefficients of pressure) from the provided thermal data file.And also to find the solution for the thermal data using curve fitting in python. OBJECTIVE :  1.To calculate which curve fits better for the given thermal data. 2.To calculate the goodness criteria of curve…

AIM : To read the data from the file provided and perform some calculations and also to plot the graphs between different parameter. OBJECTIVE : 1.Data visualizer  2.Compatability check 3.Basic performance calculations CONCEPT :  The concept is to read the data file(engine_data.out) provided.Actually the data…

AIM: To write a python program to simulate the otto cycle. OBJECTIVE: 1.To write a program to plot the graph between pressure and volume.                   2.To calculate the thermal efficiency for given compression ratio. THEORY:  The Otto cycle is the theoretical…

AIM:To simulate the forward kinematics of 2R robotic arm using python. OBJECTIVE: To write a program in python to simulate the forward kinematics of 2R robotic arm and also to create animation video of the plots obtained as an output. THEORY:  Forward kinematics refers to the use of the kinematic equations of a robot…

Objective:To write a python program to calculate the drag force which act on cyclist. Problem statement:Every bicyclist has to overcome wind resistance and drag force so it is important for a bicyclist to know that how he can experiences least drag force.It is necessary to analyse the drag force acting on bicyclist at…

AIM:To develop a door trim panel following the design guidelines. SOFTWARE USED: Catia V5. FINAL BODY(RENDERED): CLASS A SURFACE:   INTRODUCTION: Door panels serve as an interface between the interior of the car and the inner workings of the door, and between vehicle occupants and the door. They are expected…

OBJECTIVE: To create quick return mechanism and CV joint parts in part work bench or generative work bench and assemble them following all the guidelines. SOFTWARE USED: CATIA V5. INTRODUCTION: a) QUICK RETURN MECHANISM: A quick return mechanism is an apparatus to produce a reciprocating motion in which the time taken…

AIM: To create B-pillar trim of a car using class A surface and as well as using the master sections provided by following all the OEM design standards. SOFTWARE USED: CatiaV5. MASTER SECTION PROVIDED: ABSTRACT: The design and development of an automobile is a complex process. The Automobile consists of number of parts;…

AIM: To create 4-way locators,2 way-locators and heat stakes. SOFTWARE USED: CatiaV5. INTRODUCTION: 3-2-1 PRINCIPLE: A work-piece free in space can move in an infinite number of directions. For analysis, this motion can be broken down into 12 directional movements or "degrees of freedom". All 12 degrees of freedom must…

 AIM: To create the dog house following the design principles. SOFTWARE USED: CatiaV5. INTRODUCTION: DOG HOUSE Dog house is an engineering feature used in plastic trim design. Dog houses are used as supporting feature. Sometimes other engineering features like snaps; locators etc. are mounded on them to increase their…

AIM: To design the screw boss following design rules SOFTWARE USED: CatiaV5 INTRODUCTION: Introduction Bosses are protuberances on a plastic part designed to add strength, to facilitate alignment during assembly, to provide for fastening, etc. Currently, many boss design practices are standardized and follow set guidelines.…

AIM: To create ribs on the coin holder. SOFTWARE USED: CatiaV5 INTRODUCTION: Ribs are thin wall-like structures that add support and rigidity to injection molded parts. They are thinner than primary walls and are used to support these walls, as well as bosses, by running perpendicular to these structures. Ribs are often…

Core & Cavity Separation workbench: Import of the Molded Part (Skrinkage operation during the Import operation) Direction management (Add Main Pulling direction, Add Slider direction, Add Axis system) Mold area management (Move faces from a Mold area to an other, Split faces, Add Faces in a Mold area) Extract Parting…