9th October, 2020
MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. MicroStrategy describes its core reporting software as having a "ROLAP" or "Relational OLAP" architecture, meaning that a complex relational database can be expressed using a virtual multidimensional cube structure that can be more easily understood by business users who wish to navigate through the data.
Business intelligence (BI) refers to computer-based techniques used in spotting, digging-out, and analyzing business data, such as sales revenue by-products and/or departments, or by associated costs and incomes. BI technologies provide historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, business performance management, benchmarking, text mining, and predictive analytics.
Business intelligence aims to support better business decision-making. Thus a system can be called a decision support system (DSS).
Operational systems collect and store business data. These systems usually are databases or mainframes, and the data they store is typically limited to recent or current data.
Source systems refer to any system or file that captures or holds data of interest. A bank is an example of a business with many source systems. A source system is usually the most significant site of online transaction processing (OLTP).OLTP systems are databases or mainframes that store real-time processing data.
The extraction, transformation, and loading (ETL) process represents all the steps necessary to move data from different source systems to an integrated data warehouse.
The ETL process involves the following steps:
A well-designed and robust data warehouse is the source of data for the decision support system or business intelligence system. Data warehouses are usually based on relational databases or some form of relational database management system (RDBMS) platform. These relational databases can be queried directly with Structured Query Language (SQL), a language developed specifically to interact with RDBMS software. However, MicroStrategy does not require that data be stored in a relational database. You can integrate different types of data sources with MicroStrategy such as text files, Excel files, and MDX Cubes.
In combination with MicroStrategy tools and products, the data warehouse also provides the foundation for a robust online analytical processing (OLAP) system. Analytical processing involves activities such as choosing to see sales data by month and selecting the applicable metric to calculate sales trends, growth patterns, percent-to-total contributions, trend reporting, and profit analysis.
MicroStrategy designed and built its MicroStrategy platform from the ground up with the goal of easy Internet accessibility, rapid deployment, fast responses to report requests, and sophisticated analysis and reporting functionality.
The following diagram shows the rich set of business intelligence functionality that the MicroStrategy platform provides.
MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform that ensures the scalability and fault tolerance required for sophisticated analysis of terabyte databases and deployments to millions of users. MicroStrategy Intelligence Server is specifically optimized for all major relational databases and contains the load distribution, prioritization, and system tuning capabilities required for large-scale implementations. It also handles all communication with the relational data warehouse.
Report Services is an available extension to MicroStrategy Intelligence Server that delivers the most flexible report layout, with drag-and-drop simplicity, and provides comprehensive formatting capabilities to MicroStrategy Desktop users. OLAP Services is another available extension to MicroStrategy Intelligence Server that allows MicroStrategy Web and Desktop users to manipulate Intelligent CubesTM. An additional Intelligence Server option is clustering, which lets you join multiple individual servers together without any additional software or hardware components. Built-in failover support ensures that if a server experiences a hardware failure, the remaining MicroStrategy Intelligence Servers pick up the failed jobs.
MicroStrategy Desktop is the business intelligence software component that provides integrated query and reporting, powerful analytics, and decision support workflow of the personal computing desktop. It provides a wide variety of features for online analysis of data. Reports and documents are easy to create and can be viewed in various presentation formats, polished into production reports, distributed to other users, and extended through a host of ad hoc features including drilling, pivoting, and data slicing.
MicroStrategy Web is a powerful and user-friendly environment for interactive analysis. A full set of capabilities for data browsing, drilling, and reporting development enable stream-of-consciousness navigation.
MicroStrategy Office brings business intelligence to the Microsoft Office productivity suite. With simple, one-click access to corporate data, MicroStrategy Office users can run any report from within Excel, Word, or PowerPoint for visually pleasing reports in a familiar environment.
MicroStrategy Architect is a rapid development environment for business intelligence systems. The information-mapping module separates underlying information structures from applications, providing flexibility.
MicroStrategy Object Manager allows you to easily migrate objects from one environment to another using drag-and-drop, copy/paste, and so on. Object Manager also includes a tool called Project Merge that lets you perform bulk object copying.
MicroStrategy Enterprise Manager lets administrators monitor system and reports usage, which in turn allows them to develop tuning strategies that can maximize performance.
MicroStrategy Command Manager provides the ability to create text-based scripts and automate common administrative functionality. These text-based scripts can also run from the command line and are therefore available from inside third-party applications. MicroStrategy comes with hundreds of default text scripts.
MicroStrategy SDK creates an open architecture that enables developers to integrate, extend, and fully exploit the power of the MicroStrategy platform through a set of rich APIs that fully expose all platform functionality.
MicroStrategy metadata is a repository that stores MicroStrategy object definitions and information about your data warehouse. The information is stored in a proprietary format within a relational database. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. The metadata also stores the definitions of all objects created with MicroStrategy Desktop and Web such as templates, reports, metrics, facts, and soon
A project source is a configuration object which represents a connection to a metadata repository. In MicroStrategy Desktop, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. A connection to a metadata repository is achieved in one of two ways:
Direct or two-tier mode: Connects to the metadata by specifying a DSN, login, and password to a metadata repository
Server or three-tier mode: Connects to the metadata by pointing to an Intelligence Server definition, which in turn governs and validates the connection to the metadata. The project metadata is the first tier, MicroStrategy Desktop is the second tier, and Intelligence Server is the third tier. Intelligence Server manages all connections to databases, enforces security, and ensures metadata integrity. For these reasons, the Intelligence Server is a necessary part of any production project.
The following diagram illustrates Server connectivity between a MicroStrategy metadata repository, Intelligence Server, and MicroStrategy Desktop. This is the type of connection used to create a production-ready project in MicroStrategy.
A project is where the report and document designers locate objects to use on the report or document they are designing, and where they save the completed report/document for analysts to access. A project holds all of the objects your organization develops which need to work together now or in the future, to develop the reports/documents you need for effective business intelligence.
Projects are listed in Desktop’s Folder List, which is displayed on the left as shown in the image below. In MicroStrategy Web, projects are listed on the Projects page when you first open Web, or immediately after you log in, depending on how Web is configured
The project can be created from Project Builder or Project Creation Assistant. Below are the differences between these two.
The warehouse tables for a project determines the set of data available to be analyzed in the project. You use the Warehouse Catalog to add warehouse tables to your project. The Warehouse Catalog lists all the tables in the data source to which you are connected through your database instance and to which your database login has read privileges.
The creation of facts and attributes will be discussed later in this chapter.
MicroStrategy Narrowcast Server is an information delivery platform. Due to its open modular architecture, the Narrowcast Server can acquire reports from MicroStrategy projects, as well as other information sources, and deliver messages via e-mail and other delivery methods. Also, MicroStrategy Narrowcast Server Subscription Portal allows users to subscribe to Narrowcast Server services using a Web browser.
Service is the fundamental tool that you use to deliver information using Narrowcast Server. A service defines some set of information that should be delivered, how this information should be delivered, a set of users who want to receive this information, and the schedule on which they would like to receive it.
The Service Wizard is the recommended way to create services.
Services can be delivered by one or more means such as via e-mail, to wireless devices, to the Subscription Portal, via voice, and so forth. Each means of delivering a message is called a delivery method. The name of each information transmitter is listed in the Delivery Methods section of the Service Wizard. By default, Narrowcast Server provides e-mail, wireless, print, file, SMS, and Web information transmitters. As a result, these options appear on the Service Wizard’s Delivery Methods page.
Each delivery method is supported by a single publication, which specifies the content to be delivered. It is the information transmitter for a publication that specifies which content sections the publication provides to the application designer and which types of content each section can accept.
For example, the E-mail (SMTP) information transmitter informs publications for the E-mail (SMTP) delivery method that a message subject, message body, and a section for attachments should be provided.
A schedule sets the times or frequencies a service is executed and represents a recurrence pattern, not a fixed date on which to send the service.
MicroStrategy Narrowcast Server uses the following objects to answer these questions:
The true power of Narrowcast Server comes from content that is determined at service execution time and can vary from recipient to recipient or from execution to execution. This type of content is called dynamic content. Like static content, dynamic content is added to documents, but dynamic content may be personalized so that each recipient receives information that is relevant for him.
Narrowcast Server uses Information Objects to retrieve dynamic content from external sources such as MicroStrategy projects, database queries, or external systems.
An information object is a set of instructions specifying how to get data from an external information source.
Information objects can serve three roles in Narrowcast Server:
Narrowcast Server also provides the ability to insert information about message recipients into service content. This capability allows you to personalize messages using user information and create message content such as “Dear Mr. Smith,” or include any other user-related information such as title, state, or zip code.
The following user information is available by default in Narrowcast Server:
Our course design of tutorials is practical and informative. At TekSlate, we offer resources to help you learn various IT courses. We avail of both written material and demo video tutorials. For in-depth knowledge and practical experience explore Online MicroStrategy Training.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us