Video není dostupné.
Omlouváme se.

Power BI Data Analysis: End-to-end Project in Telugu (with sample files)

Sdílet
Vložit
  • čas přidán 4. 08. 2024
  • 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 columns from data
    Analyzing column profile, distribution and quality
    Lots of Power Query tips & tricks
    💻 Get the sample data:
    From Kaggle: www.kaggle.com/datasets/ariyo...
    From Github: github.com/chandoo-org/Power-...
    📁 Sample Power BI Workbook (with all data cleanup steps):
    Grab the completed Power BI workbook (with a few more visuals) from my Github repo: github.com/chandoo-org/Power-...
    👩‍💻 Power BI Full Course:
    Stop searching and wasting time on CZcams for tutorials. Join my detailed, step-by-step Power BI course and learn everything in one go. Join here: chandoo.org/wp/power-bi-course/
    ⏱Video Chapters:
    ================
    0:00 - Introduction to Data Cleaning & EDA with Power BI
    1:29 - Importing data to Power BI and intro to Power Query
    5:40 - Working with null or missing values
    6:39 - Column Profiling
    10:08 - Imputing missing values (director & country example)
    19:34 - Cleaning date values
    24:01 - Rating column cleanup and EDA
    26:14 - Working with Duration and Adding columns
    31:00 - Column distribution
    32:55 - Filtering out rows or columns
    34:20 - Subbarao Check
    36:14 - Loading data into Power BI for visual analysis
    ~
    Thanks for watching and have a beautiful day ahead :)
    #PowerBI #EDA #datacleaning

