- Видео 234
- Просмотров 326 051
Analyst Adithya
Индия
Добавлен 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.
Data Analytics Full Project Course with Google Stack in 3 Hours: SQL, Python, Excel & Visualisation
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 SQL in Google BigQuery
01:40:13 Social Media Analysis using Looker Studio
02:17:32 Calorie Data Analysis using Python in Google Colab
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 SQL in Google BigQuery
01:40:13 Social Media Analysis using Looker Studio
02:17:32 Calorie Data Analysis using Python in Google Colab
Просмотров: 422
Видео
Google Analytics Tutorial: A Quick Intro for Data Analysts
Просмотров 178День назад
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
Просмотров 13921 день назад
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
Просмотров 149Месяц назад
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
Просмотров 154Месяц назад
In this video, I ask some questions to Gemini, Chatgpt and also Claude to see differences in answers. ⏲️ TimeStamps ⏲️ 00:00 Intro 01:08 Cohort Analysis 04:56 Previous Value or Percentage Change 07:15 VLookup Formula 08:47 3 Digital KPIs
Movie Box Office Analysis Using Python: Bollywood or Tollywood or Kollywood?
Просмотров 177Месяц назад
In this video, I analyse box office collections of first 7 days of some big indian movies in Tamil, Telugu and Hindi industries and analyse hidden patterns. Here is the file: drive.google.com/file/d/1MQpvsFH196BtU6CyPf07ruxMdtWvO5oS/view?usp=sharing Here is link to the code: colab.research.google.com/drive/1PuOFWG6HRHWvk2vTtc1QCE8FkOrSclEb?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 01:56 Home Sta...
4 Types of Technical Interviews & Strategies: Data Analyst Jobs
Просмотров 233Месяц назад
In this video, I explain 4 types of technical interviews possible in data analyst job processes. Here is a link to my complete data analyst free bootcamp: ruclips.net/p/PLRRWaBOk3DqfvW1Q55aBqasibP06nmTcy Here is link to swiggy projects: ruclips.net/p/PLRRWaBOk3DqeUVyltnpVN8S108bNlbj-T Here is the link to SQL scenario questions: ruclips.net/p/PLRRWaBOk3DqeEUGvOEfYcHgxa1gS7KxPQ ⏲️ TimeStamps ⏲️ 0...
Airlines Data Analysis using SQL | Travel Analysis on Real Data | SQL Portfolio Project
Просмотров 352Месяц назад
In this video, I analyse by writing SQL Queries based on my own travel data to different continents. The focus is on thinking of the important metrics to look at and playing around with some SQL. Here is the link to the dataset Data: drive.google.com/file/d/1HwIJXZca164Yu4wGmlPnvgLR8hZO6Gir/view ⏲️ TimeStamps ⏲️ 00:00 Intro 00:55 Unique Airlines Taken 01:35 Year with maximum source cities 02:53...
Monthly & Grocery Expenses Analysis using Power BI | Business Insights | Power BI Portfolio Project
Просмотров 2932 месяца назад
In this video, I analyse my own expenses data of the past 4 months and dig deep into to find out why is it optimised and how you can also control your expenses. Here is the link to the dataset: docs.google.com/spreadsheets/d/1F3Jx4enn5pwqeVkvYjfPNFBYkmdSH-0fp4mGAeWzVRw/edit?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 01:30 Expense by Month 02:16 Category Wise Expense 03:28 Grocery & Restaurant Dee...
Vande Bharat Analysis using SQL | Insights on Train & Speed Data | Google BigQuery Portfolio Project
Просмотров 2462 месяца назад
In this video, I solve some questions based on Vande Bharat data for trains. Here is the link to the dataset: drive.google.com/file/d/1NjQXw0MVI4PRmPUsvfuXfNbSGi5e-Xfw/view?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 01:05 Distinct Zones 01:26 One Way Trains 01:58 Fastest Trains & Longest Distance 03:56 Different Speed for Onward & return Journeys 12:15 How Many Days Train Operates
What I'd do if I had to learn Data Analytics from scratch in 2024 | Data Analyst Roadmap w/ projects
Просмотров 2,6 тыс.2 месяца назад
In this video, I explain some of the tools and concepts you can cover to start on the journey of becoming a data analyst. I will also touch on projects and further practice you can do in topics related to SQL, Excel & Power BI or some visualisation tool. Check out the bootcamp playlist here: ruclips.net/p/PLRRWaBOk3DqfvW1Q55aBqasibP06nmTcy Here is the SQL scenario questions playlist: ruclips.ne...
Power BI Tutorial: Bins, Lists & Drill Down Concepts with Use Cases
Просмотров 2352 месяца назад
In this video, I explain about the concept of bins,lists and drill down in Power BI. These concepts can help us analyse data at a sub category level or two levels in one chart. Link to the ecommerce data-docs.google.com/spreadsheets/d/1aCL5yre2_-u1kV1vtxLfhHOAlTbeEZ6f dQ6KqdPGw/edit?usp=sharing Link to airlines data- drive.google.com/file/d/1HwIJXZca164Yu4wGmlPnvgLR8hZO6Gir/view ⏲️ TimeStamps ⏲...
E-commerce Analysis using Power BI | Business Insights on Flipkart Data | Power BI Portfolio Project
Просмотров 1,2 тыс.3 месяца назад
In this video, I analyse my own ecommerce dataset using Power BI and answer some business questions. The focus is on thinking of the calculations and learning some cool DAX formulas. Here is the link to the two dataset: docs.google.com/spreadsheets/d/1aCL5yre2_-u1kV1vtxLfhHOAlTbeEZ6f dQ6KqdPGw/edit?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 00:39 Customer with Most Orders 01:12 Total Money by Cit...
Airlines Data Analysis using Power BI | Travel Dashboard on Live Data | Power BI Portfolio Project
Просмотров 1,5 тыс.3 месяца назад
In this video, I explain to build a simple dashboard in Power BI based on my own travel data to different continents. The focus is on thinking of the important metrics to look at and playing around with some features in Power BI. Here is the link to the two datasets Data: drive.google.com/file/d/1HwIJXZca164Yu4wGmlPnvgLR8hZO6Gir/view?usp=sharing ⏲️ TimeStamps ⏲️ 00:00 Intro 00:53 New Column 01:...
Swiggy Data Analysis using Power BI | Food Delivery Analytics Dashboard | Power BI portfolio project
Просмотров 1,5 тыс.3 месяца назад
In this video, I explain to build a simple dashboard in Power BI based on my own Swiggy data. The focus is on thinking of the important metrics to look at and playing around with some features in Power BI. Here is the link to the two datasets Items: drive.google.com/file/d/1tBhnXmWmzTlR9ZdT_sUcpmG5ZGKBk8OA/view Orders: drive.google.com/file/d/1W2-nBsOVEAPUhmi7jkTPhRhuah1tYznu/view ⏲️ TimeStamps...
Important Announcement for those planning for Master Abroad, Investing & More!
Просмотров 1303 месяца назад
Important Announcement for those planning for Master Abroad, Investing & More!
3 LinkedIn Tips That Can Be a Game Changer in Data Job Hunt
Просмотров 1924 месяца назад
3 LinkedIn Tips That Can Be a Game Changer in Data Job Hunt
3 Power BI Scenario Questions for DAX: Calculate & Filter Clauses
Просмотров 2464 месяца назад
3 Power BI Scenario Questions for DAX: Calculate & Filter Clauses
2024 India Election Analysis Project in Google Sheets: Congress vs BJP Comparison
Просмотров 3304 месяца назад
2024 India Election Analysis Project in Google Sheets: Congress vs BJP Comparison
What Does a Data Analyst Actually Do: 5 Common Tasks
Просмотров 3884 месяца назад
What Does a Data Analyst Actually Do: 5 Common Tasks
Indian Cricket Team T20 WC Performance Analysis using SQL | Cricket Analytics | Scenario Questions
Просмотров 2904 месяца назад
Indian Cricket Team T20 WC Performance Analysis using SQL | Cricket Analytics | Scenario Questions
Excel Scenario Questions In EdTech Company Case Study: Specific Formulas & Use Cases
Просмотров 2355 месяцев назад
Excel Scenario Questions In EdTech Company Case Study: Specific Formulas & Use Cases
Important E-commerce KPIs for Data Analyst Interviews: Improve Your Business Acumen
Просмотров 3185 месяцев назад
Important E-commerce KPIs for Data Analyst Interviews: Improve Your Business Acumen
Data Analyst Job Process Experience for Germany: Tips & Personal Insights
Просмотров 1 тыс.5 месяцев назад
Data Analyst Job Process Experience for Germany: Tips & Personal Insights
Are Tech Jobs in the USA Overrated? US vs UK vs Germany Job Market comparison
Просмотров 3365 месяцев назад
Are Tech Jobs in the USA Overrated? US vs UK vs Germany Job Market comparison
SQL Case Study in Berlin Based Startup Interview: Window Functions Complex Use Cases
Просмотров 1 тыс.6 месяцев назад
SQL Case Study in Berlin Based Startup Interview: Window Functions Complex Use Cases
IPL 2024 Analysis using SQL | Cricket Analytics with SQL | SQL Scenario Questions
Просмотров 7506 месяцев назад
IPL 2024 Analysis using SQL | Cricket Analytics with SQL | SQL Scenario Questions
Data Analyst vs Business Analyst | What are the differences?
Просмотров 5346 месяцев назад
Data Analyst vs Business Analyst | What are the differences?
Data Analytics Contest Prize Winners & freeCodeCamp Feature Announcement
Просмотров 4456 месяцев назад
Data Analytics Contest Prize Winners & freeCodeCamp Feature Announcement
Thanks a lot Adithya. Much needed Google stack video for me. Very helpful.
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
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💜👍
Thanks Bro💜👍
Here data.comulative used for what purpuse , is full of the word -table name ?
"Waah kya Scene Hai . . . !!!"
Very useful video... Keep going
Very useful insights.. Thank you so much sir😊
Is this trail version or free forever
did stripe provide you a document of the problem during interview?
How to get a csv file
Great 😃
Very useful. Thank you very much
it would be so great if you write down the link to those sql practical exercises which you mentioned earlier in 3:45 about advanced SQL. Thanks by the way
Hi Aaditya, it would be helpful if u share the file ur are using in demo
Thank you bhai ❤❤❤❤ bahut hi achhe se bataya 😊
perfect video
Can you write the code step by step🥺❤
👋🏻👋🏻👋🏻👋🏻👋🏻
Thank you for this video. Very clear and easy explained.
Could we install to window 7?
why are you still using windows 7?
Thank you, I had been struggling with it for a bit.
Glad I could help!
What if selmon finds this video 😶🌫️
Haaa haaa really 1st comment ? 😂
Power BI Uses?
Data analysis
@@English.with.motion Dataset Mill skta h?
Good video
Thanks
Please do more this kind of videos brother
Feel free to checkout my SQL Projects playlist!
you are awesome bro
Thank you so much 😀
Link
This is not the crt way....use DENSE_RANK instead of rank
Thanks u sirji I am also practicing your dmart data
All the best
🎉
Thank you 😊
You're welcome 😊
Hi Aditya your play is enough for get first data Analyst job for freshers?
The data set link is not working it is not showing data set
Bro, i am a 2024 pass out, my educational background is computer engineering, will it help in improving probability of my chance to get shortlisted for DA role in comparison to those applying from non cs/tech?
i have seen many thing but i wasted my time
Please make our time worth it
Is Python not Required?
Same qsn
great question.. Python is definitely valuable and obviously you can continue upskilling on the side in Python while you start applying.. if you wait till mastering python to apply it will delay your process.. so start applying with excel, sql, Power BI and a good LinkedIn and continue Python on the side..
One help please make a video to create a perfect LinkedIn profile from scratch for data analyst roles
sure in future will try to post something around this..
Is ML is necessary for data analyst roles
understanding of regression, statistics and hypothesis testing is usually good.. but first learn sql excel and some business stuff before moving to ML
Bro, you haven't told to learn python and pandas ,numpy? Is it not required initially?
@@manikraokulkarni7878 ????
@@im_soumya39I am asking, we don't have to learn python for analyst job role? Bro Aaditya not told about python in his video
great question.. python is an absolute plus for sure.. but start applying with excel sql and Power BI.. continue learning Python on the side.. dont wait till mastering Python to apply.. LinkedIn presence and network is definitely important for the first job..