Power Pivot and SAP

More Microsoft BI and SAP

By Jen Underwood • 7 years ago

Jun
2011

June 2011

SQL CAT White Paper http://sqlcat.com/whitepapers/archive/2011/01/26/

SQL CAT white paper now available on how to use Power Pivot to empower business users to integrate and analyze SAP and non-SAP data to ease and accelerate analytics. The paper reviews six scenarios where PowerPivot is used to analyze SAP ERP or SAP BW data:

– Importing data into PowerPivot via an Excel PivotTable connected to SAP BW
– Importing data into PowerPivot via SQL Server Reporting Services connected to SAP BW
– Importing data into PowerPivot from a text file generated using SAP BW Open Hub Service
– Importing data into PowerPivot from a SQL Server Analysis Services cube connected to SAP BW created using ERP-Link iNet.BI
– Importing data into PowerPivot using Xtract PPV connected to SAP BW
– Importing data into PowerPivot using Simplement Data Liberator connected to SAP ERP

The Author

Jen Underwood

Jen Underwood is a Senior Director at DataRobot and founder of Impact Analytix, LLC. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has experience launching new products and turning around failed projects. Most recently she provided advisory, strategy, educational content development, and marketing services to 100+ technology vendors through her own firm. She has been mentioned by KD Nuggets, Information Management and Forbes for her work. She also has written for InformationWeek, O’Reilly Media, and numerous other tech industry publications. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego. She was also honored to be a former IBM Analytics Insider, Tableau Zen Master, and Top 10 Women Influencer.