PART ONE: Discussion - Real time Data Warehousing, business and finance homework help

User Generated

YFO008

Business Finance

Description

PART ONE: Disussion - Real time Data Warehousing --- Due Mon Aug 21 2017

(Only Needs to be 150 Words)

Organizations require faster decision making to be competitive in today's marketplace. Data comes in faster and requires immediate conversion. Real-time data warehousing (RDW) is also known as active data warehousing (ADW). RDW is the process of loading and providing data via the data warehouse as it becomes available.

For this discussion, explore the following questions:
In an organization, what kinds of applications require real-time data warehousing?

Discuss applications that do not require real-time data warehousing.
What is the difference between the two and why is real-time data warehousing important only to some applications?



PART TWO: Current Event - Data Warehousing

(I can make it an Audio File. You just need to type it up!)

This is a slightly different type of forum. You will create an audio file then upload it for your initial post. You will respond to your classmates in the usual written manner.

Since this is a way to practice verbal reporting to a client or company officer, please offer constructive advice to your classmates on their report (i.e. - spoke too: soft, loud, fast, slow, etc) along with your comments on their audio post topic.

As you've learned so far, data warehousing is essential today due to its importance in adequately collecting and storing data.

Research a current event from within the last five years that relates to this week's topic of data warehousing. Attach an audio explanation of the current event and specifically how it relates to what you've learned this week about data warehousing.


PART THREE: Written Assignment - ETL Pocess

The ETL Process is the heart of the technical side of data warehousing. Conduct some independent research on the ETL Process.

Write a 1-2 page APA formatted paper with citations and references that analyzes why the ETL process is important for data warehousing efforts. Within your paper, discuss the three steps of the ETL process and briefly describe the four categories of ETL technologies. Please provide examples of ETL technologies.


PART FOUR: PROJECT - Data Retrevial

Use the 2014 Fourth Quarter spreadsheet for this deliverable.

Take the original spreadsheet and delete the columns that will not be necessary in your analysis.

In the same Excel spreadsheet, create a new tab called "Module 03 Explanation". In the Module 03 Explanation tab, provide an explanation on the fields that you will use and the fields that you eliminated. What was your reasoning?

Submit the edited spreadsheet with only the fields you will use to determine if the sales consultants are in policy.

Unformatted Attachment Preview

Institution Affiliation: Date: Business requirements  Meet minimum and maximum sales  Take the standard time in presentation  Achieve the objectives  Offer quality consultant services Reference  Tavana, M. (2014). Developing business strategies and identifying risk factors in modern organizations.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

please find the attached files. always a pleasure working with you. good bye

Running head: REAL TIME DATA WAREHOUSING

Real-Time Data Warehousing
Name
Institution
Course
Tutor
Date

1

REAL TIME DATA WAREHOUSING

2
Part One

Applications That Require Real-Time Data Warehousing
Business enterprises that are focused in attaining a competitive advantage in their
businesses do require a well streamlined real-time data warehousing process. Data is essential for
making important decisions within the organization (Langseth, 2004). There are various
applications that are used for reporting and data analysis for business intelligence within business
organizations. Extract, transform, load (ETL) is one warehouse data based application that
utilizes this feature in an authentic manner. Evidently, operational data store (ODS), query
offloading, operational reporting & dashboards; and zero downtime migrations require real-time
data warehousing to enable computer user to retrieve data being used for business making
decisions within organizations.
Applications That Don’t Require Real-Time Data Warehousing
On most occasions, data warehouses and data mart applications do not contain current
data; hence not mandatory for real-time data housing. Real-time data warehousing is only
important to some applications due to the nature of data and work being done within
organizations. For example, data warehouses and business intelligence applications are used to
generate feedbacks from user queries on real time data. They analyze vast data quantities, for
making important decisions such as unfolding suspicious activity within an organization
(Langseth, 2004).
Part Two: Current Event

REAL TIME DATA WAREHOUSING

3

Enterprise data warehouse (EDW) is crucial repositories of integrated data from different
sources of data items within the organization. EDW plays a significant role during the process of
creating reports for motivating and impacting knowledge to workers within an enterprise. It is of
cardinal impact to appreciate the fact that generic environment of real-time data warehouse do
contain: data sources, technology for data integration, data storage architecture within the
organization, effective data tools and the quality of data (Mike, 2015).
There are various events that have been realized in the field of data warehousing. One
such important event is the automation of real-time data warehousing among various
organizations. Generally, data warehouse design and execution have changed from the
perspective of being an art to a science. This has been immensely accelerated by increased
demand for data items and frustrations due to delays in the process of processing data items
within enterprises (Mike, 2015). There have been additional features including but not limited to
changes in data management, design and general operations and other notable automations in the
data warehouse automation lifecycle phases.
Successful data house companies such as Attunity and WhereScape have successfully
automated the process of real-time data warehousing. Automations have been also caused by
changes in the user interfaces that relied on mouse clicks for execution of commands. The
creation of Windows 10, innovation of tablets and smartphones have ensured de...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags