The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
by Ralph Kimball
from Wiley
Single most authoritative guide from the inventor of the technique.
- Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance.
- Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate.
"The latest edition of the single most authoritative guide on dimensional modeling for data warehousing! Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques--the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball's classic guide is more than sixty percent updated."
The Data Warehouse Lifecycle Toolkit
by Ralph Kimball
from Wiley
- Presenting the much-anticipated Second Edition, which boasts nearly 40 percent new and revised coverage, reflecting the latest best practices
- This unparalleled tutorial approach covers everything from planning the data warehouse project to implementing the design and managing the data warehouse environment
- The Kimball Group has streamlined the lifecycle methodology to be more efficient and user-friendly based on their thousands of hours of experience in both consulting and training
- They have also revised various lifecycle topics, including dimensional modeling, data warehouse architecture, ETL, and Business Intelligence
- New sections at the end of every process and techniques chapter feature coverage of managing the effort and reducing risk, assuring quality, estimating considerations, Web site resources, and more
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
by Ralph Kimball
from Wiley
- Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies
- Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process
- Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse
- Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality
Expert SQL Server 2005 Integration Services (Programmer to Programmer)
by Brian Knight
from Wrox
As a practical guide for Integration Services ETL development, this book shows you ways to implement your ETL solution requirements from the data to the administration and everything in-between. Each chapter begins with a review of pertinent ETL concepts and moves into working those out into a design with multiple examples and related Integration Services features with the end goal of putting it all together to get a solution.
The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset
by Joy Mundy
from Wiley
This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value.
Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set.
Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform.
Intended Audience
The target audience for this book is the IT department or service provider (consultant) who is:
- Planning a small to mid-range data warehouse project;
- Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology;
- Familiar with the general concepts of data warehousing and business intelligence.
The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book’s content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interesting to a database administrator or programmer as guiding information.
The book is focused on the mass market, where the volume of data in a single application or data mart is less than 500 GB of raw data. While the book does discuss issues around handling larger warehouses in the Microsoft environment, it is not exclusively, or even primarily, concerned with the unusual challenges of extremely large datasets.
About the Authors
JOY MUNDY has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy co-founded InfoDynamics LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse.
Before returning to consulting with the Kimball Group in 2004, Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy began her career as a business analyst in banking and finance. She graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems.
WARREN THORNTHWAITE has been building data warehousing and business intelligence systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm, with his co-author, Joy Mundy. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting with the Kimball Group. In addition to designing data warehouses for a range of industries, Warren speaks at major industry conferences and for leading vendors, and is a long-time instructor for Kimball University. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan.
RALPH KIMBALL, PH.D., has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known authors, speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine.
SAS For Dummies (For Dummies (Computer/Tech))
by Stephen McDaniel
from For Dummies
- Created in partnership with SAS, this book explores SAS, a business intelligence software that can be used in any business setting or enterprise for data delivery, reporting, data mining, forecasting, statistical analysis, and more
- SAS employee and technologist Stephen McDaniel combines real-world expertise and a friendly writing style to introduce readers to SAS basics
- Covers crucial topics such as getting various types of data into the software, producing reports, working with the data, basic SAS programming, macros, and working with SAS and databases
Flex Solutions: Essential Techniques for Flex 2 and 3 Developers (Solutions)
by Marco Casario
from friends of ED
Flex is the quickest and most effective technology for the creation of Rich Internet Applications for the Web. Its extensive library of components and totally customizable framework, combined with the ubiquity of Flash Player, has guaranteed its success.
The ecosystem of products that rotate around Flex 2 and Flex 3 is really broad. Flex Builder, Flex SDK, and Charting Components are all essential parts of the technology that fit the different requirements of web development.
This enormous set of possibilities can easily lead to overload for developers like you. Theres just too much to learn and too many potential places to go when you hit a brick wall. Wouldnt it be nice to have a library of solutions to solve these problems quickly and easily?
This book provides just that, with more than 100 solutions to common problems in one handy volume.
Flex Solutions: Essential Techniques for Flex 2 and Flex 3 Developers faces problems and provides solutions that can be applied to any project, from the most simple to the most complex. The solutions range from customizing Flex components with ActionScript 3.0, using the data models and the ActionScript classes as Value objects, validating and formatting data, using RPC classes to access remote data, to optimizing data-exchange performance using AMF3.
Solutions are also provided for enhancing the security of Flex applications; and techniques are offered for optimizing the actual work environment by increasing the performance of Flex Builder, adding video content, and creating an AIR project to bring your web application onto the desktop.
If you want to learn about and start to develop RIAs in a short time, being immediately productive and mastering the Flex development techniques, Flex Solutions: Essential Techniques for Flex 2 and 3 Developers is the book you need.
In this book you'll:
- Discover real-world solutions for everyday Flex development, saving hours of development time.
- Learn how to customize and extend the Flex Components Model and design and program the look and feel of your Flex applications.
- Learn best practices and tips from a Flex expert for structuring the architecture of Flex applications.
- Use the Flex Remote Procedure Classes to connect to remote data with HTTPServices and the Java Platform, PHP, ColdFusion, WebServices, and RemoteObject.
- Use the new Flex 3 features, such as the AdvancedDataGrid component and the Charting Enhancements feature.
- Port your Rich Internet Applications onto the desktop with Adobe AIR.
What youll learn
- Tips on using Flex components
- How to validate and format data
- How to manage complex data
- Filtering, sorting and using cursors on data with collection classes
- How to consume Web Services using RPC components
- How to display data using list-based controls
- How to effectively compile and deploy Flex applications
- How to customize the look and feel of your applications
- How to make your applications more secure
- How to become more efficient in using the Flex Builder IDE
- Unique tricks such as calculating memory usage, making your Flex application into an active desktop, and customizing states
- How to use the ColdFusion Extensions for Flex Builder
- How to interface your Flex applications with server-side code written in PHP, Java, Rails, and ColdFusion
- Working with Flex in enterprise enviroment using the Flex Data Services, Java Remote Object and AMFPHP
Who is this book for?
This book is for any Flex 2 or Flex 3 developer who is comfortable with the basics and wants to take their knowledge further with quick fire solutions to common problems. Please note that some of the solutions contained in this book require the Flex Builder 3 Professional release of the software.Learning MySQL (Learning)
by Seyed M.M. (Saied) Tahaghoghi
from O'Reilly Media, Inc.
Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season?
MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and "Learning MySQL" provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.
After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.
Topic include: Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using the PHP and Perl programming languages
The authors, Saied Tahaghoghi and Hugh E. Williams, have careers in academia and business, and share a keen interest in research into search technologies.
Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in "Learning MySQL" that will last a career.
Master Data Management and Customer Data Integration for a Global Enterprise
by Alex Berson
from McGraw-Hill Osborne Media
Transform your business into a customer-centric enterprise
Gain a complete and timely understanding of your customers using MDM-CDI and the real-world information contained in this comprehensive volume. Master Data Management and Customer Data Integration for a Global Enterprise explains how to grow revenue, reduce administrative costs, and improve client retention by adopting a customer-focused business framework.
Learn to build and use customer hubs and associated technologies, secure and protect confidential corporate and customer information, provide personalized services, and set up an effective data governance team. You'll also get full details on regulatory compliance and the latest pre-packaged MDM-CDI software solutions.
- Design and implement a dynamic MDM-CDI architecture that fits the needs of your business
- Implement MDM-CDI holistically as an integrated multi-disciplinary set of technologies, services, and processes
- Improve solution agility and flexibility using SOA and Web services
- Recognize customers and their relationships with the enterprise across channels and lines of business
- Ensure compliance with local, state, federal, and international regulations
- Deploy network, perimeter, platform, application, data, and user-level security
- Protect against identity and data theft, worm infection, and phishing and pharming scams
- Create an Enterprise Information Governance Group
- Perform development, QA, and business acceptance testing and data verification
Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications (Addison-Wesley Information Technology Series)
by Larissa T. Moss
from Addison-Wesley Professional
+++
