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 1 – Introduction to BI
Business Intelligence (BI):
Microsoft Dynamics AX 2012 provides a flexible pre-built business intelligence (BI) solution for mid-market organizations. The use of built-in content—including Role Centers, analytic reports, and analysis cubes—eliminates the need to build a solution from the ground up, and therefore saves time and money. The Microsoft Dynamics AX 2012 business intelligence solution can be configured and extended to suit your specific needs with the help of Microsoft Business Intelligence development tools.
The Microsoft Dynamics AX 2012 business intelligence solution consists of the following built-in features:
- Role Centers (dashboards). Thirty-two default home pages that pertain to the work needs of various user profiles in an organization.
- Analysis cubes. Eleven analysis cubes that address the analytic requirements of the major functional areas within Microsoft Dynamics AX 2012—including finance, supply chain, manufacturing, professional services, and business processes.
- Key Performance Indicators (KPIs). More than 60 of the most commonly used KPIs that help users evaluate the success of business activities.
- Analytic reports. More than 150 analytic reports that provide insight into business data.
The pre-built BI solution can be deployed when you implement Microsoft Dynamics AX 2012 in your organization. A new intuitive, wizard-driven interface guides the user through deployment of the solution without requiring the user to have expert business intelligence skills.
By deploying the pre-built business intelligence solution as you implement Microsoft Dynamics AX 2012, your organization can start using BI capabilities as soon as the new business functionality is operational.
Some Other Options For Business Intelligence with Dynamics AX:
Excel: Many businesses will begin by using the Dynamics AX 2012 R3 feature to export data to excel as a familiar and easy way of manipulating the data to suit their needs for a Cashflow Budgeting Model or Forecast Model, for example. A great thing about this is that it allows for data in their CRM or other systems to be mashed up with the Dynamics AX data to provide a better picture of their business.
Power Views: Dynamics AX also has embedded SQL Power Views that can be accessed from a button called Analyze data on your ribbon. This will allow you to understand hidden trends behind the data. This will open SQL Power View where the user is presented with an extended set of tables and fields for easier analysis.
Tableau and Dynamics AX: Tableau is a user-oriented dashboarding tool that is easy to use and has a great amount of user community support. Connecting to AX with Tableau and blending data together from other sources is a common practice for businesses. it allows for easy integration and connections between your CRM, financial, and other systems, which can provide you with the visibility to understand your business better.