STOP using Spreadsheets for Everything!
👨🏼💻 My FREE Course to be a Data Analyst 👉 https://lukebarousse.com/5daycourse
In this video we cover a couple of my past projects as a data analyst that involved spreadsheets (such as Microsoft Excel and Google Sheets). We look at the good with this application and then move into the bad uses/practices of this. Specifically, I go into issues with using spreadsheets for: Data Storage, Reproducibility, and Sharing/Dashboarding. Finally I end with my recommended resources which I have included links for below. 🤙🏼
Certificates & Courses
==================================
Coursera Courses:
📜 Google Data Analytics Certificate (START HERE) 👉🏼 https://lukeb.co/GoogleCert
💿 SQL for Data Science 👉🏼 https://lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 https://lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 https://lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 https://lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 https://lukeb.co/RforDataScienceJH
Coursera Plus Subscription (7-day free trial) 👉🏼 https://lukeb.co/CourseraPlus
DataCamp Courses:
🐍 Python 👉🏼 https://lukeb.co/PythonBasicsDataCamp
📈 Power BI 👉🏼 https://lukeb.co/PowerBIDataCamp
📊 Tableau 👉🏼 https://lukeb.co/TableauDataCamp
🏴☠️ R 👉🏼 https://lukeb.co/RDataCamp
🐍 Data Analyst w/ Python 👉🏼 https://lukeb.co/PythonAnalystDataCamp
DataCamp Subscription (25% off ) 👉🏼 https://lukeb.co/datacamp_discount
👨🏼🏫 All courses 👉🏼 https://kit.co/lukebarousse/data-anal...
My Tech for Data Science
(Includes Amazon Affiliate Links)
==================================
💻 Dell New XPS 13 (PC of choice) 👉🏼 https://geni.us/DellNewXPS13
💻 Dell New XPS 15 👉🏼 https://geni.us/DellNewXPS15
👨🏼💻 M1 Macbook Air 8GB (Mac of choice) 👉🏼 https://geni.us/M1macAir8GB
👨🏼💻 M1 Macbook Pro 8GB 👉🏼 https://geni.us/M1macPro8GB
🔌 Must-have Mac dock 👉🏼 https://geni.us/CalDigitTS3
🖥 M1 Multiple monitor adapter 👉🏼 https://geni.us/DisplayLinkAdapter
⌨️ Mac Keyboard 👉🏼 https://geni.us/MacMagicKeyboard
🖱 Mac Mouse 👉🏼 https://geni.us/MacMagicMouse
💾 Small (1TB) External HD 👉🏼 https://geni.us/WDelements1TB
💾 Large (14TB) External HD 👉🏼 https://geni.us/WDelements14TB
🏢 Standing Desk 👉🏼 https://geni.us/StandingDeskFezibo
📗 Data Science Must Read 👉🏼 https://geni.us/StorytellingWithData
📸 Camera of Choice 👉🏼 https://geni.us/SonyA6600body
For computers, I recommend checking the manufacturer's website (i.e., dell.com) for deals/rebates
Social Media / Contact Me
======================
🙋🏼♂️Website: https://www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: [email protected]
As a member of the Amazon Associate Program and Coursera Affiliate Program, I earn a commission from qualifying purchases on the links above. It costs you nothing, but helps me with content creation.
00:00 Intro
00:34 Overview
01:06 Good Example Using Spreadsheets
02:05 Not so Good ex. Using Spreadsheets
03:02 Data Storage - Spreadsheet Issues
04:51 Reproducibility - Spreadsheet Issues
06:27 Sharing/Dashboards - Spreadsheet Issues
07:48 How I've Learned These Tools
08:24 Recommended Resources
#datanerd #dataanalyst #datascience
Watch video STOP using Spreadsheets for Everything! online without registration, duration hours minute second in high quality. This video was added by user Luke Barousse 30 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 146,782 once and liked it 4.9 thousand people.