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.***This course covers cleaning databases and structuring them in a way that maximizes accuracy of business intelligence.
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.
- 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
Online
No advanced preparation or prerequisites are required for this course.
Online
Online
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward CPP recertification through the American Payroll Association (APA). Please make note of the Course Code on your CPP Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
Online
No advanced preparation or prerequisites are required for this course.
|
This activity, ID No. 19 ILL 000 has been approved for 1.0 Recertification Credit Hour(s) toward RCH recertification through the American Payroll Association (APA). Please make note of the Course Code on your FPC Recertification Log. For more information about certification or recertification, please visit the APA website at www.americanpayroll.org. |
On Demand/Online
No advanced preparation or prerequisites are required for this course.
On Demand/Online
No advanced preparation or prerequisites are required for this course.
Online
No advanced preparation or prerequisites are required for this course.
 | This activity, ID No. XXXXXX has been approved for #### CPE credit hours toward IRS Enrolled Agent (EA) continuing education requirements. In accordance with the standards set forth in Circular 230 section 10.6, CE credits have been granted based on a 50-minute hour. |
Online
Online
Online
Online
Online
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->XXXXXX<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->####<!-- // --> recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/shrmcertseal2017.png" width="80" height="60" alt="pre-approved by SHRM" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->XXXXXX<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->####<!-- // --> recertification credit hours toward SHRM-CP™ and SHRM-SCP™ recertification through the Society of Human Resource Management® (SHRM®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the Society for Human Resource Management website at <a href="https://www.shrm.org/certification">www.shrm.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>
Online
No advanced preparation or prerequisites are required for this course.
<table width="100%" border="0" cellspacing="0" cellpadding="5"><tbody><tr><td><img src="https://www.illumeo.com/lpfiles/hrci_ap_preapprovedseal_2016_150x.png" width="80" height="80" alt="pre-approved by HRCI" /></td><td align="left" valign="middle"><span style="font-size:10px;font-weight:normal">This activity, <span style="font-size:12px; font-weight:bold;">ID No. <!-- ONLY THIS PART CHANGES -->000000<!-- // --></span> has been approved for <!-- ONLY THIS PART CHANGES -->1.0<!-- // --> <!-- ONLY THIS PART CHANGES -->HR (General)<!-- // --> recertification credit hours toward aPHR™, PHR®, PHRca®, SPHR®, GPHR®, PHRi™ and SPHRi™ recertification through HR Certification Institute® (HRCI®). Please make note of the activity ID number on your recertification application form. For more information about certification or recertification, please visit the HR Certification Institute website at <a href="https://www.hrci.org">www.hrci.org</a>. </span></td></tr></tbody></table>