Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance
Author: Christopher Adamson
Publisher: John Wiley & Sons
ISBN: 1118429184
Category: Computers
Page: 384
View: 1277

Continue Reading →

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

Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance
Author: Christopher Adamson
Publisher: John Wiley & Sons
ISBN: 0471777099
Category: Computers
Page: 345
View: 7380

Continue Reading →

Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with eight task-oriented minibooks that cover begininning to advanced-level material Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Mastering Data Warehouse Aggregates

Solutions for Star Schema Performance
Author: Christopher Adamson
Publisher: Wiley
ISBN: 0470073683
Category: Computers
Page: 336
View: 6008

Continue Reading →

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

Mastering Data Warehouse Design

Relational and Dimensional Techniques
Author: Claudia Imhoff,Nicholas Galemmo,Jonathan G. Geiger
Publisher: John Wiley & Sons
ISBN: 0471480924
Category: Computers
Page: 456
View: 1849

Continue Reading →

A cutting-edge response to Ralph Kimball's challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing Written by one of the best-known exponents of the Bill Inmon approach to data warehousing Addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems Weighs the pros and cons of relational vs. dimensional modeling techniques Focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality

Data warehouse design solutions


Author: Christopher Adamson,Michael Venerable
Publisher: John Wiley & Sons Inc
ISBN: N.A
Category: Business & Economics
Page: 523
View: 1852

Continue Reading →

"Each chapter is... a practice run for the way we all ought to design our data marts and hence our data warehouses."-Ralph Kimball, from the Foreword. Let the experts show you how to customize data warehouse designs for real business needs in Data Warehouse Design Solutions. To effectively design a data warehouse, you have to understand its many business uses. This guidebook shows you how business managers in different corporate functions actually use data warehouses to make decisions. You'll get a rich set of data warehouse designs that flow from realistic business cases. Two top experts show you how to customize your data warehouse designs for real-life business needs including: * Sales and marketing * Production and inventory management * Budgeting and financial reporting * Quality control * Product delivery and fulfillment * Strategic business analysis such as determining market share, rates of return on investment, and other key analytic ratios. CD-ROM includes All sample data warehouse designs with accompanying preformatted reports in HTML for specific business uses such as marketing, sales, and financial analysis.

Star Schema The Complete Reference


Author: Christopher Adamson
Publisher: McGraw Hill Professional
ISBN: 9780071744331
Category: Computers
Page: 510
View: 3012

Continue Reading →

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 Warehousing Fundamentals

A Comprehensive Guide for IT Professionals
Author: Paulraj Ponniah
Publisher: John Wiley & Sons
ISBN: 0471463892
Category: Computers
Page: 544
View: 4428

Continue Reading →

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.

Mastering Tableau


Author: David Baldwin
Publisher: Packt Publishing Ltd
ISBN: 1784398845
Category: Computers
Page: 476
View: 3188

Continue Reading →

Master the intricacies of Tableau to create effective data visualizations About This Book Arm yourself with an arsenal of advanced chart types and geocoding to efficiently and engagingly present information Map a grid over a network node diagram and use that grid to demonstrate loads, processing time, and more in Tableau Integrate R with Tableau by utilizing R functions, libraries, and saved models Who This Book Is For If you are a business analyst without developer-level programming skills, then this book is for you. You are expected to have at least a fundamental understanding of Tableau and basic knowledge of joins, however SQL knowledge is not assumed. You should have basic computer skills, including at least moderate Excel proficiency. What You Will Learn Create a worksheet that can display the current balance for any given period in time Recreate a star schema from in a data warehouse in Tableau Combine level of detail calculations with table calculations, sets, and parameters Create custom polygons to build filled maps for area codes in the USA Visualize data using a set of analytical and advanced charting techniques Know when to use Tableau instead of PowerPoint Build a dashboard and export it to PowerPoint In Detail Tableau has emerged as one of the most popular Business Intelligence solutions in recent times, thanks to its powerful and interactive data visualization capabilities. This book will empower you to become a master in Tableau by exploiting the many new features introduced in Tableau 10.0. You will embark on this exciting journey by getting to know the valuable methods of utilizing advanced calculations to solve complex problems. These techniques include creative use of different types of calculations such as row-level, aggregate-level, and more. You will discover how almost any data visualization challenge can be met in Tableau by getting a proper understanding of the tool's inner workings and creatively exploring possibilities. You'll be armed with an arsenal of advanced chart types and techniques to enable you to efficiently and engagingly present information to a variety of audiences through the use of clear, efficient, and engaging dashboards. Explanations and examples of efficient and inefficient visualization techniques, well-designed and poorly designed dashboards, and compromise options when Tableau consumers will not embrace data visualization will build on your understanding of Tableau and how to use it efficiently. By the end of the book, you will be equipped with all the information you need to create effective dashboards and data visualization solutions using Tableau. Style and approach This book takes a direct approach, to systematically evolve to more involved functionalities such as advanced calculation, parameters & sets, data blending and R integration. This book will help you gain skill in building visualizations previously beyond your capacity.

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: 8696

