New and updated for SAS Enterprise Guide 4.2!

In this pragmatic, example-driven book, author Neil Constable demonstrates how you can use SAS code to enhance the capabilities of SAS Enterprise Guide. Designed to help you gain extra value from the products you already have, SAS Programming for Enterprise Guide Users contains tips and techniques that show you a variety of features that cannot be accessed directly through the task interfaces. In all cases, techniques are shown with examples that you can try and test, plus additional exercises are included to give you more practice. The end result is more efficient and resilient use of SAS Enterprise Guide in a wider variety of business areas.

Included is a discussion of the following subject areas: the Output Delivery System, advanced formatting, macro variables and macros, advanced reporting using PROC REPORT, highlighting in reports, hyperlinking between reports and graphs, data manipulation using SQL, data manipulation using the DATA step, extended graphics.

By adding small amounts of code in key areas, SAS Enterprise Guide users can get more out of the product than the tasks reveal. Users should be familiar with the SAS Enterprise Guide user interface and tasks. No programming experience is necessary.

This book is part of the SAS Press program.

A one-of-a-kind resource on identifying and dealing with bias in statistical research on causal effects Do cell phones cause cancer? Can a new curriculum increase student achievement? Determining what the real causes of such problems are, and how powerful their effects may be, are central issues in research across various fields of study. Some researchers are highly skeptical of drawing causal conclusions except in tightly controlled randomized experiments, while others discount the threats posed by different sources of bias, even in less rigorous observational studies. Bias and Causation presents a complete treatment of the subject, organizing and clarifying the diverse types of biases into a conceptual framework. The book treats various sources of bias in comparative studies—both randomized and observational—and offers guidance on how they should be addressed by researchers. Utilizing a relatively simple mathematical approach, the author develops a theory of bias that outlines the essential nature of the problem and identifies the various sources of bias that are encountered in modern research. The book begins with an introduction to the study of causal inference and the related concepts and terminology. Next, an overview is provided of the methodological issues at the core of the difficulties posed by bias. Subsequent chapters explain the concepts of selection bias, confounding, intermediate causal factors, and information bias along with the distortion of a causal effect that can result when the exposure and/or the outcome is measured with error. The book concludes with a new classification of twenty general sources of bias and practical advice on how mathematical modeling and expert judgment can be combined to achieve the most credible causal conclusions. Throughout the book, examples from the fields of medicine, public policy, and education are incorporated into the presentation of various topics. In addition, six detailed case studies illustrate concrete examples of the significance of biases in everyday research. Requiring only a basic understanding of statistics and probability theory, Bias and Causation is an excellent supplement for courses on research methods and applied statistics at the upper-undergraduate and graduate level. It is also a valuable reference for practicing researchers and methodologists in various fields of study who work with statistical data. This book was selected as the 2011 Ziegel Prize Winner in Technometrics for the best book reviewed by the journal. It is also the winner of the 2010 PROSE Award for Mathematics from The American Publishers Awards for Professional and Scholarly Excellence

The go to resource for how to use Excel dashboards and reports to better conceptualize data Many Excel books do an adequate job of discussing the individual functions and tools that can be used to create an "Excel Report." What they don't offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively. Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly Shows how to automate redundant reporting and analyses Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet's Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that's both visually attractive and effective.

250 + ready-to-use, powerful DAX formulas Develop effective business intelligence (BI) solutions and drive faster, better decision making across your enterprise with help from an experienced database consultant and trainer. Through clear explanations, screenshots, and examples, Practical PowerPivot & DAX Formulas for Excel 2010 shows you how to extract actionable insights from vast amounts of corporate data. More than 250 downloadable DAX formulas plus valuable appendixes covering SQL, MDX, and DMX query design are included in this hands-on guide. Build pivot tables and charts with PowerPivot for Excel Import information from Access, Excel, data feeds, SQL Server, and other sources Organize and format BI reports using the PowerPivot Field List Write DAX formulas that filter, sort, average, and denormalize data Construct complex DAX formulas from statistical, math, and date functions Compare current and past performance using date and time intelligence Handle non-additive numbers, non-numeric values, and running totals Develop complete self-service and sharable BI solutions in a few minutes Download the source code from www.mhprofessional.com/computingdownload

