Analyse company data to anwser this questions

• Number of orders for each Manufacturer

• The profit that each Manufacturer makes

• Which country makes the highest profit?

• Which product subcategory makes the highest profit?

• Which manufacturer that sells each Product subcategory makes the highest profit?

1. A. Datum Corporation --> [Digital Cameras]
2. Adventure Works --> [Laptops, Televisions, Desktops]
3. Contoso, Ltd --> [Home Theater System, Cell phones Accessories,...
4. Fabrikam, Inc. --> [Camcorders, Digital SLR Cameras]
5. Proseware, Inc. --> [Projectors & Screens, Printers, Scanners & Fax]
6. Southridge Video --> [Car Video, VCD & DVD]
7. The Phone Company --> [Smart phones & PDAs , Touch Screen Phones ]
8. Wide World Importers --> [Monitors, Recording Pen, Bluetooth Headphones]