Oracle Essbase 11 Development Cookbook will help you learn the tools necessary for the development of Essbase databases in Oracle Essbase version 11.1.2.1. Here you will find over 90 recipes that explain everything from how to use a relational data model to building and loading an Essbase database in Essbase Studio. The book also goes over...
PowerPivot comprises a set of technologies for easy access to data mining and business intelligence analysis from Microsoft Excel and SharePoint. Power users and developers alike can create sophisticated, online analytic processing (OLAP) solutions using PowerPivot for Excel, and then share those solutions with other users via PowerPivot for...
Teach yourself to use SQL Server 2008 Analysis Services for business intelligence?one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple...
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen...
Cutting-edge content and guidance from a data warehousing expert—now expanded to reflect field trends
Data warehousing has revolutionized the way businesses in a wide variety of industries perform analysis and make strategic decisions. Since the first edition of Data Warehousing Fundamentals, numerous...
Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak...
Learn to create an effective business strategy using Microsoft's BI stack
Microsoft Business Intelligence tools are among the most widely used applications for gathering, providing access to, and analyzing data to enable the enterprise to make sound business decisions. The tools include SharePoint Server, the Office...
Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible. Pro SQL Server 2008...
Ace your preparation for the skills measured by MCTS Exam 70-448 and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make...
Knowledge is power! As its name suggests, the promise of Microsoft SQL Server Analysis Services 2005 is to promote better data analytics by giving information workers the right tool to analyze consistent, timely, and reliable data. Empowered with Analysis Services and Microsoft Business Intelligence Platform, you are well positioned to solve the...
In many decision support fields the data that is exploited tends to be more and more complex. To take this phenomenon into account, classical architectures of data warehouses or data mining algorithms must be completely re-evaluated.
Processing and Managing Complex Data for Decision Support provides readers with an overview of the emerging...
Create powerful, innovative reporting solutions with Excel 2007
In this new book, significantly updated from his bestselling Excel 2003 version, Timothy Zapawa has provided you with in-depth coverage of Excel 2007's enhanced reporting capabilities. Discover what you can do with PivotTable and...