Analytics with Adam
Welcome to Analytics with Adam.
I focus on making content related to Business Analytics and AI using the Google Stack
Google Sheets, Google Appscript, BigQuery, Looker Studio, Google Gemini and Google Colab.
This channel is aimed at business users and students who want to leverage data analysis tools to improve their role performance or data analytics portfolios.
My name is Adam, I am in the midst of a varied techo-functional career where I have worked as a data end user (business analyst / accountant) and am now leading some finance analytics projects for one of the world's top consultancy firms. Using my experience with both large and small business I hope to share relevant, usable and actionable tutorials / walkthroughs. I believe in lifelong learning and am learning everyday.
#businessanalytics #businessanalysis #dataanalytics #datavisualization #dataanalysis #bigquery #lookerstudio #SQL #googlecolab #python #googlesheets #googlegemini
Analytics with Adam
This week I launched my first Udemy course, Looker Studio: The Practical Masterclass.
This course is full of practical projects and data analytics tips in order to get you job ready with Looker Studio including building out an impressive portfolio.
Im offering a special coupon to my followers on YouTube, you can get there by following this link:
www.udemy.com/course/looker-studio-masterclass/?co…
#LookerStudio
#LookerStudioCourse
7 months ago (edited) | [YT] | 2
View 0 replies
Analytics with Adam
I was really impressed with AI SQL assistant in #bigquery.
Have already been using it for autocompletion in work but will start using the data insights functionality heavily now. Have a made a video demoing the capabilities, its below.
What do you guys think?
1 year ago | [YT] | 1
View 0 replies
Analytics with Adam
This week I posted a tutorial on what I have been up to with Google Gemini and App Script at Work.
Its a guide on how to create automated decks from SQL to Sheets to Slides with the click of a button.
This is a major time saver so you should check it out if you use Google workspace. #Automation #GoogleGemini #GoogleAppsScript
1 year ago | [YT] | 1
View 0 replies
Analytics with Adam
You can now leverage a Large Language Model in your SQL query using Big Query ML. This opens up a lot of use cases such as complex data cleanup, language translation, classification and sentiment analysis.
In this video I give a complete guide of how to get started. #SQLTips #GoogleGemini #BigQuery #GenAI
1 year ago | [YT] | 3
View 2 replies
Analytics with Adam
If you are looking to pull all the comments and replies from a playlist through the #youtubeapiv3 this is the video for you.
1 year ago | [YT] | 0
View 0 replies
Analytics with Adam
One of my Objectives in 2024 is to create one portfolio project per month.
My first project combines a Sentiment Analysis Algorithm in Python with a #PowerBI Dashboard to answer the question of what are the most positive and negative national anthems in the world.
Any Questions on my process let me know.
1 year ago | [YT] | 0
View 0 replies
Analytics with Adam
Data Analyst Roadmap 2024
In this video I lay out what I think are the keys to learning how to be a data analyst in 2024.
Specifically ,Tips and Resources for learning and building with:
#Sql
#PowerBI
#Excel
#Dataanalystportfolio
Let me know if you have some tips I missed
1 year ago | [YT] | 1
View 0 replies
Analytics with Adam
What do you guys want to see more of?
2 years ago | [YT] | 4
View 1 reply
Analytics with Adam
If you want to know how to do Machine Learning in Excel. This one is for you !!!!!!!!!!!!!!!
#PythoninExcel #MLinExcel #MachineLearninginExcel
2 years ago | [YT] | 0
View 0 replies
Analytics with Adam
#JSON is normally a hard format to parse and deal with unless you use libraries from a programming language . Power Query in Excel has tools to make it simple to parse and work with right in #Excel.
In this week’s video we show how Parse JSON in Excel step by step.
2 years ago | [YT] | 0
View 0 replies
Load more