CLASS ASSIGNMENT
IT INTEGRATION
Manoj Nareddula
Sandeep Kumar Vasam
DATA WAREHOUSING:
It’s a storage of large data which collect from wide range of sources within a company and used to guide management systems.
It’s also Known as Enterprise Date warehouse system which generally uses for the reports and any data analysis. In this system, which stores the current and historical data that are used for creating the analytical reports for the employees who is working throughout the enterprise.
Examples of these reports may be range from annual and quarterly comparisons in detail for the sales analysis.
What is the system used about?
A Data Warehouse is a storage of large data from multiple information sources and transformed them into multidimensional data model for efficient analysis.
Software Tools of Data Warehouse:
QlikView: It’s the most flexible Business Intelligence platform for transferring the data into the knowledge. This tool is used in almost 24,000 organizations worldwide to enable their users to search, visually analyze all their important data for the business insight using the QlikView’s tool.
This uses in fast decision making when having the correct information available and also easy accessible. QlikView can also promotes the unrestricted analysis of application data, and helps users to save time for accurate decisions.
The Associative Search is Good in QlikView. This search gives users the freedom to start and finish them analyzes anywhere.
Features of QlikView:
- Does not requires any high cost of Hardware.
- Fast and Powerful visualization capabilities
- Low cost-shorter implementations result in cost saving and fast returns on the investment.
- Risk free- available as a fully functional free trail download.
ETL (Extraction transformation loading): is a process in data warehousing responsible for transforming the data out from source systems and storing into a data warehouse.