Call today 0845 643 6463

Business Intelligence

  • BCS talk on Business Intelligence

    September 6th, 2010 in Blog, Business Intelligence

    On Monday 20th September, Alex & Hollie from Purple Frog Systems will be giving a talk on business intelligence to the Shropshire branch of the British Computer Society. The event is free to attend, even for non BCS members, and will be held from 6.15pm at the Telford campus of Wolverhampton Uni. We’ll be providing an introduction to BI, explaining what it is, how it works and how it can benefit your organisation. We’ll present…

    » Read more

  • Calculating Run Rate in DAX for PowerPivot

    August 20th, 2010 in Blog, Business Intelligence, PowerPivot

    In my previous post I explained how to create a calculated MDX member that projects full year data (sales etc.) based on existing year to date data. In this post I’ll be doing exactly the same but in DAX, the new expression language used to enhance PowerPivot data. As it’s the same desired outcome, I’m not going to repeat the background, you’ll have to look at my previous post for that. The expressions below assume that…

    » Read more

  • Data Warehousing: Kimball vs Inmon

    August 2nd, 2010 in Blog, Business Intelligence

    Anyone involved in the Business Intelligence space has had their head in the sand if they are not aware of the long running, and more often than not misunderstood, debate between the two conceptual models of data warehouse design. Bill Inmon has recently posted an article on www.b-eye-network.com discussing the matter, and to his credit, has tried to put forward a number of balanced pros and cons of each methodology. I’ll state now that…

    » Read more