Data Warehousing Fundamentals

A Comprehensive Guide for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 0471463892

Category: Computers

Page: 544

View: 2068

DOWNLOAD NOW »
Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations. Market: IT Professionals, Consultants.

Data Warehousing Fundamentals for IT Professionals

Author: Paulraj Ponniah

Publisher: John Wiley & Sons

ISBN: 1118211308

Category: Computers

Page: 600

View: 6606

DOWNLOAD NOW »
Cutting-edge content and guidance from a data warehousing expert—now expanded to reflect field trends Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous enterprises have implemented data warehouse systems and reaped enormous benefits. Many more are in the process of doing so. Now, this new, revised edition covers the essential fundamentals of data warehousing and business intelligence as well as significant recent trends in the field. The author provides an enhanced, comprehensive overview of data warehousing together with in-depth explanations of critical issues in planning, design, deployment, and ongoing maintenance. IT professionals eager to get into the field will gain a clear understanding of techniques for data extraction from source systems, data cleansing, data transformations, data warehouse architecture and infrastructure, and the various methods for information delivery. This practical Second Edition highlights the areas of data warehousing and business intelligence where high-impact technological progress has been made. Discussions on developments include data marts, real-time information delivery, data visualization, requirements gathering methods, multi-tier architecture, OLAP applications, Web clickstream analysis, data warehouse appliances, and data mining techniques. The book also contains review questions and exercises for each chapter, appropriate for self-study or classroom work, industry examples of real-world situations, and several appendices with valuable information. Specifically written for professionals responsible for designing, implementing, or maintaining data warehousing systems, Data Warehousing Fundamentals presents agile, thorough, and systematic development principles for the IT professional and anyone working or researching in information management.

The Data Warehouse Toolkit

The Definitive Guide to Dimensional Modeling

Author: Ralph Kimball,Margy Ross

Publisher: John Wiley & Sons

ISBN: 1118732286

Category: Computers

Page: 600

View: 3570

DOWNLOAD NOW »
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Data Warehousing in the Age of Big Data

Author: Krish Krishnan

Publisher: Newnes

ISBN: 0124059201

Category: Computers

Page: 370

View: 3058

DOWNLOAD NOW »
Data Warehousing in the Age of the Big Data will help you and your organization make the most of unstructured data with your existing data warehouse. As Big Data continues to revolutionize how we use data, it doesn't have to create more confusion. Expert author Krish Krishnan helps you make sense of how Big Data fits into the world of data warehousing in clear and concise detail. The book is presented in three distinct parts. Part 1 discusses Big Data, its technologies and use cases from early adopters. Part 2 addresses data warehousing, its shortcomings, and new architecture options, workloads, and integration techniques for Big Data and the data warehouse. Part 3 deals with data governance, data visualization, information life-cycle management, data scientists, and implementing a Big Data–ready data warehouse. Extensive appendixes include case studies from vendor implementations and a special segment on how we can build a healthcare information factory. Ultimately, this book will help you navigate through the complex layers of Big Data and data warehousing while providing you information on how to effectively think about using all these technologies and the architectures to design the next-generation data warehouse. Learn how to leverage Big Data by effectively integrating it into your data warehouse. Includes real-world examples and use cases that clearly demonstrate Hadoop, NoSQL, HBASE, Hive, and other Big Data technologies Understand how to optimize and tune your current data warehouse infrastructure and integrate newer infrastructure matching data processing workloads and requirements

Building the Data Warehouse

Author: W. H. Inmon

Publisher: John Wiley & Sons

ISBN: 0471774235

Category: Computers

Page: 543

View: 6591

DOWNLOAD NOW »
The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects Covers advanced topics, including data monitoring and testing Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

Dimensional Modeling: In a Business Intelligence Environment

Author: Chuck Ballard,Daniel M. Farrell,Amit Gupta,Carlos Mazuela,Stanislav Vohnik,IBM Redbooks

Publisher: IBM Redbooks

ISBN: 0738496448

Category: Computers

Page: 664

View: 9290

DOWNLOAD NOW »
In this IBM Redbooks publication we describe and demonstrate dimensional data modeling techniques and technology, specifically focused on business intelligence and data warehousing. It is to help the reader understand how to design, maintain, and use a dimensional model for data warehousing that can provide the data access and performance required for business intelligence. Business intelligence is comprised of a data warehousing infrastructure, and a query, analysis, and reporting environment. Here we focus on the data warehousing infrastructure. But only a specific element of it, the data model - which we consider the base building block of the data warehouse. Or, more precisely, the topic of data modeling and its impact on the business and business applications. The objective is not to provide a treatise on dimensional modeling techniques, but to focus at a more practical level. There is technical content for designing and maintaining such an environment, but also business content. For example, we use case studies to demonstrate how dimensional modeling can impact the business intelligence requirements for your business initiatives. In addition, we provide a detailed discussion on the query aspects of BI and data modeling. For example, we discuss query optimization and how you can determine performance of the data model prior to implementation. You need a solid base for your data warehousing infrastructure . . . . a solid data model.

Managing the data warehouse

Author: William H. Inmon,J. D. Welch,Katherine L. Glassey

Publisher: John Wiley & Sons Inc

ISBN: N.A

Category: Computers

Page: 386

View: 6965

DOWNLOAD NOW »
A data warehouse allows enterprises to store and access vast amounts of information quickly and efficiently. The authors look at how to monitor data warehouse performance, administer the necessary tools and system interfaces, and manage growth.

Enterprise Dashboards

Design and Best Practices for IT

Author: Shadan Malik

Publisher: John Wiley & Sons

ISBN: 0471741930

Category: Business & Economics

Page: 240

View: 1653

DOWNLOAD NOW »
Enterprise Dashboards: Design and Best Practices for IT is a one-stop resource of methodology and best practices for this dynamic and relevant information platform, packed with charts, reports, visual indicators, and alert mechanisms, all consolidated in a rich computer interface. This powerful book is both a guide and a handbook. It helps business leaders understand dashboarding while considering dashboards for their information needs and outlines a tested and proven, step-by-step implementation framework. Enterprise Dashboards covers strategies, vendor selections, execution steps, project milestones, dashboard types, case studies contributed by DaimlerChrysler, Emergency Medical Associates, and ING Direct, and more. Enterprise Dashboards: Design and Best Practices for IT is the perfect tool to help COOs, CIOs, CFOs, CTOs, IT managers, business intelligence managers, information analysts, and software consultants be successful at dashboard implementation.

An R and S-Plus® Companion to Multivariate Analysis

Author: Brian S. Everitt

Publisher: Springer Science & Business Media

ISBN: 1846281245

Category: Mathematics

Page: 221

View: 8772

DOWNLOAD NOW »
Applied statisticians often need to perform analyses of multivariate data; for these they will typically use one of the statistical software packages, S-Plus or R. This book sets out how to use these packages for these analyses in a concise and easy-to-use way, and will save users having to buy two books for the job. The author is well-known for this kind of book, and so buyers will trust that he’s got it right.

Business Intelligence and Data Warehousing Simplified

500 Questions, Answers, and Tips

Author: Arshad Khan

Publisher: Mercury Learning & Information

ISBN: 9781936420322

Category: Computers

Page: 296

View: 2210

DOWNLOAD NOW »
This book targets business and IT professionals who need an introduction to business intelligence and data warehousing fundamentals through a simple question / answer format. Topics include evolution and fundamentals, characteristics and process, architecture and objects, metadata, data conversion, ETL, data storage, infrastructure, data access, data marts, implementation approaches, planning, design, Inmon vs. Kimball, multi-dimensionality, OLAP, facts and dimensions, common mistakes and tips, trends, etc.

E-Data

Turning Data Into Information with Data Warehousing

Author: Jill Dyché

Publisher: Addison-Wesley Professional

ISBN: 9780201657807

Category: Business & Economics

Page: 335

View: 9303

DOWNLOAD NOW »
Dyche presents the complete manager's briefing on what data warehousing technology can do today and how to achieve optimal results. Using real-world case studies from Charles Schwab, Bank of America, Qantas, 20th Century Fox, and others, she covers decision support, database marketing, and many industry-specific data warehouse applications.

Fundamentals of Multimedia

Author: Ze-Nian Li,Mark S. Drew,Jiangchuan Liu

Publisher: Springer Science & Business Media

ISBN: 331905290X

Category: Computers

Page: 727

View: 3383

DOWNLOAD NOW »
This textbook introduces the “Fundamentals of Multimedia”, addressing real issues commonly faced in the workplace. The essential concepts are explained in a practical way to enable students to apply their existing skills to address problems in multimedia. Fully revised and updated, this new edition now includes coverage of such topics as 3D TV, social networks, high-efficiency video compression and conferencing, wireless and mobile networks, and their attendant technologies. Features: presents an overview of the key concepts in multimedia, including color science; reviews lossless and lossy compression methods for image, video and audio data; examines the demands placed by multimedia communications on wired and wireless networks; discusses the impact of social media and cloud computing on information sharing and on multimedia content search and retrieval; includes study exercises at the end of each chapter; provides supplementary resources for both students and instructors at an associated website.

DATA WAREHOUSING

Concepts, Techniques, Products and Applications

Author: C.S.R. PRABHU

Publisher: PHI Learning Pvt. Ltd.

ISBN: 8120336275

Category: Computers

Page: 184

View: 6929

DOWNLOAD NOW »
The Third Edition of this well-received text analyses the fundamental concepts of data warehousing, data marts, and OLAP. The author discusses, in an easy-to-understand language, important topics such as data mining, how to build a data warehouse, and potential applications of data warehousing technology in government. Besides, the text compares and contrasts the currently available software tools used to design and develop data warehouses. While retaining the six existing case studies, it gives four new case studies:  HARBOR, A Highly Available Data Warehouse  A Typical Business Data Warehouse for a Trading Company  Customer Data Warehouse for the World’s First and Largest Online Bank in the United Kingdom  A German Supermarket EDEKA’s Data Warehouse The book, which is a blend of principles and real-life case studies, is intended as a text for students of B.Tech/M.Tech (Computer Science and Engineering), B.Tech/M.Tech (Information Technology), MBA, M.Sc. (Computer Science), M.Sc. (Information Technology), and MCA. It should also be of considerable utility and worth to software professionals and database practitioners.

Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance

Author: Christopher Adamson

Publisher: John Wiley & Sons

ISBN: 1118429184

Category: Computers

Page: 384

View: 6430

DOWNLOAD NOW »
This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

Star Schema The Complete Reference

Author: Christopher Adamson

Publisher: McGraw Hill Professional

ISBN: 9780071744331

Category: Computers

Page: 510

View: 6308

DOWNLOAD NOW »
The definitive guide to dimensional design for your data warehouse Learn the best practices of dimensional design. Star Schema: The Complete Reference offers in-depth coverage of design principles and their underlying rationales. Organized around design concepts and illustrated with detailed examples, this is a step-by-step guidebook for beginners and a comprehensive resource for experts. This all-inclusive volume begins with dimensional design fundamentals and shows how they fit into diverse data warehouse architectures, including those of W.H. Inmon and Ralph Kimball. The book progresses through a series of advanced techniques that help you address real-world complexity, maximize performance, and adapt to the requirements of BI and ETL software products. You are furnished with design tasks and deliverables that can be incorporated into any project, regardless of architecture or methodology. Master the fundamentals of star schema design and slow change processing Identify situations that call for multiple stars or cubes Ensure compatibility across subject areas as your data warehouse grows Accommodate repeating attributes, recursive hierarchies, and poor data quality Support conflicting requirements for historic data Handle variation within a business process and correlation of disparate activities Boost performance using derived schemas and aggregates Learn when it's appropriate to adjust designs for BI and ETL tools

Data Mining and Warehousing

Author: S. Prabhu

Publisher: New Age International

ISBN: 8122419720

Category: Data mining

Page: 144

View: 6689

DOWNLOAD NOW »
Data Mining is the process of analyzing large amount of data in search of previously undiscovered business patterns. Data Warehousing is a relational/multidimensional database that is designed for Query and Analysis rather than Transaction Processing. This book provides a systematic introduction to the principles of Data Mining and Data Warehousing. It covers the entire range of data mining algorithms (prediction, classification, and association), data mining products and applications, stages.

Oracle DBA Guide to Data Warehousing and Star Schemas

Author: Bert Scalzo

Publisher: Prentice Hall Professional

ISBN: 9780130325846

Category: Computers

Page: 208

View: 1689

DOWNLOAD NOW »
The ultimate reference guide to successful implementation of star schemas within Oracle data warehouses, this edition also covers Oracle 8i and Oracle 9i with real-world examples, sample code and benchmarks to illustrate key concepts.

Data Warehousing

Author: Reema Thareja

Publisher: Oxford University Press, USA

ISBN: 9780195699616

Category: Computers

Page: 474

View: 3683

DOWNLOAD NOW »
Data Warehousing is designed to serve as a textbook for students of Computer Science & Engineering (BE/Btech), computer applications (BCA/MCA) and computer science (B.Sc) for an introductory course on Data Warehousing. It provides a thorough understanding of the fundamentals of Data Warehousing and aims to impart a sound knowledge to users for creating and managing a Data Warehouse. The book introduces the various features and architecture of a Data Warehouse followed by a detailed study of the Business Requirements and Dimensional Modelling. It goes on to discuss the components of a Data Warehouse and thereby leads up to the core area of the subject by providing a thorough understanding of the building and maintenance of a Data Warehouse. This is then followed up by an overview of planning and project management, testing and growth and then finishing with Data Warehouse solutions and the latest trends in this field. The book is finally rounded off with a broad overview of its related field of study, Data Mining. The text is ably supported by plenty of examples to illustrate concepts and contains several review questions and other end-chapter exercises to test the understanding of students. The book also carries a running case study that aims to bring out the practical aspects of the subject. This will be useful for students to master the basics and apply them to real-life scenario.

Big Data For Dummies

Author: Judith Hurwitz,Alan Nugent,Fern Halper,Marcia Kaufman

Publisher: John Wiley & Sons

ISBN: 1118644174

Category: Computers

Page: 336

View: 6359

DOWNLOAD NOW »
Find the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work. Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionals Authors are experts in information management, big data, and a variety of solutions Explains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much more Provides essential information in a no-nonsense, easy-to-understand style that is empowering Big Data For Dummies cuts through the confusion and helps you take charge of big data solutions for your organization.

A Manager's Guide to Data Warehousing

Author: Laura Reeves

Publisher: John Wiley & Sons

ISBN: 0470176385

Category: Business & Economics

Page: 451

View: 2179

DOWNLOAD NOW »
Aimed at helping business and IT managers clearly communicate with each other, this helpful book addresses concerns straight-on and provides practical methods to building a collaborative data warehouse . You’ll get clear explanations of the goals and objectives of each stage of the data warehouse lifecycle while learning the roles that both business managers and technicians play at each stage. Discussions of the most critical decision points for success at each phase of the data warehouse lifecycle help you understand ways in which both business and IT management can make decisions that best meet unified objectives.