Image

Excel

SAP Hana and PowerPivot
6 years ago

SAP Hana and PowerPivot

Last year I shared a fantastic white paper on various ways to consumer SAP and SAP BW data in PowerPivot for more agile self-service business intelligence with SAP sources –  …
Read More

PowerPivot Maps, Tabs, Image Overlays and Other Creative Tips
6 years ago

PowerPivot Maps, Tabs, Image Overlays and Other Creative Tips

Let’s face it, dashboard presentation design matters and you can get fancy with PowerPivot. PowerPivot can be seriously fun, functional and powerful – especially with upcoming Hadoop ODBC and Hive …
Read More

Social Analytics PowerPivot Solutions
6 years ago

Social Analytics PowerPivot Solutions

UPDATED 8/14/2013 Microsoft BI Social Analytics Solution and Technical Support Site

Social analytics enables companies to keep a constant pulse on   the marketplace by reviewing customer sentiment, likes, dislikes  and hot …
Read More

Playing with the Big Data Hadoop ODBC Driver
6 years ago

Playing with the Big Data Hadoop ODBC Driver

At PASS, Microsoft announced the upcoming TAP for a Hadoop ODBC driver.  This driver will enable integration of Apache Hadoop, Windows and Azure Hadoop flavors with various Microsoft BI products. …
Read More

Tip! SharePoint BI/Excel Services
6 years ago

Tip! SharePoint BI/Excel Services

If you have multiple pivot tables/charts in a SharePoint EWA web  part you can use a slicer as a controller to those multiple objects  and pass parameters to the slicer from …
Read More

Tip! Using PowerPivot as PerformancePoint Data Sources
6 years ago

Tip! Using PowerPivot as PerformancePoint Data Sources

I just finished a really fun BI POC build. In this POC, I have been using an Excel Power Pivot .xlsx file as a PerformancePoint data source! I was skeptical but hey …
Read More

More Microsoft BI and SAP
6 years ago

More Microsoft BI and SAP

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 …
Read More

Top