Star Schema The Complete Reference


Author: Christopher Adamson
Publisher: McGraw Hill Professional
ISBN: 9780071744331
Category: Computers
Page: 510
View: 7394
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

Star Schema The Complete Reference


Author: Christopher Adamson
Publisher: McGraw-Hill Education
ISBN: 9780071744324
Category: Computers
Page: 510
View: 7776
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

The Star Schema Handbook

The Complete Reference to Dimensional Data Warehouse Design
Author: Christopher Adamson
Publisher: John Wiley and Sons
ISBN: 0470477261
Category: Computers
Page: 408
View: 7762
DOWNLOAD NOW »
The first comprehensive handbook on star schema design The Star Schema Handbook is a comprehensive guide to dimensional modeling covering both basic and advanced topics. Organized around technical concepts rather than business examples, this is the perfect resource for data warehouse designers or developers. The book is architecture-neutral, providing full coverage of the best practices for the design of star schema and OLAP cubes in any environment. You'll find numerous examples of designs drawn from real-world situations. The book covers schema capabilities, ETL loading, reporting, and more. The Star Schema Handbook is a complete reference for dimensional modeling and star schema design, whether you're new to the field or are seeking advanced information to help you address specific design challenges The book explores best practices for star schema design and OLAP cubes; it is architecture-neutral, providing guidance on best design practices for any environment Topics include schema capabilities, ETL loading, reporting, and much more This comprehensive guide covers both basic and advanced topics, making it the complete reference for all data warehouse designers.

Business intelligence

estrategias para una implementación exitosa
Author: Cindi Howson
Publisher: N.A
ISBN: 9789701067598
Category: Business & Economics
Page: 256
View: 8635
DOWNLOAD NOW »
Lectura obligada para estrategas y técnicos que pretenden ser competidores analíticos en Business Intelligence, incluye temas relacionados con tecnología, organización, estrategia e incluso cultura. Mediante la aplicación de técnicas de BI, los procesos empresariales se agilizan, vuelven competitivos y rentables.

The DAMA Guide to the Data Management Body of Knowledge (DAMA-DMBOK) Spanish Edition


