![Chandoo in Telugu (తెలుగులో)](/img/default-banner.jpg)
- 16
- 1 197 437
Chandoo in Telugu (తెలుగులో)
New Zealand
Registrace 15. 09. 2022
Learn about Data Analytics, Excel, Power BI and more. From Chandoo, now in Telugu.
🔗 Connect with me:
📺 Main channel - czcams.com/channels/8uU_wruBMHeeRma49dtZKA.html
🌐 Website - chandoo.org/wp/
📷 Instagram - chandoo.xlsx
🐤 Twitter - r1c1
📰 LinkedIn - www.linkedin.com/in/purnaduggirala/
🔗 Connect with me:
📺 Main channel - czcams.com/channels/8uU_wruBMHeeRma49dtZKA.html
🌐 Website - chandoo.org/wp/
📷 Instagram - chandoo.xlsx
🐤 Twitter - r1c1
📰 LinkedIn - www.linkedin.com/in/purnaduggirala/
Learn SQL and Analyze Data - Complete Telugu Tutorial with Sample Queries
SQL అంటే ఏమిటి? దాన్ని ఎలా ఉపయోగించాలి? అది ఎలా install చెయ్యాలి? Queries ఎలా రాయాలి?
అన్నీ ఈ video లో cover చేశాను. చూసేయండి మరి 😀
~
What is SQL, how to use it? How to install SQL in your computer, how to write SQL queries yourself?
I cover all these topics in this video with detailed, practical examples. Let's dive in...
📁 Sample Data Files:
==================
All the data files, installation instructions and useful information here:
chandoo.org/wp/how-to-use-sql-telugu/
⏱ Video topics and timestamps:
===========================
0:00 - Introduction to SQL and what to expect in this video?
0:51 - Database & SQL concepts
9:19 - Installing and setting up MySQL on your computer
14:49 - Creating a new database (schema) in MySQL
15:50 - Adding / Creating tables by importing CSV files
21:48 - Writing SQL queries (a story from my life)
25:30 - 10 examples queries with SQL for business situations
~
#sql #telugu
~
SELECT "awesome day" from DAYS
WHERE person="You" 😀
అన్నీ ఈ video లో cover చేశాను. చూసేయండి మరి 😀
~
What is SQL, how to use it? How to install SQL in your computer, how to write SQL queries yourself?
I cover all these topics in this video with detailed, practical examples. Let's dive in...
📁 Sample Data Files:
==================
All the data files, installation instructions and useful information here:
chandoo.org/wp/how-to-use-sql-telugu/
⏱ Video topics and timestamps:
===========================
0:00 - Introduction to SQL and what to expect in this video?
0:51 - Database & SQL concepts
9:19 - Installing and setting up MySQL on your computer
14:49 - Creating a new database (schema) in MySQL
15:50 - Adding / Creating tables by importing CSV files
21:48 - Writing SQL queries (a story from my life)
25:30 - 10 examples queries with SQL for business situations
~
#sql #telugu
~
SELECT "awesome day" from DAYS
WHERE person="You" 😀
zhlédnutí: 45 627
Video
2 Minute Dashboard with Excel #shorts
zhlédnutí 3,4KPřed 2 měsíci
Instant Excel Dashboard with Table, Slicer, Conditional Formatting and Subtotal. #Excel #Dashboards #shorts
Power BI Data Analysis: End-to-end Project in Telugu (with sample files)
zhlédnutí 18KPřed 2 měsíci
Learn how to clean business data and perform Exploratory Data Analysis (EDA) using Power BI in this hands-on video. You will become a data ninja after this. Topics covered: POWER QUERY for data cleaning and EDA How to deal with missing values, blanks, nulls and errors in data Working with date values and data type conversion Creating new columns from existing data Filtering and removing column...
Beginner to PRO Data Analysis with Excel - FREE Adv. Masterclass in TELUGU
zhlédnutí 204KPřed 4 měsíci
Want to learn how to perform data analysis in Excel from beginning to end? This is the video! In this video, you are going to learn: 1) how to structure your data with Excel tables 2) data cleaning in Excel 3) how to use pivot tables for doing trend analysis 4) using advanced formulas in Excel (SUMIFS, COUNTIFS, FILTER) 5) conditional formatting in excel 6) interactive reports with slicers in e...
Data Analyst Technical Interview Prep with Live Example in Telugu
zhlédnutí 14KPřed 6 měsíci
Do you want to succeed in "technical round" of data analyst interviews? Check out this live example of data analyst technical assessment and learn how to answer such questions. Get the sample file from here - chandoo.org/wp/wp-content/uploads/2024/01/technical-interview-question-1.xlsx Need more? Join my Excel School program - chandoo.org/wp/excel-school-program/ All the best for your interview.
Introduction to Power BI Data Modeling with Real-world Example in Telugu
zhlédnutí 26KPřed 8 měsíci
Data modeling kavala nayana? 😋 Aithe chusey mari... 💥📚 Full Power BI Course: chandoo.org/wp/power-bi-course/ ~ Sample data file to practice: chandoo.org/wp/wp-content/uploads/2023/11/ac-sample-tel.xlsx Topics covered in the video: 0:00 - Data modeling ante emiti? 0:30 - Loading up our data set to Power BI 2:19 - Using Model View to set up data model 3:40 - Connecting two tables in Power BI 5:50...
How to Create Excel Dashboards - Telugu Tutorial
zhlédnutí 118KPřed 11 měsíci
💥Full Excel Dashboards Course: chandoo.org/wp/excel-school-program/ 📁Sample data - chandoo.org/wp/wp-content/uploads/2023/08/telugu-dashboard-blank.xlsx #excel #dashboard
Power BI End-to-End Data Analysis Project in Telugu
zhlédnutí 127KPřed rokem
Data Analysis with Power BI - a full length real-world example with 10 scenarios. Sample Data Workbook: chandoo.org/wp/wp-content/uploads/2023/07/hr-data.xlsx Data Analysis Themes: 1. How many people are there in each department? 2. Gender distribution by department 3. Age spread of our staff (histogram) 4. Min / max / average salary in each department 5. Top earners in each country 6. Performa...
Learn Power Pivot & DAX in Telugu in 30 minutes
zhlédnutí 64KPřed rokem
Power Pivot and DAX ante emiti, vaatini ela vadaali? In this video: 0:00 - Introduction to Power Pivot & DAX 2:42 - Making our first DAX measure 5:16 - Why we should use DAX? 7:13 - Adding more measures 10:40 - Evaluation context explained 13:04 - using COUNTROWS, DIVIDE functions 16:50 - Using IF function in DAX 19:20 - Applying conditional formatting in Power BI 21:10 - Advanced IF trick in D...
Secret Excel Tricks That Will Make Your Boss Think You're a Genius 😎
zhlédnutí 29KPřed rokem
Analyze data faster and better with these 5 amazing Excel tricks. They are: 1) Quick Analysis (CTRL Q) 2) Date cleanup 3) Deriving user id from name column 4) Duplicate check 5) Extracting unpaid students Timestamps: 0:00 - Intro and first tip (Quick analysis) 1:45 - Date cleaning (with text to columns) 3:40 - Date cleaning with formulas 6:00 - User ID creation 7:25 - Duplicate check 8:19 - Fil...
Learn Power BI in Telugu and create your first report in 15 minutes
zhlédnutí 492KPřed rokem
Power BI ante emiti, adhi ela vaadali, data loda ela cheyyali and inke enno... Download sample file here: Data - files.chandoo.org/pbix/sample-data-10mins.xlsx Power BI File - files.chandoo.org/pbix/our first report.pbix Learn more: Power Pivot & DAX in Telugu (in 30 minutes) - czcams.com/video/m5MdeSQUj_4/video.html Power BI in English (main channel videos) - czcams.com/video/uwe8C7K8fXY/video...
The best VLOOKUP trick for doing your work faster
zhlédnutí 11KPřed rokem
daggaraki randi, oka rahasyam chepta. Ee VLOOKUP tip vaadithe, meeru keke! Example workbook here - chandoo.org/wp/wp-content/uploads/2022/10/tel-vlookup.xlsx More on LOOKUP in Excel: XLOOKUP in Telugu - czcams.com/video/QqmQUylmvF8/video.html Excel formulas in Telugu: playlist - czcams.com/video/1dezuCS6iWM/video.html XLOOKUP article (English) - chandoo.org/wp/xlookup-examples/ XLOOKUP other lo...
How to use SUMIFS in Excel - Telugu Tutorial
zhlédnutí 11KPřed rokem
SUMIFS is the most important function in Excel. We can use it to answer business questions quickly and easily. In this simple tutorial learn how to use SUMIFS to answer 5 questions. 0:00 - Introduction 1:10 - Total amount for a specific product 3:36 - Total amount based on two conditions 4:32 - Fixing problems with SUMIFS 5:06 - Total amount based on wildcards 6:35 - Total based on first letter...
IF Function in Excel - Telugu Tutorial with 6 Examples + Sample File
zhlédnutí 12KPřed rokem
IF function ante emiti, danni ela vaadali? Learn in this video. Get the sample file here 👉 chandoo.org/wp/wp-content/uploads/2022/09/tel-if-function.xlsx
Excel lo data errors తల నొప్పా? Aithe idi vadandi... (Data Validation)
zhlédnutí 7KPřed rokem
Data validation is useful to avoid errors and get correct data. Ee video lo, data validation vaadi oka list of values matrame allow cheyyadam elago nerchukundam. Sample file - chandoo.org/wp/wp-content/uploads/2022/09/tel-data-validation.xlsx Data validation article - chandoo.org/wp/excel-add-drop-down-list/ Main channel (English) Data validation video - czcams.com/video/KSQiMdGi3-0/video.html ...
Instead of promoting unnecessary webseries promote this guy who is spending his quality time to spread the knowledge.
thank you sir
Thanks for explaining without charging a single penny..
Ever I have joined the coutching institute but u have better explaining techniques than them …!!! And also in fact I have paid a large amount for institute but ur better than them ..? Can u also explain by a doing a project
Great Great Explanation Ever Sirji 🙏🙏
Telugu లో చెప్పినందుకు ధన్యవాదాలు సర్
Thanks sir useful. Please make more advanced techniques for analysis🙏
Very good explanation sir😊😊 l learned some information of analysis of data by using Excel
thank you sir
Sir telugu lo full course cheyandi
Thank you sir
Anna large data set use cheskoni direct query lo ela chestharo oka videos cheyyandi anna limited data tho aithey work authundi but large dataset lo total ravatledu, duplicates vasthunaai ee videos chesthe maaku real time lo chala work authundi
The concept is same whether you use small data or large data (and dq or load). If your total is wrong or values are missing, that means either: 1) your assumptions about model are wrong 2) your modeling is incorrect or inefficient or wrong 3) your dax is wrong 4) your data has values that are not clean 5) something else. I will try adding larger dataset videos in future, but the challenge for me (as a teacher / creator) is how to share the datasets effectively. Let's see what the future holds.
Best Teacher, amazing bro
Anna ni dehara Manchi Humar undi 🎉
Very good explanation sir, you made me feel easy to learn. Thankyou sir.
sir excellent video. When i am working with pivot table derived data is not showing in that. please solve this problem
thank you sir for given good information on power bi
thank u sir
Hai sir, I did btech in 2012, I have 12 years career, can I get fresher job in data analyst, if I try now.
SELECT * FROM people WHERE `Sales Person` LIKE 'S%' AND Location ='Hyderabad';
please use "Vacheyandi" instead "Randi" please ...... thank you for your great work.
I keep thinking about this once in a while. Naaku chinnapati nunchi "randi" alavatu, well before I learned the more offensive hindi meaning of the word.
Hi anna SQL+ Power BI combination lo oka project cheyandi anna please, so many people's are waiting for this vedio
Sir meru chesina e 4videos bhaga nerchukunte power bi as a fresher data analyst ga saripothundha sir
After data selection visualisation not showing what I have to do
fentastic, mind blowing , unbelivable, my god chanduuuuuuuuuuuuuuu🥰
i want overall power bi concepts
thanks sir
Hii sir IF conditions apply avvatam ledu error vasthundhi
Kia Ora, Hi brother ela vunnaru? I would like to learn power BI but I'm not sure where to start also i don't have any knowledge on technical. Please guide me.
love from telangana
Super ga cheppuru sir...
Is it case sensitive SELECT * FROM ....and....select * from
Nope. Should work in any case.
Motham Anni topics cheppandi anna
Very good information
Hi sir can u please make video on end to end project with large data set using direct query in power bi??
Multiple sheets are having same formatted data. We need to copy from all the sheets and get all the data into a new sheet at a time. How to do it.. please reply me ...
gurudeva, i learned so much thank you 🙏
Sir this is my first video watching in your channel, i am totally impressed how you explained in telugu sir.😊
Anna naaku miru chepina power bi vedious motham kavali Anna
Hai sir I'm raju i will interest to learn data analyst course. You will make videos for Full course this is my humble request sir and you will upload day1 and day2 like that sir I'm your subscriber
Dax concept cheppandi sir
I am following all your videos anna i like it i need PowerPoint presentation from basic to advanced level please anna
Annayaa SQL BASICS TO ADVANCE GA VIDEO chiyandii annaya pls
Data analysis kosam power bi and SQL meda video cheyandi sir
I would have used the filters option in vlookup rather than formulas for status
In python we can use Data frame
Months date, year date quarter date a option ledhu sir m cheyyali
Sir meru petti na this excel topics nerchukunte data analysis vachesinattena
7 - Sales persons whose name begins with S (Home Work) select * from people where `Sales Person` like 'S%' and location like 'Hyderabad';
Thanks chinna....