This book provides a broad, mature, and systematic introduction to current financial econometric models and their applications to modeling and prediction of financial time series data. It utilizes real-world examples and real financial data throughout the book to apply the models and methods described. The author begins with basic characteristics of financial time series data before covering three main topics: Analysis and application of univariate financial time series The return series of multiple assets Bayesian inference in finance methods Key features of the new edition include additional coverage of modern day topics such as arbitrage, pair trading, realized volatility, and credit risk modeling; a smooth transition from S-Plus to R; and expanded empirical financial data sets. The overall objective of the book is to provide some knowledge of financial time series, introduce some statistical tools useful for analyzing these series and gain experience in financial applications of various econometric methods.

Do you know what people do when they visit your website or web app? Or how much the site contributes to your bottom line? Google Analytics keeps track and makes it easy for you to learn precisely what's happening. This hands-on guide shows you how to get the most out of this free and powerful tool -- whether you're new to Google Analytics or have been using it for years. Google Analytics shows you how to track different market segments and analyze conversion rates, and reveals advanced techniques such as marketing-campaign tracking, a valuable feature that most people overlook. And this practical book not only provides complete code samples for web developers, it also explains the concepts behind the code to marketers, managers, and others on your team. Discover exactly how the Google Analytics system works Learn how to configure the system to measure data most relevant to your business goals Track online marketing activities, including cost-per-click ads, email, and internal campaigns Track events -- rather than page views -- on sites with features such as maps, embedded video, and widgets Configure Google Analytics to track enterprise data, including multiple domains Use advanced techniques such as custom variables and CRM integration

This book provides a comprehensive and systematic approach to understanding GARCH time series models and their applications whilst presenting the most advanced results concerning the theory and practical aspects of GARCH. The probability structure of standard GARCH models is studied in detail as well as statistical inference such as identification, estimation and tests. The book also provides coverage of several extensions such as asymmetric and multivariate models and looks at financial applications. Key features: Provides up-to-date coverage of the current research in the probability, statistics and econometric theory of GARCH models. Numerous illustrations and applications to real financial series are provided. Supporting website featuring R codes, Fortran programs and data sets. Presents a large collection of problems and exercises. This authoritative, state-of-the-art reference is ideal for graduate students, researchers and practitioners in business and finance seeking to broaden their skills of understanding of econometric time series models.

Design and Deliver Oracle CRM On Demand Dashboards Create custom, interactive dashboards to deliver actionable business intelligence directly to end users with help from this Oracle Press guide. Oracle CRM On Demand Dashboards provides comprehensive coverage of the versatile features available in Oracle Answers On Demand coupled with detailed planning and design strategies for building and deploying reports and dashboards with Oracle CRM On Demand. Real-world examples and time-saving formatting tips are included throughout this practical resource. Configure administrative settings to access report and dashboard development tools Take advantage of built-in dashboards Plan dashboards and reports based on business needs Create, edit, manage, save, and delete custom dashboards Configure dashboard properties and pages Add and configure dashboard objects, such as guided navigation, links, images, and folders Display and arrange reports on dashboards Develop dashboard filter prompts Deploy dashboards to Oracle CRM On Demand end users

Montgomery and Runger's bestselling engineering statistics text provides a practical approach oriented to engineering as well as chemical and physical sciences. By providing unique problem sets that reflect realistic situations, students learn how the material will be relevant in their careers. With a focus on how statistical tools are integrated into the engineering problem-solving process, all major aspects of engineering statistics are covered. Developed with sponsorship from the National Science Foundation, this text incorporates many insights from the authors' teaching experience along with feedback from numerous adopters of previous editions.

