Incorta Direct Data Platform

The unified data analytics platform that provides everyone with the means to acquire, enrich, analyze, and act on business data with unmatched speed, simplicity, and insight.

GO

Incorta Intelligent Ingest

The fastest way to transform, connect, and prepare data from multiple data sources for complex analytics.

Go

resource-icon-newResource Center

Stop here for guides, blueprints, ebooks, and other resources that illustrate modern approaches for accessing, analyzing, and acting on data across roles and industries.

Go

learn-iLearn

Get all the facts on modern analytics in self-paced learning paths led by our experts. Enjoy courses designed for administrators, developers, and analysts.

Go

DocumentationDocumentation

Dive into Incorta with official documentation, how-to’s, tech specs, user tips, and more. Get the answers needed to optimize your daily user experience here.

Go

CommunityCommunity

Join others and discuss the platform, register for webinars, explore events, learn about new product releases, and get support from the Incorta community.

Go

support-iconSupport

Need help navigating Incorta? Our experts are ready to help. Our team is here to answer questions, troubleshoot, and provide solutions to optimize user experiences.

Go

How to know your customer using data

With more customer data available than ever before, teams can finally identify critical trends quickly and make smart pivots for faster growth. Learn how to apply these strategies during COVID in this blog.

Read Blog

Screen Shot 2020-09-03 at 10.32.35 AM

Unlocking NetSuite Data with Incorta for Supply Chain

Phil Reinhart: Today's webinar is going to be important for supply chain, my name is phil reinhardt I am the resident sales and Eric here at encarta i'll be moderating today.

23
00:02:24.660 --> 00:02:34.410
Phil Reinhart: And so just a real quick little housekeeping items, before we begin, you know if you have any questions or comments or you know if you just want to try to play stump the chump.

24
00:02:34.950 --> 00:02:42.600
Phil Reinhart: You throw anything you want the chat box and try to you know you want to get deeper into this topic, you want to throw a question out you want to.

25
00:02:42.960 --> 00:02:49.050
Phil Reinhart: Tell me how bad my jokes are going to hear from you and i'll be reaching out, you know individually to all of you.

26
00:02:49.410 --> 00:02:59.340
Phil Reinhart: To make sure that you know, there are any questions that are missed, you can also message me directly, if you'd rather do that you don't want to you know when your questions you go out and into the public public chat.

27
00:03:00.090 --> 00:03:07.200
Phil Reinhart: So just you know, be aware of that and, at the end will certainly take the time to to answer questions live as well as throughout the presentation.

28
00:03:08.550 --> 00:03:10.080
Phil Reinhart: Give me the next slide there Brian.

29
00:03:12.750 --> 00:03:16.530
Phil Reinhart: So the agenda for today, you know, as always, the.

30
00:03:17.550 --> 00:03:23.070
Phil Reinhart: There are two There is one more session after this one, so this is all about supply chain, the next session is all about.

31
00:03:23.580 --> 00:03:32.850
Phil Reinhart: diving deep into the the architecture round in court, from an IT perspective and so keep that in mind, but after the series is over.

32
00:03:33.300 --> 00:03:44.640
Phil Reinhart: we're going to be launching a value sprint throughout October so we're actually going to be solving to up to two of your use cases will be giving you our time our talent and our technology to give you the context and confidence.

33
00:03:45.030 --> 00:03:55.170
Phil Reinhart: That those use cases can actually be solved so just keep in mind that, because of attending this event, you do have that opportunity to get our free time talent technology.

34
00:03:56.160 --> 00:04:07.230
Phil Reinhart: Now, the first speaker is going to be Brian he's gonna be talking about in fortune the office of the office of supply chain and then ethan will be doing a DEMO around the topic.

35
00:04:07.860 --> 00:04:23.640
Phil Reinhart: Just to introduce Brian a bit you know if you've attended other sessions this might be a little bit of a repeat, but he has had some major experience within the fortune 10 to the fortune 500 companies within digital transformation, he was actually the CIO over at Norton security.

36
00:04:24.420 --> 00:04:30.750
Phil Reinhart: and deployed in court to there, so if you missed that first couple sessions, where he talks about his story and how.

37
00:04:31.170 --> 00:04:38.100
Phil Reinhart: How he almost made an ocean moment with other technology spending millions of dollars and then stumbled across the Court.

38
00:04:38.760 --> 00:04:50.670
Phil Reinhart: and was able to help the company get through the China tariffs China China us tariffs last year, so definitely has a strong grasp on the netsuite.

39
00:04:51.180 --> 00:05:04.560
Phil Reinhart: Data analytics digital transformation space he's got an MBA from Stanford so guys just freaking smart and then we have currently have and, by the way, you can is also or Brian is also our CIO here in court to now.

40
00:05:05.820 --> 00:05:10.260
Phil Reinhart: ethan post his head open courses pre sales Center of enablement.

41
00:05:11.280 --> 00:05:23.610
Phil Reinhart: And he's been with the company for three years prior to in court, the he was he was on a journey through implementation and consulting focused on the areas of bi and analytics so.

42
00:05:24.630 --> 00:05:35.850
Phil Reinhart: ethan certainly has a perspective on what clients and customers are doing with data today and all the frustrations of how much money, you have to throw into.

43
00:05:37.170 --> 00:05:50.700
Phil Reinhart: You know the services to stand any you know enterprise bi solution up so his perspective is always invaluable so without further ado i'll hand it over to Brian to kick us off and we'll get into the meat of it.

44
00:05:51.450 --> 00:05:57.000
Brian Keare: Great oops Thank you so much Thank you so much phil really appreciate it.

45
00:05:58.410 --> 00:06:10.440
Brian Keare: So we're going to talk about supply chain today i'm going to tell a little bit of my story to give context to folks that didn't attend the first webinar.

46
00:06:11.160 --> 00:06:29.370
Brian Keare: But we're going to try to break new ground here and talk about supply chain so as phil mentioned prior to being an import a Iran it business system state analytics you know everything related to business systems and data for a global manufacturer called neuro tech security and control.

47
00:06:30.390 --> 00:06:42.570
Brian Keare: Nor tech makes smart products for homes and businesses and they've got lots of brand names and lots of companies that we acquired to build up a very successful company called North tech.

48
00:06:43.770 --> 00:06:54.120
Brian Keare: nori tech was powered by netsuite we decided to focus on netsuite as our era P to run our global business.

49
00:06:55.020 --> 00:07:03.180
Brian Keare: We did this across multiple across all continents countries currencies thousands of employees dozens of locations.

50
00:07:04.020 --> 00:07:14.880
Brian Keare: We really worked hard to make sure that netsuite was the core tool to run our business, not just one of a bunch of that people spend their day in but we tried to maximize the chance that.

51
00:07:15.600 --> 00:07:28.770
Brian Keare: People spent as much of their day as possible inside of netsuite and that tweet had as many of the answers as it could possibly have to help us run our business and that's what works well, we have great team.

52
00:07:29.850 --> 00:07:40.650
Brian Keare: We trained and empowered our employees super well, they can work from anywhere in the world on a secure cloud system and i'm a huge fan of netsuite as the rp.

53
00:07:41.970 --> 00:07:47.070
Brian Keare: On the supply chain front, we ran all of our transactions all of our inventory everything through netsuite.

54
00:07:48.150 --> 00:07:55.260
Brian Keare: We developed our own version of a supply chain control tower before netsuite invented at supply chain control tower.

55
00:07:56.100 --> 00:08:03.690
Brian Keare: Which is what you see here and we took advantage of netsuite its own developments in this area when they came along.

56
00:08:04.110 --> 00:08:16.530
Brian Keare: So, for those of you familiar with netsuite you know that you've got dashboards that have kpis and trends inventory position shipment performance definitely has some good stuff.

57
00:08:18.720 --> 00:08:28.530
Brian Keare: Occasionally we would customize netsuite to suit our business, and you know just not to get too much in the weeds but one of the aspects of our business that.

58
00:08:29.400 --> 00:08:40.800
Brian Keare: In our supply chain network which span the globe would involve nor tech taking ownership of a product as it left the supplier factory.

59
00:08:41.430 --> 00:08:52.620
Brian Keare: in a foreign country or as it got loaded on a container ship at the point of origin, so those of you who are in supply chain, know that that fact.

60
00:08:53.070 --> 00:09:00.960
Brian Keare: That use case can get complicated very complicated very fast because why because taking ownership remotely means that if.