Author: DAMA International
Publisher: Technics Publications
ISBN: 1634620119
Category: Computers
Page: 470
View: 1944
DOWNLOAD NOW »
Escrito por más de 120 profesionistas en la gestión de datos, la guía DAMA de los fundamentos para la gestión de datos (DAMA-DMBOK) es la recopilación más impresionante jamás realizada de principios y mejores prácticas en la gestión de datos. Este libro proporciona a profesionales de IT, ejecutivos, trabajadores del conocimiento, educadores e investigadores de gestión de datos un método de manejo de datos para desarrollar su arquitectura de información. En comparación con los libros PMBOK o el BABOK, el libro DAMA-DMBOK proporciona información sobre: · Gobierno de datos · Gestión de Arquitectura de Datos · Desarrollo de datos · Gestión de Operaciones de base de datos · Gestión de la seguridad de datos · Gestión de datos maestros y de referencia · Gestión de almacenamiento de datos e inteligencia de negocios · Gestión de documentación y contenidos · Gestión de metadatos · Gestión de calidad de datos · Desarrollo profesional Como introducción oficial a la gestión de datos, los objetivos de la guía DAMA-DMBOK son: · Construir consensos para una visión general aplicable a las funciones de gestión de datos. · Proporcionar definiciones estandarizadas para funciones comúnmente utilizadas en la gestión de datos, resultados, roles y otras terminologías. · Documentar principios guiados para la gestión de datos. · Presentar una visión neutral de buenas prácticas comúnmente aceptadas, técnicas y métodos ampliamente adoptados, y alcances alternativos significantes. · Clarificar los alcances y límites de la gestión de datos. · Desempeñarse como guía de referencia para una mayor compresión para el lector Editores: Mark Mosley, Editor de desarrollo, Michel Brackett, Editor de producción, Susan Early, Asistente de editor, y Deborah Henderson, Patrocinador del proyecto. Prologo por John Zachman, Prefacio por John Schley (presidente internacional de DAMA) y Deborah Henderson (Presidenta de fundación DAMA, Vicepresidenta internacional de educación e investigación DAMA) y Epilogo por Michel Brackett. (Galardonado al Premio a la Trayectoria de DAMA Internacional). El DMBOK fue traducido al español por: Derly Almanza, Cinthia Carolina Sanchez Osorio, Karen Dawson, Ramón Vasquez, Juan Azcurra, Juan Diego Lorenzo, Fernado Giliberto, Sergio Tornati y Pablo Cigliuti. Prólogo por John Zachman: El libro es una recopilación exhaustiva de todos los temas y casos posibles que merecen consideración para iniciar y ejecutar u responsabilidades de gestión de datos en una empresa moderna. Es impresionante en su integralidad. No sólo identifica las metas y los objetivos de todos los temas de gestión de datos y las responsabilidades sino también sugiere de manera natural los participantes en la organización y los resultados finales que se deben esperar. La publicación comenzó como una recopilación trascendente muy necesaria de artículos y hechos sustantivos acerca del poco entendimiento del tema de la gestión de datos organizada por algunas personas de la sección Chicago de DAMA. Este material fue único en su momento por la carencia de información relacionada a este tema. Ha progresado hasta convertirse en un manual facultativo que merece un lugar en cualquier anaquel de gestión de datos. Hay una gran cantidad de información para el principiante de datos, pero también es de gran valor para el experto utilizándolo como una lista de comprobación y validación de sus conocimientos y responsabilidades para asegurar que nada se le ha olvidado. Es impresionante su amplitud y exhaustividad. La guía DAMA-DMBOK merece un lugar en cada estantería de libros de profesionistas de gestión de datos y para un gerente general servirá como guía para establecer expectativas y para asignar responsabilidades para la gestión y la práctica de lo que se ha convertido en el recurso más crítico de la empresa que ha progresado en la era de la información: DATOS!

The Data Warehouse Toolkit

The Definitive Guide to Dimensional Modeling
Author: Ralph Kimball,Margy Ross
Publisher: John Wiley & Sons
ISBN: 1118530802
Category: Computers
Page: 600
View: 8537
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.

Database Design and Relational Theory

Normal Forms and All That Jazz
Author: C. J. Date
Publisher: Apress
ISBN: 1484255402
Category: Computers
Page: 451
View: 4025
DOWNLOAD NOW »
Create database designs that scale, meet business requirements, and inherently work toward keeping your data structured and usable in the face of changing business models and software systems. This book is about database design theory. Design theory is the scientific foundation for database design, just as the relational model is the scientific foundation for database technology in general. Databases lie at the heart of so much of what we do in the computing world that negative impacts of poor design can be extraordinarily widespread. This second edition includes greatly expanded coverage of exotic and little understood normal forms such as: essential tuple normal form (ETNF), redundancy free normal form (RFNF), superkey normal form (SKNF), sixth normal form (6NF), and domain key normal form (DKNF). Also included are new appendixes, including one that provides an in-depth look into the crucial notion of data consistency. Sequencing of topics has been improved, and many explanations and examples have been rewritten and clarified based upon the author’s teaching of the content in instructor-led courses. This book aims to be different from other books on design by bridging the gap between the theory of design and the practice of design. The book explains theory in a way that practitioners should be able to understand, and it explains why that theory is of considerable practical importance. Reading this book provides you with an important theoretical grounding on which to do the practical work of database design. Reading the book also helps you in going to and understanding the more academic texts as you build your base of knowledge and expertise. Anyone with a professional interest in database design can benefit from using this book as a stepping-stone toward a more rigorous design approach and more lasting database models. What You Will Learn Understand what design theory is and is not Be aware of the two different goals of normalization Know which normal forms are truly significant Apply design theory in practice Be familiar with techniques for dealing with redundancy Understand what consistency is and why it is crucially important Who This Book Is For Those having a professional interest in database design, including data and database administrators; educators and students specializing in database matters; information modelers and database designers; DBMS designers, implementers, and other database vendor personnel; and database consultants. The book is product independent.

