Channel Title: Absent Data Channel Description: Channel is dedicated to providing you with quick and easy tutorials to expand your skills in Data Analysis Learn practical formulas in Statistics, DAX, Python, Excel and acquire Machine Learning techniques that will make you become a amazing data analyst. <video> Amazon SQL Interview | Percent Change | FORMAT & LAG Functions Description: In this video, we will explore how to calculate the percent change by using the LAG function and format. #sql #sqlinterview #dataanalysis Learn and Practice SQL coding online at DataCamp, check out my affiliate link: https://datacamp.pxf.io/KjO5ba You can practice SQL interview Questions on Stratascratch https://stratascratch.com/?via=absentdata </video> <video> Data Analysis End to End | Project Analytics | Beginner Friendly Description: End-to-End Data Analysis Project from start to finish using Excel, SQL Server, and Power BI, we’ll build a Product Analytics Dashboard that tracks revenue, profits, and trends. You’ll learn how to break down management request, build a database, write SQL queries, and create executive level dashboard. Whether you’re just starting out or want to sharpen your skills, this is a great way to dive into real-world data analysis. What is Covered in the Analysis 1. Build a Database 2. Develop SQL 2. Connect to Power BI 3. Create a Dashboard ****To create a Date table***** 1. Click Modeling in the top ribbon 2. Choose New Table 3. Add this to you DAX formula: Calendar = CALENDAR("1/1/2022","12/31/2023") Timestamps ----------------------------------------------------------------------------------------- 0:45 Management Request 1:54 Company Overview 2:15 Dashboard Preview 3:36 Installing SQL Server and SQL Server Studio 7:25 Building your Database 14:20 Exploring the Database Tables 17:35 Developing SQL Queries 28:51 Connecting Database to Power BI 31:30 Building the Dashboard Structure 36:08 Image Slicer 38:46 Animated Image 44:28 Bar Charts (Revenue by Country and Over Time) 52:40 Pie Charts 54:47 Add Column and Profit Calculation 1:00:03 Year on Year Calculation ( see table calculation above) 1:04:17 Visual Card 1:15:08 Toolttip Page Creation 1:24:29 Cleaning up the Dashboard You can get the zip files here on Github: https://github.com/Gaelim/youtube/blob/master/Data%20Analysis%20Project%20November%202024%20-%20Copy.zip You can get the dataset files: https://absentdata.com/data-analysis/end-to-end-data-analysis-project/ See other End-to-End Projects here: https://www.youtube.com/playlist?list=PLi5spBcf0UMXfbMt1X2bHQkk7mHXkTUhs Try Stratascratch to practice SQL interview question from top companies https://stratascratch.com/?via=absentdata Learn SQL at LearnSQL.com with great course for Data Analyst https://learnsql.com/?ref=nmm1zdj </video> <video> Amazon SQL Interview Question | Biggest Black Friday Discount | New 2024 Description: We have a new SQL interview question from Amazon! We’re figuring out which product had the biggest Black Friday discount: Here is the workflow: First, we use a CTE (Common Table Expression) to get the original price (from January 1, 2023) and the Black Friday price (from November 25, 2023) for each product using a CASE statement. Next, we calculate the discount percentage by subtracting the Black Friday price from the original price, then dividing by the original price. Finally, we ORDER BY the discount in descending order, so the biggest discounts appear at the top. Get the full SQL code here : /* Which Product has the Biggest Black Friday Discount*/ with prices as( select product_name, max(case when price_date ='2023-01-01' then price end) as original, max(case when price_date ='2023-11-25' then price end) as black_friday from black_friday_sales group by product_name) select product_name, (original-black_friday)/original as discount from prices where black_friday is not null order by 2 desc Here is the data if you want to practice product_name,category,price_date,price iPhone 13,Electronics,2023-01-01,799.99 iPhone 13,Electronics,2023-03-15,749.99 iPhone 13,Electronics,2023-06-01,699.99 iPhone 13,Electronics,2023-09-15,649.99 iPhone 13,Electronics,2023-11-25,599.99 AirPods Pro,Electronics,2023-01-01,249.99 AirPods Pro,Electronics,2023-07-01,219.99 AirPods Pro,Electronics,2023-11-25,199.99 Nike Air Max,Footwear,2023-01-01,129.99 Nike Air Max,Footwear,2023-04-15,149.99 Nike Air Max,Footwear,2023-08-01,159.99 Nike Air Max,Footwear,2023-12-01,139.99 #sqlqueryinterviewquestionsandanswers #sql #dataanalysis #dataanalyst </video> <video> META | SQL Interview | Peak Period | CONCAT and Subquery Description: In the SQL interview question for data analysts given by META. You will use SQL code to find the peak period for online activity. You will use the CONCAT and DATEPART Functions to find the peak period by segmenting the start and end timestamps by the hour. Next, you will convert your findings into a subquery to aggregate the users. #sqlinterview #dataanalysis #sql Learn and Practide SQL coding online at DataCamp, check out my affiliate link: https://datacamp.pxf.io/KjO5ba </video> <video> SQL Interview | Top 25% of Customer Sales | Visa | Percent Rank & CTE Description: #sqlqueryinterviewquestionsandanswers #sql #dataanalysis We will use Percent RANK and CTEs to find the top 25% of customer sales from this SQL interview question given by Visa. You can find the full SQL query here: https://github.com/Gaelim/youtube/blob/master/Top_25_percent_SQL And dataset here: https://github.com/Gaelim/youtube/blob/master/user_activity_purchase_data_enhanced_alphanumeric.csv Check this SQL data analysis project https://youtu.be/KN9nGtpTjL8?si=iAHF8fjfeoDemNqr Learn and Practice SQL coding online at DataCamp. Check out my affiliate link: https://datacamp.pxf.io/KjO5ba You can practice SQL interview Questions on Stratascratch https://stratascratch.com/?via=absentdata </video> <video> End-to-End Data Analysis Project 2024 | SQL & Power BI | Beginner Friendly Description: You will build an end-to-end data analysis project in less an 1 hour. This is aimed at beginners who want to understand the whole end-to-end process of data analysis. It will help you develop skills and see a typical analysis request. You are the Data Analyst in this Story: You will act as a data analyst helping Toman Bike Share to understand if increasing prices next year is possible. All files and data provided. Here is the workflow below 1. Build a Database 2. Develop SQL queries 3. Connect Power BI to your database 4. Build a Dashboard 5. Make Analysis Recommendations You can find all the files here for download https://github.com/Gaelim/YT_bike_share click the data file and download it as raw file. Check me out on LinkedIn https://www.linkedin.com/in/gaelimholland/ Video Time Stamps: 0:49 Data Analysis Request Email 2:01 Downloading and Install Microsoft SQL Server and SQL Server Studio 5:22 Setting up your Database and Tables 10:25 Developing your SQL queries 22:43 Dashboard Preview 23:49 Connect Power BI to the Database 27:44 Building the Dashboard 55:05 Answer the Analysis Question 1:00 Recommending Price Increase Check me out on Linked In or DM me: https://www.linkedin.com/in/gaelimholland For up to 50% at DataCamp, check out my affiliate link: https://datacamp.pxf.io/KjO5ba </video> <video> SQL Interview Question | American Express | ROW NUMBER & CTE Description: We will use the ROW NUMBER function to get the last 5 transactions by Affiliate ID with a CTE, and these aggregate our results to get the total amount for the last 5 transactions per ID #sql #sqlinterviewquestions #dataanalysis </video> <video> UBER SQL Interview Question | Late Delivery Percent | DATEDIFF, CTE, & CASE Description: We want to find the percentage of deliveries that are late based on the data from UBER, We are going to use DATEDIFF, CASE, and CTEs to answer this question. You can find the SQL query here. https://github.com/Gaelim/youtube/blob/master/late_delivery_SQL Find the dataset here https://github.com/Gaelim/youtube/blob/master/orders_data.csv #sqlserver #sqlinterviewquestionsandanswers #dataanalysis </video> <video> End-to-End SQL & Power BI 2024 | Create a Database | Novice Friendly | Project Analysis Description: Welcome to this end-to-end data analysis project! You'll step into the shoes of a data analyst to create a dashboard using real project data. Don't worry, I've got you covered with all the data files and step-by-step video instructions. You'll learn how to clean, analyze, and visualize the data in a straightforward way. Let's dive in and build something awesome! Table of Contents 0:33 Workflow 0:40 Requirements from Stakeholders 1:52 Dashboard Preview 2:25 Downloading the Database Software 5:12 Install and Setup Server 9:13 Creating your Database 16:05 Writing SQL Queries 28:50 Connecting Database to Power BI 32:20 Dashboard Build 1:14:11 Final Dashboard Correction: To get he capital = you can double the salary or multiply the department budget by 0.5. You don't need to do both. You can find the files here: https://absentdata.com/data-analysis/data-analysis-end-to-end-project/ For up to 50% at DataCamp, check out my affiliate link: https://datacamp.pxf.io/KjO5ba #dataanalysis #sql #powerbi </video> <video> Most Common SQL Interview Question | SELF JOIN | Manager Direct Reports Description: This is one of the most common SQL interview questions you will receive. I have seen it on at least 5 interviews. Please make sure you master this. The key here is a self join with having. #sql #sqlinterview #dataanalysis </video> <video> SQL Interview Question | Percent of Total Sales | SUBQUERY Description: This is one of the most common SQL interview question which is to derive the percent of total sales. Follow along to see how we can use a Subquery to get the correct query using SQL #sql #dataanalyst #sqlinterview </video> <video> SQL Interview Question - SALESFORCE - RANK Description: Try this SQL interview question from Salesforce where you need to find the average call duration of the first call. Here you will be utilizing RANK, Subquery and the WHERE clause to get the average call duration. #sqlqueryinterviewquestionsandanswers #dataanalysis </video> <video> Data Analysis Case Study | Product Recommendation | Fortune 100 Company Description: This is a full case study where you will be doing a full end to end data analysis using Excel, Power Query and Power BI. The problem statement asks us to create an analysis to discover what product mix should be recommended for the new stores. #datanalysis #excel #powerbi 0:59 Case Study Breakdown 4:27 Data Exploration 8:20 Cleaning Data with Power Query 12:43 Create columns 19:10 Grouping Data 25:02 Creating Product Mix Proportions 28:54 Unpivoting/Melting Data 30:56 Visualizing Data in Excel 37:20 Correlations 38:29 Loading Data in Power BI 39:51 Shape Map 44:20 Dashboard Build 54:20 Building DIM tables 59:05 Dynamic Narrative 1:03:00 Recommendations and Summary Get the data here: https://github.com/Gaelim/Case-Study </video> <video> Amazon SQL Interview Question | Subquery VS. CTE | 2 Solutions Description: We will find the most recent transaction in our dataset. This is a question from Amazon data analyst SQL interviews. There are two solutions here one with CTE and the other with a subquery. Also, we will utilize a self join and ROW NUMBER for ranking transactions. #dataanalysis #sqlqueryinterviewquestionsandanswers #sql </video> <video> ZILLOW SQL Interview Question | SUBQUERY + HAVING #sql #dataanalysis Description: In this video we will tackle a SQL interview question quest from ZILLOW. We need to find the city averages that are higher than the national average. We can easily do this with a SUBQUERY and the HAVING operator. Lets dive into to see how this is done. </video>

Contacts and Links

Description

Channel is dedicated to providing you with quick and easy tutorials to expand your skills in Data Analysis Learn practical formulas in Statistics, DAX, Python, Excel and acquire Machine Learning techniques that will make you become a amazing data analyst.

Videos from channel