Portfolio

Key Components 1. Data Generation Tools Used: Youtube + ChatGPT + Python Faker Library 2. Design & Visualization Mockups: Designed wireframes with draw.io for container layouts to plan the dashboard’s structure. Tableau Features: Dynamic filters, calculated fields, and interactive tooltips for seamless user exploration. 3. Dashboard Structure A. Summary View Overview: Tracked headcount metrics (active/terminated […]

Dashboard Link. Click Here

Introduction: The project overview for bike share project Karan Github Link, objectives, and tools used (SQL and Power BI). Data Collection: Explanation of the dataset and its source. Importing the data into SQL. Data Cleaning: Removing duplicates. Creating new columns. Aggregating data. Using SQL queries for data manipulation. Data Analysis: Writing SQL queries to extract

About the Dataset The TripAdvisor dataset contains reviews and ratings for various hotels across different continents. This dataset includes details such as user reviews, hotel ratings, traveler types, periods of stay, and more. Data Transformation and Visualization After loading the CSV file into Power BI, it was observed that the ratings were in whole numbers.

About the Dataset Amazon Prime is one of the most popular media and video streaming platforms, with over 200 million subscribers globally as of mid-2021. This dataset includes comprehensive listings of nearly 10,000 movies and TV shows available on Amazon Prime. Each listing features details such as cast, directors, ratings, release year, duration, and more.

The primary goal of this project was to create a tool that provides stakeholders with a comprehensive and interactive view of key healthcare metrics. The dashboards facilitate data-driven decision-making, improve efficiency in data processing and visualization, and offer clear, actionable insights.