61
00:09:01.320 --> 00:09:12.450
Brian Keare: You close a period close a month close your books, while a container ship is on the water your balance sheet needs to reflect the fact that you own that good and it's on your balance sheet.

62
00:09:14.370 --> 00:09:21.270
Brian Keare: You need to also know that it's in transit it's not in one of your locations, but it's in transit, maybe it's on the ocean in a container ship.

63
00:09:21.750 --> 00:09:34.650
Brian Keare: It also means that when you receive products that your warehouse you are not in fact receiving against a PO, which is a non posting transaction for you accounting nerds under know phil if you've got an accounting job to.

64
00:09:35.010 --> 00:09:46.560
Brian Keare: insert there, but for your carrier is not a non posting transaction your instead receiving against a different kind of transaction that reflects the fact that you've actually already received the Po in the goods on to your balance sheet.

65
00:09:47.670 --> 00:09:57.600
Brian Keare: This, of course, is not just semantics, because if you find a discrepancy in the quantities of the goods that you receive once they eventually get to you into your warehouse.

66
00:09:57.930 --> 00:10:06.540
Brian Keare: You can't just partially receive against the Po because you've previously received against that PO at the point of origin, when you took ownership of the goods.

67
00:10:07.590 --> 00:10:17.340
Brian Keare: So at northside we created solutions for this kind of core business process and we actually developed a custom transaction, that was a precursor to.

68
00:10:18.060 --> 00:10:25.500
Brian Keare: To the inbound shipments solution that netsuite eventually released, why do I share all this well you know ethan.

69
00:10:26.070 --> 00:10:35.910
Brian Keare: is not necessarily going to go and do a DEMO of that specific use case, but we want to, I want to highlight it because of the fact that adding korda.

70
00:10:36.360 --> 00:10:45.420
Brian Keare: You know, through our solutions experts, we take pride in understanding the nuances of things like that things about the supply chain.

71
00:10:45.630 --> 00:10:55.680
Brian Keare: That matter to enterprise and that matter to and counting the matter to the confluence of somebody who cares about the accounting and somebody cares about the operations of supply chain.

72
00:10:56.100 --> 00:11:05.190
Brian Keare: And we build that as the fuel to empower our customers our companies to manage their supply chains using in quarter.

73
00:11:08.220 --> 00:11:20.160
Brian Keare: So with that as a backdrop, you know as good as netsuite is the fact of the matter is that we frequently travel like Alice down the rabbit hole netsuite case the rabbit hole.

74
00:11:20.940 --> 00:11:29.160
Brian Keare: You click on a number and it leads you to a whole new screen, maybe an individual transaction, and as you chase transaction by transaction.

75
00:11:29.910 --> 00:11:37.350
Brian Keare: Sometimes you can lose the context, the big picture, even if you end up like I always would having 75 browser tabs open at once.

76
00:11:38.130 --> 00:11:49.620
Brian Keare: It can be a very disjointed reactive one transaction by one transaction experience, this is an example on the screen you click on a current inventory number in your.

77
00:11:50.370 --> 00:11:57.600
Brian Keare: control panel dashboard for supply chain and you get taken immediately to a separate screen with one individual report.

78
00:11:58.110 --> 00:12:09.510
Brian Keare: A big list of items that make up that number that is of course helpful because it is the detail behind that number, but if you are navigating this kind of way of.

79
00:12:10.410 --> 00:12:22.260
Brian Keare: Trying to manage your business you're constantly flipping back and forth constantly going browser the browser individual page by individual page and sometimes it can be really hard work to navigate through all of this.

80
00:12:23.580 --> 00:12:33.390
Brian Keare: Inevitably in netsuite you're going to leverage save searches you're going to promote those saved searches to your key dashboards and put them front and Center.

81
00:12:34.230 --> 00:12:41.280
Brian Keare: Where you work in this case open ipos is on you know was put on the control tower dashboard.

82
00:12:41.700 --> 00:12:52.890
Brian Keare: and North tech and i'm sure all of you who are using netsuite do this for every different function in your supply chain, so if you're a buyer your focus on orders that need to be placed or maybe which are late.

83
00:12:53.550 --> 00:13:05.820
Brian Keare: If you are managing your logistics you're focusing on orders that might need to be upgraded to an expedited class of shipping to get to the warehouses faster, and you have a list of.

84
00:13:06.960 --> 00:13:17.160
Brian Keare: list of transactions that are created via save search to try to get you that list that you would select from if you're a warehouse manager.

85
00:13:17.400 --> 00:13:27.150
Brian Keare: You might need to validate receipts and dig into inventory discrepancies if you're managing orders, you would focus on juggling who gets priority allocation.

86
00:13:27.390 --> 00:13:39.810
Brian Keare: for incoming inventory, if your accounting, you would reconcile to discrepancies and interact with vendors on any on any shorts and short payments that you would be planning to pay against a given PO.

87
00:13:41.160 --> 00:13:52.320
Brian Keare: So, but again, you know you can customize it person by person department by department function by function, but in the end you're living in netsuite you're you're at the end of the day, clicking on one thing, and a summary list or KPI.

88
00:13:52.830 --> 00:14:04.590
Brian Keare: And it takes you to one separate individual browser with one transaction at a time, and this is how you live, you live, looking at a summary or at one transaction or flipping between a browser that has.

89
00:14:05.700 --> 00:14:18.540
Brian Keare: Each of those things, and you know if you're like me, you got 75 browsers that are open very difficult to look, both at once, even with netsuite advanced analytics which is really the equivalent of a pivot table and ends up being a chore.

90
00:14:19.620 --> 00:14:27.060
Brian Keare: So what do we do, inevitably, whether you as a admin or executive at your company, whether you want.

91
00:14:27.450 --> 00:14:35.010
Brian Keare: Your employees to or not your users inevitably start taking those saved searches snippets of netsuite data.

92
00:14:35.340 --> 00:14:41.760
Brian Keare: And they say gosh I really want to try to have a little bit more comprehensive view i'm gonna download it's xml see what I can do an excel.

93
00:14:42.240 --> 00:14:50.400
Brian Keare: And, of course, no one safe search can give you everything you need so you create more save searches and you download more data into excel.

94
00:14:51.180 --> 00:15:09.120
Brian Keare: It becomes a little bit of a snowball, as we all know, North tech we have 10s of thousands of safe search in our instances everyone had their favorite few dozen so from a supply chain perspective, what what are your choices for trying to manage this dynamic.

95
00:15:10.230 --> 00:15:21.270
Brian Keare: You know I think I try to boil it down to four, which are the four that I mean i'll take my experience before that we that we manage number one you can direct can continue to try to direct as much.

96
00:15:21.630 --> 00:15:26.610
Brian Keare: of your team's time and effort, as you can back and do your era P, and we certainly did that.

97
00:15:27.120 --> 00:15:36.930
Brian Keare: When it's not sufficient, you need to kind of raise your hand and kind of half surrender and allow good analysts in your organization to put their ex ex expertise to work.

98
00:15:37.530 --> 00:15:48.660
Brian Keare: Maybe you consider building a data warehouse maybe you are enticed by a shiny piece of supply chain software lets you read my little quote, that I put it, and.

99
00:15:49.230 --> 00:15:55.230
Brian Keare: You could probably get a sense of how I feel about that, so you know here's what we were up against at.

100
00:15:55.680 --> 00:16:03.030
Brian Keare: North tech and those of you who are at my first webinar you know saw this slide but let's go dig into.

101
00:16:03.630 --> 00:16:21.150
Brian Keare: The supply chain part of this complexity, yes, at the Center was Oracle netsuite powering millions of transaction many millions of transactions over 10,000 products globally but we had other key supply chain systems here that we had to navigate so we had our own factory.

102
00:16:22.170 --> 00:16:33.300
Brian Keare: Which with many of those 10,000 products was a bit complicated to run via netsuite We actually had a different legacy msrp that we used and that we needed to.

103
00:16:33.750 --> 00:16:44.160
Brian Keare: Actually bounced that data off of netsuite and feed that into netsuite we had outside vendors, if we were lucky those outside vendors would give us a vendor portal, the check.

104
00:16:44.820 --> 00:16:55.560
Brian Keare: more likely they would give us a daily excel spreadsheet with order status that we weren't so lucky we were emailing them one by one, with ad hoc questions and drinking from the firehose of.

