Business Intelligence Featuring Microsoft’s Power BI Tools
Information Technology
8 CPE Credits
Major Topics
Learning Objectives
- 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 be useful in BI applications
- Differentiate between the BI opportunities in Excel and Power BI
- Create and distribute dashboards using Power BI
Course Description
In today’s business climate, Business Intelligence (BI) is perhaps the hottest topic in most professional circles. Increasingly, organizations of all sizes are seeking to take advantage of the data that is 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 – ranging 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.
In this program, you will learn how to implement “do it yourself business intelligence” using a variety of techniques and tools. You will learn how to work with some of the advanced data query and summarization features in Excel to create Excel-based dashboards and then you will learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining greater insights into your data to make better decisions is of interest to you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Compliance Information
Advanced Preparation
None
Field of Study
Information Technology
Credits
8 Credits
Published Date
April 18, 2023
Course Authors
K2 Enterprises
K2’s goal is to produce and deliver the highest quality technology seminars and conferences available to business professionals. We work cooperatively with professional organizations (such as state CPA societies and associations of Chartered Accountants) and vendors of technology products. K2 also provides consulting services and advice on technology.
We make every effort to maintain a high level of integrity, family values, and friendship among all involved.
Overview
In today’s business climate, Business Intelligence (BI) is perhaps the hottest topic in most professional circles. Increasingly, organizations of all sizes are seeking to take advantage of the data that is 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 – ranging 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.
In this program, you will learn how to implement “do it yourself business intelligence” using a variety of techniques and tools. You will learn how to work with some of the advanced data query and summarization features in Excel to create Excel-based dashboards and then you will learn how to leverage that knowledge to build even more powerful BI objects using Microsoft’s Power BI tools. If gaining greater insights into your data to make better decisions is of interest to you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.
Course Details
- 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 be useful in BI applications
- Differentiate between the BI opportunities in Excel and Power BI
- Create and distribute dashboards using Power BI
Intended Audience —
Advanced Preparation — None
Field of Study — Information Technology
Credits — 8 Credits
IRS Program Number –
Published Date – April 18, 2023
Revision Date –
Course Authors
K2 Enterprises
K2’s goal is to produce and deliver the highest quality technology seminars and conferences available to business professionals. We work cooperatively with professional organizations (such as state CPA societies and associations of Chartered Accountants) and vendors of technology products. K2 also provides consulting services and advice on technology.
We make every effort to maintain a high level of integrity, family values, and friendship among all involved.
All of our self-study courses are NASBA approved (through our partners at K2 Enterprises) the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).
Your Registration Includes:
- ✓ Course materials (video & PDF version)
- ✓ Unlimited attempts to complete exam
- ✓ Course materials (PDF & Sample Materials)
- ✓ Instant grading & certificate of completion
- ✓ One year access to complete your CPE
- ✓ Completion certificate