Data Warehousing Fundamentals for IT Professionals, Second by Paulraj Ponniah

By Paulraj Ponniah

State-of-the-art content material and tips from an information warehousing expert—now increased to mirror box trendsData warehousing has revolutionized the way in which companies in a large choice of industries practice research and make strategic judgements. because the first variation of information Warehousing basics, quite a few organisations have applied information warehouse structures and reaped huge, immense merits. Many extra are within the means of doing so. Now, this new, revised variation covers the basic basics of knowledge warehousing and enterprise intelligence in addition to major fresh tendencies within the field.The writer presents an greater, accomplished evaluate of information warehousing including in-depth motives of severe matters in making plans, layout, deployment, and ongoing upkeep. IT pros desirous to get into the sector will achieve a transparent figuring out of thoughts for information extraction from resource structures, facts detoxification, facts modifications, info warehouse structure and infrastructure, and many of the equipment for info delivery.This functional moment version highlights the parts of information warehousing and enterprise intelligence the place high-impact technological development has been made. Discussions on advancements comprise information marts, real-time info supply, facts visualization, necessities collecting tools, multi-tier structure, OLAP purposes, internet clickstream research, information warehouse home equipment, and information mining concepts. The booklet additionally includes overview questions and workouts for every bankruptcy, acceptable for self-study or lecture room paintings, examples of real-world occasions, and a number of other appendices with helpful information.Specifically written for execs accountable for designing, enforcing, or preserving facts warehousing platforms, information Warehousing basics offers agile, thorough, and systematic improvement ideas for the IT specialist and somebody operating or gaining knowledge of in details administration.

Show description

Read Online or Download Data Warehousing Fundamentals for IT Professionals, Second Edition PDF

Best mathematics books

Surveys in Combinatorics

Combinatorics is an lively box of mathematical learn and the British Combinatorial convention, held biennially, goals to survey an important advancements by way of inviting individual mathematicians to lecture on the assembly. The contributions of the critical teachers on the 7th convention, held in Cambridge, are released the following and the subjects mirror the breadth of the topic.

Hamiltonian Methods in the Theory of Solitons

The most attribute of this now vintage exposition of the inverse scattering procedure and its purposes to soliton idea is its constant Hamiltonian method of the idea. The nonlinear Schrödinger equation, instead of the (more traditional) KdV equation, is taken into account as a prime instance. The research of this equation varieties the 1st a part of the ebook.

The Mountain Pass Theorem: Variants, Generalizations and Some Applications (Encyclopedia of Mathematics and its Applications)

Joussef Jabri provides min-max tools via a accomplished examine of the several faces of the distinguished Mountain cross Theorem (MPT) of Ambrosetti and Rabinowitz. Jabri clarifies the extensions and editions of the MPT in a whole and unified approach and covers normal themes: the classical and twin MPT; second-order details from playstation sequences; symmetry and topological index conception; perturbations from symmetry; convexity and extra.

Additional resources for Data Warehousing Fundamentals for IT Professionals, Second Edition

Example text

Computing Technology Mainframe Mini PCs/Networking Client/Server Human/Machine Interface Punch Card Video Display GUI Voice Processing Options Batch 1960 1970 Online 1980 Networked 1990 2000 Figure 1-3 Explosive growth of information technology. 2010 8 THE COMPELLING NEED FOR DATA WAREHOUSING Processing large volumes of data and providing interactive analysis requires extra computing power. The explosive increase in computing power and its lower costs make provision of strategic information feasible.

At one time or another in your career in information technology, you must have been exposed to situations like this. Sometimes, you may be able to get the information required for such ad hoc reports from the databases or files of one application. Usually this is not so. You may have to go to several applications, perhaps running on different platforms in your company environment, to get the information. What happens next? The marketing department likes the ad hoc reports you have produced. But now they would like reports in a different format, containing more information that they did not think of originally.

My interactions with them have enabled me to shape this textbook according to the needs of IT professionals. My special thanks are due to the wonderful staff and editors at Wiley, my publishers, who have worked with me and supported me for more than a decade in the publication and promotion of my books. D. Milltown, New Jersey October 2009 PART 1 OVERVIEW AND CONCEPTS CHAPTER 1 THE COMPELLING NEED FOR DATA WAREHOUSING CHAPTER OBJECTIVES † † † † † † Understand the desperate need for strategic information Recognize the information crisis at every enterprise Distinguish between operational and informational systems Learn why all past attempts to provide strategic information failed Clearly see why data warehousing is the viable solution Understand business intelligence for an enterprise As an information technology (IT) professional, you have worked on computer applications as an analyst, programmer, designer, developer, database administrator, or project manager.

Download PDF sample

Rated 4.26 of 5 – based on 14 votes