Category BI

Dynamic Data Flow using COZYROC component Part II

In the previous post, I explained the problem and the envisaged solution using COZYROC Data flow plus component. This post is the continuation of the required setup for using dynamic data source without the need of knowing its metadata ahead of time. In the foreach loop container that which loop over the data definitions there […]

SQL Nexus Call for speakers is live

Nexus noun – “That which unites or binds”         After several months of work with a team of great people and companies: -Kenneth M. Nielsen (b|t) -Mark Broadbent (b|t) –ASAP design –Funky.biz –Microsoft –bloodyuseful We have the honour to launch the call for speakers for the next generation data platform conference in Copenhagen. The […]

Speaking at SPBiz conference

Next week I will virtually be speaking at a 2 days SharePoint virtual conference : SPBIZ. I will speak about a subject that I particularly like : Doing Business Intelligence with SharePoint. About configuring Excel services, Reporting Services and Power Pivot Service to provide SharePoint BI tools in a secure and performant way. This is a […]

Speaking at SQL BITS XIV – Superheroes

The 14th edition (actually it is probably the 13th since they skipped SQLBits XIII – Who said superstition ?) of SQL Bits will take place from the 4th to 7th March in London. This years edition is placed under the Superhero theme. It is my first time at the event and I really have great […]

Speaking at SQL Saturday Slovenia #356 – SharePoint as a BI platform

In only 10 days it is time for gathering of SQL Family and friends in Ljubjana, Slovenia. I will be presenting a brand new session that I’ve been working on for the last 3 years ! No kidding !! And just to make sure that I’m super fresh, I’ve been given the first morning session. […]

SSAS Basic at SQL Saturday 341 Porto

SSAS Basics pre-conference day I have the immense honor and privilege to have been selected to do a whole day of preconference on thursday October 16th at SQL Saturday Porto – Rua Dr. António Bernardino de Almeida. During this whole day of training I will give a thorough introduction to SQL Server Analysis Services together […]

From Hellhound to Best of Breed – A Guide To Setting up Kerberos Delegation with SharePoint BI Stack – Part I

This post is the first one in a series about using SharePoint BI features together with Kerberos, hereby enabling you to delegate the user credentials all the way to the data source, enabling role based security. When I think about it seems like people love to fear Kerberos. Often, the developers and the infrastructure people […]

The necessity of both

Great points and even better discussion about Corporate BI and Self-service BI and the necessity of both. Thanks Chris. Chris Webb's BI Blog I was chatting to a friend of mine a few days ago, and the conversation turned to Microsoft’s bizarre decision to make two big BI-related announcements (about Mobile BI and GeoFlow) at […]

Only Scratching the Surface (RT)

A few weeks ago I purchased a Surface RT at the University Village Microsoft Store in Seattle while attending the 2012 PASS Summit. It was a great and busy Summit and it left me very little time to play with my newly acquired tablet. Now that I have been home for a couple of weeks […]

See Beyond The Numbers: Data Visualization with Status Lists in Sharepoint 2010 – part 2 SSAS based Status Indicator and Fixed Value based Status Indicator

In part 1 of this post I wrote about first two types of Status Indicators : Sharepoint List based and Excel based. In this part I will demonstrate what the possibilities are for building Status List Indicators with SSAS KPIs and also with Fixed Values. SQL Server Analysis Services based Status Indicator This is a […]