Iterative BI-Solution

I have been reading alot about BI-solutions in different Kimball books aswell in Brian Larson´s “Deliviering Business Intelligence” but not until now when reading the book: “Microsoft Business Intelligence for Dummies” have I got a greater and fully concept about how I should work when doing my solution. I have some experience in agil methods with software development and the benefits it provides. Now everything make sense reading about the same approach in BI.

This will be my major angle of incidence going forward with my project.

I will also make a new list that represent what I am really doing so that I can compare after project ending.

Create a specification on what the most important information on the dashboard is. 

  1. Look in the databases of my ERP to localize the table or tables with columns which are necessary to show the transactional data with SSRS.
  2. Create fact tables and dimensions in a star schema.
  3. Create a strategy for the ETL process (maybe this can be devided)
  4. Processing schedule
  5. Populate the tables
  6. Physical design (SSAS)
  7. Extract data to SSRS and make report. (Make subreports and dashboard)
Advertisements
Tagged with: , , , , , ,
Posted in Future thougths, Main, Report Building

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Archive
Categories

Blogstatistics
  • 3,777 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.

True Tiger Recordings

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.

%d bloggers like this: