1) Data modelling
Tools + Kimball worksheet
2) KPI, Perspectives, Translations
video
3) SSIS - best practices
text content
4) SSIS Logging
text content
5) Sharepoint, Powerview
VMWare - workstation
Windows 2008, Sharepoint 2010, MS Office 2010
7) Reports
6) MDX - Scripting
video
7) Definitions:
Dimensions:
Reference (due to snowflake)
Role-Playing
Junk dimensions
Degenerate dimensions
Factless fact tables
Bridge tables - is used to model man-to-many relationship between two dimensions
Parent-child
User-Hierarchies
text content
7) Reference sources
8) Full Blown SSIS package
Tools + Kimball worksheet
2) KPI, Perspectives, Translations
video
3) SSIS - best practices
text content
4) SSIS Logging
text content
5) Sharepoint, Powerview
VMWare - workstation
Windows 2008, Sharepoint 2010, MS Office 2010
7) Reports
6) MDX - Scripting
video
7) Definitions:
Dimensions:
Reference (due to snowflake)
Role-Playing
Junk dimensions
Degenerate dimensions
Factless fact tables
Bridge tables - is used to model man-to-many relationship between two dimensions
Parent-child
User-Hierarchies
text content
7) Reference sources
8) Full Blown SSIS package
No comments:
Post a Comment