La semana laboral de 4 horas

olvídate de fichar, vive donde quieras y únete al club de los ricos
Author: Timothy Ferriss
Publisher: Rba Publicaciones Editores revistas
ISBN: 9788498673777
Category: Business & Economics
Page: 367
View: 2527
DOWNLOAD NOW »
Olvídate del transnochado concepto de jubilación y deja de aplazar tu vida: no hace falta esperar; existen demasiadas razones para no hacerlo. Si tu sueño es dejar de depender de un sueño, viajar por el mundo a todo tren, ingresar más dinero al mes o, simplemente, vivir más y trabajar menos, este libro es la brújula que necesitas.

Agile Data Warehouse Design

Collaborative Dimensional Modeling, from Whiteboard to Star Schema
Author: Lawrence Corr,Jim Stagnitto
Publisher: DecisionOne Consulting
ISBN: 0956817203
Category: Business & Economics
Page: 304
View: 3091
DOWNLOAD NOW »
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.

Java 8


Author: Herbert Schildt
Publisher: N.A
ISBN: 9788441536258
Category: Computers
Page: 672
View: 5107
DOWNLOAD NOW »


Business Objects: The Complete Reference


Author: Cindi Howson
Publisher: McGraw Hill Professional
ISBN: 0072230436
Category: Computers
Page: 770
View: 3339
DOWNLOAD NOW »
If your objective in business intelligence reporting is Business Objects success, this is the resource for you. Gives a thorough run-down of the software, plus coverage of Web intelligence, complex queries, multidimensional analysis, and more. Author Cindi Howson has plenty of hands-on experience with the product.

Análisis de datos con Access


Author: Ken Bluttman,Wayne S. Freeze
Publisher: Anaya Multimedia-Anaya Interactiva
ISBN: 9788441522978
Category: Business & Economics
Page: 415
View: 1783
DOWNLOAD NOW »
El análisis de datos es una parte esencial de cualquier sistema de bases de datos que se respete. Si tiene grandes cantidades de información en una base de datos de Microsoft Access y necesita comprender cómo proceder, este libro contiene fórmulas prácticas para resolver los problemas comunes que surgen al extraer datos y llevar a cabo operaciones. Cada fórmula ofrece soluciones paso a paso, y un debate sobre cómo y por qué funciona. Totalmente actualizado para Access 2007 y compatible con versiones anteriores, este libro enseña nuevos métodos de consulta de datos, diferentes formas de mover datos dentro y fuera de Access, como calcular las respuestas a problemas financieros y de inversión, ir más allá de SQL al manipular datos con VBA, procesar fechas y tiempos, e incluso llegar a usar las herramientas de análisis de datos de Excel.

