chapter8: Assessing Organizational Information -Data Warehouse

1). Describe the role and purpose of data warehouses and data marts in the organization.

Data warehouse- A data warehouse is a collection of data, usually current and historical, from multiple databases that the organization can use for analysis and decision making. The purpose, of course, is to bring key sets of data about or used by the organization into one place.-

Data mart- Data marts are related sets of data that are grouped together and separated out from the main body of data in the data warehouse.

source from google

The purpose of data warehouse is to aggregate information throughout an organization into a single repository in such way that employee can make decision and undertake business analysis activities.

besides that, database store all the transaction such as sales of product.

The roles of data mart is easily to employee to access the data information. Other than that, data marts as having focuses information subsets particular to the needs of a given business unit such as finance or production and operations.

2). Explain the relationship between business intelligence and a data warehouse.

Business intelligence usually refers to the information that is available for the enterprise to make decisions on. A data warehousing (or data mart) system is the backed  or the infrastructural, component for achieving business intelligence. Business intelligence also includes the insight gained from doing data mining analysis, as well as unstructured data (thus the need of content management systems). 

Let me give the path of Data warehousing. All the source data from disparate sources are used to load/Stage data. Different sources can be flat files, another database or some other process. The starting point of the Data warehouse should extract the data in order to load into its environment.This is extracting. This data may not be the expected format or size. your business demands are different or your organization business requirements are different. So the business process has to modify the data or better word is to transform the incoming data to meet requirements and objectives. This is called Transformation. Once every slicing and dicing of the data is done along with applied business rules, this data is ready for loading into the target tables. This process is called Loading. So overall till now we have done Extraction, Transformation and Loading. In short we call this ETL. There are lot of tools available in today's market which does help in achieving the ETL process. Once this data is loaded in to the database, this is ready for next processing. We call that database as Data warehouse database. The next process could be building of datamarts or directly reporting from it. There are lot of tools/software available for reporting/analysis. Some call it business reporting or analysis tool. But if you see the whole process has intelligence involved in business. we can call this or the gurus call it Data warehousing and the system involved from end to end is called business intelligence system.

chapter 7: Storing Organization Information-Database

1). Define the fundamental concepts of the relational database model..

What is database actually? macam mana database ni berfungsi?...manelah tahu benda ni..budak yang ambik sains komputer je kut yg tahu..<------is that your perception?kne banyak membaca ni..isk3...

DATABASE MANAGEMENT SYSTEM (DBMS)..

A collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes.

In example: computerized library system, automated teller machines  
                  (ATM) and flight reservation systems.

besides that,it is shows how the internal organization can affect how quickly and flexibly you can extract information from this database.

This software are gathered all of the information in one central database..

2). Evaluate the advantages of the relational database   

     model.

• Increase flexibility - who access the database will able get the information based on their users of database.
• Increase scalability and performance- which is to looked at the performance of organization. Scalability is how well the systems can adapt to increase demand. Meanwhile, performance is base on the how quickly systems performs during transaction.
• Reduced information redundancy- which is to reduce duplication of information.
• Increase information integrity(quality)-measure quality of  information.
• Increase information security- which is to maintain information integrity using password, access levels and access control.

3). Define a database management system and its relationship    

     to a website.

Database Management System(DBSM) is how the software can interact within users and application programs. How the DBMS manipulate the data information through database. The example is online shopping.How the owner want to fulfill the customer demand with the information for the warehouse data. Besides that, organization can measure their performance using the website. Which is how many visitors every day reach to the website,

4). Explain why an organization would want to integrate its database.

the organization should integrates the database because to ensure there no duplication of information. Means, no need  difference people key in the same database information. it is also increase flexibility because difference users with difference purpose can using one database according to their purpose.

The organization increase their performances and quality of database.

Salam Maulidur Rasul

CHAPTER5: ORGANIZATIONAL STRUCTURE THAT SUPPORT STRATEGIC

assalamualaikum.....;)

Hello, looked at the title above..Anyone knows who they are? hmmm what their responsibilities actually?

don't you want to know?..lets read my entry till the end..weheee...

 To ensure our organization running smoothly we should have a few top manager which can lead our organization in order to achieve organizational goals.

Firstly is Chief Knowledge Officer( CKO)  

• responsible for managing intellectual capital and the custodian of Knowledge Management practices in an organization. 
•  CKO can help an organization maximize the returns on investment in knowledge (people, processes and intellectual capital), exploit their intangible assets (know-how, patents, customer relationships), repeat successes, share best practices, improve innovation, and avoid knowledge loss after organizational restructuring.
• responsibilities of CKO: Collecting relevant data that is useful for the organization as knowledge, Developing an overall framework that guides knowledge management, Actively promoting the knowledge agenda within and beyond the company, Overseeing the development of the knowledge infrastructure and Facilitating connections, coordination and communications.

Chief Information Officer (CIO)

• responsible for the information technology and computer systems that support enterprise goals.
• Information technology and its systems have become so important that the CIO has come to be viewed in many organizations as the key contributor in formulating strategic goals for an organization.
• chief technology officer develops new technologies to expand corporate technological capabilities.

Chief Technology Officer (CTO)

•  CTO as “Big Thinker” spends his/her time evaluating how technology can be used internally by the business.
• This CTO’s responsibilities often include advanced technology, competitive analysis, technology assessment, prototyping lab,partnering, planning, and architecture standards.

Chief Security Officer (CSO)

• A chief security officer, or CSO, is the top official with an organization's computer system and handles all problems and concerns associated with information and system data. It is her duty to protect any piece of data that goes through an organization's computer system as well as decrease the threat of fraud within the systems.

Chief Privacy Officer (CTO)

• Establish a uniform high level of data protection for all personal data, regardless of origin and location,but leave space for customization based on local law or a particular client requirements.
• Establish complaint and rights procedures.
• Respond and deal with requests from individuals.
• Respond and deal with clients’ requests.

Efficiency and Effectiveness using a facebook in IT Metrics

Assalamualaikum..;)

Hye the previous entry I had explained about efficiency and effectiveness of the IT Metrics.

And this entry I should comment how the efficiency and effectiveness the seller using  Facebook as a medium of business.

source from google

By doing a business online the seller should to figure out whether the medium used is very effective in terms of speed, availability and etc. for the customers or not.

An example I as a online seller through a Facebook offering furniture and house accessories.

I should advertise the product exactly similar with the original by using a pictures, detail information such as what kind of raw materials used for that sofa.

Thus the customer can making a decision through the certain information was given. And how much time the customer would spend into my website just to review my product?

Weather it is effective or not?

Has my customer have their satisfaction during online shopping at my website?

 THE ANSWER IS:

Yes, because when the customer review my website, they don't need much time to spent time during survey the product.

For example, when the customer attracted to my product, they will read the specifications for that item such as raw materials, price incurred and the design of that product will clearly stated from the websites.

This kind of business online is very effective because can save time and no need to make much effort to get the product.

Besides that, from this business also we can get the satisfaction information from the customer.

This satisfaction information I will collect it from the feedback of the customers.

From the feedback I can measure it, weather I achieve my organization goals or not.

Effectiveness and Efficiency of IT metrics

what is IT METRICS????(click here for the definition)

Efficiency of IT Metrics..

• Measure of the performance of the IT.
• Which is how far the company can utilize the resources.
• For example:  In example, the rate of speed is used in reference to transactions. when I go to the Tesco to purchase groceries, how much I spend my time to queue in the line until the cashier return my balance.

Effectiveness of IT 

• Measure the impact of IT on business process and activities including of customer satisfaction, conversion rate and etc.
•  An example in real life would be how well customers are treated at the Apple store when purchasing a new I pod or computer.

CHAPTER 3: Strategyi Initiatives for Implementing Competitive Advantages

SUPPLY CHAIN MANAGEMENT....

Whose know what is Supply Chain Management (SCM)?

• Means managing and maintain all the supplier relationship. 
• click here for better definition SCM .=)
• In this software consists of four basic component which are:

1. Supply chain strategy.
2. Supply chain partners.
3. Supply chain operation.
4. Supply chain logistics.

SCM is a software using widely in organization to ensure their company running smoothly. For example Tesco, this supermarket needed to have a good relationship with their supplier to ensure Tesco can supply their product to customer.

This software have a few steps before the product can reach to the customer.

• RAW MATERIAL

Before it is can be a product, the organization will bought raw materials from their supplier. For instance, screw to make a component of computer. Each step of process to produce a computer have their own suppliers. Which all the organization should maintain their relationship between their suppliers.  

• COMPONENT

 Component is something the combination of raw materials to create a module. For example, computer is the module meanwhile the equipment inside the computer is the component  to produce a computer.  

• MANUFACTURER

After making a component process, manufacturer will ask the supplier sent it to the factory to making a final steps to become a computer. which is the manufacturer will complete the task to ensure the computer can be use in future. After complete the process, manufacturer will deliver those items to the retailers.

• RETAILER

After manufacturer delivered the product, retailer will market their product to ensure fulfill  the customer demand.

• CUSTOMER

Customer will purchase the product to ensure they can get their needed. Thus it is the final stages which the product have been delivered to the customers and they have their satisfaction.