How to Understand Big Data with BigQuery

29 July 2020

Understanding Big Data with BigQuery

 

The way we collect, collate, and analyze data has drastically changed in the last 5 years. Gone are the days when we crammed servers and more servers into our office buildings to hold our information. Cloud computing brought with it a radical change in thinking about the way we collect and visualise the information we hold. Organisations want to know how to understand the data they have and how they can use this data to give themselves a competitive advantage. 

data analysis image

Take the example of Retail. Retailers want to understand: buying patterns and behaviours; who to target at a given time and in what geographic area. Concepts like Data Warehousing, ML, AI and specific products like Google BigQuery are designed to help with that exact business case – by being able to collect and store data about the customer behaviours and analyse it in seconds allows organisations to react fast, and given themselves a competitive advantage in any market. After all, data is the most valuable asset on the planet.


Our question to organisations today is: Are you using your data to your advantage, and if not, what is stopping you?


 

Businesses are realising the power of data to predict future spending patterns, analyse spending cycles and understand geographical patterns in consumer behaviour. By using analytical tools and AI we can also ensure that if we are to enter times of uncertainty again, we can initiate and ensure our business continuity plans are in line with the insights our data has provided us. Google is often considered the market leader in data analytics capabilities, with a specific focus on its solution, BigQuery. BigQuery is your enterprise data warehouse, fully managed and completely serverless with built-in machine learning capabilities and is at the forefront of the innovative organisations that are using analytics to gain competitive advantage. Providing usable and easy to digest information is a must and BigQuery can run analytics at scale with 26%–34% lower three-year TCO than cloud data warehouse alternatives. Being resilient, scalable and cost-effective has provided customers with faith in Google Cloud services and there are many more benefits to this solution, click here to understand more about BigQuery. 

What we want to understand is the use of BigQuery, some real-world data scenarios where companies have invested and had a tangible return by using this service to collect and understand the data they receive, and how partners like Netpremacy can assist you. 

So with this in mind, let’s look at the example of how Enterprise organisations with multinational functions are using Google Cloud and Big Query. UPS are world-leading distribution organisation with a global footprint, but the perspective of their operations is definitely needed to understand the scale of this operation:


• Every day, UPS delivers 21 million packages in more than 220 countries worldwide. During the all-important holiday season, the number of packages delivered per day can reach its peak.

• The drivers who make that possible perform 120 pickups and dropoffs daily.

• The number of possible routes each driver can take from stop number one to stop number 120 is unthinkably large at 199 digits.


 

UPS set out to use Google Cloud Platform (GCP) to design routing software that saved them on average $400 million per annum. GCP provided the platform scalability and security and BigQuery provided the machine learning to fundamentally change their operations in line with their data insights. The information they gained from that data help inform UPS on how to load delivery vehicles, make more targeted operations adjustments, and minimize forecast uncertainty, especially around the holiday seasons. Ultimately helping the organisation deliver more packages at a lower cost which in turn maximised their ROI. 

Although the process of moving to the cloud, or setting up a data warehouse with BigQuery may sound daunting, Netpremacy are here to help. We can be your trusted advisors and partner throughout the whole process – from the initial stages exploring Google Cloud Platform services; to the commercial, deployment and aftercare of workloads. We help optimises spend throughout to ensure you are utilising your Google Platform at peak efficiency. Many data strategies start small and leverage the scale and power of Google to grow. No matter the size of the data you house, the information you gain will continue to grow. So even though most organisation’s data is not on the Petabyte scale, Big Data definitely starts with collecting lots of Small Data, and analysing that data to gain valuable insight is vital for organisations to move forward ahead of their competitors.

 


If you could analyse data, fast, concisely, with zero operational overhead and a helping hand from a Google Premier Partner, why wouldn’t you?


 

We are running a number of data related webinars over the course of July 2020, for our current customers and to organisations that want to find out further information surrounding Big Data and BigQuery. No matter the vertical or size of your organisation, data-driven strategies are vital to the success of your business in new and digital environments that we now face more than ever. Get in touch with our teams today. Or contact amunroe@netpremacy.com

30 January 2019

Keep your company’s data secure

Unfortunately, it is almost impossible to prevent your employees’ devices being lost or getting stolen from time to time. These things happen. However, it does not have to be such a worry when things like this do happen.

G Suite keeps your company’s data secure with mobile device management (MDM) policies. With basic management, you can ensure that mobile devices require screen locks and/or strong passwords on your employees’ devices, keeping your corporate data secure. In addition, G Suite allows you to erase confidential business data with device wipe, or selected account wipe for Android or iOS. This feature also allows you to wipe corporate information from devices if they have been lost or stolen. You can see the list of devices that are accessing corporate data in the Google Admin console.

Google Mobile Management means that you can manage, secure and monitor all mobile devices that are in your organisation. It is possible to manage a range of devices, including phones, tablets, and even smartwatches. People are still able to use their own personal devices for work (BYOD) as you will be able to wipe their corporate accounts on their devices, should the worst happen.

So, how does G Suite protect my data?

When you decide that you would like to store your data with G Suite, it is then protected in a number of different ways. This includes advanced phishing detection with the aid of machine learning, authentication with security key enforcement and also prevention of data leakage.

Due to G Suite being a 100% cloud-based system it means you can be protected from attacks such as Ransomware, viruses, and malware. There is no need to install a separate system for spam processing because Gmail uses Machine Learning to automatically filter any spam and to scan all emails for suspicious and dangerous content.  The G Suite administrator can also control all attachments sent and received by your organisation so that nobody opens or sends anything that they shouldn’t.

2 Step Verification keeps your data secure  

Using 2-Step Verification (2SV) provides users with a better option to secure their accounts. As well as 2SV over an encrypted connection, users can also block unauthorized access to their accounts with Google Prompt that delivers real-time prompts, telling the user when they have logged into a device.

This update comes through as a pop-up notification on the Google app. This allows users to answer “yes” or “no” when asked, “are you logging in?”

Automatic rules

There are now new device rules for Mobile Management, which allows G Suite admins to define custom rules that create triggers for certain actions or events. For example, if somethingoccurs on one of your company’s devices that’s been specified in a custom rule, the corresponding action that’s been set will automatically be carried out. Some of these rules include;

  • Approve select mobile devices when the device is enrolled.
  • Block access to corporate data if a specific app is installed.
  • Block access to account/wipe the device if the user has more than 5 failed screen unlock attempts.
  • Block access to/wipe the account if there is suspicious activity found on the device.

3rd party app control

Google can also protect your data against phishing attacks. Google provides 3rd party control with OAuth apps whitelisting. This gives your company extra control over 3rd party applications that have access to your data. It is now possible for admins to specifically select which apps can have access to which users G Suite data. This keeps your data safe as it is ensuring that your users don’t accidentally grant access to apps that may be malicious.

How can Netpremacy help?

Our support team are highly skilled and have the knowledge needed to answer any questions you may have about your companies security, and how you can further improve it. If you have any questions regarding security, please feel free to contact us here.