Agile Data Warehouse Design

Autore: Lawrence Corr
Editore: DecisionOne Consulting
ISBN: 0956817203
Grandezza: 67,84 MB
Formato: PDF, ePub, Mobi
Vista: 7199
Download

Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling ] brainstorming) with BI stakeholders. This book describes BEAM, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team. BEAM provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and entity relationship based tools and model interactively with their colleagues. The result is everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional modeling solutions. Business stakeholders feel ownership of the data warehouse they have created, and can already imagine how they will use it to answer their business questions. Within this book, you will learn: Agile dimensional modeling using Business Event Analysis & Modeling (BEAM ) Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun! Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how) Modeling by example not abstraction; using data story themes, not crow's feet, to describe detail Storyboarding the data warehouse to discover conformed dimensions and plan iterative development Visual modeling: sketching timelines, charts and grids to model complex process measurement - simply Agile design documentation: enhancing star schemas with BEAM dimensional shorthand notation Solving difficult DW/BI performance and usability problems with proven dimensional design patterns LawrenceCorr is a data warehouse designer and educator. As Principal of DecisionOne Consulting, he helps clients to review and simplify their data warehouse designs, and advises vendors on visual data modeling techniques. He regularly teaches agile dimensional modeling courses worldwide and has taught dimensional DW/BI skills to thousands of students. Jim Stagnitto is a data warehouse and master data management architect specializing in the healthcare, financial services, and information service industries. He is the founder of the data warehousing and data mining consulting firm Llumino.

Agile Data Warehousing For The Enterprise

Autore: Ralph Hughes
Editore: Newnes
ISBN: 0123965187
Grandezza: 46,23 MB
Formato: PDF, ePub, Docs
Vista: 7337
Download

Building upon his earlier book that detailed agile data warehousing programming techniques for the Scrum master, Ralph's latest work illustrates the agile interpretations of the remaining software engineering disciplines: Requirements management benefits from streamlined templates that not only define projects quickly, but ensure nothing essential is overlooked. Data engineering receives two new "hyper modeling" techniques, yielding data warehouses that can be easily adapted when requirements change without having to invest in ruinously expensive data-conversion programs. Quality assurance advances with not only a stereoscopic top-down and bottom-up planning method, but also the incorporation of the latest in automated test engines. Use this step-by-step guide to deepen your own application development skills through self-study, show your teammates the world's fastest and most reliable techniques for creating business intelligence systems, or ensure that the IT department working for you is building your next decision support system the right way. Learn how to quickly define scope and architecture before programming starts Includes techniques of process and data engineering that enable iterative and incremental delivery Demonstrates how to plan and execute quality assurance plans and includes a guide to continuous integration and automated regression testing Presents program management strategies for coordinating multiple agile data mart projects so that over time an enterprise data warehouse emerges Use the provided 120-day road map to establish a robust, agile data warehousing program

Agile Data Warehouse Design

Autore: Michael Blaha
Editore:
ISBN:
Grandezza: 11,81 MB
Formato: PDF, Mobi
Vista: 6036
Download

"In this Agile Data Warehouse Design training course, expert author Michael Blaha will teach you how to model and design a data warehouse. This course is designed for users that are already familiar with data warehouses. You will start with a data warehouse overview, then jump into learning about data sources, such as customer order, customer account, and vendor procurement. From there, Michael teaches you about staging tables, basic data warehouse modeling, recurrent dimensions, and advanced dimension data warehouse modeling. This video tutorial also covers data warehouse design, data warehouse data, and end user access. Finally, you will learn about metadata management. Once you have completed this computer based training course, you will be fully capable of modeling and designing your own data warehouse."--Resource description page.

Agile Data Warehousing

Autore: Ralph Hughes
Editore: iUniverse
ISBN: 0595471676
Grandezza: 57,99 MB
Formato: PDF, Mobi
Vista: 3638
Download

