All about Power BI, Modelling, DAX and Microsoft BI
This week i have a .NET 3.5 WPF course by the good people of U2U. One of the most interesting new things is Data Binding. A short introduction: Microsoft Windows Presentation Foundation (WPF; formerly Avalon) introduces a profound new way to develop user interfaces for rich clients. For the first time, WPF separates design of the user interface from the code. This separation means that, much like ASP.NET, your markup is typically in one... Read more
There’s a lot of talk these days about key performance indicators (KPIs). They are the backbone of scorecards and dashboards, which have become an irresistible way for organizations to present performance information to executives and staff. Unfortunately, BI developers seem to focus more on creating visual metaphors (dials, gauges, arrows, etc.) than understanding what constitutes a good KPI that delivers long-term value to the organization. Part of the problem is that people use the... Read more
A very nice artikel about the “future” of healthcare .. is it? In a nutshell, all patient records are accessable, everything from their medical histories to lab results in google, behind a login. Read more: Google to Begin Storing Patients’ Health Records Read more
Microsoft has announced the release of a new feature complete SQL Server 2008 CTP, try it online for free on the SqlServerBeta site or at the MS connect site. I’ve played with it a little and found the new report designer to still be a preview version with some strange behavior. BIDS seems stable and the report project environment is nice, too bad the wizard isn’t there (yet i hope). The new reporting services configuration manager had... Read more
One of most important enhancements coming up in SQL Server 2008 Reporting Services is the new tablix region. In fact, I dare to predict that many folks will upgrade to SSRS 2008 just to get Tablix. What’s tablix anyway? A nice article about the tablix at: http://prologika.com/CS/blogs/blog/archive/2007/08/12/tablix-the-crown-jewel.aspx Read more
I made a connection to AS in Excel and published this connection as a ODC file to SharePoint as mentioned in a previous blog post. But when i openend the file connection by clicking itm i got a warning: “Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server”. After some searching with MS i found a solution: http://support.microsoft.com/kb/931388. I tried tuning the... Read more
Some very nice videos and test drives of the 2008 products (BI included) at: http://www.microsoft.com/heroeshappenhere/testdrive/sql-server-2008/default.mspx Read more
When you want to analyse a cube in sharepoint from excel services you need to create a data connection file and publish it to SharePoint, see the following Blog post for a walk through: http://www.sharepointblogs.com/tonstegeman/archive/2007/03/13/using-analysis-services-data-in-excel-services-part-3-create-and-test-an-excel-sheet.aspx One note, it is stated in the above walk through you need to save the file and upload it to the data connection folder, but its easyer to save it to the data connection folder at once. Read more