105
00:16:55.920 --> 00:17:03.690
Brian Keare: responses from vendors to who would let us know where we were on each PO that we had submitted them, we had to understand.

106
00:17:04.350 --> 00:17:15.450
Brian Keare: Our logistics providers and where our shipments were that were inbound and also out down to our customers, but on the supply chain side, where containers were on the ocean.

107
00:17:17.010 --> 00:17:24.570
Brian Keare: When they were clearing customs along that was going to take when they were on the trucks or we have to coordinate with ldl carriers ups, you name it.

108
00:17:25.650 --> 00:17:39.030
Brian Keare: On the demand planning side customer side we had old team that would take into account what were the latest trends what were the latest trends for customers or for item seasonality cyclicality how did pandemic affect us.

109
00:17:39.750 --> 00:17:52.260
Brian Keare: You know, in this day and age, and so the supply chain team needs to adjust their processes, and you know all of the items coming inbound to account for those changing demand plans.

110
00:17:53.220 --> 00:17:58.260
Brian Keare: And, as I said, we acquired companies and so acquired companies didn't necessarily have netsuite What do you do with them.

111
00:17:59.100 --> 00:18:03.780
Brian Keare: sure you try to integrate them into netsuite but you know, during those six months, what do you do, you need something.

112
00:18:04.770 --> 00:18:16.740
Brian Keare: So against this business system landscape which of these choices ended up becoming suboptimal well netsuite kinda does because, once you start having key sources of information.

113
00:18:17.070 --> 00:18:24.330
Brian Keare: Especially outside of netsuite I think ethan will make the case later that even if you're doing straight operational analytics on top of netsuite.

114
00:18:24.750 --> 00:18:30.660
Brian Keare: there's some real Aha moments that are game changers even for internal netsuite.

115
00:18:31.200 --> 00:18:42.000
Brian Keare: netsuite operational analytics using a powerful tool, like in quarter, but once you start having key sources of information outside of netsuite that you need to factor into the equation becomes a different ballgame.

116
00:18:42.810 --> 00:18:53.610
Brian Keare: Even if you pursue data integration strategies like we did i'm a huge fan of boomy as well we use that and used it to great success, but the more data sources, you have.

117
00:18:54.060 --> 00:19:09.450
Brian Keare: And the more that those data sources are in constant flux, the more difficult it is to contemplate how netsuite can be the be all end all giving you the complete view so for us supply chain software was also out, I had a director of supply chain, who suggested.

118
00:19:10.650 --> 00:19:19.950
Brian Keare: To me on Point number four or option number for that that was exactly what we needed to do all our problems would be solved if only we went with a certain solution, and he had a favorite.

119
00:19:20.460 --> 00:19:33.780
Brian Keare: You know my first question to him was okay so tell me about your supply chain playbook your supply chain processes, what are we going to use as the basis for embarking on a multi quarter, maybe multi year.

120
00:19:34.980 --> 00:19:39.900
Brian Keare: project and, once you get to a total cost of ownership, that would cost us millions of dollars.

121
00:19:40.350 --> 00:19:49.200
Brian Keare: and his answer was well we're will work that all out through the implementation what he was really saying was he didn't have a good process, he was hoping that.

122
00:19:49.620 --> 00:19:55.170
Brian Keare: A tool could magically come in and solve all these problems, but what was the fact of the matter, the fact of the matter was.

123
00:19:55.440 --> 00:20:05.100
Brian Keare: That he had been living too much of his career drinking out of the proverbial firehose being reactionary and he didn't have a coherent plan.

124
00:20:05.490 --> 00:20:14.280
Brian Keare: My conclusion was that such a project and money would be wasted in lesson until we can get a handle on the bigger picture.

125
00:20:14.790 --> 00:20:23.610
Brian Keare: We needed to understand our data better we needed to begin as a company to make better data driven decisions in our business.

126
00:20:24.270 --> 00:20:31.590
Brian Keare: That would help us run our business and that will help us prioritize our efforts better so that left us number two and number three.

127
00:20:32.520 --> 00:20:42.000
Brian Keare: So excel tell me about your master XL supply chain workbook and i'll tell you about ours or hers contained a couple dozen worksheets.

128
00:20:42.390 --> 00:20:49.110
Brian Keare: That came mostly from netsuite but also some of the sources of information that I mentioned to previously.

129
00:20:49.440 --> 00:20:58.320
Brian Keare: So we would incorporate those into our workbook and they would include vendor information logistics information demand planning information.

130
00:20:58.710 --> 00:21:06.960
Brian Keare: Other ad hoc bits and pieces, that would be that would get incorporated it was a monster, at least by my standards.

131
00:21:07.680 --> 00:21:25.020
Brian Keare: You know, maybe some of you in the audience could trump this ours, you know when I ended up leaving or when you know when we went in court to enter the scene, I think, topped out at 164 megabytes of data and a lot of complexities.

132
00:21:26.100 --> 00:21:35.580
Brian Keare: I will tell you that our key analyst who ran this xml monster, who is primarily responsible for it had the most powerful computer in the company they get may have been liquid gold.

133
00:21:36.630 --> 00:21:42.840
Brian Keare: I can tell you that her weekends were shot wide Mondays were our key supply chain planning meeting.

134
00:21:43.260 --> 00:21:49.170
Brian Keare: And in order to be ready for monday's that meant that the dozens of data sources needed to be refreshed.

135
00:21:49.620 --> 00:22:03.570
Brian Keare: She couldn't do in Monday morning, but she was a machine, she was a human etfs machine she did it over the weekend every single data source was refreshed every single calculation needed to be revalidated and by goodness she did it.

136
00:22:04.260 --> 00:22:11.250
Brian Keare: Over the weekend and was generally ready for the Monday meetings, but a weekend through shot God help us if she was ever sick.

137
00:22:12.360 --> 00:22:18.930
Brian Keare: It would give me constant heartache to hear stories about the stress the late nights the weekends that she endured and how much.

138
00:22:19.500 --> 00:22:31.680
Brian Keare: was on her back for such a company, so you might hear this and say, well, maybe that fancy fancy supply chains a piece of software would have helped and yeah That was the key argument of our director of supply chain but.

139
00:22:32.310 --> 00:22:44.130
Brian Keare: Again we had enough experience i'd have experience with implementations and had enough fellow cios in my network to know that the pitfalls of implementing such a tool, without having.

140
00:22:44.850 --> 00:23:00.630
Brian Keare: processes in place that were sound in the first place, so we needed a better understanding of our data first So what do we do we tried to help her and other analysts by making the sourcing of data and calculations easier, we created a data warehouse we built flows to integrate data.

141
00:23:00.900 --> 00:23:03.330
Brian Keare: From key sources into a data warehouse.

142
00:23:03.390 --> 00:23:12.450
Brian Keare: We use the tl tools to try to take some of that load off of our analysts and she who was a human ATM machine.

143
00:23:13.020 --> 00:23:23.280
Brian Keare: We built a model shape the data to try to optimize for consumption in excel or power bi or tablo we took lots of the dozens of worksheets that they had created.

144
00:23:24.030 --> 00:23:34.800
Brian Keare: built those those in calculations into a master excel supply chain workbook from the workbook and reverse engineered them back into our data warehouse structure.

145
00:23:35.880 --> 00:23:52.590
Brian Keare: But that to had some problems data warehouse had some problems excel had some problems, the problem with the data warehouse was the atl would break or something else in the process would break building the data marts or cubes or calculations would break it men right.

146
00:23:53.040 --> 00:23:56.340
Phil Reinhart: And Brian how long did it take you to even set that up in the first place.

147
00:23:56.520 --> 00:24:07.650
Brian Keare: Oh gosh you know it's a it's a it is, I think our first effort at data warehouse 1.0 was about a four month process to get something up and running, but.

148
00:24:08.670 --> 00:24:17.100
Brian Keare: But yes, and you know we'll get to you know the next point not only when something breaks, but if somebody has a new question I got a new data source, we got a new.

149
00:24:17.340 --> 00:24:26.700
Brian Keare: vendor portal information that's coming or a new logistics provider, that we need to incorporate the problem is re incorporating that into the data warehouse.

150
00:24:27.690 --> 00:24:40.590
Brian Keare: You know, it always needed to be changed, and it was way too slow, so new data source new vendor portal new logistics provider he you know would take weeks and weeks to get into incorporated.

