Google Gemini 2.0 Flash brings Python power to business analysts

Anyone who has had a job that required intensive amounts of analysis will tell you that any speed gain they can find is like getting an extra 30, 60, or 90 minutes back out of their day.

Automation tools, in general, and AI tools specifically, can assist business analysts who need to crunch massive amounts of data and succinctly communicate it.

In fact, a recent Gartner analysis,” An AI-First Strategy Leads to Increasing Returns” states that the most advanced enterprises rely on AI to increase the accuracy, speed, and scale of analytical work to fuel three core objectives — business growth, customer success, and cost efficiency — with competitive intelligence being core to each.

Google’s newly released Gemini 2.0 Flash provides business analysts with greater speed and flexibility in defining Python scripts for complex analysis, giving them more precise control over the results they generate.

Google claims that Gemini 2.0 Flash builds on the success of 1.5 Flash, its most adopted model yet for developers.

Gemini 2.0 Flash outperforms 1.5 Pro on key benchmarks, delivering twice the speed, according to Google. 2.0 Flash also supports multimodal inputs, including images, video, and audio, as well as multimodal output, including natively generated images mixed with text and steerable text-to-speech (TTS) multilingual audio. It can also natively call tools like Google Search, code execution, and third-party user-defined functions.

Taking Gemini 2.0 Flash for a test drive

VentureBeat gave Gemini 2.0 Flash a series of increasingly complex Python scripting requests to test its speed, accuracy, and precision in dealing with the nuances of the cybersecurity market.

Using Google AI Studio to access the model, VentureBeat started with simple scripting requests, working up to more complex ones centered on the cybersecurity market.

What’s immediately noticeable about Python scripting with Gemini 2.0 Flash is how fast it is, nearly instantaneous, in providing Python scripts back in seconds. It’s noticeably faster than 1.5 Pro, Claude, and ChatGPT when handling increasingly complex prompts.

VentureBeat asked Gemini 2.0 Flash to perform a typical task a business or market analyst would be requested to do, which is to create a matrix comparing a series of vendors and analyze how AI is used across each company’s products.

Analysts often have to create tables quickly in response to sales, marketing, or strategic planning requests, and they usually need to include unique advantages or insights into each company. This can take hours and even days to get done manually, depending on an analyst’s experience and knowledge.

VentureBeat wanted to make the prompt request realistic by having the script encompass an analysis of 13 vendors, also providing insights into how AI helps the listed XDR vendors handle telemetry data. As is the case with many requests analysts receive, VentureBeat asked Python to produce an Excel file of the results.

Here is the prompt we gave Gemini 2.0 Flash to execute:

Write a Python script to analyze the following cybersecurity vendors who have AI integrated into their XDR platform and build a table showing how they differ from each other in implementing AI. Have the first column be the company name, the second column the company’s products that have AI integrated into them, the third column being what makes them unique and the fourth column being how AI helps handle their XDR platforms’ telemetry data in detail with an example. Don’t web scrape. Produce an Excel file of the result and format the text in the Excel file so it is clear of any brackets ({}), quote marks (‘) and any HTML code to improve readability. Name the Excel file. Gemini 2 flash test.
Cato Networks, Cisco, CrowdStrike, Elastic Security XDR, Fortinet, Google Cloud (Mandiant Advantage XDR), Microsoft (Microsoft 365 Defender XDR), Palo Alto Networks, SentinelOne, Sophos, Symantec, Trellix, VMware Carbon Black Cloud XDR

Using Google AI Studio, VentureBeat created the following AI-powered XDR Vendor Comparison Python scripting request, with Python code produced in seconds:

Next, VentureBeat saved the code and loaded it into Google Colab. The goal in doing this was to see how bug-free the Python code was outside of Google AI Studio and also measure its speed of being compiled. The code ran flawlessly with no errors and produced the Microsoft Excel file Gemini_2_flash_test.xlsx.

The results speak for themselves

Within seconds, the script ran, and Colab signaled no errors. It also provided a message at the end of the script that the Excel file was done.

VentureBeat downloaded the Excel file and found it had been finished within less than two seconds. The following is a formatted view of the Excel table where the Python script was delivered.

The total time needed to get this table done was less than 4 minutes, from submitting the prompt, getting the Python script, running it in Colab, downloading the Excel file, and doing some quick formatting.

A convincing argument to unleash AI on monotonous tasks

For the many professionals who have worked in a variety of business, competitive, and market analyst roles in their careers, AI is the force multiplier they’ve been looking for to trim hours off of repetitive, monotonous tasks.

Analysts, by nature, have a high degree of intellectual curiosity. Unleashing AI on the most mundane and repetitive parts of their jobs and equipping them to create the comparisons and matrices they often are asked to develop quickly is a powerful boost to an entire team’s productivity.

Managers and leaders of business, competitive analysis, and marketing teams need to consider how the fast advances in models, including Google’s Gemini 2.0 Flash, can help their teams get growing workloads under control. Helping lift that burden will give analysts a chance to do what they enjoy and do best, which is to use their intuition, intelligence, and insight to deliver exceptionally valuable ideas.

Daily insights on business use cases with VB Daily

If you want to impress your boss, VB Daily has you covered. We give you the inside scoop on what companies are doing with generative AI, from regulatory shifts to practical deployments, so you can share insights for maximum ROI.

Read our Privacy Policy

Thanks for subscribing. Check out more VB newsletters here.

An error occured.