![Analytical Guy](/img/default-banner.jpg)
- Видео 115
- Просмотров 600 329
Analytical Guy
Индия
Добавлен 4 сен 2021
The Objective of this channel is to give knowledge related to Data Analytics for FREE.
If you want to join my newsletter, you can submit your details here: forms.gle/MPMNQRjYmzBWTerr8
This newsletter is a strong community of 2k+ people getting knowledge related to Data Analytics (Excel, Power BI, SQL, Python), as well as Job & Interview tips.
#dataanalytics #dataanalyst #datascientist #microsoftpowerbi #sql
If you want to join my newsletter, you can submit your details here: forms.gle/MPMNQRjYmzBWTerr8
This newsletter is a strong community of 2k+ people getting knowledge related to Data Analytics (Excel, Power BI, SQL, Python), as well as Job & Interview tips.
#dataanalytics #dataanalyst #datascientist #microsoftpowerbi #sql
How to Land Your First Data Analyst Job: Essential Tips & Strategies for Success!
▶ Have queries regarding Data Analytics or studying abroad? Get in touch!
topmate.io/analyticalguy
Ready to start your career as a Data Analyst? This video is your ultimate guide to landing that first job! Whether you're a recent graduate or making a career switch, I've got you covered with actionable tips and proven strategies.
🔍 What You'll Learn:
1. Effective Job Search Strategies: Discover where and how to find the best data analyst job opportunities.
2. Master the STAR Method: Learn how to craft compelling responses to interview questions and stand out from the competition.
3. Resume Tips That Work: Create a resume that highlights your skills and experiences in a way that catches recruiter...
topmate.io/analyticalguy
Ready to start your career as a Data Analyst? This video is your ultimate guide to landing that first job! Whether you're a recent graduate or making a career switch, I've got you covered with actionable tips and proven strategies.
🔍 What You'll Learn:
1. Effective Job Search Strategies: Discover where and how to find the best data analyst job opportunities.
2. Master the STAR Method: Learn how to craft compelling responses to interview questions and stand out from the competition.
3. Resume Tips That Work: Create a resume that highlights your skills and experiences in a way that catches recruiter...
Просмотров: 84
Видео
Excel Formula Full Course: Become a PRO in 45 Minutes | Become a Data Analyst Faster
Просмотров 42216 часов назад
▶ Dataset Excel file for practice bit.ly/ExcelFormulaCheatsheet ▶ Have queries regarding Data Analytics or studying abroad? Get in touch! topmate.io/analyticalguy Are you ready to elevate your Excel skills? In this 45 minute comprehensive tutorial, we dive deep into advanced Excel formulas that every professional should know. Whether you're a data analyst, business analyst, finance expert, or j...
POWER BI Full Project - Olympics Dashboard | From Scoping to Sharing on GitHub and LinkedIn
Просмотров 1,6 тыс.14 дней назад
In this comprehensive tutorial, we'll take you through every step of creating a Power BI dashboard, from initial project scoping to the final delivery. You'll learn how to plan and design your dashboard, build it in Power BI, and ensure it meets your project's goals. But we won't stop there - I'll also guide you through the process of uploading your completed project to GitHub for sharing, and ...
Step-by-Step Calendar Creation with Native Visuals, DAX Calculations, and Conditional Formatting
Просмотров 273Месяц назад
▶ Dataset Excel file & Power BI file for practice bit.ly/3zjf5qL ▶ How to create DATE table bit.ly/3XzzZvX ▶ Get Mentored | Analytics in Australia topmate.io/analyticalguy/ ▶ DAX Course (End-To-End) bit.ly/DAXCourse In this video, I will create a Calendar using Native visual available in Power BI. There are various other ways of doing this, lets discuss them. To create a Calendar, you would nee...
Mining Industry in Western Australia | In conversation with Russel, CEO of RadiXplore | Tech Jobs
Просмотров 128Месяц назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this comprehensive video, we explore one of the most crucial industries in Western Australia - mining. In this episode, Russell discusses the mining industry, identifies gaps, and reveals business oppor...
From Non-Tech to Power BI Developer | In conversation with Federico | Impact on Jobs after ChatGPT?
Просмотров 675Месяц назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this comprehensive video, we delve into the journey of transitioning from a non-tech background to a flourishing career in the data field. Explore the intricate challenges and solutions in Power BI, the...
Data Analytics - Job Interview Guide with Douglas Robertson | Data Engineer vs Data Scientist
Просмотров 2042 месяца назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this episode, we are diving into tech job interviews for candidates in Australia. We'll cover the latest trends in resumes, top in-demand skills, strategies to impress recruiters, the role of recruitmen...
Understanding GenAI & Cloud Computing | In conversation with Jia from Microsoft | Perth Data Podcast
Просмотров 1382 месяца назад
Join us in this enlightening episode as we sit down with Jiaranai, a Data & AI Architect at Microsoft, to uncover her journey and insights into the world of AI and cloud computing. This episode is packed with valuable advice and tips tailored for students aspiring to enter the tech industry. Highlights: Discover Jiaranai’s path from relationship management to becoming a leading AI expert at Mic...
Cracking the Tech Job Market with Fabrizio | Resume Tips | Do's and Don'ts from a Consultant
Просмотров 3332 месяца назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this episode, we are discussing about the tech job market in Perth, Western Australia. We will also touch base on resume writing, Cover Letter, LinkedIn, and many other important aspect related to recru...
From Analyst to Managing Director at GemCutter Analytics | Jacob Hammer | Management Consulting
Просмотров 3133 месяца назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this episode, we are unlocking the Power of Business Analytics with Jacob Hammer. 📊 Dive deep into the core competency required to become a business analyst as we explore the secrets to mastering analyt...
Navigating the Job Market in Data Science | Problems with ChatGPT | In Conversation with Dr Kruti
Просмотров 1613 месяца назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this episode, we are discussing the job market and the skill set relevant now for the Data Scientists. To discuss the same, today we have Dr Kruti Lehenbauer from Analytics TX (Texas, United States). Pl...
From Ex-Accountant to Director at Access Analytic | In Conversation with Wyn Hopkins | Microsoft MVP
Просмотров 3263 месяца назад
Welcome to a new episode of Analytics Unplugged Podcast | Conversations with Experts, where we bring in Data Experts to share their career journey and expertise to help others learn and grow. In this episode, we are unlocking the Power of Data Analytics with MVP Microsoft Expert, Wyn Hopkins! 📊 Dive deep into Power BI, DAX, Power Query, and Fabric as we explore the secrets to mastering analytic...
Boosting Self-Confidence in professional career with Dr. Katherine Iscoe | Analytics Podcast S1E1
Просмотров 1693 месяца назад
In the debut episode of "Analytics Unplugged: Conversations with Experts" we dive into an unexpected yet invaluable topic: self-respect & confidence. Join us as we sit down with Dr Katherine Iscoe, renowned for their expertise in self-respect and personal development, to explore how cultivating these elements can empower data professionals to excel in their field. While data skills are undoubte...
Advanced Power Query Tutorial | 5 Practical Use Cases and Tips for Excel & Power BI Users | M Query
Просмотров 3,8 тыс.5 месяцев назад
Advanced Power Query Tutorial | 5 Practical Use Cases and Tips for Excel & Power BI Users | M Query
Learn Data Science with R: Unveiling Insights from the PIMA Dataset 📊📈 | Beginner's Guide | R Studio
Просмотров 457Год назад
Learn Data Science with R: Unveiling Insights from the PIMA Dataset 📊📈 | Beginner's Guide | R Studio
Mastering Data Science | My journey in Australia's Top University #australia #datascience
Просмотров 4 тыс.Год назад
Mastering Data Science | My journey in Australia's Top University #australia #datascience
Simple Explanation on Data Engineer vs Data Analyst vs Data Scientist vs ML Engineer
Просмотров 594Год назад
Simple Explanation on Data Engineer vs Data Analyst vs Data Scientist vs ML Engineer
🔥 Discover the Secrets to Landing Your Dream Data Analytics Internship! 🔥
Просмотров 999Год назад
🔥 Discover the Secrets to Landing Your Dream Data Analytics Internship! 🔥
Master Grouping and Segmenting in Power BI with DAX: Advanced Tips and Tricks | Measure vs Column
Просмотров 2,8 тыс.Год назад
Master Grouping and Segmenting in Power BI with DAX: Advanced Tips and Tricks | Measure vs Column
Analyzing Data like a Pro: Building a Project Dashboard with Power BI - Maven Analytics Challenge
Просмотров 5 тыс.Год назад
Analyzing Data like a Pro: Building a Project Dashboard with Power BI - Maven Analytics Challenge
Power BI License quick Update | Which Plan is Right for You? Complete Guide $$ #powerbi #microsoft
Просмотров 302Год назад
Power BI License quick Update | Which Plan is Right for You? Complete Guide $$ #powerbi #microsoft
Step-by-Step Guide: Creating a Date Table in Power BI | Everything about Date table in 15 minutes
Просмотров 1,3 тыс.Год назад
Step-by-Step Guide: Creating a Date Table in Power BI | Everything about Date table in 15 minutes
Top 7 MIS Interview questions | L'oreal Real Dataset | Crack your next MIS Interview | INDEX | MATCH
Просмотров 982Год назад
Top 7 MIS Interview questions | L'oreal Real Dataset | Crack your next MIS Interview | INDEX | MATCH
Mastering Data Modelling in Power BI: Tips, Tricks & Best Practices 🏦 | Star ⭐ Schema | Fact Table
Просмотров 1,8 тыс.Год назад
Mastering Data Modelling in Power BI: Tips, Tricks & Best Practices 🏦 | Star ⭐ Schema | Fact Table
Microsoft Power BI END-TO-END PROJECT on MAVEN Analytics Data Playground #mavenfamilyleavechallenge
Просмотров 3,1 тыс.Год назад
Microsoft Power BI END-TO-END PROJECT on MAVEN Analytics Data Playground #mavenfamilyleavechallenge
Complex SQL to find most searched ITEM | Convert Comma Separated Values(CSV)into rows|#SQLWednesdays
Просмотров 526Год назад
Complex SQL to find most searched ITEM | Convert Comma Separated Values(CSV)into rows|#SQLWednesdays
Can you get 20 Lakhs package as a Data Analyst? Skills required| How to search for JOBs | #linkedin
Просмотров 1,9 тыс.Год назад
Can you get 20 Lakhs package as a Data Analyst? Skills required| How to search for JOBs | #linkedin
Write Complex SQL Queries 2 | Cricket Analytics | Interview questions with Solution | #SQLWednesdays
Просмотров 608Год назад
Write Complex SQL Queries 2 | Cricket Analytics | Interview questions with Solution | #SQLWednesdays
TOP 10 SQL Query Interview Questions and Answers (HARD)| Project for Expert Professionals | Part4
Просмотров 2,3 тыс.Год назад
TOP 10 SQL Query Interview Questions and Answers (HARD)| Project for Expert Professionals | Part4
Write Complex SQL Queries | Interview questions with Solution | Windows Function | #SQLWednesdays
Просмотров 770Год назад
Write Complex SQL Queries | Interview questions with Solution | Windows Function | #SQLWednesdays
Thanks for the great information, Atikant.
I’m glad you liked it. 🎉
Pretty informative and trendy
@@user-pq2vf4nl9i thank you 🙏
@@user-pq2vf4nl9i what is your favourite skill?
Thanks for the guidance
@@shreya6115 you’re welcome. 🙏
Sir, Kuch FMCG Sales Ke upar bhi video banaiye, Kaafi Month Ho Gaya hai Video banaye
@@amansinha5456 what kind of videos in FMCG? Excel reporting for FMCG Sales?
Thanks for this great video
@@hendrag593 I’m glad it was useful.
Sir pls do video about team handling fmcg
Great content
@@sasyaashok thank you 🙏
🎉🎉🎉 good morning Bhai
@@AyushVerma-bi1me 🙌
thank you very much
@@OluwaseunOgunseitan-x8e you’re welcome ☺️
Good learning sir, thank you
@@rahulamesar5387 I’m glad it was helpful 🙌
Hi sir video is awesome. We r people required this type of videos more. It has enhanced our knowledge. After practice more we have understood all for advanced excel. Pls make more videos on this sir.
I’m glad this video was useful. I’ll be uploading more videos on business analyst journey.
Thanks for urs answer
I want to know by doing master in data science may is it eligible for PR
@@sunitabhatara9535 there is no direct pathway to PR. But it might help. It will depend on various other factors.
Sir really superb work u r done in this video.......thank u so much pls make interview question videos which has been ask in interview time.......
@@atulshinde5343 thanks Atul, did you check other videos on Interview preparations? Check my channel, I’ll also post some more this month.
Easiest way to showcase your project using GitHub. Thank you 🙏
@@shreya6115 Thank you 🙏
Thanks for sharing Atikant, great job!
@@shivabajelan3341 thank you so much Shiva! :)
I need access
@@peace-18 pls check I have provided the access.
@@analyticalguy thnx man
@@peace-18 you’re welcome :)
Very Helpful video on Power BI topics, It will more helpful if you share the PPT also
@@MADHUSUDANJAISWAL-q1q sure, please mail me on analyticalguys@gmail.com I’ll share it with you.
The dashboard and storytelling is quite impressive, for next please consider making some videos on Hard problems faced while Data modeling for different cases like duplicate, two fact tables, indexing, two way filter, schemas, and SCD etc.
@@ajityadav-db7qq that’s a great suggestion, feedback taken. Would love to make a video on this. 👍
Please reach out to me if you are stuck anywhere while creating this dashboard.
Amazing visualization
@@shreya6115 thank you 🙏
All things are very best but Hindi me hota to aur best hota
Apologies for that. Please try subtitles?
excellent 👍
Thank you so much! I hope you can create a project for your GitHub.
Olympics Dataset : bit.ly/4fwrxE3 This link also has the desired Dashboard result (PBIX file)
Thank you sir, please share the dataset
Thanks for mentioning, I have uploaded the dataset and pbix file in the comments. Please check!
Thanks everyone who attended this LIVE Stream. For those who will watch now, please ignore first 5 minutes, there was a technical glitch.
RLP = 100 - 0.2*RLP RLP(1+0.2) = 100 Now can u plz tell me from where u are getting that 1 [1+0.2] 3:12
The below formula throuws errors specifically for times slots between 11 Am and 12 PM. Can yo uplease help me resolve it at the earliest? Number.Round(Number.From([OrderTime]) * (60*24/60)) /(60*24/60)
excellent tip. and if we want to add a list of columns, using a list of names query, how is it done?
It's very useful can I get the sheet .how We can find outlet category based on average sales or payment
But in Document format how can I give the final conclusion with my client all about report???
Waah sir wah...more n more..
Lot's of information for Data analytics especially Power BI. Great Video
@@DatawithHimanshu thank you 🙏
This video is very helpful for me
@@SadafAkhtar-jy4dq I’m glad you liked it. 👍
Would it be possible to create daily or weekly charts, comparing how much more/less I spent in percentage or absolute value?
Yes, we can use multiple visuals in POWER BI to create interactive spent analysis. I would be uploading expense tracker where anyone can analyse their spends on a daily basis.
This is super helpful. Great content
Thank you 🙏
Hi brother. I have to choose between uni of Adelaide, uwa and rmit. Ultimately what i need is to equip myself for the industry. Considering living cost, course fees and quality of the course can you suggest which one would be best.
@@yours.lovingly which course are you looking for?
@@analyticalguy master of data science
@@analyticalguy pls reply bro ;)
@@yours.lovingly again it depends on the end goal. All 3 universities mentioned have their own advantages and disadvantages. UWA & Uni of Adelaide are undoubtedly the best. It will depend on the location where you would like to study. Also from PR perspective.
@@analyticalguy thanks bro😇
I did every step right but my filter is not working(showing, hidden and reset) all these.. What can i do..?
Sir why there is the error while close and apply error😊
Very helpful. Thank you 🙌
@@nazlcelikbilek1360 I’m glad it was helpful :)
Your video will be used only in North Indian, and it is not useful to non Hindi speaking states as well as international viewers.
Super helpful!!!
@@thepratikjoshi44 thanks Pratik 🙏
@@analyticalguy More such videos would be really helpful, as I mostly struggle to demonstrate my findings and missout the important kinds of stuff while presenting, even after developing wonderful dashboards. :)
@@thepratikjoshi44 sure Pratik, I’ll make sure you get such videos :)
Thank u, youngman. Great video about indian n world footwear production statistics. Looks like india,s unorganized production us more than organized? Is unorganized production regulated by India govt anyway or consumer is Left to own dealings? Jussojuan
with cte as ( select *, rank() over(partition by salesman order by year, sales) as rnk from salesdump), cte_1 as ( Select *, case when sales < lead(sales) over (partition by salesman order by year, sales) then 1 when sales < lead(sales,2) over (partition by salesman order by year, sales) then 1 when sales < lead(sales,3) over (partition by salesman order by year, sales) then 1 when sales > lag(sales,1) over (partition by salesman order by year, sales) then 1 else 0 end as 'Result' from cte) Select * from cte_1 where Result = 1 Is this a valid solution? I could get the final solution.
Your passion for Analytics is contagious and has made learning it truly enjoyable
Thank you so much :)
This is a great video
Thanks Vicent 👍
Thank you