Contains a six-stage plan for starting new warehouse projects and guiding programmers step-by-step until they become a world-class, Agile development team. It describes also how to avoid or contain the fierce opposition that radically new methods can encounter from the traditionally-minded IS departments found in many large companies.

Agile Data Warehousing Project Management

Autore: Ralph Hughes
Editore: Newnes
ISBN: 0123964636
Grandezza: 10,36 MB
Formato: PDF, ePub, Docs
Vista: 6945
Download

What is agile data warehousing? -- Iterative development in a nutshell -- Streamlining project management -- Authoring better user stories -- Deriving initial project backlogs -- Developer stories for data integration -- Estimating and segmenting projects -- Adapting agile for data warehousing -- Starting and scaling agile data warehousing.

Building A Scalable Data Warehouse With Data Vault 2 0

Autore: Dan Linstedt
Editore: Morgan Kaufmann
ISBN: 0128026480
Grandezza: 17,35 MB
Formato: PDF, ePub
Vista: 7306
Download

The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures. "Building a Scalable Data Warehouse" covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. The book discusses how to build the data warehouse incrementally using the agile Data Vault 2.0 methodology. In addition, readers will learn how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 architecture including implementation best practices. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Linstedt and Michael Olschimke discuss: How to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes. Important data warehouse technologies and practices. Data Quality Services (DQS) and Master Data Services (MDS) in the context of the Data Vault architecture. Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouse Demystifies data vault modeling with beginning, intermediate, and advanced techniques Discusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0

Data Warehousing And Knowledge Discovery

Autore: Alfredo Cuzzocrea
Editore: Springer
ISBN: 364232584X
Grandezza: 62,44 MB
Formato: PDF, Docs
Vista: 6920
Download

This book constitutes the refereed proceedings of the 14th International Conference on Data Warehousing and Knowledge Discovery, DaWaK 2012 held in Vienna, Austria, in September 2012. The 36 revised full papers presented were carefully reviewed and selected from 99 submissions. The papers are organized in topical sections on data warehouse design methodologies, ETL methodologies and tools, multidimensional data processing and management, data warehouse and OLAP extensions, data warehouse performance and optimization, data mining and knowledge discovery techniques, data mining and knowledge discovery applications, pattern mining, data stream mining, data warehouse confidentiality and security, and distributed paradigms and algorithms.

Impossible Data Warehouse Situations

Autore: Sid Adelman
Editore: Addison-Wesley Professional
ISBN: 9780201760330
Grandezza: 13,92 MB
Formato: PDF, ePub
Vista: 6909
Download

Nine leading data warehouse experts provide answers to problematic situations encountered by a variety of organizations.

The Data Warehouse Mentor Practical Data Warehouse And Business Intelligence Insights

Autore: Robert Laberge
Editore: McGraw Hill Professional
ISBN: 0071745327
Grandezza: 58,56 MB
Formato: PDF, Docs
Vista: 527
Download

Develop a custom, agile data warehousing and business intelligence architecture Empower your users and drive better decision making across your enterprise with detailed instructions and best practices from an expert developer and trainer. The Data Warehouse Mentor: Practical Data Warehouse and Business Intelligence Insights shows how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. Learn how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered in this comprehensive guide. Understand the components of BI and data warehouse systems Establish project goals and implement an effective deployment plan Build accurate logical and physical enterprise data models Gain insight into your company's transactions with data mining Input, cleanse, and normalize data using ETL (Extract, Transform, and Load) techniques Use structured input files to define data requirements Employ top-down, bottom-up, and hybrid design methodologies Handle security and optimize performance using data governance tools Robert Laberge is the founder of several Internet ventures and a principle consultant for the IBM Industry Models and Assets Lab, which has a focus on data warehousing and business intelligence solutions.

Extreme Scoping