Written by the best known and most trusted name in the ColdFusion community, Ben Forta, The ColdFusion Web Application Construction Kit is the best-selling ColdFusion series of all time. Volume 3: Advanced Application Development, focuses on application security, scalability and high-availability, and integration with other systems and technologies. The book starts with two sections dedicated specifically to scalability and security, and then focused on extending ColdFusion applications using web technologies, other languages and platforms, and sophisticated integration techniques. Complete coverage of ColdFusion 9 is included in "Volume 1, Getting Started" (0-321-66034-X) and "Volume 2, Application Development" (0-321-67919-9).

The Complete Guide to Building Cloud Computing Solutions with Amazon SimpleDB Using SimpleDB, any organization can leverage Amazon Web Services (AWS), Amazon’s powerful cloud-based computing platform–and dramatically reduce the cost and resources associated with application infrastructure. Now, for the first time, there’s a complete developer’s guide to building production solutions with Amazon SimpleDB. Pioneering SimpleDB developer Mocky Habeeb brings together all the hard-to-find information you need to succeed. Mocky tours the SimpleDB platform and APIs, explains their essential characteristics and tradeoffs, and helps you determine whether your applications are appropriate for SimpleDB. Next, he walks you through all aspects of writing, deploying, querying, optimizing, and securing Amazon SimpleDB applications–from the basics through advanced techniques. Throughout, Mocky draws on his unsurpassed experience supporting developers on SimpleDB’s official Web forums. He offers practical tips and answers that can’t be found anywhere else, and presents extensive working sample code–from snippets to complete applications. With A Developer’s Guide to Amazon SimpleDB you will be able to Evaluate whether a project is suited for Amazon SimpleDB Write SimpleDB applications that take full advantage of SimpleDB’s availability, scalability, and flexibility Effectively manage the entire SimpleDB application lifecycle Deploy cloud computing applications faster and more easily Work with SELECT and bulk data operations Fine tune queries to optimize performance Integrate SimpleDB security into existing organizational security plans Write and enhance runtime SimpleDB clients Build complete applications using AJAX and SimpleDB Understand low-level issues involved in writing clients and frameworks Solve common SimpleDB usage problems and avoid hidden pitfalls This book will be an indispensable resource for every IT professional evaluating or using SimpleDB to build cloud-computing applications, clients, or frameworks.

Uses the powerful interactive and visual approach of JMP to introduce readers to the logic and methods of statistical thinking and data analysis. It includes a myriad of examples and problems that rely on real sets of data, often starting with an important or interesting research question that an investigator has pursued.

Deliver SAP BI 7.0 Web Reports Distribute integrated, accurate, and timely data across your enterprise using the Web-based reporting components in SAP BI. Written by an SAP insider, Applied SAP BI 7.0 Web Reports: Using BEx Web Analyzer and Web Application Designer shows you how to construct effective queries, create HTML-based reports, and combine key analytics into a dashboard-style interface. Learn how to import data from multiple providers, configure custom templates, track Key Performance Indicators (KPIs), and incorporate JavaScript and XHTML. Security, troubleshooting, and third-party tools are also discussed in this comprehensive guide. Essential BI skills for business professionals: Define queries and export them as links with BEx Web Analyzer Create BI-specific HTML pages using Web Application Designer and Report Designer Construct reusable templates, shortcuts, and Web items Design high-impact BI dashboards, cockpits, and billboards Integrate toolbars,drilldown capabilities, and drag-and-drop features Publish reporting objects with the Broadcaster and Broadcast Wizard Migrate existing systems and reports to the SAP BI 7.0 platform Add BusinessObjects, Crystal Reports, and JavaScript components Peter Jones, MBA, is a principal/platinum business applications consultant with SAP Professional Services Consulting. He has more than 11 years of consulting and educational experience in a variety of strategic and leadership roles. Jones is the author of SAP Business Information Warehouse Reporting.

This book introduces and details the key facets of Combined Analysis - an x-ray and/or neutron scattering methodology which combines structural, textural, stress, microstructural, phase, layer, or other relevant variable or property analyses in a single approach. The text starts with basic theories related to diffraction by polycrystals and some of the most common combined analysis instrumental set-ups are detailed. Also discussed are microstructures of powder diffraction profiles; quantitative phase analysis from the Rietveld analysis; residual stress analysis for isotropic and anisotropic materials; specular x-ray reflectivity, and the various associated models.

