Generate detailed reports that will give your company the competitive edge Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10 g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10 g. Set up, configure, and manage Oracle Business Intelligence Discoverer 10 g Perform ad hoc and fixed queries using the Workbook Wizard Integrate sorts, calculations, percentages, and parameters using Discoverer Plus Create reports with graphs, tables, titles, headers, footers, and margins Use Discoverer Viewer to review, format, export, email, and print reports Refine queries using interactive pivoting, drilling, and Hyper Drilling Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager Establish access and sharing rights, and scheduling privileges with Discoverer Administrator Set up and use Portal using Discoverer Portlet Provider and Portlets Implement query shortcuts, cascading parameters and advanced analytic calculations using templates

WILEY-INTERSCIENCE PAPERBACK SERIES The Wiley-Interscience Paperback Series consists of selected books that have been made more accessible to consumers in an effort to increase global appeal and general circulation. With these new unabridged softcover volumes, Wiley hopes to extend the lives of these works by making them available to future generations of statisticians, mathematicians, and scientists. ". . .this is a very competently written and useful addition to the statistical literature; a book every statistician should look at and that many should study!" -Short Book Reviews, International Statistical Institute ". . .reading this book was an enjoyable learning experience. The suggestions and recommendations on the methods [make] this book an excellent reference for anyone interested in simulation. With its compact structure and good coverage of material, it [is] an excellent textbook for a simulation course." -Technometrics ". . .this work is an excellent comprehensive guide to simulation methods, written by a very competent author. It is especially recommended for those users of simulation methods who want more than a 'cook book'. " -Mathematics Abstracts This book is a comprehensive guide to simulation methods with explicit recommendations of methods and algorithms. It covers both the technical aspects of the subject, such as the generation of random numbers, non-uniform random variates and stochastic processes, and the use of simulation. Supported by the relevant mathematical theory, the text contains a great deal of unpublished research material, including coverage of the analysis of shift-register generators, sensitivity analysis of normal variate generators, analysis of simulation output, and more.

Proposing any performance or training solutions requires rigorous analysis based on data, not speculation. Conducting a front-end analysis—a process for determining why a perceived performance gap exists and how to close the gap—enables workplace learning and performance professionals to find successful solutions. This Infoline describes how to carry out the two distinct analysis processes that go into a front-end analysis: a gap (or performance) analysis and root cause analysis. The first process determines if a performance problem exists. The second process identifies the true root cause of the issue. Helpful sidebars explain the analysis sequence, when to conduct a gap analysis, how to define performance gaps without bias, and factors that influence performance. In addition, the job aid provides a checklist of questions for a training needs analysis.

Prepare for the SAS Base Programming for SAS®9 certification exam with the official guide by the SAS® Certified Professional Program. New and experienced SAS users who want to prepare for the SAS Base Programming for SAS®9 certification exam will find this guide an invaluable, convenient and comprehensive resource that covers all of the objectives tested on the exam. Major topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors.You will also become familiar with the enhancements and new functionality that are available in SAS®9. Includes a free CD-ROM with tutorials, practice data, and sample programs to further reinforce and test your SAS skills.

The IBM WebSphere Business Integration for Healthcare Collaborative Network is an internet-based, private information network that enables secure transmission of clinical data to healthcare participants. Healthcare Collaborative Network enables immediacy in the dissemination of clinical data and provides participants with capabilities to detect and respond rapidly to health risks such as adverse drug effects, to manage quality of care, and to implement monitoring and warning systems for detecting the onset of dangerous infectious diseases or bioterrorist attacks. This IBM IBM Redbooks publication provides a first-hand guide for creating solutions based on the IBM WebSphere Business Integration for Healthcare Collaborative Network. It includes an example scenario of a public health alert based on Avian Influenza (bird flu) and Avian Influenza A (H5N1). Healthcare Collaborative Network is aimed at hospitals and large groups of medical or dental practices, international and government agencies, pharmaceutical companies, and major insurance companies.

