Normalization in Data Transformation | Min-Max & Z-score Techniques with example

āđāļŠāļĢāđŒ
āļāļąāļ‡
  • āđ€āļœāļĒāđāļžāļĢāđˆāđ€āļĄāļ·āđˆāļ­ 4 āļ.āļ„. 2024
  • 00:00 - Normalization & their technique
    01:35 - min max technique
    05:55 - z-scope technique
    In this video, discussing about the concept of normalization in data transform. Normalization in data transformation is a process used to organize data in a database efficiently. It involves structuring a database in a way that reduces data redundancy and improves data integrity. The main goal is to ensure that the database is efficient and accurate by eliminating redundant data and ensuring data dependencies make sense.
    👉Subscribe to our new channel: / @varunainashots
    ▹ Data Warehouse (Complete Playlist):
    â€Ē Data Warehouse
    Other Subject-wise Playlist Links:
    --------------------------------------------------------------------------------------------------------------------------------------
    ▹Computer Networks :
    â€Ē Computer Networks (Com...
    ▹Design and Analysis of algorithms (DAA):
    â€Ē Design and Analysis of...
    ▹Database Management System:
    â€Ē DBMS (Database Managem...
    ▹ Python For Beginners(Complete Playlist):
    â€Ē Python for Beginners
    ▹ Theory of Computation
    â€Ē TOC(Theory of Computat...
    ▹Artificial Intelligence:
    â€Ē Artificial Intelligenc...
    ▹Computer Architecture:
    â€Ē Computer Organization ...
    ▹Operating System:
    â€Ē Operating System (Comp...
    ▹Structured Query Language (SQL):
    â€Ē Structured Query Langu...
    ▹Discrete Mathematics:
    â€Ē Discrete Mathematics
    ▹Compiler Design:
    â€Ē Compiler Design (Compl...
    ▹Number System:
    â€Ē Number system
    ▹Cloud Computing & BIG Data:
    â€Ē Cloud Computing & BIG ...
    ▹Software Engineering:
    â€Ē Software Engineering
    ▹Data Structure:
    â€Ē Data Structure
    ▹Graph Theory:
    â€Ē Graph Theory
    ▹Programming in C:
    â€Ē C Programming
    ▹Digital Logic:
    â€Ē Digital Logic (Complet...
    ▹ Class XI Computer Science(Full Syllabus)
    â€Ē CLASS-XI Computer Scie...
    ▹ Microprocessor Playlist:
    â€Ē Microprocessor
    ---------------------------------------------------------------------------------------------------------------------------------------
    Our social media Links:
    ▹ Subscribe to us on TH-cam: / gatesmashers
    ▹Subscribe to our new channel: / @varunainashots
    ▹ Like our page on Facebook: / gatesmashers
    ▹ Follow us on Instagram: / gate.smashers
    ▹ Follow us on Instagram: / varunainashots
    ▹ Follow us on Telegram: t.me/gatesmashersofficial
    ▹ Follow us on Threads: www.threads.net/@gate.smashers
    --------------------------------------------------------------------------------------------------------------------------------------
    ▹For Any Query, Suggestion or notes contribution:
    Email us at: gatesmashers2018@gmail.com

āļ„āļ§āļēāļĄāļ„āļīāļ”āđ€āļŦāđ‡āļ™ • 33

  • @bibekanandabhattacharjee952
    @bibekanandabhattacharjee952 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +10

    I have seen so many videos. This is one of the most useful and explained so easily and effortlessly. Thanks Mr. Instructor.

  • @swerve-dz4cr
    @swerve-dz4cr 5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +8

    i really do not how he makes me understand everything in 4 mins(i play it on 2x), unbelievable, grateful to you varun sir

  • @rashi7729
    @rashi7729 3 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +3

    please make more videos for the data warehouse playlist
    YOU ARE THE BEST TEACHER

  • @am1tw
    @am1tw 7 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +4

    I don't understand your language, but I understood your explanation wonderfully. Thank you very much. You're really a wonderful man.

    • @GateSmashers
      @GateSmashers  7 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +2

      Wow, thank you

  • @user-nj6os9to9l
    @user-nj6os9to9l āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    thank u so much sir for clear my doubt😊

  • @rohitdhiman5925
    @rohitdhiman5925 2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    For Standard Deviation denominator should be N or n-1? (5 or 4 in this case)

  • @amanmishra6767
    @amanmishra6767 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Very Well explained these two concepts #Varun Sir

  • @PrithaMajumder
    @PrithaMajumder 5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +2

    Sir, Thanks a lot for This Amazing Lecture 🙂
    Lecture - 8 Completed ✅ in Data Warehouse Playlist

  • @k.smitarani2397
    @k.smitarani2397 3 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Simplified Explained 😊

  • @aboleebhuset-322
    @aboleebhuset-322 5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thank you for such nice explanation of concept

  • @RkShortsBreak760
    @RkShortsBreak760 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Thank you

  • @onlymuslimengineermuhammad1105
    @onlymuslimengineermuhammad1105 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    bohat acha g

  • @kavya973
    @kavya973 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    sir please make video on KDD process

  • @rajkumarrishikesh
    @rajkumarrishikesh 4 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    I think you should talk about Normalization of N1, N2, N3 etc. You are using data science related normalization. RDBMS normalization are different.

  • @tanayborade3769
    @tanayborade3769 3 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    thanks bhai

  • @20shwetha
    @20shwetha 2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Sir I was searching this concept videos finally I got very clear explanation video

  • @DTXxTANUJ
    @DTXxTANUJ āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    Sir samjhate toh accha h pr vedios p like bahut kmm h uss hisaab s

  • @hirennakum2707
    @hirennakum2707 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Siji NIC Exam ka Liya Video

  • @monikayadav-wb6pu
    @monikayadav-wb6pu 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    I am BCA student first semester
    Kya aap ki DBMS ki video humare liye beneficial hogi....???

    • @gauravarya2977
      @gauravarya2977 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      Mam yha sb kuch beneficial h seriously 🎉ðŸ˜Ū😊

    • @gauravarya2977
      @gauravarya2977 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      M yhi se pad kr pss hua hu 😊

    • @monikayadav-wb6pu
      @monikayadav-wb6pu 8 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +2

      @@gauravarya2977 ok thanks for giving suggestion 🙏🙏

    • @RealZephyro
      @RealZephyro 7 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      apne clg ke faculty se zda tum inse hi padogi in these 3yrs

  • @sangramlembe7231
    @sangramlembe7231 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    ye DBMS wala he yaa, Machine Learning

    • @gireeshsinha1078
      @gireeshsinha1078 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

      ML vala

  • @d.krishnamohanpanda6522
    @d.krishnamohanpanda6522 7 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    -1.5 did not lies between 0 to 1

    • @pailatejeswararao4572
      @pailatejeswararao4572 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Yes brother ,but why isn't it normalised did you know?

    • @aravindram1480
      @aravindram1480 5 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

      Yes I had that doubt. I thought its range is between -3 to 3 but nope.

  • @divyaalok5538
    @divyaalok5538 6 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™ +1

    āĪœāĪŊ āĪķāĨāĪ°āĨ€ āĪ•āĨƒāĪ·āĨāĪĢ

  • @Ny-lx2do
    @Ny-lx2do 2 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Sir Is telling dekho samjh to aaya nhi hoga😂😂😂😂

  • @shitalpatle7566
    @shitalpatle7566 āļŦāļĨāļēāļĒāđ€āļ”āļ·āļ­āļ™āļāđˆāļ­āļ™

    Ap bhout confuze kr rhe h