Data Analyst Bootcamp for Beginners (SQL, Tableau, Power BI, Python, Excel, Pandas, Projects, more)

By freeCodeCamp.org
Published: Jan 09, 2024

“
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/

???? Access the datasets used here: https://github.com/AlexTheAnalyst

?? 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

[READ MORE]

”

Crazy Metallic Text in After Effects

By Olufemii
Published: Dec 28, 2023

“
???? Get Envato Elements for $9: https://1.envato.market/Y9vo9P
????? Unlimited After Effects Templates: https://1.envato.market/Y9vo9P

???? This text effect in After Effects gives you a sick metallic text effect in just a couple minutes

Beautiful Metallic Base Footage Download Link:
https://www.dropbox.com/scl/fi/73s4l8a61yrn9o0v7f9fm/Beautiful-Metalic-Base-Footage-i.mp4?rlkey=5orgb25lhbvvbuydwkgtd8g77&dl=0

???? If you found this tutorial helpful, consider hitting the like button, sharing it with your fellow video creators, and subscribing to our channel for more After Effects tutorials.

?? Subscribe Here: https://www.youtube.com/c/OlufemiiTuts

???? For more cool effects and video editing tips, follow us on our social media channels and stay updated: https://www.instagram.com/josholufemii

Thanks for your support! ????????

[READ MORE]

”

A Gift For You (Freebie Bundle & More)

By Olufemii
Published: Dec 26, 2023

“
Get The Free Bundle Here: https://bit.ly/3veh2mj
Get The Total Collection for $19: https://bit.ly/46KRQ57
Get the Music Video Mini-Masterclass for $49: https://bit.ly/MVS2024

A few gifts from me to you. I hope you enjoy them!

?? Subscribe Here: https://www.youtube.com/c/OlufemiiTuts

???? For more cool effects and video editing tips, follow us on our social media channels and stay updated: https://www.instagram.com/josholufemii

Thanks for your support! ????????

[READ MORE]

”

the end

By Cinecom.net
Published: Dec 22, 2023

“
Learn to blend multiple images together using Generative Fill in Adobe Photoshop!

This is the easiest way to create composites! What do you think?

???? SUBSCRIBE to get more amazing Photoshop tutorials!
? https://hi.switchy.io/Subscribe-to-PTC

???? LINKS:

Gen Fill Ultimate Guide ? https://www.youtube.com/watch?v=a3LXB-lA-Qw&list=PL3bfN-31F9RfB_7DNMOtdiPwvL-WAA-7F

Premium Tutorials ? http://ptcvids.com/shop

Become an Adobe Stock Contributor ? https://swiy.co/Stock-Contributor  

???? CONNECT
? TikTok ? https://www.tiktok.com/@jrfromptc 
? Instagram ? http://instagram.com/photoshoptrainingchannel

???? CREDITS
? Photoshop video tutorials by Jesus Ramirez

#PhotoshopTutorial #Photoshop #PTCvids

[READ MORE]

[READ MORE]

[READ MORE]

[READ MORE]

[READ MORE]

”

Learn After Effects 2024: Beginners Tutorial

By Olufemii
Published: Dec 22, 2023

“
???? Get Envato Elements for $9: https://1.envato.market/Y9vo9P
????? Unlimited After Effects Templates: https://1.envato.market/Y9vo9P

Learn After Effects with our project based After Effects Masterclass. You can download the link to the project file below and follow along. You will learn all the basics of After Effects as well as:

After Effects Interface
Importing Footage
Rotoscoping
Adding Text
Animating Text
Tracking Text
Adding Effects to Text
Rendering
VHS Effects
TV Screen Effects
Compositing Fog
Exporting

Here is the project file link: https://www.dropbox.com/scl/fo/h15uitksaph9jsbz0fng1/h?rlkey=egbvfyajol3rv2rw9rjcnntaj&dl=0

???? If you found this tutorial helpful, consider hitting the like button, sharing it with your fellow video creators, and subscribing to our channel for more After Effects tutorials.

?? Subscribe Here: https://www.youtube.com/c/OlufemiiTuts

???? For more cool effects and video editing tips, follow us on our social media channels and stay updated: https://www.instagram.com/josholufemii

Thanks for your support! ????????

#learnaftereffects #LearnAfterEffects2024 #BeginnerAfterEffects

[READ MORE]

”

Master Behavioral Interviews (for Software Engineers)

By freeCodeCamp.org
Published: Dec 21, 2023

“
Learn the essential skills and insights to succeed in behavior-based interviews. While many developers focus on preparing for technical interviews, you should also prepare for the other parts of job interviews. This course will help you navigate behavioral interviews with ease.

?? Course developed by @DestinationFAANG

?? Resources ??
? PPT deck with all the content: https://docs.google.com/presentation/d/16DNAiuCC_UohosO61I1UQvIdWFrjlUz7/edit?usp=drive_link&ouid=112476210230339613138&rtpof=true&sd=true
? Books:
– Cracking The Coding Interview
– 101 Great Answers to the Toughest Interview Questions
? Online Courses: LinkedIn learning, Coursera, Udemy
? Reddit: r/jobs, r/interviews, r/cscareerquestions
? Websites: Levels.fyi, Glassdoor,
? Other important resources:
– https://www.levels.fyi/blog/amazon-leadership-principles.html
– https://www.microsoft.com/en-us/microsoft-365-life-hacks/presentations/behavioral-interview-questions-answers
– https://www.tryexponent.com/blog/the-complete-google-behavioral-interview-guide

?? Contents ??
?? (0:00:29) Course outline
?? (0:02:38) Understanding different types of interviews
?? (0:04:03) Behavioral interview fundamentals
?? (0:10:34) Master of the STAR method
?? (0:19:59) Self-assessment and researching companies
?? (0:32:38) Case study 1: Netflix
?? (0:39:01) Case study 2: Amazon
?? (0:42:12) Behavioral interview question categories
?? (0:50:09) Top 50 behavioral interview questions
?? (2:01:20) How to deal with tough questions
?? (2:06:19) Non-verbal communication
?? (2:08:19) Strategies for preparation and useful Resources

???? Thanks to our Champion and Sponsor supporters:
???? davthecoder
???? jedi-or-sith
???? ????
???? Agustín Kussrow
???? Nattira Maneerat
???? Heather Wcislo
???? Serhiy Kalinets
???? Justin Hual
???? Otis Morgan
???? Oscar Rahnama

—

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

[READ MORE]

”

Learn JavaScript Interactively in NEW freeCodeCamp.org Curriculum

By freeCodeCamp.org
Published: Dec 20, 2023

“
freeCodeCamp.org has just launched a major update to the JavaScript Algorithms and Data Structures Certification. You can now learn JavaScript by building 21 projects!

Instead of coding through a series of challenges, you will learn the fundamentals of JavaScript by building 16 practice projects + 5 certification projects. Each of the practice projects will lead you through a step by step process for building out dynamic HTML, CSS and JavaScript applications.

Check out the new JavaScript curriculum at www.freeCodeCamp.org!

?? Jessica Wilkins created this walkthrough video.

[READ MORE]

”

Full Stack Tutorial – Hotel Management Site w/ Next.js, React, Sanity.io, Tailwind, Stripe

By freeCodeCamp.org
Published: Dec 19, 2023

“
Learn how to build and deploy a hotel management system with Next.js, React, Sanity.io, Tailwind CSS, and Stripe.

Features:
– Hotel Room Management CRUD with Sanity.IO
– Hotel Room Review
– Room Booking
– Checkout with Stripe
– Stripe webhook
– Light / Dark Mode with React Context
– Search (Room Type / Name)
– Authentication with Auth.JS
– Typescript
– useSwr Hook
– Deployment to Vercel
– And lots more…

???? Code: https://github.com/laribright/hotel-management

?? Course created by @codewithlari

