The report allows comprehensive on SAIT Staffing. It is in workspace ws_SABOG. The pipeline contains ws_SABOG [Development], ws_SABOG [Test], ws_SABOG. Datasets can be edited in ws_SABOG [Development]. Tedi Tehrani is the author. The report Staffing_All.pbix is separated from the datasets dataset_StaffingALL.pbix
dataset_StaffingALL
The dataset is a basically star schema using StaffingFact as the fact table. Snowflake extensions apply to a few Employee and empstartpoistion dimensions. The dataset users parameters that are set as rules in the pipeline to connect to dev, test, prod dataflows. As of this publishing the dataset contains 11 13 tables.
Table | Source (dataflow, entity, workspace) | |||||
|---|---|---|---|---|---|---|
Account | datawarehouse, account CareerTracks_Titlecodes_3 | CrareerTracks,CareerTracks_Titlecodes_3 , ws_SABOG | ||||
Control PointEmpjob Fact table | datawarehouse, account , ws_SABOG | Cost Centers | GMC Costing, costcenters, ws_SABOG | Cost Types | GMC Costing, costTypes , ws_SABOG | |
Employee | df_UCPath,UCPath Emp Demographic", ws_payroll | Fund | datawarehouse, Fund , ws_SABOG | Project Codes | GMC Costing,projectCodes,ws_SABOG | |
StaffingFact | Sub | UC Path Job Funding | UC Path Fiscal Calendar | |||
IDMSecurityBTStaffing | ||||||
Order of YOS | ||||||
Remote_Hybrid | ||||||
RLS Manager | ||||||
Salary Diff Percentile | ||||||
Sorting Annual Salary Category | ||||||
Time in Position | ||||||
UCPath Position |