Business profit analysis
FOCUS ON MYSQL, EXCEL & POWER BI
Project 1 new page
About dataset:
This dataset comes in 3 tables in .csv format and holds up to 2070 records, as follows:
– bookings: including data about tours transactions, payment method etc
– customers: date of birth, gender, nationality etc
– prices: mainly about tours prices and discounts
Besides, I will include a public dataset about local and international visits to London during the same period for various purposes i.e. leisure, business, and visiting friends and relatives (VFR).
Metadata:
Here is a glossary of definitions for the variables (fields) used in the dataset:
— invoice no
— tour id
— tour category
— tour name
— base price
— adult
— child
— student
— senior
— total paid
— tour status
— date and time
— booking pos
— payment method
— club card
— rating %
— customer nationality
— customer username
— customer gender
— customer age
The task:
To draw acionable business insights that can help the company improve on sales by giving a specific set of recommendations and supporting analysis based on the data. And, to create a visual story (dashoard) to share with stakeholders that help them asnwer business questions relating to profits and better customer undersatnding.
Project pipeline:
1- Cleaning and organising the data in spreadsheets
2- Building database and developing the SQL query
3- Visualising the data using Tableau
4- Summarising the findings to stakeholders