Go to Main Content

Purdue Self-Service



Detailed Course Information


Fall 2024
Jun 25, 2024
Transparent Image
Information Select the desired Level or Schedule Type to find available classes for the course.

AGEC 20201 - Introduction To Data Analytics For Agricultural Business
Credit Hours: 3.00. Overview of data analytics in agricultural business. Students are exposed to an overview of software tools with a primary focus on Excel, introduction to relational databases, and data visualization. Focus is in using financial, accounting, and economic data to make management decisions. Laptop required.
3.000 Credit hours

Syllabus Available
Levels: Undergraduate, Graduate, Professional
Schedule Types: Distance Learning, Lecture

Offered By: College of Agriculture
Department: Agricultural Economics

Course Attributes:
Credit By Exam, Lower Division

May be offered at any of the following campuses:     
      West Lafayette

Learning Outcomes: 1. Create and format a basic Excel worksheet. 2. Apply formulas and functions to calculate and analyze data. 3. Create charts and insert sparklines to represent data visually. 4. Manage and analyze large sets of data. 5. Analyze data by creating subtotals, PivotTables, and PivotCharts. 6. Use decision-making tools such as Range Names, Data Tables, and Goal Seek. 7. Manipulate data using date, logical, statistical, and financial functions. 8. Employ statistical functions to analyze data for decision making. 9. Demonstrate data management and error control within workbooks containing links and 3-D formulas. 10. Import, format, and manipulate data from external sources. 11. Manipulate data using text, database, and lookup functions. 12. Demonstrate how to design templates, insert comments, create macros, and use VBA. 13. Read an ERD Diagram. 14. Learn elements of Structured Query Language including the ability to create tables, retrieve, update, and delete data. 15. Understand usage of primary and foreign keys. 16. Create a relational database. 17. Understand different data types. 18. Create and format visualizations. 19. Create visualizations for nominal, ordinal, interval, and ratio scale data. 20. Create map visualizations.

Return to Previous New Search
Transparent Image
Skip to top of page