Business Intelligence, PowerBI, PowerPivot, SQLServerPedia Syndication

Sharepoint and PowerPivot: Connections fail to refresh in SQL Server 2008 Denali CTP3

Sharepoint requires a range of troubleshooting skills because it can involve the integration of various applications, which are necessarily resting on the application stack. I have the deepest respect for SharePoint specialists since i know that the troubleshooting skills can cut across applications and an understanding of the 'glue' that welds SharePoint together. Take, for example,… Continue reading Sharepoint and PowerPivot: Connections fail to refresh in SQL Server 2008 Denali CTP3

Business Analytics, Community, Data Relish Services, Mobile Business Intelligence, PowerPivot, Tableau

SQLUniversity: PowerPivot, Tableau and Jedi Knights

This blog will show an overview of how I mobilised PowerPivot using Tableau. I've previously given this session at SQLBits, NEBytes Microsoft Technology User Group, and SQLServerDays in Belgium but thought it would also be useful to supply the files for you. The steps are very simple since I intended to show the end-to-end solution… Continue reading SQLUniversity: PowerPivot, Tableau and Jedi Knights

Community, Mobile Business Intelligence, PowerPivot, Tableau

SQLUniversity: Introduction to PowerPivot and Mobile Business Intelligence

Here is the second post for SQL University, where we introduce the topic of mobilising PowerPivot data. As an introduction, I thought it might be useful to share the presentations that I did recently. Tomorrow's blog will talk more about the details of mobilising PowerPivot data using Tableau, but I thought that these articles might… Continue reading SQLUniversity: Introduction to PowerPivot and Mobile Business Intelligence

Community, PowerPivot, SQLServerPedia Syndication

SQLUniversity: PowerPivot and ATOM feed mashup Source to PerformancePoint

This is the first episode of SQL University’s week of PowerPivot! In this episode, we will look at how PowerPivot can be used to mash up PowerPivot and ATOM Feed data, which in turn is then shaped and surfaced in PerformancePoint Services for Sharepoint. All of the images are hosted on Flickr so please feel… Continue reading SQLUniversity: PowerPivot and ATOM feed mashup Source to PerformancePoint

PowerBI, PowerPivot, SQLServerPedia Syndication

DAX PowerPivot Arbitrary Time Intelligence with Fact tables containing Future Data

One thing I love about PowerPivot is the Time Intelligence feature. Aspects of Time Intelligence appear non-intuitive at first, but with practice, it becomes clear. This is all very well if you have nice, clean Time Intelligence requirements, such as Year to Date, Month to Date, and so on. However, what happens if you have… Continue reading DAX PowerPivot Arbitrary Time Intelligence with Fact tables containing Future Data

PowerBI, PowerPivot

Sorting Months from PowerPivot models in Excel Filters and Slicers

Date Sorting by month requires additional steps for Excel Filters and Slicers, and these will be discussed here. The excellent book entitled ‘Practical PowerPivot and DAX Formulas for Excel 2010’ by Tennick suggests one method of fixing the issues around the Excel slicer sorting, which involves an IF statements on an existing Month Number column… Continue reading Sorting Months from PowerPivot models in Excel Filters and Slicers

Business Intelligence, Data Visualisation, PowerPivot, SQLServerPedia Syndication

PowerPivot Denali – Upgrading from SQL Server 2008 R2 and KPIs

This blog is part of a series in which I will share my experiences in the move from PowerPivot in SQL Server 2008 R2 to SQL Server 'Denali'.  As always, your comments are welcome! In this segment, I will explore the upgrade itself, and some new functionality in PowerPivot - the creation of KPIs.The UpgradeThe… Continue reading PowerPivot Denali – Upgrading from SQL Server 2008 R2 and KPIs

Business Intelligence, Data Visualisation, PowerBI, PowerPivot, Tableau

Tableau and PowerPivot – a subversive partnership?

From the Tableau perspective, why is PowerPivot a credible data source? Since PowerPivot is a 'user-oriented' tool rather than an IT-oriented tool, it is possible that its complexity and offering can be overlooked. PowerPivot fits well with Tableau, which is also aimed at the business user audience. This blog offers a preview of some of the… Continue reading Tableau and PowerPivot – a subversive partnership?