Finding distribution in a list of values

September 18, 2008

I had a friend of mine ask me a question not long ago. He had developed a site for posting ads on selling houses for a certain company. The managers of the company were now trying to analyze the data on people posting ads. One of the things they were asking him to do, was give them a graph on how many people were posting ads on a certain span of prices. They weren't going to define him the span of money, but rather wanted him to give them the span, according to the amount of people that existed...

BI & Cloud Computing

September 17, 2008

Well I guess the future is really up in the cloud... The last strategic move for Panorama is joining Google and offering a BI Analytics tool to work with Google Docs - PowerApps. But that's old news by now. GoodData has recently gotten funding for their BI in the cloud, giving you a complete platform for storing and analyzing your data. Business Objects offers "OnDemand" another platform that enables you to share Crystal Reports over the web. The list goes on, with other companies trying to get a piece of the pie. So maybe that's what pushed Microsoft from...
tags: , ,

BI and SQL Server Videos

September 15, 2008

I came across two very interesting web sites lately, both of which are a great source for good webcasts. The first site is Learn Microsoft BI which has all sorts of video on BI projects and how to develop them using SSAS. There has actually just been a first video on PerformancePoint Server as well. The site requires registration, but is well worth it. The other site is SQL Server Videos which targets more DBAs and developers. Having done just a few webcasts and knowing how much work goes into it, I am in complete awe of what's given in both...

Slowly Changing Dimension Type 2 Tips & Tricks

September 9, 2008

Slowly Changing Dimension Type 2 Tips & Tricks I've blogged in the past about Slowly Changing Dimension Type 2, and I see that it's a subject that really interests you. I remember quite distinctly how hard and demanding it was to create it for my project (trust me I do!) and even to do it for two business entities. So, hoping that I may assist you even slightly, I thought I may share with you a few thoughts I have on the matter: Do you really need it? Now I know this is going to sound quite obvious, but before...