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...
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...
The SQL Server product has been around since the late 1980s. Back then, Microsoft worked together with Sybase to create a database on the OS/2 platform. Shortly after this effort was completed, Microsoft realized it wanted to tightly couple SQL Server with Windows. By 1993, Microsoft had released Windows NT 3.1, and with it came the option of...
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...
Architects, project planners, and sponsors are always dealing with multiple technologies, conflicting techniques, and competing business agendas. This combination of issues gives rise to many challenges facing business intelligence (BI) and data warehouse (DW) initiatives. The question you need to ask yourself is this: “Do I have the...
World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren't database experts. No matter how messy or complex your business challenge, Designing Effective Database Systems shows you how to design an effective, high-performance database to solve it. Riordan begins...
Your in-depth guide to using the new Microsoft data mining standard to solve today's business problems
Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert...
Nowadays the economy is characterized by fast and continuously changing markets and business opportunities. Therefore, in order to be successful, it is essential for an enterprise to make right business decisions and to make them fast. Business decisions are taken on the basis of analyses of the past and current condition of an enterprise as well...
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it...
ADO.NET is the data access model built into the .NET Framework. It replaces the old (and largely successful) ADO used in almost all Visual Basic and ASP applications built over the last few years. ADO.NET enables an application to communicate with any OLE database source (including Oracle, Sybase, Microsoft Access, and even text files). This...
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...
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features...