Latest / Pharmacy Podcast Network / Turning Information into Impact in LTC Pharmacy | FrameworkFocus™

Transcript

Turning Information into Impact in LTC Pharmacy | FrameworkFocus™ · Pharmacy Podcast Network

0:00
Speaker 1: Thanks for listening to the Pharmacy podcast Network.
0:20
Speaker 2: You are listening to Framework Focus, the podcast that explores trends, innovations,
0:25
Speaker 2: and insights in the long term care pharmacy industry. Join
0:29
Speaker 2: us as we connect the entire LTC ecosystem.
0:32
Speaker 3: Hey, welcome back to the podcast for everything long term
0:36
Speaker 3: care pharmacy. Frame Work Focus by Softwriters one of my
0:41
Speaker 3: favorite podcasts because I love talking to LTC. I love
0:44
Speaker 3: talking about the evolution of community pharmacy, which, by the way,
0:48
Speaker 3: is going to heavier long term care in the future
0:51
Speaker 3: of long term care at home. And when I think
0:54
Speaker 3: of how to build business, building business or building onto
1:01
Speaker 3: business is going to take data and it's going to
1:03
Speaker 3: take data reflection and that in of itself. I guess
1:07
Speaker 3: we could say people say analytics, people say metrics, people
1:11
Speaker 3: say data. Terry's here with me, Terry, what do you
1:15
Speaker 3: say metrics, analytics or data?
1:18
Speaker 4: Oh?
1:19
Speaker 1: I guess I'd say insight.
1:22
Speaker 4: Call it anything, right, but generally I call it metrics.
1:26
Speaker 1: That's probably my normal turm outside of insight.
1:30
Speaker 3: What about you, Amanda, Is it data or is it data?
1:34
Speaker 5: Ooh?
1:35
Speaker 4: I would definitely say depends on how I feel, but
1:40
Speaker 4: typically data, yeah, very rarely data.
1:44
Speaker 3: Yeah, data data guy myself. Hey, coming back to Terry,
1:49
Speaker 3: introduce yourself to the to the listeners, let them know
1:53
Speaker 3: who you are and what you do over there at SOFTWRITERSH.
1:57
Speaker 1: Well, hi everybody.
1:57
Speaker 4: My name is Terry Dean. I'm the director of Product
2:00
Speaker 4: Operations and Execution, and I've been with soft Writers for
2:04
Speaker 4: almost five years, so I'm just very excited to be
2:07
Speaker 4: here and talk about Framework Insight.
2:10
Speaker 3: How about that new headquarters in downtown Pittsburgh or I
2:13
Speaker 3: should say DANTWN Pittsburgh.
2:16
Speaker 1: It's nice down here.
2:17
Speaker 3: Yeah, Amanda, you're up. What are you doing over there
2:22
Speaker 3: at soft Writers?
2:24
Speaker 5: Yeah? Hi, my name is Amanda Mluli.
2:26
Speaker 4: I am the agile product owner for Framework Insight here
2:31
Speaker 4: at staff Writers. I've been here for almost three months now,
2:37
Speaker 4: so still getting my bearings. But the office is indeed beautiful,
2:43
Speaker 4: so that.
2:44
Speaker 3: Helps very much. Is it's huge. You got so much
2:49
Speaker 3: more space there. I absolutely love going down dantann to
2:52
Speaker 3: Pittsburgh and singing you guys. Today we are turning information
2:56
Speaker 3: into impact in long term care pharmacy, and I'm excited
3:01
Speaker 3: about this subject because at the Framework Innovation Conference twenty
3:05
Speaker 3: twenty five in sunny San Diego we dropped the announcement
3:10
Speaker 3: about Framework Insights, we got to be part of that
3:13
Speaker 3: press release, we got to talk about it at the
3:16
Speaker 3: Innovation conference. So now it's time to really dig into
3:20
Speaker 3: this system and this product, and I'm just going to
3:24
Speaker 3: open it up to both of you. I'm going to
3:26
Speaker 3: start out with you, Terry, and just give us a
3:29
Speaker 3: little bit of the background on intelligence and insights and
3:35
Speaker 3: how it came to be and what it is. What
3:39
Speaker 3: is this tool that can help our long term care
3:42
Speaker 3: pharmacy operators.
3:44
Speaker 4: So Framework Insight is a dashboard system. It comes with
3:49
Speaker 4: multiple dashboards the target different areas of your business operations, finance, inventory.
3:56
Speaker 4: There's some AI powered insights that give you some and
4:01
Speaker 4: kind of predictive analytics on your data. So it's a
4:05
Speaker 4: very robust reporting system that just provides a lot of
4:08
Speaker 4: additional capabilities that our other systems don't provide.
4:13
Speaker 1: So I guess how it got started. A few years ago.
4:15
Speaker 4: Our customers were telling us that, you know, they really
4:18
Speaker 4: just they didn't have the reporting that they needed. They
4:21
Speaker 4: couldn't get the data out of our systems that's the
4:23
Speaker 4: way that they wanted to So they were contracting with
4:26
Speaker 4: third party vendors or just trying to do manual reporting
4:29
Speaker 4: on their own if they happen to have you know,
4:31
Speaker 4: some talent in house with SQL servers, and so we
4:35
Speaker 4: really went to look at, well, you know, what kind
4:37
Speaker 4: of reporting do we provide today. We had an old
4:40
Speaker 4: legacy BI system that you know, customers had been using,
4:44
Speaker 4: but again we were getting feedback that it really just
4:46
Speaker 4: wasn't fitting the bill, It wasn't providing the actionable intelligence
4:50
Speaker 4: that the customers really needed. So we when we went
4:53
Speaker 4: back to the drawing board, we said, okay, well we
4:55
Speaker 4: have a few options.
4:56
Speaker 1: We can add more reporting to the systems.
4:58
Speaker 4: We can upgrade that you know, old legacy BI system
5:01
Speaker 4: to maybe add more to it, or we can just
5:04
Speaker 4: start fresh and say, you know what would be the
5:06
Speaker 4: best thing to serve all of our customers. What do
5:09
Speaker 4: they really need to have the actual insights they're really
5:13
Speaker 4: looking for. So instead we decided to start fresh, and
5:18
Speaker 4: our front end of the system is in Tableau, which
5:21
Speaker 4: is a very well known reporting system and is very
5:24
Speaker 4: capable and robust and can do a lot of different
5:26
Speaker 4: types of reporting. And one of the things that is
5:29
Speaker 4: really nice about it is that it actually does it
5:31
Speaker 4: in visualization, so charts and graphs and lots of difvergencies.
5:36
Speaker 4: You can really see trends over time. That's a lot
5:39
Speaker 4: more difficult to see in the tabular reporting that we've
5:43
Speaker 4: seen in the past and what our regular systems normally provide.
5:49
Speaker 3: I want to back up for just a second, and Amanda,
5:53
Speaker 3: when we hear long term care pharmacy, long term care pharmacy,
5:59
Speaker 3: specialty community mix compounding, so many different sections and each
6:04
Speaker 3: of them are transforming, some of them are even nishing
6:07
Speaker 3: into different components within themselves. But what makes long term
6:11
Speaker 3: care pharmacy uniquely complex compared to other those other pharmacy environments.
6:17
Speaker 5: Yeah, sure so.
6:19
Speaker 4: Prior to my role, I worked primarily with with retail
6:23
Speaker 4: community pharmacies. So working with LTC pharmacies there are very
6:31
Speaker 4: unique complexities, especially with their need to like manage payer
6:37
Speaker 4: relationships across various payers. They also have multiple facilities and
6:45
Speaker 4: and you know they handle the inventory across all different
6:49
Speaker 4: types of medication types like compounding as you had mentioned,
6:53
Speaker 4: and then also coordinating delivery logistics, So doing all of
6:58
Speaker 4: that while also maintaining their quality or compliance standards which
7:05
Speaker 4: can also differ across jurisdictions. If that applies, So that
7:10
Speaker 4: creates a lot of challenges with data. Obviously, we are
7:15
Speaker 4: in twenty twenty five, almost twenty twenty six, we have
7:19
Speaker 4: no shortage of data necessarily, But it's what you do
7:23
Speaker 4: with that data and how you transform that data into
7:27
Speaker 4: information and transform that information into knowledge that can be
7:33
Speaker 4: used to make business decisions is a whole other game.
7:39
Speaker 4: It's a very complex method of handling business or making
7:45
Speaker 4: business decisions. So yeah, BI tools aren't always built with
7:52
Speaker 4: that complexity in mind. Which is why Insight is so
7:57
Speaker 4: specific towards LTC because we really have that LTC background
8:06
Speaker 4: and data behind us.
8:10
Speaker 3: It's the absolute flavor of a long term care, pharmacy,
8:14
Speaker 3: assisted living, skilled nursing institutional environment where you're catering to
8:20
Speaker 3: the specific organization's request for their own internal operations, and
8:24
Speaker 3: they may have an EHR, they may have a specific
8:28
Speaker 3: packaging that they're using, they may have I mean, there's
8:30
Speaker 3: a multitude of things that just doesn't fit our community spaces.
8:35
Speaker 3: And I mean to tell a war story when I
8:41
Speaker 3: was part of the Softwriter's team and I was selling
8:44
Speaker 3: pharmacy management systems to organizations that were trying to get
8:49
Speaker 3: into long term care, and they were normally assisted living
8:54
Speaker 3: in light long term care. I would say they were
8:57
Speaker 3: really community having them drive things from a batch of
9:02
Speaker 3: prescriptions that were dedicated to an organization instead of dedicated
9:05
Speaker 3: to just a single patient. Because of the efficiency that
9:09
Speaker 3: that created was like it was like trying to teach
9:12
Speaker 3: Greek or Mandarin language to these operators. And so you
9:18
Speaker 3: guys really have become experts in that environment where you
9:23
Speaker 3: can tap into the power of data and the power
9:26
Speaker 3: of insights to pull some of that out to stay
9:29
Speaker 3: ahead of the operations. So you're almost does a predictive
9:33
Speaker 3: modeling esque kind of flavor per se to being able
9:37
Speaker 3: to say, hey, this is the insights, and based on
9:39
Speaker 3: these insights and these trends, here's what we can expect.
9:43
Speaker 3: And I'm wondering, you know, Terry, about the gaps and
9:47
Speaker 3: where when you look at the that across the industry,
9:51
Speaker 3: and how are most pharmacies currently using their data as
9:55
Speaker 3: is your framework insights like the Google as you put
10:00
Speaker 3: over your your eye so that you can see stuff,
10:03
Speaker 3: but it's it's those organizations that don't have those goggles.
10:07
Speaker 3: So how are most pharmacies using data to try to
10:10
Speaker 3: map the next steps?
10:12
Speaker 4: Yeah, I think the way you phrased it, with you know,
10:14
Speaker 4: being able to use goggles to see everything together. And
10:17
Speaker 4: insight is a great example because the customers that aren't
10:21
Speaker 4: using that tool, and they are using, you know, either
10:24
Speaker 4: their own customer reporting or things they've done on their own,
10:28
Speaker 4: it's all piecemeal. They can see certain pieces of data
10:32
Speaker 4: at certain times. It's kind of like you have to
10:34
Speaker 4: look at this thing here, then you look over there,
10:37
Speaker 4: and then you look over here, and then you're trying
10:39
Speaker 4: to piece it all together in your mind and you're saying, well,
10:42
Speaker 4: this is what you know, my inventory manager needs, and
10:46
Speaker 4: this is what my operational folks needs, and this is
10:48
Speaker 4: what our billing and finance folks needs.
10:50
Speaker 1: But as a you know, as a leader, I want
10:51
Speaker 1: to see it all together.
10:52
Speaker 4: I want to see everything for my business, and that's
10:56
Speaker 4: extremely difficult to do without framework insight. I think one
10:59
Speaker 4: of the things that our dashboards are able to include
11:03
Speaker 4: a lot of data from different areas of the system
11:05
Speaker 4: and pull it together in a singular view so that
11:07
Speaker 4: you can just see everything.
11:08
Speaker 3: Together and you're able to analyze that data with confidence
11:11
Speaker 3: and you're able to rely on it for specific reporting
11:14
Speaker 3: extraction of data because your CFO wants to see something
11:18
Speaker 3: different than your workflow manager does or your technician data
11:24
Speaker 3: entry team, and you could really split it up into
11:27
Speaker 3: categories and really start to hone in on how do
11:30
Speaker 3: we make this operation more effective and more efficient? And
11:35
Speaker 3: I think that's exactly what Framework Insight is doing. And
11:39
Speaker 3: so I'm talking about that business intelligence and why that
11:43
Speaker 3: matters now, And it's now more than ever. It's harder
11:47
Speaker 3: to run a pharmacy in so many ways today than
11:51
Speaker 3: it was twenty years ago because of the complexity and
11:54
Speaker 3: because of reimbursement and the sensitivity around that. So when
11:59
Speaker 3: we're talking about business intelligence, you know why why is
12:05
Speaker 3: it so important now for long term care pharmacies to
12:08
Speaker 3: have access to those insights into that data.
12:11
Speaker 4: The things that our customers are facing that you know,
12:15
Speaker 4: really good data and insights can can at least help
12:18
Speaker 4: you manage through. So there, as you brought up the reimbursements,
12:24
Speaker 4: the IRA MFP that's coming down next year, and then
12:27
Speaker 4: it's going to pile on in twenty seven and it's
12:30
Speaker 4: just going to keep going. These our big implications for
12:34
Speaker 4: our customers, their cash flow and just how they manage
12:37
Speaker 4: their business. They need to be able to see the
12:40
Speaker 4: data they need to be able to work with the data,
12:42
Speaker 4: make actionable decisions based on that data, and then come
12:46
Speaker 4: back in a.
12:46
Speaker 1: Day or so and say, oh, yeah.
12:48
Speaker 4: Those changes that I implemented like they made a difference
12:51
Speaker 4: and I can see them here or there.
12:55
Speaker 1: So, whether it's tracking.
12:56
Speaker 4: Your reimbursements or tracking you know which drugs are being
13:01
Speaker 4: dispensed and how you can you know, help their patients
13:05
Speaker 4: figure out, you know, which medications can be helpful for
13:09
Speaker 4: the patient and be helpful for the pharmacy at the
13:12
Speaker 4: same time. What are the other challenges that our customers face.
13:15
Speaker 4: Is staffing challenges there, you know, aren't It's very hard
13:19
Speaker 4: to find good people and keep them and maintain them.
13:22
Speaker 4: So one thing that the tool does is it really
13:26
Speaker 4: helps to analyze staffing and you know when you have
13:31
Speaker 4: your staff in place, who is there and when they're there,
13:34
Speaker 4: to know how much work they're doing. So if you
13:37
Speaker 4: can see that your volume of prescriptions is very high
13:39
Speaker 4: at nine am and you need to have more of
13:42
Speaker 4: your texts and that you know in their seeds at
13:45
Speaker 4: that time, then you can figure out, you know, how
13:47
Speaker 4: do you want to float your staff throughout the day
13:49
Speaker 4: to handle the workload that's coming in.
13:56
Speaker 3: Amanda, I want to shift gears for just a second
13:58
Speaker 3: and really talk about some character wristics of effective BI
14:03
Speaker 3: and what that means from the listener's perspective too, What
14:06
Speaker 3: separates just data from true decisions to support that decision
14:12
Speaker 3: support based on maybe the category, maybe the department. So
14:17
Speaker 3: can you explain that to the listeners?
14:19
Speaker 5: Yeah, for sure.
14:22
Speaker 4: To me, I think the effective BI should be built
14:26
Speaker 4: for the specific industry or the specific customer that is
14:31
Speaker 4: using it. So in our case for LTC pharmacy, that
14:36
Speaker 4: means dashboards and metrics designed around staff productivity or inventory
14:43
Speaker 4: management and not just charts or visualizations to customize and
14:50
Speaker 4: obtain information from the box. You know, in a box
14:55
Speaker 4: package may may provide some information for pharmacies to build
15:03
Speaker 4: off of, but it wouldn't be as personalized or you know,
15:08
Speaker 4: specific to the industry that they're in. So a good
15:13
Speaker 4: BI tool presents opportunities and not just numbers and figures.
15:18
Speaker 5: Like Terry had mentioned, the AI.
15:21
Speaker 4: Tablet Pulse is incredibly helpful to help understand why something
15:27
Speaker 4: is happening rather than just showing the charts, and for
15:31
Speaker 4: decision support that requires business contacts. So having years of
15:37
Speaker 4: historical data integrated so you can see trends or understanding
15:43
Speaker 4: different seasons or different quarters of the business, and to
15:49
Speaker 4: benchmark the performance over time. So for example, you know,
15:53
Speaker 4: maybe there was a I don't know, an operational change
15:58
Speaker 4: that a pharmacy has made. To know if that really
16:01
Speaker 4: worked or didn't work, you probably want to go about
16:04
Speaker 4: it in a scientific way and be able to test
16:07
Speaker 4: to see if it worked.
16:08
Speaker 5: But in order to do so, having those metrics and
16:11
Speaker 5: those numbers is.
16:13
Speaker 4: Incredibly helpful for actually knowing if what you're doing is working.
16:19
Speaker 5: And that's kind of what decision support is. Kind of
16:24
Speaker 5: the point of.
16:24
Speaker 4: It is to anticipate the questions that you need to
16:27
Speaker 4: ask and help you maybe communicate those findings and then
16:32
Speaker 4: also dig deeper if you do catch something that might
16:36
Speaker 4: be an anomaly or a reason behind something that took place.
16:46
Speaker 6: Terry.
16:46
Speaker 3: When I bring on a new system, I'm converting from
16:52
Speaker 3: one software to the next. I take on Framework LTC,
16:57
Speaker 3: my implementation happens, I get my training, start to build
17:01
Speaker 3: my workflow. When does Framework in Sight put the we
17:07
Speaker 3: said goggles And it's kind of what I'm thinking of.
17:09
Speaker 3: When when do we put those on? And what difference.
17:13
Speaker 3: Does that truly make to a pharmacy operations that is
17:19
Speaker 3: desperate for those kinds of insights and being able to
17:22
Speaker 3: really map what's happening in their operation.
17:26
Speaker 1: Yeah.
17:26
Speaker 4: Actually, one of our early adopts part of our beta
17:30
Speaker 4: testing program was a brand new pharmacy that was just starting,
17:34
Speaker 4: so they had just on board with Framework LTC and
17:37
Speaker 4: they were ready to just jump in with Framework Insights.
17:40
Speaker 4: I think they were running for about a month before
17:43
Speaker 4: we installed with them, and.
17:46
Speaker 1: You know, I think they really benefited from the system.
17:49
Speaker 4: They stayed with it, and they were able to really
17:52
Speaker 4: track the trends of you know, how was the business performing,
17:56
Speaker 4: particularly in the early days when they maybe had to
18:00
Speaker 4: ramp up and scale up as more facilities were coming
18:03
Speaker 4: on board and they were adopting, you know, more patients
18:07
Speaker 4: and more medications coming in. They were able to track
18:11
Speaker 4: those trends and see them and anticipate what was going
18:14
Speaker 4: to come.
18:16
Speaker 3: I love that because those kinds of insights will give
18:21
Speaker 3: operators an opportunity to stay ahead and start digging down
18:26
Speaker 3: into what trips them up as not only a facilitator
18:30
Speaker 3: of medication management, but also looking to the future for
18:35
Speaker 3: drug shortages or price pricing opportunities to save money, or
18:41
Speaker 3: or a flagging of a of an instant of an organization,
18:47
Speaker 3: of a long term care facility that might not have
18:51
Speaker 3: the insights that the pharmacy does, and that makes the
18:53
Speaker 3: pharmacy more of a partner to that organization, to that
18:57
Speaker 3: assisted living center because now you're giving them insights. That's
19:02
Speaker 3: actually something that I didn't even think of until now
19:05
Speaker 3: that you said that, Terry. But are are there any
19:08
Speaker 3: data reporting that you can pull from Framework LTC via
19:12
Speaker 3: Framework Insight and share that with with your facilities and
19:16
Speaker 3: with the people that you're serving.
19:18
Speaker 1: Yeah, that's a great question. Actually, it came up quite
19:21
Speaker 1: a bit from our customers.
19:22
Speaker 4: In the early design phases and during beta testing. But
19:27
Speaker 4: we do have a facility focused dashboard. Now, many of
19:30
Speaker 4: our dashboards you can filter down to a specific facility
19:33
Speaker 4: and maybe you'd want to talk over that data with them,
19:36
Speaker 4: but we also have a facility specific dashboard. We're really
19:39
Speaker 4: trying to include, you know, what are your highest drug costs,
19:43
Speaker 4: what are the drugs that are being dispensed the most,
19:46
Speaker 4: or what are your highest cost patients.
19:49
Speaker 1: So there's a lot of.
19:50
Speaker 4: Different insights that you could have specific on that facility dashboard,
19:54
Speaker 4: and then you can export the report, so say you know,
19:57
Speaker 4: you export it to PDF, you take it to your
19:59
Speaker 4: next meeting with that facility and you can really go
20:01
Speaker 4: over all of the details with them or send it
20:03
Speaker 4: to them on a regular basis if you want to.
20:06
Speaker 3: So, how has the system evolved, Amanda? Because I remember
20:11
Speaker 3: report building out of a Seql server was so novel,
20:15
Speaker 3: so new, and sometimes you had to know even how
20:19
Speaker 3: even yourself users framework LTC users had to know how
20:22
Speaker 3: to write these themselves in order to extract the data.
20:25
Speaker 3: But now we have framework Insight to do it. So
20:29
Speaker 3: how has the original version of framework Insight? How has
20:33
Speaker 3: that all evolved?
20:34
Speaker 6: Yeah?
20:34
Speaker 4: Yeah, so when I came in a few months ago,
20:39
Speaker 4: can't believe there has only been a few months. But
20:42
Speaker 4: we had plenty of ideas to work off of from
20:46
Speaker 4: beta testers, from internal users, all types of feedback and ideas,
20:52
Speaker 4: which is kind of the dream in product, but also
20:56
Speaker 4: something to weed through which can be kind of tedious.
20:59
Speaker 4: But you know, our beta testers had one major complaint
21:08
Speaker 4: in common, being kind of more of like the loading
21:12
Speaker 4: times or you know how slow maybe it took to
21:18
Speaker 4: load up the dashboard. So you know, we could have
21:22
Speaker 4: pushed through with some new features and big pretty charts
21:29
Speaker 4: and different diagrams of different things, but we instead kind
21:34
Speaker 4: of shifted gears and took a step back and said, well, okay,
21:39
Speaker 4: if if that is the main concern across pretty much everyone,
21:45
Speaker 4: maybe that that should be our first priority moving into
21:50
Speaker 4: our next release. Because what good is having, you know,
21:56
Speaker 4: fifty or more charts or metrics if they can't use
22:00
Speaker 4: them efficiently or work them into their daily work workflow because.
22:06
Speaker 5: It's taking too long to load.
22:08
Speaker 4: So that experience was kind of more of a lesson
22:12
Speaker 4: in product overall for me, which is not always about
22:16
Speaker 4: what just looks great and what is interesting and cool,
22:21
Speaker 4: but also what actually the customers are asking for and
22:26
Speaker 4: what they actually want.
22:27
Speaker 5: In their real world environments.
22:31
Speaker 4: So we kind of had to sacrifice where of course
22:35
Speaker 4: still doing those cool, great things, but to make that progress,
22:40
Speaker 4: we wanted to maintain or improve our back end as well,
22:44
Speaker 4: so that it can be robust and so that we
22:47
Speaker 4: can handle the bigger items. And that's kind of become
22:51
Speaker 4: our guiding principle is kind of continuous improvement based on
22:57
Speaker 4: how our customers are using the the product and not
23:01
Speaker 4: just making assumptions on what they need, and so that's
23:05
Speaker 4: why we're taking an approach where the pharmacy input really
23:09
Speaker 4: shapes what we do and how we move forward with
23:13
Speaker 4: our roadmap.
23:16
Speaker 3: I love that and I've seen it work because Softwriters
23:20
Speaker 3: through an artificial intelligence assemblance of very hand picked clients
23:26
Speaker 3: and customers to come together to talk about the future
23:29
Speaker 3: of AI and long term care pharmacy, which could be
23:32
Speaker 3: another podcast we could do for sure. And with that,
23:38
Speaker 3: I want to just throw this over to Terry and
23:43
Speaker 3: demonstrate that how does your clients bring you real world
23:48
Speaker 3: issues that they're facing in their workflow and their business.
23:53
Speaker 3: How does that shape the products? How does it shape
23:57
Speaker 3: our existing product framework insight? But how's it how's it
24:00
Speaker 3: shaped for what's to come?
24:02
Speaker 4: Yeah, we we rely on that information quite heavily. So
24:06
Speaker 4: Framework Spark is our ideas portal and we make use
24:11
Speaker 4: of that across the product suite. So anyone can get
24:15
Speaker 4: access to framework Spark that it's one of our customers.
24:18
Speaker 4: You can go in there and you can take a
24:19
Speaker 4: look at the different ideas across the products. You can
24:23
Speaker 4: enter new ones, you can upvote the ones that are existing,
24:26
Speaker 4: and we really you know, use those votes to see
24:29
Speaker 4: the things that are going to have the widest reach
24:33
Speaker 4: and the based impact on our customers, so that we
24:37
Speaker 4: can help to rank things to say okay, in our
24:39
Speaker 4: next release, We're going to have to choose, but we
24:41
Speaker 4: want to choose the things that are most important to
24:43
Speaker 4: our customers. Between what we're getting feedback on and framework spark,
24:47
Speaker 4: what we hear from our customers at events that we
24:49
Speaker 4: go to, we hold focus group meetings. I know, you know,
24:52
Speaker 4: Amanda was looking at a new dashboard that we're looking
24:55
Speaker 4: to release and some updates to the filtering, and she's
24:58
Speaker 4: already starting to pull things together to to meet with
25:00
Speaker 4: customers and go over them and get more feedback. So
25:03
Speaker 4: we take all of that information and synthesize it together
25:06
Speaker 4: to really be able to pick the most high value
25:08
Speaker 4: things that we can add to the system, even when
25:10
Speaker 4: it's back.
25:12
Speaker 1: In things that aren't flashy and fun. Like Amanda was
25:14
Speaker 1: talking about that there are.
25:16
Speaker 4: Things that need done that people want that you know,
25:19
Speaker 4: we get in our list and we get it done.
25:23
Speaker 1: I think one of the best feedback.
25:24
Speaker 4: We got from our beta testers or that as soon
25:26
Speaker 4: as they told us something, by the time we met
25:28
Speaker 4: with them next time, we had it addressed and we
25:30
Speaker 4: had it fixed or we had something else for them
25:32
Speaker 4: to look at. And that's the you know, that's the
25:35
Speaker 4: best result you can get from a beta testing or
25:38
Speaker 4: alpha testing program is to get that feedback into people
25:41
Speaker 4: that are on the other end, to really feel heard
25:43
Speaker 4: and really feel that we're responsive to what they're asking
25:46
Speaker 4: us for.
25:47
Speaker 3: All Right, Demanda, I'm going to put you on the spot.
25:50
Speaker 3: Give us the top three most popular reports or components
25:56
Speaker 3: of Framework insight based on customer feedback.
26:02
Speaker 4: Yeah, so I know one for certain, which is our
26:06
Speaker 4: staff productivity. For sure, that is probably one of the
26:13
Speaker 4: bigger items that we've gotten feedback from, just because that
26:18
Speaker 4: is something that pharmacies can use to to visualize a
26:22
Speaker 4: workflow on a much more granular scale than than what
26:26
Speaker 4: they could be able to see and say, you know,
26:29
Speaker 4: the reporting in framework or even just the pharmacy productivity.
26:34
Speaker 5: Another item that.
26:35
Speaker 4: Is heavily asked about, and we are kind of in
26:40
Speaker 4: the works of building is quality events. So an ability
26:46
Speaker 4: for pharmacies to visualize their quality events that they put
26:49
Speaker 4: into LTC. So that is a type of report that
26:55
Speaker 4: isn't readily available right out of LTC. So we're really
27:00
Speaker 4: excited to be able to bring that to them in
27:02
Speaker 4: a visualization. And then in addition, I would say the
27:09
Speaker 4: last one would probably be the financial dashboard, just because
27:13
Speaker 4: of how there's a lot on that particular dashboard. I
27:17
Speaker 4: believe they are about eight different data sources. Terry could
27:21
Speaker 4: correct me on that one, but lots of very specific
27:27
Speaker 4: financial information which at the very root of a lot
27:31
Speaker 4: of operational usage of insight. That that's kind of what
27:35
Speaker 4: they are often also looking for, is the financial impact
27:39
Speaker 4: of all of this.
27:41
Speaker 5: So yeah, in addition to that, though.
27:44
Speaker 4: We are also building new filters to add on so
27:48
Speaker 4: that they can even drill down even further into each
27:52
Speaker 4: of the each of the dashboards.
27:54
Speaker 3: Follow up bonus question goes to Terry, and that is,
27:58
Speaker 3: I think of the CFO, I think of the accountant.
28:02
Speaker 3: I think of the people who might not be as
28:07
Speaker 3: integrated into the clinical or the workflow or necessarily the operations,
28:12
Speaker 3: but they're really dialing into profitability. They're dialing into opportunities
28:19
Speaker 3: in the future to potentially save some money. They're looking
28:24
Speaker 3: back to their wholesale reports and their secondaries and just
28:27
Speaker 3: all of that pure financial data. What feedback have you
28:31
Speaker 3: gotten from like the CFO slash CPA type about framework insight,
28:36
Speaker 3: we really didn't.
28:37
Speaker 4: Get any requests for more data to be added. I mean,
28:39
Speaker 4: it includes your claims data, It includes your profit margin,
28:43
Speaker 4: your revenue, your costs.
28:45
Speaker 1: It pulls everything together.
28:46
Speaker 4: And that's why Amanda was saying, I had so many
28:48
Speaker 4: data sources on it, because we're really looking across the
28:51
Speaker 4: entire system and pulling everything in together for a single view.
28:54
Speaker 4: We also have some of that information in Tableau Pulse,
28:58
Speaker 4: and we also got feedback from there that that was
29:01
Speaker 4: really helpful because it's providing those summaries on why things changed,
29:05
Speaker 4: so it can pull out very easily and show you
29:07
Speaker 4: where are your outliers, where are the things that you
29:09
Speaker 4: know caused it changed in the past thirty days that
29:12
Speaker 4: you might not even realize was causing a change, you know,
29:16
Speaker 4: one direction or another. And you're also able to set
29:19
Speaker 4: goals and thresholds. So if you say, you know, we
29:21
Speaker 4: want our you know, profit margins to be at ten percent,
29:27
Speaker 4: you know, I mean that's a very high number, but
29:30
Speaker 4: maybe they want them there and they want to set
29:32
Speaker 4: that goal for a certain date, and then tablet Pulse
29:34
Speaker 4: can send you messages you know, daily or weekly and
29:38
Speaker 4: give you updates on how close you're getting or if
29:39
Speaker 4: something's happening and you're you know, regressing or going a
29:42
Speaker 4: different direction, and then you'll be able to have those
29:44
Speaker 4: alerts on a regular basis.
29:46
Speaker 3: There's mentioned at Framework ltc dot com forward slash Framework Insight,
29:52
Speaker 3: and we'll have that link in the show notes. There's
29:55
Speaker 3: mention of five specific dashboards. Could you give us exams,
30:00
Speaker 3: amples and little testimony of each of the five.
30:04
Speaker 4: So we have our Pharmacy Operations dashboard and that does
30:08
Speaker 4: pretty much what the title says, it's giving you all
30:10
Speaker 4: of your operational data. It includes some ECM data as
30:13
Speaker 4: well as Framework LTC and really looking at your patterns
30:17
Speaker 4: of dispensing and filling orders. We have the Facility dashboard
30:23
Speaker 4: that we talked about earlier that's really facility focused. You
30:25
Speaker 4: can filter it down to a specific facility and really
30:29
Speaker 4: see the what they're ordering, how often you're delivering to them, what.
30:37
Speaker 1: Drugs are being used by their patients.
30:39
Speaker 4: And then after facility, we have the inventory dashboard. And
30:43
Speaker 4: the inventory dashboards is actually split into two so you
30:46
Speaker 4: can see your fast movers and you can see anything
30:51
Speaker 4: that's missing refills or missing missing other data points that
30:57
Speaker 4: really should be in this system, you can also see
31:01
Speaker 4: when your orders are coming in for inventory and your
31:05
Speaker 4: costs of course related to inventory, an they adjustments that
31:08
Speaker 4: you're making. And now also of inventory, we have this
31:12
Speaker 4: staff productivity that Amanda was talking about, and that provides
31:16
Speaker 4: some high level workflow or reviews to see. You can
31:20
Speaker 4: select a set of prescriptions and what steps in the workflow,
31:24
Speaker 4: who touched it, how long did it take? And then
31:27
Speaker 4: you can also drill down to specific parts of the workflow.
31:31
Speaker 4: You can say, okay, I want to see everyone in
31:32
Speaker 4: order entry and what they were doing.
31:34
Speaker 1: You can see their work by day or by hour.
31:37
Speaker 4: And then the finance dashboard which has all of your
31:40
Speaker 4: financial information from across the system.
31:43
Speaker 3: That's cool. Yes, so we have all five. We have
31:49
Speaker 3: five we have inventory, staff, and finance. And when I
31:55
Speaker 3: think of those five, I want to turn it over
31:58
Speaker 3: to Amanda. And that is you know, just you've been
32:02
Speaker 3: there a while, You've experienced this, you've looked into it,
32:05
Speaker 3: You've spent time with clients and customers using this system.
32:08
Speaker 3: In your own words, what makes Framework Insight uniquely valuable
32:13
Speaker 3: to that long term care pharmacy operations specifically?
32:18
Speaker 4: Yeah, So, as I mentioned previously, a good bi tool
32:22
Speaker 4: is going to be industry specific. In this case, it's
32:26
Speaker 4: LTC specific, right. What's more important, even more important than that,
32:34
Speaker 4: is that our approach to building this tool is completely
32:42
Speaker 4: customer based, so customer focused, customer centric, maybe all of
32:48
Speaker 4: the above, but we're not the ones necessarily dictating what
32:52
Speaker 4: comes next. We're the ones building with the pharmacy through
32:59
Speaker 4: maybe frameworks spark. My my role here is not to
33:04
Speaker 4: necessarily be the expert in LTC. We we don't need
33:10
Speaker 4: that in me necessarily, I we What we do need is,
33:15
Speaker 4: you know, completely customer focused. They're the experts in LTC
33:20
Speaker 4: and everything framework and they're the ones who can absolutely
33:25
Speaker 4: dictate what happens next with with this particular product.
33:30
Speaker 1: This is entirely.
33:31
Speaker 4: Built with them in mind, and to assist with any
33:36
Speaker 4: operational or even policy Like Terry had mentioned with the
33:44
Speaker 4: i RA and uh m f P, those are all
33:48
Speaker 4: things that we've we've considered and will constantly evaluate. So
33:55
Speaker 4: really any feedback is valuable, good and bad. We take
34:00
Speaker 4: it all into account and use that to improve constantly.
34:07
Speaker 3: Terry and Amanda, this has been a really good deep
34:11
Speaker 3: dive into framework insight and for listeners, if you're curious.
34:17
Speaker 3: You're running a long term care of pharmacy, you want
34:22
Speaker 3: to expand you might want to take on additional skilled nursing.
34:26
Speaker 3: You want to understand how is this system going to
34:30
Speaker 3: impact my operation, my profitability. Reach out to this team
34:34
Speaker 3: and ask those questions. Take time to go through a
34:38
Speaker 3: specific demo of the Framework Insight and be able to
34:42
Speaker 3: extract specific data that you'd like to see that you
34:45
Speaker 3: might not be receiving from your existing pharmacy management system.
34:49
Speaker 3: And that's okay, it doesn't. We will never have everything
34:53
Speaker 3: that's perfect. But we have to know about our data.
34:56
Speaker 3: We have to know how to splice it. We know
34:59
Speaker 3: have to know how to let beverage it in order
35:01
Speaker 3: to become profitable enough to keep moving forward because the
35:08
Speaker 3: baby boomers haven't we haven't even reached the top of
35:12
Speaker 3: the mountain yet, and how many baby boomers there are
35:16
Speaker 3: out in the United States, and so we desperately need
35:19
Speaker 3: long term care pharmacy expansion. You have to be profitable
35:23
Speaker 3: in order to completely have that opportunity for expansion. Amanda,
35:29
Speaker 3: thank you so much for being on Framework Focus, and Terry,
35:33
Speaker 3: thank you so much for your participation as well.
35:37
Speaker 4: Absolutely thanks for having us it's great to get to
35:39
Speaker 4: introduce Amanda to everybody, so she finally gets.
35:42
Speaker 1: To meet everyone.
35:43
Speaker 3: Right, Amanda is now on the pods. When you're on
35:46
Speaker 3: the pods, you are officially official.
35:50
Speaker 5: I've made it.
35:51
Speaker 3: You were listening to Framework Focus, a softwriter's podcast. I'm Todd.
35:57
Speaker 3: You're a host of the Pharmacy podcast Network. Thank you
36:00
Speaker 3: for listening. Once again. Take a look Framework LTC dot
36:05
Speaker 3: com forward slash Framework Insight schedule demo and look at
36:10
Speaker 3: it for yourself and give us your feedback. Send it
36:13
Speaker 3: to us. We're ready to ready to explore, ready to
36:17
Speaker 3: do more. In twenty twenty six.
36:21
Speaker 2: We just heard some great conversation from Terry and Amanda
36:24
Speaker 2: about why real time accessible data matters so much and
36:27
Speaker 2: long term care pharmacy and how that thinking ultimately shaped
36:30
Speaker 2: Framework Insight. Now we're going to shift to a segment
36:34
Speaker 2: from this year's Framework LTC Innovation Conference. In this clip,
36:37
Speaker 2: you'll hear Terry speaking with Michael Battler from Phoebe Pharmacy
36:40
Speaker 2: about their experience with Framework Insight.
36:46
Speaker 7: I think we really appreciated the filtering capability of the system.
36:50
Speaker 7: I think that we know it started out with a
36:54
Speaker 7: few data sets that we could filter by and then
36:56
Speaker 7: I think you've added more, and I know that there's
36:57
Speaker 7: more coming in the works, and I think a redesigned there.
37:00
Speaker 6: I think that just allows.
37:01
Speaker 7: You to really do a great comparison across your communities,
37:04
Speaker 7: across your staff members. It really does let you drill
37:07
Speaker 7: down into the data that really will help you shape
37:10
Speaker 7: your workforce.
37:12
Speaker 4: How does the filtering, do you think like compare to
37:15
Speaker 4: other tools that you've used.
37:17
Speaker 6: I think it went very easily.
37:18
Speaker 7: The thing I liked is it allows you to include
37:21
Speaker 7: or exclude at the same time. So to me, being
37:23
Speaker 7: able to do that right from the start, like you know,
37:25
Speaker 7: when you're going into the bar chart that you're looking at,
37:28
Speaker 7: you know you may want to keep something out because
37:30
Speaker 7: it's not it doesn't match up apples to apples.
37:32
Speaker 6: So being able to do.
37:33
Speaker 7: That, and then once we had the facility groups, which
37:36
Speaker 7: I think we utilize I think a lot of other
37:38
Speaker 7: pharmacies utilize, you'll be able to really kind of dig
37:40
Speaker 7: down into comparing them very well.
37:45
Speaker 4: So after you're in the program for a little while,
37:47
Speaker 4: like or maybe from the beginning, what gave you confidence
37:50
Speaker 4: that this was going in the right direction, that we
37:52
Speaker 4: were doing the right thing.
37:53
Speaker 7: I think one of the data made sense to us,
37:56
Speaker 7: I think when we first loaded it, being that we
37:58
Speaker 7: had four pharmacies and we are one of the pharmacies
38:00
Speaker 7: that has four pharmacies that are doing business as the
38:03
Speaker 7: exact same name, which always trips up soft Writers and Framework.
38:07
Speaker 7: So once we got that figured out, it really.
38:10
Speaker 6: Was seeing that.
38:13
Speaker 7: Any feedback we gave was really being worked on in
38:16
Speaker 7: a timely manner, so it wasn't something that we had
38:18
Speaker 7: to wait months for a solution.
38:19
Speaker 6: It was days to weeks.
38:21
Speaker 4: Yeah, I think that really highlights the benefits of it
38:24
Speaker 4: being a software as a service solution where we can
38:26
Speaker 4: quickly iterate on things and get it back out to
38:28
Speaker 4: the customers and a more reasonable amount of time, which
38:32
Speaker 4: is great.
38:34
Speaker 1: Those faster iteration cycles.
38:36
Speaker 4: Do you think they made you more willing to give
38:39
Speaker 4: feedback or to report issues than in the past.
38:41
Speaker 6: Yes.
38:43
Speaker 7: Being an eighteen year customer of Framework, I know in
38:45
Speaker 7: the past there's things that I just live with and
38:47
Speaker 7: I don't submit them anymore because it's they're not going
38:50
Speaker 7: to get fixed, and I know that's LALTC. But so
38:53
Speaker 7: knowing that our feedback really was handled and addressed that
38:56
Speaker 7: quickly made me more willing to send even the little
38:59
Speaker 7: thing that may not take up too much of your time,
39:02
Speaker 7: but it's just one step closer to being a more
39:05
Speaker 7: complete product.
39:06
Speaker 4: Yeah, that's good feedback, all right, So let's talk about
39:11
Speaker 4: the user experience side. How did it compare to what
39:15
Speaker 4: you were expecting over.
39:17
Speaker 7: So, I think that it had everything that we were
39:18
Speaker 7: we were hoping for. So I think when we first
39:22
Speaker 7: got it initially, that very first couple of weeks, I
39:25
Speaker 7: think we wished it had been a little bit faster,
39:27
Speaker 7: and it.
39:27
Speaker 6: Has gotten faster.
39:28
Speaker 7: But I also know that they're pulling in at a
39:30
Speaker 7: lot of data points. But it really was comparable and.
39:35
Speaker 6: Far exceeding what we had previously used in the past.
39:38
Speaker 4: So can you think of anything that was surprising, either
39:41
Speaker 4: good or maybe not so great.
39:45
Speaker 7: I think obviously you mentioned about the the staff productivity,
39:50
Speaker 7: So I think that to us having the bar charts
39:52
Speaker 7: looking that we could filter down to the staff member
39:55
Speaker 7: or at the job title in framework LTC really did
39:59
Speaker 7: help us to see some weak spots in our system.
40:01
Speaker 7: Let us know like, Okay, well we're really good at
40:04
Speaker 7: entering the product and we're really good at filling it.
40:06
Speaker 7: But there's a final review piece that's taking way too
40:08
Speaker 7: long between the other two steps, so we really could
40:11
Speaker 7: kind of see what was happening throughout the pharmacy, So
40:13
Speaker 7: that was that was helpful.
40:15
Speaker 4: Yeah, So for the for the audience, the screens that
40:18
Speaker 4: you're looking at the pharmacy productivity at the top corner
40:22
Speaker 4: is really showing you the team wide in each of
40:24
Speaker 4: the workflow steps. Well, the one on the bottom is
40:26
Speaker 4: doing more of the individual staff members where you can
40:30
Speaker 4: see by day and by hour, And originally we really
40:33
Speaker 4: hadn't anticipated y'all asking so hard for the by day
40:37
Speaker 4: and by hour and individuals and workflow steps. So I
40:41
Speaker 4: think that was surprising from our perspective, and I'm glad
40:45
Speaker 4: that we were able to iterate on it and give
40:46
Speaker 4: you that. How would you say that your team's comfort
40:49
Speaker 4: level evolved over time with the product? Did they have
40:51
Speaker 4: any challenges getting up to speed?
40:54
Speaker 7: I think at the beginning there was a few staff
40:56
Speaker 7: members that definitely had some some challenges and just couldn't
40:58
Speaker 7: quite understand the data. But we kind of did a
41:01
Speaker 7: train the trainer model, so I kind of took that
41:03
Speaker 7: part of it on and then made sure that I
41:05
Speaker 7: took it back to.
41:06
Speaker 6: The team and could show them.
41:08
Speaker 7: We use teams, so that was the easiest way to
41:09
Speaker 7: just kind of show them what they were doing wrong
41:11
Speaker 7: and how to get it. And then the next part
41:13
Speaker 7: is the dashboards and everything has a reset button, so
41:15
Speaker 7: if you filter it down too far and realize like,
41:16
Speaker 7: oh I didn't I don't quite remember where I started,
41:18
Speaker 7: what I've done, you can hit the reset and kind
41:20
Speaker 7: of get it back to the base settings.
41:24
Speaker 4: What would you say were the most common questions that
41:26
Speaker 4: you got about the system.
41:28
Speaker 7: I think the biggest thing was just is a state accurate?
41:33
Speaker 7: They were like, yes, you can confirm it, you can
41:36
Speaker 7: click on it. It does give you some detail on
41:38
Speaker 7: the data of where it's pulling from, depending on what
41:41
Speaker 7: piece of it you're in, But I think that was
41:43
Speaker 7: probably the number one.
41:44
Speaker 6: Was like, this is like true data. We can trust this,
41:47
Speaker 6: and said.
41:47
Speaker 4: Yes, yeah, trust all day here. Yeah. So this little
41:52
Speaker 4: I don't know if you can see it well, but
41:53
Speaker 4: there's these little info buttons on each of the charts,
41:55
Speaker 4: so you can hover over those and they'll give you
41:57
Speaker 4: detail about where the data is coming from. We also
42:00
Speaker 4: have the usual user guides, but it's nice that it's
42:03
Speaker 4: actually built into the system and you don't have to
42:05
Speaker 4: navigate anywhere else to figure out what that data is.
42:11
Speaker 4: So let's talk about like a typical day in the life, right,
42:14
Speaker 4: So give us like a Tuesday morning.
42:17
Speaker 3: How do you use this system?
42:18
Speaker 6: What does your day look like? Yeah, so we talked
42:20
Speaker 6: about a little bit about the speed.
42:21
Speaker 7: So when you first open it up, it is going
42:23
Speaker 7: to be kind of uploading all that information, So you're
42:25
Speaker 7: going to want to start that process. And I usually
42:27
Speaker 7: go make my coffee and I come back and by
42:29
Speaker 7: the time I'm back, it's ready to go. And the
42:32
Speaker 7: next part is I get triggered by Tableau Pulse. So
42:34
Speaker 7: you can set up Tableau Pulse to send your data
42:36
Speaker 7: on a daily, weekly, or monthly timeframe. So typically on
42:43
Speaker 7: Monday or Tuesday, we were getting that Tableau Pulse report
42:45
Speaker 7: and then that's when we as a team kind of
42:47
Speaker 7: looked at the data at that time.
42:49
Speaker 4: All right, well, yeah, let's dig into Tableau Pulse a
42:52
Speaker 4: little bit. So I think that's different than the normal
42:55
Speaker 4: dashboard thing that people.
42:56
Speaker 1: Are used to.
42:58
Speaker 4: So, for for anyone in the audience that has never
43:00
Speaker 4: used Tableau poles before, how would you describe the difference
43:03
Speaker 4: between these metrics versus what you see in the dash board.
43:06
Speaker 7: So I think the tablet pulse really is like your
43:08
Speaker 7: trend line, so you can really see quickly what is
43:10
Speaker 7: going on in your pharmacy. You can really see that
43:12
Speaker 7: average full time. You can kind of see where that's
43:14
Speaker 7: at and where it's compared to. You can also set metrics,
43:17
Speaker 7: so if you want to set a goal for your team,
43:19
Speaker 7: you can do that.
43:19
Speaker 6: In the system.
43:21
Speaker 7: We're post consumption, so some of the Tableau pulse fields
43:24
Speaker 7: didn't really apply to us because we don't build all
43:27
Speaker 7: of our prescriptions or cycle prescriptions don't get built to
43:30
Speaker 7: the next month, so if you're looking at a month
43:32
Speaker 7: to date view or previous week, it may not be
43:35
Speaker 7: as accurate in that sense, but we definitely found some
43:38
Speaker 7: of them very useful.
43:40
Speaker 4: All Right, do you feel like it's better for like
43:42
Speaker 4: a quick check versus a deep analysis?
43:45
Speaker 6: Yeah?
43:45
Speaker 7: I think to me, it kind of it kind of
43:47
Speaker 7: lets you know exactly what you probably already do know,
43:50
Speaker 7: but it confirms that the data is there that like, yeah,
43:53
Speaker 7: I think we were a little slow in getting deliveries
43:55
Speaker 7: out and you can kind of see that average full
43:57
Speaker 7: time being something that you can see it trend up
44:00
Speaker 7: in that way. Then you can kind of be a
44:01
Speaker 7: little bit more proactive in that regard and make sure
44:04
Speaker 7: that the next day you're kind of seeing that trend
44:06
Speaker 7: line go back down.
44:07
Speaker 4: Did you notice any changes in like the questions you
44:11
Speaker 4: were even asking about your data after.
44:13
Speaker 6: Seeing these, I think there definitely was. I think we
44:15
Speaker 6: kind of really looked.
44:16
Speaker 7: A making sure that our staff was up to speed.
44:21
Speaker 7: And obviously I love the program or the presentation before
44:24
Speaker 7: this with the AI because I think that's going to
44:26
Speaker 7: help make them even more efficient when we have that
44:29
Speaker 7: in place. But I think there definitely was some different
44:33
Speaker 7: questions that we asked in going into that.
44:35
Speaker 4: Right, So, what's your favorite pulse metric?
44:38
Speaker 5: What's your go to?
44:39
Speaker 6: It's definitely the average full time.
44:40
Speaker 7: That's the real time easiest to Yeah, and I think
44:44
Speaker 7: everybody from the managers of all of our pharmacies, it
44:46
Speaker 7: was the easiest for them to understand too. And then
44:48
Speaker 7: that's why the staff productivity became the next report after
44:51
Speaker 7: the table pulse.
44:52
Speaker 6: We'd go over there and take a look at that.
44:54
Speaker 4: Right, So you mentioned you were using the weekly subscriptions.
44:58
Speaker 4: Tableau Pulse can either you can you daily, weekly or monthly.
45:02
Speaker 4: Why did you choose weekly?
45:03
Speaker 3: Why not I think we.
45:04
Speaker 7: Kind of thought it'd be something that I didn't want
45:06
Speaker 7: to be too reactive, so like every every single day,
45:09
Speaker 7: Oh no, we need to change something, because then you're
45:10
Speaker 7: just gonna be chasing your tail. So I think we
45:12
Speaker 7: we thought on a weekly basis it.
45:13
Speaker 6: Would be good for our team.
45:14
Speaker 7: We would already we were already meeting on a weekly basis,
45:16
Speaker 7: so it kind of made sense to all say, Okay,
45:18
Speaker 7: this is our time that we're going to check this,
45:20
Speaker 7: and usually that meant people checked it the day before,
45:23
Speaker 7: so they were already in the system and looking at it.
45:25
Speaker 4: Yeah, okay, I think that fits with the long term
45:28
Speaker 4: business strategy because it's not really you know, moment to
45:30
Speaker 4: moment analytics, but so that kind of fits that model.
45:34
Speaker 4: So you said you guys would meet and look at
45:37
Speaker 4: it weekly. Was there immediate action taken or was it
45:40
Speaker 4: more long term planning?
45:42
Speaker 6: I think it was more long term planning.
45:43
Speaker 7: I think, like I said, when we from the tablet Pulse,
45:46
Speaker 7: we got into then the staff productivity, and that really
45:48
Speaker 7: kind of identified the weaker staff members versus the stronger
45:51
Speaker 7: and I think we were able to kind of focus
45:53
Speaker 7: our training a little bit around that and make sure
45:55
Speaker 7: that if they were a newer employee, were bringing them
45:57
Speaker 7: up to speed, if they were have been here. We
45:59
Speaker 7: want to make or that they're giving them a fair chance.
46:02
Speaker 7: But obviously performance improvement is always something we're looking for.
46:05
Speaker 7: Got to make sure we control our costs. That's to
46:07
Speaker 7: me the one thing you can control in a pharmacy.
46:09
Speaker 7: You can't control what prescriptions are going to be ordered
46:12
Speaker 7: from the physicians for your residents, but you can go
46:14
Speaker 7: ahead and control the staff and costs.
46:17
Speaker 4: Yeah, so let's talk a little bit more about workflow
46:20
Speaker 4: integration and future growth potential. So how do you feel
46:26
Speaker 4: like it integrated into.
46:29
Speaker 6: Your daily day workflow. I think it worked well.
46:32
Speaker 7: I think, like I said, in the morning, we were
46:34
Speaker 7: probably one of those few that you saw hitting it
46:36
Speaker 7: at the eight, nine, ten am. And we tried multiple
46:39
Speaker 7: times to figure out a better time to put our
46:40
Speaker 7: data in because we kind of wanted real time data
46:43
Speaker 7: is what we thought would be helpful, and you kind
46:46
Speaker 7: of have real time data in for everything that's not posted.
46:49
Speaker 7: But then we found out that it was being too late.
46:51
Speaker 7: So by having it early in the morning, we could
46:53
Speaker 7: take a look at it, and that's kind of where
46:56
Speaker 7: we focus. So our morning's really. I think we also
46:59
Speaker 7: hit the finance Thata board a lot as well. That
47:01
Speaker 7: really helped us get a better picture.
47:03
Speaker 6: Of our communities.
47:05
Speaker 4: Has the system or using it, has it changed any
47:08
Speaker 4: of the conversations that you have with your team.
47:10
Speaker 1: Do you talk about data differently?
47:12
Speaker 6: We do, I think.
47:14
Speaker 7: So we have the finance dashboard, I think up on
47:16
Speaker 7: the slide, and one of the things we really found
47:19
Speaker 7: out of that is we have some communities we service
47:22
Speaker 7: personal cares stand alone as part of other communities, and
47:25
Speaker 7: we really found that some of the personal cares, with
47:27
Speaker 7: their freedom to kind of go wherever they want for medications,
47:30
Speaker 7: were not as profitable as others. And I think this
47:32
Speaker 7: allowing us to filter and compare to a previous period,
47:35
Speaker 7: whether it's the previous year and the previous month, we
47:38
Speaker 7: can kind of see where we were losing a little
47:40
Speaker 7: bit of the customers. As new admissions came in, they
47:43
Speaker 7: weren't always choosing our pharmacy at.
47:45
Speaker 6: The level of the community.
47:47
Speaker 7: So we kind of figured out where we need to
47:49
Speaker 7: focus some of our efforts in bringing those people back
47:52
Speaker 7: to our services.
47:53
Speaker 4: Okay, so how are you doing that type of thing?
47:56
Speaker 6: Beforehand? Was it just got feel got feel.
47:58
Speaker 7: Got feel, and I think our billing manager maybe had
48:02
Speaker 7: a rolling tab of how many residents we're using us
48:04
Speaker 7: in each building. But again, if they get one item
48:08
Speaker 7: from us and then the other ten are coming from
48:09
Speaker 7: another pharmacy, it still counts as being a customer of ours.
48:13
Speaker 6: So didn't really do a great job.
48:16
Speaker 4: Okay, so now that you've been using the system for
48:20
Speaker 4: a while, what are you most excited about that it
48:23
Speaker 4: could do next?
48:25
Speaker 7: Like I said, I think the obviously the facility group
48:27
Speaker 7: filtering will really help. That way you can really compare
48:29
Speaker 7: your skilled nursing to your personal cares, to your independent
48:32
Speaker 7: living communities. I think that'll really help you drive where
48:36
Speaker 7: you're being most profitable. But then the next thing I
48:39
Speaker 7: didn't know is the quality events reporting is coming next.
48:42
Speaker 6: I believe sex amount, Yes it is.
48:44
Speaker 7: So I think that's going to help us elevate our
48:47
Speaker 7: customer service when we have the ability to really dig
48:49
Speaker 7: down into where the errors happening, who's making those, how
48:53
Speaker 7: do we prevent those? I think that's we can We
48:56
Speaker 7: will ever beat the bigger pharmacies on price, but we
48:59
Speaker 7: can fully beat them on service, and I think that'll
49:02
Speaker 7: help us do that.
49:03
Speaker 4: Yeah. Yeah, we went through some design sessions with the
49:07
Speaker 4: quote events dashboard to get some feedback already. So it's
49:10
Speaker 4: in development and as soon as we have some prototypes ready,
49:13
Speaker 4: we'll be excited to serve is back out and take
49:15
Speaker 4: a look at them. For anyone new to framework insight,
49:20
Speaker 4: what advice would you give them to get the most
49:22
Speaker 4: out of the system.
49:24
Speaker 7: I think it's you kind of have to just keep
49:25
Speaker 7: going into it. It's one of those that I know
49:27
Speaker 7: it's tough in our day to day to sit down
49:29
Speaker 7: and look at this data, but I do think it's
49:32
Speaker 7: something that once you get in there and start doing
49:34
Speaker 7: playing around the filters and figuring out what's going to
49:37
Speaker 7: give you a better look.
49:38
Speaker 6: For your pharmacy.
49:39
Speaker 7: Like I said, if your point of sale, post consumption,
49:41
Speaker 7: pre consumption, I think you'll be able to figure out
49:44
Speaker 7: what's going to give you data that's going to really
49:46
Speaker 7: help drive your decision making in the in the pharmacy.
49:52
Speaker 4: So knowing we're you know, we're planning to go with
49:55
Speaker 4: data and AI, what's most exciting?
49:59
Speaker 5: Thank you?
49:59
Speaker 7: Well, I think that AI piece of it obviously is,
50:01
Speaker 7: but I think them together, I think is really going
50:04
Speaker 7: to be able to help you out because I think
50:06
Speaker 7: once you're able to add the AI data points probably
50:08
Speaker 7: into into the BI or into the insight system. At
50:11
Speaker 7: some point it's going to be able to help you
50:13
Speaker 7: really focus on on where your where some of your
50:17
Speaker 7: losses are and make sure you're tightening up your operation.
50:22
Speaker 4: All right, Well, those were those were all of our questions.
50:28
Speaker 4: So thank you for being up here with me.
50:31
Speaker 3: And I'm so.
50:31
Speaker 4: Grateful for the partnership throughout the whole beta testing program.
50:34
Speaker 4: You will have just been so fantastic to work with
50:37
Speaker 4: and provided so much feedback.
50:39
Speaker 1: I think we valuable to everyone.
50:42
Speaker 4: Is there any questions from the audience?
50:46
Speaker 6: Didn't all you to receive access to all five.
50:49
Speaker 4: To ashboards or about your they received access to all five. Yes,
50:57
Speaker 4: we didn't have any requests to limit any but as possible.
51:03
Speaker 3: Would you say that maybe the financial want is just
51:06
Speaker 3: send it at all users or.
51:08
Speaker 4: Do you think it's also necessary for them to see
51:11
Speaker 4: the full picture of what's going on in the formal scene.
51:15
Speaker 7: I guess yeah, I mean, I think to me, that's
51:18
Speaker 7: a great question. When we did the beta testing, the
51:21
Speaker 7: five people that we had access to me we would
51:23
Speaker 7: not have been hiding any of that information from but
51:25
Speaker 7: I could understand if you're giving it to all your
51:27
Speaker 7: staff and your technicians have it, Yeah, there may be
51:30
Speaker 7: a point where you get an employee that says, well,
51:32
Speaker 7: why I need to be paid more? I see what
51:33
Speaker 7: we're making here, So yeah, I could certainly understand that.
51:37
Speaker 7: And we do limit in this security of LTC what
51:39
Speaker 7: reports they have access to, so I could see that
51:41
Speaker 7: if you need to do that. But I kind of
51:43
Speaker 7: figured this is going to be more of a manager level,
51:46
Speaker 7: supervisor level that I would think the data should be
51:49
Speaker 7: safe to share with them, but I could understand the
51:52
Speaker 7: need for that. So I believe the way that works
51:57
Speaker 7: is from the time it is flashed to the time
52:00
Speaker 7: it is toded.
52:02
Speaker 6: Is the average fill time?
52:04
Speaker 7: I believe in the system Now when it comes to
52:07
Speaker 7: there's because there's multiple I think for the Tableau Pulse,
52:09
Speaker 7: it's the full picture. I believe when it's the average
52:13
Speaker 7: fill time. I think if you saw on the staff
52:14
Speaker 7: Productivity two where it was to PV one to PV two,
52:20
Speaker 7: that obviously is going step by step. So I think
52:24
Speaker 7: where we did it is I'm not sure how you're
52:25
Speaker 7: set up, but we have different package types for our
52:28
Speaker 7: cycle pill than we do for our regular fills. So
52:31
Speaker 7: that's one of the fil feed filter features that you
52:35
Speaker 7: can use to kind of separate those out. So if
52:37
Speaker 7: you don't want to see those into the numbers as
52:39
Speaker 7: average fill time, we would typically exclude that package type,
52:42
Speaker 7: knowing that that workflow is completely different and we're working
52:45
Speaker 7: days ahead and it may not be toted for another
52:47
Speaker 7: day before that actually goes out the door, so that
52:50
Speaker 7: time of average full time is going to look really
52:52
Speaker 7: really large.
52:53
Speaker 4: All right, Well, thank you all for attending, and if
52:56
Speaker 4: you want to experience framework Insight for yourself, please stop
52:59
Speaker 4: by the There are demos there that's you can schedule
53:03
Speaker 4: a demo at your convenience. But thank you all for
53:06
Speaker 4: being here.
53:07
Speaker 6: Thank you