Create a medium size company and specify the following details:

Name of the company:

Industry:

Main activity:

Departments (name 5 at least):

Question 1.

Define the process of data collection and analysis that this company would follow in order to be able to achieve its goals.

(25%)

Question 2.

Define the software tools that would be necessary to be used in each department in order to perform its activities.

(25%)

Question 3.

If the company grows, discuss about the scalability of its systems.

(25%)

Question 4.

Create in Sheet 1 (in the Records.xlsx file), tables/charts to be used by the company in order to analyze data for the following tasks:

Create a small dashboard in excel, using two different graphs, to show two relevantKPIs of the company (you can choose the KPIs)

Create two formulas for two investment options to invest the net revenues from two different countries (with two different interest rates and two different compounding periods)