How to implement a data warehousing solution for Google Analytics d...

SOA and Data Warehousing

Hello everyone.... I need your help here. I am working on some DW related roadmaps. I am stuck on role SOA(Service Oriented Architecture) is going to play in Data Warehousing ETL in- particular and BI in-general. Your comments on above mentioned are

predictive analytics suggested reading?

I am curious if anyone has any recommendations on understanding predictive analytics concepts and/or techniques. In particular, how to apply such concepts to datawarehousing and dimensional modeling. I am not sure if there are any conceptual books on

New at BI and data warehousing and trying to make sense of it all.

Good evening gents! I am new on this site obviously and wanted to say hi before i start with my issue. now on to the issue. I am starting a data warehousing project from complete scratch for a small company that is getting off the ground. This is my

Data Warehouse Purge Strategy - HELP

I'm looking at the best way to implement a purge strategy in a dimensional model. The reason to purge is that no personal data can be kept after 4 years, but the users would still want to see counts/facts by no identifying data. For example i couldn't

Data Warehouse Failure Statistics

Is there any recent study / statistics / surveys on data warehouse project pitfalls and risks ? Your help is truely appreciated. Best Regards,

Data Warehousing Vendors (Manufacturing)

Dear Sir or Madam We are a local company located in Syria, specialized in Industrial Confectionary Development (Food; Biscuit, Chocolate and Juice) The company seeks to find consultants/ vendors in order to initiate a data warehouseing project to be

Managing Data warehousing Unit

I am working as data warehousing and Reporting manager. I am responsible of managing the unit and helping my Engineers in data modeling and ETL design and developing Reporting some times .I am also responsible of running any data warehousing projects

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Vote for Drawing Contest [Winner-Emilio]

Vote for Drawing Contest! Start Voting for the best creation Hello Everyone Thank you all for submitting your wonderful eye catching ideas & creations for this contest. Here are the entries, you will need to post whose creation you

New update: anti-spam system + Google +1 Widget

Important AnnouncementNew update: anti-spam system + Google +1 Widget Hello, In response to your growing demand, and to provide you with secure forums incorporating all the latest technical progress, Forumotion and his team are proud to announce

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

How to implement a data warehousing solution for Google Analytics data?