Product Table Illustration in Excel with Charts

 In this post we will be looking into the product table data and the chart illustrations in excel. The table and charts are presented below.

Product Table:



Product Table Bar chart:


Product Table Pie chart:



Comments

Post a Comment

Popular posts from this blog

Documentation: Customer database in Excel

Image
This post will document the customer database creation process in excel step by step with other tables in relation with the customer. 1. Creating User table (Customer table) The image below illustrates the empty user (customer) table in excel spread sheet with six properties id, first name, last name, email, address and phone. In this entity the user id is the primary key and the address is the foreign key from the address table shown below. The screenshot below illustrates the fully entered data in the user database table. 2. Creating Product table The second table in relation with customer table is product table which contains five properties they are id, title, description, price, and category id. Product id is the primary key and the category key is the foreign key in this table. The image below presents how the data is stored in the product table. 3. Order table This is the third table which stores the order information of users and it has seven properties they are  id, date, quan
Read more

4Ps of Marketing (Product, Price, Place, and promotion)

Image
( Krzywda, 2022 ) The 4 Ps of marketing, also known as the marketing mix, are four key elements that marketers must consider when developing and implementing marketing strategies for a product or service (Kotler & Keller, 2012). The 4 Ps include product, price, place, and promotion. Product refers to the goods or services being offered, and includes elements such as design, features, packaging, and branding (Kotler & Keller, 2012). Price refers to the cost of the product or service and how it is priced in comparison to competitors (Kotler & Keller, 2012). Place, also known as distribution, refers to the channels through which a product or service is made available to customers, such as retail stores, online channels, or through a direct sales force (Kotler & Keller, 2012). Promotion refers to the various marketing efforts used to communicate with and persuade customers, including advertising, sales promotions, public relations, and personal selling (Kotler & Keller,
Read more