Business-Analytics-Demos

Several Business and Marketing Analytics Projects

1. NYSE data analysis

project link
Includes Problem solving dashboard, Profit&Loss statement, 2-year Forecasting model and presentation

2. Flight Delay Analysis Dashboard

project link
Tableau Dashboard URL: choose your best airline
Tableau Dashboard URL: Flights Delay Reasons Analysis
I used tableau to explore the data then made several dashboards and two stories which users can interact with and select the most satisfactory airline for their travel. The detailed design idea and dashboard explaination is in the report.
Airline delay data

3. Chinook Music Database Analysis

project link
chinook database
Database: SQLite
I used SQL and answered several interconnected questions for planning a concert.

Marketing-Analytics-Demos

1. Ecommerce Retailer Analysis

project link Best seller analysis
This is a UK ecommerce retailer who needs to decide their best sellers.

2. Udacity student survey analysis

project link
Analyse students surbey and find some insights

3. Google merchandise store analysis

project link
Google Analytics & Data studio
Explore and visulize data insights using advanced reporting techniques including customer segmentation, multiple display format and data studio dashboards.

4. Tesla Analytics brief

project link
Created an analytic brief to answer questions about business and customer to test and learn from marketing initiative.

5. 2018 & 2019 Black Friday Campaign Report

project link
Used advanced excel techniques to report on campaign performance and audience insights.