Database vs Spreadsheet - Advantages and Disadvantages

Поділитися
Вставка
  • Опубліковано 15 гру 2024

КОМЕНТАРІ • 74

  • @365DataScience
    @365DataScience  5 років тому +4

    🚀Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sGBk7a

  • @wsitech
    @wsitech 3 роки тому +23

    Data integrity is so overlooked when it comes to databases. So many times I've had to import data from old databases or Excel to a new database, and it was a nightmare because of incorrect date formats. I'd say the #1 reason for data migration failing is for bad data types. One project, I saw cities where states should be, countries where ZIP codes should be, all because there was no checking for data types as you demonstrate with dates in Excel. Great video!

    • @Brandon354786
      @Brandon354786 Рік тому +1

      You posted this 2+ years ago, so I doubt you care anymore, but you can actually do the same thing in excel pretty easily. It is called "Data Validation" in Excel, and it lets you restrict entries.

  • @captainkeyboard1007
    @captainkeyboard1007 4 роки тому +8

    Your explanation on the differences between using a spreadsheet and a database program is comprehensible. I am a fan and an avid user of Microsoft Access, but I do use Microsoft Excel only for heavy-duty number crunching.

    • @bzflowerbee
      @bzflowerbee Рік тому +1

      Also for graphs.

    • @captainkeyboard1007
      @captainkeyboard1007 Рік тому +1

      @@bzflowerbee I use Microsoft Excel mainly for files that call for number-crunching. I have not used the application program for business art, because my jobs do not require that task. However, the Excel graphs are more than those would be found in Microsoft Access. Both, Microsoft Access and Microsoft Excel are fine programs. Thank you for tapping or typing to me.

    • @bzflowerbee
      @bzflowerbee Рік тому

      @@captainkeyboard1007 I've been using Excel all my life but lately I am thinking about learning something new like SQL. My job needs to interpret data alot especially using graphic to grab people attention.

    • @captainkeyboard1007
      @captainkeyboard1007 Рік тому

      @@bzflowerbee Fortunately, I learned to use Microsoft Office first with Office XP Professional in 2002. I discovered some techniques in Word 2002, Excel 2002, Access 2002, PowerPoint 2002, Outlook 2002, and Publisher 2002. Many of the techniques would not be likely taught in a job. Those programs enabled me to use my keyboarding skills in an advanced way without the speed. After all, the speed did not help me gain successful employment. Today, I am using Microsoft Office 2021 Professional, that is nested in Microsoft Windows 10 Pro. Also, I am trying to revive my typewriting service, even though many people do not request work that requires much keyboarding. I print on paper with a color laser printer, and I print label tapes with a label tape printer. Your comment is interesting to me. Thank you very much for tapping or typing to me.

  • @nutella_drifter
    @nutella_drifter 4 роки тому +5

    This is a very useful and concise explanation. My questions:
    1) Is working with databases faster than with spreadsheets because, (since there are no formulas, formattings etc.) the overall CPU and RAM usage is lower?
    2) is there any software or data management method that includes best of both worlds? Like one that can handle lots of data with integrity and speed but also has the capability of detailed analysis and visualization?

    • @ksojoel
      @ksojoel 4 роки тому

      you may be looking por excel enviroment: power query, power pivot, dax

  • @awesh1986
    @awesh1986 6 років тому +21

    I mean where were you guys since so long. I have been looking for such tutorials on clarifying my concepts on databases. Awesome video. Is there any place where I can watch all the videos sequentially so that I move ahead in a sequence

    • @365DataScience
      @365DataScience  6 років тому +2

      We're so happy to see you like our content! You could either subscribe to our UA-cam channel so you can get notified when we post a new video, or you could go to 365datascience.com/career-tracks/ so you could watch the free previews of our career tracks! :)

  • @granand
    @granand 4 роки тому +2

    As I agree with all, 1. Spread sheets can be configured with data validation.2 Spread sheets are front facing to the user of any skill, you cannot ask end user to work on databases 3. Well we can always have Databases connected to excel in the back end .. problem solved? look forward but yes useful

  • @Trey7Walker
    @Trey7Walker 5 років тому +25

    The ACCESS to this video is EXCELent

  • @eddieyutub
    @eddieyutub 5 років тому +7

    Excel is perfect for project management if you know how to use it. Database is for operation.

    • @ksojoel
      @ksojoel 4 роки тому

      i bet microsoft project is better for pm than excel is

    • @captainkeyboard1007
      @captainkeyboard1007 4 роки тому +1

      I find that Excel is suitable for intensive number crunching and various calculations, and Access is right for information management, indexing and filing data. Its tools such as tables, queries, forms and reports are remarkable.

  • @TortoRacoon
    @TortoRacoon Рік тому +2

    You can reference tables or specific cells in Excel so the data will update in other tables as well

    • @Brandon354786
      @Brandon354786 Рік тому +2

      Yep. I'm not saying this video is useless, but 90% of the things he mentions as being advantages for databases are 100% possible to do in excel. Will a Database do it better? Sure, but for the average person it won't matter that a database uses slightly less resources per entry, or can go past one million entries.
      It is weird too, because so many videos on Access say the exact same thing, and I know it to not be true because I have literally made spreadsheets that do everything they are talking about that they say you need a database for.
      Want to limit users to only entering Dates, or selections from a list? Excel can do it.
      Want to create data that auto-updates every other instance of itself? Excel can do.
      Want to set user edit permissions? Excel can do it.
      So on and so forth.
      Like I said, a database may be able to do it better, but they aren't framing it that way, they are framing it as Excel not being able to do it AT ALL.

  • @mrityunjayahiremath3951
    @mrityunjayahiremath3951 5 років тому +17

    I feel that there is something fishy about spreadsheets in the long run. I feel databases are more reliable. Please correct me if I am wrong

  • @bryanphillips7252
    @bryanphillips7252 9 місяців тому

    In the example of changing the McKinley(?) email address in Excel, could you use the Find and Replace tool so that you only have to do it once instead of several times manually?

  • @AndyLiner
    @AndyLiner 4 місяці тому

    The VLookup function & ImportRange function are basically the same as a relational database.. if you get creative most of the features exclusive to databases can be done in Excel/Google Sheets, the biggest downside is the api call limits & limited capacity of spreadsheets

  • @JuanPabloVivasR
    @JuanPabloVivasR 4 роки тому +2

    I've been an excel user for a long time, even I know macros, but knowing this I'll surely try SQL, although I might continue using excel for presentation by far

    • @thatoneuser8600
      @thatoneuser8600 3 роки тому +1

      Yo, updates one year later? Are you using SQL now, or did you completely drop it?

  • @dalskiBo
    @dalskiBo Рік тому

    Thank you, well explained

  • @karlyadams6760
    @karlyadams6760 Рік тому

    What about cvs or other formats in excel, which also cannot store formatting and different fonts?

  • @mahougnondjihouessi9629
    @mahougnondjihouessi9629 5 років тому +3

    Easy to understand! Thank you very much

  • @dianamgdata
    @dianamgdata 2 роки тому

    Are there Open Source / Free resources for managing Data Bases?

  • @eddieyutub
    @eddieyutub 5 років тому +6

    With excel, one can deal with day to day data needs without the need to convince IT to create the desired output from the current database. I use excel to make database that existing database and query cannot provide. It has help me to handle enterprise accounts that the companies I worked for is unable to provide.

  • @namroy8625
    @namroy8625 5 місяців тому

    excelent video...

  • @thangaveluraj5366
    @thangaveluraj5366 3 роки тому

    Excellent presentation, thank you very much

  • @hamedhasan5843
    @hamedhasan5843 4 роки тому +3

    Thanks. I was thought spreadsheet and database are same in many cases, but they are not.

  • @GG-671
    @GG-671 3 роки тому

    Great and concise presentation!! Made things much clearer as I am currently a CS major college student who's kinda struggling to get a clear pic of all the content I need to go through lol.

  • @oumarounsangounjikam5301
    @oumarounsangounjikam5301 Рік тому

    thanks this realy helped me

  • @edvirgiliom
    @edvirgiliom 5 років тому +2

    Why does he says at 3:21 that "there is no way you can mistake a record of data with a calculation? Thanks for the help!

    • @tabithaday127
      @tabithaday127 4 роки тому +2

      I think this comment was to emphasize the data integrity offered by databases over spreadsheets. In database software (like Microsoft Access) calculations can only occur in a certain space in the workbook, separate from your table of records (rows of data), so if you are looking for only the original (raw) data or only the calculations on those data it is very easy to find and distinguish between them. This is different from spreadsheet software (like Microsoft Excel) because in spreadsheets you can have data and calculations occur in the same space- even the same row; this mixing of raw and processed data can become confusing, especially if multiple users are working with the same dataset.
      As an example scenario, let's say a forest research team has a set of data describing the trees growing in their research plot. These data may contain information like species names, dates observed, descriptions of the tree's condition, heights, or other measurements. Perhaps some of the team members need to know information about the growth of the trees over time: these people would need to be able to make calculations for the data. But maybe the other team members need to report on the current status of the trees, without any changes. If the data were in an Excel spreadsheet, it would be possible for the calculations team to start typing in the raw dataset and potentially change the information, which would make the reporting teams' job more difficult because they would have to sort through which data were raw and which were edited. In Access, the calculations team would NOT be able to type calculations into the same rows as the raw data, but would be able to complete their work in a separate section of the workbook, allowing each team to complete their tasks without interfering with the success of the other team. With careful management of and communication about the data, Excel could be used effectively by this team, but they would need to agree on how to use the sheets so that they would not accidentally undo or inhibit the work of others.
      Essentially, Access allows more control over where, and by whom data can be manipulated (more organization features) and Excel allows more control over how data can be manipulated (more calculation and representation features).

    • @neaworld3960
      @neaworld3960 2 роки тому

      This has been. It's been bothering me. I'm not gonna prolong it anymore... As your friend, I have to tell you that Someone loves you so much that they would die for you .. they want you to talk to them, to open your door to them ... the door of life.. they really want the best for you and you're probably gonna be reaally upset that I'm talking to you about GOD but I have to I'm scared for you. please don't cut yourself I know how hard it can get but God will deliver you through it all.. just talk to him ..bring all your problems to him. I'm not sure when God will come back but one thing I know is that there is hell and the devil is trying to bring you there you won't actually die there but SUFFER and burn alive there,, please go towards the light.. please I am begging you to be saved because the only reason you're sad is that you are not on the path destined for you.. hear me out.. As a Christian, I have a DUTY to bring non-believers to the light of Christ and share the gospel with you.I can't stand to see you sad but know why but not help you. It's my calling .. after this life is heaven .. there we will see all of the angels and reconnect with family members. but before that we will be judged by God by our life I KNOW He exists (God) and I Know that you're a good person..PLEASE PLEASE be saved by God..he loves you. I love you (as a friend of course) Remember, we can't see the virus, but we claim it is there in the air, we wear masks and stay inside from something we can't see but people have gotten sick. We can't see God, but we have seen his miracles- life- he has LITERALLY brought people back to life and healed them.. he can heal you if you give him a chance.
      2 Chronicles 7:14- If my people, who are called by my name, will humble themselves and pray, and seek my face, and turn from their wicked ways, then I will hear from heaven and I will forgive their sin and heal the land.

  • @3DCrafterBro
    @3DCrafterBro 2 роки тому

    Thanks for the video :D

  • @sofusaxelsen4029
    @sofusaxelsen4029 4 роки тому +2

    Omg, yeah this is very useful!

  • @s2f-spiritualfinancialfree785
    @s2f-spiritualfinancialfree785 2 роки тому

    thank you so much!!

  • @JB-sz4wy
    @JB-sz4wy 5 років тому +2

    I have access and excel although I find Excel is far easier to use for the graphing features and with Access the userface is not very good in the sense that they make the program hard to learn. Fooling with it will eventually get you to learn it though although the chart tools are hard to find and if you set a certain rule it can be difficult to undo it and if you have tables open you cannot run things although thats it

    • @rons.6683
      @rons.6683 5 років тому

      JB 6000 That has been MY experience as well.

  • @rangaramc66
    @rangaramc66 5 років тому +1

    Thank You

    • @neaworld3960
      @neaworld3960 2 роки тому

      This has been. It's been bothering me. I'm not gonna prolong it anymore... As your friend, I have to tell you that Someone loves you so much that they would die for you .. they want you to talk to them, to open your door to them ... the door of life.. they really want the best for you and you're probably gonna be reaally upset that I'm talking to you about GOD but I have to I'm scared for you. please don't cut yourself I know how hard it can get but God will deliver you through it all.. just talk to him ..bring all your problems to him. I'm not sure when God will come back but one thing I know is that there is hell and the devil is trying to bring you there you won't actually die there but SUFFER and burn alive there,, please go towards the light.. please I am begging you to be saved because the only reason you're sad is that you are not on the path destined for you.. hear me out.. As a Christian, I have a DUTY to bring non-believers to the light of Christ and share the gospel with you.I can't stand to see you sad but know why but not help you. It's my calling .. after this life is heaven .. there we will see all of the angels and reconnect with family members. but before that we will be judged by God by our life I KNOW He exists (God) and I Know that you're a good person..PLEASE PLEASE be saved by God..he loves you. I love you (as a friend of course) Remember, we can't see the virus, but we claim it is there in the air, we wear masks and stay inside from something we can't see but people have gotten sick. We can't see God, but we have seen his miracles- life- he has LITERALLY brought people back to life and healed them.. he can heal you if you give him a chance.
      2 Chronicles 7:14- If my people, who are called by my name, will humble themselves and pray, and seek my face, and turn from their wicked ways, then I will hear from heaven and I will forgive their sin and heal the land.

  • @j.karlosp7059
    @j.karlosp7059 5 років тому +4

    excel for me is better i feel like I have more control specially if you know the formulas and how excel work

    • @ckhobhey1047
      @ckhobhey1047 3 роки тому +1

      Nope... Excel is Limited... Please learn access and get a better experience.

  • @damnson1754
    @damnson1754 4 роки тому +2

    1:23

  • @colephillips8070
    @colephillips8070 3 роки тому

    Can anyone explain why a database would be better than a spread sheet fro creating a mailing list? Is it just because the columns have information preset?

    • @neaworld3960
      @neaworld3960 2 роки тому

      This has been bothering me. I'm not gonna prolong it anymore... As your friend, I have to tell you that Someone loves you so much that they would die for you .. they want you to talk to them, to open your door to them ... the door of life.. they really want the best for you and you're probably gonna be reaally upset that I'm talking to you about GOD but I have to I'm scared for you. please don't cut yourself I know how hard it can get but God will deliver you through it all.. just talk to him ..bring all your problems to him. I'm not sure when God will come back but one thing I know is that there is hell and the devil is trying to bring you there you won't actually die there but SUFFER and burn alive there,, please go towards the light.. please I am begging you to be saved because the only reason you're sad is that you are not on the path destined for you.. hear me out.. As a Christian, I have a DUTY to bring non-believers to the light of Christ and share the gospel with you.I can't stand to see you sad but know why but not help you. It's my calling .. after this life is heaven .. there we will see all of the angels and reconnect with family members. but before that we will be judged by God by our life I KNOW He exists (God) and I Know that you're a good person..PLEASE PLEASE be saved by God..he loves you. I love you (as a friend of course) Remember, we can't see the virus, but we claim it is there in the air, we wear masks and stay inside from something we can't see but people have gotten sick. We can't see God, but we have seen his miracles- life- he has LITERALLY brought people back to life and healed them.. he can heal you if you give him a chance.
      2 Chronicles 7:14- If my people, who are called by my name, will humble themselves and pray, and seek my face, and turn from their wicked ways, then I will hear from heaven and I will forgive their sin and heal the land.

  • @shaikshafi4332
    @shaikshafi4332 Рік тому

    Thanks.

  • @eddieyutub
    @eddieyutub 5 років тому +3

    You can use excel for small database

  • @MontyYT578
    @MontyYT578 5 років тому +2

    Anyone from Mr Mousa’s class?

  • @jaysant6958
    @jaysant6958 Рік тому

    I think I need a little more convincing. There’s not anything really that o haven’t been able to do with spreadsheets yet. But after all, database is more useful for large amounts of data and so maybe that’s why I find spreadsheets the better for now.

  • @phanx0m924
    @phanx0m924 Рік тому

    Thanx! Except you can have Excel update the data in other places.

  • @Paul-im7pd
    @Paul-im7pd 11 місяців тому

    not true, you can set Excel only accepting for example natural numbers in a specific cell.

  • @DrummaBoy202
    @DrummaBoy202 6 місяців тому

    I can't stop hearing "implemented - plemented" in my head.

  • @Generalistcrafts
    @Generalistcrafts 5 років тому

    Q1

  • @Clawwingo
    @Clawwingo 4 роки тому

    I caanot believe I have this in class 8

    • @neaworld3960
      @neaworld3960 2 роки тому

      This has been. It's been bothering me. I'm not gonna prolong it anymore... As your friend, I have to tell you that Someone loves you so much that they would die for you .. they want you to talk to them, to open your door to them ... the door of life.. they really want the best for you and you're probably gonna be reaally upset that I'm talking to you about GOD but I have to I'm scared for you. please don't cut yourself I know how hard it can get but God will deliver you through it all.. just talk to him ..bring all your problems to him. I'm not sure when God will come back but one thing I know is that there is hell and the devil is trying to bring you there you won't actually die there but SUFFER and burn alive there,, please go towards the light.. please I am begging you to be saved because the only reason you're sad is that you are not on the path destined for you.. hear me out.. As a Christian, I have a DUTY to bring non-believers to the light of Christ and share the gospel with you.I can't stand to see you sad but know why but not help you. It's my calling .. after this life is heaven .. there we will see all of the angels and reconnect with family members. but before that we will be judged by God by our life I KNOW He exists (God) and I Know that you're a good person..PLEASE PLEASE be saved by God..he loves you. I love you (as a friend of course) Remember, we can't see the virus, but we claim it is there in the air, we wear masks and stay inside from something we can't see but people have gotten sick. We can't see God, but we have seen his miracles- life- he has LITERALLY brought people back to life and healed them.. he can heal you if you give him a chance.
      2 Chronicles 7:14- If my people, who are called by my name, will humble themselves and pray, and seek my face, and turn from their wicked ways, then I will hear from heaven and I will forgive their sin and heal the land.

  • @jossue2141
    @jossue2141 Рік тому

    like si vienes de edutin

  • @lostfan5054
    @lostfan5054 10 днів тому

    I'm sorry but I still don't see why I'd wanna use a database instead of Excel. Seems like Excel does everything and more.

  • @fazilop9318
    @fazilop9318 3 місяці тому

    Don't believe.

  • @romeowhiskey1146
    @romeowhiskey1146 2 роки тому

    "In this LECTURE...."...stop using LECTURE...nobody wants to be LECTURED to.
    Also "TAY..BU...LAR" form is called by the rest of us as TAB-U-LAR.
    Geez where is this person from? Clearly not America.

    • @daniel_cunha
      @daniel_cunha Рік тому

      f*ck you bro, you disrespect someone just because of accent?? how many languages do you speak perfectly, without any of this type of mistakes you pointing??