Hsu Wai Wai Hlaing's Business Intelligence Analysis Assignment

This business intelligence assignment, submitted by Hsu Wai Wai Hlaing from the 11th Batch of Youth International University, delves into crucial aspects of business analysis. The assignment covers business processes, illustrating them with an HR hiring example, and categorizes them into operational, supporting, and management processes. It explores organizational levels, differentiating between top, middle, and lower management, highlighting their roles and responsibilities. The assignment also examines structured, unstructured, and semi-structured data, providing an analogy to clarify the differences. Furthermore, it outlines key features of business intelligence functionality, including ranking reports, what-if analysis, executive dashboards, interactive reports, geospatial mapping, operational reports, pivot tables, and ad-hoc reports. Finally, it discusses the advantages and disadvantages of application software and explores various information systems and technologies supporting organizations at operational, tactical, and strategic levels. The assignment serves as a comprehensive overview of business intelligence principles and their practical applications in organizational settings.

Unit – Business Intelligence
Assignment 1 : Challenging for Business
Analysis
Hsu Wai Wai Hlaing
11th Batch
Youth International University

Table of Contents
Business Process........................................................................................................................2
Example of Business Process.................................................................................................2
Three Types of Business Processes............................................................................................3
Supporting Process.................................................................................................................3
Organizational Levels................................................................................................................4
Top Level Management..........................................................................................................4
Middle Level of Management................................................................................................5
Lower Level of Management.................................................................................................6
The Difference Between Structured, Unstructured, And Semi-Structured Data.......................7
The key features of business intelligence functionality.............................................................7
Advantage & Disadvantage of Application Software..............................................................10
Advantages of Application Software:..................................................................................10
Disadvantages of Application Software...............................................................................11
Range of Information Systems and Technologies that can be Support Organization at
Operational, Tactical and Strategic levels................................................................................12
Informational system in Organizational Level.....................................................................12
Operational management level.........................................................................................14
Tactical Management Level..............................................................................................14
Strategic Management Level............................................................................................14
Information Technologies in Organization level..................................................................15
References................................................................................................................................15
1

Business Process
A business process is an activity or set of activities that can achieve a specific
organizational goal. A business process should have a purpose, be as specific and consistent
as possible with a result.
A business process is defined as a set of business actions and activities that, when
performed by a person or system within a structured process, produce an outcome that
contributes to the achievement of a business goal.A business process includes at least one of,
but not limited to, the following elements:
o task/ activity
o system
o employee(s)
o workflow
o data
Business process mapping provides organizations with a visual representation of how
different processes are performing and gives them a better view of how the business is
performing. It can also help improve a company's operational efficiency.
Example of Business Process
For example, consider the hiring process for an HR department. From the
announcement of a job offer to employee integration, the process involves several stages.
Although this can vary from organization to organization, a simple workflow might look like
this:
 The HR government posts the activity update
 Multiple applicants observe in a portal
 The HR government displays the applicants and filters the best-fits
 The decided-on applicants are referred to as for the following levels of the recruitment
 The proper candidate is selected on the closing level of the recruitment
 Salary and coverage negotiations take place
 The provide letter is dispatched and the candidate accepts
2

Three Types of Business Processes
There are 3 types of Business Process According to Business Process Handbook. They are:
1) Operational process (Core or Primary Process)
2) Supporting process (Secondary Process)
3) Management process
Supporting Process
Supporting Process is executed to keep integrity of the service or product evolved by
“primary process” as properly because it guarantees that merchandise and procedures observe
predefined provisions and plans. Supporting procedures accompany the “primary process”,
which do now no longer usually bring about very last merchandise of the organization,
however as a substitute in a roundabout way contributes to the fee added. Documentation,
configuration management, verification, education and audit system are all helping
procedures.
The Supporting Process category provides some basic activities and concepts needed
to support all other categories. Process areas in this category support the adoption and
ongoing maintenance of all data management processes described in this document.
Supporting Processes include the following Process Areas:
a. Measurement and Analysis: Identifies however the observe will measure the
effectiveness of how they need enforced data management processes.
b. Method Management: Assists the practice with developing work products, appreciate
best practices, policies, procedures, the business glossary, and so on
Method Quality Assurance: Focuses on creating enhancements in how the information
management processes are implemented.
The activities are in supporting processes, aimed at achieving objectives that support other
processes that perform a specialized function. These objectives can point to:
 Define the requirement to record all information produced by process lifecycle
activities.
 Integrate identification, control and statistical evaluation of configurations and version
management.
3

 Define activities to objectively ensure that software products meet specified
requirements and adhere to established plans.
 Specify activities (for acquirer, supplier, or independent organization) to verify
software products and services.
 Determine the activities (customer, vendor, or independent organization) to validate
the software products of the software project.
 Undertake a peer review of the technical and administrative aspects, where they will
verify the state of the goods produced and the activities undertaken.
 Specify activities to determine compliance with requirements, plans, and contracts.
This process can be used by either party, where one party (audit) verifies the products
or activities of the other party (audit).
 Specify a process for analyzing and eliminating (resolving) problems (including
disagreements), regardless of their nature or origin, which are discovered during the
execution of the development, operation, maintenance and other processes.
Organizational Levels
The term levels of management see the shared path that exists between many
positions of social control in the associate degree organization. as the size of the company
and the workforce increase, the number of management levels will increase with it, and vice
versa. the different levels will confirm the chain of command within an organization, as well
as the amount of authority and generally influence over decision-making accrued by all
leadership positions.
Organizational levels can be generally classified into three principal categories, all of
which direct managers to perform different functions.
1. Top-Level Management/ Administrative level
2. Middle-Level Management/ Executory
3. Low-level Management/ Supervisory
Top Level Management
Administrative management level is often referred to as top level management. They
plan ahead and coordinate resources. The Board of Directors, the Chief Executive Officer
(CEO), the Chief Financial Officer (CFO), and the Chief Operating Officer (COO) or
President and Deputy President, form senior management.
4

Top management is responsible for the organization's goals and policies, as well as its
ultimate source of authority. They organize the various departments of the company,
including their budgets, processes, and agendas, and provide liaison and control over all
company activities.
The operation of the firm was carried out by senior management of shareholders.
There are several tasks performed by senior management, but three of them are very
important, and they are:
• Establish organizational policies and policies
• Setting business objectives and assigning qualified managers to departments or
intermediate level to achieve them.
• Maintaining communication between the company and the world.
Middle Level of Management
The middle management, also known as the management level, is responsible for the
planning and supervision of the lower level management. They are subordinate to the top
management. They are responsible for the actions of their departments and report to senior
management.
The middle managers are sub-managers and are made up of departmental directors
and branch managers. They may be subdivided into medium and small level management in
the event of a large organization. They organize the obligations of the lower unit of the firm
and achieve the performance of lower-level managers.
Medium managers are in charge of recruiting and preparing for lower levels. They are
also the mediators between high and low level as they exchange data, reports, and other
business information at the highest level. Apart from this, there are three main functions of
middle level management in the organization described below:
 To make company plans compliant with the rules and regulations set out by senior
management.
 Preparing departmental framework or activities.
 To be a vision or to inspire young executives to improve their efficiency.
5

Lower Level of Management
A low level of management is also called a supervisory or management level of
management. They guide and train working staff. They spend a lot of time talking to a
working firm, as instructed by their superiors.
Low-level managers are the main line of management as they intervene in operations,
so they are key employees who convey the firm issues of the firm to higher levels. This level
of management is made up of the foreman, the line manager, the transport manager, the
section manager, the main feeder, the managers, and the sergeant.
They are mediators; they resolve problems among employees and are responsible for
maintaining proper relationships within the organization. They are also responsible for
training, supervising, and supervising the staff.
Low-level managers represent managers in effective staff as they ensure ethics and
efficiency in the organization. The work of inspiration and encouragement falls on them, as
they strengthen the staff. They also organize the necessary equipment, tools, and other
equipment needed by the staff to get their work done.
Summary below are the key functions of low-level management:
 Delegate responsibilities and responsibilities to working staff.
 Ensuring quality and accountability for production value.
 Communicating with the goals and objectives of the firm set by senior management
and staff suggestions, recommendations, complaints, and information on labor issues
to senior management.
 Giving instructions and guidance to employees in their daily activities.
 Provide periodic staff reports to senior management.
6

The Difference Between Structured, Unstructured, And Semi-Structured
Data
To easily understand the differences between the data categories, let's use this analogy
to illustrate. When discussing work, let’s say there are three different categories of
conversations: formal, informal and informal.
In a formal interview, the interviewer follows a strong text outlined by the department
of labor and followed by each candidate. Another type of interview is a random interview. In
informal conversation, it is up to the interviewer to determine the questions and the order in
which they will be interviewed (or will be interviewed) for each candidate. A small structured
interview takes features from both formal and informal interview categories. It uses
flexibility and plural elements allowed for formal conversation but offers the freedom to
customize it based on the circumstances that are most relevant to informal conversation.
Therefore, in data, structured data is easily organized and follows a solid format;
irregularities are complex and often quality information that is impossible to reduce or order
is a related site and less structured data has both of your characteristics.
The key features of business intelligence functionality
The most important business intelligence features include:
1) Ranking Reports
Ranking reports let you easily view the best- and worst-performing facets of
your business, from products to marketing campaigns to salespeople. You can view
rankings across multiple dimensions and specify various criteria to focus your results.
2) What-If Analysis
If you’re curious about how a future decision will affect your business, you
can run a “what-if” analysis using past data to predict the potential impacts. Tools for
what-if analyses give you an objective view of the risks and rewards involved in each
potential decision, and allow you to plan better for the future.
3) Executive Dashboards
Executive dashboards give your organization’s leaders a real-time overview of
your business in the form of graphs, charts, summaries and other information reports.
They allow your company’s executives to make smarter, faster and better decisions.
7

4) Interactive Reports
Interactive reports allow users to condense the massive amounts of collected
data into a wide variety of possible views. Users can take advantages of features like
statistical analysis and regression to identify trends, anomalies and outliers in the data.
5) Geospatial Mapping
Applications using location intelligence can take your information and
transform it into graphical and cartographic representations, simplifying your
geographical data. At a glance, judging which regions are performing better than
others — and which ones need particular attention — becomes much easier.
6) Operational Reports
At the end of each day, business intelligence features like these can provide
your organization’s executives with a detailed summary of the daily events, giving
them the information, they need to make critical decisions.
7) Pivot Tables
Pivot tables can automatically extract significant features from a large, messy
set of data. They can perform calculations such as sorting, counting or averaging the
data stored in one table, and show the summarized results in another table. Pivot
tables are essential tools for analyzing information and uncovering hidden trends.
8) Ad-Hoc Reports
Instead of burdening your IT department with requests for detailed reports, ad-
hoc reports are one of several important features of BI that let your nontechnical end-
users generate their own reports on the fly. Users can pick and choose the elements
that they wish to be included in the report, emphasizing only those aspects that are
relevant to their query.
9) User-Specific Security
If you need to restrict certain users’ access to particular data sets, your BI tool
should allow you to personalize your BI features and applications to individuals or
groups of users. Some solutions provide user-specific data sources, where a single
application pulls from different sources of data depending on who’s using the
application.
10) Open Integration
Smart BI platforms will be able to access not only your organization’s own
data, but information from email, social media, websites and more. For example,
8

instead of only providing your internal sales data, your BI platform could accompany
that information with reviews and comments about your products.
With so many data formats and so many applications to pull from, it’s
important that BI platform is able to integrate as many different types of data as
possible under a single roof, seamlessly combining disparate forms of information
into an actionable report.
Match up these critical BI software features within your BI requirements
template to ensure you are researching and selecting the ideal BI platform for your
organization
Different organizations will invest in a Business Intelligence (BI) solution for
different reasons depending on their specific circumstances and industry.
Regardless of individual agenda, here are six features you should insist upon
in any BI solution, no matter the circumstances of its application:
i. Executive dashboards
Personalized Dashboards deliver relevant, easily understood real-time data to
business leaders, enabling faster and better decision-making whilst lowering response
times to internal and external events. Executives need access to personalized
dashboards that deliver easy-to-understand KPIs and summary information on a
regular, scheduled basis. Additionally, exception reporting should alert the executive
to unexpected events and scenarios that require action. Personalized data delivery
means executives are able to make decisions quickly, without any guesswork, and
without having to wade through irrelevant information.
ii. Location Intelligence
Location Intelligence is the ability to map and visualize data in geographical
formats. Exploring and visualizing data sets based on spatial elements enables
organizations to understand their business operations from new perspectives, such as
sales per region.
iii. “What if” analysis
“What if” analysis allows businesses to assess the potential effects of critical
business decision before they’re actually made. Using existing data, users can
formulate strategies to achieve business targets and avoid the default “hit and miss”
approach. This helps management undertake accurate strategic planning.
9

iv. Interactive reports
Interactive reports help users convert data into knowledge. They allow users to
better understand the analysis within reports, and the underlying data those reports are
based on, to support better decision-making. User should be able to:
 Drill down and through reports
 Conduct slice and dice OLAP analysis
 Apply analysis such as moving averages and regression to highlight
trends in data
 Use time-series zooming to scan large data sets to understand
anomalies in their data
 Use conditional formatting to set data alerts which highlight data
exceptions
v. Meta data layer
A metadata layer makes reporting easy and eliminates the need for coding and
SQL, allowing users and report writers to see and access information in simple
business language. Users solely interact with data at the meta data level without
having to comprehend the complexities of the underlying data or database.
vi. Ranking reports
This feature allows you to create reports that order specific categories of
information, from across multiple dimensions, by selecting specific criteria. Ranking
reports let you view the best and worst performing aspects of your business. For
example, you could create a report that ranks your 10 best-selling products, regions or
sales people.
Advantage & Disadvantage of Application Software
Application Software is a type of program that is tailored to the needs of the
customers. Framework layout provided an application platform. Advanced vernacular
languages are not accustomed to designing a machine system. It is a reason for planning. One
of the important things to consider about the term "application system" is that it is very broad.
That is, more or less. In that sense, any client program is generally referred to as the
“application.” So a well-founded saying: "there is a request for that." People often use the
10

term “program” to refer to packages or circles for individual applications, using another term,
“program,” to request specific applications. That is because “system” is associated with a
single unit, which cannot be calculated, whereas “system” usually asks for a single system.
Advantages of Application Software:
 One of their best positions is that they meet the specific needs of the client. Since it is
clearly designed for one reason, the customer realizes that he must use one specific
plan to accomplish his task.
 A related business may close access and may think that it intends to monitor their
organization further.
 General updates from the licensed application developer were received for social
reasons. In addition, the engineer continuously sends the faculty to clarify any
problems that may arise from time to time.
 The chances of infection invading handmade projects may be small, as long as any
associated business can restrict access and should provide you with a strategy to
protect its environment and you.
Disadvantages of Application Software
 Creating applications aimed at achieving clear goals can create a costly for
developers. This can have a detrimental effect on their financial system and the way
they make money, especially if they spend a lot of time building the wrong product.
 A system that is often used by many of our people, at the same time shared on the
web, carries the real risk of contamination by pest or other revenge projects.
 Doing a few things that take up your time as it requires a reliable connection between
the developer and the supporter. This slows down the whole creative process, which
could prove destructive during a few cases.
11