Guide to the Project Management Body of Knowledge (PMBOK(R) Guide-Sixth Edition / Agile Practice Guide Bundle (SPANISH)


Author: Project Management Institute
Publisher: Project Management Institute
ISBN: 1628255242
Category: Business & Economics
Page: 976
View: 4497
DOWNLOAD NOW »
To support the broadening spectrum of project delivery approaches, PMI is offering A Guide to the Project Management Body of Knowledge (PMBOK® Guide) – Sixth Edition as a bundle with its latest, the Agile Practice Guide. The PMBOK® Guide – Sixth Edition now contains detailed information about agile; while the Agile Practice Guide, created in partnership with Agile Alliance®, serves as a bridge to connect waterfall and agile. Together they are a powerful tool for project managers. The PMBOK® Guide – Sixth Edition – PMI's flagship publication has been updated to reflect the latest good practices in project management. New to the Sixth Edition, each knowledge area will contain a section entitled Approaches for Agile, Iterative and Adaptive Environments, describing how these practices integrate in project settings. It will also contain more emphasis on strategic and business knowledge—including discussion of project management business documents—and information on the PMI Talent Triangle™ and the essential skills for success in today's market. Agile Practice Guide has been developed as a resource to understand, evaluate, and use agile and hybrid agile approaches. This practice guide provides guidance on when, where, and how to apply agile approaches and provides practical tools for practitioners and organizations wanting to increase agility. This practice guide is aligned with other PMI standards, including A Guide to the Project Management Body of Knowledge (PMBOK® Guide) – Sixth Edition, and was developed as the result of collaboration between the Project Management Institute and the Agile Alliance.

Aprende SQL


Author: Alan Beaulieu
Publisher: Anaya Multimedia-Anaya Interactiva
ISBN: 9788441526372
Category: Business & Economics
Page: 384
View: 3375
DOWNLOAD NOW »
SQL es un lenguaje de programación destinado a generar, manipular y recuperar información de una base de datos relacional. No depende de sí mismo, sino que lo invocan otros programas escritos en lenguajes de uso general, como por ejemplo C++, Java, Python y Perl. Uno de los motivos por el que estas bases de datos son tan populares es porque basándose en un diseño relacional adecuado, pueden llegar a gestionar grandes cantidades de datos. Actualizada para los sistemas de gestión de bases de datos actuales (entre los que se incluyen MySQL 6.0, Oracle 11g y Microsoft SQL Server 2008), con esta guía aprenderá SQL rápido y cómodamente. Independientemente de sus necesidades (escribir aplicaciones de bases de datos, realizar tareas administrativas, generar informes...), la segunda edición de este libro le ayudará a dominar sin esfuerzo los fundamentos del lenguaje SQL.

BusinessObjects XI (Release 2): The Complete Reference


Author: Cindi Howson
Publisher: McGraw Hill Professional
ISBN: 9780071491280
Category: Computers
Page: 650
View: 542
DOWNLOAD NOW »
This book is a must read for anyone deploying BusinessObjects. It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There's in depth coverage of Designer, security via the Central Management Console, InfoView, Web Intelligence, and Desktop Intelligence. It goes beyond step-by-step instructions to cover how and why in a business context. Transition notes are interspersed for version 5 and 6 customers to understand the biggest changes in XI Release 2. If you drive BI requirements in your company or are a data warehouse program manager, Business Objects administrator, report author or consumer, this book is for you.

Microsoft Power BI Complete Reference

Bring your data to life with the powerful features of Microsoft Power BI
Author: Devin Knight,Brian Knight,Mitchell Pearson,Manuel Quintana,Brett Powell
Publisher: Packt Publishing Ltd
ISBN: 1789955637
Category: Computers
Page: 794
View: 4935
DOWNLOAD NOW »
Design, develop, and master efficient Power BI solutions for impactful business insights Key Features Get to grips with the fundamentals of Microsoft Power BI Combine data from multiple sources, create visuals, and publish reports across platforms Understand Power BI concepts with real-world use cases Book Description Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: Microsoft Power BI Quick Start Guide by Devin Knight et al. Mastering Microsoft Power BI by Brett Powell What you will learn Connect to data sources using both import and DirectQuery options Leverage built-in and custom visuals to design effective reports Administer a Power BI cloud tenant for your organization Deploy your Power BI Desktop files into the Power BI Report Server Build efficient data retrieval and transformation processes Who this book is for Microsoft Power BI Complete Reference Guide is for those who want to learn and use the Power BI features to extract maximum information and make intelligent decisions that boost their business. If you have a basic understanding of BI concepts and want to learn how to apply them using Microsoft Power BI, then Learning Path is for you. It consists of real-world examples on Power BI and goes deep into the technical issues, covers additional protocols, and much more.

JavaServer Faces 2.0, The Complete Reference


Author: Ed Burns,Chris Schalk
Publisher: McGraw Hill Professional
ISBN: 0071625100
Category: Computers
Page: 752
View: 2955
DOWNLOAD NOW »
The Definitive Guide to JavaServer Faces 2.0 Fully revised and updated for all of the changes in JavaServer Faces (JSF) 2.0, this comprehensive volume covers every aspect of the official standard Web development architecture for JavaEE. Inside this authoritative resource, the co-spec lead for JSF at Sun Microsystems shows you how to create dynamic, cross-browser Web applications that deliver a world-class user experience while preserving a high level of code quality and maintainability. JavaServer Faces 2.0: The Complete Reference features an integrated sample application to use as a model for your own JSF applications, with code available online. The book explains all JSF features, including the request processing lifecycle, managed beans, page navigation, component development, Ajax, validation, internationalization, and security. Expert Group Insights throughout the book offer insider information on the design of JSF. Set up a development environment and build a JSF application Understand the JSF request processing lifecycle Use the Facelets View Declaration Language, managed beans, and the JSF expression language (EL) Define page flow with the JSF Navigation Model, including the new "Implicit Navigation" feature Work with the user interface component model and the JSF event model, including support for bookmarkable pages and the POST, REDIRECT, GET pattern Use the new JSR-303 Bean Validation standard for model data validation Build Ajax-enabled custom UI components Extend JSF with custom non-UI components Manage security, accessibility, internationalization, and localization Learn how to work with JSF and Portlets from the JSF Team Leader at Liferay, the leading Java Portal vendor Ed Burns is a senior staff engineer at Sun Microsystems and is the co-specification lead for JavaServer Faces. He is the co-author of JavaServer Faces: The Complete Reference and author of Secrets of the Rock Star Programmers. Chris Schalk is a developer advocate and works to promote Google's APIs and technologies. He is currently engaging the international Web development community with the new Google App Engine and OpenSocial APIs. Neil Griffin is committer and JSF Team Lead for Liferay Portal and the co-founder of The PortletFaces Project. Ready-to-use code at www.mhprofessonal.com/computingdownload

SAP BusinessObjects BI 4.0 The Complete Reference 3/E


Author: Cindi Howson,Elizabeth Newbould
Publisher: McGraw Hill Professional
ISBN: 0071773118
Category: Computers
Page: 752
View: 6817
DOWNLOAD NOW »
The definitive reference for building actionable business intelligence—completely revised for SAP BusinessObjects BI 4.0. Unleash the full potential of business intelligence with fact-based decisions, aligned to business goals, using reports and dashboards that lead from insight to action. SAP BusinessObjects BI 4.0: The Complete Reference offers completely updated coverage of the latest BI platform. Find out how to work with the new Information Design Tool to create universes that access multiple data sources and SAP BW. See how to translate complex business questions into highly efficient Web Intelligence queries and publish your results to the BI Launchpad. Learn how to create dashboards from data sourced through a universe or spreadsheet. The most important concepts for universe designers, report and dashboard authors, and business analysts are fully explained and illustrated by screenshots, diagrams, and step-by-step instructions. Establish and evolve BI goals Maximize your BI investments by offering the right module to the right user Create robust universes with the Information Design Tool, leveraging multiple data sources, derived tables, aggregate awareness, and parameters Develop a security plan that is scalable and flexible Design Web Intelligence reports from basic to advanced Create sophisticated calculations and advanced formatting to highlight critical business trends Build powerful dashboards to embed in PowerPoint or the BI Launchpad Use Explorer to visually navigate large data sets and uncover patterns

Algoritmos + estructuras de datos


Author: Niklaus Wirth
Publisher: N.A
ISBN: 9788421901724
Category: Technology & Engineering
Page: 382
View: 7291
DOWNLOAD NOW »