I got till the last step and my result is matching with the expected except the arrangement of the data for each column. I am unable to open the solution for the practice exercise.

pwbailey

LucieReveillere

y22m7p91

done

LaurenU

Oof, this one was a bit of a doozy. Glad I got to the solutions! Apologies for the bottom part of my workflow, it's super ugly. There is probably a better way. 😛

Its a big one!

Spoiler

Part 1:

Part 2:

Chibkay

Here's my solution

mikeanders

I think you are missing something! Your solution did not save properly!

Michella97

Done

siddhartha0208

it was a bit long - instructions were not clear. Solution isn't really meaningful in real use case.

suyashkashyap

Great!!

Anjana_R08

Done with exercise 4!

Exercise Solved

practice exercise 4!

Solution

Product mix, also known as product assortment or product portfolio, refers to the complete set of products and/or services offered by a firm. A product mix consists of product lines, which are associated items that consumers tend to use together or think of as similar products or services.Consumer products. A consumer product is a finished product available for sale to a customer. ...
Industrial products. Businesses usually purchase an industrial product to make other products or to help them with running their business. ...
Service products.

Shaikmunnisa

Consumer products. A consumer product is a finished product available for sale to a customer. ...
Industrial products. Businesses usually purchase an industrial product to make other products or to help them with running their business. ...
Service products.

Shaikmunnisa

product category is a group of similar products that share related characteristics. Product category marketing focuses on promoting certain categories to meet consumer expectations.

ikea

orvis

fenty beauty

swarovski

target

dove

michaels

Shaikmunnisa

general terms, the demand and the supply of
maritime transport services interact with each other
to determine freight rates. While there are countless
factors affecting supply and demand, the exposure of
freights rates to market forces is inevitable.
Cargo volumes and demand for maritime transport
services are usually the first to be hit by political,
environmental and economic turmoil. Factors such as
a slowdown in international trade, sanctions, natural
disasters and weather events, regulatory measures
and changes in fuel prices have an impact on the
world economy and global demand for seaborne
transport. These changes may occur quickly and have
an immediate impact on demand for maritime transport
services. As to the supply of maritime transport services,
there is generally a tendency of overcapacity in the
market, given that there are no inherent restrictions on
the number of vessels that can be built and that it takes
a long time from the moment a vessel order is placed to
the time it is delivered, and is ready to be put in service.
Therefore, maritime transport is very cyclical and goes
through periods of continuous busts and booms, with
operators enjoying healthy earnings or struggling to
meet their minimum operating costs.
In 2012, the maritime sector continued to experience
low and volatile freight rates in its various segments
because of surplus capacity in the global fleet
generated by the severe downturn in trade in the
wake of the 2008 economic and financial crisis. The
steady delivery of newbuild vessels into an already
oversupplied market, coupled with a weak economy,
has kept rates under heavy pressure, as described
below.

Shaikmunnisa

Associate the appropriate "Shipping Method" with each order based on its "Order_Priority".

Then combine the "Product Categories" information with the "Product Details" info (the headers in Product Details are product SKUs).

Finally, combine both datastreams to flag all orders which contained "Technology" items and were sent via "Freight". Mark those orders with "REVIEW" and all others with null..................................

Shaikmunnisa

Associate the appropriate "Shipping Method" with each order based on its "Order_Priority".

Then combine the "Product Categories" information with the "Product Details" info (the headers in Product Details are product SKUs).

Finally, combine both datastreams to flag all orders which contained "Technology" items and were sent via "Freight". Mark those orders with "REVIEW" and all others with null.product category is a group of similar products that share related characteristics. Product category marketing focuses on promoting certain categories to meet consumer expectations.