151
00:24:40.680 --> 00:24:55.260
Phil Reinhart: Data work and were there ever points where it took so long that maybe the question that was asked for the data source that was added in maybe it wasn't even valuable anymore okay i've heard some stories like that, where you know it's weeks in.

152
00:24:55.980 --> 00:25:02.760
Phil Reinhart: Four weeks six weeks and then okay well that was four weeks ago we're not too concerned with that anymore in the market has changed.

153
00:25:03.600 --> 00:25:04.230
Brian Keare: What do we do.

154
00:25:04.410 --> 00:25:09.090
Brian Keare: We always do we break we go back to the master supply chain excel workbook.

155
00:25:09.360 --> 00:25:17.160
Brian Keare: geez yeah you know, those of you watched iron chef you know who reigns supreme the master excel supply chain workbook.

156
00:25:17.640 --> 00:25:25.710
Brian Keare: reign supreme stayed the workout stayed the workforce of all of this effort that was until in court again.

157
00:25:26.640 --> 00:25:36.210
Brian Keare: So the promise of according to what's promise of important promise of in court is a unified platform where you can connect disparate data, exactly as it exists in the source system.

158
00:25:36.690 --> 00:25:46.200
Brian Keare: and start building visualizations almost immediately so when I heard that and those of you who were in the previous webinar know that my response was.

159
00:25:46.590 --> 00:25:56.580
Brian Keare: impossible, we had struggled with the hundred and 64 megabytes spreadsheet we built the data warehouse it was hard thankless work there were no magic bullets.

160
00:25:57.510 --> 00:26:10.830
Brian Keare: or were there, so I did some research talk to an analyst among the things that the analysts told me was that encarta had a very happy customer and that customer His name was shutterfly.

161
00:26:11.190 --> 00:26:19.050
Brian Keare: shutterfly used in Korea to completely transform their supply chain so wow that had my attention shutterfly.

162
00:26:20.040 --> 00:26:25.320
Brian Keare: If they were to be successful, they need to be able to get customized products to customers really quickly.

163
00:26:25.830 --> 00:26:36.060
Brian Keare: couldn't do so wastefully they had a really complex supply chain and if if shutterfly was saying in quarter revolutionized their supply chain, I was super interested.

164
00:26:36.780 --> 00:26:51.450
Brian Keare: So we had to set up that proof of concept connected to some data we loaded it in its original form, did we need to transform it no we actually didn't all we needed to do is validate the data structure and how it was connected.

165
00:26:52.890 --> 00:26:56.700
Brian Keare: And then we can start building visualizations ethan will show you that.

166
00:26:57.480 --> 00:27:09.150
Brian Keare: In many cases, you don't need to validate the data structure anymore, because of our blueprints we've pre validated common data structures, including netsuite and so you you already have visualizations built for you that you can build.

167
00:27:09.150 --> 00:27:14.190
Brian Keare: Upon so by the end of the weekend of validating this we were we were super sold.

168
00:27:14.790 --> 00:27:27.990
Brian Keare: And we were sold on on three points that we've talked about one is that, instead of flipping back and forth between those 75 browser tabs you either get to look at an individual transaction.

169
00:27:28.350 --> 00:27:37.440
Brian Keare: or a list of transactions or a KPI number you get to look at all of them at once, and you get to drill down and see how.

170
00:27:38.040 --> 00:27:44.070
Brian Keare: you're you get to see the transaction detail and how those slices and dices of those that information.

171
00:27:44.670 --> 00:27:58.260
Brian Keare: happens in real time that's a game changer because you can start asking questions of your data and have instant gratification on what that means, as you start asking questions of your day to start understanding your business in a totally different way.

172
00:27:58.680 --> 00:27:59.070
Brian Keare: And I think.

173
00:27:59.190 --> 00:27:59.910
Phil Reinhart: I think even.

174
00:28:00.060 --> 00:28:08.940
Phil Reinhart: Even also from like like a I keep hearing this is fail fast insight approach or this fail fast on you know I mean any any.

175
00:28:09.540 --> 00:28:19.200
Phil Reinhart: Any business team that wants to get the answer as quickly as possible, wants to be able to fail as quickly as possible so that they can get to that right answer.

176
00:28:19.740 --> 00:28:29.190
Phil Reinhart: And I feel like that's something that you're saying here is is hey look at the data is already there you can you know you can iterate through your ideas.

177
00:28:29.880 --> 00:28:38.820
Phil Reinhart: You know at this speed of thought, and I mean the complexity of the you know that diagram they showed before of all the different areas of the business and all the different data sources.

178
00:28:39.360 --> 00:28:48.480
Phil Reinhart: That iteration doesn't seem possible that much complexity and what you're saying here is no like there's actually there is.

179
00:28:49.350 --> 00:29:01.980
Brian Keare: That I mean that is correct, and so what What do you do if you're in netsuite you need to answer a new question you build your 10,140 sixth saved search.

180
00:29:02.370 --> 00:29:11.340
Brian Keare: Right in order to get the new slice of data, if you are in a data warehouse, then you need to unwind everything that you've done.

181
00:29:11.850 --> 00:29:23.040
Brian Keare: define the new requirement and build it back up which takes those weeks if you are in in quota you either have the data there, or you can add it.

182
00:29:23.640 --> 00:29:35.100
Brian Keare: In minutes and start being able to report on it super quickly so ethan is going to go either is going to go a little bit into that and why that is such a game changer, but it is, and especially in supply chain, which is constantly.

183
00:29:35.580 --> 00:29:41.850
Brian Keare: Changing can't you can't optimize like I could you know this is part of the part of the issue with respect to the.

184
00:29:42.360 --> 00:29:53.430
Brian Keare: Supply Chain software as well that presumes that you can get to one optimization of your business and basically ride that wave.

185
00:29:53.760 --> 00:30:03.690
Brian Keare: For a long period of time, there are some businesses that you might be able to contemplate doing that most businesses, however, need to modify and adapt and the last thing you want is to.

186
00:30:04.110 --> 00:30:13.800
Brian Keare: You know, have a year long implementation and then you've got you know, on day one you've got four change requests and you know you've got another four months worth of work.

187
00:30:14.730 --> 00:30:21.630
Brian Keare: You know that's terrible so in court as a game changer in that respect, because of what you said phil and ethan's going to show off some of that.

188
00:30:22.650 --> 00:30:29.730
Brian Keare: yep the other things you know number two single source of truth, the number in encarta matches the source system.

189
00:30:30.030 --> 00:30:39.390
Brian Keare: There is not the debate that needs to be had that we all have had in excel did you get your calculation correct where did you get that data.

190
00:30:39.600 --> 00:30:49.110
Brian Keare: It static data when did you load that data is it stale did it incorporate the POs that Sally place last night oh i'm not sure you know.

191
00:30:49.410 --> 00:30:55.500
Brian Keare: Because it's not real time data i'd have to reload that data into my excel workbook i'll come back to you in two days.

192
00:30:56.070 --> 00:31:00.270
Brian Keare: that's really hard so you got single source of truth that is up to date.

193
00:31:01.080 --> 00:31:11.040
Brian Keare: Real time and that's also a game changer number three is you know, building on all of these first two is that you really have the possibility for true self service in the first time.

194
00:31:11.430 --> 00:31:23.010
Brian Keare: it's really drag and drop in a way that is a third game changer here so at the end of the day, got one more you know one more quick note we're going to turn it over to ethan for for the.

195
00:31:23.430 --> 00:31:34.470
Brian Keare: You know, for the DEMO but you know So what are the choices, the choices are you know, do I rebuild the data warehouse we you know we thought about building a data warehouse 2.0 we thought about.

196
00:31:35.310 --> 00:31:46.470
Brian Keare: Implementing one of those fancy fancy supply chain solutions all of those are you know 812 24 months millions of dollars, you have to get it right.

197
00:31:47.430 --> 00:31:54.210
Brian Keare: At the at the beginning, it becomes pretty inflexible or the alternative is you can implement in quarter.

198
00:31:54.840 --> 00:32:03.060
Brian Keare: Our typical installations of in quota are one to two months, nor tex happened to be one month, which was a land speed record for us.

199
00:32:04.020 --> 00:32:15.420
Brian Keare: And we are finding that sweet customers that try out our blueprint they click a button they actually start seeing their data within an hour So you see real modern bi.

200
00:32:16.440 --> 00:32:32.070
Brian Keare: That ethan will show you, you can do it, you can do it in minutes or an hour and translate that into a production system super quick so there's nothing quite like it so without further ado let's actually get to a DEMO of what this is all about ethan over to you.

201
00:32:33.090 --> 00:32:44.490
Ethan Post: yeah appreciate it, and I think, maybe just to kind of set the stage for what i'm hoping to talk through is taking a lot of brian's insights and thoughts around you know supply chain for netsuite and how important can optimize that process.

202
00:32:45.900 --> 00:32:52.710
Ethan Post: You know my mind automatically goes to a lot of the customers, whose whose issues we're solving right and one of our newest customers and netsuite customer.

203
00:32:53.070 --> 00:33:01.110
Ethan Post: Who, a lot of the things Brian said just just rang so true right, so they are a very complex retailer who sells both direct to consumer as well as wholesaler.

204
00:33:01.590 --> 00:33:09.600
Ethan Post: They have a very seasonal business, which requires them to basically acquire a lot of goods at once and basically sell them off a little by little right.

205
00:33:09.840 --> 00:33:19.650
Ethan Post: So one of the things that they had their eyes on is this concept of available to sell meaning hey we now have a stockpile of goods that were selling in multiple channels, how do we get visibility into.

206
00:33:20.640 --> 00:33:29.160
Ethan Post: How many we have left and making sure we're not overselling because this complex supply chain takes you know, three, four weeks of lead time in order to get to get items into their front door right.

207
00:33:30.090 --> 00:33:36.390
Ethan Post: So when I think about that the interesting thing about that story is you know, Brian and team had a very similar conversation with these folks.

208
00:33:36.630 --> 00:33:46.380
Ethan Post: You know, over the course of a couple days and they decided hey you know it all sounds good, what you're telling me sounds like it could definitely solve their problems and they were definitely in the you know the depths of.

209
00:33:46.950 --> 00:33:57.390
Ethan Post: saved searches and in a matter of you know, a day, we had an encoded instance deployed we call our blueprint, which want to show right now loaded their data and maybe 30 to 45 minutes.

210
00:33:58.050 --> 00:34:05.820
Ethan Post: Enhanced standard content set up for netsuite in a matter of minutes right, these are folks who have leverage netsuite for for their rfp for several years.

211
00:34:06.060 --> 00:34:13.860
Ethan Post: never really had operational analytics on top of their the rp data, which is obviously you know for any business of any size is going to be, probably the key data source of of.

212
00:34:14.610 --> 00:34:23.640
Ethan Post: You know analytic insights right, so if i'm logging in this encoded instance, what I want to talk you through is this concept of how did these folks basically go from nothing.

213
00:34:24.150 --> 00:34:30.030
Ethan Post: To a set of standard package dashboards that can help them answer some of the toughest challenges just right off the BAT right.

214
00:34:30.900 --> 00:34:37.170
Ethan Post: So, of course, it comes pre packaged with this concept of a blueprint, so, in addition to the back end technology that's really the game changer.

215
00:34:37.470 --> 00:34:44.010
Ethan Post: we've also done a week all you're building these blueprints which is hey all the plumbing all of the legwork and getting those complex data sources stood up.

216
00:34:44.310 --> 00:34:53.250
Ethan Post: As well as a semantic layer we call this the schema which we'll talk through here in a second, as well as pre packaged analytical content right So if I click on this netsuite blueprints folder.

217
00:34:54.000 --> 00:35:01.380
Ethan Post: Out of the box, we support things like executive dashboard and reporting right finance sales order operation purchasing HR and others, so if you think of.

218
00:35:01.710 --> 00:35:11.010
Ethan Post: This is kind of your your staple of reporting for any organization all this just becomes delivered right, so what I can do is i'll show you a quick example of netsuite data.

219
00:35:11.730 --> 00:35:17.580
Ethan Post: And what essentially is a very complex process and to end for a lot of organizations, so if you think of the concept of procure to pay.

220
00:35:18.000 --> 00:35:24.660
Ethan Post: Right I drilled into the operations purchasing folder and i'm looking to procure to pay dashboard so that process of hey from the.

221
00:35:25.050 --> 00:35:35.280
Ethan Post: Second, that I issue appeal to the second that I actually received the goods and actually make make a payment a How long does it take be what's the process that any current point and how do I get visibility into that right.

222
00:35:36.330 --> 00:35:45.750
Ethan Post: So when I can show you real quick is just a dashboard we set up right, where I have things like open PO quantity my class type appeal quantity by item class I can drill into and get all the way down to the item name.

223
00:35:46.200 --> 00:35:55.560
Ethan Post: But also, I can look at this by vendor right by supplier by supplier type but, at the end of the day, to brian's point in quarter really is is based on this concept for netsuite of.

224
00:35:56.160 --> 00:36:05.760
Ethan Post: Basically, packaging this concept of high level insights with that raw transactional detail right so down below I have all the list of purchase orders come out of netsuite.

225
00:36:06.030 --> 00:36:14.550
Ethan Post: All the item receipts all the buildings and then, finally, all the payments, which essentially makes up that concept of procure to pay within netsuite itself right, so what I can do is okay.

226
00:36:14.880 --> 00:36:21.210
Ethan Post: If i'm say i'm an analyst I want to come in and look at our our largest vendor type right all of a sudden, I can drill into this, you know.

227
00:36:21.630 --> 00:36:33.720
Ethan Post: photographic equipment supplies come to find out the two of my top 10 vendors are actually actually fall into this category and turns out the one of these suppliers canon in our you know internal kind of netsuite test site.

228
00:36:34.830 --> 00:36:39.660
Ethan Post: It was by far the largest vendor that that actually contributes to this this vendor type right.

229
00:36:40.260 --> 00:36:43.800
Ethan Post: So, as I continue to drill down as i'm sure you're expecting now below.

230
00:36:44.220 --> 00:36:51.630
Ethan Post: All of that raw transactional detail is not changing right so now i've kind of drill in on one of my key suppliers for one of my key vendor types.

231
00:36:52.050 --> 00:37:01.230
Ethan Post: And I can get visibility into things like okay well you know how many items that we actually received over the lifetime of our relationship right so say right around $913,000 worth of inventory.

232
00:37:01.830 --> 00:37:05.070
Ethan Post: And I can continue to look at okay well based on that inventory that we've received.

233
00:37:05.550 --> 00:37:13.350
Ethan Post: How much of this we've been built for which turns out all of it, how much of this that we actually paid turns on again we've actually paid all the inventory we proceed right so from a.

234
00:37:13.740 --> 00:37:20.910
Ethan Post: Security standpoint that's good, but the other thing I can find out is just from a raw purchase order standpoint right there's 17 purchase orders that we issued.

235
00:37:21.720 --> 00:37:28.470
Ethan Post: To canon over the lifetime of our relationship and that that actually makes up 120 $7,000 within toy right so somewhere out there.

236
00:37:28.740 --> 00:37:32.760
Ethan Post: I see one transaction, which is actually still outstanding right so i'm still waiting for this to come in.

237
00:37:33.330 --> 00:37:44.520
Ethan Post: to the tune of about $14,000 right So if you think of what I just did right going from this is kind of package dashboard that just comes to liver, because in quarter understands netsuite because of our technology and the way that we kind of.

238
00:37:45.870 --> 00:37:48.060
Ethan Post: play against these tables that load the data directly.

239
00:37:49.080 --> 00:37:53.040
Ethan Post: I can identify a single transaction from one of my key suppliers and one of my key areas.

240
00:37:53.550 --> 00:37:59.340
Ethan Post: That i'm waiting on right and you don't stop there, because a quarter provides you the ability to get that kind of raw transactional detail.

241
00:37:59.760 --> 00:38:06.750
Ethan Post: What I can also show you one of the things that Brian kind of just loved and the second, he joined in quarter made sure that we have all over the place in this is the blueprint.

242
00:38:07.050 --> 00:38:10.980
Ethan Post: is a concept of okay if i've identified a key transaction coming out of netsuite.

243
00:38:11.910 --> 00:38:20.730
Ethan Post: it'd be really great if I could just click on that transaction side of quarter and drill directly over to netsuite and you know potentially there's some actions you take right so now I drilled from kind of a.

244
00:38:21.180 --> 00:38:27.450
Ethan Post: tabular reports admin quota to that underlying purchase order so to brian's point certainly something that netsuite itself can do.

