• The Neuron
  • Posts
  • šŸ˜ŗ How to analyze data faster

šŸ˜ŗ How to analyze data faster

PLUS: The top #100 AI tools are....

Welcome, humans.

A new Under Armour ad feat. boxer Anthony Joshua that used AI is getting pushback for allegedly reusing creative works without giving credit where credit is due.

TBH, the ad is genuinely very hype (watch here). Sidestepping the controversy, it's clear that AI ads (and the debates they spark) will go bananas once Sora hits the market.

Hereā€™s what you need to know about AI today:

  • Our tutorial on using Data Analyst GPT to better understand your data.

  • Copilot Pro is finally globally available.

  • A clip from WSJā€™s interview with OpenAI CTO Mira Murati is going viral.

  • a16z published the 100 most popular AI tools in the world.

How to use the Data Analyst GPT.

For anyone who crunches numbers on the daily, the Data Analyst GPT in ChatGPT can summarize and offer insights on basic datasets.

P.S. anything beyond basic data should be delegated to your data intern from Cornell. Also Claude 3 isnā€™t great with data yet, so stick with GPT-4.

Using it is simple:

1. Upload an Excel or GSheet to the Data Analyst GPT.Ā 

2. First, make sure it understands the dataā€”here are some handy prompts:

"Please summarize this dataset for me. Include details like the number of rows, columns, and a brief description of each column."

"Analyze the dataset for missing values. Which columns have missing values and what percentage of their data is missing?"

"Provide a statistical summary for each numerical column, including mean, median, mode, and standard deviation."

3. From there, ask the GPT to draw high-level insights from the data. We uploaded our Readership Survey and asked for content suggestions based on your responses:

4. To create charts, use thisĀ megaprompt. (And here are 60 prompts for more advanced data analyses).

Peter Yang

Data Analyst isnā€™t perfect, and sometimes it makes sh*t up.Ā 

Request that it ā€œensure insights are directly supported by the dataā€ OR ā€œreference the specific data points where [x] occursā€, and always be sure to verify any important graphs or insights by double-checking the raw data yourself.

Also worth exploring are DataGPT (basically Data Analyst with sexier dashboards and visuals) and ExcelGPT (specifically good for Excel).

DataGPT

FROM OUR PARTNERS

Jurny is modernizing the $4.1T hospitality industry.

Six months back, we gave you a sneak peek at Jurny, an AI startup revolutionizing hospitality with some of the slickest dashboards weā€™ve ever seen.

They help property managers like Airbnb to Booking.com automate everything from reservations to pricing, a $1 trillion inefficiency.Ā 

After 5x customer growth and processing $35M+ in bookings, Jurny is giving The Neuron readers a chance to invest.Ā 

You can learn more about their vision by checking out this in-depth Q&A with Jurnyā€™s CEO.

The 100 top AI tools in the world.

a16z

a16z published its semi-annual list of the top #50 most popular AI web and mobile apps.

TLDR: Itā€™s ChatGPT and the field. And ā€œthe fieldā€ largely consists of an ever-rotating lineup of productivity, education, and companionship apps.

a16z

Here are a few tools many people are finding useful that we havenā€™t covered much:

  • Eightifyā€”summarizes YouTube videos.

  • Gammaā€”helps make presentations.

  • Photoroomā€”AI editor for stuff like removing backgrounds.

  • Pixelcutā€”AI that creates product photos.

  • Phindā€”coding assistant and search engine.

  • Speechifyā€”text-to-audio tool w/ celebrities voices.

The entireĀ report is worth a read!

a16z

Around the Horn.

  • Copilot Pro, which offers access to Copilot/GPT in all your Office Apps, is now globally available.

  • *Advertise in The Neuron. Reach 400,000+ AI enthusiasts. Drive hundreds of new customers.

  • Check out these astonishing 9 new Sora videos published by OpenAI.

  • OpenAIā€™s CTO refused to answer the question of what data Sora was trained on.

Intelligent Insights.

In todayā€™s roundup: Big Tech recalibrating its expectations for how many customers will actually buy their AI products:

  • Amazon, Google Quietly Tamp Down Generative AI Expectations (link).

  • The European Parliament has just APPROVED the AI Act. What everyone should know: (link).

  • Prompt injection and jailbreaking are not the same thing (link).

  • Silicon Valley is pricing academics out of AI research (link).

  • Thread: Why LLMs might do to developers what spreadsheets did to accountants (link).

Friday Faculty.

  1. 37 roles at Figure AI (Sunnyvale, CA).

  2. Software Engineer at Cognition (NYC or SF).

  3. Email Midjourney if you want to join their team!

  4. Director of Marketing at Inflection AI (Palo Alto).

  5. Research Security Manager at Google DeepMind (NYC).

Search from over 10,000 AI roles on The Neuronā€™s Jobs Board.

A Cat's Commentary.

Thatā€™s all for today, for more AI treats, check out our website.

Get your brand in front of 400,000+ professionals here.

See you cool cats on Twitter: @nonmayorpete & @noahedelman02

What'd you think of today's email?

Login or Subscribe to participate in polls.