EXCEL实用文档-超精美HR数据报告仪表盘

HRManagementDashboardTotalEmp28%72%Source:Obvience©Hourly671948Salary0510152025Qtr1Qtr2Qtr3Qtr4Qtr1Qtr2Qtr3Qtr420152016TotalActiveEmployees160520172018SeparationsSeparationsBadHires11520172018TerminationReasonInvoluntaryVoluntaryEthnicityGroupAGroupBGroupCGroupDGroupEGroupFGroupGFull/PartFTPTGenderFMRegionCentralEastMidwestNorthNorth...SouthWestActivesDashboardSeparationsDashboardTurnover42%50%FullTime43%62%58%50%PartTime57%38%1025134873030-4950+FMQtr4Qtr1Qtr2Qtr3Qtr4Qtr1Qtr2Qtr3Qtr420172018ActiveEmployeesNewHires0510152025FMGroupAGroupBActivesbyEthnicGroup020406080100120140160FMGroupAAverageTenure413275721131119282310CentralEastMidwestNorthNorthwestSouthWestActivesbyRegionFTPTTurnover187%270%140%FMFMFMFMFMFMGroupBGroupCGroupDGroupEGroupFGroupGActivesbyEthnicGroupFTPTFMFMFMFMFMFMGroupBGroupCGroupDGroupEGroupFGroupGAverageTenure-MonthsFTPTYear2015201620172018returntoindexCopyrightNoticeThisworkbookcontainsamodifiedversionofdataprovidedbyObvience.:obviEnce©,MyOnlineTrainingHub©.ThissheetmustremaininanyfilethatusesthisdataandortheseDashboardtechniques.Anyusesofthisworkbookand/ordatamustincludetheaboveattribution.ThisworkbookcontainsamodifiedversionofdataprovidedbyObvience.TheDashboardinthisfilewascreatedbyMyndaTreacyfromMyOnlineTrainingHub.Individualusersarepermittedtorecreatethedashboardforpersonalpracticeonly.Recreatingthedashboardfortrainingofothersisnotpermitted,unlesswrittenconsentisgrantedbyMyndaTreacy.Theworkbookandanyvisualizationpagesmustbeaccompaniedbythefollowingcopyrightnotice:obviEnce©,MyOnlineTrainingHub©.ThissheetmustremaininanyfilethatusesthisdataandortheseDashboardtechniques.Anyusesofthisworkbookand/ordatamustincludetheaboveattribution.Theworkbookandanyvisualizationpagesmustbeaccompaniedbythefollowingcopyrightnotice:obviEnce©,MyOnlineTrainingHub©.ExcelDashboardusingPowerQueryandPowerPivotNote:ThisfilewillnotworkinExcel2010.Note:thisdashboardusesdatafromthefoldersonmyPCasyousawinthewebinar.Asaresultyoucannot'RefreshAll'asyouwillnothavethesamedrivemappingasme.However,youcaninteractwiththedashboardbychangingtheSlicerselections.IfyougetanerrortryingtointeractwiththeSlicersthenyoumayhaveadifferentversionofExceltotheoneIusedtocreatethisdashboard.Checkoutmyotherwebinarshere:Ifyou'dliketolearnhowtobuilddashboardslikethispleasecheckoutmyExcelDashboardcourse.RelatedTraining:GotoExcelDashboardCourseGotoFileIndexGotoPowerQueryCourseGotoPowerPivotCourseFREEWebinarsClickheretoseewhichversionsofExcelhavePowerPivotClickheretoseewhichversionsofExcelhavePowerQueryExcelDashboardusingPowerQueryandPowerPivotdashboardusesdatafromthefoldersonmyPCasyousawinthewebinar.AsaHowever,youcaninteractwiththedashboardbychangingtheSlicerselections.IfyougetanerrortryingtointeractwiththeSlicersthenyoumayhaveadifferentversionofExcelPowerQueryandPowerPivotExcelDashboardswithMyndaTreacyActivesDashboardExcelVersionDifferencesDashboardProtectionMoreResourcesSourceInformationgotosheetgotosheetgotosheetgotosheetgotosheetPowerQueryandPowerPivotExcelDashboardswithMyndaTreacyActivesDashboardSeparationsDashboardreturntoindexRowLabelsActiveEmployeesF48M19GrandTotal67ActiveEmployeesColumnLabelsRowLabelsFMGrandTotalHourly50.00%42.11%47.76%Salary50.00%57.89%52.24%GrandTotal100.00%100.00%100.00%ActiveEmployeesColumnLabelsRowLabelsFMGrandTotalFT61.54%43.18%54.92%PT38.46%56.82%45.08%GrandTotal100.00%100.00%100.00%ActiveEmployeesColumnLabelsRowLabelsFMGrandTotal301041430-492583350+13720GrandTotal481967TO%ColumnLabelsRowLabelsFMGrandTotal201763.79%105.71%79.57%201892.31%186.36%126.23%GrandTotal139.74%270.45%186.89%ActiveEmployeesColumnLabelsRowLabelsFTPTGrandTotalGroupAF13619M4913GroupBF17522M5510GroupCF8614M62127GroupDF15722M5914GroupEF151227M6511GroupFF181129M81119GroupGF639M6814GrandTotal132118250RowLabelsSeparationsBadHires201710201865GrandTotal75SeparationsColumnLabelsRowLabelsInvoluntaryVoluntaryGrandTotal2017112018156GrandTotal257ActiveEmployeesColumnLabelsRowLabelsFTPTGrandTotalCentral41115East13316Midwest21113North71926Northwest52833South72330West21012GrandTotal40105145Avg.TenureMonthsColumnLabelsRowLabelsFTPTGrandTotalGroupAF772361M1134767GroupBF1052186M61533GroupCF581640M1381441GroupDF971170M672037GroupEF90751M1154282GroupFF621544M603043GroupGF90562M672845GrandTotal852054RowLabelsActiveEmployeesNewHires2015Qtr113Qtr213Qtr313Qtr41412015Total1412016Qtr114Qtr214Qtr314Qtr4142016Total142017Qtr114Qtr2162Qtr3161Qtr41712017Total1742018Qtr1181Qtr2191Qtr3206Qtr4192018Total198GrandTotal1913MoreResourcesCoursesExcelDashboardCourse.PowerQueryCourse.....PowerPivotCourse.....PowerBICourse........ExcelForum...............Contact...................://