Book Description

• When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
• Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions
• Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

From the Back Cover
The new features of Analysis Services 2008 make it even easier to use andbuild your databases for efficient and improved performance. This authoritative book, written by key members of the Analysis Services product team at Microsoft, explains how to best use these enhancements for your business needs. The authors provides you with valuable insight on how to use Analysis Services 2008 effectively to build, process, and deploy top-of-the-line business intelligence applications.

You’ll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step-by-step instructionson building Download Now »

Book Description

• Teaches solution architects, designers, and developers how to use Microsoft’s reporting platform to create reporting and business intelligence (BI) solutions
• Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
• Includes programming examples focused on specific, scenario-based solutions
• Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques

From the Back Cover
Professional Microsoft SQL Server 2008 Reporting Services

SQL Server Reporting Services makes reporting faster and easier than ever. This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company’s needs. It walks you step-by-step through the fundamentals of designing the most effective reports by following careful planning considerations.

The authors progress from beginning to advanced report design and filtering techniques, showing you the conditions where reports could be more efficient. They also explore holistic business intelligence solutions, comprehensive OLAP/Analysis Services reporting, and complete production-deployment scenarios. Download Now »

Book Description

CFO Techniques: A Hands-on Guide to Keeping Your Business Solvent and Successful is a comprehensive and instructive working manual for multitasking chief financial officers and controllers working in the fast-paced commercial environment. Every senior financial professional with an ever-broadening span of control will benefit from this complete outline of the core activities—with specific descriptions of individual tasks—comprising the daily agenda of a successful CFO or controller. It covers everything from traditional responsibilities like budgeting and financial reporting, to more innovative tasks like performance analytics and business strategy development.

While emphasizing specific guidelines on what it takes to excel as a company’s head of finance, the book refrains from overwhelming dryness by using cultural references, real-life examples, and a casual tone. With its bite-sized, easy-to-read chapters, CFO Techniques serves as both an invaluable desktop reference handbook and a good bedtime read. Whether you need a quick recommendation on treasury procedures, adhering to GAAP, keeping funds safe from embezzlers, or advice on dealing with the CEO, you will find the answers in this book.

• Guides you through CFO/controller core responsibilities, function by function
• Serves as a reference manual on financial matters specific to the small and mid-size commercial environment
• Goes beyond finance and accounting, addressing the administrative and behavioral issues all CFOs occasionally must address Download Now »

Book Description

Metrics are a hot topic. Executive leadership, boards of directors, management, and customers are all asking for data-based decisions. As a result, many managers, professionals, and change agents are asked to develop metrics, but have no clear idea of how to produce meaningful ones. Wouldn’t it be great to have a simple explanation of how to collect, analyze, report, and use measurements to improve your organization?

Metrics: How to Improve Key Business Results provides that explanation and the tools you’ll need to make your organization more effective. Not only does the book explain the “why” of metrics, but it walks you through a step-by-step process for creating a report card that provides a clear picture of organizational health and how well you satisfy customer needs.

Metrics will help you to measure the right things, the right way—the first time. No wasted effort, no chasing data. The report card provides a simple tool for viewing the health of your organization, from the outside in. You will learn how to measure the key components of the report card and thereby improve real measures of business success, like repeat customers, customer loyalty, and word-of-mouth advertising. This book:

• Provides a step-by-step guide for building an organizational effectiveness report card
• Takes you from identifying key services and products and using metrics, to determining business strategy
• Provides examples of how to identify, collect, analyze, and report metrics Download Now »

Book Description

Business Intelligence (BI) is the process of obtaining business information from available data and today, most businesses use BI to control their affairs. With Business Analysis and Reporting in Oracle Business Intelligence, you can quickly learn how to put the power of the Oracle Business Intelligence solutions to work. To jump start with analysis and reporting of data on an Oracle Business Intelligence SE platform and to keep the process of learning simple and interesting requires numerous annotated examples.

The examples in this introductory guide will make you immediately familiar with tools included in the Oracle Business Intelligence package. This book will teach you how to find answers to common business questions and make informed business decisions as well as helping you to use Oracle Business Intelligence SE platform and prepare database for analysis.

This practical, example-rich guide starts by explaining concepts behind getting business information from data. We then move smoothly onto the tools included in the Oracle Business Intelligence SE and Oracle Business Intelligence Tools packages. Along the way, we will look at how to take advantage of Discoverer Administrator, Discoverer Plus, and Discoverer Viewer for analysis and reporting. You will also learn how to build, deploy and execute reports using Oracle Reports, and integrate data from different data sources with warehousing, employing Oracle Warehouse Builder software. Covering advanced Oracle Business Intelligence features, this book will teach you how to pivot data, drill it up and down, as well as display it visually in graphs.

A fast-paced introductory guide to get you up and running swiftly with the tools included in Oracle BI SE Download Now »

Book Description

The Oracle Hyperion Interactive Reporting is one of the many products in the Oracle Enterprise Performance Management software suite, an industry-leading business intelligence software package. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities. It also provides the capability to disseminate information throughout an enterprise. There is a very steep learning curve for most users of this tool.

This book examines the power of the Interactive Reporting Web Client software, focusing on the key features of each section of the product. The author’s experience in developing and supporting Interactive Reporting users is very well documented in this book. The goal is to educate you on every useful feature of the product, enabling you to gather information from various sources and process it to produce meaningful results that help you to spot problems and analyze trends necessary for business decisions.

The book starts with a quick introduction to the product interface and the EPM Workspace, with explanation of importing and provisioning. It then takes you through each section from building a query and data model to building graphical displays of the data in a logical sequence. The report sections and interactive dashboards are also discussed at length. The book also covers advanced features of the product and provides you with the information necessary to build the foundation for creating complex queries and computations using the product.

Demonstrates the key functionalities of the Oracle Hyperion Interactive Reporting software with a detailed view of each section and an introduction to dashboard design Download Now »