1
00:00:00,240 --> 00:00:02,240
Hi, everyone. This is
Phil from one model.

2
00:00:02,240 --> 00:00:04,960
And we spend a lot of time here
talking about how to connect

3
00:00:04,960 --> 00:00:07,600
data from, you know, big
systems like Workday,

4
00:00:07,600 --> 00:00:09,120
SuccessFactors, Oracle.

5
00:00:09,120 --> 00:00:11,120
Of course, we handle
that very well.

6
00:00:11,120 --> 00:00:13,680
But another question that
usually comes up right after

7
00:00:13,680 --> 00:00:16,985
that is, what if we have some
supplemental data coming from,

8
00:00:16,985 --> 00:00:18,425
say, just a spreadsheet?

9
00:00:18,425 --> 00:00:19,705
It's important to our analysis.

10
00:00:19,705 --> 00:00:22,265
We wanna load that in and
connect it with the data that's

11
00:00:22,265 --> 00:00:24,325
coming from these other systems.

12
00:00:27,240 --> 00:00:29,880
This can be important
particularly if you're tracking

13
00:00:29,880 --> 00:00:33,400
against a headcount plan or
if you have recruiting targets

14
00:00:33,400 --> 00:00:35,240
that you're
maintaining separately.

15
00:00:35,240 --> 00:00:38,120
You wanna bring that in and you
wanna show it alongside your

16
00:00:38,120 --> 00:00:41,460
other metrics so your team can
see how they're performing.

17
00:00:41,745 --> 00:00:45,025
You also wanna have a process
to update that back into one

18
00:00:45,025 --> 00:00:48,065
model in case things change
as you go through time.

19
00:00:48,065 --> 00:00:50,145
So if you look at
this view right now,

20
00:00:50,145 --> 00:00:52,145
we have a head count
projection that's going on.

21
00:00:52,145 --> 00:00:55,745
We can see how our head count is
changing in the view in the upper right.

22
00:00:55,745 --> 00:00:59,560
And what we wanna do is add in
some additional perspective and

23
00:00:59,560 --> 00:01:01,480
that's gonna come
from a spreadsheet.

24
00:01:01,480 --> 00:01:03,320
So here's our spreadsheet.

25
00:01:03,320 --> 00:01:05,000
And this is a really
simple example.

26
00:01:05,000 --> 00:01:08,280
But, again, when you load
in supplemental data like this,

27
00:01:08,280 --> 00:01:11,615
sometimes it is a very simple
additional piece of data that's

28
00:01:11,615 --> 00:01:13,215
going to make all
the difference.

29
00:01:13,215 --> 00:01:15,135
So we make that
easy in one model.

30
00:01:15,135 --> 00:01:16,815
Here's my spreadsheet.

31
00:01:16,815 --> 00:01:18,335
And back in the system,

32
00:01:18,335 --> 00:01:21,195
what I'm gonna do is
go to my data menu

33
00:01:22,610 --> 00:01:26,430
and I'll pull open our sources
so you can get a sense of

34
00:01:26,930 --> 00:01:28,770
how we bring that data in.

35
00:01:28,770 --> 00:01:31,890
So here in one model, we
have all of the different sources.

36
00:01:31,890 --> 00:01:35,135
Again, core HR, recruiting,
performance survey,

37
00:01:35,135 --> 00:01:36,735
those could all
be coming in here.

38
00:01:36,735 --> 00:01:41,295
But what we've also set up is
a place where we can import a

39
00:01:41,295 --> 00:01:44,015
few spreadsheets coming
from the finance team.

40
00:01:44,015 --> 00:01:47,620
In this case, we can see some location,
earnings data, and, and of course,

41
00:01:47,620 --> 00:01:50,740
we can see those target head counts
that we were just looking at.

42
00:01:50,740 --> 00:01:52,980
Okay. So back to our
head count projection.

43
00:01:52,980 --> 00:01:56,100
Let's add in that head count
line so we can see how we're

44
00:01:56,100 --> 00:01:58,080
doing against our plan.

