This repository contains all the necessary files and documentation for a detailed analysis of bank loan data using a combination of SQL, Power BI, Excel, and Tableau. The project aims to uncover insights related to loan applications, funding, repayments, and borrower demographics, facilitating data-driven decision-making in the banking sector.

🔥 人人可用的开源数据可视化分析工具，帆软、Tableau 等商业 BI 工具的开源替代。

A daily auto-updating interactive dashboard project to visualize the impact of community's mobility to daily new COVID-19 cases by leveraging the data from MOH Malaysia, Google, Apple, Waze and TonTon. https://public.tableau.com/views/COVID-19MobilityDashboard/MobilityTrends (Tableau) https://datastudio.google.com/reporting/54616e0e-19c9-4097-bc…

This is the repo for all the practical works, assignments, projects done during the PW skill Data Science Masters 1.0 course.

Data Analyst-Portfolio

Data Science Case Studies for computer science students.

In this project, I utilized SQL and Tableau to analyze sales data for Maven Roasters, a fictitious coffee shop with three locations in NYC.

A comprehensive Data analysis project using SQL for data cleaning and pre-processing and Tableau for visualization, focusing on key HR KPIs. Features interactive dashboards and detailed insights.

Churn Analysis of Telecommunications Company Data using Tableau.

A Python library for the Tableau Server REST API

The Food-Facility-Compliance-Engine leverages advanced ETL and BI technologies to process and visualize inspection data from Sonoma County's official government database, boosting compliance and safety in local food facilities.

FilmFlux Analytics : An advanced ETL-to-BI pipeline, transforming movie data into dynamic insights with Alteryx, MySQL, and Talend, visualized through Power BI and Tableau dashboards.

An SDK for building your own application to migrate to a new Tableau environment.

This project analyses customer churn data for a telecom company in California, covering 7043 customers in Q3. It identifies reasons for churn and uses Tableau to visualize insights and patterns.

It consists through a range of chart types, customized computations, and interactive capabilities for a thorough examination of data trends and patterns, it analyzes the Superstore sales statistics in Tableau and presents crucial insights.

This case study simulates the real-world experience of a junior data analyst at Cyclistic, a fictional company. We will leverage the data analysis process framework (Ask, Prepare, Process, Analyze, Share, Act) to address critical business questions and provide data-driven insights to guide strategic decision-making.

Data Collection,Processing,EDA,visualization,application of machine learning to drive insights for given use case

This Python project was part of CareerFoundry's Data Analytics course in which I analyzed the data of hate crime victims in the United States between 1991-2018

Explore dropout rates and success metrics among students across various academic disciplines.

Yelp data analysis of business rating, categories, any trends/patterns, correlation, etc.