Microsoft Business Scorecard

The Solution

The Microsoft Balanced Scorecard Framework provides a technology environment and an integrated set of tools your company can use to derive maximum value from its balanced scorecard solution. The framework is not a packaged application. Instead, it integrates a variety of Microsoft packaged applications and industry standards to automate a Balanced Scorecard. It consists of a set of tools and methods to help both business users and developers get to success faster and more reliably so software is no longer a hurdle to overcome in scorecard development, but an asset to speed development. Learn more about the Balanced Scorecard Framework.

The Microsoft business intelligence platform includes world-class data collection, data warehousing, and analytical processing technologies, which enable flexible, balanced scorecard automation. With intuitive, familiar desktop tools and a flexible, open architecture that will meet your changing needs, these technologies provide the perfect operating environment for delivering your balanced scorecard solution.

Office XP technologies play a key role in bringing business scorecard solutions to the desktop. Knowledge workers can use Office XP analysis tools such as Microsoft Excel and Office Web Components to analyze and explore performance metrics in a familiar, easy-to-use environment. Microsoft SharePoint™ Portal Server provides powerful collaboration features and a personalized information portal.

Analytical and Presentation Tools

Your balanced scorecard solution must be woven into your organization's everyday operations, so employees can see whether they are meeting their goals. You can also use a balanced scorecard solution powered by Office XP to equip workers with tools that notify them of a potential problem, so they can react in time to keep your company running smoothly.

Well-presented performance metrics have a better chance of influencing a change in behavior. Excel and Office Web Components deliver visually rich charts, stop-light indicators, and graphs that integrate directly with users' desktops. These tools also make it easy for users to view and organize data so they can better understand the relationships among various business dimensions and uncover what drives performance indicators.

Collaborative Environment

Your business-strategy-focused teams can use the resources in SharePoint Portal Server to work together efficiently. SharePoint Portal Server provides search functionality, version control, workflow and/or approval management, and more, to assist you in managing the associated strategy and training materials. SharePoint also provides teams and workgroups with a personalized portal that helps individuals focus on the information that is most relevant to them.

Excel Analysis CubesMicrosoft® Business Solutions - Great Plains®

FOR FINANCIAL MANAGEMENT
  • Extend Great Plains capabilities across your company
  • Leveraging the power of SQL Server - the foundation for Microsoft Great
  • Plains Analysis CubesÑyou can put Microsoft Great Plains information on the desktops of everyone within your organization. Opening the flow of business information to your employees, empowers them to work more effectively with customers, trading partners, and each other.
  • Reduce administrative tasks
  • Automated report building and processing capabilities reduce the time employees spend on administrative work, giving them more time to analyze information, create Online Analytical
  • Processing (OLAP) queries, and make strategic decisions based on sound information.
  • Use OLAP cubes to quickly spot trends
  • Using OLAP cubes, you have the option to use the tool that best fi ts your budget, environment, and needs. You can quickly produce analytical views of sales trends, customer buying patterns, and other values you can use to answer key questions about your business.
  • Empower employees with better business intelligence
  • Microsoft Great Plains Analysis Cubes can be viewed in a familiar Excel environment; using the Microsoft Excel
  • Add-In for SQL Server Analysis Services, your employees can ramp up quickly, and perform advanced reporting and analysis, with less training.
  • Analysis Cubes for Microsoft Offi ce Excel Using Microsoft® Business Solutions-Great Plains® Analysis Cubes for Excel, you significantly improve your ability to analyze and report fi nancial data, and share information across your organization. Microsoft Great Plains Analysis
  • Cubes for Excel put everyone in your organization, from your CEO to your finance managers, from salespeople to warehouse staff, in touch with vital business information.

Building on the powerful Microsoft SQL Server™ database and the familiar Microsoft Office Excel interface, you can view the information you need in the format you prefer, analyzing data from multiple angles. Analysis Cubes for Excel help you unlock your organization's vital information.

ANALYZE TRENDS AND IMPROVE DECISION-MAKING PROCESSES by creating an Excel dashboard to display key Microsoft Great Plains information.

WITH THE EXCEL PIVOT TABLE GENERATOR, you can define the dimensions to analyze.

INFORMATION OBTAINED with Analysis Cubes can be viewed in familiar pivot tables in Microsoft Offi ce Excel.

Analysis Cubes for Microsoft Office Excel

Introducing

Business Intelligence Foundation Layer

Analysis Cubes for Excel are a key component of the new Microsoft Great Plains Professional-Business Intelligence Foundation Layer. This complete fi nancial foundation is designed to help businesses like yours that require deeper financial analysis. Equally important, you can track information flow throughout your company to empower better decision making. Coupled with Microsoft Business Portal Key Performance Indicators (KPIs) and Microsoft Office Solution Accelerator for Sarbanes-Oxley, the Business Intelligence Foundation Layer brings a rapid ROI, without a major investment in new training or technology.

Analysis Cubes for Excel

Microsoft Great Plains Analysis Cubes for Excel include Financial Series cubes such as General Ledger, Accounts Receivable, Accounts Payable, Receivables Aging, and Bank Reconciliation, so you can begin analyzing information immediately. Receive quick answers to common business concerns such as:

  • Sales analysis based on customer, sales territory, salesperson, or General Ledger account
  • Total purchases by vendor or account code
  • Financial statements and reports such as profi t and loss statements

Using the Excel Pivot Table Generator you can define how to 'slice and dice' information from Microsoft Great Plains, and this information will be instantly created in Excel for analysis.

