K2’s Business Intelligence, Featuring Microsoft’s Power BI Tools
Accounting
8 CPE Credits

Major Topics
- The importance of Business Intelligence in today’s business climate
- Differentiating between Power BI licensing options
- A hands-on approach to creating effective Power BI reports and dashboards
Learning Objectives
- Create and distribute dashboards using Power BI
- Create Excel-based BI dashboards
- List the potential shortcomings of BI solutions based wholly on Excel
- Identify and implement various Excel add-ins that might useful in BI applications
- Differentiate between the BI opportunities in Excel and Power BI
Description
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently.
This program will teach you to implement “do-it-yourself business intelligence” using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Compliance Information
Overview
Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today’s business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently.
This program will teach you to implement “do-it-yourself business intelligence” using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Course Details
- Fraud in small business environments
- Internal control options in small business accounting software
- Understanding the need for application controls and general controls
- Common challenges associated with implementing appropriate internal controls in small business environments
- Cite internal control fundamentals, including definitions and concepts, types of internal control activities, and the need for internal controls
- Identify common small business control deficiencies and issues, including concentration of ownership and inadequate segregation of duties, and list five key risk areas for small businesses
- Recognize the common types of fraud schemes occurring in small businesses and implement internal control measures to reduce the threat of becoming a victim
- List the objectives and common deficiencies of small business accounting systems
- Define the purpose of general controls and list examples of typical control techniques in small businesses
- Implement technology tools to prevent and detect occupational fraud
- List opportunities to enhance security over information systems and sensitive data
Intended Audience — Business professionals responsible for internal control and fraud prevention and detection
Advanced Preparation — None
Field of Study — Auditing
Credits — 8 Credits
IRS Program Number –
Published Date – November 2, 2022
Revision Date –