Continue Reading →

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.

Mastering MongoDB 3.x

An expert's guide to building fault-tolerant MongoDB applications
Author: Alex Giamas
Publisher: Packt Publishing Ltd
ISBN: 1783982616
Category: Computers
Page: 342
View: 6082

Continue Reading →

An expert's guide to build fault tolerant MongoDB application About This Book Master the advanced modeling, querying, and administration techniques in MongoDB and become a MongoDB expert Covers the latest updates and Big Data features frequently used by professional MongoDB developers and administrators If your goal is to become a certified MongoDB professional, this book is your perfect companion Who This Book Is For Mastering MongoDB is a book for database developers, architects, and administrators who want to learn how to use MongoDB more effectively and productively. If you have experience in, and are interested in working with, NoSQL databases to build apps and websites, then this book is for you. What You Will Learn Get hands-on with advanced querying techniques such as indexing, expressions, arrays, and more. Configure, monitor, and maintain highly scalable MongoDB environment like an expert. Master replication and data sharding to optimize read/write performance. Design secure and robust applications based on MongoDB. Administer MongoDB-based applications on-premise or in the cloud Scale MongoDB to achieve your design goals Integrate MongoDB with big data sources to process huge amounts of data In Detail MongoDB has grown to become the de facto NoSQL database with millions of users—from small startups to Fortune 500 companies. Addressing the limitations of SQL schema-based databases, MongoDB pioneered a shift of focus for DevOps and offered sharding and replication maintainable by DevOps teams. The book is based on MongoDB 3.x and covers topics ranging from database querying using the shell, built in drivers, and popular ODM mappers to more advanced topics such as sharding, high availability, and integration with big data sources. You will get an overview of MongoDB and how to play to its strengths, with relevant use cases. After that, you will learn how to query MongoDB effectively and make use of indexes as much as possible. The next part deals with the administration of MongoDB installations on-premise or in the cloud. We deal with database internals in the next section, explaining storage systems and how they can affect performance. The last section of this book deals with replication and MongoDB scaling, along with integration with heterogeneous data sources. By the end this book, you will be equipped with all the required industry skills and knowledge to become a certified MongoDB developer and administrator. Style and approach This book takes a practical, step-by-step approach to explain the concepts of MongoDB. Practical use-cases involving real-world examples are used throughout the book to clearly explain theoretical concepts.

Managing Data in Motion

Data Integration Best Practice Techniques and Technologies
Author: April Reeve
Publisher: Newnes
ISBN: 0123977916
Category: Computers
Page: 204
View: 6858

Continue Reading →

Managing Data in Motion describes techniques that have been developed for significantly reducing the complexity of managing system interfaces and enabling scalable architectures. Author April Reeve brings over two decades of experience to present a vendor-neutral approach to moving data between computing environments and systems. Readers will learn the techniques, technologies, and best practices for managing the passage of data between computer systems and integrating disparate data together in an enterprise environment. The average enterprise's computing environment is comprised of hundreds to thousands computer systems that have been built, purchased, and acquired over time. The data from these various systems needs to be integrated for reporting and analysis, shared for business transaction processing, and converted from one format to another when old systems are replaced and new systems are acquired. The management of the "data in motion" in organizations is rapidly becoming one of the biggest concerns for business and IT management. Data warehousing and conversion, real-time data integration, and cloud and "big data" applications are just a few of the challenges facing organizations and businesses today. Managing Data in Motion tackles these and other topics in a style easily understood by business and IT managers as well as programmers and architects. Presents a vendor-neutral overview of the different technologies and techniques for moving data between computer systems including the emerging solutions for unstructured as well as structured data types Explains, in non-technical terms, the architecture and components required to perform data integration Describes how to reduce the complexity of managing system interfaces and enable a scalable data architecture that can handle the dimensions of "Big Data"

Mastering Oracle SQL

