| Using SQL Server PowerPivot for Excel to Analyze SAP Data |
| Written by Microsoft |
| Wednesday, 26 January 2011 22:12 |
|
Writers: Scott Cameron (Hitachi Consulting), Chunhui Zhu, Denny Lee SAP is one of the most widely deployed and capable ERP systems. Because SAP is the central nervous system for many organizations, accessing the data that is captured and lives in SAP is essential to effectively managing the business. As with many ERP systems, it can sometimes be challenging to get data out of SAP applications because those are optimized for transacting and capturing data. SAP has a number of BI tools, but very few of the tools allow end users to work directly with the data in a familiar environment like Microsoft Excel and easily integrate other non-SAP data sources. Read more... |
Author articles
- What's New in PowerPivot
- DAX in the BI Tabular Model Whitepaper and Samples
- Tutorial: Optimize a Sample PowerPivot Model for Power View Reports
- Power View and PowerPivot HelloWorldPicnic Samples for SQL Server 2012 RC0
- What's new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
