Objective To become Data warehousing Techno-Functional Consultant Current Role: Team member Synopsis of Experience: ➢ Over 2+ years of IT experience in Application Development, Testing of Data Warehousing Projects. ➢ Worked extensively on ETL tool (Informatica 9.1). ➢ Working knowledge on BI Tool (BOXI) ➢ Good exposure to data analysis, data extraction and data loading. ➢ Extensively worked on Oracle 10G. ➢ Strong understanding of Dimensional Modeling
Words: 593 - Pages: 3
Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly those assigned in Weeks 3 and 4 of the class. 2. Re-read the “UMUC Haircuts Case Study" and the Stage 1 & 2 assignments, and review the “Walmart Example.” 3. Review Instructor feedback from previous assignment submissions. Purpose of this Assignment This assignment gives you the opportunity to apply your knowledge of the course concepts to develop IT requirements for a
Words: 2090 - Pages: 9
all, business intelligence analysis requires the capturing of information and storing in a single location for effective data analysis. (Greenwalt, D., & Riney, S. (2007) A hotel franchise uses BI analytical applications to compile statistics on average occupancy and average room rate to determine revenue generated per room. It also gathers statistics on market share and data from customer surveys from each hotel to determine its competitive position in various markets. Such trends can be analyzed
Words: 431 - Pages: 2
Research of improve the data quality Abstract Data Warehouse is a data collection which is subject-oriented, integrated, relativelyand relatively stable. and It can reflect the changes of history and support the management decision. It is an important segment to maintain the accuracy of the data warehouse. However, ETL is an important part to build data warehouse and occupy about 60 percent of the load. The improvement of the quality in the data warehouse helps to guarantee the reliability
Words: 3026 - Pages: 13
Data Warehousing Saikrishna Burugula IST 7000 Data Management Wilmington University Abstract A data storage could be a subject-oriented, integrated, time-variant, non-updateable assortment of knowledge utilized in business intelligence and support of organizing decision-making method (Inmon, Strauss & Neushloss, 2008). In data warehousing when the data is stored it is not updated, commonly data warehousing
Words: 1513 - Pages: 7
Database Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. Characteristics * Real-world entity − A modern DBMS is more realistic and uses real-world entities to design its architecture. It uses the behaviour and attributes too. For example, a school database may use students as an entity
Words: 1010 - Pages: 5
with its Real-Time Data Warehouse John Paul Barber Schreiner University MKTG 4324, Business Intelligence Dr. Mark D. Woodhull February 16, 2015 Continental Airlines is the fifth-largest carrier in the United States as well as the eleventh largest carrier company in the world. The airline company provides service to 84 domestic and 53 international locations resulting in over 2000 daily flights. This high level of demand creates a large obligation for data and information to
Words: 958 - Pages: 4
Systems Capstone Business Requirement Plan Currently our system consist of SQL database sitting on 5 Cisco servers onsite. I plan to have that changed to oracle databases in a virtual world and out sourcing the cloud storage. Our current data warehouse is at ten terabytes. This is expected to increase by twenty percent a year therefore this must also be taken into account when searching for a provider of cloud storage. This will save on cost of equipment and also space. This savings of cost
Words: 1621 - Pages: 7
The database is the blueprint to business data, and can be key to whether the business succeeds or fails. Databases must be structured to provide quick and easy access to all of the information necessary to run an organization. That becomes extremely challenging as more and more data is fed into the database from various sources and systems, including enterprise resource planning (ERP) and customer relationship management (CRM). Data warehouses built in the 1990s were simply large repositories
Words: 1255 - Pages: 6
Head: DIFFERENCE BETWEEN DATABASE AND DATA WAREHOUSE 1 Database vs Data Warehouse Patricta Eric Doller Prudue University Relation Database Management Systems Bob Estein March 14, 2015 DIFFERENCES BETWEEN DATABASE AND DATA WAREHOUSE Relational database versus a data warehouse Businesses use new technology in many aspect of running everyday duties, like record keeping. To keep these records organized, companies have separate database and data warehouses. A database is used for a single application
Words: 1271 - Pages: 6
