Based on the data sets involving OMT, you are going to develop pivot tables for the lab test questions and theory question to evaluate your level of understanding on the topics business information systems. Answer all questions and even experiment with the data to learn new things about it$.$

Answer these questions using your PIVOT Table:

Where do most of our customers come from? The answer might tell managers where to spend more marketing resources, or to initiate new marketing efforts. $(5$ Marks$)$

Where are the average purchases higher? The answer might tell managers where to focus marketing and sales resources or pitch different messages to different regions. $(5$ Marks$)$

What form of payment is the most common? The answer could be used to emphasize in advertising the most preferred means of payment. $(5$ Marks$)$

Identify and briefly describe all FOUR $(4)$ types of information systems that are predominantly used to manage organizational data within the different levels of management. Your description must include the major users of the system, its functions and capabilities and examples. $(20$ Marks$)$

Identify and briefly describe all THREE $(3)$ types of enterprise systems that are predominantly used to manage organizational data between departments, as well as with selected external parties. Identify any ONE $(1)$ business values and ONE $(1)$ challenges of each enterprise system. $(15$ Marks$)$