SQL data analysis & visualization projects using MySQL, PostgreSQL, SQLite, Tableau, Apache Spark and pySpark.

India based Hardware company Sales Insights - A Data Analysis Project performed on Tableau & SQL

Tasks and projects solved while passing a Data Analysis course: Python, Pandas, Numpy, Seaborn, Google APIs, Git, Airflow, SQL, ClickHouse, PostgreSQL, Redash, Supersеt, Statistics, A/B-tests, Bootstrapping, Amplitude, Tableau, DAU, MAU, ARPU, LTV, Retention and other metrics.

HR Analytics: A Complete Employee Data Analysis Project using Tableau Dashboard

Tableau Projects for data analysis, data analytics and data visualaization on different data sets

These are my personal data analysis projects. I mainly used R/Python programming for my data analysis. And also used BI tools such as Tableau and Power BI to build dashboards.

This is a case study for one of Google's Data Analytics Professional Certificate capstone project. Within, you'll find my written analysis report along with a link to my recorded presentation on youtube and visuals on tableau public.

This repository contains Tableau dashboard, visualization, and data analysis projects I have created.

Course included such topics, as Data Preprocessing, Exploratory Data Analysis (EDA), Statistical Data Analysis (SDA), Data Collection and Storage (PostgreSQL), Business Analytics, Making Business Decisions Based on Data (Hypotheses testing), How to Tell a Story Using Data (Presentation and Data Visualization - Maplotlib, Seaborn, Plotly), Automation (Dash, Tableau), Forecasts and Predictions, 2 Integrated projects.

Explore my data-driven journey! This repository showcases a collection of my SQL and Tableau projects, ranging from exploratory data analysis to data visualization. Dive into real-world applications, demonstrating my skills in extracting insights, handling diverse datasets, and making informed decisions. 📊

This Tableau project aims at visualizing and analyzing Air Pollution in India. Air Pollution is a major disaster which is slowly growing. The data set used for this analysis is attached in the repo.

A collection of data analytics projects and exercises using Python, KNIME, and Tableau. Includes notebooks, workflows, dashboards, sample datasets, and reusable code for data cleaning, analysis, and visualization.

Collection of projects related to Data analysis. Projects ranging from Python, Tableau, Excel, and SQL.

This MySQL-Tableau project is a cloned mimic version of Instagram's Database. I performed data analysis and answer real-world business-related questions.

This is my projects portfolio. It contains my Data Analysis Projects using Python, SQL, Excel, Tableau, and Power BI.

Amazon Shipping Analysis - Tableau 📦📊 This project presents a data-driven analysis of Amazon’s shipping operations using Tableau. It examines shipping efficiency, delivery performance, cost distribution, and regional shipping trends to uncover key insights and patterns in Amazon’s logistics.

The Formula 1 Data Analysis project is a comprehensive exploration of the world of Formula 1 racing through the lens of data analytics. This project combines the power of SQL for data manipulation and Tableau for data visualization to provide insights into the thrilling world of Formula 1 racing from 1953-2020.

This program includes over 180 hours of instruction and hundreds of practice-based assessments, which will help you simulate real-world data analytics scenarios that are critical for success in the workplace. The content is highly interactive and exclusively developed by Google employees with decades of experience in data analytics. Through a mix of videos, assessments, and hands-on labs, you’ll get introduced to analysis tools and platforms and key analytical skills required for an entry-level job. Skills you’ll gain will include: Data cleaning, problem solving, critical thinking, data ethics, and data visualization Platforms and tools you will learn include: Presentations, Spreadsheets, SQL, Tableau and R Programming In addition to expert training and hands-on projects, you'll complete a case study that you can share with potential employers to showcase your new skill set. Learn concrete skills that top employers are hiring for right now.

Contains Data for Analysis.Tableau Workbooks and Dashboard Projects

A data analysis project on the most popular podcasts on Spotify in Germany in December 2022, including scraped data, cleaned and enriched data, a Jupyter notebook, and images for a Tableau presentation.

End-to-End Data Pipeline for Sales Analysis: This project showcases a data pipeline using Snowflake, dbt, and Tableau to transform raw sales data into structured insights. It employs incremental data processing for optimized performance and features a star schema design for efficient querying and reporting.

For the last few years Betfair is losing too many customers and is finding a solution to retain its customers. Aim of this project is to build a customer churn model to predict the customers who are about to get churned so that Betfair can implement different business strategies to retain those customers before they actually leave. The tools I am using for this analysis are R-studio and Tableau. Package mlr was chosen as the modeling package. The data for the purpose of prediction was provided by Betfair. After proper data exploration and visualization, important features for the customer churn prediction model was identified. The 8 different classification models were applied on the data in separate steps of configuring the learner task, making the learner, training the learner, prediction and performance evaluation. Out of the 8 different models, Random Forest was chosen as the best model. Cross-validation was done using random forest was done and obtained a mean miss classification error rate of 0.1278126. Hyper-parametric tuning of the random forest model was performed using package mlrHyperopt. There was only 0.05% improvement in the model accuracy after Hyper-parametric tuning. The model obtained is good enough to predict the customers who are about to fall in the churned customer category. Applying this model on the real-time data in Betfair can save huge money in revenue.

Sales analysis project using Tableau and Superstore data

[SQL, Tableau, Excel, Finance Domain knowledge]. A comprehensive end-to-end financial data analysis project which involves ETL data using SQL queries, analyze and visualize the data using the powerful features of Tableau & Excel.

Data analysis project using Python, Jupyter, and Tableau/Power BI, including data cleaning, EDA, and dashboards.

This repository contains business-related data analytics projects using Excel, Python, Tableau, and StatPlus. The projects cover tasks like survey data analysis, brochure demand forecasting, and movie data visualization, showcasing data processing, analysis, and visualization techniques.

The project aims to analyze the Energy Consumption Patterns and it's relationship with socio-demographic and weather indicators for European cities like London, post the installation of Smart Energy Meters over a period of 30 months. Exploratory Data Analysis was performed on Tableau and Python. Data Preprocessing was done using Spark and a variety of Machine Learning Algorithms were utilized to perform Time Series Forecasting.

📊 Customer Engagement Analysis project using SQL for data exploration and Tableau for visualization. Includes queries on purchases, watch time, and seasonal trends, along with insights and recommendations for improving pricing, marketing, and course strategy.

This repository contains a comprehensive analysis of Airbnb listing data, exploring trends in pricing, availability, and geographic patterns using Tableau visualizations. It includes key insights, project files, and a presentation summarizing the findings. Future enhancements may incorporate predictive analysis and an interactive web dashboard.

A project which deals with designing an Enterprise Data Warehouse (EDW) by dimensional modelling utilizing star & snowflake schemas including components such as Slowly Changing Dimesnions (SCD), Role-Playing Dimensions, Junk and SOR Dimensions to maintain historical and current data effectively, examining and addressing data quality gaps by transforming and cleansing data such as reformatting, consolidation, and validation, in order to maintain clean, consistent, conformed, current and comprehensive data and various KPI's in the EDW using Talend, implementing data integration by ETL workflows using Talend for migrating data from the operational ERP system to EDW on platforms like Oracle, MySQL, PostgreSQL 12 and MS SQL Server 2017, enabling data profiling and designing interactive dashboards to analyze and capture trending movies, their box-office analysis, audience ratings and lifetime gross on IMDb using Tableau and Power BI