Instructor for this course
more

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

Last updated/reviewed: June 04, 2018

Included In Certifications

This course is included in the following Expert Certifications:

15 CoursesCertified Data Analyst Professional

  1. The Fundamentals of Business Intelligence (BI): What it Does and Why it's so Essential
  2. How is Industry Using Big Data? – A Case Study Reading
  3. Business Intelligence - Data Collection and Cleaning
  4. Business Intelligence - Structuring Data for Analysis
  5. Business Intelligence - Fundamentals of Data Analysis
  6. Business Intelligence - Using Big Data Analytics
  7. Doing Data Analytics In Excel (Hands-on module)
  8. Regressions in Excel (Hands-on module)
  9. Financial Forecasting
  10. Advanced Analytics – Omitted Variables
  11. Advanced Analytics – Fixed Effects
  12. Case Study in Data Analytics
  13. Using Regressions for Forecasting
  14. Financial Forecasting in Excel (Hands-on module)
  15. Blockchain for Business

47 Reviews (290 ratings)Reviews

3
Member's Profile
Course is beginning to repeat information addressed in other courses. The review can be helpful to a point, but it felt like it shot past the point of usefulness.
5
Anonymous Author
I leaned data structure, assessing data, ratios and key metrics from my college and this course provided me a fresh review.
5
Anonymous Author
Great session. Learned a lot on statistics and how to organize and analyze large sets of data and why it is useful.
4
Anonymous Author
Nothing surprised me about this course. Everything went as expected. Nothing new here, but helpful review for me.
5
Anonymous Author
Good presentation. Especially the discussion on imputing variables and total asset turnover ratio.
4
Anonymous Author
Very informational course. The mid-section can be a bit bland, but it's very useful knowledge.
4
Anonymous Author
Great course that provides plenty of examples of how to use the ratios for analysis.
5
Anonymous Author
.This course was helpful in determining different ways to structure data.
3
Anonymous Author
This training did a good job of explaining ways to analyze data.
4
Anonymous Author
This exam was more challenging than the others! Good to see.
5
Anonymous Author
Good course. Would recommend. Will be taking more courses.
4
Member's Profile
Great overview of the steps and potential hurdles that come while structuring data for Analysis and Business Intelligence. The only negative was that there was a bit too much discussion on financial metrics and ratios, which are interesting in themselves, but a bit off topic from the focus of the video. All in all great info and would recommend.
4
Anonymous Author
The ratios were explained well. There were a lot of equations, but the instructor was able to articulate the purpose and the expectations for them well.
4
Anonymous Author
Solid review of data selection. A bit duplicative with some of the information, but over a good into to different formulas and ways to analyze data.
4
Anonymous Author
Overall, good course. I thought it was a bit duplicative with some of the information discussed in previous courses, but still a good overview.
5
Member's Profile
Very insightful for how to look at data. Discussion on the limitation of data is very helpful for looking at data in ways that can be useful.
2
Anonymous Author
this course was very boring and could have been more useful to have had some test questions in between lectures to retain my attention
3
Anonymous Author
The majority of this seemed highly repetitive of the previous business intelligence courses, with much less new information.
5
Member's Profile
Great review of data selection or organizing. Really appreciated the talk about Benford Law, interesting to learn about that
5
Anonymous Author
I appreciated the instructor's crossover from one lesson to another. This cohesiveness blends the lessons together well.
5
Member's Profile
Great refresher for terms and ideas I learned in college. Also helped me find more practical applications of each topic
4
Anonymous Author
One of the questions was wrong. It asked about the Z score but referenced marketing rather than bancruptcy.
5
Member's Profile
Good overview of data analysis. Not a lot of detail. But taken with the other courses, it makes sense.
3
Member's Profile
The course had a lot technical information that was difficult to follow as I have never seen it before.
5
Anonymous Author
Basic intro into different formulas and ways to analyze both qualitative and quantitative data.
3
Anonymous Author
I wish Mr. McDonald had used more mathematical examples to illustrate his points.
4
Member's Profile
Good course with valuable information. The presentation was very easy to follow.
4
Member's Profile
a good course with a good amount of coverage in the financial ratios area.
5
Member's Profile
Great instructor and I would suggest this course to a college finance student
5
Member's Profile
The mechanics of completing the course appear to be subject to user error
5
Member's Profile
Very good course, easy to understand topic and PDF correlated perfectly
5
Member's Profile
Continuing to learn a lot as I work my way through these courses.
5
Anonymous Author
Great course. Helped clear up confusing on some of these topics.
4
Anonymous Author
Very interesting and insightful course. Very nicely put together.
4
Member's Profile
Great review of the financial ratios, as well as data inputs.
4
Member's Profile
My video was freezing a lot so I had to use the slides for it
4
Anonymous Author
More great info on Business Intelligence, useful course.
4
Anonymous Author
Had very useful information and review of data analysis.
5
Member's Profile
Everything about this course was absolutely fantastic.
5
Member's Profile
Great course! Very informative.
5
Member's Profile
Great course! Very informative
5
Member's Profile
Interesting and informative!
5
Anonymous Author
Very good course!
5
Anonymous Author
Very informative
4
Member's Profile
Useful course
5
Anonymous Author
Geat Course!
5
Anonymous Author
excellent

Prerequisites

Course Complexity: Intermediate

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.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION and OVERVIEW
  1:30Introduction to Business Intelligence - Structuring Data For Analysis
Structuring Data for Business Analysis
  6:40Data Structure Overview
  10:52Assessing Data
  18:17Ratios and Key Metrics
  8:20Categorical Variables
CONCLUSION
  7:21Imputing Data and Conclusion
Continuous Play
  52:59Business Intelligence - Structuring Data for Analysis Full Video
SUPPORTING MATERIALS
  PDFSlides: Structuring Data for Business Analysis
  PDFStructuring Data for Business Analysis Glossary/Index
REVIEW and TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM