K2's BI Add-ins - Self-Service Business Analytics on the Desktop - On Demand (2 CPD Hours)

K2's BI Add-ins - Self-Service Business Analytics on the Desktop - On Demand (2 CPD Hours)

  • $129.00

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.