What are some of the most common problems encountered when integrating data from multiple sources to retrieve the data points necessary for business analytics? Very frequently asked questions that we hear when starting business intelligence projects include:
How to connect to the data sources? How do I manage different keys for similar data? How to handle large data feeds? Should I use a temporary staging table or load dimensions and facts immediately? Must I use a UDM for data model?
These are complex questions with answers that depend on many factors. But they are frequently asked and I am putting together a list of answers for these based on Microsoft SQL Server best practices for BI and DW using SSAS and SSIS and various solutions through our partners including those that offer solutions for high-speed adapters.
Those answers and responses will be posted here on my blog over the next several weeks, so please check back frequently ... hang in there!! Mark