Putting Oracle SQL to Work
Author: Sanjay Mishra,Alan Beaulieu
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596552473
Category: Computers
Page: 496
View: 8377

Continue Reading →

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

The Data Warehouse Lifecycle Toolkit


Author: Ralph Kimball,Margy Ross,Warren Thornthwaite,Joy Mundy,Bob Becker
Publisher: John Wiley & Sons
ISBN: 1118079566
Category: Computers
Page: 672
View: 1400

Continue Reading →

A thorough update to the industry standard for designing, developing, and deploying data warehouse and business intelligence systems The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. In that time, the data warehouse industry has reached full maturity and acceptance, hardware and software have made staggering advances, and the techniques promoted in the premiere edition of this book have been adopted by nearly all data warehouse vendors and practitioners. In addition, the term "business intelligence" emerged to reflect the mission of the data warehouse: wrangling the data out of source systems, cleaning it, and delivering it to add value to the business. Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. The authors understand first-hand that a data warehousing/business intelligence (DW/BI) system needs to change as fast as its surrounding organization evolves. To that end, they walk you through the detailed steps of designing, developing, and deploying a DW/BI system. You'll learn to create adaptable systems that deliver data and analyses to business users so they can make better business decisions.

A Manager's Guide to Data Warehousing


Author: Laura Reeves
Publisher: John Wiley & Sons
ISBN: 0470176385
Category: Business & Economics
Page: 451
View: 5318

Continue Reading →

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.

The Kimball Group Reader

Relentlessly Practical Tools for Data Warehousing and Business Intelligence Remastered Collection
Author: Ralph Kimball,Margy Ross
Publisher: John Wiley & Sons
ISBN: 1119216591
Category: Computers
Page: 912
View: 4501

Continue Reading →

The final edition of the incomparable data warehousing and business intelligence reference, updated and expanded The Kimball Group Reader, Remastered Collection is the essential reference for data warehouse and business intelligence design, packed with best practices, design tips, and valuable insight from industry pioneer Ralph Kimball and the Kimball Group. This Remastered Collection represents decades of expert advice and mentoring in data warehousing and business intelligence, and is the final work to be published by the Kimball Group. Organized for quick navigation and easy reference, this book contains nearly 20 years of experience on more than 300 topics, all fully up-to-date and expanded with 65 new articles. The discussion covers the complete data warehouse/business intelligence lifecycle, including project planning, requirements gathering, system architecture, dimensional modeling, ETL, and business intelligence analytics, with each group of articles prefaced by original commentaries explaining their role in the overall Kimball Group methodology. Data warehousing/business intelligence industry's current multi-billion dollar value is due in no small part to the contributions of Ralph Kimball and the Kimball Group. Their publications are the standards on which the industry is built, and nearly all data warehouse hardware and software vendors have adopted their methods in one form or another. This book is a compendium of Kimball Group expertise, and an essential reference for anyone in the field. Learn data warehousing and business intelligence from the field's pioneers Get up to date on best practices and essential design tips Gain valuable knowledge on every stage of the project lifecycle Dig into the Kimball Group methodology with hands-on guidance Ralph Kimball and the Kimball Group have continued to refine their methods and techniques based on thousands of hours of consulting and training. This Remastered Collection of The Kimball Group Reader represents their final body of knowledge, and is nothing less than a vital reference for anyone involved in the field.

Mastering Enterprise JavaBeans 3.0


Author: Rima Patel Sriganesh,Gerald Brose,Micah Silverman
Publisher: John Wiley & Sons
ISBN: 0470072997
Category: Computers
Page: 720
View: 2158

Continue Reading →

An invaluable tutorial on the dramatic changes to Enterprise JavaBeans (EJB) 3.0 Featuring myriad changes from its previous versions, EJB 3.0 boasts a very different programming and deployment model, with nearly every aspect of development affected. Even the most experienced EBJ and J2EE developers will need to relearn how to best use EJB to develop mission-critical applications. This author team of experts has taken their combined skills in architecture, development, consulting, and knowledge transfer to explain the various changes to EJB 3.0 as well as the rationale behind these changes. You'll learn the concepts and techniques for authoring distributed, enterprise components in Java from the ground up. Covering basic through advanced subjects, Mastering Enterprise JavaBeans 3.0 is more than 50 percent new and revised. Four new chapters and one new appendix cover the latest features of this new release, and in-depth coverage of the Java Persistence API and the entities defined therein is provided. The authors' main goal is to get you programming with EJB immediately. To that end, you'll learn: * How to implement EJB 3.0 beans, with emphasis on session beans (stateful and stateless) and message-driven beans * Both basic and advanced concepts (such as inheritance, relationships, and so on) of Java Persistence API defined entities * How to develop and deploy EJB 3.0 Web services * How to secure EJB applications * How to integrate EJB applications with the outside world via the Java EE Connector technology * Tips and techniques for designing and deploying EJB for better performance * How clustering in large-scale EJB systems works * Best practices for EJB application design, development, and testing The companion Web site provides all the source code, updates to the source code examples, and a PDF version of the book. Wiley Technology Publishing Timely. Practical. Reliable. Visit the companion Web site at www.wiley.com/go/sriganesh

The Microsoft Data Warehouse Toolkit

With SQL Server 2005 and the Microsoft Business Intelligence Toolset
Author: Joy Mundy,Warren Thornthwaite
Publisher: John Wiley & Sons
ISBN: 0470007362
Category: Computers
Page: 768
View: 2199

Continue Reading →

OLAP Solutions

Building Multidimensional Information Systems
Author: Erik Thomsen
Publisher: John Wiley & Sons
ISBN: 0471266256
Category: Business & Economics
Page: 688
View: 2692

Continue Reading →

OLAP enables users to access information from multidimensional data warehouses almost instantly, to view information in any way they like, and to cleanly specify and carry out sophisticated calculations. Although many commercial OLAP tools and products are now available, OLAP is still a difficult and complex technology to master. Substantially updated with expanded coverage of implementation methods for data storage, access, and calculation; also, new chapters added to combine OLAP with data warehouse, mining, and decision support tools Teaches the best practices for building OLAP models that improve business and organizational decision-making, completely independent of commercial tools, using revised case studies Companion Web site provides updates on OLAP standards and tools, code examples, and links to valuable resources

Enterprise Integration Patterns

Designing, Building, and Deploying Messaging Solutions
Author: Gregor Hohpe,Bobby Woolf
Publisher: Addison-Wesley
ISBN: 0133065103
Category: Computers
Page: 735
View: 7850

Continue Reading →

Enterprise Integration Patterns provides an invaluable catalog of sixty-five patterns, with real-world solutions that demonstrate the formidable of messaging and help you to design effective messaging solutions for your enterprise. The authors also include examples covering a variety of different integration technologies, such as JMS, MSMQ, TIBCO ActiveEnterprise, Microsoft BizTalk, SOAP, and XSL. A case study describing a bond trading system illustrates the patterns in practice, and the book offers a look at emerging standards, as well as insights into what the future of enterprise integration might hold. This book provides a consistent vocabulary and visual notation framework to describe large-scale integration solutions across many technologies. It also explores in detail the advantages and limitations of asynchronous messaging architectures. The authors present practical advice on designing code that connects an application to a messaging system, and provide extensive information to help you determine when to send a message, how to route it to the proper destination, and how to monitor the health of a messaging system. If you want to know how to manage, monitor, and maintain a messaging system once it is in use, get this book.

Mastering Visual C# .NET


Author: Jason Price,Mike Gunderloy
Publisher: John Wiley & Sons
ISBN: 9780782152234
Category: Computers
Page: 1008
View: 1403

Continue Reading →

Get Everything You Can Out of Visual C# and the .NET Framework Mastering Visual C# .NET is the best resource for getting everything you can out of the new C# language and the .NET Framework. You'll master C# language essentials, quickly taking advantage of the many improvements it offers over C++ and see tons of examples that show you all the ways that .NET can make your programming more efficient and your applications more powerful. You'll learn how to create stand-alone applications, as well as build Windows, web, and database applications. You'll even see how to develop web services—a technology that holds great promise for the future of distributed application. Coverage includes: Mastering the fundamentals and advanced aspects of the C# language Using Visual Studio .NET for increased coding productivity and debugging Creating distributed applications with remoting and web services Understanding object-oriented concepts Delivering data across the Internet with web services Using XML to communicate with other applications Accessing databases with ADO.NET Building Windows applications Creating web applications using ASP.NET Reading and writing data from/to files or the Internet Using advanced data structures to store and manipulate information Using multi-threading for greater application efficiency Using reflection to manipulate running code Building distributed applications with remoting and web services Securing code and authenticating users Using built-in encryption facilities Making your applications world-ready Parsing strings with regular expressions Using delegates to handle runtime events Programming defensively with exception handling