Autore: Larissa T. Moss
Editore: Technics Publications
ISBN: 1634620240
Grandezza: 27,85 MB
Formato: PDF, ePub, Docs
Vista: 8070
Download

Do your business intelligence (BI) projects take too long to deliver? Is the value of the deliverables less than satisfactory? Do these projects propagate poor data management practices? If you screamed “yes” to any of these questions, read this book to master a proven approach to building your enterprise data warehouse and BI initiatives. Extreme Scoping, based on the Business Intelligence Roadmap, will show you how to build analytics applications rapidly yet not sacrifice data management and enterprise architecture. In addition, all of the roles required to deliver all seven steps of this agile methodology are explained along with many real-world examples. From Wayne Eckerson’s Foreword I’ve read many books about data warehousing and business intelligence (BI). This book by Larissa Moss is one of the best. I should not be surprised. Larissa has spent years refining the craft of designing, building, and delivering BI applications. Over the years, she has developed a keen insight about what works and doesn’t work in BI. This book brings to light the wealth of that development experience. Best of all, this is not some dry text that laboriously steps readers through a technical methodology. Larissa expresses her ideas in a clear, concise, and persuasive manner. I highlighted so many beautifully written and insightful paragraphs in her manuscript that it became comical. I desperately wanted the final, published book rather than the manuscript so I could dog-ear it to death and place it front-and-center in my office bookshelf! From David Well’s Foreword Extreme Scoping is rich with advice and guidance for virtually every aspect of BI projects from planning and requirements to deployment and from back-end data management to front-end information and analytics services. Larissa is both a pragmatist and an independent thinker. Those qualities come through in the style of this book. Extreme Scoping is a well-written book that is easy to absorb. It is not full of surprises. It is filled with a lot of common sense and lessons learned through experience.

Data Warehousing Fundamentals For It Professionals

Autore: Paulraj Ponniah
Editore: John Wiley & Sons
ISBN: 1118211308
Grandezza: 60,43 MB
Formato: PDF
Vista: 9472
Download

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.

Sports Analytics

Autore: Benjamin C. Alamar
Editore: Columbia University Press
ISBN: 0231535252
Grandezza: 26,64 MB
Formato: PDF, Mobi
Vista: 207
Download

Benjamin C. Alamar founded the first journal dedicated to sports statistics, the Journal of Quantitative Analysis in Sports. He developed and teaches a class on sports analytics for managers at the University of San Francisco and has published numerous cutting-edge studies on strategy and player evaluation. Today, he cochairs the sports statistics section of the International Statistics Institute and consults with several professional teams and businesses in sports analytics. There isn't a better representative of this emerging field to show diverse organizations how to implement analytics into their decision-making strategies, especially as analytic tools grow increasingly complex. Alamar provides a clear, easily digestible survey of the practice and a detailed understanding of analytics' vast possibilities. He explains how to evaluate different programs and put them to use. Using concrete examples from professional sports teams and case studies demonstrating the use and value of analytics in the field, Alamar designs a roadmap for managers, general managers, and other professionals as they build their own programs and teach their approach to others.

Principles And Applications Of Business Intelligence Research

Autore: Herschel, Richard T.
Editore: IGI Global
ISBN: 146662681X
Grandezza: 35,41 MB
Formato: PDF
Vista: 3766
Download

"This book provides the latest ideas and research on advancing the understanding and implementation of business intelligence within organizations"--Provided by publisher.

Data Science And Big Data Analytics

Autore: EMC Education Services
Editore: John Wiley & Sons
ISBN: 1118876059
Grandezza: 27,27 MB
Formato: PDF, ePub, Mobi
Vista: 436
Download

