1. Number of Card Types: 4

2. Average Bank Products per Customer: 4

3. Average Credit Utilization Ratio: 0.27

4. Average Inactive Months: 2

5. Demographic Analysis

6. Credit Card Usage

7. Behavioral Trends

1. Jackets dominate sales ($401K) and pricing, making them Zara’s most profitable product line.

2. Cotton and polyester are the key materials, reflecting affordability and versatility.

3. Production is Asia-centric, with China and Bangladesh leading in price contribution.

4. Seasonality matters: Autumn and Winter drive the highest sales, showing Zara’s strength in outerwear.

5. Jeans underperform, suggesting a weaker position in denim compared to competitors.

1. Calculate the total revenue from the orders table.

2. Which pizza had the highest number of slices sold?

3. Calculate the average number of orders per day.

4. How many orders were placed on weekends (Saturday and Sunday)?

5. Calculate the total revenue for each type of pizza.

6. Calculate the revenue percentage for each pizza type.

7. Which day had the highest total revenue?

8. How many orders included only large-size pizzas?

9. Calculate the average revenue per order.

10. Display number of orders per hour using order time.

Based on the dashboard provided, here is a summary of the key data points and trends:

Financial Performance

• Total Sales: 2,297,201

• Total Profit: 286,397

• Growth Trend: Sales have nearly doubled over four years, growing from 49,544 (2015) to 93,439 (2018).

• Profit Share: 2018 was the strongest year, contributing 33% of the total profit.

• Volume: The company handled 5,009 orders for 793 customers across 1,862 products.

• Logistics: The average shipping time is 4 days.

• Geographic Reach: Active operations in 531 cities.

I prepared a sales dashboard summary, database from Kaggle.com, about retail sales data (2019–2020) from an online store

KPIs:

1. count of countries the store is selling at

2. total cost & total order value

3. count of categories

4. count of devices

5. count of orders

Objectives:

1. top 5 countries by profit

2. categories by order value

3. device type by order value

4. progress in 2020-2019

5. conditional if for device type & order value(expensive, cheap)

6. category by country

7. progress per month9- top 10 customers by order value 

This dashboard was a comparison between Disney and Netflix sales as 2 platforms providing video on-demand over-the-top streaming services.

analyzing :

1. Audience 

2. Movies and series

3. top 5 countries producing on each platform

4. Category of films whether (action, comedy, horror, science fiction,...etc.)

This dashboard is about the sales of a company producing TVs, Mobile phones, and Tablets.

Analyzing  : 

1. Total sales

2. Total profit

3. total cost

4. number of orders

5. number of customers

6. each device share in the market

7. Top 5 countries by profit

8. Progress in 2019 and 2020

this Dashboard was about a company's sales

analyzing : 

1. Total units sold

2. Total sales 

3. Total profit

4. Average of sales

5. Percentage of Profit 

6. Gross sales by product

7. Profit per month

8. Sales per month

This dashboard was to analyze Udemy company's data and sales.

analyzing : 

1. Total number of courses

2. Percentage of free courses 

3. Percentage of paid courses

4. Total sales in million dollars

5. Total sales in percentage

6. Average number of subscribers

7. Total number of courses for beginners 

8. Total number of courses with intermediate level

9. Total courses of Expert level courses

10. Average of courses ratings by year

11. Total sales per year

12. Number of courses published per year

This dashboard evaluates students' grades in a school.

analyzing:

1. Total students

2. number of sessions given

3. number of topics included

4. total students in each country

5. grades of students by their nationalities

6. grades of students based on absence

7. grades of students in each class

This dashboard aimed to analyze employees' data in a company.

by analyzing:

1. number of employees.

2. average salaries.

3. number of departments

4. salaries in each department.

5. analyzing work-life balance and job satisfaction by job title

6. employee performance.

7. average incomes by job level.

8. fields of study.

9. employee training sessions and promotions.

This dashboard evaluates students' grades in a school.

analyzing:

1. Total students

2. number of sessions given

3. number of topics included

4. total students in each country

5. grades of students by their nationalities

6. grades of students based on absence

7. grades of students in each class

This dashboard analyzes the sales in a company.

analyzing:

1. profit each year

2. sales each year

3. sales by region

4. sales in different countries yearly.

5. sales by segment.

This dashboard aims to analyze the products sold in the last 4 years based on the following:

1. Total profit.

2. total countries

3. total products sold

4. profit by year

5. total quantity by product size

6. total sales by year

KPIs

1. # empolyees

2. # departement

3. # location

4. # المؤهلات الدراسية

5. # وظائف

Objectives

1. work experience

2. ages

3. Performance = 2020-2019

4. Salary