Module 1: Business Intelligence for Information Workers

Lessons

• Business Intelligence
• Business Intelligence Overview

Module 2: Financial Reporting

Lessons

• Analyzing the Chart of Accounts
• Demonstration: Review G/L Account Balances
• Demonstration: Review G/L Balances
• Demonstration: Review G/L Balances by Dimension
• Demonstration: Review G/L Account Balances and Budgets
• Demonstration: Review G/L Balances and Budgets
• Account Schedules
• Demonstration: Set up an Account Schedule
• Demonstration: Print Account Schedule Reports
• Demonstration: Export Account Schedules to Excel
• Demonstration: Filter Account Schedules Using Dimensions

Lab: Create a Detailed Account Schedule

After completing this chapter, students will be able to:

Module 3: XBRL

Lessons

• XBRL Terminology
• XBRL Specifications and Taxonomies
• Demonstration: Import a Taxonomy
• Demonstration: Update a TaxonomyWorking with Linkbases
• Demonstration: Attach a Linkbase
• Demonstration: Update a Linkbase
• Demonstration: Add a New Label Linkbase
• Demonstration: Apply a LinkbaseEntering XBRL Line Definitions
• Demonstration: Map the Taxonomy to the Chart of Accounts
• Demonstration: Copy XBRL SetupExporting the XBRL Lines

Lab: Stock Exchange Reporting with XBRL

After completing this chapter, students will be able to:

Module 4: Financial Analysis

Lessons

• View Posted Dimension Information
• Demonstration: View Dimensions on Posted EntriesAnalyze Financial Information Using Dimensions
• Demonstration: Create Analysis Views
• Demonstration: Add Dimension Value Filters
• Dimension Based Reports
• Demonstration: Generate the Dimensions - Total Report
• Demonstration: Generate the Dimensions - Detail Report
• Demonstration: Combine Analysis Views with Account Schedules

After completing this chapter, students will be able to:

Module 5: Business Analytics

Lessons

• Data Warehouse
• Setting up the Microsoft Dynamics NAV Configurator
• Demonstration: Set up a New Cube
• Setting up BA Databases
• Demonstration: Set up BA Databases
• Demonstration: Schedule the Configurator to Run Automatically
• Additional Business Analytics Task Demonstration: Set up a Virtual Cube
• Demonstration: Map Existing Dimensions to a Cube

Lab: Create a New Cube

After completing this chapter, students will be able to:

Module 6: Analyze Microsoft Dynamics NAV 5.0 Data in Microsoft Excel

Lessons

• Export Analysis Views to Excel
• Demonstration: Export an Analysis View to Excel
• Work with Data in Excel
• Demonstration: Rename a Column and Add Bold Effects
• Demonstration: Add a Chart

After completing this chapter, students will be able to: