Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by P1Daniels
-
Is TIME a SCD or FCD?
I'll probably get slammed for this, but I don't think it is either...Generally, changing dimensions are present when information becomes outdated, or the truth changes over time...Home Address is a slowly changing dimension, Customer_Type could also be a slowly changing dimension, whereas...- P1Daniels
- Post #2
- Forum: Data Warehousing/Big Data
-
Data Warehouse Suggestions
Many of the most important issues in DW'ing no longer lie within the DW itself...Here are couple of ideas, in and out of the DW Developing Data Mining Algorithms in a DW Measuring a DW's Return on Investment (ROI) Developing cross-functional teams to ensure a successful DW Real-time DW using an...- P1Daniels
- Post #2
- Forum: Data Warehousing/Big Data
-
data ware house and analyis services
SQL Server does not contain any visualization tools and Analysis Services only has basic data checking tool...You can connect to an Analysis Services cube using Microsoft Excel and swet up graphing there...(Open MS Excel...Get External Data...then point to the cube..). You may need to install... -
How calculate percent values??
Look up "calculated measure" in your Help menu... -
New to DW, Can you provide an outline or plan of action?
Kimball's book "The DW-ing Toolkit" has a section entitled "The Nine Decision Points of Data Warehousing"...That contains the most fundamental list of questions needing answers before anybody proposes a design, a toolset, or writes one bit of code..There's also some good tips...- P1Daniels
- Post #4
- Forum: Data Warehousing/Big Data
-
Business Objects Vs Proclarity Decision
ProClarity has developed an extensive and tight partnership with Microsoft. If intergration with Desktop tools is important to you, I would consider ProClarity, as the integration will only get tighter in the coming months...What DB system are you using? If SQL Server 2000, I would recommend...- P1Daniels
- Post #5
- Forum: Data Warehousing/Big Data