In the book 'Microsoft Visio 2010 Business Process Diagramming and Validation', you'll master the specialized features of Microsoft Visio 2010 Premium. This guide focuses on creating structured diagrams and validation rules, helping you enhance the accuracy and clarity of your business data visualization. What this Book will help me do Gain expertise in leveraging Visio's structured diagram tools for business process mapping. Learn how to build, customize, and apply Validation Rules for ensuring diagram accuracy. Develop skills in using the Visio Object Model and ShapeSheet to create advanced diagramming solutions. Understand and implement enhanced diagramming templates and rules, including BPMN and custom workflows. Acquire techniques for creating add-ins and publishing templates to establish company-wide diagramming standards. Author(s) David Parker, the author of this insightful book, is a seasoned professional with extensive experience in Microsoft Visio. His expertise includes creating complex diagramming solutions and training professionals in maximizing Visio's features. David's hands-on approach and understanding of business process needs make this a practical and enriching guide. Who is it for? This book is for users and developers of Microsoft Visio 2010 Premium Edition who want to master diagram validation and structured diagrams. Beginners with basic Visio knowledge and experienced users aiming to develop advanced applications will both benefit from this resource. It is especially useful for professionals seeking to enforce accuracy and compliance in their diagrams.

Sams Teach Yourself Google Analytics™ in 10 Minutes gives you straightforward, practical answers when you need fast results. By working through its 10-minute lessons, you’ll learn everything you need to use Google Analytics to accurately measure your website’s performance–and improve it! 10 minutes is all you need to learn how to… Quickly create a Google Analytics account and add Google Analytics to your site Define goals and measure how well your site is achieving them Track visitors from search engines, pay-per-click advertising, email, and other sources Discover the pages your visitors view, how long they stay, and where they exit Monitor specific user actions, such as playing embedded video, selecting Flash menu items, or downloading files Identify your best and worst content, and fix poorly performing pages Improve your site by tracking error pages and broken links Measure AdWords traffic, position, and e-commerce performance Manage Google Analytics through the Dashboard Customize Google Analytics to work more effectively with your site Capture more accurate information by filtering out internal traffic Choose the right reports and data, understand them, and act on what you learn

Time is a scarce commodity in today's business environment. Curt Hinrichs and Chuck Boiler's JMP Essentials: An Illustrated Step-by-Step Guide for New Users is designed for the new or occasional JMP user who needs to generate meaningful graphs or results quickly. The authors, drawing on their own extensive experience working with customers with little or no background in JMP, provide a good survey and just what new users typically need. The format of the book is unique. It adopts a show-and-tell design with essential steps on the left-hand side and extensive illustrations on the right, which is very similar to the software's own philosophy of producing graphs alongside results. In most cases, each page or two-page spread completes a JMP task, which maximizes the book's utility as a reference. In addition, each chapter contains a family of features that are carefully crafted to first introduce basic features and progress to more advanced ones. For new users, JMP Essentials is the most accessible and fastest reference available.

JMP Means Business: Statistical Models for Management, by Josef Schmee and Jane Oppenlander, covers basic methods and models of classical statistics. Designed for business and MBA students, as well as industry professionals who need to use and interpret statistics, JMP Means Business covers data collection, descriptive statistics, distributions, confidence intervals and hypothesis tests, analysis of variance, contingency tables, simple and multiple regression, and exponential smoothing of time series. The easy-to-use format includes verbal and graphical explanations and promotes standard problem-solving techniques, with a limited use of formulas. Examples from business and industry serve to introduce each topic. Each example starts with a problem definition and data requirements, followed by a step-by-step analysis with JMP. Relevant output from this analysis is used to explain each method and to provide the basis for interpretation. Each chapter ends with a summary and a collection of problems for further study.