?? Contents ??
0:00:07 Intro and Demo
0:09:07 New Project
0:14:42 Layout
0:35:02 Dark / White Theme
0:47:37 Authentication Page Setup
1:02:01 Sanity CMS Integration
1:13:57 Environment Variables
1:16:47 Sanity Schemas (user, account, booking, hotelRoom, verificationToken)
1:52:37 Authentication with next auth (Github, Email, Google)
2:12:02 Toast Notification
2:14:18 Fixing Api folder error
2:15:35 Authentication Continued
2:20:29 Complete Schema
2:25:22 Authentication Test
2:31:07 Configuring jwt
2:40:37 Custom classnames using tailwind directives
2:42:07 Hero Section
3:07:35 Search Feature
3:23:52 Gallery Component
3:25:47 NewsLetter Component
3:27:22 Featured Room
3:56:37 Nextjs Loading Component
3:58:33 Nextjs Error Component
4:02:27 Rooms Page
4:31:07 Room Details Page
6:03:28 Create Booking API
6:13:58 Middleware
6:16:07 Stripe Integration
6:38:45 Test Booking Payment
6:42:37 Webhooks
7:25:37 User Details Page
8:37:10 Rate Hotel Room
9:28:22 Display Hotel Room Rating
9:54:26 Git / Vercel / Deployment

???? Thanks to our Champion and Sponsor supporters:
???? davthecoder
???? jedi-or-sith
???? ????
???? Agustín Kussrow
???? Nattira Maneerat
???? Heather Wcislo
???? Serhiy Kalinets
???? Justin Hual
???? Otis Morgan
???? Oscar Rahnama

—

Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

[READ MORE]

”

Adobe and Davinci Will Destroy This Business

By Olufemii
Published: Dec 18, 2023

“
???? The Total Collection Bundle $59 (Save $138): https://bit.ly/46KRQ57

???? Join Josh on a captivating journey through the dynamic world of video production, where AI and innovation meet. In this essential episode, we delve into the revolutionary changes brought by Adobe and DaVinci, and explore how AI video editing tools and software are reshaping the industry.

#aivideoediting #Adobe #DaVinci #TechInsights

???? If you found this tutorial helpful, consider hitting the like button, sharing it with your fellow video creators, and subscribing to our channel for more Premiere Pro tutorials.

?? Subscribe Here: https://www.youtube.com/c/OlufemiiTuts

???? For more cool effects and video editing tips, follow us on our social media channels and stay updated: https://www.instagram.com/josholufemii

Thanks for your support! ????????

[READ MORE]

”

Microsoft Azure Fundamentals Certification Course (AZ-900) UPDATED – Pass the exam in 8 hours!

By freeCodeCamp.org
Published: Dec 14, 2023

“
Learn about Microsoft Azure and pass the Azure Fundamentals exam! The Azure Fundamentals exam (AZ-900) is an opportunity to prove knowledge of cloud concepts, core Azure services, Azure pricing, SLA, and lifecycle, and the fundamentals of cloud security, privacy, compliance, and trust. You will learn about all these things in this course.

?? Course developed by Andrew Brown of ExamPro. Check out the ExamPro YouTube channel: https://www.youtube.com/channel/UC2EsmbKnDNE7y1N3nZYCuGw
???? ExamPro Certification Training: https://www.exampro.co
???? Twitter: https://twitter.com/andrewbrown
???? Instagram: https://www.instagram.com/exampro.co/

?? Course Contents ??
?? (00:01:05) Introduction
Why should I get the AZ-900?
Exam Guide Walkthrough

?? (00:24:24) Cloud Concepts
What is Cloud Computing
Common Cloud Services
What is Microsoft and Azure
Benefits of Cloud Computing
Types of Cloud Computing
Types of Cloud Computing Responsibilities
Cloud Deployment Models
Total Cost of Ownership
CAPEX vs OPEX
Cloud Architecture Terminologies
High Availability
High Scalability
High Elasticity
Fault Tolerance
High Durability
Business Continuity Plan
Disaster Recovery Options

?? (00:57:44) Evolution of Compute
Dedicated Servers
Virtual Machines
Containers
Functions

