In Progress

Information Analysisx

You are required to develop an information system based on a fictional company of your choice. The company is a small business that has a number of branches. There are a number of sales personnel working in each branch. Sales personnel can be reassigned to other branches to work. The owners of the company wish to have an information system that gives them up to date information about the current status of the business.

The company only has limited computing resources and little technical skill and you are required to develop a system that uses a dashboard interface to display important trends and to perform analysis more quickly and easily. The company’s most urgent need is to have information concerning the profitability of the product they are selling; the profitability of its branches; and the performance of their salespeople. The company would like to use the system for forecasting and analysis purposes and therefore expects it to be constructed in such a way that data can be varied and results calculated automatically.

You may assume the following for simplification purposes:

• You have only nine months of trading data available in the company.

• The company has five sales personnel.

• The company has four branches.

• The company only sells 8 different products.

You must provide at least four different interactive visualisations for the owners. An example of a useful interactive visualisation might be the following:

• A chart that shows the overall sales per month in the nine months of trading. Allow the owner to further select a specific product to see its sales over the six months.

• A chart that shows average sales per Staff.

• A chart that shows overall sales per product.

The system must be tailored to the company chosen by you. List any assumptions that you make in modelling the business. You must compile a report and demonstrate your system at the end of term.

Skills: Business Analysis, Excel, Research Writing, Software Development

See more: salespeople required, uses for excel, product profitability analysis, excel uses, modelling and analysis, information system, data forecasting, business modelling, interactive excel, data trends excel, excel based dashboard, excel sales performance report, profitability analysis, date analysis excel, analysis dashboard, status list excel, salespeople, sales performance analysis excel, compile list business, excel compile report, performance dashboard excel, compile excel data month, end end technical sales, excel performance dashboard, list status excel

About the Employer:
( 22 reviews ) Petaling Jaya, Malaysia

Project ID: #7407857

Awarded to:

farr4u

Hi, expert here ready to start.. I will give you a very good application for your requirements and at a relatively low cost, thanks.

$45 USD in 3 days
(25 Reviews)
4.1

13 freelancers are bidding on average $54 for this job

Xazoo

Hello! If you want your project to be done by a qualified and professional academic writer; please feel free to contact me at your earliest. I am as excited as you to present this paper in wonderful style. I always com More

$63 USD in 3 days
(586 Reviews)
8.2
erinkennedy

HI, I would like to use my experience to serve you better. You can trust my sincere indulgence both in quality and time frame. If you will give me a chance, I will ensure that you're satisfied. I'm really interested in More

$65 USD in 1 day
(184 Reviews)
7.0
alibutt2014

A+ ACADEMIC WRITER HERE ----------- Ready to start this work, expect HIGH QUALITY from me. Looking Forward.......Thank you!

$54 USD in 3 days
(138 Reviews)
6.8
RafNancy

-Being an experience academic writer and well researcher. I am 100% confident I can do this project perfectly. I have already written PhD and Masters Level Paper for UK and US Students and I can easily work on it. I a More

$55 USD in 1 day
(139 Reviews)
6.4
Emam9109

Hi, I am a professional writer, and I have some expert academic writers. They are very proficient. I always check and recheck before sending to the client. Do not worry about deadline. I am eagerly waiting for yo More

$93 USD in 3 days
(84 Reviews)
6.2
samin59

Experienced and accomplished ACADEMIC WRITER available to provide quality work. Please contact for future consideration. Regards

$75 USD in 1 day
(123 Reviews)
6.3
BDSEO

A proposal has not yet been provided

$54 USD in 2 days
(33 Reviews)
4.7
VirtualBrainInc

No sub-contacting your work, my work speaks for itself. A mute testimony to all my claims are the abundant glowing reviews attributed to me from clients in countries like UK, USA, UAE, Malaysia, Australia and Canada, w More

$35 USD in 1 day
(41 Reviews)
5.1
uksyashmak

Hello I have been writing since long time and [url removed, login to view] is just a platform for me. I do extensive research on topic and come up with excellent quality paper. I am familiar with Referencing style APA, MLA, Harvard, More

$50 USD in 1 day
(24 Reviews)
4.5
akshay175

Hi, I am an expert in MS Excel, MS Access, SQL database production and management. I have over 7 years of experience in working with all of the databases and analytics. I am a financial engineering graduate and have e More

$84 USD in 5 days
(12 Reviews)
4.0
leelaaswanth

Will give you 100% accurate and efficient output............thank you..................................

$50 USD in 1 day
(9 Reviews)
2.9
vivirain

一个有效的提议尚未被提供

$50 USD in 5 days
(1 Review)
1.7
ucbenli

Bir öneri henüz sağlanmadı

$50 USD in 3 days
(1 Review)
0.7
kamalsurani

A proposal has not yet been provided

$35 USD in 1 day
(0 Reviews)
0.0
gildamchaves

La propuesta todavía no ha sido proveída

$83 USD in 3 days
(0 Reviews)
0.0