
K2's BI Add-ins - Self-Service Business Analytics on the Desktop - On Demand (2 CPD Hours)
Course Description
Microsoft has created two parallel environments for delivering business intelligence reports and dashboards. One uses Excel and the four premium data-analysis add-ins (Power Pivot, Power View, 3D Maps, and Power Query). The other environment uses the cloud-based tools of Power BI and Power BI Desktop to create dashboards without Excel. Both environments allow business professionals to create user-interactive tabular reports and dashboards using quick and easy drag-and-drop processes. Don't miss this opportunity to see and evaluate the Excel-based environment for producing business intelligence reports, analysis, and dashboards.
Main Topics
- Comparing the two BI environments
- Understanding the add-ins required to use BI functionality in Excel
- Using the Excel BI add-ins to produce financial and operational analysis
- Comparing the two BI environments
Learning Objectives
Upon completing this course, you should be able to:
- Identify the desktop applications, server components, and Office 365 subscriptions for producing and delivering analytics
- Describe the process of accessing external data for analysis
- Use Power Pivot, Power View, and Power Map to produce user-interactive analysis
- Explain how to use Power Query to find, clean, transform, and merge data from multiple sources
Course Information
-
CPD credit: Recommended for 4 CPD hours Computer Software and Applications
-
Prerequisites: Good working knowledge of Excel and PivotTables
- Program level: Advanced
- Advance preparation: None
-
Who should participate: Accountants and business professionals who want to harness the power of business intelligence functionality using the premium Excel add-ins.
Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.