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

In this project i havee created a report using power query,macro VBA,list functions and data validation functions for data reporting of supply chain managment companies. https://docs.google.com/spreadsheets/d/1B7Ys2UOpvmyXCDxegdBg_MFElHEFwcnv/edit?usp=drivesdk&ouid=101354297315463581757&rtpof=true&sd=true

Company ABC Private Limited is manufacturing and selling below mentioned Products: Classic Cars Motorcycles Planes Ships Trains Trucks and Buses Vintage Cars As Business Analyst of the Company, you are required to perform following mentioned tasks on the provided dataset. a. Do proper formatting of the data with using…

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…

A pie graph of women inBiological ScientistsChemists & Materials ScientistsComputer & Mathematical OccupationsEngineers & Architects The trend of percent women graduating in Computer science and Engineering from 2000-2015Should be in text after the graph. Frame a sentence.What percent of women are graduating…

I done the project 2 by the week 7 to week 12 knowledge of creating index and view, how to create schema and procedure making and cursors and etc...

I done this project from the SQL course week -1 to week-6 knowledge of how to create a database,how to insert the data into that table and how to delete the data from the table and how to use string functions,numeric functions and  date functions.And clauses,alias,algorithms,logical operators,order by,group by,aggregate…

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. Hence,…

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 MenuAdd a new wordFind the meaningUpdate a wordExitEnter Choice:If item 1 is selected,…