U2 & CHAPTER 8 : Accessing Organizational Information WEEK 8 ( 25th January 2017, 4.59p.m.)

Assalamualaikum & Goodevening Dear Blog Readers,

Lately the whether in my area here was raining for 2 days straight and this morning I get a glimpse of The Sunlight till later at 2 o'clock the whether start to became cloudy till present. The tests last week I  sat was not to good but not to bad as well, there still one last test this week on Friday Finance 242 a couple of hours right before 7.30pm I am flying of to Shah Alam to rest my head from this university stress a week at least and focused to rest,sew,piano and helping ma' parents. Ain't to not mentioned that I am gonna continue watching the drama 7 Hari Mencintaimu with my mum, shes thrilling excited to watch since my home has no subscribed TV channels for a year and a half but that could not be bother more or less when we watched downloadable movies directly via USB.

WELCOME TO THE OFFICIAL CHAPTER 8 !!!
Coincidence I've also completed this chapter in a 2 hours class yesterday 24.1.2017 on WEEK 8 as well.

Chapter 8 mainly explains what is Data Warehouse actually,

What is Data Warehouse?

It is a logical collection of information which is gathered from many different operational databases which supports business analysis activities and  decision making tasks

What is the Data Warehouse purpose?

Its purpose is to aggregate information throughout an organization into a single repository for decision making process.

The Fundamentals.......

- Extraction, Transformation, and Loading (ETL)
A process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse.

- Data Mart
It contains a subset of data warehouse information.

- The Data Warehouse Model

Multidimensional Analysis and Data Mining

The databases contain information in a series of two dimensional tables. In a data warehouse and data mart, information is multidimensional which contains layers of columns and rows.

- Cube
Common term for representation of multi dimensional information.

- Data Mining
The process of analyzing data to extract information not offered by the raw data alone.It uses data-mining tool which it a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making.

Information Cleansing or Scrubbing

A process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Business Intelligence (BI)

An information that people use to support their decision making efforts

The principles of BI are :

- Technology
Even the smallest company with BI software can do sophisticated analyses today that were unavailable to the largest organizations a generation ago.

       The largest companies today can create enterprisewide BI systems that compute and monitor metrics on virtually every variable important for managing the company.

- People
Understanding the role of people in BI allows organizations to systematically create insight and turn these insights into actions.
    
        Organizations can improve their decision making by having the right people making the decisions. This usually means a manager who is in the field and close to the customer rather than an analyst rich in data but poor in experience.

- Culture
A key responsibility of executives is to shape and manage corporate culture. The extent to BI attitude flourishes in an organization depends in large part on the organization's culture.

Thank You for reading till

After 6th February 2017

HAPPY CHINESE NEW YEAR !!! 

U2 & CHAPTER 7 : Storing Organizational Information @ Databases WEEK 7 ( 18th January 2017, 3.41p.m.)

Assalamualaikum dear Blog Readers,

Time goes by so fast that when I woke up this morning, Gosh, Its already week 7 of the semester to  total of 14 weeks excluding the 1 week Chinese New Year holiday and final exam weeks. So yes, its gonna be very busy as for my planning in this week it self as bellows :

• 18th January 2017 - Operations Management TEST 1 at 8pm an I've only covered 3 chapters out of 5 chapters in total.
• 19th January 2017 - Legal Aspects Of Insurance TEST 1 at 8pm also haven't really study well upon four chapters because it is a fully reading subject ... : (
• 20th January 2017 - Malaysian Economics TEST 1 at 2.15p.m. right after the Friday prayers which I have 0% of my knowledge yet upon chapter 1 till 3.
• 21st January 2017 - "Do I Need To Recycle My Technology" event at Bandar Hilir, Melaka with my course mates which is like 75% in progress.

As you can see the future timeline above that yeah, my schedule is tight but nevertheless, ain't nobody need to waste time right? so that is why I update my blog upon the new Chapter 7 that was revised yesterday ( 17th January 2017)  but haven't 100% complete yet.

Welcome and welcome to Chapter 7 for we will be covering up about storing the organizational information and their databases.

Literally, information is everywhere in an organization and these information is stored in databases

What is databases?

It maintains the information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

There are mainly 3 database models which includes :

1.) Hierarchical Database Model

Information is organized into a tree-like structure in such way that it cannot have too many relationships.

2.) Network Database Model

A flexible way of representing objects and their relationships/

3.) Relational Database Model

Stores information in the form of logically related two-dimensional tables.

Entity @ Attributes

Entity
A person , place , thing, transaction, or event about which information is stored.

Attributes
Characteristics or properties of an entity class.

Key @  Relationships

The primary key and foreign keys identify the various entity classes (tables) in the database

Primary Key
A field that uniquely identities a given entity in a table

Foreign Key
A primary key of one table that appears an attribute in another table and acts to provide a logicall relationship among the two tables.

Relational Databases Advantages

1.) Increased Flexibility

- Handle changes quickly and easily

- Provide users with different views

- Have ONE physical view

   Physical view deals with the physical storage of information o a storage device (hard disk)

