Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more. Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology
Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology Transcript and Lesson Notes
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about Raw Data, Data, Proper Data Sets and Data Terminology: 1) (00:17) Introduction 2) (00:36) What is Raw Data? 3)
Quick Summary
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about Raw Data, Data, Proper Data Sets and Data Terminology: 1) (00:17) Introduction 2) (00:36) What is Raw Data? 3)
Key Takeaways
- Review the core idea: Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about Raw Data, Data, Proper Data Sets and Data Terminology: 1) (00:17) Introduction 2) (00:36) What is Raw Data? 3)
- Understand how Excel fits into Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology.
- Understand how Microsoft Excel fits into Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology.
- Understand how Highline College fits into Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology.
- Understand how Mike Girvin fits into Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology.
Key Concepts
Full Transcript
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about Raw Data, Data, Proper Data Sets and Data Terminology: 1) (00:17) Introduction 2) (00:36) What is Raw Data? 3) (01:33) What is Data? 4) (01:55) Data Types and Default Alignment in Excel 5) (06:12) What is Proper Data Set? 6) (07:32) Terms for Proper Data sets. We will see parallel terms for Databasing and Analytics. 7) (09:36) In Excel a Proper Data set may or may not have a Primary Key (List of Unique Elements) 8) (10:35) Variables and Variation 9) (12:48) Population & Sample 10) (13:02) Quantitative and Categorical Data 11) (14:55) Cross Sectional and Time Series data Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
Lesson FAQs
What is Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology about?
Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/AllFilesBI348Analytics.htm Learn about Raw Data, Data, Proper Data Sets and Data Terminology: 1) (00:17) Introduction 2) (00:36) What is Raw Data? 3)
What key concepts are covered in this lesson?
The lesson covers Excel, Microsoft Excel, Highline College, Mike Girvin, excelisfun.
What should I learn before Basic Excel Business Analytics #12: Raw Data, Data, Proper Data Sets and Data Terminology?
Review the previous lessons in Excel Business Analytics Free Course - Forecasting, Linear Programming, Simulation & more., then use the transcript and key concepts on this page to fill any gaps.
How can I practice after this lesson?
Practice by applying the main concepts: Excel, Microsoft Excel, Highline College, Mike Girvin.
Does this lesson include a transcript?
Yes. The full transcript is visible on this page in indexable HTML sections.
Is this lesson free?
Yes. CourseHive lessons and courses are available to learn online for free.
Continue Learning
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