Komentáře • 72

  • @krishnachaitanya9879
    @krishnachaitanya9879 Před 2 měsíci +28

    Brother SQL+ Power BI meeda oka live project video cheyyandi plz🙏

  • @sreeharikca1
    @sreeharikca1 Před 2 měsíci +7

    చందూ గారు.. మీకు తలవంచి పదాబి వందనం చేస్తున్నాను.. for your love on telugu.. no words to describe this🙏🙏🙏🙏🙏🙏

  • @devarajululanka6427
    @devarajululanka6427 Před 2 měsíci +3

    No one can explain better than you sir, thanks a ton 🙌. please upload some more useful videos on power bi

  • @NaveenKumar-ki3np
    @NaveenKumar-ki3np Před 2 měsíci +7

    Anna garu ❤ nenu data analyst ga work chestunna mee videos valla skills chala improve cheskuntunna

    • @chandhana7757
      @chandhana7757 Před 10 dny

      Hi andi..how can i contact you..can i get your email id or insta id please?

  • @harishbharadwaj4772
    @harishbharadwaj4772 Před 2 měsíci

    very informative and engaging video sir!!! dhanyavadhalu

  • @amulya6061
    @amulya6061 Před 2 měsíci +1

    please make a video on students' marks data analysis, your videos are very worthwhile

  • @SujathaS-sx3kg
    @SujathaS-sx3kg Před 2 měsíci +2

    Clean and concise explanation, that to in Telugu. Chala Baga explain chesaru.

  • @k.hemanthsai2882
    @k.hemanthsai2882 Před 2 měsíci

    Superb explanation waiting for part 2

  • @susobhandasu1874
    @susobhandasu1874 Před 2 měsíci +1

    Waiting for your video sir....😊
    Please upload more videos of power bi

  • @haifrendhai
    @haifrendhai Před 2 měsíci +2

    Bore kottakunda subba rao, legends words, fun vaduthu maku intresting ga chupistunnanduku Thank you so much bro. 😍😍😍

  • @telugugk8687
    @telugugk8687 Před 2 měsíci +1

    Thank you so much sir ❤❤❤❤

  • @johnkumar7679
    @johnkumar7679 Před 11 dny

    Anna Baga ardhamayyindi, Same ilagey prathi DAX function meeda videos cheyyamani korukuntunnanu.
    Thank you🙏

  • @user-tu7zy9tb1e
    @user-tu7zy9tb1e Před 2 měsíci +1

    Good explain Bro

  • @gopichand2
    @gopichand2 Před 2 měsíci

    Thank you

  • @mgnregszaffergadh9277
    @mgnregszaffergadh9277 Před 2 měsíci

    Thanq anna

  • @velamurisarath562
    @velamurisarath562 Před 5 dny

    Very good information

  • @Anandlivingcool
    @Anandlivingcool Před 2 měsíci

    Great to be here. #telugu

  • @sktalks2758
    @sktalks2758 Před měsícem +1

    Thankyou Annayya ❤

  • @m.d.sravani_yadav6118
    @m.d.sravani_yadav6118 Před měsícem

    Thank you very much sir 😊❤️

  • @KattaKonnects
    @KattaKonnects Před 2 měsíci

    Devuudu ayya meeru 😊🙏

  • @RaghunadhareddyVelagala
    @RaghunadhareddyVelagala Před 2 měsíci

    Hi bro really nice explanation oka complete project start to end with test cases to Saha explain chesi pettandi bro

  • @saikrishna1164
    @saikrishna1164 Před 2 měsíci +1

    చందూ అన్నా 😊❤😊

  • @balajikumar4856
    @balajikumar4856 Před 2 měsíci +1

    Do Data cleaning videos(text & numbers separately).

  • @suvarna2135
    @suvarna2135 Před 2 měsíci

    Chandon garu mee explanation awesome,Thanks a lot for your videos.Data Analyst ku me videos lo order wise (Road map) Ela follow avvalo cheppandi please.

  • @jagangujju5880
    @jagangujju5880 Před 2 měsíci +1

    sir data analysis with original project tho explain cheyandi nd MIS Reports also please

  • @sarihaddu
    @sarihaddu Před 2 měsíci +1

    Anna namaste.

  • @somisettilakshmanarao
    @somisettilakshmanarao Před 10 dny

    adurus bro.....questions and answer kuda video cheyandi please

  • @sridharguggilla6783
    @sridharguggilla6783 Před 2 měsíci

    By the end, I had learned a great deal, yet I found myself lacking in data visualization techniques; therefore, we require additional visual analysis methods.
    Splendid work on Analysis 👌

    • @data_with_chandoo
      @data_with_chandoo  Před 2 měsíci

      EDA is usually limited to doing preliminary analysis and not final visualization. Watch my Power BI videos to learn how to make the visuals and tell data stories.
      Try this - czcams.com/video/698ihA3A3WA/video.html

  • @gsrsakhilakhil528
    @gsrsakhilakhil528 Před 2 měsíci +1

    Sir Dax meeda kuda videos cheyandi please

  • @sivab3875
    @sivab3875 Před 2 měsíci

    Thanks for the information. Is there a way to extract the cleaned data into an Excel?

  • @msateeshkumar6902
    @msateeshkumar6902 Před 2 měsíci

    Anna❤

  • @RenukasaiAnde
    @RenukasaiAnde Před měsícem

    hi sir MIS executive use chesa tools gurichi explain chesthu oka vedio chyandi sir please

  • @Littlekrushna
    @Littlekrushna Před 2 měsíci

    Sir; excel lo micros ela work chestayo oka video cheyandi. Please
    Automatic ga information ela store chesukuntundo kasta cheppandi

  • @bhargavikunuru
    @bhargavikunuru Před 2 měsíci

    Brother Listed in splitting process cheppandiii

  • @nandanacherukuri1975
    @nandanacherukuri1975 Před měsícem

    Hello andi,can you please make a video of JOINS in power Bi

  • @PavanVarma369
    @PavanVarma369 Před 2 měsíci

    Can you make a video of how to make reports in excel and powerbi please...

  • @udaykudupudi
    @udaykudupudi Před měsícem

    Chandoo sir please make a video on Data Analyst Roadmap in telugu

  • @balajiawari9740
    @balajiawari9740 Před 2 měsíci

    Direct Query mida real time lo useful tips mida oka video

  • @RudraveerSena
    @RudraveerSena Před 25 dny

    Bro, Do videos on DAX Functions

  • @Vsriram226
    @Vsriram226 Před měsícem

    chandu sir full end to end power bi project cheyandi sir

  • @bloggingbyasifali4984
    @bloggingbyasifali4984 Před 2 měsíci

    Hi anna nenu recent ga powerbi developer ga join aiyya maa client nannu oka question vesadu powerbi lo old records poi adey place lo new record ravali and aa patha data delete avvali ilaage Naku roju jaragali annadu adi elaa possible anna ??? Power bi lo old data ni delete chesi aa place lo new data ni unchagalama roju ??

  • @balajikumar4856
    @balajikumar4856 Před 2 měsíci

    Do Entry-level Data Analyst roadmap video to get job.

  • @devarajululanka6427
    @devarajululanka6427 Před 2 měsíci

    please show us how to split that tv shows columns 🙏

  • @ribcalankapalli3111
    @ribcalankapalli3111 Před 2 měsíci

    sir, please tell how to split the listed_in

  • @SathishKumar-oq7tz
    @SathishKumar-oq7tz Před 2 měsíci

    If date columns names are different like wk18, wk19, wk20 and so on in table 1 and wk19, wk20, wk21 in table 2 like wise weekly column names are keep changing, if so can we append these type of tables into one table?

  • @kvsravanthi3113
    @kvsravanthi3113 Před 2 měsíci

    Anna power bi basics to advance course Telugu lo chepandi anna anadhriki chala useful ithundi

  • @avanthika1086
    @avanthika1086 Před 2 měsíci

    Anna okka video vba meedha cheyyandi

  • @rajeswarip5098
    @rajeswarip5098 Před 2 měsíci

    Can you suggest any topics for me, which will be helpful for my resume

  • @sailikith7644
    @sailikith7644 Před měsícem

    Hi, can we create a real-time Power BI dashboard using Instagram insights?

  • @jyothi2630
    @jyothi2630 Před 2 měsíci

    Hi brother, I need full telugu power bi cource

  • @adityaprince5507
    @adityaprince5507 Před 2 měsíci

    spelling mismatches check cheyataniki technique cheppandi,ee video lo meeru just manually check chesaru ,unique values kuda ela find out cheyalo cheppandi . anybody in the comment section please answer my questions

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

  • @bhanusai5537
    @bhanusai5537 Před 2 měsíci +1

    DATA ANALYST JOBS WORK FROM HOME JOBS UNTE CHEPPU ANNA

  • @user-ud3vh7jz1s
    @user-ud3vh7jz1s Před 2 měsíci +1

    sir video editor setavvaleda mottan screen record chesaru oparation emi chestunnaru ani clear ga kanipitle sir
    antha screen lo ekkada emi chestunnaro ardam kavadam ledu

    • @data_with_chandoo
      @data_with_chandoo  Před 2 měsíci

      Thanks for this feedback andi. Yeah, I used an editor for this video but I was also not happy with the outcome. Hopefully it will be different in future videos.

    • @user-ud3vh7jz1s
      @user-ud3vh7jz1s Před 2 měsíci

      @@data_with_chandoo it's meen a lot considering my feedback n much thankful

  • @mrgun4606
    @mrgun4606 Před 2 měsíci

    Make this in Hindi please

  • @govardhanpinisetti5653
    @govardhanpinisetti5653 Před měsícem

    Anna Kaggle file download chestha vunta Adhii meeru edit chesinatu chupisthundhi annaya anta ippudu meeru video lo cheppinattu ledu annaya File full ga edit ayivundhii annaya

    • @data_with_chandoo
      @data_with_chandoo  Před měsícem

      Please download the archived data from here - github.com/chandoo-org/Power-BI/blob/main/netsflix-shows-kaggle.csv

  • @kosuruom1376
    @kosuruom1376 Před 10 dny

    List_in

  • @BajiBabu837
    @BajiBabu837 Před 2 měsíci +1

    ee subbarao fantasy endhi anna neeku 😅🤣