14 күн бұрын
4 ай бұрын
4 ай бұрын
Пікірлер
@rajugoud1563 Күн бұрын
Awesome video bro
@dileepgedela1486 Күн бұрын
Awesome work Chandoo
@shikharsahu1557 Күн бұрын
In the last wildcard formula there are few mistakes. The formula should be =IF(COUNTIFS(C8,"*"&$O$5&"*")>0,"bo person","not a bo person") instead of =IF(COUNTIFS(C8,"*",&$O$5&"*"),"bo person","not a bo person")
@seeramaheswari4658 Күн бұрын
can you make a video on how to run sql in visual studio code
@lovelytest027 Күн бұрын
This video tell me , "What i know is Nothing". Thanx chandoo
@likeit3914 Күн бұрын
Hello sir, why I am not able to drag my slicer to the graph area?
@ShankarTmsw Күн бұрын
What is the problem statement ?? Sir
@saiumadevimunagapaka1558 2 күн бұрын
Thank you sir
@irsrika 2 күн бұрын
Im not finding any reference to installing sakila in this video. Can anyone pls help.
@prathmeshsharma3332 2 күн бұрын
👍👍
@SISTARRRRR1 2 күн бұрын
Every time I need help with an analytics tool, I always end up on your channel. Thanks!
@AneeCk 2 күн бұрын
Hi sir ,can u make a video about how to connect tables in powerbi that has no common key.
@kavalisony6260 2 күн бұрын
Can you please upload video in Telugu sir
@safeerahmedx 2 күн бұрын
Thank you sir , you helped me crack my lab exam 😁.
@PraveenKumar-il8kn 2 күн бұрын
Hi sir, can we read confidential labelled excel file in power query?
@Jdbdjdbdkdbdjjd 2 күн бұрын
Don't use music
@1972jms 2 күн бұрын
This is a phenomenal video. Very clear and helpful instructions at just the right pace. Well done and thank you, Chandoo!
@mmsharmma6789 2 күн бұрын
What about the duplicates in the data ? if i want to remove duplicates should i use trim ?
@DallasCash-f2o 2 күн бұрын
This video is so informative. I’ve been using Astirna New Tab to keep track of my tasks and it really helps when I’m diving into data.
@TheBootyWarrior-p6n 2 күн бұрын
I love how you made that dashboard interactive. By the way, I found Astirna New Tab really helpful for organizing my tasks alongside my data analysis.
@ballerbscottballerbscott-q3o 2 күн бұрын
This dashboard looks great. I just started using Astirna New Tab for better productivity while working on similar projects.
@suvradeepbanerjee6801 2 күн бұрын
Brilliant!! Great thank you so much.
@dshop9512 3 күн бұрын
fantastic
@anujbhardwaj778 3 күн бұрын
Best practical video
@amitdoctor3677 3 күн бұрын
Hello Chandoo Sir, its very great experience for the beginners who tried to learned PBI, I am definitely recommended to my friends and colleagues, I have an issue in PBI that I could not able to find forecast feature in my software, please help me on it how do I add this in my system? thanks in advanced
@musasurajh1470 3 күн бұрын
i love all you are doing and may you always be bless
@shibusam8710 3 күн бұрын
Enjoyed watching the video and Q&A!
@Wallaha11 3 күн бұрын
y u dont participate in financial modelling world cup,i m sure u will win
@amitdoctor3677 3 күн бұрын
Hi Chandoo in that white blank space add KPI % for all teams
@CheapayVentures-w2r 3 күн бұрын
Sir i do not under the assignment at al it was confusing😅
@vadladharani5813 3 күн бұрын
Hey, i have one genuine doubt can anyone tell me why use formulas and all when we have pivot tables to filter out the data and do the calculations according to our requirement which is way more simple? Note: I'm new to excel.
@asaudaymanisaiisiignjihj9328 3 күн бұрын
Just Awesome Brother. Could you do more videos on ETL and it's famous tools in industry for Data Analytics.
@Dark_Horse1909 3 күн бұрын
Thank you sir, I just created my first Tableau dashboard watching this video.
@gloystar 3 күн бұрын
Hi Chandoo, I desperately need your help. I have a column of data in a pivot table and I'd like to standardize this column values, how can I create a DAX measure to do that? I tried the formula: Standardized = (Table[Value] - STDEVX.P(Table, Table[Value]))/AVERAGEX(Table, Table[Value]) but something is wrong!
@chandoo_ 3 күн бұрын
I suggest doing this operation in Power Query or SQL for performance reasons. But if you prefer doing it in DAX, here is the code: Column = ('Table'[Column1]- STDEVX.P(ALL('Table'[Column1]),'Table'[Column1])) / AVERAGEX(ALL('Table'[Column1]), 'Table'[Column1])
@gloystar 2 күн бұрын
@@chandoo_ Thanks for the reply. Unfortunately, I get this error: "This formula is invalid or incomplete: 'Calculation error in measure 'Combined'[2188f049-5373-4f9c-b2cc-f663cb20ba04]: A single value for column 'المتوسط' in table 'Combined' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result". Perhaps, when you have time, can you make a short video showing the PowerQuery method for calculating z-score for a column of values? I'd love to learn that too. Meanwhile I'll try to fix the DAX somehow.
@gloystar 2 күн бұрын
@@chandoo_ Thanks for your reply Chandoo. I tried the DAX formula but I get the kind of errors indicating that multiple values where supplied where a single value was expected. I'd like to learn the PowerQuery method as well. Thanks!
@chandoo_ 20 сағат бұрын
I think you need to learn DAX & Power Query properly. You seem to jumping in the middle. Start with fundamentals and take it slow. Start here: 1) Getting started with Power Query - kzbin.info/www/bejne/g37HlJaworp_qLc 2) Getting started with DAX - kzbin.info/www/bejne/onWahamhpLZpqLs I have a full step-by-step course that gives you structured learning. Check it here - chandoo.org/wp/power-bi-course/
@kowsergazi 3 күн бұрын
Please continue to upload #Python tutorials. A continuous series would be great! 💚
@Georgia-kq7sl 4 күн бұрын
Wowww such an awesome video ,i can't wait for the next one .hope its soon ,litteraly excited ❤🎉
@derrellrose7020 4 күн бұрын
I dont see the Microsoft office app that scans.
@tamilmoviessuperscense 4 күн бұрын
Sir please making latest excel mutual fund tracker in one video sir. Your website template now not working sir
@siripaltheru6821 4 күн бұрын
Difference between slicers and field parameters?
@anuradhatomer5801 4 күн бұрын
But if names are inconsistent in second table then power query will not work here I think
@EMRANKhan-q8x 4 күн бұрын
Very informative
@SiddhiShete-n5u 4 күн бұрын
15:35 im getting problem with the =Pivots!A4 i followed all the steps still the its says invaild ....what will be solution ...any one can help mme we that
@deepthoughts1122 5 күн бұрын
Thanku bro🎉 Always grateful to u
@HepsiSathenapalle 5 күн бұрын
Hello anna how can we contact you
@Solimaomran 5 күн бұрын
Who is here in 2025
@driveinnature 5 күн бұрын
Beautiful presentation ❤
@rajeshpanchal9068 5 күн бұрын
Waiting for the next video. 21:54
@tanushreepokestar7484 5 күн бұрын
Hi Chandoo Sir, I have tried but could not be able to rectify the issue where we are getting 0 values for another category of products. It would be great if you help us here in this regard with detailed steps. Thank you for such videos.
@isampellisandhyaranisandhy6214 5 күн бұрын
Great Effort Chandoo garu,, iam among those looking for data analyst tutorial from scratch in free. Much helpfull resource, MANY THANKS
@greenvally8467 5 күн бұрын
Thank you Chandoo for sharing python tutorial