In this course, the learner will work with spreadsheets, databases, geographic information systems and data mining / modelling software. Microsoft Excel will be the application of choice for spreadsheets where the learner will produce several business models that incorporate various formulas to produce numerical, charting and statistical outputs. The learner will use Microsoft Access to create database business solutions that include tables, relationships, forms and queries leading to SQL, report and data mining outputs. In addition, the learner will setup databases on Microsoft SQL Server, apply security permissions, then create a link to Microsoft Access front-end forms. The learner will utilize Power BI to analyze and present their data outputs in visual, filtered and unfiltered solutions.
Business Applications I - CSA103