Відео

I don’t have a degree in data analytics, but I have a degree in computer science in an unrelated field.

Yea but does it know what analysis to run?

If people don't have jobs as a result of AI taking over almost all jobs, people will not have money. If people don't have money, they will not spend on anything. Then what data will the companies analyse if nobody is buying their products?

The latest Gemini demo showed 2 cartoon pictures of a cat, one dead and one alive. Then they put a box next to the pictures and asked Gemini what they reminded it of (or something along those lines) and it said Schrödinger’s cat. I was amazed by that level of abstract thinking, something I haven’t even seen with ChatGPT but now I wonder if they didn’t fake it.

Sir, I feel like subscribing to your channel is the proudest subscription of my entire existence in UA-cam. I’m actually a L&D professional from Morocco and I’m trying to steer my career to data & business analytics and really need guidance. Thanks for the very cool story though!

this only applies on excel right? not on google spreadsheet?

Love your content😊

Please give us some time to read the prompts.. .

Hey Luke , how should i corss verify the practical problem answers ?

Please, I need your help. I'm an accountant with a little knowledge of SQL, Python, and Power Query. As you are professional, what would you advise me to study? I'm very confused. Should I study Power Query and M language, SQL, or Pandas? I would like to study all of them, but due to time constraints, I'm seeking your guidance to help me make a plan or focus on one thing. Thank you.

what about SAS ?

❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

very helpful, but i was stuck at installing postgre, it never works on my computer

all of this gems for free, you're a legend, thank you is not enough , but really, thank you so much...

Having data spread across many tables in a database is not a problem 😂 that's the whole point of a database... If you store it in a single table, it's not a database, it's an excel file... Your statement makes no sense

I am pivoting for a time to learn data analysis and machine learning skills. I eventually want to do work as a biologist (once I finish my college education but I want to be able to use data analysis as part of my skillset in any research I might be doing in the future.

I am planning to buy your course ChatGPT for Data Analytics. Is it okay to become a data analyst without knowing coding? Can I get a good job and salary? Can the company accept me to do data analysis with the chat gpt4? Please let me know.

You'll need to buy a "proper" database query tool as excel is not designed to part the red sea...can sort our koolaid though

Fyi for those who didn't know, you can text from your windows machine as well as use apps, view photos etc etc through the "phone link" app which comes with your pc

Sənə halaldı, Mujiksən 😎

Great job, thanks, Luke, so helpful. I am the PM and going to include SQL into my resume.

Amazing! Thank you!

This is the best video of sql that i found and i searched a lot. Thank you!!!

The course is too long. Could you please tell me the plugins you use in the ChatGPT plus and list all the prompts?

Hello

I never write comments but this video is awesome seems perfect

Imagine being a student now... Ina few years, no one will know a damn thing... The future is terrifying

Thank you Luke. Took me around a month to finish this but now I know SQL very well!

I was planning this exact project myself, but it seems that you beat me to it. I need to come up with some other idea now. I must say, excellent work. You're an inspiration to me. The concept, the method, the execution of the project, and then the presentation of it in this video is top-notch. How I wish I could do a cool af project like this and make a video about it too.

I didn’t understood anything but I want to learn everything 🤩

Can you ask Grok if overpopulation is a myth?

pray for communism

Hi, so i am done with my studies, and my tableau license that i got through my college is expiring soon. PowerBI is not available on Mac natively, I do use my windows machine from time to time, is there any other software that you can suggest for me please Thank you :)

ChatGPT summary : Summary: - The video outlines the process of utilizing Python for data analysis, focusing on collecting data, cleaning it, performing exploratory data analysis (EDA), and building a dashboard. - Python is highlighted as a versatile tool for data analytics, capable of tasks ranging from collecting data from APIs like serp API, cleaning and analyzing the data, to building interactive dashboards using libraries like Streamlit. - The process involves automation using Google Cloud services, particularly BigQuery for storing data and automating data collection scripts. - Key skills highlighted for data analysts include proficiency in SQL, Excel, and Python, with Python catching up in popularity. - The video emphasizes the importance of continuous learning and improvement in Python skills, recommending courses like "Python for Everybody" and "Applied Data Science with Python Specialization" on Coursera. - Future plans include expanding data collection to include other data analyst roles and encouraging contributions from viewers through open-sourcing the project on Reddit.

ChatGPT Summary : In the last video, the creator highlighted a significant issue in the data science industry regarding the mismatch between recommended skills and actual job postings. They built an app analyzing data analyst job posts in the US and discovered outdated recommendations lacking evidence. The Stack Overflow developer survey inspired them to create a similar survey for data professionals. However, they faced challenges such as limited data for data professionals and technical issues with their app. To address these issues, they embarked on building a new solution. They utilized Python to connect to an API, collecting job data globally. They engaged a data engineer to refine the data pipeline using tools like Airflow for scheduling and BigQuery for data warehousing. They also employed Spark clusters for processing large datasets efficiently. After cleaning the data, they delved into exploring salary and skills. They found discrepancies in salary ranges in job postings and used median values for accuracy. They also identified the most in-demand skills for different roles, emphasizing SQL and Python for data professionals. To provide accessible insights, they developed a web app using Streamlit, allowing users to filter job postings by title and explore skills and salaries. Users can now make informed decisions about skill acquisition based on real-time data. Overall, their journey involved overcoming challenges in data collection, processing, and analysis to create a valuable resource for data professionals. They continue to seek feedback for further improvements to the website. | Key Points | |------------------------------------------------------------------------------| | - Identified a gap between recommended skills and actual job postings in data science. | | - Built an app analyzing US data analyst job posts but faced technical issues and limited data. | | - Developed a new solution, collecting global job data using Python, Airflow, and Spark clusters. | | - Explored salary and skill data, highlighting discrepancies in salary ranges and in-demand skills. | | - Created a web app using Streamlit for users to access real-time insights on skills and salaries. | | - Open to feedback for improving the website and continuing data collection for future analysis. |

Hi Luke. I am completely new in this field. I always loved doing analyses in excel. But I found my self limited. Now I am going through your course of SQL and also went through this course. I was able to set up local LLM using LM Studio (on MacBook Air M2) and get it running in VS Code via Continue extension. My question is, have you tried some locally running LLM? Also I recently found Microsoft LIDA. It would be great if we have your opinion on this tools.

Hello Luke 😀 hope your all well. Hmm is there a way to check the version on dataset you put up on kaggle on the datajobs via the Kaggle API ?. I just want to make sure that I don't start downloading a dataset if I already got it 😀

Data analysis seem interesting. Though I was wondering which certificate has more weight or is more considered between IBM and Google?

Hi Luke! Great video. Very informative. Would you consider giving a discount code to your viewers abroad? I really want to purchase the notes you provided but but my country's currency is very worthless and 25 dollars is unfortunately a huge amount for me.

Wow… this is a great content Luke. A lot of work was put into this.

R is simply the best👏👏👏👏👏

Stackoverflow assistant

too fast for me to follow.

can i please get the file on smss?

Is this suitable for an introvert ?

"store them in excel sheets', lol, "no God please no", hahahaha

Hi Luke, I have been experiencing frequent and prolonged errors with ChatGPT’s inability to read Excel, CSV and other file types. Even very small datasets seem to be a problem. Do you know whether this problem also persists in the USA, I'm living in the Netherlands Has anyone else experienced this issue? I think this is a major shortcoming of a service for which you also have to pay monthly

说实话在365中copilot对我来说似乎没什么用处，我很少用到他们

Nice! And Great!

Who lives in the USA I want to do this course.