Видео

Hi Chandoo Sir, if one needs to see Dynamic rolling - Week on Week measurement of Cash collected by Country and Agent. Can u help with a scenaario?

Bro, meeru cheppina new formulas web page lo Microsoft 365 login chesi try chesthunte formula bar kanipinchatledu + cells lo kuda formula enter cheylekapothunna. What's the alternative to use new age powerful formulas, please suggest? Paid version teeskuntene panichestada? Pls reply

Brooo 47:00😂

please give us detail sql course becoz as we are freshers....interview lo theory baga adutunnaru.So we need detail ones from you.Meeru chupututhe baga ardam ithunai sir!!!

Really good. I need learn full power BI

the best explanation i have ever seen about one perfect roadway to build a perfect skill

Anna complete SQL beginner to advanced video cheyandi please 🙏

Q: Permanent headcount ANSWER: =COUNTIFS(staff[Employee type], "Permanent", staff[Department],B3:B15) COUNTIFS: specific condition ichina danineh count cheysi istudi Q: who joined in 2020 or after… ANSWER: =FILTER(staff[Emp ID]:staff[Salary], (staff[Salary]>F67)*(staff[Gender]="Female")*(staff[Start Date]>=DATE(2020,1,1))) (verey version valaki Date function ravatle even answer crt iyna,idk y!!! :(( ) Q: All dept in one cell,comma seperated!!! ANSWER: =TEXTJOIN(", ", TRUE, UNIQUE(staff[Department])) TEXTJOIN : allows you to concatenate (join together) multiple text values into a single string, with a specified delimiter separating each value. Q: Veeravasarapu data in Row and Column Answer: Row -- =XLOOKUP(C17,staff[Last Name],staff[[Emp ID]:[Salary]]) Column -- =TRANSPOSE(XLOOKUP(C17,staff[Last Name],staff[[Emp ID]:[Salary]])) Q: Finding all the employees of 120000 salary with all print all "Tuxwell" duplicates lastname in a row within it!! ANSWER:=FILTER(staff, (staff[Salary]=120000) + (staff[Last Name]="Tuxwell")) SEPERATE TUXWEEL DUPLICATES FORMULA: =FILTER(staff,(staff[Last Name]="Tuxwell")) Q : Female Ratio ANSWER: =COUNTIFS(staff[Department],B6#, staff[Gender], "Female") / COUNTIFS(staff[Department], B6#) THANK YOU FOR GREAT EXPLAINATION SIR!!! @data_with_chandoo😊😊😊

Anna Thank you soo much for your efforts

Tried third Home work Taks - Who joined in or after 2020 with below formula it showed correct result =FILTER(staff[Emp ID]:staff[Salary], (staff[Salary]>F67)*(staff[Gender]="Female")*(staff[Start Date]>=DATE(2020,1,1)))

3RD TRAIL CELL A LO 23 VUNDHI SIR CELL B LO 35 UNDI CELL C LO =A+B(23+35=58) NEN DAILY LEDA ENNI TYMES CHANGE CHESINA B CELL LO VALUE ADD AVVUTHU UNDALI NENU B CELL LO 35 THARUTAHA SAME CELL LO 20 ADD CHESINA AITHEY NAKU C CELL LO (58+20=78) RAVALI KANI MALLA (23+20 =43) RAKODADU C CELL LO ANY FUNCTION OR TRICK IS THERE FOR THIS TASK SIR EVRY ONE ENTERING DAILY DATA AND DATA HAVE TO BE ADDED PREVIOUS ONE AND THATVALUE SHOULD BE FREEZ

01/10 i selled 10 sops entereed in cell A 02/10 i selled 12 sops entereed in cell A or B 03/10 i selled 9 sops entereed in cell C 04/10 i selled 8 sops entereed in cell c 05/10 i selled 10 sops entereed in cell c naku C cell lo daily sale enter chesta naku B lo o1 to 5 total undali 49 soaps 06/10 i sell 6 chesina naku automatics ga 49 ki 6 add ayyi UNDALI

brother i havèa dought 1st nen danni clear ga explain cehyyaaniki try chesta plz kasta opikiga chadavandi im working on a marketing field ikkada naku daily task okati untadi target montly untadi aithey yesterday nen oka 10 sops sale chesina cell C lo enter chesina and to day oka 6 sopas sale chesina n repu kua 15 chesina ani expect chestunna aithey! nen daily sale enter cheyyaniki refrence cell okati teesukunta cell D naku ninnati data C lo undi e roju data D cells lo undi. ninnatidi and e roju di cell C lo total kavali aiheu past old data antha ninnatidi monnatidi aha mundu di antha C cell add ayyi undali and nenu daily D cell lo add chesta naku past date antha e roju data ki add kavali malla nenu D chell lo repati data add cheste old data + today data anedi naku kanipiyyali fourmula etla sir adi

out fit bagundi sir chalaaa

Anna full power bi course Telugu lo upload chayandi anna.

Anna advanced sql topics available english classes, I understand little bit but can you please make that vedios in telugu also that is more helpful to us who are from telugu background like me

Hi Sir Could you please share your contact number sir I will connect with separately. I want to total Power BI classes. Finally good explain for your online classes. Thanks &Regards, Shiva B.

Really nice explanation ❤

Sir Pls Explain How to Connect Web Browser and URL Link Creation... in Power BI in Health care Data.

🙏🏻🙏🏻 Annya, SQL ante chaala bayamesedhii.... chala simple gaa concepts ardham ayyayi... thank you, Anna ❤❤

అన్న 2012లో mba చేసా మధ్యలో చాలా జాబ్స్(teaching +It job)చేసా ఇప్పుడు data analyst గా జాబ్ చేయాలనీ ఉండి skills నేర్చుకున్న but no జాబ్స్. Without DA exp నాకు జాబ్ వస్తుందా?

chandu brother i am at the age 53 i am understanding your class very well brother thank you brother upcoming students ki me class chala use aowthavi brother👍👍

filters

love it can you make the other version for google sheets because many google sheets their are alot for differences between...

Thank you sir

@data_with_chandoo A dataset avado Pakistan odu chesinattu vunnadu, director peru leni rows annitiki adi country peru pettukunnadu, 😂

very nice

అన్నా ఇదే data ని short గా చేసి చెప్పు అన్న

VERY NICE

Super sir.....excellent

please add English subtitle or make it in English language.

Thanks for the knowledge sharing please use better Mike and remove background noise while editing and set echo properly

PermanentEmployee Head count each department Answer : =COUNTIFS(staff[Employee type],"Permanent",staff[Department],B3)

Hii sir. You Explained very good. I. Studied BA. And. I. Want to. Learn this course. Sir

i AM GETTING ONLY VISULISATION, DATA BUT NOT VISULISATION, FIELDS AS SHOWN IN YOUR VIDEO HOW TO GET FIELDS

I AM NOT FINDING FIELDS IN POWER BI

If possible try to give telugu voice over to your power bi english videos or else make new videos We r in need please.

Good teaching sir... Thanks... Full course telugulo post cheyandi sir

హాయ్ సర్ మీరు echina excel file lo formulas work avutunnayi , meeru echina file lo unna data ni copy cheysi excel new lo paste chesysi formula apply cheysanu but its shows 0, please help me in this

Vere level explanation bro 👊🏻 thank you very much 👏🏻👏🏻❤

First of all tysm for uploading such useful videos.Sir please create more videos in telugu on power query, copilot ,like how to automate our data in excel for free in telugu, it's a sincere request from our end... Hope u take time and publish the videos soon.

Can you please make complete video on python in your way

Great Man

pie chart lo multiple categories vuntay kadha ayithe single categorie select cheydam ela mana mouse tho ? na power bi account lo anni charts work avuthunay oka pie chart thappa plz help me sir

For the question at 51:30 minutes I’m giving my guess that by using or function we can get the salesperson name staring with s and who’s from Hyderabad. Please reply me if possible because this is my first SQL learning before this never seen anything about SQL.

Your way of teaching is excellent sir Thank you so much Can you please upload more and more videos sir

meeru ekkada nerchukunnaru sir data analytics course

Anna ela nay MIS Executive or MIS Analyst ki samdenchina Real time projects chy Anna using Advance excel and SQL use chysi please chela help aeodhi🤗🤗🤗🤗🤗

You are a great trainer - no doubt . Explaining in simple language is your super power.

thank you Sir it is very informative