Analytics with Adam
Analytics with Adam
  • 206
  • 940 079
HR Data Analysis Made Easy: ChatGPT + Python in Action | Maximize Productivity
Can ChatGPT handle complex data analysis? Yes-with a little help from Python! In this video, I show how to work around ChatGPT's math limitations by leveraging its Python capabilities to analyze an HR dataset. In just a few prompts, we generate insights, create visualizations, and format a detailed report. If you're looking for productivity hacks with AI, this video is for you!
👨‍💻 Key Highlights:
How to use ChatGPT + Python to analyze HR data
Overcoming the limitations of large language models
Generating professional reports with ease
Step-by-step guide to creating charts and pulling insights
Unlock the true potential of AI by working smarter, not harder. Like, share, and subscribe for more data analysis tips!
#ChatGPT #Python #DataAnalysis #HRAnalytics #AIProductivity #TechTips #LargeLanguageModels #AIHacks
Переглядів: 139

Відео

How to Extract YouTube comments in sheets and analyse with AI with 1 click
Переглядів 187День тому
Unlock the power of AI-driven UA-cam analytics with this step-by-step tutorial! Learn how to extract UA-cam comments directly into Google Sheets using Apps Script and the UA-cam Data API v3. Then, take your analysis to the next level by leveraging the cutting-edge Google Gemini API to perform sentiment analysis on those comments. This video guides you through creating a user-friendly Google She...
Dynamic Automated Reports in Google Sheets with Apps Script and Gemini
Переглядів 31814 днів тому
In this video we delve deep in to passing user inputs in to Google Apps Scripts which allows the user to define parameters in the automated reports. We use Google Gemini and Google Big Query with Apps Script to Develop an Automated Reports with Parameters and Prompts passed by the user. Apps Script allows the user to use Google Gemini in Google Sheers but should be controlled in order to ensure...
Automate Your Presentations From Google Sheets to Slides with Apps Script
Переглядів 24021 день тому
Unlock the power of automation and streamline your data presentation workflow with this comprehensive tutorial! In this video, you'll learn how to seamlessly transfer data visualizations from Google Sheets to Google Slides using the magic of Apps Script. We'll walk you through the entire process, starting with pulling data from BigQuery into Google Sheets. You'll see how to create dynamic, refr...
SQL for Beginners - The Where Clause
Переглядів 92Місяць тому
Unlock the power of SQL filtering with this quick, actionable guide to the WHERE clause! Perfect for business analysts, data scientists, and SQL beginners. In just 4 minutes, you'll learn how to: ✅ Use comparison operators to pinpoint exact data ✅ Combine conditions with AND, OR, and NOT ✅ Leverage BETWEEN and IN for advanced filtering We're using real-world data from London's Bicycle Hire syst...
Unleashing the Power of AI in Google Sheets
Переглядів 251Місяць тому
Unlock the power of automated narrative reporting in Google Sheets with this game-changing tutorial! Learn how to seamlessly integrate BigQuery data retrieval, Gemini AI analysis, and dynamic report generation-all within Google Sheets. GitHub: github.com/analyticswithadam/App_Script/blob/main/Big Query and Gemini Narrative Reporting.js In this video, you'll discover how to: - Set up a custom me...
AI-Powered Lead Distribution: Harnessing GPT4o and Google BigQuery
Переглядів 90Місяць тому
Generative AI enables us to use natural language instructions to perform automations that were previously very difficult or impossible to code. In this video, we demonstrate a Sales Lead Allocation Automation using codified intelligence stored in a database. Our example focuses on incoming sales leads that need to be allocated considering multiple rules, such as workers' specialisations and bal...
Learn SQL for Business Analysis Advanced SELECT Techniques with Real Data
Переглядів 2,2 тис.Місяць тому
Learn SQL for Business Analysis Advanced SELECT Techniques with Real Data
Automate Social Media Campaign Reporting: Google Gemini + YouTube API Tutorial
Переглядів 150Місяць тому
Automate Social Media Campaign Reporting: Google Gemini UA-cam API Tutorial
How to Create Automated Reports with Using Google Apps Script and Big Query
Переглядів 8302 місяці тому
How to Create Automated Reports with Using Google Apps Script and Big Query
GPT4o for Data Analysis (Honest Review)
Переглядів 2662 місяці тому
GPT4o for Data Analysis (Honest Review)
Learn SQL for Business Analysis: Select Statement for Beginners
Переглядів 1632 місяці тому
Learn SQL for Business Analysis: Select Statement for Beginners
PDF to Excel in Seconds with Power Query!
Переглядів 3932 місяці тому
PDF to Excel in Seconds with Power Query!
Google Apps Script For Sheets - How to Copy, Clean and Insert Data in Sheets
Переглядів 1,1 тис.3 місяці тому
Google Apps Script For Sheets - How to Copy, Clean and Insert Data in Sheets
Supplier Risk Assessment with GPT4o - AI for Business Analysis
Переглядів 2183 місяці тому
Supplier Risk Assessment with GPT4o - AI for Business Analysis
SQL Tutorial - Common Table Expression (CTEs) with Examples
Переглядів 4063 місяці тому
SQL Tutorial - Common Table Expression (CTEs) with Examples
How to Record Macros in Google Sheets with Apps Script
Переглядів 1,6 тис.3 місяці тому
How to Record Macros in Google Sheets with Apps Script
How build Forecast Dashboards with Looker Studio
Переглядів 1,1 тис.4 місяці тому
How build Forecast Dashboards with Looker Studio
Top 5 Text Transformations in Excel Using Power Query
Переглядів 8174 місяці тому
Top 5 Text Transformations in Excel Using Power Query
OpenAI GPT4o Speed Test: Is it Faster than GPT4 at Data Cleaning?
Переглядів 1774 місяці тому
OpenAI GPT4o Speed Test: Is it Faster than GPT4 at Data Cleaning?
Google Apps Script for Beginners: Start Automating Google Sheets
Переглядів 29 тис.4 місяці тому
Google Apps Script for Beginners: Start Automating Google Sheets
Google Sheets with Gemini API: Create AI-Powered Functions Using App Script!
Переглядів 6 тис.4 місяці тому
Google Sheets with Gemini API: Create AI-Powered Functions Using App Script!
What is the best AI Tool in Excel? Copilot or Analyze Data.
Переглядів 2,3 тис.4 місяці тому
What is the best AI Tool in Excel? Copilot or Analyze Data.
How to Query Google BigQuery datasets in Python For Free
Переглядів 1,2 тис.5 місяців тому
How to Query Google BigQuery datasets in Python For Free
How to use Calculated Fields with Parameters in Looker Studio
Переглядів 1,3 тис.5 місяців тому
How to use Calculated Fields with Parameters in Looker Studio
Top 5 Numeric Transformations in Excel Using Power Query
Переглядів 1,2 тис.5 місяців тому
Top 5 Numeric Transformations in Excel Using Power Query
Using Google Gemini and Big Query to Create Narrative Reports
Переглядів 1,3 тис.5 місяців тому
Using Google Gemini and Big Query to Create Narrative Reports
How to use LLMs in SQL Statements with Big Query ML
Переглядів 1,1 тис.5 місяців тому
How to use LLMs in SQL Statements with Big Query ML
Power Query - How to create columns from Examples
Переглядів 2586 місяців тому
Power Query - How to create columns from Examples
I put Gemini Pro Vision to the test on Google Cloud!!!
Переглядів 2936 місяців тому
I put Gemini Pro Vision to the test on Google Cloud!!!