- Have MULTIPLE logical views

   Logical view focuses on how users logically access information

2.) Increased Scalability and Performance

- Must scale to meet increased demand, while maintaining acceptable performance levels.

- Scalability

  Refers to how well a system can adapt to increased demands

- Performance

  Measures how quickly a system performs a certain process or transaction

3.) Reduced Information Redundancy

- Inconsistent is one of the primary problems with redundant

- Redundancy

   The duplication of information or storing the same information in multiple places

4.) Increased Information Integrity

- Information Integrity

  Measures the quality of information

- Integrity Constraint

  Rules that help ensure the quality of information

- Relational Integrity

  Constraint rule that enforces basic and fundamental information based constraints.

- Business Critical Integrity Constraint

  Rule that enforce business rules vital to an organization's success and often require more insight.

5.) Increased Information Security

-  Password

   Provides authentication of the user

-  Access Level

   Determines who has access to the different types of information

- Access Control

   Determines types of user access such as read-only access.

6.) Database Management Systems

- A software through which users and application programs interact with a database

THANK YOU FOR READING =D,

 As at continuation,

Data-Driven Websites

This is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database. 

 1.) Development

Allows the website owner to make changes anytime all without having to rely on a developer or knowing HTML programming.

2.) Content Management

A static website requires a programmer to make updates. This adds an unnecessary layer between the business and its web content, which can lead to misunderstandings and slow turnarounds for desired changes.

3.) Future Expands

Having a data driven website enables the site to grow faster than would be possible with a static site. Changing the layout, displays, and functionality of the site is easier with a data-driven solution.

4.) Minimize Human Error

A well designed data driven website will have error-trapping mechanisms to ensure that required information is filled out correctly and that content is entered and displayed in its correct format.

5.) Cutting Production and Update Costs

A data driven websites can be updated and published by any competent data entry or administrative person. In addition to being convenient and more  affordable, changes and updates will take a fraction of the time that they would with a static site

6.) More Efficient

With a data driven solution, the system keeps track of the templates so users do not have to do.

7.) Improved Stability

With a data driven website , there is a peace of mind knowing the content is never lost even if our programmer is.



Integrating Information among Multiple Databases

Integration,

Allows separate systems to communicate directly with each other

- Forward Integration
Takes information entered in a given systems and sends it automatically to all downstream systems and processes.
-Backward Integration
Takes information entered into a given system and sends it automatically to all upstream systems and processes.

Forward & Backward Integration

Central Repository

U2 & CHAPTER 6 : Valuing Organizational Information WEEK 6 ( 10th January 2017, 9.21 p.m.)

Assalamualaikum Dear Blog Readers,

Well, upon updating my chapter 5 slot, I felt that there is an ample of time that I ask myself, Should I continue with Chapter 6?, The answer is YES, because if I don’t, I wouldn’t even be typing this right now. =D

WELCOME TO UNIT 2 : EXPLORING BUSINESS INITIATIVES

Unit 2 which consists of Chapter 6, 7 and 8.Now let us open the curtains for Chapter 6 or in Malay language we call it “ Pembuka tirai untuk Unit 2 adalah Bab 6”.

CHAPTER 6 : VALUING ORGANIZATIONAL INFORMATION

 

 

Organizational Information

·         Information is literally everywhere in an organization

·         Employees must be able to obtain and analyze the many different levels, formats, and granularities of organizational information to make decisions.

·         Successfully collecting, compiling, sorting, and analyzing information can provide tremendous insight into how an organizational is performing.

·         Levels, formats, and granularities of organizational of information.

 

The Value of Transactional and Analytical Informational

 

The Value of Timely Informational

·         Timeless is an aspect of information that depends on the situation.

·         Real-time Information

Immediate, up-to-date information.

·         Real-time system

Provides real-time information in response to query requests.

 

 

 

The Value of Quality Informational

 

 

·         Business decisions are only as good as the quality of the information used to make decisions.

·         You never want to find yourself using technology to help you make a bad decision faster.

·         Characteristic of high-quality information are :

 

v  Accuracy

Are all the values correct? For example, is the name spelled correctly? Is the Ringgit Malaysia amount recorded properly?

 

v  Consistency

Is the aggregate or summary information in agreement with detailed information? For example, do all total fields equal the true total of the individual fields?

 

v  Uniqueness

Is each transaction, entity, and event represented only once in the information? For example, are there any duplicate customers?

 

v  Timeless

Is the information current with respect to the business requirements? For example, is information updated weekly, daily, or hourly?

 

Poor Information,

 

 

What is the cost of Poor Information?

The source came from,

v  Online customers intentionally enter inaccurate information to protect their privacy

v  Information from different systems have different entry standards and formats.

v  Call center operators enter abbreviated or erroneous information by accident or to save time.

v  Third party and external information contains inconsistencies, inaccuracies and errors.

The potential effects towards the Business,

v  Inability to track accurately customers

v  Difficulty in identifying valuable customers

v  Inability to build strong customer relationships.

 

 

THANK YOU FOR READING ;)