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

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

A company has customer data that contains 8 columns of customer details and another table having the name customer_policy data contains the policy details of the customer. The company intends to offer some discount in premium for certain customers.   df1 ~ customer details df2 ~ customer policy details

English Dictionary: def display_menu(): print("""Menu: 1. Add a new word 2. Find the meaning 3. Update a word 4. Exit Choose from the above""") import json d = {} display_menu() while True: choice = int(input('Enter your choice:')) if choice == 1: word = input('Enter a word: ').title() meaning = input('Enter its meaning:…

https://public.tableau.com/views/EducationtrendsinTamilnadu/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link

https://public.tableau.com/views/WomeninSTEMfields_16678349996700/Dashboard1?:language=en-US&publish=yes&:display_count=n&:origin=viz_share_link

https://drive.google.com/file/d/1AZuXfyaa2STFENFY4qvKUZawWHXqLqih/view?usp=sharing 1. Created a new Schema : There are multiple ways to create a new schema right click on the free space in the schema tab shows create schema or Click the icon shown below which says create a new schema in the connected server. Named schema…

PROJECT: CREATING SALES REPORTS OF COMPANY PRODUCTS USING PIVOT TABLES AND CHARTS IN MICROSOFT EXCEL. Link : https://docs.google.com/spreadsheets/d/1xEXiiYDY-he-T9okF5-1CNcIB4xxQg8v/edit?usp=sharing&ouid=116649376204193397723&rtpof=true&sd=true Understanding the dataset and data formatting is the foremost step…

File Link: https://drive.google.com/file/d/1AtLM1phnE7xEi8ju2K1ldrXL4oQSo83u/view?usp=sharing A preview of the dashboard after analyzing the data: