DSS - Aendy Suwarno

Decision Support Systems - Application Case 2

1. What capabilities of a wiki are not available in email?

Answer : From my point of view, I think what wiki does that email couldn’t do the same is to edit someone else’s post because in email it is already fix. The interaction between users is limited to give and take, while wiki enables a discussion session about particular post or document where users can interact with it.

2. Describe the applications of wikis in finance and operations.

Answer : Wiki helps them to eliminate the cumbersome number of emails, view the development of business plans, store commonly used information, and create a forum to make interactions between one and another user.

3. How does DrKW’s wiki increase employee productivity?

Answer : Ofcourse, wiki makes employee’s work environment become more convenient and connected to each other and eventually it will make their productivity higher.

4. How does DrKW’s wiki help with foreign language and training?

Answer : Enables the users to edit the intranet quickly and easily for foreign users by helping them build an internal glossary that defines company jargon through employees doing similar jobs. That consider as effective and efficient training method.

Decision Support Systems - Application Case 2

Based on the case

1. What capabilities of a wiki are not available in email?

Wiki can track project development so that the team and management know what progress has been made, regardless of individual geographic locations, and to raise the team's awareness about what each person is doing, the status of each project, and what actions should follow.

Decision Support Systems - Application Case 2

1.Capabilities of a wiki that are not available in email:

• information sharing for users, freely update information
• wiki allows to provide feedbacks from users
• different ways of communication

2.Applications of wikis in finance and operations:

• can improve the communications
• provides status update for users
• organize meeting agendas
• external communications with clients
• can act as a medium to collect resources

Decision Support Systems - Application Case 2

What capabilities of a wiki are not available in email?

the wiki allow all team members to upload information more easily which encourages collaboration and transparency by making the sharing of email conversations and other ideas uncomplicated.

Describe the applications of wikis in finance and operations.

Finance:

application of wikis can strengthens business relationship among employees, especially among employees who have never met by by using communicating tools.

Decision Support Systems - Application Case 2

1. What capabilities of a wiki are not available in email?

The capabilities that wiki have is a structure that a geographically dispersed, publication and collaboration skill through the workspace. And wiki has an important roles that is tracking project development so that the team and management know the progress

2. Describe the applications of wikis in finance and operations.

They use the unit deals with the loans, equity swaps, and the other so it will eliminate the cumbersome number of emal, view the development of the business plan and store the useful information

Data Mining for Business Intelligence

Predictive Analytics DSS Presentation - Youtube Link

Data Warehouse DSS Presentation

Administration and Security of Data Warehouse

1. Steps to ensure the security of data warehouse

• Isolate sensitive databases: maintain an accurate inventory of all databases deployed across the enterprise and identify all sensitive data residing on those databases.
• Eliminate vulnerabilities: continually assess, identify and re-mediate vulnerabilities that expose the database.
• Enforce least privileges: identify user entitlements and enforce user access controls and privileges to limit access to only the minimum data required for employees to do their jobs.
• Monitor for deviations: implement appropriate policies and monitor any vulnerabilities that cannot be re-mediated for any and all activity the deviates from authorized activity.
• Respond to suspicious behavior: alert and respond to any abnormal or suspicious behavior in real time to minimize risk of attack.

Benefits of Data Warehouse

1. Benefits of data warehouse

• Enhances data quality and consistency - Insights will be gained through improved information access.  Managers and executives will be freed from making their decisions based on limited data and their own "gut feelings".  Decisions that affect the strategy and operations of organizations will be based upon credible facts and will be backed up with evidence and actual organizational data.
• Saves time - Since business users can quickly access critical data from a number of sources, all in one place, they can rapidly make informed decisions on key initiatives. They won't waste precious time retrieving data from multiple sources.
• Generates a high ROI - Companies that have implemented data warehouses and complementary BI systems have generated more revenue and saved more money than companies that haven't invested in BI systems and data warehouses. According to a 2002 International Data Corporation (IDC) study "The Financial Impact of Business Analytics", analytics projects have been achieving a substantial impact on a business' financial status.
• Increased query and system performance - Data warehouses are purposely designed and constructed with a focus on speed of data retrieval and analysis.  Moreover, a data warehouse is designed for storing large volumes of data and being able to rapidly query the data.

Architectures of Data Warehouse

1. What are the key similarities and difference between two-tier and three-tier architecture?

Similarities: 

Give user an interface to access and use application and data warehouse

Differences:

2-tier, Data warehouse and Application in one machine

3-tier, Data warehouse and application in different machine

2. how the web influenced data warehouse design?

with the web, the application and data warehouse can be placed in the server and the user interface also can be displayed in web browser.

Data Warehouse - What is Data Integration

What is data integration?

Data integration is a process in which heterogeneous data are retrieved and combined as an incorporated form and structure. Data integration allows different data types (such as data sets, documents and tables) to be merged by users, organizations and applications, for use as personal or business processes and/or functions.

Data integration primarily supports the analytical processing of large data sets by aligning, combining and presenting each data set from organizational departments and external remote sources to fulfill integrator objectives. 

Real-Time Data Warehouse

1. RDW(Real-time Data Warehouse)Definition

A Real-time data warehouse is a process of decision support that is up to date and ongoing when all business transactions occur. Real-time data warehouse is usually also called as active data warehouse.

2. Benefits of using a real-time data warehouse

• RDW is making a better quality from the traditional data warehouse 
• Propagate decision making process until a tactical level and maybe going to the operational level. 
• Users can interact with customers and suppliers directly 

DSS History

How Can Decision-Making Problems: 1) Under Assumed Certainty, 2) Under Assumed Uncertainty, and 3) Under Assumed Risk Be Handled?

1.Under Assumed Certainty 

In this condition, decision maker has all information that he need to make a decision. The decision maker know what the outcome will be, the nature problem itself and in most situation, the solution are already available from past experiences for handling this problem. The decision maker in this condition must be careful in identifying the problem and create a solution.

Explain Why A Manager Might Perform What-If Analysis

What-if analysis: Observing how changes to selected variables affect other variables.

So why a manager needs to perform what-if analysis is because they can compare between all of those variables. For example, deciding the price of a product they need to calculate the price + demand + subsequent + profit or they can calculate the price,demand, and profit and they must know the consequences from 2 of them or they have another type but they also need to see the consequence that is why a manager needs to perform a what-if analysis.

Describe Important DSS Classifications

Classifications of DSS are:

1. File Drawer Systems : This is a system which provide the user with organized information regarding specific demands. This system provides on-line information. This is very useful system for decision making.

2. Data Analysis Systems:  These decision systems are based on comparative analysis and makes use of a formula. The cash flow analysis, inventory analysis and personnel inventory systems are examples of the analysis systems. This use of simple data processing tools and business rules are required to develop that system. 

Explain Why A Manager Might Use Goal Seeking?

A manager might use goal seeking to see and to predict how much they need to achive for certain goals. For example, there is a table that displayed a number of product sales. But several products don't have their sales number yet because it's not yet available. A manager can use a goal seeking to see how much that products need to sell in order to reach that company goals. So goal seeking is like a predictive calculation on things that not yet available to the manager.

What Is A Decision Table?

Decision table is a way or method used for decision making to model complicated business logic which leads to improving business. Using a decision table software offers many benefits over paper methods. First, it makes editing and re-editing easy. Contemporary decision table tools can also give added value by supporting features like conditions, actions, rules highlighting, table layout, reporting, etc. And of course, when it comes to working with a software, it makes sharing, discussion and management of work much easier.