Image

Power Pivot

Data Discovery Player Market Trends
4 years ago

Data Discovery Player Market Trends

In keeping a close pulse on the overall BI industry, one of the stats I like to track is the Job Trends and Skills that are HOT and their increase …
Read More

FAQ: How is PowerPivot Different than Excel?
5 years ago

FAQ: How is PowerPivot Different than Excel?

I have wanted to write this post for a LOOOOONG time now.  I cannot delay this again, period.  Deep technical resources often ask me what is the difference between PowerPivot …
Read More

Free BI Technical Training from Microsoft Product Teams
5 years ago

Free BI Technical Training from Microsoft Product Teams

http://www.microsoftvirtualacademy.com

WOW – how did I miss the memo?  I did not know this great technical resource even existed so thought I would share it here in case others are …
Read More

FAQ: How to deploy SQL Server 2012 BI in a SharePoint 2010 farm
5 years ago

FAQ: How to deploy SQL Server 2012 BI in a SharePoint 2010 farm

UPDATE: August 2012 Power View Infrastructure Installation:  Step-by-Step and Scripts

General guidance for implementing SQL Server 2012 BI in a SharePoint 2010 farm (with one dedicated BI Server in the …
Read More

PowerPivot “How To” for Large Scale Projects
5 years ago

PowerPivot “How To” for Large Scale Projects

It seems many BI pros do not realize the wonderful large scale potential for PowerPivot projects using the easy SSAS upgrade path in SQL Server 2012. Most of the enterprise …
Read More

SAP Hana and PowerPivot
5 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

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