Chapter 1- Overview
Chapter 2 - SQL Server Reporting Services (SSRS)
- Lesson 1 – Report Data Sources
- Lesson 2 – Reporting architecture
- Lesson 3 – Native Mode Microsoft SharePoint Integrated Mode
- Lesson 4 – Report Development Tools and Process
- Lesson 5 – Deploying Reports and Working with Static Reports
- Lesson 6 – Report Parameters
- Lesson 7 – Creating and Using Style Templates
- Lesson 8 – Auto versus Precision Reports
- Lesson 9 – Integrating Data From Multiple Data Sources
- Lesson 10 – Creating a Drill Through Report
Chapter 3- SQL Server Analysis Services (SSAS)
Chapter 4 - Enterprise portal and Role Centers
Lesson 2 – Overview of BI Tools
BI tools in Microsoft Dynamics AX 2012:
Now that we are familiar with the core concepts, let’s briefly review the capabilities of the BI tools that are available in Microsoft Dynamics AX 2012.
Query tools: We have further grouped the query tools into two categories. Predefined queries are the most frequently used queries. They are defined once and consumed frequently, often by a group of users. Ad-hoc queries, on the other hand, are mostly situational. They are purpose-built as and when they are needed.
Reporting tools: Microsoft SQL Server Report Builder v3 with cubes – A business user can create robust, professional-quality reports with the data contained in Microsoft Dynamics AX 2012 cubes by using Microsoft SQL Server Report Builder v3. Report Builder leverages the power of SQL Server Reporting Services server for report processing and distribution. In addition to providing the capability to author professional-looking reports, these reports enable parameters and conditional
logic to be included in such a way that they can be consumed by a large population of users in the organization.
Analysis tools: Business Overview Web Part– A business user can pin pre-built KPIs and indicators to Role Centers by using the Business Overview Web Part. Microsoft Dynamics AX 2012 R2 provides the capability to add user-defined filters to existing KPI definitions in such a way that users can pin the same KPI to Role Centers by adding filters to reflect their area of interest.
As you saw in the previous section, Microsoft Dynamics AX 2012 ships with a powerful set of tools and options for providing BI capabilities to users. Although these tools are powerful, not all users need these capabilities. How do you choose the best tool for each role in an organization? Let’s examine how we can apply the role-based BI concept to limit the choice of tools for each role.
The following table indicates the BI patterns for each type of persona, along with a candidate list of BI
tools that can be used.