?? (01:03:37) Global Infrastructure
Regions and Geographies
Paired Regions
Region Types and Service Availability
Special Regions
Availability Zones
AZ Supported Regions
Availability Sets Fault and Update Domains

?? (01:19:26) Getting Started Follow Along
Creating an Azure Account
Registered Providers
Create a User Account
Enabling MFA

?? (01:44:28) Compute Services
Computing Services
Azure Virtual machines
Operation Systems
Azure Scale Sets
Load Balancer
Scaling Policy
Health Montoring
Azure Virtual Desktop
Launching a Server

?? (02:06:57) Azure App Service
Introduction to Azure App Service
Runtimes
Custom Containers
Deployment Slots
App Service Enviroment
Azure App Service Plan
Configure and Deploy App Service

?? (02:27:13) Azure Container Instances
Introduction to ACI
Container Restart Policies
Container Environment Variables
Container Persistent Storage
Create an Azure Container Instances

?? (02:34:49) Virtual Networking
Introduction to VNets
VNet Peering
Network Interfaces
Subnets
Introduction to Azure DNS
Introduction to Virtual Network Gateways
Azure Express Routes
Private Links
Create a VNet

?? (02:49:27) Storage Accounts
Storage Services
Introduction to Storage Accounts
Storage Comparsion
Core Storage Services
Performance Tiers
Access Tiers
Replication Data Redundancy
LRS ZRS
GRS GZRS
RAGRS_RA GZRS
Introduction to Azure Blob
Azure Blob Types
AZCopy
Azure Storage Explorer
Introduction to Azure Files
Azure Files Use Cases
Azure File Sync
Storing files in Blob Storage

?? (03:24:14) Migration Options
Azure Cloud Adoption Framework
Azure Migrate
Azure Migrate Integrated tools
Azure Databox

?? (03:33:10) Microsoft Entra ID
Microsoft Entra ID Name Change
Introduction to Entra ID
Use Cases
AD vs AAD
Terminology
AD DS Microsoft Entra Domain Services
Single Sign On SSO
External Identities
Conditional Access

?? (03:49:46) Security
Zero Trust Model
Zero Trust Principles
Defense In Depth
Azure Defender
MFA
Azure Security Center
Key Vault
Azure DDoS Protection
Azure Firewall
Application Gateway
Routing Rules
Role Based Access Control RBAC
Management Groups
Service Health
Azure Advisor

?? (04:16:09) Technology Overview
Database Services
Application Integration
Developer and Mobile Tools
Azure DevOps Services
Cloud Native Networking Services
Enterprise Hybrid Networking Services
Azure Traffic Manager
IoT Services
Big Data and Analytics Services
AI ML Services Introduction
AI ML Services
Serverless Services

?? (04:39:34) Follow Alongs
Create a Resource Group
Creating an Azure Function

?? (04:45:54) Billing And Pricing
Service Level Agreements
Service Credits
Composite SLAs
TCO Calculator
Azure Marketplace
Azure Hybrid Benefit
Azure Subscriptions
First Look at Subscriptions
Pricing Calculator
Azure Cost Management
Resource Tags

?? (05:07:47) Governance and Compliance
Microsoft Purview Information Protection
Introduction
Resource Locks
Azure Blueprints

?? (05:15:31) Azure Management Tools
Azure Portal
Portal Preview and Features
Cloud Shell
Exploring Azure Cloud Shell
PowerShell
PowerShell Follow Along
Azure CLI
Azure CLI Follow Along
Visual Studio Code
Azure SDK Follow Along
Introduction to ARM
Use Cases
ARM Scoping
Introduction
ARM Templates Follow Along
Azure Bicep Follow Along
Azure Terraform Follow Along
Free Tier Spend and Usage

?? (08:12:11) Monitoring Tools
Introduction to Azure Monitor
The Pillars of Obervability
Anatomy of Azure Monitor
Log Analytics
Log Analytics Workspaces
Azure Alerts
Application Insights

[READ MORE]

”