Analytical Guy
Analytical Guy
  • Видео 115
  • Просмотров 600 329
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...
Просмотров: 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

Комментарии

  • @shivabajelan3341
    @shivabajelan3341 14 часов назад

    Thanks for the great information, Atikant.

  • @user-pq2vf4nl9i
    @user-pq2vf4nl9i 15 часов назад

    Pretty informative and trendy

    • @analyticalguy
      @analyticalguy 14 часов назад

      @@user-pq2vf4nl9i thank you 🙏

    • @analyticalguy
      @analyticalguy 14 часов назад

      @@user-pq2vf4nl9i what is your favourite skill?

  • @shreya6115
    @shreya6115 15 часов назад

    Thanks for the guidance

    • @analyticalguy
      @analyticalguy 14 часов назад

      @@shreya6115 you’re welcome. 🙏

  • @amansinha5456
    @amansinha5456 15 часов назад

    Sir, Kuch FMCG Sales Ke upar bhi video banaiye, Kaafi Month Ho Gaya hai Video banaye

    • @analyticalguy
      @analyticalguy 14 часов назад

      @@amansinha5456 what kind of videos in FMCG? Excel reporting for FMCG Sales?

  • @hendrag593
    @hendrag593 2 дня назад

    Thanks for this great video

    • @analyticalguy
      @analyticalguy 2 дня назад

      @@hendrag593 I’m glad it was useful.

  • @sasyaashok
    @sasyaashok 3 дня назад

    Sir pls do video about team handling fmcg

  • @sasyaashok
    @sasyaashok 3 дня назад

    Great content

  • @AyushVerma-bi1me
    @AyushVerma-bi1me 4 дня назад

    🎉🎉🎉 good morning Bhai

  • @OluwaseunOgunseitan-x8e
    @OluwaseunOgunseitan-x8e 4 дня назад

    thank you very much

    • @analyticalguy
      @analyticalguy 4 дня назад

      @@OluwaseunOgunseitan-x8e you’re welcome ☺️

  • @rahulamesar5387
    @rahulamesar5387 7 дней назад

    Good learning sir, thank you

    • @analyticalguy
      @analyticalguy 6 дней назад

      @@rahulamesar5387 I’m glad it was helpful 🙌

  • @atulshinde5343
    @atulshinde5343 7 дней назад

    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.

    • @analyticalguy
      @analyticalguy 7 дней назад

      I’m glad this video was useful. I’ll be uploading more videos on business analyst journey.

  • @sunitabhatara9535
    @sunitabhatara9535 7 дней назад

    Thanks for urs answer

  • @sunitabhatara9535
    @sunitabhatara9535 7 дней назад

    I want to know by doing master in data science may is it eligible for PR

    • @analyticalguy
      @analyticalguy 7 дней назад

      @@sunitabhatara9535 there is no direct pathway to PR. But it might help. It will depend on various other factors.

  • @atulshinde5343
    @atulshinde5343 10 дней назад

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

    • @analyticalguy
      @analyticalguy 10 дней назад

      @@atulshinde5343 thanks Atul, did you check other videos on Interview preparations? Check my channel, I’ll also post some more this month.

  • @shreya6115
    @shreya6115 15 дней назад

    Easiest way to showcase your project using GitHub. Thank you 🙏

  • @shivabajelan3341
    @shivabajelan3341 15 дней назад

    Thanks for sharing Atikant, great job!

    • @analyticalguy
      @analyticalguy 15 дней назад

      @@shivabajelan3341 thank you so much Shiva! :)

  • @peace-18
    @peace-18 16 дней назад

    I need access

    • @analyticalguy
      @analyticalguy 16 дней назад

      @@peace-18 pls check I have provided the access.

    • @peace-18
      @peace-18 16 дней назад

      @@analyticalguy thnx man

    • @analyticalguy
      @analyticalguy 16 дней назад

      @@peace-18 you’re welcome :)

  • @MADHUSUDANJAISWAL-q1q
    @MADHUSUDANJAISWAL-q1q 16 дней назад

    Very Helpful video on Power BI topics, It will more helpful if you share the PPT also

    • @analyticalguy
      @analyticalguy 16 дней назад

      @@MADHUSUDANJAISWAL-q1q sure, please mail me on analyticalguys@gmail.com I’ll share it with you.

  • @ajityadav-db7qq
    @ajityadav-db7qq 17 дней назад

    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.

    • @analyticalguy
      @analyticalguy 16 дней назад

      @@ajityadav-db7qq that’s a great suggestion, feedback taken. Would love to make a video on this. 👍

  • @analyticalguy
    @analyticalguy 17 дней назад

    Please reach out to me if you are stuck anywhere while creating this dashboard.

  • @shreya6115
    @shreya6115 17 дней назад

    Amazing visualization

  • @manoharpatil7006
    @manoharpatil7006 17 дней назад

    All things are very best but Hindi me hota to aur best hota

    • @analyticalguy
      @analyticalguy 17 дней назад

      Apologies for that. Please try subtitles?

  • @kebincui
    @kebincui 17 дней назад

    excellent 👍

    • @analyticalguy
      @analyticalguy 17 дней назад

      Thank you so much! I hope you can create a project for your GitHub.

  • @analyticalguy
    @analyticalguy 17 дней назад

    Olympics Dataset : bit.ly/4fwrxE3 This link also has the desired Dashboard result (PBIX file)

  • @priscillah.5106
    @priscillah.5106 17 дней назад

    Thank you sir, please share the dataset

    • @analyticalguy
      @analyticalguy 17 дней назад

      Thanks for mentioning, I have uploaded the dataset and pbix file in the comments. Please check!

  • @analyticalguy
    @analyticalguy 24 дня назад

    Thanks everyone who attended this LIVE Stream. For those who will watch now, please ignore first 5 minutes, there was a technical glitch.

  • @_subh4m
    @_subh4m 28 дней назад

    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

  • @xingme1974
    @xingme1974 28 дней назад

    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)

  • @user-sw6jx4gi1g
    @user-sw6jx4gi1g Месяц назад

    excellent tip. and if we want to add a list of columns, using a list of names query, how is it done?

  • @DumpalaSwami
    @DumpalaSwami Месяц назад

    It's very useful can I get the sheet .how We can find outlet category based on average sales or payment

  • @Rabbani_World_Flock
    @Rabbani_World_Flock Месяц назад

    But in Document format how can I give the final conclusion with my client all about report???

  • @775shahrukh
    @775shahrukh Месяц назад

    Waah sir wah...more n more..

  • @DatawithHimanshu
    @DatawithHimanshu Месяц назад

    Lot's of information for Data analytics especially Power BI. Great Video

    • @analyticalguy
      @analyticalguy Месяц назад

      @@DatawithHimanshu thank you 🙏

  • @SadafAkhtar-jy4dq
    @SadafAkhtar-jy4dq Месяц назад

    This video is very helpful for me

    • @analyticalguy
      @analyticalguy Месяц назад

      @@SadafAkhtar-jy4dq I’m glad you liked it. 👍

  • @mayankmaheshwari3684
    @mayankmaheshwari3684 Месяц назад

    Would it be possible to create daily or weekly charts, comparing how much more/less I spent in percentage or absolute value?

    • @analyticalguy
      @analyticalguy Месяц назад

      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.

  • @shreya6115
    @shreya6115 Месяц назад

    This is super helpful. Great content

  • @yours.lovingly
    @yours.lovingly Месяц назад

    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.

    • @analyticalguy
      @analyticalguy Месяц назад

      @@yours.lovingly which course are you looking for?

    • @yours.lovingly
      @yours.lovingly Месяц назад

      @@analyticalguy master of data science

    • @yours.lovingly
      @yours.lovingly Месяц назад

      @@analyticalguy pls reply bro ;)

    • @analyticalguy
      @analyticalguy Месяц назад

      @@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.

    • @yours.lovingly
      @yours.lovingly Месяц назад

      @@analyticalguy thanks bro😇

  • @Aaakash_guptaG
    @Aaakash_guptaG Месяц назад

    I did every step right but my filter is not working(showing, hidden and reset) all these.. What can i do..?

  • @riyadeogaonkar5171
    @riyadeogaonkar5171 Месяц назад

    Sir why there is the error while close and apply error😊

  • @nazlcelikbilek1360
    @nazlcelikbilek1360 Месяц назад

    Very helpful. Thank you 🙌

    • @analyticalguy
      @analyticalguy Месяц назад

      @@nazlcelikbilek1360 I’m glad it was helpful :)

  • @jbenchris
    @jbenchris Месяц назад

    Your video will be used only in North Indian, and it is not useful to non Hindi speaking states as well as international viewers.

  • @thepratikjoshi44
    @thepratikjoshi44 Месяц назад

    Super helpful!!!

    • @analyticalguy
      @analyticalguy Месяц назад

      @@thepratikjoshi44 thanks Pratik 🙏

    • @thepratikjoshi44
      @thepratikjoshi44 Месяц назад

      @@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. :)

    • @analyticalguy
      @analyticalguy Месяц назад

      @@thepratikjoshi44 sure Pratik, I’ll make sure you get such videos :)

  • @surendersingal2192
    @surendersingal2192 Месяц назад

    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

  • @srushtiOm
    @srushtiOm Месяц назад

    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.

  • @deepanshuhans9425
    @deepanshuhans9425 Месяц назад

    Your passion for Analytics is contagious and has made learning it truly enjoyable

  • @vicenteantoniomagallanesju5289
    @vicenteantoniomagallanesju5289 Месяц назад

    This is a great video

  • @sunnyblaze4912
    @sunnyblaze4912 Месяц назад

    Thank you