Share

Home > Products > User Interfaces: Office > MicroStrategy Office Overview

MicroStrategy Office™

Features | Benefits | FAQs

MicroStrategy Office lets every Microsoft® Office user run, edit and format any MicroStrategy report directly from within Microsoft applications such as Excel, PowerPoint® and Word. MicroStrategy Office is designed using Microsoft .NET technology and accesses the MicroStrategy business intelligence platform using XML and Web services.

MicroStrategy Office gives business users open and straightforward access to the full functionality of the MicroStrategy platform from familiar Microsoft Office applications. MicroStrategy Office serves as a Microsoft add-in, with MicroStrategy functionality expressed as a single tool bar in Microsoft.

Features At A Glance

  • Users can run, manipulate & create MicroStrategy BI reports from within Microsoft Office applications
  • Embedded MicroStrategy reports can be reformatted using Microsoft Office formatting tools
  • Reports inherit all native Microsoft Excel, PowerPoint & Word functionality
  • Web Services architecture is fully Microsoft.NET-compliant
  • Compatible with Microsoft Office 2000, XP & 2003
  • Detailed Features

  

Benefits At A Glance

  • Brings Business Intelligence to the whole enterprise
  • Create customized report books, presentations & documents
  • Use reports outside of Office
  • Quick & easy integration with existing applications of Microsoft Office
  • Securely share reporting with other Office users
  • Easy administration as part of the MicroStrategy Platform
  • Detailed Benefits

Product Highlights

Ad Hoc Reporting Through Microsoft Office

With MicroStrategy Office, users can select projects, run, save and refresh any type of report from the Microsoft Office program of their choice -- Excel, PowerPoint or Word -- with full security and prompting. MicroStrategy Office lets users organize frequently used reports and extend the data-driven capabilities of basic Excel grids.

 

Secure, Personalized, On-Demand Office Reports

MicroStrategy Office leverages the iron-clad security and the personalization of the MicroStrategy reporting platform. This means when any user runs a report, the content can be automatically personalized to all levels of detail from summary to transaction data.

 

 

Self-Service Report Design Using Only Excel Skills with No Metadata Impact

Users can create reports by answering simple and intuitive object prompts and thereby completely determine the structure and content of the resulting report. MicroStrategy Office also allows automatic prompt reuse and default prompt acceptance, allowing users to refresh reports quickly with the latest data with just one click.


Auto-Generated PowerPoint

Field Sales personnel need a quick way to reuse standard sales presentations, yet have them automatically change and be tailored throughout for each customer they plan to visit. With MicroStrategy Office the Sales User can simply refresh the report, choose a new customer name from the list of their customers and have all the enterprise data in the entire presentation be personalized for that specific customer.