Video Post: AI with BigQuery and SQL

Stop waiting to unlock the power of AI! 🤯 You already know SQL… and that’s ALL you need. Transcript if you have a lot of data stored on  Google Cloud for analytics it’s probably  going to be stored in B query now  everyone’s trying to do Ai and their  training models using pre-existing  models spending a lot of money on data  scientists but I’ve got some great news  if you’re using be query be query has be  query ml built into it this lets you run  AI against your B query data set by  using SQL now SQL is the language used  by all the people doing queries or  database administrators now it’s very  simple to use and you probably already  have the skills so you don’t need to go  and hire expensive data scientists and  AI Engineers to gather insights from  your data I’m going to break down some  of the models that are built into B cre  ml to see if these are going to solve  business problems for you first one is  linear regression this is predicting how  much you’ll sell based on past data so  if you’re planning stock Staffing trying  to run promotions more accurately this  is for you it’s built- in can be run  with sequel the next one is logistic  regression this is sorting things into  categories so let’s say you want to sort  customers into categories um to see  whether they’re going to buy from you  again um or if products are faulty  putting them into categories saying  these products are likely going to be  faulty so you can see the use cases for  business the next one is K means  clustering this finds hidden groups  within your customer base so you can  Target marketing campaigns towards them  the next Matrix factorization suggesting  which customers might be likely to buy  an it this is kind of what you’ll see  when you get predictive things on  websites saying and you might also like  to buy X I think we’re up to the fifth  one PCA or principal component analysis  this is simplifying complex data to find  the most important pattern helping you  spot Trends and make more informed  decisions the last one I’ve got is time  series so predicting future sales based  on past data helping you predict demand  and make sure you have enough stock  based on things that have happened in  the past so all of these models are  already build into big query ml as I  said and can be accessed using SQL  queries which you likely already have  the skills for in your organization to  enabling your organization to make AI  enabled decisions without spending an  absolute Fortune if you want help with  any of this Reach Out aviat Consulting  can help you thanks   – Generated with https://kome.ai

Video Post: Google Cloud Vertex AI & Hugging Face

Who Really Owns Your App? Transcript did you know that most app developers in Australia don’t let you own the IP that they develop for you let me break that down for you you pay someone to write an app for you they let you use it licensed to use it commercialize it change it but you don’t actually own the intellectual property now what would happen if someone else had a similar idea to you went to the same app developer they could sell the code that you paid them to develop this other person doubling their money the next day all they need to do is change the colors and logo maybe make a few slight changes and you’re going to have a competitor now the app developers made a ton of cash on this cuz they’ve sold the same thing twice and only done the work once but you’ve got a competitor that’s going to compete with you and I don’t think that’s really fair and that’s not what we do at aviato at aviato if you pay us to develop your app you own the intellectual property we aren’t going to steal it and use it elsewhere and we’re not going to sell it to a competitor a few days after we finish your project so that then you have someone to compete with in the marketplace if you are looking to get an app developed this is really something that you should be checking with the app developer that you’re going to use reach out to us if ou do want to get an app developed Thanks

Video Post: Don’t hire a team of developers

Don’t Hire A Team of Developers Transcript so you’re looking to get a mobile app built and you need to hire a team of developers I’m Ben from Aviato Consulting and I’m gonna tell you why that’s not the best way to do things if you have a great app idea but lack the in house expertise you can build a development team from scratch but it’s super expensive you need a user interface designer to help your apps look good you need a front end developer to actually build the frontend of the ad and a backend developer to talk to any databases or APIs and then you’re probably gonna need a fourth person to oversee the first three by the time you hire those people I think I can have your app released maybe not fully finished but at least released for a fraction of the cost this is where we excel we’re flexible on demand development team you pay us monthly and you can cancel it anytime we’re literally developers as a service from my experience working at Google it made sense to specialise in deploying our apps on Google Cloud as well that means the app you get is powerful secure and reliable we also write all of our apps in flutter again by Google which means we write the code a single time and deploy that to web, Android and iOS cutting down the development time and cost so to summarize with us you get speed we understand the pressure launch quickly and our streamline process gets your app to market fast host effectiveness you only pays the development hours you need known as enter into long term contract and you get our Google Cloud expertise making sure the app is scalable secure and reliable

Video Post: Cut Your App Development Costs In Half