245
00:38:27.720 --> 00:38:32.430
Ethan Post: But according can do a lot better because it gives you that ability to be analytical about the way that you're looking at data right.

246
00:38:33.300 --> 00:38:36.270
Ethan Post: And maybe here, this is that actionable analytics on top of your data.

247
00:38:36.600 --> 00:38:45.660
Ethan Post: Driving actions and making sure hey, if I understand i'm pending received your maybe there's some kind of hold up or maybe there's something I need to do or take action on my part to expedite this shipment right.

248
00:38:46.140 --> 00:38:51.060
Ethan Post: So to me that's that's exactly what you know operational analytics is about, especially for supply chain.

249
00:38:51.480 --> 00:38:56.430
Ethan Post: As Brian mentioned that's an area that's constantly changing and you need to kind of keep tabs on in near real time.

250
00:38:56.760 --> 00:39:06.360
Ethan Post: And that's what a quarter provides to end user so Brian i'll kind of pause there because i'm curious if you can even make parallels between what I just showed and what nor tech experienced or what we've done for some other customers.

251
00:39:10.170 --> 00:39:23.550
Brian Keare: yeah and and we actually you know even went one step better, which is that we took advantage of in court, a capability, which is that you can embed an interactive browser like this.

252
00:39:23.940 --> 00:39:37.680
Brian Keare: As an iframe into anything we embed it for customers into salesforce and certainly we can do it inside of netsuite so everyone's homepage became their favorite in quarter dashboard.

253
00:39:38.070 --> 00:39:50.370
Brian Keare: And you have an interactive dashboard inside of netsuite that you could click on and actually go to the transaction, so it basically becomes seamless inside of netsuite using in cordova.

254
00:39:50.760 --> 00:39:57.660
Brian Keare: And this is exactly what we did The other thing is you go slice and dice you know that was also.

255
00:39:58.170 --> 00:40:08.340
Brian Keare: it's also critical for our CFO and that our CFO loved is that we make sure that the GL impacts of the transactions you're looking at match exactly to what.

256
00:40:08.670 --> 00:40:15.960
Brian Keare: is going on inside of netsuite So if you wanted to take a look at how all of your POs or bills.

257
00:40:16.560 --> 00:40:32.040
Brian Keare: Actually hit you know our CFO loved it for two reasons number one it matched and number two he found out some things that were problematic about how we set up, you know why is a bill hitting a certain GL account that i'm seeing.

258
00:40:32.910 --> 00:40:38.760
Brian Keare: We messed up how we either entered that transaction or how netsuite is set up, I don't want it hitting that GL.

259
00:40:39.720 --> 00:40:45.510
Brian Keare: I don't want him hitting that GL account, and so, instead of having to close out a month by doing a bunch of.

260
00:40:46.080 --> 00:40:57.000
Brian Keare: journal entry transactions that fix all this stuff he's able to look at this in real time and fix it at its source, so that the transactions are flowing exactly where.

261
00:40:57.870 --> 00:41:07.410
Brian Keare: He needs them to and it streamlined the accounting and month and close process dramatically as well, so you get different departments working together.

262
00:41:08.850 --> 00:41:12.270
Brian Keare: On something like this in a way that we never were able to have before.

263
00:41:13.740 --> 00:41:21.930
Ethan Post: yeah really, really well said, and I think the thing that you just kind of reminded me of is, as you talk about maybe you know supply chain specific applications that that folks may be.

264
00:41:22.380 --> 00:41:30.990
Ethan Post: Evaluating keep in mind that you know netsuite or excuse me in court is specifically designed to to handle all of your complex netsuite supply chain challenges.

265
00:41:31.620 --> 00:41:38.970
Ethan Post: But you're not getting a netsuite system right and quarter is not only netsuite data not only supply chain it's you know netsuite finance netsuite HR hr.

266
00:41:39.660 --> 00:41:51.630
Ethan Post: Human resources, but also any other source, you want to bring in right so so Brian show this complex supply chain of this complex web systems within your tech and accordance able to solve all those problems in just all that data from those disparate sources right.

267
00:41:53.610 --> 00:41:59.610
Ethan Post: So that's kind of this concept of comparing a quarter, maybe to you know best of breed and maybe even supply chain analytic technology.

268
00:41:59.970 --> 00:42:07.560
Ethan Post: But what I also wanted to do is kind of juxtaposing quarter with that excel based functionality right So when I look at something like netsuite itself.

269
00:42:08.040 --> 00:42:17.460
Ethan Post: i'll kind of flash up this concept of comparing in quarter to that safe search problem because that's where a lot of the light bulbs Come on, when we get to a proof of value and we really show this in real time.

270
00:42:18.000 --> 00:42:24.390
Ethan Post: So let's kind of take this concept here of maybe you know someone in the supply chain organization might have a pre built.

271
00:42:25.140 --> 00:42:35.430
Ethan Post: Report or a safe search out here for open sales orders right so at any given point you can obviously go out to this this safe search and retrieve a list of open sales orders which is really valuable to understand what's outstanding right.

272
00:42:35.940 --> 00:42:42.750
Ethan Post: nine times out of 10 that same person is going to go and export this to excel go ahead and open it up and probably mash it together with you know.

273
00:42:43.080 --> 00:42:48.900
Ethan Post: host of other things right, so I have an example of that just to hopefully you know harken some some nightmares, on the other side of this call.

274
00:42:49.200 --> 00:42:57.120
Ethan Post: Because when I think about what this is actually doing right, so I have that same open sales orders sheet right maybe I want to compare that to something like.

275
00:42:57.630 --> 00:43:04.080
Ethan Post: You know back orders, maybe I want to also pull in things like pending fulfillment or even you know inventory status report on my items.

276
00:43:05.040 --> 00:43:09.930
Ethan Post: At the end of the day, you know it's going to take someone in your organization to take you know all these these kind of you know.

277
00:43:10.260 --> 00:43:18.420
Ethan Post: disparate one off saved searches and pull them together through a series of things like you know super complex excel formulas and i'll tell you just from experience.

278
00:43:18.750 --> 00:43:26.520
Ethan Post: Not only these manually effort intensive super prone to error right, so I don't think i've been on a netsuite engagement where we've gone through this kind of example.

279
00:43:26.760 --> 00:43:39.930
Ethan Post: And not come up with at least a couple of deviations from from what they expected to see just based on the the automated kind of you know centralized nature of quarter first what is essentially you know one person kind of plugging away at an excel document right.

280
00:43:40.980 --> 00:43:51.000
Ethan Post: So let's kind of compare this concept that that you know, in the average person in your organization is likely taking hours per week to stand up maintain and make sure that it's agile enough to meet the business needs.

281
00:43:52.410 --> 00:43:56.790
Ethan Post: If you think about what according to us, we have this concept inherent to our blueprints called a business schema.

282
00:43:57.330 --> 00:44:04.080
Ethan Post: And we have one year called netsuite inventory status, so if you take that big scary kind of master excel spreadsheet I just showed you.

283
00:44:04.680 --> 00:44:13.050
Ethan Post: we're almost kind of showing the same thing here right, so a set of inventory management attributes right so things like transaction number status customer name in those types of things.

284
00:44:13.410 --> 00:44:20.130
Ethan Post: we've also created a you know a number of inventory measures these could be things like you know, the net amount sales order quantity on hand count.

285
00:44:20.820 --> 00:44:27.360
Ethan Post: What I can show you here real quick is you know if you're the type of folks, on the other side of the call who have gone through this process inside of excel.

286
00:44:28.020 --> 00:44:38.280
Ethan Post: Maybe i'll just add a quick formula here to show you how easy, this is and keep in mind we're talking about a one time setup here versus someone having to manually export that data pull it into an excel document doing something, but then.

287
00:44:41.520 --> 00:44:49.020
Ethan Post: So maybe I want to create a measure here called insufficient inventory which think I just misspelled but for that this the sake of this DEMO will go ahead and keep it right.

288
00:44:49.470 --> 00:44:54.510
Ethan Post: And it's a pretty complex formula right, so it takes into account the quantity ordered the office been committed.

289
00:44:54.810 --> 00:45:04.080
Ethan Post: And doesn't evaluation and basically if if we are oversold we're going to return the amount of inventory, that we are kind of lacking to fulfill a given order right.

290
00:45:04.830 --> 00:45:09.810
Ethan Post: So we've added that measure i've now basically built out an additional fields inside this business schema.

