This course prepares 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 is on financial data though the techniques are also applicable to more general forms of data like that used in marketing or management analyses.
***Please download and open all supporting materials before starting the course videos.***
Learning Objectives
- Discover how to evaluate data for accuracy using Benford’s Law
- Explore how to develop ratios and relative metrics to better evaluate data
- Explore how to develop moving average and other tools to smooth data over time
- Discover how to create binary variables and decile rankings to evaluate data structure
***Each of the objectives above will be covered in Excel, SAS, and Stata
Included In Certifications
This course is included in the following Certification Programs:
15 CoursesData Analytics Professional (DAP) Certification
- The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
- How is Industry Using Big Data? – A Case Study Reading
- Business Intelligence - Data Collection and Cleaning
- Business Intelligence - Structuring Data for Analysis
- Business Intelligence - Fundamentals of Data Analysis
- Business Intelligence - Using Big Data Analytics
- Doing Data Analytics In Excel (Hands-on module)
- Regressions in Excel (Hands-on module)
- Financial Forecasting
- Advanced Analytics – Omitted Variables
- Advanced Analytics – Fixed Effects
- Case Study in Data Analytics
- Using Regressions for Forecasting
- Financial Forecasting in Excel (Hands-on module)
- Blockchain for Business
94 Reviews (528 ratings)
Prerequisites
No Advanced Preparation or Prerequisites are needed for this course. However, it is recommended to take the other courses in the series prior to completing this one.