Data Visualization and Business Analytics Techniques

This report discusses the importance of data visualization and various business analytics techniques that Small Appliances Specialists can use to normalize its data. It also highlights the benefits of using business analytics for Small Appliances Specialists.

Student Name
Student ID 1
Business Information Systems - ISYS2109
Submitted By
Course
Professor
Date

Student Name
Student ID 2
Introduction
Data visualization includes exhibiting information in graphical or pictorial shape which makes
the data very simple to understand. There has been the requirement for showing monstrous
measures of information in a way that is effortlessly open and also easy accessible. Associations
produce information consistently. Therefore, the measure of information accessible on the Web
has expanded drastically. It can be challenging for clients to envision, investigate, and utilize this
gigantic information. The capacity to imagine information is essential to logical research.
Information Visualization advances enable people 'to see' information and change substantial
quantitative informational collections into valuable data with endless associations depending
vigorously on these devices for better decisions and business insight. In this report, we will
discuss about business analytics techniques that Small Appliances Specialists can use to
normalize its data. (Pamela and Olsen, 2014).
Business Analytics
Business Analytics is considered as vogue innovation for business association. It alludes to the
data generation as well as utilization of information and insight for applying decision making
process in order to have better strategic business objective. This process mainly incorporates
managing decision, content investigation, planning as well as anticipating, disclosure analytics,
business insight, prescient analysis, content management, stream figuring, information
warehousing, data joining and also governing big data. (Rachida and Thambusamy, 2017).
The three types of business analytic techniques are given as following:

Student Name
Student ID 3
SWOT Analysis - The SWOT Analysis is known for Strengths, Weaknesses, Threats and
Opportunities Analysis. This technique is considered as enterprise level analysis strategy of
evaluating an association against these four measurements.
Business Process Modeling (BPM) - Business Process Modeling is known as diagrammatic
portrayal of the successive work process of data, procedures as well as decisions for a specific
business process.
Data Modelling - This BA Technique is tied in with portraying a prerequisite as far as its
information components. This technique of data modelling is utilized to depict various entities
like items, individuals, places and so forth of which information is to be caught and ascribes for
all the entities for recording data. (Business Analysis Excellence, 2018).
Business Analytics help Small Appliances Specialists
As we know that Small Appliances Specialists is electronic retailers, who purchases its
appliances from various manufacturers and then sells these to the customers. This is basically
sale purchase business. It becomes difficult for the organization to maintain data in excel or in
manual records which further difficult to calculate overall revenue of the organization. Business
analytics can make information better by using prescient analysis and will also forecast the
reaction of customers while having interfacing with brands. It can help to have accurate
perspective of a client to settle on the decisions about how best to secure and hold clients,
recognize high-value clients and proactively cooperate with them. (Michigan State University,
2018).
Data Visualization

Student Name
Student ID 4
Data visualization is defined as main component in business as well as in data analytics, that
allows data analysts in organizations for developing tools like dashboards that can help business
administrators. This process includes introducing information in graphical or pictorial form that
makes the data simple and very easy. (Diamond and Mattia, 2018).
Charts – Chart causes the audience to get the idea visually on the data which needs to be
forwarded to top management. Charts are very advantageous when there would be incredible
arrangement of subtleties that would use more time for passing the entire information.
Graphs – 1. All business administrators can see the graphs initially and can settle on better
decisions which is not really possible through many descriptive reports.
2. Graphs can be satisfactory to the busy people since it effortlessly features about the topic of
the report. This keeps away from wastage of time.
3. It provides better analysis of data. (Rasel, 2013).
Maps - Business process mapping (BPM) can be defined as the key analysis of recognizing as
well as making a visual delineation of the process flow of many parts of the association. This
BPM of a business procedure makes a visual procedure portrayal. This can be possible via an
intricate data flow outlines and diagrams. (Henderson, 2018).
Pivot Chart

Student Name
Student ID 5
2 slice Toaster
4 slice Toaster
Icecream Maker
Kettle 8 cup
Microwave
Rice Cooker
Sandwich Press
Slow Cooker
Steam Iron
Stick Blender
0
500
1000
1500
2000
2500
3000
3500
4000
4500
5000
Count of Product Id
Sum of Profit
The main problem in this pivot chart is that profit percentage is much higher as compared to
number of products sold. MSRP price is much higher for the products as compared to buying
cost. The organization must have some particular percentage of profit from purchase price.
Database Design
ERD Diagram

Student Name
Student ID 6
Benefits of Relational Database for Small Appliances Specialist
Essentially, relational databases depend on relational hypothesis. Normalization is very
important part of the relational model of databases. Various relational operations that are upheld
by relational databases work best with normalized tables. In given scenario, relational database
helps to organize data in normalized tables with minimum redundancy. This can help to fasten
queries as well as will occupy less memory space. Table structures can be effortlessly
comprehended by the clients, which makes it less difficult for them to utilize it. Relational
databases can support an essential idea of dynamic perspectives. These database structures give
phenomenal security. They can provide various access authorizations which enable the database
manager to actualize require based consents to the access of information in database tables.
(Techspirited Staff, 2018).

Student Name
Student ID 7
Ethics in Business
Business Ethics' can be named as the analysis of appropriate business policies as well as
practices on with respect to possible issues like corporate administration. New patterns and
issues emerge once a day which may make an essential pressure to associations and end clients.
These days, the requirement for proper moral behavior inside association has turned out to be
essential to maintain a strategic distance from various lawsuits. Business morals ensure different
social gatherings including buyers, workers, small businesspersons, government, investors,
creditors, and so on. (Salehi and Saeidinia, 2012).
Cybersecurity
Cyber security is characterized as advancements and procedures that are developed to secure
PCs, hardware devices, programming, network systems as well as information from unauthorized
access, vulnerabilities that are provided through Internet by digital hackers. Digital security is
identified with securing web as well as network based advanced supplies and also data from any
type of unauthorized access and modification. Internet is considered as main source of
information and can be used as the source for promoting and moving various items in other
forms, communicate with the clients as well as the retailers for performing various financial
transactions. Also, various security challenges exist in various businesses due to restricted assets
as well as appropriate digital security skills. (Goutam, 2015). Various methods to minimize the
risks are given as following:
1. Firewall - A firewall is software or the hardware device that helps to monitor all the activities
of hackers, viruses as well as worms that are able to access the system over the Internet. Firewall

Student Name
Student ID 8
is responsible to monitor all messages that enter or leave the network system, which analyzes
each message and furthermore analyzes those that don't meet the foreordained security criteria.
2. Anti-virus software - Antivirus programming is the software installed into the system that
recognizes, foresees, and also makes a move to cripple or remove any type of virus from the
system. (Reddy, nd).
Business Solutions
System Thinking
System thinking is defined as the technique for critical reasoning by which one can analyze the
connection between the framework's parts to comprehend a circumstance for better decision
making process. As opposed to segregating an issue and making it settled, this system thinking
approach can analyze any type of emerging issue. Through this systematical methodology, causal
impacts are perceived and an issue space can be analyzed.
By having knowledge about systems thinking as an all-encompassing perspective view, which
emerges its real value. The value itself is having the capacity to utilize this all-encompassing
perspective point of view to distinguish a genuine issue, while understanding the all-inclusive
interconnected system that encompasses it. Customary analyzes centers around isolating the
individual parts of the issues caused though systems thinking that enables organization to
concentrate on how the individual parts associate with one another and distinguishes the reason
for an issue. (Das, 2018).
5 Steps of Problem Solving
Step 1: Pin the Problem

Student Name
Student ID 9
Analyze and characterize the current issue. The business must look at the issue from different
points of view. What might CEO recognize as the issue? clients? Your other stakeholders?
Step 2: Identify the Issues
Differentiate the issue into subcomponents. For instance, profit issue needs to be divided into
income issues and cost issues. The income side divides further into cost and volume issues.
Step 3: Generate Hypotheses and Prioritize Proving Them
When the organization has found all issues, they must consider approaches to illuminate every
one. Don't really start placing arrangements without hesitation - simply recognize possible
solution for each issue. Those solutions turn into the theories that the organization will organize,
examine, and assess.
Step 4: Conduct Your Analysis
The investigation is an engaged effort intended to demonstrate or negate the essential theory. It's
an important arrangement, that the organization has some effect and, proceed onward to the next
idea.
Step 5: Advance Your Answer
After that, there must be some recommendation or suggestion so that it gets executed. The
organization must start by changing that speculation into a plainly worded proposal. Have the
center investigations required to show the case. (Figliuolo, 2018).
Issue with Small Appliance Specialization in Near Future

Student Name
Student ID 10
The organization can face many issues in coming time. With the increase in business, it will be
difficult to organize all data centrally. Also, it will be difficult for them to organize all financial
data which includes ledger, revenue generation, profit margin, reducing costs etc. Hence, they
need to hire financial consultants so that all the accounts statements will be processed
automatically. As it depends on the business, an advisor or we can say consultant can be hired
who can help in various areas. Also, they need to have customer centered system in order to have
better customer services.
Controlling cash in an effective way is imperative for the given business. In terms of developing
business, the financial objectives can be the best factor obliging advancement of the business. By
making best utilization of the finance ought to be a key component in planning new strategies
and evaluating better options. Great stock control and successful provider the board will in
general turn out to be progressively imperative as the organization develops. Small appliance
specialization mainly depend on expansive volumes of data - financial records, co-operations
with clients and the contact details, representative subtleties, administrative prerequisites, etc. It's
best to monitor - not to mention use adequately - without the effective system. (Chamber of
Commerce of Metropolitan Montreal, 2018).
References
Pamela, A. and Olsen, D., H. (2014). Business Intelligence, Analytics And Data Visualization: A
Heat Map Project Tutorial. International Journal of Management & Information Systems
– Third Quarter 2014 Volume 18, Number 3. [Accessed: 8th January 2019]

Student Name
Student ID 11
Rachida, F., P. and Thambusamy, R. (2017). Understanding Business Analytics Success and
Impact: A Qualitative Study. Information Systems Education Journal (ISEDJ) November
2017. [Online] Available at: https://files.eric.ed.gov/fulltext/EJ1151897.pdf [Accessed:
8th January 2019]
BUSINESS ANALYSIS TECHNIQUES. Business Analysis Excellence (2018). [Online]
Available at: https://business-analysis-excellence.com/business-analysis-techniques/
[Accessed: 8th January 2019]
How Business Analytics Can Help Your Business. Michigan State University (2018). [Online]
Available at: https://www.michiganstateuniversityonline.com/resources/business-
analytics/how-business-analytics-can-help-your-business/ [Accessed: 8th January 2019]
Diamond, M. and Mattia, A. (2018). Data visualization: an exploratory study into the software
tools used by businesses. Journal of Instructional Pedagogies Volume 18. [Online]
Available at: https://files.eric.ed.gov/fulltext/EJ1151731.pdf [Accessed: 8th January 2019]
Rasel (2013). Advantages and Disadvantages of Graphical Representation of Data. [Online]
Available at: http://www.businesscommunicationarticles.com/advantages-and-
disadvantages-of-graphical-representation-of-data/ [Accessed: 8th January 2019]
Henderson, K., J. (2018). What Are the Benefits of Business Process Mapping? [Online]
Available at: https://smallbusiness.chron.com/benefits-business-process-mapping-
3246.html [Accessed: 8th January 2019]
Advantages of Relational Databases. Techspirited Staff (2018). [Online] Available at:
https://techspirited.com/advantages-of-relational-databases [Accessed: 8th January 2019]

Student Name
Student ID 12
Salehi, M. and Saeidinia, M. (2012). Business Ethics. International journal of scientific and
research publications, volume 2, issue 1, January 2012. [Online] Available at:
http://www.ijsrp.org/research_paper_jan2012/ijsrp-jan-2012-46.pdf [Accessed: 8th
January 2019]
Goutam, R., K. (2015). Importance of Cyber Security. International Journal of Computer
Applications (0975 – 8887) Volume 111 – No 7, February 2015. [Online] Available at:
https://pdfs.semanticscholar.org/5cfb/7a5bd2e6c181e8a69ebd49b1dadb795f493b.pdf
[Accessed: 8th January 2019]
Reddy, G., N. (nd). A STUDY OF CYBER SECURITY CHALLENGES AND ITS
EMERGNING TRENDS ON LATEST TECHNOLOGIES. [Online] Available at:
https://arxiv.org/ftp/arxiv/papers/1402/1402.1842.pdf [Accessed: 8th January 2019]
Das, D. (2018). Systems Thinking—A Process For Problem Solving in SDLC. [Online]
Available at: https://www.cigniti.com/blog/systems-thinking-a-process-for-problem-
solving-in-sdlc/ [Accessed: 8th January 2019]
Figliuolo, M. (2018). 5 Steps to Solving the Problems With Your Problem Solving. [Online]
Available at: https://www.inc.com/mike-figliuolo/decision-making-process.html
[Accessed: 8th January 2019]
THE CHALLENGES OF GROWING A BUSINESS - AND HOW TO MEET THEM. Chamber
of Commerce of Metropolitan Montreal (2018).
https://www.infoentrepreneurs.org/en/guides/the-challenges-of-growing-a-business---
and-how-to-meet-them/ [Accessed: 8th January 2019]