291
00:45:10.200 --> 00:45:16.860
Ethan Post: And what I can do really quickly is now go to the front end so i'm sure folks, on the other end of this call, who had seen that kind of standard pre built content.

292
00:45:17.190 --> 00:45:25.350
Ethan Post: Hopefully you're wondering okay that's great but that's not going to fit all my business needs, so the end of the day in quarter has also giving you the ability to unlock your transactional data.

293
00:45:25.770 --> 00:45:32.340
Ethan Post: and say, maybe I just want to build a simple report here that gives me that transaction detail so i'll pull in things like maybe sales order number status.

294
00:45:32.970 --> 00:45:37.620
Ethan Post: I think I was pulling customer name, we can pull in any dates, maybe an item and so on and so forth right.

295
00:45:38.520 --> 00:45:47.130
Ethan Post: Then I can start to filter things so maybe in this case I actually specifically want to look at sales orders, because I want to see for which sales orders we actually have insufficient inventory in our supply chain right.

296
00:45:47.820 --> 00:45:54.480
Ethan Post: Okay, so now i'm going to filter on specifically sales orders also going to look at order status that happens to be pending for coming.

297
00:45:54.840 --> 00:46:03.210
Ethan Post: I think all this is important to understand because there's no coding required right for an end user, they don't even necessarily need to know that that underlying netsuite data structure.

298
00:46:03.630 --> 00:46:10.800
Brian Keare: And maybe i'll know you know how to build a safe search, you know how to build a more complex powerful bi dashboard and in quarter.

299
00:46:11.610 --> 00:46:18.690
Ethan Post: yeah well said okay so basically we have our attributes here right, so this this kind of covers all the maybe the transaction master data, I want to pull in.

300
00:46:18.990 --> 00:46:26.430
Ethan Post: And then from here, maybe I just want to pull in all the measures that I have i've already kind of built out here right so that includes not only are insufficient I don't even know how to pronounce that now.

301
00:46:26.910 --> 00:46:34.680
Ethan Post: Insufficient inventory plus all the other attributes we pulled in here and the cool thing is look all i've done is drag and drop a couple fields over added a couple filters.

302
00:46:35.490 --> 00:46:45.420
Ethan Post: But in reality, what this amounts to on netsuite not not super complex right but it requires me to go into my customer table to my item table transaction transaction lines and and basically pulling in inventory by location.

303
00:46:46.080 --> 00:46:54.030
Ethan Post: But in accordance super easy to do right because we've kind of abstracting all of that complexity, the last thing i'll do here is i'm just going to sort this insight here by.

304
00:46:54.600 --> 00:46:57.960
Ethan Post: By net amount, so that the the impact of this right is going to be.

305
00:46:58.920 --> 00:47:08.400
Ethan Post: Any sales order, which has a high net amount we're going to be able to evaluate things like okay what's our on hand Count of inventory what's our revenue loss for insufficient inventory and so on, so forth.

306
00:47:09.060 --> 00:47:14.820
Ethan Post: So the other cool thing is hey I just built on an insight right and it'd be nice if I can actually just add that to an existing dashboard.

307
00:47:15.150 --> 00:47:21.450
Ethan Post: Just so happen to have a dashboard here called inventory analysis that has some high level metrics and you know kind of summary statistics.

308
00:47:21.750 --> 00:47:27.150
Ethan Post: That, again, I can drill into just like I just show what i've added down here is in addition to kind of transaction details.

309
00:47:27.450 --> 00:47:33.570
Ethan Post: i've now added a host of very colorful descriptive metrics and attributes that helped me kind of drive the business right.

310
00:47:34.410 --> 00:47:42.210
Ethan Post: So that's as easy as it is to go from kind of the pre built cam content that accord it comes packaged within our blueprint to allow you the ability to come in here and start to you know.

311
00:47:42.780 --> 00:47:44.640
Ethan Post: Maybe I want to look at my top customer who's going to be.

312
00:47:44.970 --> 00:47:53.550
Ethan Post: affected by inventory shortages of my supply chain and look at the various items that they'll be purchasing right so five items and sales orders that we don't have the inventory to fulfill.

313
00:47:53.880 --> 00:48:00.180
Ethan Post: And, as I continue to drill down this is wearing coordinate i'm super powerful because i've not looked at a specific customer in a specific item.

314
00:48:00.540 --> 00:48:12.870
Ethan Post: And I can identify the two sales orders which are going to be affected right so think about how much time that would take you and kind of the safe search in netsuite world Compare that to the encoder processes automated gives you real time access to your data.

315
00:48:13.230 --> 00:48:15.090
Ethan Post: Obviously, with the ability to come in and.

316
00:48:15.270 --> 00:48:17.250
Ethan Post: and expand upon our canned offering.

317
00:48:19.020 --> 00:48:23.880
Ethan Post: So that's all I got in terms of of DEMO where for today, hopefully, that that kind of gets the wheels turning in terms of.

318
00:48:24.150 --> 00:48:34.980
Ethan Post: specific challenges that you folks are experiencing in your supply chain and phil's definitely going to talk here next about how we kind of convert this conversation into more actionable insights on your end here in our October value spring.

319
00:48:37.260 --> 00:48:43.650
Phil Reinhart: awesome Thank you ethan thanks Brian so i'm going to take this screen and I just want to talk about some of the.

320
00:48:45.390 --> 00:48:46.560
Phil Reinhart: The opportunities that.

321
00:48:48.360 --> 00:49:00.240
Phil Reinhart: We have coming up in October, also we do have a another session next week so it'll be going into the it perspective around quarter within netsuite but.

322
00:49:00.870 --> 00:49:11.400
Phil Reinhart: Primarily, the the October value sprint starts next week or well actually this month and will probably actually probably push into November, a little bit.

323
00:49:11.880 --> 00:49:20.430
Phil Reinhart: But it's a 30 day access to our technology we're also going to be giving our time and talent to you to solve up to two use cases.

324
00:49:21.330 --> 00:49:34.590
Phil Reinhart: With this will will also be getting to outcomes not just giving you it's not just a proof of concept it's actually a proof of value so we're going to execute on an outcome.

325
00:49:35.550 --> 00:49:50.010
Phil Reinhart: up to you to use cases is the goal and doing this within 30 days, so we have the so we leave you with the confidence and the context with again a hard dollar impact or a process improvement.

326
00:49:50.790 --> 00:50:15.060
Phil Reinhart: or an F T saving that's real and tangible that you can take to your CFO and say look we saved three hefty This is also going to save us about you know 600,000 or $1.2 million within how we look at our our materials or our traceability, and you know, maybe it's going to help us eliminate.

327
00:50:16.080 --> 00:50:34.230
Phil Reinhart: Challenges when we have recalls and we'll be able to react to those recalls within 30 minutes or 15 minutes, rather than 24 hours, so you can imagine, those are some major outcomes that we could we could we could tackle within within that 30 day period.

328
00:50:35.460 --> 00:50:45.540
Phil Reinhart: In courts also has the access to download and try today, so if you have to cloud that in courts COM, you can jump on the important platform start playing around with it do exactly what ethan.

329
00:50:45.990 --> 00:50:54.780
Phil Reinhart: Show today we even have the ability to deploy the netsuite blueprint into that trial environment, so if you want to see.

330
00:50:55.110 --> 00:51:11.100
Phil Reinhart: What the blueprint blueprint can really do for your netsuite environment we can we can throw that up there, and you can play around with it, we can do the same with salesforce and other other systems as well, so and we can also we can jump on a call and take give you a tour as well.

331
00:51:13.140 --> 00:51:20.130
Phil Reinhart: give you some perspective around you know what's coming up next we do have that session next Tuesday that's going to go into the it.

332
00:51:20.490 --> 00:51:39.330
Phil Reinhart: perspective of in court to watch to get into the architecture and what that looks like and and going deeper into how you would set up courts around netsuite and your other data sources like shopify and salesforce and some of those other sources that are very common.

333
00:51:40.410 --> 00:51:51.510
Phil Reinhart: And then just a reminder, the call to action really here is, you know invite your netsuite peers, to the sessions we've got the recordings out there on the last few sessions we have next week.

334
00:51:52.410 --> 00:52:04.200
Phil Reinhart: For it, and then we have this October values that we're launching here at the end of the year, to be able to solve projects for you all and and connect with your core team, you know we're here to help.