45
00:01:58,500 --> 00:02:00,720
I'm gonna explore this view.

46
00:02:02,105 --> 00:02:05,705
And now, here in
the Explore tool,

47
00:02:05,705 --> 00:02:08,665
I have the data coming
in from the finance team.

48
00:02:08,665 --> 00:02:10,585
That's become part
of my data model.

49
00:02:10,585 --> 00:02:13,445
And now, all I have
to do is click,

50
00:02:13,480 --> 00:02:15,640
add in that target
head count number.

51
00:02:15,640 --> 00:02:18,120
The other thing I'm gonna do
quickly is just make it align

52
00:02:18,120 --> 00:02:20,660
so that it lines up
with everything else.

53
00:02:21,800 --> 00:02:23,220
Here we go.

54
00:02:23,400 --> 00:02:27,015
We'll rerun that and now we
can see for perspective how my

55
00:02:27,015 --> 00:02:31,095
headcount is trending against
where I'm trying to go, my plan.

56
00:02:31,095 --> 00:02:33,495
My plan is now shown
in that green line.

57
00:02:33,495 --> 00:02:36,055
The line is straight in this
case. It could be dynamic.

58
00:02:36,055 --> 00:02:38,535
It could change over time
and that's perfectly fine.

59
00:02:38,535 --> 00:02:40,190
And if you had keen eyes,

60
00:02:40,190 --> 00:02:43,230
you may have noticed that we didn't
just load in a static number.

61
00:02:43,230 --> 00:02:46,910
We actually had target head counts
that were different for each location.

62
00:02:46,910 --> 00:02:49,070
And so again,
thanks to one model,

63
00:02:49,070 --> 00:02:52,430
we can align all of those
dimensions and now allow you to

64
00:02:52,430 --> 00:02:54,895
say not just how are
things going overall,

65
00:02:54,895 --> 00:02:58,395
but maybe my user wants
to come in and understand

66
00:02:58,495 --> 00:03:00,715
for, headcount,

67
00:03:00,895 --> 00:03:03,535
how are things
looking by location.

68
00:03:03,535 --> 00:03:06,155
For example, say, just in Texas.

69
00:03:06,335 --> 00:03:08,815
As soon as I add that
filter and rerun it,

70
00:03:08,815 --> 00:03:10,320
everything updates.

71
00:03:10,320 --> 00:03:12,640
Everything's joined together
and now I can see how the team

72
00:03:12,640 --> 00:03:14,960
in Texas is doing relative
to their headcount.

73
00:03:14,960 --> 00:03:17,840
You know, what often happens with
some of these strategic planning

74
00:03:17,840 --> 00:03:20,640
processes is that the strategy
happens at the beginning of the

75
00:03:20,640 --> 00:03:22,000
year and then unfortunately,

76
00:03:22,000 --> 00:03:24,720
it gets forgotten as you go
into operational mode during

77
00:03:24,720 --> 00:03:26,285
the rest of the year.

78
00:03:26,285 --> 00:03:28,525
By setting up a process
like this in one model,

79
00:03:28,525 --> 00:03:31,245
you're able to keep track of
how you're trending against

80
00:03:31,245 --> 00:03:34,285
that plan as time goes
on and, of course,

81
00:03:34,285 --> 00:03:36,605
take action and intervene
when you need to.

82
00:03:36,605 --> 00:03:39,885
You know, again, if you find yourself
and you have data in different systems

83
00:03:39,885 --> 00:03:43,210
and those systems are
large, small, spreadsheets,

84
00:03:43,390 --> 00:03:44,910
full HRIS systems,

85
00:03:44,910 --> 00:03:48,350
come and talk to us because the
power for you is gonna come in

86
00:03:48,350 --> 00:03:50,270
bringing all of
that data together,

87
00:03:50,270 --> 00:03:53,310
seeing connected insights, and
getting everything aligned.

88
00:03:53,310 --> 00:03:56,170
And check us out at OneModel

89
00:03:57,357 --> 00:03:58,777
or something.