Gurvinder Dhiman

PROJECTS

Web Scraping
Using scraping, I collected class and attribute information from a live website. My scraping and data wrangling were done using Python scripts, and I exported data in CSV format to create visualization dashboards for further analysis.
Objectives:
1) Designed for making a lookalike website whose final position has already been achieved.
2) The data analysis will also be easier since we don't have to go through every webpage to keep track of everything one by one.
3) You can retrieve any particular information you need, such as classes and attributes, without any difficulty.

Power BI Visualization Dashboard For Data Analysis
To import Data, I used several files available in CSV format. then I did Data Cleaning and Data Wrangling because you can't Analyze Unstructured Data. created particular Relationships between Tables (Data Modelling), and created Calculated Columns and Measures according to the needs of the project. creating Visualization Dashboard Report is the end goal.
Objectives:
1) To easily do dynamic calculations like 10-Day Rolling Profit.
2) To extract the granular information about every product without any
difficulty. For Example in Hierarchical Form.
3) To check which product is doing well in a particular Region/City, Age, or Income level by just clicking on that particular product.
4) Whether the company is making the expected sales or not.
5) Decision Making regarding whether we have to increase the production or not.