How we did it:
Expert advice for smarties is offered from the #1 SQL guru. Trees and hierarchies are topics that all SQL users need to know, and this is the first developer's guide that addresses these concepts that are universally difficult for programmers to master. The book is Web-enhanced with downloadable SQL code, ready to use.
Ralph Kimball, Margy Ross
Ralph Kimball invented a data warehousing technique called ?dimensional modelling? and popularised it in his first Wiley bestseller The Data Warehouse Toolkit. Since then dimensional modelling has become the most widely accepted technique for data warehouse design. Since the first edition, Kimball has improved on his earlier techniques and created many new ones. In this second edition, he provides a comprehensive collection of all of them, from basic to advanced, and strategies for optimising data warehouse design for common business applications. He includes examples for retail sales, inventory management, procurement, orders and invoices, customer relationship management, accounting, financial services, telecommunication and utilities, health care, insurance and more. He also presents unique modelling techniques for e-commerce and shows strategies for optimising performance. A companion Web site provides updates on dimensional modelling techniques, links to related sites and source code where appropriate.
The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.
Microsoft's Reporting Services product is a vital part of the SQL Server 2005 business intelligence platform, but it works with virtually any data source. This hands-on guide explains how to transform data into insightful and interactive Web-based reports using Microsoft SQL Server 2005 Reporting Services. With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
Creating 2D and 3D charts is one of the most common uses of computer graphics. Such charts can have wide applications in representing mathematical, physical, and economic functions in your daily life. Whether you are an engineer, a quantitative analyst, a teacher, or a student, you will end up dealing with charting applications to some degree. Windows Presentation Foundation (WPF) is a next-generation graphics platform that enables you to build advanced user interfaces incorporating documents, media, 2D and 3D graphics, and animations. It is an ideal development tool that allows you to not only generate data, but also easily represent data graphically. Practical WPF Charts and Graphics provides all the tools you will need to develop professional chart and graphics applications in WPF and C#. This book will be useful for WPF and C# programmers of all skill levels, providing a complete and comprehensive explanation of WPF’s graphics capability and the creation of various charts, and paying special attention to the details of code implementation. What you’ll learn Understand the types of charts that can be developed in WPF and how WPF can be used to maximum effect in their development Develop a wide range of charts that consist of not only simple 2D and 3D graphs, but also the multimedia elements, embedded documents, and animations now commonly found in cutting-edge applications Adapt the wide selection of fully working demonstration charts that are provided with the book and integrate them into your own web site for instant results Who this book is for Practical Charts and Graphics is more than just a book—it's a powerful 2D and 3D charts and graphics package. You will find that many of the examples in the book can be immediately used in your real-world applications, and that many others will inspire you to create advanced graphical and sophisticated chart capabilities of your own. This book is targeted at professional developers and those who are studying to become professionals. Its coverage is equally valuable to both groups, providing a strong reference for one audience and an excellent introduction to the other. Table of Contents Overview of WPF Programming 2D Transformations WPF Graphics Basics in 2D Colors and Brushes 2D Line charts Specialized 2D Charts Stock Charts Interactive 2D Charts 2D Chart Controls Data Interpolations Curve Fitting 3D Transformations WPF Graphics Basics in 3D 3D Charts with the WPF 3D Engine 3D Charts Without the WPF 3D Engine Specialized 3D Charts
SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET. Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of a revolutionary new tool. What you will learn from this book Details of programming reports and report scripting Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content How to manage reports using Report Manager or program code High-level strategies for business support systems Rendering reports using .NET code, .NET IO namespace classes, and URL rendering Deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options Who this book is for This book is for developers and report designers using VB, C#, and ASP.NET who need to tie into SQL Server to build customized reports or to integrate reports into Windows or Web-based applications. Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.