1 00:00:06,300 --> 00:00:08,500 Hi everybody. And welcome to the show this 2 00:00:08,500 --> 00:00:13,300 week before we get started, I just wanted to take some time to 3 00:00:13,300 --> 00:00:16,000 recognize. Those who have messaged me on 4 00:00:16,000 --> 00:00:21,900 LinkedIn on forums, social media, by phone by email, and 5 00:00:21,900 --> 00:00:24,900 said that they're really enjoying the show that really 6 00:00:24,900 --> 00:00:28,900 motivates me to keep producing the show and keep talking and 7 00:00:28,900 --> 00:00:31,300 interviewing others. And, you know, sharing a 8 00:00:31,300 --> 00:00:33,600 knowledge. I really would love anyone. 9 00:00:33,600 --> 00:00:37,600 Who's interested to give me a buzz and we'll throw you on an 10 00:00:37,600 --> 00:00:40,800 episode as well. This is a community thing. 11 00:00:40,800 --> 00:00:43,000 We need to learn by challenging each other. 12 00:00:44,000 --> 00:00:47,700 So yeah, I'm glad people are getting value out of the show 13 00:00:47,700 --> 00:00:50,400 and that will keep me motivated. So, keep messaging me. 14 00:00:50,400 --> 00:00:53,800 It puts a smile on my face and this week I have had a bit of a 15 00:00:53,808 --> 00:00:57,200 cold, so it was great to receive those messages. 16 00:00:57,600 --> 00:01:06,900 So on with the show, now better business analysis, Institute 17 00:01:07,000 --> 00:01:10,600 presents the Better Business analysis podcast with Kingdom. 18 00:01:15,500 --> 00:01:20,200 Today we're going to be talking about the top 10 tools, every 19 00:01:20,200 --> 00:01:22,600 bitter business analyst needs to know. 20 00:01:25,000 --> 00:01:30,900 So I'm going to be counting down those tools from ten to one and 21 00:01:30,900 --> 00:01:34,700 I'm going to try and offer a cup of varieties. 22 00:01:34,700 --> 00:01:39,300 Not necessarily, you know, pushing one Brando name over the 23 00:01:39,300 --> 00:01:46,200 other and look at both the paid and free options for those top 24 00:01:46,200 --> 00:01:48,900 10 tools. And when I talk about tools 25 00:01:48,900 --> 00:01:51,700 today, I'm really meaning applications that you can use 26 00:01:51,700 --> 00:01:54,200 pieces of software that you can access. 27 00:01:54,800 --> 00:02:00,900 Okay, let's get into it. Making the top ten on our list 28 00:02:00,900 --> 00:02:05,200 today is an AI tool, which you may know about already, which is 29 00:02:05,200 --> 00:02:12,000 chat, g p-- t? Now, when I say chat GPT, I'm 30 00:02:12,000 --> 00:02:16,700 really meeting a whole Suite of applications that are hosted by 31 00:02:17,700 --> 00:02:21,700 open a.i. It's not just the one that 32 00:02:21,700 --> 00:02:24,400 you've just referred to there, actually, a whole lot of engines 33 00:02:24,400 --> 00:02:26,900 or Models for doing different things chat. 34 00:02:26,900 --> 00:02:31,300 Gbt happens to take text that's uses, not your input to return 35 00:02:31,300 --> 00:02:35,500 text. However, actually open, AI has a 36 00:02:35,500 --> 00:02:37,800 whole other Suite of tools to you. 37 00:02:37,800 --> 00:02:41,400 That, you know, could be used for programming languages or 38 00:02:41,400 --> 00:02:44,500 they could be used for generating images or for doing 39 00:02:44,500 --> 00:02:47,400 lots of other bits and pieces. And a lot of applications are 40 00:02:47,400 --> 00:02:51,100 built on top of this kind of open a.i. platform. 41 00:02:51,100 --> 00:02:55,600 And if you Google with chat, gbt So you'll actually find there 42 00:02:55,600 --> 00:02:58,800 are hundreds, if not thousands of applications that are popping 43 00:02:58,800 --> 00:03:04,000 up that are adding a bit of an interface on top of this engine 44 00:03:04,200 --> 00:03:07,300 for specific use cases. So they've kind of been prompt. 45 00:03:07,300 --> 00:03:09,400 They've got like from Generations. 46 00:03:09,400 --> 00:03:12,600 They've been refined to do different things, for example, 47 00:03:12,600 --> 00:03:16,000 referred to programming, I've used one recently to write a 48 00:03:16,000 --> 00:03:21,000 WordPress plug-in automatically through one of these websites. 49 00:03:21,100 --> 00:03:23,600 There's ones that do diagramming, which I've shared 50 00:03:23,600 --> 00:03:26,000 on LinkedIn. And on our blocked. 51 00:03:27,100 --> 00:03:30,000 And so there's a house way and that's just the open a, i 52 00:03:30,000 --> 00:03:32,700 family. And it's important to talk about 53 00:03:32,700 --> 00:03:38,100 that particular company because they, you know, are the ones who 54 00:03:38,600 --> 00:03:43,400 have well-known also, they're not going to go away anytime 55 00:03:43,400 --> 00:03:44,800 soon. And the reason why they're not 56 00:03:44,800 --> 00:03:47,400 going to is that they've got our, it strategic relationship. 57 00:03:47,400 --> 00:03:51,100 I'm not sure if it's a purchase or not, but definitely a 58 00:03:51,100 --> 00:03:53,900 strategic relationship with Microsoft. 59 00:03:54,000 --> 00:03:57,900 So, Mike So Soft has been busy integrating these Technologies 60 00:03:57,900 --> 00:04:01,600 inside their sweets. When I say they're sweet, I mean 61 00:04:01,600 --> 00:04:05,700 windows I mean the Power Platform where you make that I 62 00:04:05,700 --> 00:04:10,100 applications and most importantly, what is used to be 63 00:04:10,100 --> 00:04:13,400 called Office 365 and is now called Microsoft 365. 64 00:04:14,000 --> 00:04:18,500 So what you could do for example is go to Word Within word. 65 00:04:18,500 --> 00:04:21,899 There might be some, you know, menu options that you're so used 66 00:04:21,899 --> 00:04:26,500 to using but instead they do. Enhanced with a I so they could 67 00:04:26,500 --> 00:04:28,500 add a sentence. They could all the great things 68 00:04:28,500 --> 00:04:32,200 that chat to Beauty can do, but we're fine for a certain use 69 00:04:32,200 --> 00:04:37,100 case, which makes it much more less of a toy and much more of a 70 00:04:37,100 --> 00:04:40,500 productive tool. So that's not going away. 71 00:04:40,500 --> 00:04:44,200 And and not only that, it's going to be very easy to access 72 00:04:44,200 --> 00:04:48,200 because it's going to be via the tools and the UI and ux you 73 00:04:48,200 --> 00:04:51,100 already are familiar with, you will know. 74 00:04:51,100 --> 00:04:53,800 Also that being which is Microsoft search engine that 75 00:04:53,800 --> 00:04:55,100 works. But their marks Soft Edge. 76 00:04:55,100 --> 00:04:57,500 Which is actually built on the same engine as Chrome. 77 00:04:57,600 --> 00:05:02,300 Ironically has chat has like, a I built into it. 78 00:05:02,300 --> 00:05:07,000 It's actually a version of its kind of model of chat gbt. 79 00:05:07,600 --> 00:05:11,500 Now, I don't personally like, the results that I get from 80 00:05:11,500 --> 00:05:16,000 being, I'm I don't even like the landing page and maybe it's just 81 00:05:16,000 --> 00:05:17,900 because I've been using Google so often. 82 00:05:17,900 --> 00:05:20,900 So I'm used to seeing the results that I get through their 83 00:05:20,900 --> 00:05:24,500 algorithm. And and so, so Microsoft has 84 00:05:24,700 --> 00:05:27,300 They push the fact that they want people to use being and 85 00:05:27,300 --> 00:05:29,800 this is another enhancement. So you might see people using 86 00:05:29,800 --> 00:05:32,500 wedding because it comes with office. 87 00:05:33,700 --> 00:05:35,600 And the reason I mentioned that is that that's a whole 88 00:05:35,600 --> 00:05:39,800 ecosystem, Microsoft? Not going to go away and so 89 00:05:39,800 --> 00:05:42,400 therefore they are, you know, they are at the Forefront of 90 00:05:42,400 --> 00:05:46,500 consumer Rising AI to a nice h8 G BT. 91 00:05:46,500 --> 00:05:49,100 I'm meaning this whole family and those that are built on top 92 00:05:49,100 --> 00:05:51,900 of it. Now, completely separately from 93 00:05:51,900 --> 00:05:57,100 the whole open a.i. Don't we have the Google site 94 00:05:57,100 --> 00:06:01,300 and and Google's built their own, you know, open our I kind 95 00:06:01,300 --> 00:06:06,400 of Technology called Bard. Be a d and it is integrated now 96 00:06:06,400 --> 00:06:09,900 with Google. So Not only was it its own 97 00:06:09,900 --> 00:06:13,200 application, they're starting to release it within within the 98 00:06:13,200 --> 00:06:16,600 Chrome browser and within the search engine to do specific 99 00:06:16,600 --> 00:06:19,400 things. So for example, think about all 100 00:06:19,400 --> 00:06:23,200 the different applications you can do use right now with Google 101 00:06:23,600 --> 00:06:26,300 and especially. The search space and the really 102 00:06:26,300 --> 00:06:30,800 focused on using AI for search. So you can now get, I don't 103 00:06:30,800 --> 00:06:35,100 know, AI images, or get images back around like a trip. 104 00:06:35,100 --> 00:06:38,600 You want to take, for example, there's different modules will 105 00:06:38,600 --> 00:06:41,900 use cases that have actually got under the search bar, now in the 106 00:06:42,300 --> 00:06:45,700 beta version that I'm using. So it's like, you know, find me 107 00:06:45,700 --> 00:06:50,400 images around this holiday or work out the most efficient 108 00:06:50,400 --> 00:06:52,900 route. So they've got quite a few use 109 00:06:52,900 --> 00:06:55,900 cases. So again, Google you know gue 110 00:06:56,000 --> 00:06:59,500 people are not going to stop using Google and I was asked 111 00:06:59,500 --> 00:07:03,600 recently by someone who was kind of asking me to throw my B 112 00:07:03,600 --> 00:07:08,000 behind one of these to know Google driven or open a, i 113 00:07:08,000 --> 00:07:11,800 Microsoft Riven horse races and I don't think there is, I 114 00:07:11,800 --> 00:07:14,900 actually think they will live in harmony and compete against one 115 00:07:14,900 --> 00:07:17,300 another. So because they're people 116 00:07:17,300 --> 00:07:19,000 consumers, won't change the products. 117 00:07:19,000 --> 00:07:21,700 They use that quickly and I don't think these companies are 118 00:07:21,707 --> 00:07:26,400 going away. There are Facebook has its own 119 00:07:26,400 --> 00:07:30,100 kind of model engines. And if you've played in the 120 00:07:31,000 --> 00:07:34,200 image space, like I have this something called stable 121 00:07:34,200 --> 00:07:39,900 diffusion and it's where you may have seen a art driven, they're 122 00:07:39,900 --> 00:07:45,100 all very similar and you know there's there's not Cafe there's 123 00:07:46,800 --> 00:07:50,000 there's quite a few, there's sorry mid-june he's really 124 00:07:50,000 --> 00:07:53,600 popular engine and they're kind of like or image generations and 125 00:07:53,600 --> 00:07:55,500 that been training and Owning and training, you can actually 126 00:07:55,500 --> 00:07:59,900 get these tools for free. If, you know, your way around 127 00:07:59,900 --> 00:08:02,600 GitHub and you know, you can play with that. 128 00:08:02,600 --> 00:08:05,600 So I think that will exist to the whole engine. 129 00:08:05,600 --> 00:08:08,700 I'm not sure around who's going to win the image creation 130 00:08:08,700 --> 00:08:11,400 engine, but I do know from the productivity Suite, Microsoft 131 00:08:11,400 --> 00:08:14,200 and Google will still be, there will be integrated into their 132 00:08:14,200 --> 00:08:17,800 workplace platform. So that's number, 10, that can 133 00:08:17,800 --> 00:08:21,500 quick that will quickly. Jump to number one in the next 134 00:08:21,500 --> 00:08:23,400 couple of years. So, please, if you haven't 135 00:08:23,400 --> 00:08:26,800 papers those tools, I go out this this free version, you get 136 00:08:26,800 --> 00:08:34,100 free credits on these sites, Google bad as free checked, your 137 00:08:34,100 --> 00:08:37,600 beauty is cut kind of free to a certain point unless you want to 138 00:08:37,600 --> 00:08:41,600 send massive documents to it and it is but limited but you can 139 00:08:41,600 --> 00:08:46,000 pay for it if you like you can actually download local versions 140 00:08:46,000 --> 00:08:50,400 of these software if you know your way around GitHub as well. 141 00:08:50,600 --> 00:08:54,500 So that's number 10 on our list number 9 on our list. 142 00:08:54,500 --> 00:09:01,800 Just is white boarding tools, like mural or neuro that are 143 00:09:01,800 --> 00:09:05,500 very similar to one another. You can get like three 144 00:09:05,500 --> 00:09:07,600 freeboards. I think of you sign up. 145 00:09:07,900 --> 00:09:12,900 So it is a free product or a freemium model what you can use 146 00:09:12,900 --> 00:09:15,900 for online collaboration. It is a number one tool that 147 00:09:15,900 --> 00:09:19,600 I've used in the last couple of years, in terms of work, 148 00:09:19,600 --> 00:09:23,900 shopping in terms of voting terms of virtual Post-it. 149 00:09:24,200 --> 00:09:27,700 And Absolve pasting in a Visio document and then doing a 150 00:09:27,700 --> 00:09:32,900 workshop on the flow diagram. You can invite people, you can 151 00:09:32,900 --> 00:09:37,000 train via it, you can have multi editors at the same time. 152 00:09:37,300 --> 00:09:40,900 If you haven't used these tool, you need to get on to learning 153 00:09:40,900 --> 00:09:44,600 one of these two tools, I would suggest starting with something, 154 00:09:44,600 --> 00:09:50,500 like mural or mirror. Mirror is probably more advanced 155 00:09:50,500 --> 00:09:54,400 in terms of its plugins, but I actually do before the ux 156 00:09:54,500 --> 00:09:58,900 experience in mural, if you don't want to pay for these 157 00:09:58,900 --> 00:10:01,600 tools or you're going to be using it at an Enterprise level 158 00:10:01,600 --> 00:10:04,200 and you don't want to pay for these tools and they do, they do 159 00:10:04,200 --> 00:10:08,800 add up to being around 30 20 to 30 dollars per user per month. 160 00:10:08,800 --> 00:10:13,900 Mark soft has a very budget version called white board which 161 00:10:13,900 --> 00:10:17,900 is part of the team's environment. 162 00:10:17,900 --> 00:10:21,300 So if you have teams already, you can have a mini whiteboard 163 00:10:21,300 --> 00:10:24,500 within that product. And over in Google, they have 164 00:10:24,500 --> 00:10:27,500 Have Jam boards, which are similar, and again, very limited 165 00:10:27,500 --> 00:10:30,400 functionality. Pretty sure that the mark soft 166 00:10:30,800 --> 00:10:34,900 white board will evolve, when they might even purchase one of 167 00:10:34,900 --> 00:10:37,100 these other white board products. 168 00:10:37,100 --> 00:10:42,100 But start with mural or Moreau and start using it and your 169 00:10:42,100 --> 00:10:48,300 daily workflow as a ba, And so I let that move those on to number 170 00:10:48,300 --> 00:10:52,200 8. And number eight, on our list is 171 00:10:52,400 --> 00:10:58,000 a collection of tools which I call Erp /, crms, both big and 172 00:10:58,000 --> 00:11:01,900 small. So I've there is another podcast 173 00:11:01,900 --> 00:11:05,400 episode talking specifically around what these applications 174 00:11:05,400 --> 00:11:07,600 mean, Erp. Enterprise resource planning and 175 00:11:07,600 --> 00:11:10,200 CRM, being customer relationship management and somewhere in the 176 00:11:10,200 --> 00:11:13,600 middle is xrm, which is kind of a merge between the two. 177 00:11:13,900 --> 00:11:17,200 These are the Large Enterprise pieces of software that you 178 00:11:17,200 --> 00:11:20,800 should know as be a should at least know, one version or one 179 00:11:20,800 --> 00:11:24,900 very popular version of each of these two segments. 180 00:11:24,900 --> 00:11:29,700 Erps and serums you go into the Microsoft Family, what used to 181 00:11:29,700 --> 00:11:34,600 be called marks of Syria, which is now Dynamics 365, is a very 182 00:11:35,700 --> 00:11:38,000 popular tool. You should understand that it 183 00:11:38,000 --> 00:11:40,700 will help you understand. When you go into an 184 00:11:40,700 --> 00:11:45,700 organization, that's aligned with Microsoft, what the The 185 00:11:45,700 --> 00:11:50,600 kind of Enterprise sweet tools. Look like there are P has kind 186 00:11:50,600 --> 00:11:54,200 of been divided into modules. Are they all integrate together? 187 00:11:54,200 --> 00:11:59,200 There's there's a there's a whole like Financial Suite that 188 00:11:59,200 --> 00:12:01,600 can integrate they're all coming under the Dynamics. 189 00:12:01,600 --> 00:12:05,400 Family, these days though, and so that has a crud screen as 190 00:12:05,400 --> 00:12:09,200 ways in which you can configure the system, it has ways, you can 191 00:12:09,200 --> 00:12:11,600 integrate the system, they've got power apps, where you can 192 00:12:11,600 --> 00:12:14,300 build low code, no code apps on top of these systems. 193 00:12:14,400 --> 00:12:18,000 So, I've got customer portals, you really should understand one 194 00:12:18,000 --> 00:12:20,200 of these. And of course, the greatest 195 00:12:20,200 --> 00:12:24,400 competition in the serum space, for Microsoft would be 196 00:12:24,400 --> 00:12:28,700 salesforce.com again. I've used that product probably 197 00:12:28,700 --> 00:12:33,100 Microsoft and more and anger. But early days Salesforce, I was 198 00:12:33,100 --> 00:12:36,400 involved in an implementation there at that very similar in 199 00:12:36,400 --> 00:12:38,500 terms of what they do. They've just got different ethos 200 00:12:38,500 --> 00:12:42,000 has or reasons for existence and different kind of code bases, 201 00:12:42,600 --> 00:12:44,200 but you should understand what these tools. 202 00:12:44,600 --> 00:12:48,300 And least understand one of them from an Erp point of view. 203 00:12:48,300 --> 00:12:52,700 The biggest piece in the world are things like sap, their think 204 00:12:52,700 --> 00:12:57,100 very old-school interface almost budget, you know, first 205 00:12:57,100 --> 00:13:01,800 generation Windows 95 kind of stuff but to understand that 206 00:13:01,800 --> 00:13:05,500 they have Registries and they have ways in which you can like 207 00:13:05,700 --> 00:13:11,000 config a codes and you know, the VIPs are usually much more 208 00:13:11,200 --> 00:13:16,900 old-school but they have You can generate screens and you can, 209 00:13:17,300 --> 00:13:20,700 you know, have modules. So very similar to the Syrian 210 00:13:20,700 --> 00:13:24,600 family and the kind of, I would say evolving that way. 211 00:13:24,600 --> 00:13:27,600 There's Gigi JD Edwards is PeopleSoft marked. 212 00:13:27,800 --> 00:13:30,500 Sorry, Oracle own, those are core a big player in there. 213 00:13:30,800 --> 00:13:32,800 Yeah, peace space. And you probably should have 214 00:13:32,800 --> 00:13:34,800 touched at least one of those systems. 215 00:13:34,800 --> 00:13:37,300 The just understand the different models that they use. 216 00:13:37,600 --> 00:13:41,300 So from the I would understand what my action is to use the 217 00:13:41,308 --> 00:13:44,200 understand what an Erp is, find one or con. 218 00:13:44,400 --> 00:13:48,600 Find understand how I'm Works. You've got to be lucky if you 219 00:13:48,600 --> 00:13:52,600 get access to uncover, a very expensive, understand that set 220 00:13:52,600 --> 00:13:56,600 and the Oracle family live within that space quite heavily 221 00:13:56,900 --> 00:14:03,300 and the Microsoft sales forces of the world live in the serum 222 00:14:03,300 --> 00:14:07,200 space more. So in saying that Microsoft will 223 00:14:07,200 --> 00:14:11,100 sell you all of those things and in the serum space, there are 224 00:14:11,100 --> 00:14:14,200 quite a few free smaller ones, so you can get load up. 225 00:14:14,500 --> 00:14:18,400 HubSpot for free, I use it and that'll give you a general idea 226 00:14:18,400 --> 00:14:21,300 of serum. So get your hands on one of 227 00:14:21,300 --> 00:14:27,300 those, a free ones, Ojos another free one, sign up, and then you 228 00:14:27,300 --> 00:14:30,000 can start using these products and understand the kind of 229 00:14:30,000 --> 00:14:33,500 processes that they solve and help. 230 00:14:33,700 --> 00:14:35,700 Now, I'm not suggesting here, of course, that you have any 231 00:14:35,700 --> 00:14:38,100 flavor, or you're jumping to a technology side, but 232 00:14:38,100 --> 00:14:41,600 understanding the limitations of these systems does make you a 233 00:14:41,600 --> 00:14:47,000 better business analyst. Let's move quickly to number 77, 234 00:14:47,100 --> 00:14:52,500 is the other August typical Enterprise kind of business 235 00:14:52,500 --> 00:14:56,800 Suite that most businesses have that kind of sit on top of our 236 00:14:56,800 --> 00:14:59,800 theorem. And then I P system and that's 237 00:14:59,800 --> 00:15:06,000 the CSM sorry CMS which is the content management system. 238 00:15:06,000 --> 00:15:10,200 So the website software so you may have heard of Squarespace, 239 00:15:10,200 --> 00:15:14,200 that's you know, one place that you can make websites shopper. 240 00:15:14,300 --> 00:15:20,400 If I, they're all, you know, kind of er, e Commerce cms's 241 00:15:20,400 --> 00:15:23,500 content Management systems but the most popular one in the 242 00:15:23,500 --> 00:15:27,100 world is WordPress. So if you can get that software 243 00:15:27,100 --> 00:15:30,600 for free, you can just load up a little instance locally or you 244 00:15:30,600 --> 00:15:33,500 can Chuck it on a hosting server of your head to do that and 245 00:15:33,500 --> 00:15:38,300 having a play of understanding, what a Content management system 246 00:15:38,300 --> 00:15:42,300 does, understanding a little bit about web design understanding 247 00:15:42,300 --> 00:15:46,200 modules and plugins and how you. An expose information to your 248 00:15:46,200 --> 00:15:50,000 work in customers and to the public is really important as 249 00:15:50,400 --> 00:15:52,800 you guarantee that your business has a website. 250 00:15:52,800 --> 00:15:56,700 And this is what kind of what software we use to get it. 251 00:15:56,700 --> 00:16:02,300 Our website so WordPress, you can get that for free and let 252 00:16:02,300 --> 00:16:03,100 that up. You can even go to 253 00:16:03,100 --> 00:16:06,400 wordpress.com, door all go, thank and you can get a free 254 00:16:06,400 --> 00:16:08,600 block and so that's on WordPress. 255 00:16:10,800 --> 00:16:15,900 As we jump on to number 7 on our list today, we really talking 256 00:16:15,900 --> 00:16:20,400 probably it's fair to say the Angeles less Ian's family, which 257 00:16:20,400 --> 00:16:25,800 includes Dura, Confluence and Trello a, you may have used one 258 00:16:25,800 --> 00:16:28,300 or more of those tools. I'll start with Trello, Trello 259 00:16:28,300 --> 00:16:31,700 is a combine tool used for your in progress, you know, not 260 00:16:31,700 --> 00:16:37,400 started kind of done blockers, I see the lots of companies using 261 00:16:37,400 --> 00:16:40,700 it for their workflow. In terms of We are tasks are at, 262 00:16:41,000 --> 00:16:43,800 you can share those. You can drag tasks and cards 263 00:16:43,900 --> 00:16:46,500 local cars around. You can integrate that with 264 00:16:46,900 --> 00:16:51,500 things like slack and teams Confluence is the kind of 265 00:16:51,500 --> 00:16:56,400 internal intranet. We can edit Pages. 266 00:16:56,400 --> 00:17:00,800 It's kind of like a Wiki that's usually associated can be 267 00:17:00,800 --> 00:17:03,800 associated with a place to put your requirement specifications 268 00:17:03,800 --> 00:17:08,800 or I'll twos. And then that moves us on to 269 00:17:08,800 --> 00:17:11,700 jira, which is actually the grunt the product that you do 270 00:17:11,700 --> 00:17:16,500 need to know about Dura is the kind of requirements management 271 00:17:16,500 --> 00:17:18,099 tool. It's also a help desk product, 272 00:17:18,099 --> 00:17:21,000 but primarily you can use it in the software space for your, 273 00:17:21,000 --> 00:17:25,300 scrum, your agile, Sprint's, or even waterfall just in terms of 274 00:17:25,300 --> 00:17:30,700 your backlog management, your user stories and your efforts. 275 00:17:30,700 --> 00:17:34,500 And, you know, it's used by at least half the clients that I 276 00:17:34,500 --> 00:17:38,300 know. You know, primarily you do not 277 00:17:38,300 --> 00:17:41,100 need to know Jarrett. And so now I'm when I say know 278 00:17:41,100 --> 00:17:44,600 how to use it, I mean you should be able to create your own kind 279 00:17:44,600 --> 00:17:47,200 of project, and you should better sit that project up. 280 00:17:47,200 --> 00:17:51,500 It's pretty easy. It's click click through and you 281 00:17:51,500 --> 00:17:53,900 should be able to create user stories and if it's within 282 00:17:53,900 --> 00:17:55,200 their. So learn that. 283 00:17:55,300 --> 00:17:59,900 If you don't know that already, I should mention that the other 284 00:17:59,900 --> 00:18:02,500 popular tool. These days is your devops 285 00:18:02,500 --> 00:18:06,500 usually in a development environment it has Has a kind of 286 00:18:07,300 --> 00:18:14,200 dura type very limited but type available where you can manage 287 00:18:14,200 --> 00:18:17,800 user stories and you can link those two bugs and issues just 288 00:18:17,800 --> 00:18:20,300 like jira. But it's within the usual space. 289 00:18:20,300 --> 00:18:23,500 You can also get a copy of that for free and also the gra side 290 00:18:23,500 --> 00:18:25,800 you can get for free for a couple of people as well. 291 00:18:25,800 --> 00:18:30,000 So jump on the learn those products, understand Confluence 292 00:18:31,100 --> 00:18:33,600 and yeah, it's probably worth knowing a little bit around 293 00:18:33,600 --> 00:18:36,100 Trello. Cool. 294 00:18:36,900 --> 00:18:40,300 So they're all kind of yeah, I guess requirements management 295 00:18:40,300 --> 00:18:43,600 tools. There are there were other tools 296 00:18:43,600 --> 00:18:47,000 like rational Rose when I was growing up and there was also 297 00:18:47,100 --> 00:18:50,500 ea2 as Enterprise architect and you may see those. 298 00:18:50,500 --> 00:18:54,300 I think those tools are very intense, some organizations use 299 00:18:54,300 --> 00:18:57,000 them, especially if they've got a strong tag of architecture 300 00:18:57,000 --> 00:19:01,900 practice and so maybe just understand what those those are, 301 00:19:02,400 --> 00:19:07,600 the usually quite expensive and they Very, very much focused on 302 00:19:08,100 --> 00:19:11,300 how we used to do software development so you may not see 303 00:19:11,300 --> 00:19:14,200 those around as much especially in the agile space. 304 00:19:15,800 --> 00:19:18,500 Number five, we're talking about diagramming tools. 305 00:19:18,500 --> 00:19:22,100 And so I'm going to say to you that you do need to know how to 306 00:19:22,100 --> 00:19:25,500 use. Vizio, I went on a few be here 307 00:19:25,500 --> 00:19:27,400 is we're going to be listening to this podcast and they're 308 00:19:27,400 --> 00:19:31,300 literally, they're back is going to be, but I put up because I 309 00:19:31,300 --> 00:19:35,700 have said the word physio Vizio is an interesting product takes 310 00:19:35,700 --> 00:19:39,300 a while to get used to like quite a lot of the Microsoft 311 00:19:39,300 --> 00:19:42,000 Suite. However, it is actually very 312 00:19:42,000 --> 00:19:44,500 powerful and there are a lot of because you can eat at the 313 00:19:44,500 --> 00:19:46,900 stencils. So So easily you can make your 314 00:19:46,900 --> 00:19:50,000 own stencils, you can make and eat it Excel if you want to 315 00:19:50,000 --> 00:19:53,400 automatically create diagrams. Once you understand you get to a 316 00:19:53,408 --> 00:19:55,900 Tipping Point with Visio it is your friend. 317 00:19:56,300 --> 00:19:59,200 Yes it's a pain sometimes the connectors not looking good, 318 00:19:59,200 --> 00:20:02,400 just use the Buddy, change the connector to around one, you'll 319 00:20:02,400 --> 00:20:06,400 be okay but it is you know it is an Enterprise product and you 320 00:20:06,400 --> 00:20:09,500 should be really using in 20 of your men. 321 00:20:09,900 --> 00:20:11,600 We approach this bot Lane diagrams. 322 00:20:12,000 --> 00:20:16,200 It used to have a very high price tag you can Actually do 323 00:20:16,200 --> 00:20:18,900 you video documents for free now and you can actually edit them 324 00:20:18,900 --> 00:20:21,200 for free. So, no longer you've got that 325 00:20:21,200 --> 00:20:23,600 limitation of doing something in Visio, not being able to share 326 00:20:23,600 --> 00:20:27,000 the documents, that's not true, but if you do want to share it 327 00:20:27,000 --> 00:20:29,600 in someone, for whatever reason doesn't have access to the 328 00:20:29,600 --> 00:20:36,600 Microsoft Family, you can export it as a SVG which is a scaled 329 00:20:36,600 --> 00:20:41,700 Victor so you can show it in that form scar vectors A very 330 00:20:41,700 --> 00:20:45,000 good because they don't lose their quality as you scale them. 331 00:20:45,200 --> 00:20:49,900 The whole point but also you can check the, you know, you're 332 00:20:49,900 --> 00:20:54,500 working copy if you like into something like mural or mirror 333 00:20:54,500 --> 00:20:56,700 and then you can start with shopping on it and then make the 334 00:20:56,700 --> 00:20:59,500 changes later because you've users post, it's the kind of 335 00:20:59,500 --> 00:21:02,200 make changes on top of the image and then you can go back and do 336 00:21:02,200 --> 00:21:04,900 your Administration later. So videos are kind of a 337 00:21:04,908 --> 00:21:08,200 must-have is there are other tools if you want. 338 00:21:08,400 --> 00:21:13,300 So it is free. Now in terms of its web version, 339 00:21:14,600 --> 00:21:16,500 which is As good as anything else out there. 340 00:21:18,200 --> 00:21:22,700 And if you have Microsoft Microsoft 365, the other 341 00:21:23,000 --> 00:21:27,200 alternative of course, is that you can jump into the Google 342 00:21:27,200 --> 00:21:30,800 family. They have one at the name is 343 00:21:31,000 --> 00:21:33,200 popped out of my head for a second but it's not. 344 00:21:33,500 --> 00:21:37,400 I know it's not great but draw.io is very popular. 345 00:21:37,400 --> 00:21:41,300 So if you want a free, one draw.io would be the way to go 346 00:21:42,100 --> 00:21:45,100 and you really want a tool that you can export and import. 347 00:21:45,200 --> 00:21:48,600 Put into the 0 if you needed to. So I think that would be your 348 00:21:48,600 --> 00:21:51,700 requirement. There, you have to understand 349 00:21:51,700 --> 00:21:56,700 those diagramming tools as we've talked about and some blog and 350 00:21:56,700 --> 00:22:00,600 on LinkedIn. There is AI diagramming coming 351 00:22:00,600 --> 00:22:03,500 very soon and they're kind of linking to the white building 352 00:22:03,500 --> 00:22:06,100 tools. So we might find there's a 353 00:22:06,108 --> 00:22:08,100 mash-up between the white building tools in the 354 00:22:08,100 --> 00:22:11,800 diagramming tools become one at the moment. 355 00:22:11,800 --> 00:22:15,800 I don't think there's anything even in mural or Bureau That's 356 00:22:15,800 --> 00:22:20,800 really as good as an advanced I guess is I wouldn't say is good 357 00:22:20,800 --> 00:22:24,900 but as advanced as Visio for rapidly creating diagrams, so I 358 00:22:24,908 --> 00:22:28,800 haven't ridden off completely. However, for simple diagram you 359 00:22:28,800 --> 00:22:31,700 can come up with your templates and actually use those 360 00:22:31,700 --> 00:22:36,300 whiteboarding tools of you really want to Sorry that leaves 361 00:22:36,300 --> 00:22:40,300 us to. That's the kind of begin to 5 in 362 00:22:40,300 --> 00:22:43,100 terms of tools. And so we going to jump down to 363 00:22:43,200 --> 00:22:47,300 the last or here. Number four might be 364 00:22:47,300 --> 00:22:50,400 controversial. I'm going to suggest that you 365 00:22:50,400 --> 00:22:53,400 should understand what SQL has. Okay. 366 00:22:53,400 --> 00:22:56,400 You should understand. It's the language used query 367 00:22:57,000 --> 00:23:00,700 data from a database. You should have some idea 368 00:23:00,900 --> 00:23:05,800 release be able to generally understand how Here comes out of 369 00:23:05,808 --> 00:23:09,700 a database and SQL is the language we use to do that 370 00:23:09,700 --> 00:23:13,900 generally. And so by having some knowledge 371 00:23:13,900 --> 00:23:17,000 of getting what you need out of a database that can mean that 372 00:23:17,000 --> 00:23:20,900 you can do some data analysis, that might need to do might need 373 00:23:20,900 --> 00:23:24,100 to do. I'm going to be talking about 374 00:23:25,000 --> 00:23:28,900 other products soon, but specifically just having a basic 375 00:23:28,900 --> 00:23:33,300 understanding of of getting data from a table, I think you should 376 00:23:33,300 --> 00:23:36,800 know as a ba, I think. If you don't know, if you could 377 00:23:36,800 --> 00:23:38,200 say it's a should have requirement. 378 00:23:38,200 --> 00:23:42,900 I think you should, you should go on to w3schools and learn 379 00:23:42,900 --> 00:23:48,600 about SQL for free. You can generally get a database 380 00:23:48,600 --> 00:23:53,500 for nothing MySQL. For example, load that up and 381 00:23:53,500 --> 00:23:57,300 have a play around. Also included in there. 382 00:23:57,300 --> 00:24:01,400 I am going to suggest that HTML and CSS, or at least what they 383 00:24:01,400 --> 00:24:07,600 are HTML is what websites we pages are made out of Of and CSS 384 00:24:07,600 --> 00:24:11,300 is the style sheet. The look and feel of the page 385 00:24:11,500 --> 00:24:15,400 and JavaScript is kind of the most common front end. 386 00:24:16,700 --> 00:24:20,000 Scripting language, for lie, hiding showing things and kind 387 00:24:20,000 --> 00:24:23,400 of program at the front end and linked. 388 00:24:23,400 --> 00:24:26,000 I guess that's linking to a family of basic programming. 389 00:24:26,000 --> 00:24:32,800 So if my notes Here, say SQL could have HTML JavaScript and 390 00:24:32,800 --> 00:24:36,700 basic programming having some Knowledge of that and we had a 391 00:24:36,700 --> 00:24:39,300 recoded, a high level will make you a better. 392 00:24:39,300 --> 00:24:44,500 Be a it also, it's also amazing that if you pick up one of those 393 00:24:44,500 --> 00:24:47,100 skills, when you're on a project, you can actually help 394 00:24:47,100 --> 00:24:52,000 out and get things across the road across the line or start to 395 00:24:52,000 --> 00:24:56,400 help your users understand how their applications work of you 396 00:24:56,400 --> 00:25:00,200 have knowledge of these basic it functions. 397 00:25:01,800 --> 00:25:06,200 Iva to number three. And and this is very much 398 00:25:07,000 --> 00:25:10,500 opinion here. I think it's really important to 399 00:25:10,500 --> 00:25:15,900 understand what cloud integration Platformers. 400 00:25:15,900 --> 00:25:18,700 And when I say cloud, integration sweets, I'm not 401 00:25:18,700 --> 00:25:22,800 talking about necessary AWS or is your or something, 402 00:25:22,800 --> 00:25:26,200 complicated, technically at that level until about what's built 403 00:25:26,200 --> 00:25:29,200 on top of it. So I'm talking about tools like 404 00:25:29,200 --> 00:25:32,300 zapier. And make.com. 405 00:25:32,300 --> 00:25:36,200 So if you haven't played with these tools, sign up for as a 406 00:25:36,200 --> 00:25:41,400 prayer cap as a account or make.com, and what these tools 407 00:25:41,400 --> 00:25:47,000 allow you to do is connect to existing apps that have an API 408 00:25:47,200 --> 00:25:49,800 or and a connector built for these platforms. 409 00:25:50,100 --> 00:25:52,700 And you can take information from one system and you can 410 00:25:52,700 --> 00:25:56,000 integrate it with another and vice versa, or you can trigger 411 00:25:56,500 --> 00:25:59,700 events happening one EMD and you can send notifications to 412 00:25:59,700 --> 00:26:05,000 another application. Microsoft has, I think it's cold 413 00:26:05,000 --> 00:26:07,500 used to be called flow, Microsoft flow that they may 414 00:26:07,500 --> 00:26:09,800 have changed. The name recently to say power 415 00:26:10,100 --> 00:26:13,300 automate, I think it is called now which does something very 416 00:26:13,300 --> 00:26:17,500 similar within the Microsoft Dynamics Power Platform family 417 00:26:18,300 --> 00:26:21,100 which can take information from Excel and then can, you know, 418 00:26:21,300 --> 00:26:24,500 read all the names and send an email out. 419 00:26:25,300 --> 00:26:27,300 Please have a look at these tools. 420 00:26:27,300 --> 00:26:30,400 It you would say it's probably integration. 421 00:26:30,600 --> 00:26:35,100 Use the be the most expensive kind of kind of project that you 422 00:26:35,100 --> 00:26:37,700 would need to worry about because it's quite complicated 423 00:26:37,700 --> 00:26:40,400 to send information by it. What we called, by directly, one 424 00:26:40,400 --> 00:26:43,800 way, and Back Again, from one system to another, and you have 425 00:26:43,800 --> 00:26:47,900 to worry about lots of logic behind their, these tools don't 426 00:26:47,900 --> 00:26:49,700 necessary, get rid of that problem. 427 00:26:49,700 --> 00:26:54,600 But they are built very light drag and drop style so you can 428 00:26:54,600 --> 00:26:59,400 easily, you know, send information from one system to 429 00:26:59,400 --> 00:27:03,500 another Easily, and they usually subscription-based like $20 a 430 00:27:03,508 --> 00:27:07,400 month and usually paying for the number of transactions that are 431 00:27:07,400 --> 00:27:10,500 happening. Or these steps with a new 432 00:27:10,500 --> 00:27:14,900 integration that happening check out zapier make.com as your 433 00:27:14,900 --> 00:27:19,100 starter, it's amazing. Actually, some of these tools 434 00:27:19,700 --> 00:27:27,200 you may have heard of ift. If then, if then, then that I 435 00:27:27,200 --> 00:27:30,400 can't, I can't remember the acronym, but it's kind of like, 436 00:27:30,500 --> 00:27:34,600 What home automation is used a platform that you can use for 437 00:27:34,600 --> 00:27:39,900 home automation and what things like Alexa and your Google 438 00:27:39,900 --> 00:27:42,400 Assistant can do. So it's kind of like, you know, 439 00:27:43,000 --> 00:27:46,100 to my kettle on. And so when you receive the word 440 00:27:46,100 --> 00:27:49,400 cartoon kettle on, then turn on the kettle. 441 00:27:49,900 --> 00:27:53,000 And so that uses something very, very uses exactly the same kind 442 00:27:53,000 --> 00:27:58,200 of concept or science behind it, which is your one application is 443 00:27:58,200 --> 00:28:01,700 connecting to another and asking that that Wi-Fi device, for 444 00:28:01,700 --> 00:28:05,700 example, to turn on and so they're very similar to 445 00:28:05,700 --> 00:28:09,600 understand those as a ba, you know, integrating those systems, 446 00:28:09,600 --> 00:28:13,100 or steps within two processes, which may be working in 447 00:28:13,100 --> 00:28:16,200 different systems or different workflows is. 448 00:28:16,300 --> 00:28:18,900 You know, as we, you can get a lot of continuous Improvement, 449 00:28:18,900 --> 00:28:25,100 so it's with understanding that and there and moving quickly on 450 00:28:25,100 --> 00:28:28,700 to number two. The reason I bought this at 451 00:28:28,700 --> 00:28:33,500 number two is because data Science has become the thing and 452 00:28:33,500 --> 00:28:36,700 the last five years. And so, you know, you staff 453 00:28:36,700 --> 00:28:39,500 report writers. I remember doing a Crystal 454 00:28:39,500 --> 00:28:45,100 Reports, whatever it was 7 or 13, cause when I first started 455 00:28:45,100 --> 00:28:47,800 an it, and I understood how to use a reporting tool. 456 00:28:48,200 --> 00:28:52,700 Now we've, you know, with the invention of machine learning 457 00:28:52,700 --> 00:28:56,300 and Ai and using data and lakes, and all these complicated 458 00:28:56,300 --> 00:28:58,900 things, you don't actually need to understand today. 459 00:28:58,900 --> 00:29:00,400 Maybe it's something that you're interested. 460 00:29:00,600 --> 00:29:03,700 Then what I was going to say is I think you need to understand 461 00:29:03,700 --> 00:29:10,600 at least a couple of reporting tools and the most popular tools 462 00:29:10,600 --> 00:29:14,200 that are out there to Mark the moment, power bi. 463 00:29:15,100 --> 00:29:19,000 So bi being, you know, business intelligence but Power bi is a 464 00:29:19,000 --> 00:29:23,400 way in which you can report on information. 465 00:29:24,000 --> 00:29:26,400 So consume information and display it. 466 00:29:27,700 --> 00:29:33,400 You can also try transform that information and mash it up and 467 00:29:33,400 --> 00:29:36,600 drill down on it. And also tabula is the other 468 00:29:36,600 --> 00:29:38,600 one. I think I'm pretty sure that's 469 00:29:38,600 --> 00:29:40,800 open source. Release cheaper than power bi 470 00:29:42,200 --> 00:29:46,500 and you can and that's more of a programming base that little bit 471 00:29:46,500 --> 00:29:52,300 less then power. Bi Now, power bi is it's not a 472 00:29:52,300 --> 00:29:55,200 product that you can just sit down and learn it, but like, 473 00:29:55,200 --> 00:29:58,500 Microsoft Project you have to spend time learning it. 474 00:29:58,700 --> 00:30:01,800 So what I'm going to suggest is If you want to understand what 475 00:30:01,800 --> 00:30:03,800 I'm talking about, if you want to understand what a data model 476 00:30:03,800 --> 00:30:08,700 is, and joining databases and, you know, displaying data from a 477 00:30:08,700 --> 00:30:12,300 data source, I would suggest then load up Excel and within 478 00:30:12,300 --> 00:30:15,300 Excel. Now, there is something called 479 00:30:16,800 --> 00:30:20,700 well, there's power query but there's also, yeah. 480 00:30:20,800 --> 00:30:22,900 Power query is probably your best starting point. 481 00:30:22,900 --> 00:30:27,800 And power query is free and it's like a mini power, bi so allow 482 00:30:27,800 --> 00:30:30,300 you to experience. What? 483 00:30:30,500 --> 00:30:34,800 Power bi does but on a small scale and you can start to 484 00:30:34,800 --> 00:30:37,900 connect data sources. So basically pull data in to 485 00:30:37,900 --> 00:30:40,700 your data model and you can start joining those tables 486 00:30:40,700 --> 00:30:44,600 together and explore data, and start producing reports that 487 00:30:44,600 --> 00:30:48,000 you're in uses. See have some knowledge of these 488 00:30:48,000 --> 00:30:51,600 tools understand that they can collect information from 489 00:30:51,700 --> 00:30:55,200 anywhere. So there that display layer. 490 00:30:55,400 --> 00:31:00,100 A lot of I was there was a time about ten years ago that every 491 00:31:00,100 --> 00:31:03,600 single Project or main programs on was almost single source of 492 00:31:03,600 --> 00:31:07,500 Truth or one place to view data into the way we used to do that. 493 00:31:07,500 --> 00:31:09,800 Of course, was having these reporting tools that were 494 00:31:09,900 --> 00:31:13,500 pulling data from a data warehouse, but these tools can 495 00:31:13,500 --> 00:31:15,000 actually talk to you individual apps. 496 00:31:15,000 --> 00:31:17,400 So this is a way of Measuring Up data so you can actually get 497 00:31:17,400 --> 00:31:20,500 some of those reporting requirements done quite easily 498 00:31:21,300 --> 00:31:23,500 with these tools. So understanding what they do at 499 00:31:23,500 --> 00:31:29,800 least is a good starter and that finally moves us to number. 500 00:31:30,700 --> 00:31:36,500 One the number one tool that a better ba needs to know and and 501 00:31:36,500 --> 00:31:41,900 I'm going to stress the level in which I want you to understand 502 00:31:41,900 --> 00:31:45,700 here and that number one tool is our favorite Excel. 503 00:31:46,300 --> 00:31:51,800 So Excel also, I'll bring into that Google Sheets, which is the 504 00:31:52,000 --> 00:31:57,400 free Google version of it. Actually of late. 505 00:31:57,400 --> 00:31:59,900 I got a new laptop and it doesn't have office on it. 506 00:31:59,900 --> 00:32:03,200 I can get around. Take pictures, hang it and holy 507 00:32:03,200 --> 00:32:05,800 moly. In am not having Excel on you 508 00:32:06,300 --> 00:32:08,700 computer as a PA is very frustrating. 509 00:32:09,000 --> 00:32:11,800 So I have been using sheets and I can do some of the things that 510 00:32:11,800 --> 00:32:15,300 I need to do an Excel but Excel, primarily you need to understand 511 00:32:15,300 --> 00:32:17,800 it, you need to understand everything around Google 512 00:32:17,800 --> 00:32:21,300 workplace and on an office or what's now called. 513 00:32:21,300 --> 00:32:25,900 Mark soft 365. Including teams and chat and all 514 00:32:25,900 --> 00:32:28,600 those good things. But specifically, when it comes 515 00:32:28,600 --> 00:32:33,900 to Microsoft, Axl the level in which you need to know Excel as 516 00:32:33,900 --> 00:32:39,500 a b, a is not basic, okay? If you know anyone in a finance 517 00:32:39,500 --> 00:32:41,500 team they will know Excel pretty well. 518 00:32:41,500 --> 00:32:44,000 Okay though understand her do pivot tables do understand how 519 00:32:44,000 --> 00:32:47,000 to do vlookups. The line doesn't stand how to do 520 00:32:47,000 --> 00:32:50,200 graphs they'll understand how to connect data. 521 00:32:50,900 --> 00:32:54,800 That's the level that you need to know at a basic level as be 522 00:32:54,800 --> 00:32:56,700 a. So you none don't need it. 523 00:32:56,700 --> 00:33:00,200 If you don't know what a vlookup is, You know, you're not at the 524 00:33:00,200 --> 00:33:02,000 level. You need to be at there are lots 525 00:33:02,000 --> 00:33:06,000 of free courses online. I'm pretty sure you can probably 526 00:33:06,000 --> 00:33:09,900 get a trial version of excel if you needed to or a cheap version 527 00:33:10,000 --> 00:33:13,900 just go online and look for, I don't know, an old version of 528 00:33:13,900 --> 00:33:19,300 office key that you can probably get like, five, ten dollars and 529 00:33:19,300 --> 00:33:22,600 install the, the old version of office and start playing with 530 00:33:22,600 --> 00:33:27,700 Excel, that it really hasn't evolved too much in the future 531 00:33:27,700 --> 00:33:31,600 and like where it is now. It will evolve with AI, but to 532 00:33:31,600 --> 00:33:35,000 be honest, you can do all those basic formulas like adding sales 533 00:33:36,200 --> 00:33:38,500 doing. Like I said, vlookup is a very 534 00:33:38,500 --> 00:33:44,700 popular item doing a pivot table importing data, mashing it up. 535 00:33:45,600 --> 00:33:49,100 I would say it's the number one tall and tunes of piece of 536 00:33:49,100 --> 00:33:55,200 software that you as a ba probably it's just assumed you 537 00:33:55,200 --> 00:33:58,600 know it. So if you don't know Excel, go 538 00:33:58,600 --> 00:34:00,000 out. I know you might not sound 539 00:34:00,000 --> 00:34:03,800 exciting but you should know Excel to a certain advanced 540 00:34:03,800 --> 00:34:07,700 level. So let's just recap what we 541 00:34:07,700 --> 00:34:09,699 covered. So I've said a number 10, kind 542 00:34:09,699 --> 00:34:16,300 of chat GPT and open a iron. Look Leo titles 9, we had white 543 00:34:16,300 --> 00:34:20,800 building tools like mural or Miro and berate we had erps and 544 00:34:20,800 --> 00:34:23,000 crms both big and small versions. 545 00:34:23,300 --> 00:34:26,300 Number 7, we had content Management Systems like 546 00:34:26,300 --> 00:34:29,600 WordPress. Silver stripe, for example, in 547 00:34:29,600 --> 00:34:32,199 New Zealand, which a lot of government departments. 548 00:34:32,199 --> 00:34:37,800 Use number six, we talked about grr and the family within that, 549 00:34:37,900 --> 00:34:43,300 which included Confluence and Trello or Microsoft Azure devops 550 00:34:43,900 --> 00:34:50,199 5 Vizio understand Vizio or draw.io or both while primarily 551 00:34:50,199 --> 00:34:54,900 both or I'm suggesting, you should have a least, a readable 552 00:34:54,900 --> 00:35:01,000 knowledge of SQL. And probably HTML CSS, and 553 00:35:01,000 --> 00:35:03,600 JavaScript and some basic programming language. 554 00:35:03,800 --> 00:35:05,700 But good place for you to learn three. 555 00:35:05,700 --> 00:35:09,400 I'm talking about Cloud integration sweets, like as a 556 00:35:09,400 --> 00:35:12,700 peer and make.com and the fact that you can integrate systems 557 00:35:12,700 --> 00:35:14,700 together. Power automate is within that 558 00:35:14,700 --> 00:35:17,100 list. Number two, I'm saying reporting 559 00:35:17,100 --> 00:35:19,300 because data science is so massive. 560 00:35:19,300 --> 00:35:22,000 At the moment, you should understand what a data model is 561 00:35:22,300 --> 00:35:24,900 and how to report on data and how these tools work, like 562 00:35:24,900 --> 00:35:29,200 power, bi and tabular. And number one, To the number 563 00:35:29,200 --> 00:35:32,000 one tool that a better business analyst needs to understand at 564 00:35:32,000 --> 00:35:36,500 an advanced level is Excel. And I would say Google Sheets, 565 00:35:36,500 --> 00:35:40,500 which is the Google alternative to Microsoft. 566 00:35:41,000 --> 00:35:42,300 So I hope you got value out of the. 567 00:35:42,300 --> 00:35:44,900 If you don't understand. We haven't learned any of those 568 00:35:44,900 --> 00:35:47,200 products or tools, add it to your list. 569 00:35:47,200 --> 00:35:49,400 Your action item is to take one of those areas. 570 00:35:49,400 --> 00:35:54,800 You don't know that well and to learn about it this week.