Blog Archives

Trouble with YTD

Yesterday I had big trouble with the YTD function. I can´t make it work with my new cube. I wonder if it have something to do with my custom made time dimension. I will continue look into this since it´s

Tagged with: , ,
Posted in SCRUM

ETL Process

So, I am going to extract data from my ERP system and transform it before creating the cube. The only problem is that the data is already “good” so i don´t know what to do with it in SSIS so

Tagged with: , ,
Posted in SCRUM

So I have started to look at PowerPivot with Microsoft Excel  2010. I guess it´s a light variant of BI-solution with SSAS and SSRS. Maybe I will create a dashboard in PowerPivot also, so that powerusers can have a first

Tagged with: , , , ,
Posted in Future thougths, SCRUM

Building the main dashboard

I have now worked two days with my dashboard. I started with the main dashboard to see what i can accomplish in design. Then i will have to re-think and create the subreports and the drilldown capabilities which will probably

Tagged with: ,
Posted in SCRUM

Report finished

So, finally my report is finished and i can go on with my project. This week i will start creating reports in SSRS i think and if everything works fine i will look at Excel next week. I will try

Tagged with: ,
Posted in MDX, SCRUM

Last day of report writing.

Today will be my last day of writing my report to sum up my learnings about MDX. It´s been a short intensive period of study and i will surely come back to this topic during the following months. So the

Tagged with: , ,
Posted in Future thougths, SCRUM

Report writing & MDX-queries

Today i will continue with my report and get some of my previously made MDX-queries cover more aspects of querying. I will also read some more on the “Stairway to MDX” – forum to get more knowledge before finishing my

Posted in SCRUM
Archive
Categories

Blogstatistics
  • 4,124 hits
Boyan Penev on Microsoft BI

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Sherry's BI Corner

All about Microsoft’s BI Platform (SQL Server, Reporting Services, Analysis Services, Integration Services)

Sherry's BI Corner

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Comments for CALUMO

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

En smartare planet

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.

Data Inspirations

This is my journey towards greater knowledge with Microsofts Business Intelligence Solutions.