This webcast shows how to use Microsoft Office Excel 2007 and Microsoft SQL Server 2005 Analysis Services to build end-to-end Business Intelligence (BI) solutions. The webcast shows how to create an Analysis Services 2005 Unified Dimensional Model (UDM) that can be consumed by Excel 2007, and demonstrates how to use the new features in Excel 2007 to take advantage of the metadata exposed by the UDM. During the webcast, the presenters will build a sample BI solution that explores enhancements such as the new functionality available in PivotTables, a set of seven new OnLine Analytical Processing (OLAP) formulas one can use to retrieve data from Analysis Services 2005, and conditional formatting improvements one can apply to better visualize the BI data.
Did you find this white paper useful?
24 out of 50 users found this white paper useful
Related white papers
Green IT: Reducing your Carbon Footprint with Citrix
Going green has become an imperative, not an option, for companies facing the new reality of balancing business objectives with dwindling environmental resources. Limited energy supply and skyrocketing costs are...
Protecting virtual macchines: the "best of Vmworld" approach
By enabling IT managers to move virtual machines (and the applications they host) between physical servers, server virtualization gives them a powerful method for reducing planned downtime and speeding recovery....
Security Beyond Corporate Boundaries: Using Citrix Application Delivery to Protect Corporate Information Anywhere Business Happens
Ironclad security has become the Holy Grail for companies looking to protect corporate and customer information at large in the modern enterprise. The move toward greater data distribution -- thanks...
The End of Application Deployment: Virtualised Applications Streamline, Secure and Manage Your Business
Hundreds, even thousands, of applications serve as the life blood of each of today's distributed global enterprises - at use in more places and in more ways than ever before....
Accelerating Microsoft Windows Vista Migrations with Citrix XenApp
For many organisations, migration to Microsoft Windows Vista is not a question of "if" but "when." This inevitability is causing companies to start asking the difficult questions. This white paper...
IBM Information Server Change Data Capture
In today's fast-paced world, access to real-time data has never been more important. To be successful, organizations need to be able to report and analyze corporate data quickly and easily,...
OAMTC Ratchets Up SAP System Availability and Performance With Oracle RAC
With its 1.6 million members, OAMTC (Austrian Automotive, Motorcycle and Touring Club) is one of the world's ten largest automotive associations. OAMTC wanted to provide a high-availability/fail-safe system environment for...
