Analytics Training and Professional Development
These courses are open to the public. If you are an individual or business professional looking for analytics training, the Center for Business Analytics offers corporate training on a variety of business and data analytics topics. These short courses address some of the key skills required to increase data management, analytics and data science effectiveness and are taught by data scientists and professionals from the University of Cincinnati and from leading business analytics companies.
We also offer these and other customized courses at your location. For more information on any of these on-site course options, contact Glenn Wegryn, Executive Director of the Center for Business Analytics at email@example.com or 513-556-7146.
Upcoming Analytics Training
September 19 & 20: Data Management for Business Analysts
In this two-day short course 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
- 25% of class time will be used for instructor-guided hands-on lab time and applications of data management.
- Attendees should bring their own laptop, however there are a limited number of loaner laptops available.
- Information on any software downloads or course preparation will be sent approximately 1 week before the class start date
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.
Details and Registration
October 17 & 18: Introduction to R
This is the first course in the R for Data Science Series. R is one of the fastest growing programming languages and tool of choice for analysts and data scientists. In part, R owes its popularity to its open source distribution and massive user community. In this course, we will help both new and existing R users master the basics of R. There will be an emphasis on using hands on exercises and real world datasets. Upon successfully completing this course, students will:
- Be up and running with R
- Understand the different types of data R can work with
- Understand the different structures in which R holds data
- Be able to import data into R
- Perform basic data wrangling activities with R
- Compute basic descriptive statistics with R
- Visualize their data with base R and ggplot graphics
October 24 & 25: Advanced Tableau
This two-day workshop on Tableau will cover intermediate and advanced topics. Attendees should have attended previous "Introduction to Tableau" trainings or have significant experience using Tableau in a professional environment. Course content will include advanced chart types and business dashboards, advanced calculations in Tableau, using calculations, parameters, and table calculations, and other topics.
Details and Registration
October 31 & November 1: Intermediate Python for Data Science
The biggest mistake one can make while learning Python for data science is to learn Python for programmers. Learn Python the right way with our Python for Data Science Series.
In this course we will cover Python's powerful data science capabilities at an intermediate level, including control flow, writing functions, using python from the shell, plotting with user-friendly libraries, such as seaborn and plotly, and preview scikit-learn. Attendees should have attended previous "Introduction to Python" trainings or have experience using Python in a professional environment.
Details and Registration
October 31 & November 1: SQL for Business Analysts
This short course is a hands-on introduction to using SQL for data analysis. It is intended for the business analyst who is familiar with general database concepts and wants to perform their own data discovery. We will explore how to find answers in the data, pitfalls to avoid, and how to take analysis to the next level. Attendees should have familiarity with general database concepts. Attendance at "Data Management for Business Analysts" (Sept 19 & 20, http://www.cvent.com/d/1yqjzm) is highly recommended for those with no prior database experience.
Details and Registration
November 7 & 8: Advanced MS Power BI
This course takes a deep dive into advanced level Power BI skills, covering lesser known but more advanced skills from the Power BI set of features. This course is a continuation of the "Introduction to Power BI" class or the following knowledge is recommended prior to taking this course: how to connect to data, how to build basic data models, basic PowerBI visualizations, and basic DAX knowledge.
- Create more sophisticated calculations and metrics using advanced DAX functionality
- Improve the end user experience with various interactive reporting tools
- Efficiently publish and deploy PowerBI reports across an organization
November 21 & 22: Intermediate R
This is the second course in the "R for Data Science" series and will build on the material from Introduction to R. Attendance at the introductory course is not required for those with significant practical experience in a professional setting. This course will cover the application of R for the entire data science workflow – data acquisition, wrangling, visualization, analytic modeling, and communication. There will be an emphasis on hands-on exercises and real world datasets.
Details and Registration
December 5 & 6: Introduction to Tableau
This two-day training is designed for beginner Tableau users and anyone who works with data with or without technical or analytical backgrounds. Those with some prior Tableau experience will benefit from the many tips and trick covered in this training.
Details and Registration
Classes not currently scheduled
Advanced Data Management is a continuation of the topics discussed in the Introduction Data Management course. This course focuses on dimensional modeling and data warehousing techniques, and teaches participants advanced SQL code. SQL development will focus on learning procedural language SQL (PL/SQL, Transact-SQL, TSQL) to create flexible and useable solutions to solve test business cases. The class will finish with coverage of current database options (cloud services), discussion of NoSQL (big data solutions), and learning how to consume data from a database into analytical tools. This class will build upon an individual's strengths in business, information technology and analytics, and is meant for those wanting to increase their knowledge regarding databases and programming in SQL.
Find the useful information hidden in your data! This course surveys computer-intensive methods for inductive classification and estimation, drawn from statistics, machine learning, and data mining. Participants learn the key inner workings of leading algorithms, compare their merits, and briefly demonstrate their relative effectiveness on practical applications.
This is the third course in the R series and will build on the material from Intermediate R. Attendance at the introductory or intermediate course is not required for those with significant practical experience in a professional setting but it is strongly recommended that attendees have significant experience with the topics covered in those courses. This course will cover the application of several descriptive, predictive and prescriptive analytic techniques. The emphasis will be on the general purpose of these techniques along with integration and application in R rather than on the theoretical nature. This allows this course to be more accessible to a wider audience looking to inject R for analytic purposes across organizational processes. There will be an emphasis on hands-on exercises and real world datasets.
This course introduces intermediate-to-advanced tools in Excel for analytics. We will cover data visualization topics that move beyond the basic charting tools in Excel. Descriptive analytics methods for analyzing data and generating meaningful insights will be covered using PivotTables, PivotCharts and other Excel tools. We will use Excel for predictive analytics by utilizing Excel’s regression tools and other forecasting capabilities. What-if analysis and other prescriptive analytics tools in Excel will also be introduced. We will cover special Excel functions such as VLOOKUP, MATCH and Data Tables to help you unleash the power of Excel as an analytics tool. This is the perfect class for the Excel user who is ready to take the next step of improving their analytics capabilities in a familiar software environment.
This half-day session focuses on providing a fundamental understanding of what analytics is, examples of successful applications in financial and other industries, how to get started, and what resources, skill sets, organization and cultural elements need to be in place for long-term success. Examples in Descriptive, Predictive and Prescriptive analytics will be reviewed, including common tools and methods used to perform analytics and conveying results effectively. This is an interactive, thought-provoking course with lectures and break-out work groups to allow better understanding of the concepts taught.
Making sense of the tools used to analyze big data can seem confusing and overwhelming at times. This session helps you understand how these components function and form the core of big data analytics systems. The emphasis of this course will be on understanding the fundamental principles of big data systems using Hadoop and Spark.
Spark allows the processing of huge volumes of data in real-time, and is a dominant choice for performing analytics at scale. Similarly, the Hadoop Distributed File System (HDFS) forms the backbone of most big data systems. In this course, participants will learn the theory behind how these tools work so they can understand when, and how, to implement them effectively. The relative strengths and weaknesses of various big data systems will be highlighted to explain how Spark has emerged as a popular choice for analyzing dynamic, high-velocity, and high-volume data.
Participants will also get hands-on experience using HDFS and Spark to illustrate the power of big data analytics.
Most organizations don't suffer from a lack of data, but from a lack of actionable insights based on that data. Powerful techniques now exist to take messy data sets and generate surprising insights. Textbooks and websites tout the power of data mining, but few sources actually discuss the difficulties and challenges that must be overcome with real world data. This two-day workshop focuses on the challenges of building predictive models in the real world and techniques experienced practitioners apply when developing their models.
Data visualization encompasses a set of techniques and principles that can be used to transform data at its most basic form into charts and tables that can be analyzed and presented to generate insights and spur action. This two-day workshop will teach participants how to use data visualization to both analyze complex data sets to generate insights and to present analytical output as meaningful information.
If you are an experienced Power BI user and want to gain an more advanced knowledge, then this is the right course for you. This will be a deep dive into the advanced levels and methods. This course is in development and details will be available soon.
This course is intended for experienced users of Power BI and as the next step for those who have taken the "Introduction to Power BI" training at the Center. Attendees should have
This two-day workshop explores drivers behind Big Data and uses cases across a wide variety of industries to illustrate the power of new technologies to harness Big Data and generate meaningful insights. Participants will be introduced to Hadoop and key-value data storage, the central components of the Big Data movement. These systems allow the distributed processing of very large data sets for structured and unstructured data.
This course is designed to be an introduction to Python and its uses as a data analytics tool. The material will emphasize the core concepts in Python, specifically data types, data structures, functions, and classes and how they can be implemented and used to address data analytics problems. Popular modules used in data analysis will also be covered at a high level to include both NumPy, Matplotlib, and statsmodels.
Learn the fundamentals and application of modern machine learning tasks. This course will cover unsupervised techniques to discover the hidden structure of datasets along with supervised techniques for predicting categorical and numeric responses via classification and regression. This course is intended for academics and data science practitioners who wish to learn about machine learning tasks as well as a guide to applying them. Readers should have knowledge of basic statistical ideas, such as correlation and linear regression analysis, along with intermediate R programming skills.
Microsoft PowerBI is a business intelligence software rapidly gaining in popularity. Due to its comprehensive suite of data visualization and integration tools as well as its affordable pricing models, Gartner has ranked Microsoft PowerBI on par with Tableau in 2017.The course is designed to be an introduction to Microsoft PowerBI and its use as a data analytics and reporting tool. There will be an even mix of lecturing and working sessions where the students will be developing their own dashboards with some sample data.
If you work in analytics or data science you are familiar with the fact that data is being generated all the time at ever-faster rates. Analysts are often trained to handle tabular or rectangular data that are mostly numeric, but much of the data proliferating today is unstructured and text-heavy. Many of us who work in analytical fields are not trained in even the simplest approaches to analyzing unstructured text data. This short course serves as an introduction to text mining with the R programming language.
For questions and further course information please contact: