@RockLee-01
breakdown of video : 1) 17:54 to 4:28:27 SQL 2) 4:29:22 to 7:16:34 EXCEL 3) 7:18:15 to 8:08:34 TABLEAU part 1 4) 8:10:01 to 8:52:48 TABLEAU part 2 5) 8:54:47 to 11:05:03 POWER BI part 1 and 2 after that PANDAS and Project work. peace out.
@sege8197
Was just about to buy a course on SQL on udemy, now this drops!! My year is made. Thanks so much. Fellow aspiring Data analysts let's cook!!!!
@ProductGrower
When I stopped watching tutorials and started doing projects is when I started to learn. It's the only consistent zone of proximal development.
@turmoilstabilizer9054
Alex, I hope you know that your commitments to the community of aspiring data analysts are treasured.
@RohitKumar-gx5zx
4:18:52 Using Common Table Expressions (CTE) to create temporary tables for querying 4:23:08 The focus was on cleaning and standardizing the data. 4:25:09 Data cleaning techniques for a portfolio project 4:28:59 Covering essential data analyst skills and tools 4:30:29 Using bike store sales dataset for demonstration. 4:34:07 Demonstrating drill downs in Tableau for country and state data 4:35:53 Analyzing bike sales revenue by country and state 4:40:03 Creating a calculated field in Tableau to ensure accurate numbers 4:41:58 Understanding and using additional columns in data analysis 4:45:52 Understanding pivot tables in Excel 4:47:32 Streamlined tutorial with useful Excel formulas 4:51:03 IF function with multiple conditions 4:52:58 Using IF function in Excel for logical testing 4:56:53 Left and right functions extract specified number of characters from a text string. 4:58:38 Extracting specific date components from a date structure. 5:02:26 Converting data to text efficiently 5:04:15 Utilize concatenate to join text strings. 5:08:15 Substituting values using Python's substitute function 5:10:12 Using replace function in SQL 5:14:14 Using count, countif, and countifs functions in Excel 5:16:23 Functions for counting and calculating date ranges 5:20:03 XLOOKUP is a new feature in Excel to replace VLOOKUP. 5:21:36 Using VLOOKUP function for data matching 5:25:15 Limitation of multiple rows functionality 5:27:22 Explaining the match mode options 5:31:04 Demonstrating search techniques in data analysis
@Friend_2162
For people who cannot load the Covid Data properly in Excel (Data does not separate). You want to open excel first as blank document. Go to data menu at top. Click Load data from CSV. Select separator as a comma and check that it contains headers. Data should be laoded properly. Make sure to save as compatible file type.
@kenway346
I can't believe that we live in this era wherein an entire bootcamp dedicated to data analysis is uploaded free of cost for the general public -> unbelievable power of educational tech joining hands with such immensely progressive people. This channel feels quite overwhelming at times due to the incredible wealth of knowledge it offers! I hope I just don't keep this course only in my saved playlist without actually starting it!
@creativeart236
1) 17:54 to 4:28:27 SQL 2) 4:29:22 to 7:16:34 EXCEL 3) 7:18:15 to 8:08:34 TABLEAU part 1 4) 8:10:01 to 8:52:48 TABLEAU part 2 5) 8:54:47 to 11:05:03 POWER BI part 1 and 2
@kinnaribhalerao8112
Alex is one of the best in this domain! His YT channel is also gold! Thank you for this boot camp!
@Kim-Min-Ki
I have started my journey, lets see how far I can go! 2024-10-01 - 00:24:44 SQL Basics Tutorial | Select + From Statements 2024-10-02 - 01:02:55 Intermediate SQL Tutorial | Unions | Union Operator 2024-10-06 - 01:15:44 Intermediate SQL Tutorial | Having Clause 2024-10-07 - 01:38:00 Advanced SQL Tutorial | Temp Tables 2024-10-10 - 02:02:06 Advanced SQL Tutorial | Stored Procedures + Use Cases 2024-11-03 - 02:27:10
@cyb3r1
In 37:45 there is a mistake, the IN statement is not used in place multiple AND statements, it is used in place of multiple OR statements
@AK-ox3mv
Just did a comparison. Whole data analyst Bootcamp playlist in Alex's YouTube chanel in 17 hours and this video is 19 hours. Well appreciated 🎉
@kishavchawla9865
I was about to enroll in a $5000 bootcamp to pursue Data Analytics, but this free content changed my mind, at least for now. I'm starting a whole new learning phase. Good luck to everyone who has just started, just like myself. Guidance from those who have already completed this journey would be much appreciated. Peace!
@nika8cht
02:16:57 - if you struggle at following with first project and cannot import excel data into destination SQL SERVER NATIVE CLIENT 11.0 - it's because microsoft updated it into - MICROSOFT OLE DB PROVIDER FOR SQL SERVER
@shawonalam6780
"02:16:57 Data Analyst Portfolio Project | SQL Data Exploration" Importing Covid data CSV file to SSMS: Select DB in SSMS(Ex: PortfolioProject) > Tasks > Import Data... > Next > Data source: Flat File Source > File name: (Browse the .CSV file (make sure the file is in CSV format or change it to .CSV format)) > Next > Next> Destination: Microsoft OLE DB Driver for SQL Server > Properties > 1. Enter the server name manually 2. log on to the server: Windows Authentication 3. Select the database: PortfolioProject > TestConnection > OK >Next > Next > Next> Finish > Close.
@rajdeepsenapati
This channel is so overwhelming like the amount of things and knowledge they give out for free is unmatchable. I couldn't believe i have so many times seen alex recommend fcc but today he came here ig it honour for him also. Thank you fcc and Alex❤️
@prasopchokrodsiri2265
38:56 18/05 Last time we left with IN statement -> Tomorrow start with GROUP BY. 1:08:20 19/05 We already explored GROUP BY, ORDER BY JOIN and UNION -> Tomorrow, start with case statement. 1:34:15 20/05 I have learned updating, deleting, AS and PARTITION BY (very powerful cluase) -> Tomorrow start with common table expression. 2:02:05 21/05 Common Table Expression, Session, Temp Table, Clean data -> TMW, stored procedure and subqueries. 2:20:00 22/05 I have learned stored procedure, ALTER stored procedure(including parameters) and subquery -> we will do a project involving data exploration with COVID19 data.
@congminhlo244
Today 8-April 2025, I am a Real Time Analyst from Workforce Management Team learning to become Data Analyst. This is just to bookmark my progress. Everyday I take at least 1 hour to learn. Day 1 (24-March): Review my material 00:00:00 to 01:19:15 (because I have learnt basic SQL since 2023) Day 13 (7-April): Finished my first Data Analyst Portfolio Project | SQL Data Exploration 01:19:15 to 03:34:01 Day 14 (8-April): 03:34:01 to 03:52:57 Day 15 (9-April): 03:52:57 to 04:00:00 Day 23 (16-April): 04:00:00 to 7:38:37 Day 27 (20-April): 7:38:37 to 11:05:20
@heyyoufounddaniel7331
As an entry level data analyst, I want to say thank you for putting this together here.
@AlexTheAnalyst