Basic Data-Warehouse using Excel
August 7, 2010 at 5:36 PM | Posted in General | 1 CommentTags: data warehouse, powerpivot, sql
As most of you probably know, a full-fledged data warehouse is usually much too complicated to create using just Excel.
Mr. Gleeson explains, however, that with Microsoft’s new PowerPivot extension (and some work) you can create some pretty impressive data-warehouse functionality directly from Excel.
Advertisement
1 Comment »
RSS feed for comments on this post. TrackBack URI
Leave a Reply
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
[...] at 9:33 AM | Posted in General | Leave a Comment Tags: data analysis, powerpivot A few days ago we looked at the new PowerPivot – Microsoft Excel Add-in (well, it’s a little understatement to [...]
Pingback by Starting with PowerPivot’s Data Analysis « Excel Tips Monster— August 15, 2010 #