Carl H. Lindner College of BusinessCarl H. Lindner College of BusinessUniversity of Cincinnati

Carl H. Lindner College of Business

Data Management for Analysts

                                                Jan 10 & 11 2019             

This course description is being modified to include overviews of other database technologies and how business analysts can use Structured Query Language (SQL) queries to access company data for analysis.

In this two-day short course offered through the Center for Business Analytics at the University of Cincinnati, you will learn

  • Database design and data rules
  • How to get data into a well designed database
  • The steps to use SQL to interact with data
  • Practical examples for solving common business problems, efficient database structure design, and how to create interactions between analytical tools and a database

This course will allow novice  users and those with some experience, the chance to learn skills, syntax, and techniques to perform analytics and data mining on datasets.

This course will be followed by an Advanced Data Management session designed for attendees from this class and more experienced users to learn and practice more advanced data management methods.

Course Description: 
Data is the foundation from which business analytics, data visualization, and business intelligence originates.  This course focuses on learning the steps to get data into a well-designed database and teaches participants how to use Structure Query Language (SQL) to interact with data. The course will start with topics related to database design and  data rules to provide participants with a sound knowledge of databases and relational data design.  The class will finish with the coverage of practical examples to solve common business problems, efficient database structure design, and solutions on how to create interactions between analytical tools and a database. This class will leverage an individual’s strengths in business, information technology and analytics, and is meant for those wanting to learn more about databases and programming in SQL. 

25% of class time will be used for instructor-guided hands-on lab time and applications of data management.          

Course Fee: $795 includes breakfasts, lunches, refreshments and free parking for both days.

Course Location:
U-Square. Room 359
225 Calhoun Street
Cincinnati. OH 45219   (google map link)

Instructor Bio:  
Andrew Harrison is an Assistant Professor of Information Systems in the Lindner School of Business at the University of Cincinnati. His research interests include consumer fraud, deception, security systems, privacy, media capabilities, and virtual worlds.



Future Training Fall 2018

Analytics in Excel
  Aug 23 & 24
Tableau Training Aug 23 & 24
MS PowerBI Training Oct 4 & 5
Python for Data Science Nov 29 & 30
Introduction to R TBD
Data Visualization TBD
Tableau Training Dec 6 & 7