- 20
- 51 728
Travis Cuzick
United States
Приєднався 29 сер 2020
I’m Travis, and this is my UA-cam channel! (obviously).
I work/play with data and AI, and love teaching people to have as much fun with this stuff as I do.
Stay tuned for upcoming tutorials and career advice in data analytics and AI, and maybe even a few spicy hot takes from time to time.
I work/play with data and AI, and love teaching people to have as much fun with this stuff as I do.
Stay tuned for upcoming tutorials and career advice in data analytics and AI, and maybe even a few spicy hot takes from time to time.
🐍 Python Crash Course for Data Professionals: Zero to Liftoff in 3 Hours 🚀
🔥 3-Hour Python Programming Crash Course - No fluff, just the essentials of Python for data analysis!
Want to level up your analytical skillset with Python, but feel overwhelmed by the sheer volume of tutorials out there? Well, this 3-hour crash course is for you!
It skips the stuff you won’t need as a data professional, and instead focuses on the Python you will need to start working with powerful data analysis libraries like Pandas. No web development or complicated UI creation here-just a laser focus on the Python essentials that matter to your data journey.
🎓 What You'll Learn:
- Programming fundamentals
- Python basics: values, types, functions, expressions
- Working with Colab Notebooks
- Variables and naming conventions
- Debugging common errors
- Objects, attributes, and methods
- Essential Python data structures: lists, tuples, dictionaries
- Using Python modules like Pandas for data analysis
BONUS: If you're ready to dive even deeper into mastering data analysis with Python and Pandas, check out my full Python/Pandas Bootcamp on Udemy, at a special discounted rate!
👉 [www.udemy.com/course/pandas-python-data-analysis-bootcamp/?couponCode=PANDAS-OCT-24]
🔔 And of course, remember to subscribe to my channel for more data analysis tips and tutorials!
00:00 Introduction
02:07 What is “Programming”?
06:28 The Programming Environment
18:57 Values and Types
27:15 Functions
37:31 Expressions
47:33 Expressions in Colab
52:22 Variables
1:05:25 Naming Variables
01:11:43 Programming Errors
01:18:38 Comments
01:24:07 Text Cells
1:43:51 Colab Tips and Pitfalls
01:58:05 Objects, Properties, and Methods
02:07:12 Modules and Libraries
02:19:26 Lists
02:31:24 Tuples
2:40:41 Dictionaries
Want to level up your analytical skillset with Python, but feel overwhelmed by the sheer volume of tutorials out there? Well, this 3-hour crash course is for you!
It skips the stuff you won’t need as a data professional, and instead focuses on the Python you will need to start working with powerful data analysis libraries like Pandas. No web development or complicated UI creation here-just a laser focus on the Python essentials that matter to your data journey.
🎓 What You'll Learn:
- Programming fundamentals
- Python basics: values, types, functions, expressions
- Working with Colab Notebooks
- Variables and naming conventions
- Debugging common errors
- Objects, attributes, and methods
- Essential Python data structures: lists, tuples, dictionaries
- Using Python modules like Pandas for data analysis
BONUS: If you're ready to dive even deeper into mastering data analysis with Python and Pandas, check out my full Python/Pandas Bootcamp on Udemy, at a special discounted rate!
👉 [www.udemy.com/course/pandas-python-data-analysis-bootcamp/?couponCode=PANDAS-OCT-24]
🔔 And of course, remember to subscribe to my channel for more data analysis tips and tutorials!
00:00 Introduction
02:07 What is “Programming”?
06:28 The Programming Environment
18:57 Values and Types
27:15 Functions
37:31 Expressions
47:33 Expressions in Colab
52:22 Variables
1:05:25 Naming Variables
01:11:43 Programming Errors
01:18:38 Comments
01:24:07 Text Cells
1:43:51 Colab Tips and Pitfalls
01:58:05 Objects, Properties, and Methods
02:07:12 Modules and Libraries
02:19:26 Lists
02:31:24 Tuples
2:40:41 Dictionaries
Переглядів: 873
Відео
Excel's IFS Function: Simplify Complex Conditional Logic
Переглядів 162Місяць тому
Master Excel's powerful IFS function in just over 10 minutes! This tutorial shows you how to streamline your spreadsheets and boost productivity by replacing nested IF statements with the sleek IFS function. 🔥 What you'll learn: - IFS vs nested IF functions - How IFS works and why it's a game-changer - Step-by-step guide to implementing IFS - Real-world example: employee performance ratings - P...
Merge Data Like a Pro with Power Query (No VLOOKUP Required!)
Переглядів 8 тис.2 місяці тому
🔍 Want to become a Power Query Merge Master? Start here! 🔍 If you've been using VLOOKUP or XLOOKUP to combine data in Excel, it's time to upgrade your skills with Power Query. In this tutorial, I'll show you how to effortlessly combine multiple datasets without the headaches of traditional Excel formulas. 📌 In This Video, You'll Learn: - The limitations of VLOOKUP and XLOOKUP for data merging -...
Prettify Your SQL Outputs with the FORMAT Function
Переглядів 1,1 тис.4 місяці тому
🕶️ Present your data in style with SQL Server's FORMAT function! 🕶️ Hey there, data enthusiasts! In today's video, we're diving deep into one of my favorite SQL Server functions: the FORMAT function. If you're a data analyst or aspiring to be one, mastering this function can elevate your data presentation skills to the next level. 🚀 🔍 What You'll Learn: - The importance of data formatting in pr...
"Query" Excel Like a SQL Database Using Dynamic Array Functions!
Переглядів 1,3 тис.4 місяці тому
Unlock the power of Microsoft Excel with dynamic array functions! In this video, I’ll show you how to transform your data with ease, performing SQL-like operations right within Excel. Whether you're a beginner or a seasoned analyst, these tips will help you streamline your workflow and enhance your data analysis skills. 🔍 What You'll Learn: - How to filter data based on specific criteria - Sele...
Analyzing Sales Trends with SQL
Переглядів 6136 місяців тому
📈 Master SQL for Sales Trend Analysis | Advanced SQL Tutorial Unlock the power of SQL to analyze sales trends without ever leaving your database! This comprehensive guide dives deep into advanced SQL techniques, using the AdventureWorks sample database to bring real-world scenarios to life. Whether you're a seasoned Data Analyst or just starting out, this tutorial is designed to enhance your sk...
Mastering Window Functions in SQL for Data Analysis: 1 Hour Mini-Course
Переглядів 1,3 тис.7 місяців тому
Unlock the power of Window Functions in SQL with this comprehensive 1-hour mini-course! Designed for current and aspiring Data Analysts, this tutorial will elevate your data analysis skills to the next level. In this video, we'll dive deep into the world of SQL Window Functions, covering essential concepts and practical applications, including: - The OVER Function: Learn how to use the OVER fun...
SQL: Applying Multiple Criteria With AND, OR, and IN
Переглядів 2,9 тис.4 роки тому
How to apply OR & AND criteria in the same SQL query - and how to streamline repetitive OR conditions with the IN keyword Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Handling Inequalities and NULLs in SQL
Переглядів 1264 роки тому
How to apply inequalities in your WHERE criteria, plus unlocking the riddle of NULL values Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Basic Criteria in SQL With WHERE
Переглядів 1984 роки тому
An introduction to filtering your data with criteria using SQL's WHERE clause Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
SQL Tips and Tricks
Переглядів 2184 роки тому
Some miscellaneous tips and tricks to make your life easier as you work with SQL and SQL Server Management Studio Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Exporting Data From SQL Server Management Studio
Переглядів 3964 роки тому
Multiple methods of getting the output of your queries out of SQL Server Management Studio, and into Excel and .csv files Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Selecting Custom Values in SQL
Переглядів 2054 роки тому
Selecting "literals" - custom values YOU define, which may be text, numbers, or dates - into the output of your SQL queries Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Column Aliases in SQL
Переглядів 2084 роки тому
How to assign custom names, or "aliases", to the often cryptic field names in SQL databases Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Introduction to SQL
Переглядів 1 тис.4 роки тому
What SQL is, how to pronounce it (hint: "sequel"), and how to "select" data from a database Check out the full course, with exercises, example files, and LOTS more content here: www.udemy.com/course/sql-basics-crash-course-with-sql-server
Saving and Opening Files in SQL Server Management Studio
Переглядів 32 тис.4 роки тому
Saving and Opening Files in SQL Server Management Studio
Downloading the AdventureWorks Sample Database
Переглядів 1324 роки тому
Downloading the AdventureWorks Sample Database
Installing SQL Server Management Studio
Переглядів 694 роки тому
Installing SQL Server Management Studio
Appreciate the author for his effort.
best colab python tutorial❤👍
Thanks, really appreciate this!
I always like Travis Lectures very easy way hw explain and i really like his style way he teach. I bought his sql server for data analysis course and i am glade to get that. I wish all the best.
Really appreciate this; hope you enjoy the video!
Very clear and instructive
Really appreciate the great feedback!
is it possible you post the excel sheet to follow through
I will definitely look into sharing the solution file - thanks for the suggestion!
This was excellent, so easy to follow. Thank You!
Glad you enjoyed it!
Nice video, pretty easy to understand
thank you
Last week, I spent an hour trying to get 3 columns from one csv file into another. Started with Index/Match, then reluctantly went to Vlookup. Nothing was working. I would name my ranges, enter the functions and when I clicked “enter”, I was staring at the formula itself…no data. I finally got it to work after I realized my target column was set to “text”. I know Power Query, and I know I could have/ should have used it. But old habits are hard to break. Thanks for this reminder.
No doubt, using VLOOKUP can be a very frustrating experience!
This video was great! Thank you!!!!Is it possible to add new columns before you load the data merge to new worksheet? Example I need it to take a date on the sheet and add 90 days but I need the value in a new column.
Absolutely! You can always go back into Power Query and add more transformations to the data; then, when you hit "close and load" at the end of your changes, your changes should be reflected in the data in the spreadsheet.
Thanks 👍 Very useful Gentleman..
Glad you enjoyed it!
Thanks very much.
you better start Uploading more, you got potential and your content is great.
Appreciate this! And I definitely plan on continuing to drop more content!
wonderful, great job
Glad you enjoyed it!
Awesome, crystal clear and concise. Well done
So glad that you enjoyed it!
Insightful! Thanks
You nailed it perfect explanation to understand the difference between group by and window function perfect use of words to explain no waste of time and the most important not speaking fast explanation is slow and steady 🎉
My goal was to explain Window Functions the way I *wish* they had been explained to me when I was first learning SQL (a painful process LOL). Glad you enjoyed the video!
@@traviscuzick1111 yeah but I am glad we have people like you who making our journey easygoing 😊
Nice video. I would have used the vstack function to add the titles.
Hi watching your video from India! I found your video very interesting and useful! Explained in such detail and in a way that is very easy to understand.. thank you! Stay blessed!
Thanks for taking the time to leave this awesome feedback...glad you enjoyed the video!
Thank you!
Glad you enjoyed the video!
Hi Travis...when are you bringing your VBA course to Udemy, please? Can't afford ZTM, lol.
it was really helpful
How to select more than 3 Columns with the AND query. It only works on 2. Except am missing something. Please help
Very well explained and nice channel! Ty and keep going!
Thanks man.Good video
I was waiting for the next video
Simply the best SQL Server course at the moment.
Thanks, really love to hear that!
Hey Travis, This is one of the best SQLServer videos I have ever come across, and your channel is really underrated and should get more views. Thank you, and Keep up the good work, Bro!
Thanks, really appreciate this!
Very grateful, sir
good video, thanks!!!
Thanks Buddy ❤️
This file doesn't work later
Travis Cuzick can you upload full SQL course. I love the way you teaching.Thanks
U would think this is the easy bit 🤣
How come my code is read as invalid every time I try to run an opened file?
same happens with me