In Statistical Programming in SAS, author A. John Bailer integrates SAS tools with interesting statistical applications and uses SAS 9.2 as a platform to introduce programming ideas for statistical analysis, data management, and data display and simulation. Written using a reader-friendly and narrative style, the book includes extensive examples and case studies to present a well-structured introduction to programming issues. This book has two parts. The first part addresses the nuts and bolts of programming, including fostering good programming habits, getting external data sets into SAS to construct an analysis data set, generating basic descriptive statistical summaries, producing customized tables, generating more attractive output, and producing high-quality graphical displays. The second part emphasizes programming in the context of a DATA step, in macros, and in SAS/IML software. Examples of statistical methods and concepts not always encountered in basic statistics courses (for example, bootstrapping, randomization tests, and jittering) are used to illustrate programming ideas. This book provides extensive illustrations of the new ODS Statistical Graphics procedures in SAS, a description of the new ODS Graphics Editor, and a brief introduction to some of the capabilities of SAS/IML Studio, such as producing dynamically linked data displays and invoking R from SAS.

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot. Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert. This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products. This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end. The companion Web site includes all the sample applications and reports discussed. What This Book Covers After discussing self-service BI and the motivation for creating PowerPivot, the book presents a quick, end-to-end tutorial showing how to create and publish a simple PowerPivot application. It then drilsl into the features of PowerPivot for Excel in detail and, in the process, builds a more complex PowerPivot application based on a real-world case study. Finally, it discusses the server side of PowerPivot (PowerPivot for SharePoint) and provides detailed information about its installation and maintenance. Chapter 1, "Self-Service Business Intelligence and Microsoft PowerPivot," begins Part I of the book. This chapter describes self-service BI and introduces PowerPivot, Microsoft's first self-service BI tool. It provides a high-level look at the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint. Chapter 2, "A First Look at PowerPivot," walks you through a simple example of creating a PowerPivot application from end to end. In the process, it shows how to set up the two components of PowerPivot, and describes the normal workflow of creating a simple PowerPivot application. Chapter 3, "Assembling Data," starts off Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces the extended example that you will build in this and subsequent chapters. Chapter 4, "Enriching Data," shows how to enhance the data you brought into your application by creating relationships and using PowerPivot's expression language, Data Analysis Expressions (DAX). Chapter 5, "Self-Service Analysis," describes how to use your PowerPivot data with various Excel features, such as PivotTables, PivotCharts, and slicers to do analysis. Chapter 5 also delves further into DAX, showing how to create and use DAX measures. Chapter 6, "Self-Service Reporting," shows how to publish your PowerPivot workbook to the server side of PowerPivot (PowerPivot for SharePoint), and make use of its features to view and update PowerPivot reports. It also shows how to use the data in a PowerPivot workbook as a data source for reports created in other tools such as Report Builder 3.0 and Excel. Chapter 7, "Preparing for SharePoint 2010," is the first chapter in Part III of the book. It describes the components of SharePoint 2010 that are relevant for PowerPivot, and looks at how PowerPivot for SharePoint interacts with those components. Chapter 8, "PowerPivot for SharePoint Setup and Configuration," provides instructions on how to set up and configure a multi-machine SharePoint farm that contains PowerPivot for SharePoint. Chapter 9, "Troubleshooting, Monitoring, and Securing PowerPivot Services," gives tips on how to troubleshoot PowerPivot for SharePoint issues. It also shows how to monitor the health of your PowerPivot for SharePoint environment, and discusses relevant security issues. Chapter 10, "Diving into the PowerPivot Architecture," describes at a deeper level the architecture of PowerPivot, both client and server. It also explains the Windows Identity Foundation and discusses the use of Kerberos in the context of PowerPivot for SharePoint. Chapter 11, "Enterprise Considerations," talks about common PowerPivot for SharePoint enterprise considerations: capacity planning, optimizing the environment, upgrade considerations, and uploading performance. Appendix A provides instructions for setting up the data sources that are used to build the SDR Healthcare extended example in Chapters 3 through 6. Additionally, two "bonus" elements are available online at this book's companion Web site: Appendix B is a comprehensive DAX reference that describes all the DAX functions and provides code snippets that show how to use them. A special chapter describes real-world scenarios in which PowerPivot is used to solve common problems.