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 […]
Bike Share SQL and PowerBI (Github Link Attached) Read More »
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.
Tripadvisor Power BI Dashboard Read More »
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.
Amazon Prime Power BI Dashboard Read 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.
Healthcare SQL and Power BI Dashboard Read More »