Data Science and Big Data Analytics is about harnessing the power of data for new insights. The book covers the breadth of activities and methods and tools that Data Scientists use. The content focuses on concepts, principles and practical applications that are applicable to any industry and technology environment, and the learning is supported and explained with examples that you can replicate using open-source software. This book will help you: Become a contributor on a data science team Deploy a structured lifecycle approach to data analytics problems Apply appropriate analytic techniques and tools to analyzing big data Learn how to tell a compelling story with data to drive business action Prepare for EMC Proven Professional Data Science Certification Corresponding data sets are available at www.wiley.com/go/9781118876138. Get started discovering, analyzing, visualizing, and presenting data in a meaningful way today!

Data Warehouse Requirements Engineering

Autore: Naveen Prakash
Editore: Springer
ISBN: 9811070199
Grandezza: 26,24 MB
Formato: PDF, Mobi
Vista: 4634
Download

As the first to focus on the issue of Data Warehouse Requirements Engineering, this book introduces a model-driven requirements process used to identify requirements granules and incrementally develop data warehouse fragments. In addition, it presents an approach to the pair-wise integration of requirements granules for consolidating multiple data warehouse fragments. The process is systematic and does away with the fuzziness associated with existing techniques. Thus, consolidation is treated as a requirements engineering issue. The notion of a decision occupies a central position in the decision-based approach. On one hand, information relevant to a decision must be elicited from stakeholders; modeled; and transformed into multi-dimensional form. On the other, decisions themselves are to be obtained from decision applications. For the former, the authors introduce a suite of information elicitation techniques specific to data warehousing. This information is subsequently converted into multi-dimensional form. For the latter, not only are decisions obtained from decision applications for managing operational businesses, but also from applications for formulating business policies and for defining rules for enforcing policies, respectively. In this context, the book presents a broad range of models, tools and techniques. For readers from academia, the book identifies the scientific/technological problems it addresses and provides cogent arguments for the proposed solutions; for readers from industry, it presents an approach for ensuring that the product meets its requirements while ensuring low lead times in delivery.

The Data Warehouse Toolkit

Autore: Ralph Kimball
Editore: John Wiley & Sons
ISBN: 1118732286
Grandezza: 23,31 MB
Formato: PDF, ePub, Mobi
Vista: 4869
Download

Updated new edition of Ralph Kimball's groundbreaking book ondimensional modeling for data warehousing and businessintelligence! The first edition of Ralph Kimball's The Data WarehouseToolkit introduced the industry to dimensional modeling,and now his books are considered the most authoritative guides inthis space. This new third edition is a complete library of updateddimensional modeling techniques, the most comprehensive collectionever. It covers new and enhanced star schema dimensional modelingpatterns, adds two new chapters on ETL techniques, includes new andexpanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide aseducators, consultants, and influential thought leaders in datawarehousing and business intelligence Begins with fundamental design recommendations and progressesthrough increasingly complex scenarios Presents unique modeling techniques for business applicationssuch 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 andprovide fast query response with The Data WarehouseToolkit: The Definitive Guide to Dimensional Modeling, 3rdEdition.

Performing Information Governance

Autore: Anthony David Giordano
Editore: IBM Press
ISBN: 0133385639
Grandezza: 19,18 MB
Formato: PDF, Kindle
Vista: 9447
Download

Make Information Governance Work : Best Practices, Step-by-Step Tasks, and Detailed Deliverables Most enterprises recognize the crucial importance of effective information governance. However, few are satisfied with the value of their efforts to date. Information governance is difficult because it is a pervasive function, touching multiple processes, systems, and stakeholders. Fortunately, there are best practices that work. Now, a leading expert in the field offers a complete, step-by-step guide to successfully governing information in your organization. Using case studies and hands-on activities, Anthony Giordano fully illuminates the “who, what, how, and when” of information governance. He explains how core governance components link with other enterprise information management disciplines, and provides workable “job descriptions” for each project participant. Giordano helps you successfully integrate key data stewardship processes as you develop large-scale applications and Master Data Management (MDM) environments. Then, once you’ve deployed an information asset, he shows how to consistently get reliable regulatory and financial information from it. Performing Information Governance will be indispensable to CIOs and Chief Data Officers…data quality, metadata, and MDM specialists…anyone responsible for making information governance work. Coverage Includes Recognizing the hidden development and operational implications of information governance—and why it needs to be integrated in the broader organization Integrating information governance activities with transactional processing, BI, MDM, and other enterprise information management functions Establishing the information governance organization: defining roles, launching projects, and integrating with ongoing operations Performing information governance in transactional projects, including those using agile methods and COTS products Bringing stronger information governance to MDM: strategy, architecture, development, and beyond Governing information throughout your BI or Big Data project lifecycle Effectively performing ongoing information governance and data stewardship operational processes Auditing and enforcing data quality management in the context of enterprise information management Maintaining and evolving metadata management for maximum business value

Building The Agile Database

Autore: Larry Burns
Editore: Technics Publications
ISBN: 1634620232
Grandezza: 20,46 MB
Formato: PDF, ePub, Docs
Vista: 3487
Download

Is fast development the enemy of good development? Not necessarily. Agile development requires that databases are designed and built quickly enough to meet fast-based delivery schedules — but in a way that also delivers maximum business value and reuse. How can these requirements both be satisfied? This book, suitable for practitioners at all levels, will explain how to design and build enterprise-quality high-value databases within the constraints of an Agile project. Starting with an overview of the business case for good data management practices, the book defines the various stakeholder groups involved in the software development process, explains the economics of software development (including “time to market” vs. “time to money”), and describes an approach to Agile database development based on the five PRISM principles. This book explains how to work with application developers and other stakeholders, examines critical issues in Agile Development and Data Management, and describes how developers and data professionals can work together to make Agile projects successful while delivering maximum value data to the enterprise. Building the Agile Database will serve as an excellent reference for application developers, data managers, DBAs, project managers, Scrum Masters and IT managers looking to get more value from their development efforts. Among the topics covered: 1. Why Agile is more than just the latest development fad 2. The critical distinction between the logical and physical views of data 3. The importance of data virtualization, and how to achieve it 4. How to eliminate the “object-relational impedance mismatch” 5. The difference between logical modeling and physical design 6. Why databases are more than “persistence engines” 7. When and how to do logical modeling and physical design 8. Use of the logical data model in model-driven development 9. Refactoring made easier 10. Developing an “Agile Attitude”

More Agile Testing

Autore: Janet Gregory
Editore: Addison-Wesley Professional
ISBN: 0133749568
Grandezza: 71,34 MB
Formato: PDF, ePub
Vista: 4314
Download

Janet Gregory and Lisa Crispin pioneered the agile testing discipline with their previous work, Agile Testing. Now, in More Agile Testing, they reflect on all they’ve learned since. They address crucial emerging issues, share evolved agile practices, and cover key issues agile testers have asked to learn more about. Packed with new examples from real teams, this insightful guide offers detailed information about adapting agile testing for your environment; learning from experience and continually improving your test processes; scaling agile testing across teams; and overcoming the pitfalls of automated testing. You’ll find brand-new coverage of agile testing for the enterprise, distributed teams, mobile/embedded systems, regulated environments, data warehouse/BI systems, and DevOps practices. You’ll come away understanding • How to clarify testing activities within the team • Ways to collaborate with business experts to identify valuable features and deliver the right capabilities • How to design automated tests for superior reliability and easier maintenance • How agile team members can improve and expand their testing skills • How to plan “just enough,” balancing small increments with larger feature sets and the entire system • How to use testing to identify and mitigate risks associated with your current agile processes and to prevent defects • How to address challenges within your product or organizational context • How to perform exploratory testing using “personas” and “tours” • Exploratory testing approaches that engage the whole team, using test charters with session- and thread-based techniques • How to bring new agile testers up to speed quickly–without overwhelming them The eBook edition of More Agile Testing also is available as part of a two-eBook collection, The Agile Testing Collection (9780134190624).