So you want to cut your app development costs in half? Transcript so you’re looking to get a mobile app built and you need to hire a team of developers I’m Ben from Aviato Consulting and I’m gonna tell you why that’s not the best way to do things if you have a great app idea but lack the in house expertise you can build a development team from scratch but it’s super expensive you need a user interface designer to help your apps look good you need a front end developer to actually build the frontend of the ad and a backend developer to talk to any databases or APIs and then you’re probably gonna need a fourth person to oversee the first three by the time you hire those people I think I can have your app released maybe not fully finished but at least released for a fraction of the cost this is where we excel we’re flexible on demand development team you pay us monthly and you can cancel it anytime we’re literally developers as a service from my experience working at Google it made sense to specialise in deploying our apps on Google Cloud as well that means the app you get is powerful secure and reliable we also write all of our apps in flutter again by Google which means we write the code a single time and deploy that to web, Android and iOS cutting down the development time and cost so to summarize with us you get speed we understand the pressure launch quickly and our streamline process gets your app to market fast host effectiveness you only pays the development hours you need known as enter into long term contract and you get our Google Cloud expertise making sure the app is scalable secure and reliablehttps://www.youtube.com/watch?v=Mi8lqBGz73Y Transcript so you’re looking to get a mobile app built and you need to hire a team of developers I’m Ben from Aviato Consulting and I’m gonna tell you why that’s not the best way to do things if you have a great app idea but lack the in house expertise you can build a development team from scratch but it’s super expensive you need a user interface designer to help your apps look good you need a front end developer to actually build the frontend of the ad and a backend developer to talk to any databases or APIs and then you’re probably gonna need a fourth person to oversee the first three by the time you hire those people I think I can have your app released maybe not fully finished but at least released for a fraction of the cost this is where we excel we’re flexible on demand development team you pay us monthly and you can cancel it anytime we’re literally developers as a service from my experience working at Google it made sense to specialise in deploying our apps on Google Cloud as well that means the app you get is powerful secure and reliable we also write all of our apps in flutter again by Google which means we write the code a single time and deploy that to web, Android and iOS cutting down the development time and cost so to summarize with us you get speed we understand the pressure launch quickly and our streamline process gets your app to market fast host effectiveness you only pays the development hours you need known as enter into long term contract and you get our Google Cloud expertise making sure the app is scalable secure and reliable

Video Post: Nobody gives a shit about cyber security

Nobody Gives A Shit About Cyber Security Transcript nobody gives a shit about cyber security honestly nobody care I think partly it’s cause the messaging is terrible but cyber security experts tell us what to do but they don’t really explain why and what they tell us to do is hard to do it’s cumbersome and time consuming hopefully I can fix that the No. 1 thing everyone tells us to do is to enable multi factor authentication now every time you sign in having to get an SMS code or use your authenticator app to get a code slows you down it’s just annoying introducing the hardware security key so not many people speak about or use these devices I plug this into my laptop and every time I log in I simply touch it it takes a second this means that anyone trying to hack me would need my password and would need to get this now that’s not impossible hackers could come to my house and take it but we have the police for that and that’s much more difficult and time consuming than sending out a fishing email this one thing will protect you against most cyber attacks if you click the link in a fishing email they might get your password but they’re not gonna get this very very simple security effortless to employ and it doesn’t take any extra time the next one is using a password manager so everyone wants to have 1 password for everything so if you use that password for everything that’s great super simple but let’s say you use your password to book a haircut at your hairdresser and my barber’s okay with cutting hair he’s probably terrible with cybersecurity if he gets hacked the hackers are gonna have my email address and my password that’s used everywhere they’re gonna go from there directly into my email and then probably try to get into my bank using a password manager means that I have one password that unlocks my password manager and then it types all of my passwords for me so all of my passwords apart from the one that I need to remember a super complex 20 something characters streams of numbers letters and characters on my phone and my computer I have my password manager installed half the time I log into that and it types all my passwords for me so actually saves me time these two things are pretty much the main point that will stop you from getting hacked if you do want any other help especially if you want a cloud security order for your business on your cloud reach out to Aviato Consulting will happily help you with that one but try these as well this one’s called a UBQ you can Google it it costs about $100 and will save you a ton of headache thanks

Video Post: Getting Started With Google Cloud

Getting Started With Google Cloud Transcript getting started with Google Cloud can seem overwhelming at first as with any cloud there are a lot of services that you can use and each has configuration options that can get you into trouble when I worked at Google Cloud I helped some of the biggest brands in Australia set up their cloud environments and I’ll give you a few tips that I learnt from doing that the first thing you wanna do is enable some structure trading an organisation and then creating folders in the organisation to keep projects organised and allow to give groups of users permissions to do things to those projects for example putting all the development projects in a folder called development and giving developers access to those and then having all of the production projects in a production folder maybe without access for developers or for other groups of people once you have the folder set up you need to set up identity and access management so as I kind of touched on that’s creating a group putting developers in the group and then giving that group access to the folder that contains the projects that developers need to work on to do their jobs we may not wanna give them access to the production folder at all or maybe we only give them read only access this is a super simple example and we can nest folders and get much more complex with it and any environment that we’re talking about is gonna have more complexity than that this is a simple explanation now we wanna start talking about organisational policies we’ve got a group of developers that got access to their projects and development folder that we still don’t wanna do anything silly like putting a cloud storage bucket on the internet so that anyone can see what our files are even if those are development mocked data having a data breach is not gonna be good in the headlines there’s a ton of all policies and each one of them needs to be configured and this one example appear for the cloud storage bucket we may need an exception for the public facing internet to be on the internet once we have all this set up we kinda wanna make sure that we’re managing with code if a developer does request that a cloud storage bucket be put on the internet we wanna see who requested that and why and track those changes the logical step here is using infrastructure as code we use Terraform the same as the best practice at Google Cloud that Google had professional services used when I was there and we can do the same for your business in 5 days excluding any complex networking some people are spending much longer on this and it’s really not that complex if this sounds too complex do reach out we’ve done this when working at Google so we know the best practices and we know how to set you up securely so that your business can scale on Google Cloud thank you

Aviato Consulting unlease the best of Google technology on your business problems.

Founded by ex-Google Cloud Consultant, and leaders to help you revolutionise your industry.

Contact us
Book a meeting, or follow us on socials below.

Australia, Aviato Consulting Pty Ltd, 59 Parry St, Newcastle 2300 +61 2 6188 9111

@2024 copyright by aviato consulting. all rights reserved