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 StaffingWorkspace_AllDemographics.pbix is separated from the datasets dataset_StaffingALL_BT.pbix
dataset_StaffingALL_BT
The dataset is a basically star schema using StaffingFact as Empjob Fact Tableas the fact table. Snowflake extensions apply to a 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 13 tables.
Table | Source (dataflow, entity, workspace) | |
|---|---|---|
CareerTracks_Titlecodes_3 | CrareerTracks,CareerTracks_Titlecodes_3 , ws_SABOG | |
Empjob Fact table | datawarehouseEmpjob, account empjob, ws_SABOG | |
Employee | df_UCPath, UCPath Emp Demographic", ws_payroll | |
Fiscal Calendar | Calendars, Julian Fiscal, ws_public data | |
IDMSecurityBTStaffing | IDMSecurtiy, IDMSecurtiytBTStaffing, ws_SABOG | |
Order of YOS | manually entered table | |
Remote_Hybrid | HybridRemoteOnSiteGoogle, Remote_Hybrid, ws_SABOG [Development] | |
RLS Manager | ? Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText( | |
Salary Diff Percentile |
| |
Sorting Annual Salary Category | manually entered table | |
Time in Position | ? Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText( | |
UCPath Position | Datawarehouse, UCPath Position, ws_SABOG |