Skip to main content

Data Analyst Bootcamp for Beginners


Curriculum for the course Data Analyst Bootcamp for Beginners

Become a data analyst by following along with this massive course. You will learn the core topics that data analysts need to know. And along the way, you will build plenty of projects to gain hands-on experience. ✏️ Bootcamp developed by @AlexTheAnalyst 🔗 Analyst Builder: https://www.analystbuilder.com/ ⭐️ Chapters ⭐️ 00:00:00 Introduction 00:01:10 How to Become a Data Analyst in 2023 (Completely FREE!) 00:15:08 SQL Basics Tutorial | Installing SQL Server Management Studio and Create Tables 00:24:44 SQL Basics Tutorial | Select + From Statements 00:30:57 SQL Basics Tutorial | Where Statement 00:38:54 SQL Basics Tutorial | Group By + Order By Statements 00:47:03 Intermediate SQL Tutorial | Inner/Outer Joins | Use Cases 01:02:55 Intermediate SQL Tutorial | Unions | Union Operator 01:08:19 Intermediate SQL Tutorial | Case Statement | Use Cases 01:15:44 Intermediate SQL Tutorial | Having Clause 01:19:15 Intermediate SQL Tutorial | Updating/Deleting Data 01:23:51 Intermediate SQL Tutorial | Aliasing 01:30:02 Intermediate SQL Tutorial | Partition By 01:34:16 Advanced SQL Tutorial | CTE (Common Table Expression) 01:37:59 Advanced SQL Tutorial | Temp Tables 01:48:18 Advanced SQL Tutorial | String Functions + Use Cases 02:02:06 Advanced SQL Tutorial | Stored Procedures + Use Cases 02:08:20 Advanced SQL Tutorial | Subqueries 02:16:57 Data Analyst Portfolio Project | SQL Data Exploration 03:34:01 Data Analyst Portfolio Project | Data Cleaning in SQL 04:28:41 Pivot Tables in Excel | Excel Tutorial 04:46:15 Formulas in Excel | Excel Tutorial 05:20:07 XLOOKUP in Excel | Excel Tutorial 05:38:52 Conditional Formatting in Excel | Excel Tutorial 05:59:49 Charts in Excel | Excel Tutorial 06:14:58 Cleaning Data in Excel | Excel Tutorial 06:36:02 Full Project in Excel | Excel Tutorial 07:16:49 How to Install Tableau and Create First Visualization | Tableau Tutorial 07:33:53 How to use Calculated Fields and Bins in Tableau | Tableau Tutorial 07:40:17 How to Create Visualizations in Tableau | Tableau Tutorial 07:54:20 How to use Joins in Tableau | Tableau Tutorial 08:08:47 Full Beginner Project in Tableau | Tableau Tutorial 08:53:02 How to Install Power BI | Building First Visualization | Microsoft Power BI 09:05:51 How to use Power Query in Power BI | Microsoft Power BI 09:18:57 How to Create and Manage Relationships in Power BI | Microsoft Power BI 09:27:33 How to use DAX in Power BI | Microsoft Power BI 09:43:16 How to use Drill Down in Power BI | Microsoft Power BI 09:49:18 How to use Conditional Formatting in Power BI | Microsoft Power BI 09:59:10 How to use Bins and Lists in Power BI | Microsoft Power BI 10:08:40 Popular Visualizations in Power BI | Microsoft Power BI 10:22:54 Full Power BI Guided Project | Microsoft Power BI 11:05:31 Installing Jupyter Notebooks/Anaconda | Python 11:15:34 Variables in Python | Python 11:28:51 Data Types in Python | Python 11:50:48 Comparison, Logical, and Membership Operators in Python | Python 11:58:03 If Else Statements in Python | Python 12:04:42 For Loops in Python | Python 12:13:59 While Loops in Python | Python 12:19:39 Functions in Python | Python 12:32:22 Converting Data Types in Python | Python 12:38:57 Building a BMI Calculator with Python | Python Project 12:53:19 Building an Automated File Sorter in File Explorer using Python | Python Project 13:10:10 Inspecting Web Pages with HTML | Web Scraping in Python 13:16:03 BeautifulSoup + Requests | Web Scraping in Python 13:23:01 Find and Find_All | Web Scraping in Python 13:35:11 Scraping Data from a Real Website | Web Scraping in Python 14:00:33 Reading in Files in Pandas | Python Pandas Tutorials 14:19:49 Filtering Columns and Rows in Pandas | Python Pandas Tutorials 14:31:37 Indexes in Pandas | Python Pandas Tutorials 14:42:59 Group By and Aggregate Functions in Pandas | Python Pandas Tutorials 14:54:04 Merging DataFrames in Pandas | Python Pandas Tutorials 15:16:13 Creating Visualizations using Pandas Library | Python Pandas Tutorials 15:33:02 Data Cleaning in Pandas | Python Pandas Tutorials 16:11:39 Exploratory Data Analysis in Pandas | Python Pandas Tutorials 16:43:52 Amazon Web Scraping Using Python | Data Analyst Portfolio Project 17:31:03 Automating Crypto Website API Pull Using Python | Data Analyst Project 18:22:13 How to Create a Portfolio Website 18:57:39 Create the Perfect Data Analyst Resume 19:15:16 Top 3 Tips on Using LinkedIn to Land a Job 19:22:05 Get Your Data Analyst Bootcamp Certification

