@@KarriNavya-vy9ir I’m glad it was helpful, Navya. Let me know if you want me to create a video on some other topic.
@KarriNavya-vy9ir6 сағат бұрын
@analyticalguy yes
@shanthiparameswaran33512 күн бұрын
Hi my husband received offer from Nottingham for sep 2025 intake.. i m working in india.. can he take me as well in student visa or thats not possible? Pls advise
@analyticalguy7 сағат бұрын
@@shanthiparameswaran3351 hi Shanti, I’m not a legal advisor, but from my knowledge you can go on student visa. UK and Australia both allow spouse to come on student visa.
@taizoondean6893 күн бұрын
Thanks for sharing God bless you
@analyticalguy3 күн бұрын
@@taizoondean689 I’m glad it was helpful to you.
@onyinyeMbonu-c6f3 күн бұрын
Thank you so much for these advices and clarifications concerning switching. I so much appreciate. I am at the moment of switching to Data Analyst. I have done courses on Power BI, Excel and SQL. I have also done some projects and visual Internship. I really want to have you as a mentor. If it will be possible, I will be very glad. Continue doing your good work.
@analyticalguy3 күн бұрын
@@onyinyeMbonu-c6f I can understand. But it’s nice that you have already started taking steps towards becoming a Data Analyst. You may connect on [email protected] my team will coordinate with you. Good Luck!
@afrozkhan28785 күн бұрын
Fantastic!! What is your name Sir?
@Perfectl_imperfect5 күн бұрын
All data.,no storytelling.... sorry brother
@sajedabegum22047 күн бұрын
simply describe, thank you very much brother. First time i am watching your video and subscribed
@kalpavriksha6669 күн бұрын
Gst forgotten
@sass52011 күн бұрын
Sir, this is Sanjukta Indu. Please Give me acces of the DAX course. I really need it
@analyticalguy9 күн бұрын
@@sass520 hi Sanjukta, you have lifetime access to this course. Please check again.
@sass5209 күн бұрын
@analyticalguy But Videos not There Sir
@ChrisSmithFW11 күн бұрын
This is a report, not a dashboard. A dashboard is created in the Power BI Service. It's not created with Power BI desktop.
@alexrosen876212 күн бұрын
Amazing tutorial. I learned a lot! Thank you 🙏
@analyticalguy11 күн бұрын
@@alexrosen8762 I’m glad it was helpful, Alex 👍
@zanelenetshapapame115114 күн бұрын
I enjoyed this interview Atikant! Well done
@analyticalguy14 күн бұрын
Thank you Zanele :)
@chandramohan141815 күн бұрын
pl provide files.thankyu
@analyticalguy15 күн бұрын
You will find the file here - analyticalguy.substack.com/p/effortless-data-cleaning-for-everyone
@analyticalguy14 күн бұрын
Are you able to download the file?
@chandramohan141814 күн бұрын
@@analyticalguy NO
@analyticalguy14 күн бұрын
@@chandramohan1418 did you check the link shared above?
Thank you very much. Great video. Im trying to replicate but when creating a table with let's say dates inlcuded, the calculated measure for Qty does not change. and repeats for all rows. can you do a video with this scenario? thanks a mill.
@sahilbhatia314319 күн бұрын
Thanks this is really useful,but when I am trying to type df. it is not showing the properties by default as it is showing in your video, so I wanted to check if there are any settings we need to do.
@analyticalguy19 күн бұрын
@@sahilbhatia3143 Hi Sahil, I am glad you liked it. If you are able to run python scripts but Intellisense isn't showing up, it might be because of your current Excel version's support for Python in that environment. - Try updating the current excel version. - Also enable Intellisense or AutoComplete in Excel. Let me know if that works.
@joewu608318 күн бұрын
I tried. df.dtypes() also donesn't work. df.info() works. But when I am coding in colab. Tried df.dtypes. It works. Python in excel a little bit unstable.
@joewu608318 күн бұрын
I tried again. It works. I don't know why.
@analyticalguy18 күн бұрын
@ that’s great Joe 👍
@rishabhdixit758820 күн бұрын
Transaction last month mtd mtlb bata dijiye sir
@Sham_97-q2q20 күн бұрын
asking for permission . the link
@balderblue357721 күн бұрын
Thank you Bro
@analyticalguy21 күн бұрын
@@balderblue3577 you’re welcome 🙏
@analyticalguy23 күн бұрын
It is a must have skill for any Data Analyst. Download the file and start practicing together: analyticalguy.substack.com/p/getting-started-with-python-in-excel Become PAID Subscriber for FREE using below Promo Code: analyticalguy.substack.com/1190a844
@easycookwithjas536426 күн бұрын
thank u for the well-explained video.
@analyticalguy13 күн бұрын
I am glad you found it helpful!
@AbeikuCobbinah26 күн бұрын
Very much insightful
@analyticalguy23 күн бұрын
@@AbeikuCobbinah thank you Abeiku 👍
@njitabernice414727 күн бұрын
i am interested in power BI and excel. your content is very informatve please can you mentor me?
@analyticalguy27 күн бұрын
@@njitabernice4147 thank you. You may reach out at [email protected]
@njitabernice414727 күн бұрын
please you show how to upload on github and data blog
@shreya6115Ай бұрын
Super helpful, thankyou for this video.
@analyticalguyАй бұрын
@@shreya6115 thank you Shreya! 🙌
@kristennaaАй бұрын
Best Microsoft Fabric video I've ever seen. Thanks so much for creating and sharing this! 👏
@analyticalguyАй бұрын
You are so welcome! 🙏🙏
@Fiona-g1qАй бұрын
Super helpful video...
@analyticalguyАй бұрын
Thank you Fiona :)
@GourishMJАй бұрын
pls share the link bro
@analyticalguyАй бұрын
@@GourishMJ Hi Gourish, I have shared the link, pls check the video description.
@GourishMJАй бұрын
@@analyticalguy we have to subscribe to your newsletter?
@Fiona-g1qАй бұрын
Super helpful Video
@analyticalguyАй бұрын
@@Fiona-g1q thank you Fiona 🙏
@Fiona-g1qАй бұрын
Thankyou analytical guy for sharing the resume template for data science students that is actually used in the real world and for keeping it free. And thankyou for this roadmap because it becomes confusing with so many things to do and this roadmap breaks down all elements perfectly.
@analyticalguyАй бұрын
@@Fiona-g1q I’m glad it was helpful, the purpose is to keep things simple. 👍
@Kkag-g1fАй бұрын
are bhai kyu bheed bdha rhe ho jinhone roadmap for data analyst in 2024 dekh kr data analysis sikha unko hi job nhi mil rhi itna competition hogya h phle hi
@analyticalguyАй бұрын
@@Kkag-g1f I can understand. The market is brutal and it’s hard to find a job. The only way to succeed is to upskill, this video is for the people who are not sure of what to study to become a Data Analyst.
@ASHARAJ-h9mАй бұрын
If possible plz make a video for a carrer gap candidate resume template...do they really have chances to get into this field....
@analyticalguyАй бұрын
@@ASHARAJ-h9m that’s a great idea, I’ll make a video on it this month 👍
@fredeata3944Ай бұрын
This looks promising. Hope to get the most out of this roadmap. Thanks for sharing.
@analyticalguyАй бұрын
@@fredeata3944 I’m glad you liked it. Just follow this approach and see the difference:)
@ajaykumar-bm3zuАй бұрын
your voice is not heardble
@analyticalguyАй бұрын
Hi Ajay, I have not received issues for this video. Can you pls check again?
@ajaykumar-bm3zuАй бұрын
@@analyticalguy sure bro
@fvinodhfranklinАй бұрын
from where i can get the real data?
@aryagigatАй бұрын
Atikant you look good in short hair pls change it
@analyticalguyАй бұрын
Thank you so much for your concern. You might see short hair after couple of months 😃
@chandramohan1418Ай бұрын
full course is there?if so ,give info.thank yu
@analyticalguyАй бұрын
Hi chandramohan, I have not prepared a full course, but week by week have been already created, I have shared the links for them. Let me know if you have any other question
@chandramohan1418Ай бұрын
@@analyticalguy is there any age limit for these posts?/
@analyticalguyАй бұрын
@@chandramohan1418 I transitioned in this field when I was 30.
@finfy7071Ай бұрын
Sir where is all l the links of the course as you discussed
@analyticalguyАй бұрын
Hi, please check the Video description, I have added the links. If you are looking for something specific, then let me know I can share some more.
@shreya6115Ай бұрын
Super helpful video, the way you've broken up all things data students need to do is super helpful. Thankyou so much 👍🙏
@analyticalguyАй бұрын
I am glad this video was helpful to you
@SakthiVel-ye3moАй бұрын
Thanks so much.❤❤❤
@analyticalguyАй бұрын
You’re welcome. Do you want to learn something specific? Let me know.
@sunnyg4261Ай бұрын
Phenomenal. When I converted the time, it rounds to the nearest whole number being 1 when the time is 23:57 as an example, and this chucks an error. I've circumvented this by using the rounddown function for the nearest 30 minute intervals. Is there an option to map to 00:00 and onwards over an hourly interval?
@analyticalguyАй бұрын
@@sunnyg4261 that’s a great question, Sunny. I’m not sure if we have that capability, it’s not that big problem so I do it Manually for this scenario.
@Sham_97-q2qАй бұрын
can u provide canva resume link . only docs is present in ur link
Hello, I am new to Data analytics and confused about what to use..For example: for data cleaning: do you use SQL, power query or python? For analysis: python, SQL, R programming.. For visualizations: Power BI or R programming.. There are a lot of tools so it's difficult to focus on one programming language/tool for cleaning, one programming language/tool for analysis, one programming language/tool for visualization.. I would like guidance on choosing a clear path. Thank you.
@analyticalguyАй бұрын
@@LeanderSatya hi Satya, you have a valid concern. There is no one size fit all. But if you’re a beginner I would suggest to start with Power Query for data cleaning, Power BI for visualisation and then go for SQL for further enhancing your capability. Once you’re comfortable with this, then Learn python for data cleaning, visualisation etc I hope this helps.
@shushrutrandive3695Ай бұрын
Sir please appka contact number mil sakt hai kya so please sir ites very Urgent bea use sir muje applo FMCG related kuch question puch hai islye sir please sir
@analyticalguyАй бұрын
@@shushrutrandive3695 hi you can mail me your concern at [email protected]
The easiest way to clean messy and dirty data within 2-3 steps👌👌👌
@analyticalguyАй бұрын
@@mandeepverma-j4h I’m glad you like it. Thanks 🙏
@yaminipatil8108Ай бұрын
Cloud you please share the template?
@analyticalguyАй бұрын
@@yaminipatil8108 hi Yamini, you may please go to the link shared analyticalguy.substack.com You’ll get the link in your mailbox.
@carolewangaa6220Ай бұрын
Where is the template?
@analyticalguyАй бұрын
@@carolewangaa6220 Hey, I have shared the link analyticalguy.Substack.com If you follow to this link, you’ll get the downloadable template on your email id.