Transform disparate enterprise data into actionable business intelligence Put timely, mission-critical information in the hands of employees across your organization using Microsoft SQL Server 2005 and the comprehensive information in this unique resource. Delivering Business Intelligence with Microsoft SQL Server 2005 shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge. It's all right here--from data mining, warehousing, and scripting techniques to MDX queries, KPI analysis, and the all-new Unified Dimensional Model. Real-world examples, start-to-finish exercises, and downloadable code throughout illustrate all of the integration, analysis, and reporting capabilities of SQL Server 2005.

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.

Excel Pivot Tables Recipe Book: A Problem-Solution Approach is for anyone who uses Excel frequently. This book follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables—from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The author presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and she carefully explains the most confusing features of PivotTables. All chapters have been organized into a collection of recipes that take you step-by-step from the problem you are experiencing to the solution you are aiming for. There's no fuss to this book, only clear and precise information to help you assess your situationwhether common or uniqueand solve your problem. The book includes real-world examples of complex PivotTables, as well as numerous PivotTable programming examples.

Baseball Hacks isn't your typical baseball book--it's a book about how to watch, research, and understand baseball. It's an instruction manual for the free baseball databases. It's a cookbook for baseball research. Every part of this book is designed to teach baseball fans how to do something. In short, it's a how-to book--one that will increase your enjoyment and knowledge of the game. So much of the way baseball is played today hinges upon interpreting statistical data. Players are acquired based on their performance in statistical categories that ownership deems most important. Managers make in-game decisions based not on instincts, but on probability - how a particular batter might fare against left-handedpitching, for instance. The goal of this unique book is to show fans all the baseball-related stuff that they can do for free (or close to free). Just as open source projects have made great software freely available, collaborative projects such as Retrosheet and Baseball DataBank have made great data freely available. You can use these data sources to research your favorite players, win your fantasy league, or appreciate the game of baseball even more than you do now. Baseball Hacks shows how easy it is to get data, process it, and use it to truly understand baseball. The book lists a number of sources for current and historical baseball data, and explains how to load it into a database for analysis. It then introduces several powerful statistical tools for understanding data and forecasting results. For the uninitiated baseball fan, author Joseph Adler walks readers through the core statistical categories for hitters (batting average, on-base percentage, etc.), pitchers (earned run average, strikeout-to-walk ratio, etc.), and fielders (putouts, errors, etc.). He then extrapolates upon these numbers to examine more advanced data groups like career averages, team stats, season-by-season comparisons, and more. Whether you're a mathematician, scientist, or season-ticket holder to your favorite team, Baseball Hacks is sure to have something for you. Advance praise for Baseball Hacks: " Baseball Hacks is the best book ever written for understanding and practicing baseball analytics. A must-read for baseball professionals and enthusiasts alike." -- Ari Kaplan, database consultant to the Montreal Expos, San Diego Padres, and Baltimore Orioles "The game was born in the 19th century, but the passion for its analysis continues to grow into the 21st. In Baseball Hacks, Joe Adler not only demonstrates thatthe latest data-mining technologies have useful application to the study of baseball statistics, he also teaches the reader how to do the analysis himself, arming the dedicated baseball fan with tools to take his understanding of the game to a higher level." -- Mark E. Johnson, Ph.D., Founder, SportMetrika, Inc. and Baseball Analyst for the 2004 St. Louis Cardinals

The ability of a structural assembly to carry loads and forces determines how stable it will be over time. Viewing structural assemblages as comprising columns, beams, arches, rings, and plates, this book will introduce the student to both a classical and advanced understanding of the mechanical behavior of such structural systems under load and how modeling the resulting strains can predict the overall future performance—the stability—of that structure. While covering traditional beam theory, the book is more focused on elastica theory in keeping with modern approaches. This text will be an expanded and updated version a similar, previously published book, but with pedagogical improvements and updated analytical methods. This engineering textbook will provide a focused treatment on the study of how structures behave and perform when under stress loading, including plastic deformation and buckling. All advanced engineering students studying engineering mechanics, structural analysis and design, fatigue and failure, and other related subjects need to have this knowledge, and this book will provide it in a thorough and coherent fashion. Written by two of the world’s leading engineering professors in this subject area, the pedagogy has been classroom-tested over many years and should find a receptive readership among both students and instructors. * An understandable introduction to the theory of structural stability, useful for a wide variety of engineering disciplines, including mechanical, civil and aerospace engineering * Covers both static and dynamic loads, for both conservative and nonconservative systems * Emphasizes elastic behavior under loads, including vertical buckling, torsional buckling and nonlinear affects of structural system buckling and stability * Case examples to illustrate real-world applications of Stability Theory

Budgets are like road maps -- they provide a direction for a corporates financial management. Balance sheets and statements of revenues also provide insights into how well a company is following that direction. But cash flow and cash flow forecasts are what guide the day-to-day itinerary for an organization. Budgets and cash flow are dynamic -- adjustments and changes can and should occur. If you understand what you are looking at, you can use cash flow to create better budgets and thus more accurate cash flow forecasting. Cash Flow Forecasting outlines the techniques required to undertake a detailed analysis of the cash flow dynamics of the business from both a historical and forward looking perspective. Cash Flow Forecasting explains how to: * Determine appropriate cash flow figures from pro forma financial statements * Interpret detailed cash flow forecasts and understand the difference between profit and cash flow * Conserve or generate cash in the short term * Evaluate different methods of project evaluation * Recognize the limitations of accounting information in valuing companies *Inspired by basic entry level training courses that have been developed by major international banks worldwide * Will enable students and those already in the finance profession to gain an understanding of the basic information and principles of cash flow forecasting * Includes questions with answers, study topics, practical "real world" examples and extensive bibliography

Greasemonkey Hacks is an invaluable compendium 100 ingenious hacks for power users who want to master Greasemonkey, the hot new Firefox extension that allows you to write scripts that alter the web pages you visit. With Greasemonkey, you can create scripts that make a web site more usable, fix rendering bugs that site owners can't be bothered to fix themselves, or add items to a web site's menu bar. You can alter pages so they work better with technologies that speak a web page out loud or convert it to Braille. Greasemonkey gurus can even import, combine, and alter data from different web sites to meet their own specific needs. Greasemonkey has achieved a cult-like following in its short lifespan, but its uses are just beginning to be explored. Let's say you're shopping on an e-commerce site. You can create a script that will automatically display competitive prices for that particular product from other web sites. The possibilities are limited only by your imagination and your Greasemonkey expertise. Greasemonkey Hacks can't help you with the imagination part, but it can provide the expert hacks-complete with the sample code-you need to turn your brainstorms into reality. More than just an essential collection of made-to-order Greasemonkey solutions, Greasemonkey Hacks is crammed with sample code, a Greasemonkey API reference, and a comprehensive list of resources, to ensure that every resource you need is available between its covers. Some people are content to receive information from websites passively; some people want to control it. If you are one of the latter, Greasemonkey Hacks provides all the clever customizations and cutting-edge tips and tools you need to take command of any web page you view.

THE KEY TO SUCCESSFUL PRINT PRODUCTION is an understanding of the entire workflow, from scanning and file creation through prepress and print production. Fully updated by author and publishing consultant Brian Lawler, The Official Adobe Print Publishing Guide, Second Edition, brings together the collective knowledge and wisdom of the experts at Adobe Systems in a simple, elegant presentation of the fundamental concepts and issues related to producing high-quality printed output. The book includes succinct, expertly illustrated explanations of the basic concepts and terminology of print production, along with Adobe’s tried and true guidelines, tips, and checklists for ensuring a successful print job.

