The dataset used for this analysis called Sales_DB comprising of eight (8) tables with fields namely: Category, Customers, Employees, Orders, Order_details, Products, Product_details, Suppliers and Shippers. i created the tables using import/export feature in pgAdmin, the csv file was loaded into the database. But before loading the data into pgAdmin, I had issues with the date column in the ‘employee’ and ‘orders’ table, as it was loading as a data type ‘text’ instead of ‘date’. I loaded the data into Power Query and cleaned by splitting the date columns using ‘slash’ as delimiter then separating the table then merged the figures in a new table and was able to change data type to ‘date’.

For better understanding of the relationship between these tables in the database, I created an Entity Relationship Diagram. it is very important as it shows the relationship, the connection between various tables in a database. An ER diagram gives a better understanding of the overall database structure. As seen below is an image of the diagram.

I was able to answer different questions using several query commands, functions and language. The query results of each question answered was downloaded as csv files. These csv files were then visualized using excel.

NUMBER OF CUSTOMER FROM EACH COUNTRY?

From the the results USA has the largest customer base closely followed by GERMANY, and the countries with the least customers being POLAND,NORWAY AND IRELAND each having 1 customer respectively.

AVERAGE PRICE

The average price for the products listed is 29. I used subquery to categorize the range of the price as below average, average and above average i.e. products below the average price of 29 was categorized as ‘below average’, when the price is 29 then ‘average’, lastly products above the average price of 29 were categorized as ‘above average’

TOP 10 MOST EXPENSIVE PRODUCTS

From the chart above, the most expensive product is ‘Cote de Blaye’ and its having a cost of 263.5, which is a big price difference compared to ‘Thuringer Rostbratwurst’, ‘Mishi Kobe Niku’, ‘Sir Rodney’s Marmalade’, having a price range of 123.79–81 respectively. ‘Rossle Sauerkraut’ is the least expensive product with a cost of 45.6 in the chart.

TOP 10 SELLING PRODUCTS BASED ON ORDER

The chart above shows the top 10 highest selling products based on orders from customers. in the chart, these products high orders by customers . From the chart most of the highest selling products ae above the average price that is 29.

TOP SELLING PRODUCTS BASED ON QUANTITY

The query and chart shows the top 10 sold out products based on quantity ordered by the customers. Reviewing the chart these products are on high demand by customers. Also majority of the most sought-after products are below the average price of 29.

BEST PERFORMING EMPLOYEE

In the chart above, the employee with the highest number of sales is ‘MARGARET PEACOCK’ who has a total sales of 3,232 products then ‘ANNE DODSWORTH’ is the employee with the least performance with a total sales of 649.

SUPPLIERS FROM EACH COUNTRY

The chart shows the top 10 out of 29 suppliers in the last 2 years based on thenumberofproductstheyhavesupplied‘PLUTZERLEBENSMITTELGROBMARKE AG’ and ‘PAVLOVA LTD’ both supplying 5 products each.

MOST PREFFERED SHIPPING COMPANY

For the most preferred shipping company ‘United Package’ have the highest preference with 38% while ‘Speedy Express’ is the least preferred having 27%.

I hope you enjoy reading my little analysis.

Thank you

I made use of Flipkart Mobiles Dataset which was gotten from this link; https://www.kaggle.com/datasets/devsubhash/flipkart-mobiles-dataset, In this article I would be analyzing the rating, Mobile Brands with the most premium offerings as regards to spec and also analyzing the profit/loss of the brands.

The dataset includes data on 17 mobile phones brands. Information like Model, Color, Memory, Storage, etc. are present which distinguishes one product from another. At least one attribute distinguishes each product. Dataset contains some missing values so i replaced with NaN. There are 8 columns and 3114 rows.

Brands with Most Product Offering

Samsung offers the most options, as seen on the BarCharts. In terms of models, they have a broad range of phones to select from. IQOO, on the other hand, has the fewest alternatives.

Analyzing The Spec

The Chart above shows that there are around 73 mobile phones with 3GB of ROM which is the most Memory offered by the phone brands. The bar graphs above also indicate the count of different products based on the Specs— Storage, Memory, with Samsung being the brand with the highest count.

COLOUR WISE PRODUCT COUNT

The Pie chart shows the 10 most common color, with black being the most offered color by the brand followed by gold and grey.

Analyzing the Ratings

87% of the total model of brands were rated above 4.0 which was about 2573 models while 397 were rated below 4.0. Apple is the brand with the highest average rating, also having about 6 models among 10 most rated model brands while Gionee has the lowest Average rating as a mobile brand.

ANALYZING THE PROFIT/LOSS

From the chart, we can see most of the mobile companies in loss with Samsung having the highest loss and HTC having neither a loss nor profit, iPhone XS is the mobile brand model with the highest loss.

CONCLUSION

According to the data, most of the mobile brand are running into huge losses with Samsung having the highest loss even as it is the Brand with the variety of model to choose from and it is also the mobile the the highest spec in terms of storage and memory. Also the brands with the highest user ratings have the highest losses.

Thank You For Reading!