- 244
- 400 782
Analyst Adithya
India
เข้าร่วมเมื่อ 26 ม.ค. 2022
I am Vyas Adithya and I have more than 6 years of experience in business intelligence, data analytics and marketing analytics.
I also secured the Amazon Business Analyst internship offer in the EU headquarters in Luxembourg.
I have previously worked for e-commerce companies in Mexico City and Berlin and have used SQL,Power BI, Python, Microsoft Excel on a regular basis.
I have trained more than 300 people on tech tools previously and helped them secure internships in BI and analyst roles in Berlin and other German cities.
I also secured the Amazon Business Analyst internship offer in the EU headquarters in Luxembourg.
I have previously worked for e-commerce companies in Mexico City and Berlin and have used SQL,Power BI, Python, Microsoft Excel on a regular basis.
I have trained more than 300 people on tech tools previously and helped them secure internships in BI and analyst roles in Berlin and other German cities.
Marketing Data Challenge: Drive Insights & Perform Analysis in SQL or Python or Looker Studio
In this video, I give you a marketing data challenge based on a fictional ecommerce furniture company data. You would need to try and come with insights or recommendations based on tool of your choice could be SQL or Python or Excel or dashboarding tool.
Think of the important metrics and KPIs and come up with an analysis.
Here is the link to the data: docs.google.com/spreadsheets/d/1_c7ZN4a8ybj_yJ7_h2oqEvEcll9Sk5hFd3x4M7_zxbE/edit?usp=sharing
Think of the important metrics and KPIs and come up with an analysis.
Here is the link to the data: docs.google.com/spreadsheets/d/1_c7ZN4a8ybj_yJ7_h2oqEvEcll9Sk5hFd3x4M7_zxbE/edit?usp=sharing
มุมมอง: 93
วีดีโอ
How to Become a Data Analyst in 2025: Skills Roadmap & Resources
มุมมอง 636วันที่ผ่านมา
In this video, I share the skills, resources and tactics needed to find your data analyst job in 2025. Here is the link to the resources sheet: docs.google.com/spreadsheets/d/1tcnj16TdraqxhN5aSTIScU76DStmNIo_A2MlTTYwc5w/edit?usp=sharing Here is the link to SQL Projects: th-cam.com/play/PLRRWaBOk3Dqc5U3xIqSm4JQAFy6NreiwD.html Here is the link to Power BI Projects: th-cam.com/play/PLRRWaBOk3Dqd0t...
3 Useful Channels to Learn Beyond Data Analytics: AI, Data Engineering & ML
มุมมอง 65828 วันที่ผ่านมา
In this video, I share about 3 useful TH-cam channels to learn about data science, AI and data engineering topics. Shashank Channel: www.youtube.com/@UCvZnwzmc3m1Eush-Or8Z6DA Pradip Channel: www.youtube.com/@UC3-uyUX8s536lUkrWwYvfDg Zach Channel: www.youtube.com/@EcZachly_/videos ⏲️ TimeStamps ⏲️ 00:00 Introduction 00:28 Data Science 01:16 NLP & AI 01:58 Data Engineering
Crypto Data Analysis SQL Project | Bitcoin & Ethereum Price Analysis | Google BigQuery Use Case
มุมมอง 90หลายเดือนก่อน
In this video, I analyse bitcoin and ethereum data and calculate some interesting trends and numbers which you can use as reference to start investing in the crypto market. Here is the link to bitcoin sample data: docs.google.com/spreadsheets/d/1O9vpQAag1xa4btzGWJ513ZbKIw0ty2I2TOceHWu_Bw8/edit?pli=1&gid=0#gid=0 Here is the link to ethereum data: docs.google.com/spreadsheets/d/150VPHkg63g9bKj56Q...
Practical BigQuery SQL Project Challenge: Crypto Data Price Analysis Questions
มุมมอง 125หลายเดือนก่อน
In this video, I give a few questions to analyse based on downloading ethereum or bitcoin data from the website coinmarketcap. Here is the link to the website link for data download: coinmarketcap.com/currencies/bitcoin/historical-data/ Here is the link to the questions: docs.google.com/spreadsheets/d/14z1DGf-Jh5XVMLFVV6G_i_C2Mv1aMhX_i0-xcggBLcs/edit?usp=sharing Analyse in BigQuery: th-cam.com/...
4 Useful Python Scripts: Regular Use Cases for Daily Work
มุมมอง 64หลายเดือนก่อน
In this video, I explain 4 cool and short python scripts which we can use to automate a lot of regular work. Here is the link to the script: colab.research.google.com/drive/1OhL MxhgdqCJn5br9uMVC_CL4aEX_xi?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Introduction 00:28 URL Shortener Script 02:16 Python Script to Summarise Reviews Using WordCloud 04:16 Python Script to Generate Random Data 06:36 Python Sc...
SQL & Python Live Case Study in Berlin E-Commerce Startup Interview: Business Use Cases
มุมมอง 190หลายเดือนก่อน
In this video, I solve a couple of SQL & Python questions asked in an ecommerce startup interview process in Berlin. Here is the link to data used in BigQuery: docs.google.com/spreadsheets/d/1cFuWMl6RadrRNomXfzg9JAKq3LDgcbJhW630GIZH3eY/edit?usp=sharing Here is the link to Python File: colab.research.google.com/drive/15TIIGUBjvbfto6IIoIiEZd0E7nYM6LB0?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Introducti...
3 Crucial Tips for Improving Communication: Data Analyst Job Interviews
มุมมอง 972 หลายเดือนก่อน
In this video I give 3 interesting tips to improve communication in data analyst job interviews. ⏲️ TimeStamps ⏲️ 00:00 Introduction 00:16 Listen to your Interviewer 00:42 Practice your answers 01:15 Star Format for Answers
Data Analyst SQL Portfolio Project | Data with Danny Case Study Analysis
มุมมอง 7412 หลายเดือนก่อน
Hi, In this video, we explore the case study on Danny's dinner as part of the Data with Danny case study challenge. We'll dive deep into the data and leverage basic and intermediate sql functions to analyse the data and drive insights from the information. Whether you're a data analyst looking to improve your skills, a business owner curious about how TH-cam works, or simply someone interested ...
SQL Scenario Questions in MAANG in 30 Minutes: DataLemur Challenge
มุมมอง 2002 หลายเดือนก่อน
In this video I solve some MAANG questions from website Data Lemur. Here is the link to the website: datalemur.com/ ⏲️ TimeStamps ⏲️ 00:00 Year on Year Growth Rate 06:42 Rolling 3 Day Average 12:15 Page with No Likes 15:37 Laptop vs Mobile Viewership 19:12 Odd vs Even Measurements
Swiggy Data Portfolio Project in 4 Tools in 75 Minutes: Excel, SQL, Python & Power BI
มุมมอง 1.5K2 หลายเดือนก่อน
In this video, I analyse my Swiggy data in SQL, Excel, Python and Power BI. Here is the link to the items dataset: drive.google.com/file/d/1tBhnXmWmzTlR9ZdT_sUcpmG5ZGKBk8OA/view Here is the link to the orders dataset: drive.google.com/file/d/1W2-nBsOVEAPUhmi7jkTPhRhuah1tYznu/view Here is the link to the SQL Code: docs.google.com/document/d/16aLhQVhugFSS0iV3TAk4vanlf7QVuNUGt0Z2I62Jk9c/edit?tab=t...
Data Analytics Full Project Course with Google Stack in 3 Hours: SQL, Python, Excel & Visualisation
มุมมอง 9682 หลายเดือนก่อน
In this video, I do multiple projects and analyse data using Google Stack. We have analysis on different real data using Google Sheets, Google BigQuery, Looker Studio and Google Colab for Python. Here is the link to all the data and code used in the video: github.com/vyasadi/Free_Code_Camp_Material ⏲️ TimeStamps ⏲️ 00:00 Travel Expenses Analysis using Google Sheets 39:30 Expenses Analysis using...
Google Analytics Tutorial: A Quick Intro for Data Analysts
มุมมอง 2513 หลายเดือนก่อน
In this video, I explain the basics of Google Analytics and the reports in the interface. Here is the link to access the demo report: support.google.com/analytics/answer/6367342?hl=en#zippy=,in-this-article ⏲️ TimeStamps ⏲️ 00:00 Intro 00:50 Main Reports 02:53 Acquisition Report 03:52 Engagement Report 04:45 Purchase Report 05:27 Retention Report 05:45 Search Console Report 06:15 Tech & Demogra...
4 Mistakes to Avoid in Data Analyst Application Process
มุมมอง 1673 หลายเดือนก่อน
In this video I explain 4 common mistakes people make and can try to avoid in data analyst job application process. ⏲️ TimeStamps ⏲️ 00:00 Intro 00:13 Avoid same Resume for all Jobs 01:00 Submit Resume and Portfolios 01:27 Research about Company 02:01 Showcase Communication Skills
How's Work Life Balance in India: Real Data Comparison with Germany, USA, UK & Australia
มุมมอง 1873 หลายเดือนก่อน
In this video we have looking at the annual working hours for workers across countries and try to identify patterns. Here is the link to the data: docs.google.com/spreadsheets/d/1pO21Ui5ONMw0Y00F1rvjQl2mBuX2ZIx2iqvMly3DWyU/edit?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 00:58 Overall Trends 04:56 South Asian Countries 06:05 Overseas Trends in North America and Europe 09:11 2010s Decade vs Before ...
Asking Data Analytics & Business Questions: Claude vs Gemini vs ChatGPT
มุมมอง 2114 หลายเดือนก่อน
Asking Data Analytics & Business Questions: Claude vs Gemini vs ChatGPT
Movie Box Office Analysis Using Python: Bollywood or Tollywood or Kollywood?
มุมมอง 2304 หลายเดือนก่อน
Movie Box Office Analysis Using Python: Bollywood or Tollywood or Kollywood?
4 Types of Technical Interviews & Strategies: Data Analyst Jobs
มุมมอง 2524 หลายเดือนก่อน
4 Types of Technical Interviews & Strategies: Data Analyst Jobs
Airlines Data Analysis using SQL | Travel Analysis on Real Data | SQL Portfolio Project
มุมมอง 4944 หลายเดือนก่อน
Airlines Data Analysis using SQL | Travel Analysis on Real Data | SQL Portfolio Project
Monthly & Grocery Expenses Analysis using Power BI | Business Insights | Power BI Portfolio Project
มุมมอง 3765 หลายเดือนก่อน
Monthly & Grocery Expenses Analysis using Power BI | Business Insights | Power BI Portfolio Project
Vande Bharat Analysis using SQL | Insights on Train & Speed Data | Google BigQuery Portfolio Project
มุมมอง 2605 หลายเดือนก่อน
Vande Bharat Analysis using SQL | Insights on Train & Speed Data | Google BigQuery Portfolio Project
What I'd do if I had to learn Data Analytics from scratch in 2024 | Data Analyst Roadmap w/ projects
มุมมอง 2.7K5 หลายเดือนก่อน
What I'd do if I had to learn Data Analytics from scratch in 2024 | Data Analyst Roadmap w/ projects
Power BI Tutorial: Bins, Lists & Drill Down Concepts with Use Cases
มุมมอง 2655 หลายเดือนก่อน
Power BI Tutorial: Bins, Lists & Drill Down Concepts with Use Cases
E-commerce Analysis using Power BI | Business Insights on Flipkart Data | Power BI Portfolio Project
มุมมอง 1.4K5 หลายเดือนก่อน
E-commerce Analysis using Power BI | Business Insights on Flipkart Data | Power BI Portfolio Project
Airlines Data Analysis using Power BI | Travel Dashboard on Live Data | Power BI Portfolio Project
มุมมอง 2K6 หลายเดือนก่อน
Airlines Data Analysis using Power BI | Travel Dashboard on Live Data | Power BI Portfolio Project
Swiggy Data Analysis using Power BI | Food Delivery Analytics Dashboard | Power BI portfolio project
มุมมอง 2.1K6 หลายเดือนก่อน
Swiggy Data Analysis using Power BI | Food Delivery Analytics Dashboard | Power BI portfolio project
Important Announcement for those planning for Master Abroad, Investing & More!
มุมมอง 1346 หลายเดือนก่อน
Important Announcement for those planning for Master Abroad, Investing & More!
3 LinkedIn Tips That Can Be a Game Changer in Data Job Hunt
มุมมอง 1976 หลายเดือนก่อน
3 LinkedIn Tips That Can Be a Game Changer in Data Job Hunt
3 Power BI Scenario Questions for DAX: Calculate & Filter Clauses
มุมมอง 2647 หลายเดือนก่อน
3 Power BI Scenario Questions for DAX: Calculate & Filter Clauses
2024 India Election Analysis Project in Google Sheets: Congress vs BJP Comparison
มุมมอง 3747 หลายเดือนก่อน
2024 India Election Analysis Project in Google Sheets: Congress vs BJP Comparison
Hey Adithya, I assume that the cost provided in the data is cost of ad spent. If it is the ad cost, I am confused how do I calculate the cost of the product based on the given info?
Is it worth learning power BI for me being a PLSQL developer? Does power BI has demand in future for jobs?
A video on Business Analyst would be much appreciated.
Brother without completing graduation, can i get good job as a data analyst
Sir, the data is broken!
Thanks I'm literally looking to change from Networking to Data Analysis but need something to begin with. This is a great place to start
Go for it!
thankyou for amazing content
A fresher can't get a job as a Data Analyst
Thank you for this knowledge #OneMIndSet
how to get list of all the matches in a certain year
I have not excel subscription 😢 how can i do
Brother, how tough it is to get a internship in Germany as a data analyst in a renowned company if one doesn't have university degree but learns all the basic skills by oneself and has some relevant projects on portfolio?
Heyy Do i need german language to become data analyst at germany ??
thanks!
Here is My Answer @Adithya SELECT DISTINCT UserId, FIRST_VALUE(`Source Channel`) OVER( PARTITION BY UserId ORDER BY SessionId ) AS enter_source_channel, FIRST_VALUE(`Source Channel`) OVER( PARTITION BY UserId ORDER BY SessionId DESC ) AS last_source_channel FROM `extreme-gecko-407515.Blinkit_DA_Assignment.ecommerce` AS A WHERE EXISTS ( SELECT B.UserId FROM `extreme-gecko-407515.Blinkit_DA_Assignment.ecommerce` AS B WHERE Converted = 1 AND A.UserId = B.UserId )
Web3 Infinity Token is a diamond in the rough. Invest now and see it shine!
I have faith in the long-term survival of Web3 Infinity Token. It has sound foundations.
Web3 Infinity Token is the most secure alternative cryptocurrency due to the fact that its automated algorithms thwart decline markets, paper hands, and bot transactions. It will undoubtedly attain $10 in a short while.
I believe that Web3 Infinity Token's long-term viability has promise. Investment considerations should be given.
What makes you think there is no way? Do you know about Web3 Infinity Token? The price of this will soar to skyrocket
Web3 Infinity Token is the genuine deal! I've done my research, and this initiative has all the ingredients for success. Join the presale and secure your position in this groundbreaking endeavour!
Web3 Infinity Token's commercial potential is tremendous. It's worth considering for investment.
Web3 Infinity Token, the first token that is controlled by itself instead of owners or anybody else, is the best token in the world.
I've been keeping up with Web3 Infinity Token for a while, and I must say that I'm satisfied with its original approach to governance. Future events are thrilling!
Nice and good Information
Bro job market analysis platform Also With realtime data try
hi just , landed on ur page , i am a 2nd yr student i just have basic 2 doubts i have been learning excel for a good month and i am not able to see how it can be used in practicality 2nd as a fresher from non tech background how to apply skills ( excel and bi ) to outshine in interview thanks
kya Germany mai data analytics ki job mil sakti hai, ya fir web development hi kru for Germany bachelors kruga wha se after graduation job chayeh to kis field mai easily mil jaegi, web development, android development and data analytics. ab ye mat bolna ki skills ke upar hai, as a fresher acchi skill hai ye maano.
16:23 , There "ORDER BY order_date should be in DESC", like - """RANK() OVER (PARTITION BY a.customer_id ORDER BY order_date DESC)"""
Nice
how to fix webview2 error ?
Would be gratefull if somebody can send me an old EXE file to install PowerBI on Windows 8.1, thx a lot in advance!
really helpful video bro
bro you haven't provided the food data file
hey unfortunately the file got corrupted completely for some reason.. can follow along the other ones..
Thanks
Sir web scrapping pls upload
Thanks. it helped 😊
You're welcome!
WebDriver.__init__() got an unexpected keyword argument 'executable_path'. This is the error showing. Please kindly help
25:51 Here you can use Dropdown list rather than typing them, and i will appear in well structured way
Thanks a lot Adithya. Much needed Google stack video for me. Very helpful.
Happy to help
so where's the Link?
Bhai job market analysis platform banao na
Detail me like interesting stats by skills like using nlp for job description also
@chaitanyamate4026 yes very good idea.. something that can add value I am thinking of it in 2025..
Link
Thank you. Successful Downloaded and installed. Please why is it very slow😢
Is i5 10th generation enough for power bi?
I run in 5th generation
@@stdlife4093 i ran it on celeron n4500 with 4gb ram, No SSD
Hi Adithya, Do you provide training on GA ?
Link
you don't have to keep partition by as section has already unique value (i.e 'A' )
hey adithya, your explanation was super clear👍
Thanks Bro💜👍