Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help for modelling a campaign marketing data

Help for modelling a campaign marketing data

Help for modelling a campaign marketing data

Hi all,

I am new to DW and started as intern in a campaign marketing firm.
They want to analyse their data to find answers to questions like,

1. agent performance. What made him to perform well.(Analyse the agent behaviour)
2. Analyse the customer behaviour. etc

Currently they have a relational database with tables like Activity, transaction, leads, campaigns, customers, etc. Can I create an OLAP cube with this? Or what are the things i need to look into the table to create a cube.

Do I need to create a DW or just OLAP cubes?

Any help is appreciated. Don't know where to start?


RE: Help for modelling a campaign marketing data

Well, I would say that it depends on the scope of the project (and perhaps the tools involved) With Microsoft BI I would create a couple of starschema's first and use these to create OLAP cube structures. With a premium BI tool like Cognos you have a few more options (ROLAP) cause you have a more advanced metadatamodelling layer to work with.

Depending on complexity and amount of data I can even imagine that you define db views that constitute the starschema's which would mean not having to generate ETL. This would not be a big issue if you only need to generate the cubes overnight.

However, the first step in each case is to define your dimensions and facts. I can imagine you somehow will need to create facttables from 'factless facts'/ 'event' tables in your case

Ties Blom

RE: Help for modelling a campaign marketing data

Thanks Ties,

Currently I have downloaded the cognos Trial version and might also download Microstrategy. My company wants to see which would be better. Although I see lot of videos to create cubes, I don't see creating facts from factless tables. I would appreciate if can you help me creating a basic cube from the events table. I need a jump start.


RE: Help for modelling a campaign marketing data

If you are working on SQL server you might consider using a MS BI solution. This is a far more cost-friendly solution if you have a limited project. What ever solution you choose you will need to follow some regular training to get the basics. for Cognos look also here:


Ties Blom

RE: Help for modelling a campaign marketing data

Hi, I am also new to data warehousing and facing this same situation now. But I can do ETL using Informatica but not cubes and not very familiar with the other terminology mentioned above. Can you please help me how you proceeded further in this case? I am not sure how to build the star schemas because the relations between the tables is so messy and confusing.

RE: Help for modelling a campaign marketing data

If you are new, I also recommend the Microsoft BI solution. Microsoft Analysis Services.  It's relatively easy to pick up, and there's a forum here on tek-tips if you get stuck.  

The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close