Database vs Spreadsheet - Advantages and Disadvantages

Подписаться 319 тыс.

Просмотров 204 тыс.

50% 1

👉Sign up for Our Complete Data Science Training with 57% OFF: bit.ly/3sJATc9
👉 Download Our Free Data Science Career Guide: bit.ly/47Eh6d5
In this video, we will focus on the advantages and disadvantages of spreadsheets vs databases.
What is a spreadsheet? It is an electronic ledger, an electronic version of paper accounting worksheets. It was created to facilitate people who needed to store their accounting information in tabular form digitally. So, it is possible to create tables in a spreadsheet. This is one reason some people believe spreadsheets and databases are interchangeable, while, in reality, they aren’t.
There are similarities between the two. Both can contain a large amount of tabular data and can use existing data to make calculations. Third, neither spreadsheets nor databases are typically used by a single person, so many users will work with the data. The differences between the two forms of data storage lie in the way these three characteristics are implemented.
Ok. Imagine a spreadsheet. Every cell is treated as a unique entity. It can store any type of information - a date, an integer value, a string name. And then, not only can we have different types of values in various cells, but we can also apply a specific format to these cells.
This is not inherent to databases. They contain only raw data. Each cell is a container of a single data value. It is the smallest piece of information there is. You must pre-set the type of data contained in a certain field. This feature prevents inadvertent mistakes - for example, in a field containing date values, should the user try to insert a string, the software will show an error and she will have the chance to correct herself. This won’t happen in Excel - if you insert a string in the column with date values, you wouldn’t obtain an error message, and Excel will store the string value.
► Consider hitting the SUBSCRIBE button if you LIKE the content: ru-vid.com...
► VISIT our website: bit.ly/365ds
🤝 Connect with us LinkedIn: / 365datascience
365 Data Science is an online educational career website that offers the incredible opportunity to find your way into the data science world no matter your previous knowledge and experience. We have prepared numerous courses that suit the needs of aspiring BI analysts, Data analysts and Data scientists.
We at 365 Data Science are committed educators who believe that curiosity should not be hindered by inability to access good learning resources. This is why we focus all our efforts on creating high-quality educational content which anyone can access online.
Check out our Data Science Career guides: • How to Become a... (Da...
#Database #Spreadsheet #DataScience

Опубликовано:

2 ноя 2017

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 73

@365DataScience 5 лет назад

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

@wsitech 2 года назад

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 11 месяцев назад

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.

@awesh1986 5 лет назад

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 5 лет назад

We're so happy to see you like our content! You could either subscribe to our RU-vid 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! :)

@dalskiBo 7 месяцев назад

Thank you, well explained

@mahougnondjihouessi9629 5 лет назад

Easy to understand! Thank you very much

@365DataScience 5 лет назад

Glad you enjoyed the video! :)

@captainkeyboard1007 3 года назад

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 Год назад

Also for graphs.

@captainkeyboard1007 Год назад

@@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 Год назад

@@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 Год назад

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

@thangaveluraj5366 2 года назад

Excellent presentation, thank you very much

@GG-671 2 года назад

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.

@phanx0m924 Год назад

Same!

@sofusaxelsen4029 3 года назад

Omg, yeah this is very useful!

@oumarounsangounjikam5301 Год назад

thanks this realy helped me

@farukTheProBro 2 года назад

Thanks for the video :D

@s2f-spiritualfinancialfree785 Год назад

thank you so much!!

@Trey7Walker 4 года назад

The ACCESS to this video is EXCELent

@Trey7Walker 4 года назад

good comment

@CrushedAsian255 Год назад

⁠@@Trey7Walkerforgot to switch accounts

@bobanmilisavljevic7857 8 месяцев назад

Gottem!

@nutella_drifter 4 года назад

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 4 года назад

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

@namroy8625 15 дней назад

excelent video...

@granand 3 года назад

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

@mrityunjayahiremath3951 5 лет назад

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

@JuanPabloVivasR 3 года назад

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 2 года назад

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

@rangaramc66 4 года назад

Thank You

@neaworld3960 Год назад

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.

@hamedhasan5843 4 года назад

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

@TortoRacoon Год назад

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

@Brandon354786 11 месяцев назад

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.

@eddieyutub 5 лет назад

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

@ksojoel 4 года назад

i bet microsoft project is better for pm than excel is

@captainkeyboard1007 3 года назад

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.

@shaikshafi4332 8 месяцев назад

Thanks.

@eddieyutub 5 лет назад

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.

@karlyadams6760 Год назад

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

@bryanphillips7252 4 месяца назад

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?

@dianamgdata 2 года назад

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

@JB-sz4wy 5 лет назад

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 5 лет назад

JB 6000 That has been MY experience as well.

@j.karlosp7059 5 лет назад

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

@ckhobhey1047 3 года назад

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

@eddieyutub 5 лет назад

You can use excel for small database

@phanx0m924 Год назад

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

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

@MontyYT578 4 года назад

Anyone from Mr Mousa’s class?

@damnson1754 3 года назад

1:23

@colephillips8070 2 года назад

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 Год назад

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.

@edvirgiliom 5 лет назад

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 3 года назад

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 Год назад

@Paul-im7pd 7 месяцев назад

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

@DrummaBoy202 2 месяца назад

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

@Generalistcrafts 4 года назад

@Clawwingo 4 года назад

I caanot believe I have this in class 8

@neaworld3960 Год назад

@jossue2141 Год назад

like si vienes de edutin

@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 Год назад

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