BTS 268 Advanced Business Database Tools • 5 Cr.
This hands-on course covers how to use data to analyze aspects of an organization's operation and make appropriate business decisions. It focuses on using web-based databases, working with external data tools to create reports and charts, exploring customer relationship database tools, and constructing methods for analyzing data in order to create effective visualizations using dashboards. Prerequisite: BTS 168 or BUSIT 103.
After completing this class, students should be able to:
- Create and use a data macro to ensure the accuracy of data.
- Secure data using passwords, startup options, replication, and backups.
- Create and publish web databases for small and medium-size businesses.
- Distinguish major stages of data analysis in business environments, including data acquisition, transport, storage, processing and servicing.
- Present large business data sets using various visualization tools.
- Develop a custom dashboard that allows users to leverage data in business decision making by creating reports and queries.
- Create and use databases for customer relationship management strategies to improve business relationships between an organization and its customers.