Chandoo in Telugu (తెలుగులో)
Chandoo in Telugu (తెలుగులో)
  • 16
  • 1 197 437
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" 😀
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 ...
Excel lo best function meeku telusa?
zhlédnutí 20KPřed rokem
Excel lo best function meeku telusa?

Komentáře

  • @rajeshnowduri1244
    @rajeshnowduri1244 Před 3 hodinami

    Instead of promoting unnecessary webseries promote this guy who is spending his quality time to spread the knowledge.

  • @durgaprasad-up8hc
    @durgaprasad-up8hc Před 8 hodinami

    thank you sir

  • @RaoTN
    @RaoTN Před 9 hodinami

    Thanks for explaining without charging a single penny..

  • @sairoczvlogs
    @sairoczvlogs Před 14 hodinami

    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

  • @Hackarz
    @Hackarz Před 20 hodinami

    Great Great Explanation Ever Sirji 🙏🙏

  • @teluguhome1675
    @teluguhome1675 Před dnem

    Telugu లో చెప్పినందుకు ధన్యవాదాలు సర్

  • @rameshgoddumari601

    Thanks sir useful. Please make more advanced techniques for analysis🙏

  • @user-pz4bv2rc2o
    @user-pz4bv2rc2o Před dnem

    Very good explanation sir😊😊 l learned some information of analysis of data by using Excel

  • @durgaprasad-up8hc
    @durgaprasad-up8hc Před dnem

    thank you sir

  • @Equalizer1452
    @Equalizer1452 Před dnem

    Sir telugu lo full course cheyandi

  • @user-yl8fl9ex6e
    @user-yl8fl9ex6e Před dnem

    Thank you sir

  • @bloggingbyasifali4984

    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

    • @data_with_chandoo
      @data_with_chandoo Před dnem

      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.

  • @prudhvipodicheti-fi3ou

    Best Teacher, amazing bro

  • @arunkumarbandi5694
    @arunkumarbandi5694 Před 2 dny

    Anna ni dehara Manchi Humar undi 🎉

  • @sravanthikampelli1895

    Very good explanation sir, you made me feel easy to learn. Thankyou sir.

  • @sirishaa1190
    @sirishaa1190 Před 2 dny

    sir excellent video. When i am working with pivot table derived data is not showing in that. please solve this problem

  • @VarunKumar-ii7hu
    @VarunKumar-ii7hu Před 2 dny

    thank you sir for given good information on power bi

  • @prashanthkumar784
    @prashanthkumar784 Před 2 dny

    thank u sir

  • @dhanvisrinamdam9198

    Hai sir, I did btech in 2012, I have 12 years career, can I get fresher job in data analyst, if I try now.

  • @parapelliveena8687
    @parapelliveena8687 Před 2 dny

    SELECT * FROM people WHERE `Sales Person` LIKE 'S%' AND Location ='Hyderabad';

  • @Gyansagarsangam
    @Gyansagarsangam Před 3 dny

    please use "Vacheyandi" instead "Randi" please ...... thank you for your great work.

    • @data_with_chandoo
      @data_with_chandoo Před 3 dny

      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.

  • @srilathakalli759
    @srilathakalli759 Před 3 dny

    Hi anna SQL+ Power BI combination lo oka project cheyandi anna please, so many people's are waiting for this vedio

  • @Bachelorbathukulu_143

    Sir meru chesina e 4videos bhaga nerchukunte power bi as a fresher data analyst ga saripothundha sir

  • @VenkatPolepaka
    @VenkatPolepaka Před 4 dny

    After data selection visualisation not showing what I have to do

  • @sainathbuthagaddala5327

    fentastic, mind blowing , unbelivable, my god chanduuuuuuuuuuuuuuu🥰

  • @hemasaipotnuru8630
    @hemasaipotnuru8630 Před 4 dny

    i want overall power bi concepts

  • @vanithavolapu7780
    @vanithavolapu7780 Před 4 dny

    thanks sir

  • @shivajiguguloth7553

    Hii sir IF conditions apply avvatam ledu error vasthundhi

  • @saileshnellorepalli

    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.

  • @sainathbuthagaddala5327

    love from telangana

  • @venugopal8521
    @venugopal8521 Před 5 dny

    Super ga cheppuru sir...

  • @JayaPrakashBommisetty

    Is it case sensitive SELECT * FROM ....and....select * from

  • @vemareddy5519
    @vemareddy5519 Před 5 dny

    Motham Anni topics cheppandi anna

  • @velamurisarath562
    @velamurisarath562 Před 5 dny

    Very good information

  • @bloggingbyasifali4984

    Hi sir can u please make video on end to end project with large data set using direct query in power bi??

  • @SandhyaRaoG
    @SandhyaRaoG Před 6 dny

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

  • @vickyvatsavai143
    @vickyvatsavai143 Před 6 dny

    gurudeva, i learned so much thank you 🙏

  • @Yashwanth_2297
    @Yashwanth_2297 Před 6 dny

    Sir this is my first video watching in your channel, i am totally impressed how you explained in telugu sir.😊

  • @VVSatyanarayanaNarra

    Anna naaku miru chepina power bi vedious motham kavali Anna

  • @RajuRaju-cq2ps
    @RajuRaju-cq2ps Před 7 dny

    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

  • @challaswathi5011
    @challaswathi5011 Před 7 dny

    Dax concept cheppandi sir

  • @srinumananji800
    @srinumananji800 Před 8 dny

    I am following all your videos anna i like it i need PowerPoint presentation from basic to advanced level please anna

  • @srinumananji800
    @srinumananji800 Před 8 dny

    Annayaa SQL BASICS TO ADVANCE GA VIDEO chiyandii annaya pls

  • @Manuvox143
    @Manuvox143 Před 8 dny

    Data analysis kosam power bi and SQL meda video cheyandi sir

  • @viswajitendra
    @viswajitendra Před 9 dny

    I would have used the filters option in vlookup rather than formulas for status

  • @Musugutrolls
    @Musugutrolls Před 9 dny

    In python we can use Data frame

  • @Swathikarthika123
    @Swathikarthika123 Před 9 dny

    Months date, year date quarter date a option ledhu sir m cheyyali

  • @devarakondalingaswamy4238

    Sir meru petti na this excel topics nerchukunte data analysis vachesinattena

  • @mkalyan7496
    @mkalyan7496 Před 9 dny

    7 - Sales persons whose name begins with S (Home Work) select * from people where `Sales Person` like 'S%' and location like 'Hyderabad';

  • @user-eu2fr1dk8q
    @user-eu2fr1dk8q Před 9 dny

    Thanks chinna....