335
00:52:05.670 --> 00:52:09.420
Phil Reinhart: So that's that's about it, we have about eight minutes for some Q amp a.

336
00:52:10.770 --> 00:52:11.430
Phil Reinhart: Sorry, if.

337
00:52:13.980 --> 00:52:18.600
Phil Reinhart: I was a little bit slow they're getting to the end i've got a little bit of a cough.

338
00:52:19.710 --> 00:52:28.350
Phil Reinhart: Today, so sorry about that, but I as i'm looking into the chat I do see there is one question that came up.

339
00:52:28.800 --> 00:52:39.420
Phil Reinhart: And the question was, and you know ethan Brian i'm not sure I know you all, Brian you answered this already in the chat, but I think it would be better, you know relevant to give your own perspectives on this live.

340
00:52:39.810 --> 00:52:54.330
Phil Reinhart: What what really is real time and, what is the refresh rate or what's the refresh rate that is viable, is it truly real time, is it streaming is, it is a close to real time, you know what what does that really look like.

341
00:52:55.590 --> 00:53:05.850
Brian Keare: yeah, so I think practically what's happening is you're taking exact replica of the transactions in netsuite and doing it on an incremental basis and so.

342
00:53:06.210 --> 00:53:12.540
Brian Keare: You know it, nor tech, which has hundreds of millions of transactions under the hood they decided 15 minutes was the right.

343
00:53:13.080 --> 00:53:24.510
Brian Keare: amount of time to be real time enough, and why what's real time enough well what we wanted to get to do, I mean the problem what's the problem statement that we had before.

344
00:53:24.930 --> 00:53:36.690
Brian Keare: you'd have a data warehouse that would be fresh if you're lucky once a day in the morning, and if you found a problem or something that needed to be fixed or recalculated.

345
00:53:37.050 --> 00:53:48.060
Brian Keare: You would go back and make a note of it and fix it in the original source system and then like oh I gotta remember the next morning to look into the data warehouse to make sure it got refreshed.

346
00:53:49.020 --> 00:53:54.420
Brian Keare: The excel spreadsheet would be even a little tougher right, that would be next week let's make sure.

347
00:53:54.720 --> 00:54:01.050
Brian Keare: Or you know or or Jane you need to go redo all of those calculations, because you forgot to include.

348
00:54:01.350 --> 00:54:09.210
Brian Keare: The POs that john entered yesterday, and so you need to pull them all down, and you know however long it takes that person to do it.

349
00:54:09.510 --> 00:54:25.560
Brian Keare: So and that's why one of the things that we transformed was we wanted to introduce the concept of kind of instant gratification instead of being tempted to fix it manually in a excel spreadsheet oh it's wrong, let me just fix it there manually.

350
00:54:26.580 --> 00:54:36.720
Brian Keare: We know how that is a problem you say Okay, let me fix it in the source system save it, how long would I need for it to be reflected in the.

351
00:54:37.140 --> 00:54:51.810
Brian Keare: Indian quarter if a customer put a new big sales order in how long would be an acceptable time to do that, and so we have some customers that are doing five minute refreshes on transactions 15 minutes some say you know our business is not.

352
00:54:52.320 --> 00:54:59.670
Brian Keare: You know, is not that time sensitive and so an hour is enough it doesn't matter really in court, it can handle any of the above.

353
00:55:00.120 --> 00:55:05.310
Brian Keare: And so we have different functions to do that, but I think the real purpose on how it.

354
00:55:05.670 --> 00:55:16.110
Brian Keare: transformed the process and the kind of concept of instant gratification we wanted people if there was a problem fix it in the source system and that could be netsuite it could be anything else.

355
00:55:16.290 --> 00:55:20.190
Brian Keare: And you'll immediately see it in court, and for us, that was a game changer because.

356
00:55:20.520 --> 00:55:33.840
Brian Keare: People faced with that instant gratification would fix it in the source system and we constantly were able to improve our systems, our source systems because of in quarter so ethan what's your perspective on kind of real time nature.

357
00:55:34.800 --> 00:55:41.880
Ethan Post: yeah I mean it's funny right like this question comes up a lot of analytic space, and you know one one customer actually one time, said to me like.

358
00:55:42.120 --> 00:55:50.370
Ethan Post: You know, real time doesn't necessarily exist because even eating streaming sources like they have some latency right so it's it's really all about the thresholds for tolerance and I think.

359
00:55:50.820 --> 00:55:59.010
Ethan Post: just keep in mind the only the only limitation on your ability to load data quickly to a corner, is how long it takes to load so that might seem kind of circuitous but it's basically.

360
00:55:59.340 --> 00:56:03.690
Ethan Post: When I go to load a table incrementally as soon as that job's done, we can kick another one off right so.

361
00:56:04.200 --> 00:56:15.030
Ethan Post: If you do some work to figure out kind of what the long pole in the 10th is there, you can set up your your load schedules to probably be i'd say five to 10 minute windows, if you really need to, and you have the correct data points so that's so far yeah.

362
00:56:16.110 --> 00:56:22.860
Brian Keare: yeah the difference in encarta is that, in contrast to a data warehouse where you load a source table.

363
00:56:23.190 --> 00:56:30.030
Brian Keare: And then you have to transform it and build a cube and do a whole bunch of things before it's ready to be on the dashboard in in Florida.

364
00:56:30.390 --> 00:56:38.550
Brian Keare: You load that source table and within a couple of seconds of the load, it is ready to go and all of your data is refreshed and so.

365
00:56:39.000 --> 00:56:44.910
Brian Keare: That is something that our customers say is completely different than they've seen before in so the concept of.

366
00:56:45.270 --> 00:56:56.880
Brian Keare: You know, being able to load every five minutes or 15 minutes in court actually means you get to see updated data every 515 minutes or however long your leg is, whereas in a data warehouse that has never that has never.

367
00:56:57.390 --> 00:57:11.400
Brian Keare: Because of all the additional post load steps that need to happen in those systems that do not need to happen in quarter so it's one of those things that needs to be seen to actually really kind of be internalized, but it is corrected in quarter.

368
00:57:13.200 --> 00:57:24.930
Phil Reinhart: One one last question for you guys, we have this this value sprint that that we're offering folks and so you know we're giving out our time or talent or technology around that but I mean.

369
00:57:25.410 --> 00:57:36.090
Phil Reinhart: You know, picking those use cases can be can be difficult and people want quick wins, you know they want something that's going to have a big impact fast, and I know we've got you know, a variety of different industries that are.

370
00:57:36.420 --> 00:57:38.970
Phil Reinhart: You know attending this call, but you know where do you see that quick when.

371
00:57:39.720 --> 00:57:49.860
Brian Keare: The quick win is what ethan showed give us your version of that spreadsheet which is going to be multiple saved searches and a summary calculated.

372
00:57:50.850 --> 00:57:58.020
Brian Keare: expression with the look ups and all that kind of stuff that somebody has to maintain painstakingly and say.

373
00:57:58.410 --> 00:58:11.550
Brian Keare: Proof in the pudding would be this laborious effort to maintain this show us how you can transform it in in corrida we've done it not only done it with many customers, but we come back within.

374
00:58:11.910 --> 00:58:17.580
Brian Keare: 2448 hours show them what we've built in, you know their eyes pop out of their head and they're like are you kidding me.

375
00:58:17.940 --> 00:58:25.410
Brian Keare: And I get to manipulate it now that we you know we're not just giving a listing table of rows and columns but we're actually adding on.

376
00:58:25.650 --> 00:58:35.520
Brian Keare: Some of the best practices of a modern VI dashboard On top of that excel spreadsheet so that you can slice dice it interrogated explorer in any way you want.

377
00:58:35.940 --> 00:58:52.890
Brian Keare: And it's a game changer so give us give us one of those as an example operationally how we can reach you how you can reimagine your process, using a tool, like in quarter, we can get you the answer, really, really quickly and then show you how easy it is for you to build on your own.

378
00:58:54.270 --> 00:58:55.350
Phil Reinhart: awesome Thank you Brian.

379
00:58:55.380 --> 00:59:07.650
Phil Reinhart: Thank you ethan everybody have a great Tuesday, have a fantastic productive week and I I wish that the the weekend comes as quickly as possible, for it for you.

380
00:59:10.410 --> 00:59:11.130
Phil Reinhart: Alright, see ya.

381
00:59:12.240 --> 00:59:12.660
Phil Reinhart: cheers.