Watch Online Full Course: Data Analyst Bootcamp for Beginners


Click Here to watch on Youtube: Data Analyst Bootcamp for Beginners


This video is first published on youtube via freecodecamp. If Video does not appear here, you can watch this on Youtube always.


Udemy Data Analyst Bootcamp for Beginners courses free download, Plurasight Data Analyst Bootcamp for Beginners courses free download, Linda Data Analyst Bootcamp for Beginners courses free download, Coursera Data Analyst Bootcamp for Beginners course download free, Brad Hussey udemy course free, free programming full course download, full course with project files, Download full project free, College major project download, CS major project idea, EC major project idea, clone projects download free

Labels:

Comments

Post a Comment

Popular posts from this blog

Fake CVR Generator Denmark

What Is Danish CVR The Central Business Register (CVR) is the central register of the state with information on all Danish companies. Since 1999, the Central Business Register has been the authoritative register for current and historical basic data on all registered companies in Denmark. Data comes from the companies' own registrations on Virk Report. There is also information on associations and public authorities in the CVR. As of 2018, CVR also contains information on Greenlandic companies, associations and authorities. In CVR at Virk you can do single lookups, filtered searches, create extracts and subscriptions, and retrieve a wide range of company documents and transcripts. Generate Danish CVR For Test (Fake) Click the button below to generate the valid CVR number for Denmark. You can click multiple times to generate several numbers. These numbers can be used to Test your sofware application that uses CVR, or Testing CVR APIs that Danish Govt provide. Generate
Post a Comment
Read more

How To Iterate Dictionary Object

Dictionary is a object that can store values in Key-Value pair. its just like a list, the only difference is: List can be iterate using index(0-n) but not the Dictionary . Generally when we try to iterate the dictionary we get below error: " Collection was modified; enumeration operation may not execute. " So How to parse a dictionary and modify its values?? To iterate dictionary we must loop through it's keys or key - value pair. Using keys
Post a Comment
Read more

How To Append Data to HTML5 localStorage or sessionStorage?

The localStorage property allows you to access a local Storage object. localStorage is similar to sessionStorage. The only difference is that, while data stored in localStorage has no expiration time untill unless user deletes his cache, data stored in sessionStorage gets cleared when the originating window or tab get closed. These are new HTML5 objects and provide these methods to deal with it: The following snippet accesses the current domain's local Storage object and adds a data item to it using Storage.setItem() . localStorage.setItem('myFav', 'Taylor Swift'); or you can use the keyname directly as : localStorage.myFav = 'Taylor Swift'; To grab the value set in localStorage or sessionStorage, we can use localStorage.getItem("myFav"); or localStorage.myFav There's no append function for localStorage or sessionStorage objects. It's not hard to write one though.The simplest solution goes here: But we can kee
Post a Comment
Read more