80050: Business Intelligence for Information Workers in Microsoft Dynamics NAV 2009
Introduction
This one-day course, Business Intelligence for Information Workers in Microsoft Dynamics NAV 2009, provides students with the information and tools to efficiently access their business data without a lot of complex setup and staging. Therefore, this course focuses on internal reporting and analysis functionality, in addition to the means for sharing data outside of the Microsoft Dynamics NAV environment, either through XBRL—a language for tagging financial data—or by exporting data to Microsoft Office Excel 2007. This course also provides an introduction to Business Analytics.
Audience
At Course Completion
- Explain business intelligence concepts.
- Filter and access analysis pages in the Chart of Accounts.
- Set up Account Schedules.
- Explain terminology associated with XBRL.
- Import and update taxonomies.
- Attach, update, and apply linkbases to taxonomies.
- Enter XBRL line definitions.
- Export XBRL lines.
- Enter dimensions in journals and documents.
- View posted dimension information.
- Set up analysis views.
- Generate and print dimension analysis reports.
- Describe Business Analytics and related terminology.
- Describe the data warehouse and the elements of the data warehouse.
- Set up a Business Analytics database and cube.
- Set up virtual cubes and map existing dimensions to a cube.
- Export analysis views to Office Excel 2007 and describe the elements of the exported file.
- Work with analysis data that has been imported into Office Excel 2007.
- Connect a Microsoft Dynamics NAV database to Office Excel 2007.
Prerequisites
- Successful completion of Course 80043: Introduction to Microsoft Dynamics NAV 2009
- General knowledge of basic ERP user roles
- Basic knowledge of financial analysis needs
Microsoft Certified Professional Exams
No Microsoft Certified Professional exams are associated with this course currently.
Course Outline
Module 1: Overview and Financial Reporting This module provides an overview of Business Intelligence and describes how to generate reports out of the Chart of Accounts—from determining the data to include in the reports, to designing the layout.Lessons
After completing this module, students will be able to:
This module provides definitions of XBRL terminology and then explains the setup and processing needed to implement data in XBRL, including importing taxonomies, attaching linkbases, entering line definitions, and exporting XBRL lines.
Lessons
After completing this module, students will be able to:
Module 3: Financial Analysis This module describes types of dimensions in Microsoft Dynamics NAV, how to analyze data using dimensions, and how to create a report based on dimensions.Lessons
After completing this module, students will be able to:
Module 4: Business Analytics This module is designed to give information workers ready access to basic analysis and reporting capabilities. Concepts relating to any data mining software, including Microsoft SQL Server Analysis Services, are introduced and data cubes are created.Lessons
After completing this module, students will be able to:
|
*E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.