Contents tagged with BI
-
SSAS: Using fake dimension and scopes for dynamic ranges
In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had really no option to use some classic solution. Thanks to SSAS forums I got my problem solved and here is the solution.
-
MSSQL: Copying data from one database to another
I have database that has data imported from another server using import and export wizard of SQL Server Management Studio. There is also empty database with same tables but it also has primary keys, foreign keys and indexes. How to get data from first database to another? Here is the description of my crusade. And believe me – it is not nice one.
-
Exam 70-448 - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
The another exam I passed was 70-448 - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. This exam covers Business Intelligence (BI) solutions development and maintenance on SQL Server 2008 platform. It was not easy exam, but if you study then you can do it.
-
Notes from Rafal Lukawiecki business analysis sessions
Last week Rafal Lukawiecki visited Estonia and I was lucky enough to find time for two sessions in my pretty tight schedule. All Rafal’s sessions were about Business Intelligence (BI) at Microsoft platform. This posting contains few notes I made for myself. Maybe you can find some interesting facts here too.