The functionality in Analysis Cubes for Excel will allow you to deploy analysis cubes on your Great Plains server and will consolidate up to two companies for analysis and reporting.

Microsoft Business Portal KPIs

Quickly and easily create KPIs that defi ne metrics important to your company, such as sales comparisons by month, quarter, or year; or, the percentages of on-time deliveries. These powerful tools help you measure the success of your organization and send alerts of material changes that affect profitabilityÑempowering key decision-makers to take corrective action before hot spots turn into fi res.

Microsoft Offi ce Solution Accelerator for Sarbanes-Oxley

The Microsoft Office Solution Accelerator for Sarbanes-Oxley can assist organizations in developing the process controls they need to facilitate compliance initiatives related to Sections 302 and 404 of the Sarbanes-Oxley Act. Integration with Microsoft Business Portal can be used to share compliance procedures, documentation, and financial data with officers, increasing the transparency of financial information for your organization.

Add-ons to Analysis Cubes For Microsoft Office Excel

Available with Microsoft Dynamics GP:

Extend the Benefits of Analysis Cubes for Excel to Your Entire Organization

Analysis Cubes Library and Advanced Analysis Cubes Library, available as add-on modules within Microsoft Great Plains Professional, give you an even greater competitive advantage with sophisticated analysis tools. Both complement Analysis Cubes for Excel. Both tools are powerful but easy to use, giving you a deeper understanding of information generated from Microsoft Great Plains. Empower employees to spot new trends, respond faster to opportunities, create innovative solutions, and generate reports and analyses that identify strategic actions.

Corporate Planner

Integrated Planning, Analysis and Reporting Solution.

This fully integrated Tool offers a Transparent, Graphical view of the entire organisation, allowing complete control and understanding of all aspects of a business.

  • flexible planning and controlling system
  • integration of planning, information, analysis, controlling
  • can be used for financial planning, cost controlling, sales estimation, enterprise planning and much more
  • all planning tools are fully integrated
  • automatic data transfer from diverse accounting systems
  • used by hundreds of companies in all lines of business

Analysis Cubes Library

Microsoft Great Plains Analysis Cubes Library contains Distribution Series cubes for Sales Order Processing, Purchase Order Processing and Inventory and it's available as an additional module within Great Plains Professional. The information you analyze will help you answer questions important to your business success, such as:

  • Which vendors are providing the best prices on a particular item?
  • What is our margin percentage by item, by customer, or by salesperson?
  • What customers are buying more from us this year than last? Which ones are buying less?
  • What was our revenue for the week? Who was the top salesperson? Customer? Product?

For widespread adoption across your company, Analysis Cubes Library lets you view detailed transaction information in Excel. For example, with a few mouse clicks, you can view all the checks that have cleared the bank to date. You have the option of drilling to the detailed transaction level on almost all of the examples shown, so you can see a list of the transactions that make up a specific value.

The functionality in Analysis Cubes Library is available for one Great Plains server and up to two Great Plains companies.

Advanced Analysis Cubes Library

The capabilities of Microsoft Great Plains Advanced Analysis Cubes Library put no limits on the number of Great Plains companies and servers. Advanced Analysis Cubes Library supports businesses that have the most complex reporting and analysis needsÑsuch as enterprise-level organizations, or rapidly growing mid-market companiesÑwithout sacrificing the ease of use you expect from Microsoft Great Plains.

With Advanced Analysis Cubes Library, organizations can load analysis cubes on their own server, increasing scalability. You gain more accurate and timely insight into your business, and create an information-rich environment designed for quick and strategic decision-making.

Analysis Cubes for Microsoft Office Excel

FEATURES OVERVIEW

  • Build More
  • Interactive Reports
  • Collaborate More
  • Effectively Customize Report
  • Delivery
  • Sharpen Your Competitive Edge

GREAT PLAINS PROFESSIONAL GREAT PLAINS STANDARD AVAILABLE WITH:

Generate reports much faster than before, including company consolidations and multi-currency reporting.

Using familiar Microsoft tools you can share information across your whole company combining data from Microsoft Great Plains, Microsoft CRM, or legacy systems. Interact with other departments and communicate effectively with colleagues. Even your remote field workers or trading partners can access your information in the familiar Excel environment, without investing in your host technology.

Build customized report packages that include only the information that is relevant for each recipient.

Deliver the highest business intelligence to key decision-makers, and free them up to work at peak performance levels. Using sophisticated OLAP cubes for in-depth analysis, you can meet specific information needs for your business, gain a more holistic view of financial activities, and summarize data using multiple dimensions. Flexible and customizable, these tools are essential for making quick sense of large amounts of data, and helping your people do what they do best.

'With OLAP cubes you can look at data from several different angles, to frame the data just the way you need it. OLAP cubes help you see information in ways you've never been able to see it before.' he Excel Add-in for Analysis Services enables users to access and analyze data from multiple Analysis Services Cubes, and to create rich, customized reports directly in Microsoft Office Excel 2003 This download not only reduces the time and resources required to train users, but it also eliminates the need for organization's to support specialized reporting systems and tools. The key business benefits of Excel Add-in for Analysis Services include: Visibility in Excel into business trends Increased speed and quality of decision-making Streamlined data analysis that shortens reporting cycles and saves resources Increased reporting flexibility through rich, highly customized, and refreshable reports Access to relevant information from multiple data sources

Top of page