American democracy, argues Charles Derber, is being subverted in the name of democracy itself. Derber shows how the current regime has maintained power by intensifying the red/blue culture wars—supporting religious extremists, exploiting terrorism fears, and manipulating the electoral process. And he reveals our best hope for positive change: an alliance between the Democratic Party and another source of hidden power—the grass roots progressive movements that have always been catalysts for change. Thoughtful, eloquent, and compelling, Hidden Power offers real hope for restoring genuine democracy to America.

Women now drive some 80% of all buying decisions. By 2010, they'll account for half of America's private wealth: $13 trillion dollars. A few remarkable companies have learned how to refocus on women -- and, in so doing, have achieved truly stunning results. In The Power of the Purse, top journalist Fara Warner takes you behind the scenes at those companies, revealing how they did it -- and how you can, too. Unlike previous books on marketing to women, this one doesn't settle for generalities: it offers in-depth, start-to-finish case studies. Discover how McDonald's turned around its business by recognizing women as full-fledged consumers, not just 'Moms.' Learn how Kodak's digital camera business soared from fourth to first by recognizing women's importance as family 'memory makers'. See how P G built Swiffer into a cultural revolution, and how the diamond industry did the same for right-hand rings. Watch Bratz topple Barbie, Torrid create its enormously successful plus-size stores for teenagers, and Avon connect with a radically new generation of women. From Nike to Home Depot, each story is unique -- but in every case, these companies put women at the center of their strategies, and listened intently to what real women consumers were telling them. It's not about 'painting your products pink': it's about transforming the way you think about women. Do that, and you'll create products that sell better to everyone.

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.

At last! A real-world reference guide for clinical trial SAS programming, packed with solutions that programmers can apply to their day-to-day problems. Discover key techniques and tools available within Base SAS (including the macro language and PROC SQL), SAS/GRAPH, and SAS/STAT that can be used to resolve many common issues in working with clinical trial data. Organized to reflect the statistical programmer's work flow, this user-friendly text begins with an introduction to the working environment, then presents chapters on importing and massaging data into analysis data sets, producing clinical trial output, and exporting data. Valuable plug-and-play programming examples are provided throughout. Whether you're a novice seeking an introduction to SAS programming for the pharmaceutical industry or a junior-level programmer exploring new approaches to problem solving, you'll find a wealth of practical suggestions to help you sharpen your skills.

Jump-start your report-writing skills! Report writing has never been easier. Learn how you can easily avoid common report-writing pitfalls with SAS Guide to Report Writing: Examples, Second Edition. Updated for SAS®9, this task-oriented book guides you through the steps that you need to produce professional reports. Using a wealth of easy-to-follow examples, this time-saving book demonstrates the many different styles of reports that are available and the SAS tools used to generate them. The examples enable more experienced programmers to quickly grasp new techniques, while margin notes and additional discussions provide novice users with the details that they need for effective learning. You can save programming hours by using the SAS programs as they are or as models for developing your own reports. Whether you are a beginner or an expert, this must-have guide will strengthen your report-writing expertise and give you the tools that you need to enhance the power of your reports!

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

Updated for SA®9, this second edition is an easy-to-understand introduction to SAS as well as to univariate and multivariate statistics. Clear explanations and simple language guide you through the research terminology, data input, data manipulation, and types of statistical analysis that are most commonly used in the social and behavioral sciences. Providing practice data inspired by actual studies, this book teaches you how to choose the right statistic, understand the assumptions underlying the procedure, prepare the SAS program for the analysis, interpret the output, and summarize the analysis and results according to the format prescribed in the Publication Manual of the American Psychological Association. Step by step you will learn how to perform the following types of analysis: simple descriptive statistics, measures of bivariate association, t tests: independent samples and paired samples, NOVA and MANOVA, multiple regression, principal component analysis, and assessing scale reliability with coefficient alpha. This text is ideally suited to students who are beginning their study of data analysis, and to professors and researchers who want a handy reference on their bookshelf.