This course is broken up into four modules.
The first module will prepare participants to begin business intelligence projects at their own firm. The focus of the course is a hands-on approach to gathering and cleaning data. After taking this course, participants will be ready to create their own databases or oversee the creation of databases for their firm. The focus in this course is on “Big Data” datasets containing anywhere from tens of thousands to millions of observations. While the tools used are applicable for smaller datasets of a few hundred data points, the focus is on larger datasets. The course also helps participants with no experience in building datasets to start from scratch. Finally, the course is excellent for users of Salesforce, Tableau, Oracle, IBM, and other BI software packages since it helps viewers see through the “black box” to the underlying mechanics of Business Intelligence practices.
The second module will prepare participants to begin business intelligence projects at their own firm. The focus of the course is a hands-on approach to structuring data including generating new variables based on comparative and relative metrics. The structuring of these variables will be done in Excel, SAS, and Stata to give viewers a sense of familiarity with a variety of different software package structures. The focus in this course will be on financial data though the techniques are also applicable to more general forms of data like that used in marketing or management analyses.
The third module will prepare participants to begin running data analysis on databases. Both univariate and multivariate analysis will be covered with a particular focus on regression analysis. Regression analysis will be done in Excel, SAS, and Stata to give viewers a sense of familiarity with a variety of different software package structures. The focus in this course will be on financial data though the techniques are also applicable to more general forms of data like that used in marketing or management analyses.
The fourth and final module will prepare participants to review, analyze, and make decisions based on results from business intelligence projects. The course will cover reading and interpreting regression analysis. The course will also give participants the skills to critically analyze and identify potential limitations on analysis. The course will also cover predicting changes in business outcomes based on analysis and identifying the level of certainty or confidence around those predictions. This paves the way for future detailed courses in predictive analytics.
Michael is an assistant professor of finance at Fairfield University in Connecticut. He holds a PhD in finance from the University of Tennessee and his work has been quoted in the Wall Street Journal, CNN, Nasdaq.com, Bloomberg, Reuters, and many other outlets. Michael is the President of Morning Investments, a consulting firm headquartered in Connecticut. He consults extensively with organizations ranging from Fortune 500 companies and government agencies to start-up businesses on matters related to finance and investments. Michael has served also as an expert witness on finance related matters in legal disputes, and is an arbitrator with the Financial Industry National Regulatory Authority (FINRA).