CHAPTER 8: Assessing Organizational Information -Data Warehouse

CHAPTER 8: 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.

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

chapter 7: Storing Organization Information-Database 

QUESTIONS:

1. Define the fundamental concepts of the relational database model. 
2.  Evaluate the advantages of the relational database model 
3.  Define a database management system and its relationship  to a website. 
4. Explain why an organization would want to integrate its database.

  

    

ANSWERS:

Number 1:

 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..


Number 2:

• 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.

 
 Number 3: 

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,

 

Number 4:

 

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.

CHAPTER 5 - ORGANISATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES

CHAPTER 5 - ORGANISATIONAL STRUCTURES THAT SUPPORT STRATEGIC INITIATIVES

DIFFERENCES BETWEEN CIO, CTO, CSO, CPO AND CKO.

CHIEF INFORMATION OFFICER (CIO)

• This person will responsible for overseeing for the uses of information technology
• It ensuring the strategic alignment of IT with business goals and objectives
• The jobs will reports all the activities in organisation directly to the CEO
• CTO also must be a person that have understanding of every aspect of an organisation
• The capability in IT must be the main power to be a CTO
• Other function of CTO:- 
• MANAGER - Ensure the delivery of all IT  projects, on time and within budget
• LEADER - Ensure the strategic vision of IT is in line with the strategic vision of the organisation
• COMMUNICATOR- Advance and communication the IT strategy by building and maintaining strong executive relationship
• CTO also need to enhance customer satisfaction ahead of their concern of any specific aspects of IT

CHIEF TECHNOLOGY OFFICER (CTO)

• Responsible for ensuring the through, speed, accuracy, availability, and reliability of an organisation in IT
• Direct responsibilities for ensuring the efficiency of IT system 
• CTO will posses well-rounded knowledge of all aspects of IT
• Runs the organization’s engineering group
• Uses technology to enhance the company’s product offerings
• Focuses on external customers (buyers)
• Collaborates and manages vendors that supply solutions to enhance the company’s product(s)
• Aligns the company’s product architecture with business priorities
• Develops strategies to increase the company’s top line (revenue)
• Has to be a creative and innovative technologist to be successful

CHIEF SECURITY OFFICER (CSO)

• To ensuring the secuarity of IT systems
• Developing strategies in IT
• Make sure the IT safeguards against attacks from hackers and viruses
• EXAMPLE OF THE RESPONSIBILITIES CSO:-
• Lead operational risk management activities to enhance the value of the company and brand.
• Oversee a network of security directors and vendors who safeguard the company's assets, intellectual property and computer systems, as well as the physical safety of employees and visitors.
• Identify protection goals, objectives and metrics consistent with corporate strategic plan.
• Manage the development and implementation of global security policy, standards, guidelines and procedures to ensure ongoing maintenance of security. Physical protection responsibilities will include asset protection, workplace violence prevention, access control systems, video surveillance, and more. Information protection responsibilities will include network security architecture, network access and monitoring policies, employee education and awareness, and more.
• Work with other executives to prioritize security initiatives and spending based on appropriate risk management and/or financial methodology.
• Maintain relationships with local, state and federal law enforcement and other related government agencies.
• Oversee incident response planning as well as the investigation of security breaches, and assist with disciplinary and legal matters associated with such breaches as necessary.
• Work with outside consultants as appropriate for independent security audits.

 
 CHIEF PRIVACY OFFICER (CPO)

• Responsibilty for ensuring the ethical and legal use of information within an organisation
•  Created to respond to both consumer concern over the use of personal information, including medical data and financial information, and laws and regulations.
• Evaluating legislative and regulatory proposals involving collection, use, and disclosure of personal information by the Federal Government. 
• Conducting a privacy impact assessment of proposed rules of the Department or that of the Department on the privacy of personal information, including the type of personal information collected and the number of people affected.
• Coordinating with the Officer for Civil Rights and Civil Liberties.

 

CHIEF KNOWLEDGE OFFICER (CKO)

• (CKO) is an organizational leader, responsible for ensuring that the organization maximizes the value it achieves through "knowledge". 
• The CKO is responsible for managing intellectual capital and the custodian of Knowledge Management practices in an organization. 
• CKO role is much broader, that 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.
• CKO must have skills across a wide variety of areas. 
• They must be good at developing/understanding the big picture, advocacy (articulation, promotion and justification of the knowledge agenda, sometimes against cynicism or even open hostility), project and people management (oversight of a variety of activities, attention to detail, ability to motivate), communications (communicating clearly the knowledge agenda, have good listening skills and be sensitive to organizational opportunities and obstacles), leadership, teamwork, influencing, and interpersonal skills. 
• The CKO who successfully combines these skills is well equipped as an excellent agent of change for their organization.

CHAPTER 4: MEASURING THE SUCCESS OF STRATEGIC INITIATIVES

Business professional know how to run a successful business in IT but nowadays, the exists of Facebook, Blogspot n so on no longer  need a business professional to run a business in IT.

Facebook is the most option website that people choose to set up their small business. Besides, with the existence of smartphones, tablets and and so forth have brought the increasing in demand for product that sell in Facebook because of people will take the easier way to shop. 

House Of Poojaan was set up by my sister and me since last year, we choose Facebook because it have an interrelationships of efficiency and effectiveness IT metrics which are:

• Throughput- amount of info that can travel through a system at any point in time. For example, as we know server or internet never and ever in a sleep mode so, customer can view my product on Facebook at any time they want.
• Speed- the amount of time a system take to perform a transaction. For example, customer will easy to get information about features of our product by uploading pictures of model use our product.
• Availability- the number of hours a system is available for use by customers and me. All the website including Facebook achieve good Key Performing Indicator (KPI)
• Accuracy- the extent to which a system generates the correct result when executing the same transaction numerous times.
• Web Traffic- including a host of benchmarks because i can easily track n know how much visitor visit at our page.
• Response time- the times it take to response to user interactions such as mouse click. Facebook did not added new tab when we click on the picture that we want to see.So customer don't have waiting to see the product.