Platform: Intellipaat. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. It is part of Microsoft SQL Server and helps perform analysis using various dimensions. These tools and capabilities include interactive dashboards, scorecards, ad hoc queries, automated report distribution. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. PMML supports a number of different data mining algorithms, including Regression, Neural Networks, Clustering, Decision Trees and Association. All 3 types of objects are pre-created. 65K. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Choose your MicroStrategy version: 2021. Functions Reference. When modeling a database inside MicroStrategy there are a few methods to try when mapping data. Explanation: MicroStrategy is a powerful data analytics and business intelligence tool that helps organizations to analyze large amounts of data and make informed business decisions. Overview of Data warehousing. The metric condition Current year in sample DB is also applied to calculate the data for the current year available in the MicroStrategy Tutorial data. Generally, you build a compound attribute when your logical data model reflects that a compound key relationship is present. Notice that the DB instance 'Tutorial Data' is used, as shown below:MicroStrategy Data Mining Services integrates seamlessly with these applications in the following ways: MicroStrategy is used as the source of data mining dataset. The MicroStrategy OLAP Services product lets MicroStrategy Desktop, Web, and Office users slice and dice data in reports without having to re-execute SQL against the data source. With MicroStrategy, business users look for patterns, trends, and exceptions and intuitively change their views of the data through simple slice-and-dice analysis. Regression analysis using data mining functions is described in. Data Wrangling. 6. Initially, it was Google Big Table, afterward; it was renamed as HBase and is primarily written in Java. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. 4. Right click on the metric in Editor tab and select Edit Threshold. A logical data model represents the definition, characteristics, and relationships of data in a technical, conceptual, or business environment. g. g. Microstrategy office. To view the structure of the MicroStrategy Tutorial. Within each hierarchy, the directLogical data model represents the flow of data in an organization. It does not represent the physical data structure in the company. Answer: a) It enables organizations to make informed business decisions. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. Learn how to build powerful and insightful Dossiers in MicroStrategy with the tutorials below. DATA SCIENTIST RESOURCES & TUTORIALS. The actual model building is a simple 2-lines code using auto. There are two approaches to modeling in MicroStrategy: Create project models from MicroStrategy Developer Create ad hoc models from MicroStrategy Web Architect Interface in MicroStrategy Developer Connect to a database instance and drag tables onto the canvas. In the Actions column, select the Edit icon for the user to modify. To view the MicroStrategy Tutorial data model using Architect. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. The MicroStrategy Tutorial is an interactive product demonstration designed to showcase the rich functionality of MicroStrategy ONE. Metric - MicroStrategy. Click the MicroStrategy icon, and select Create Document. Author: Intellipaat. Gain knowledge on concepts of data warehousing, MicroStrategy analytics, and desktop objects. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43 MicroStrategy Tutorial. PMML supports a number of different data. It is a. You combine data in the logical layer. It provides a way of organizing facts so that they can be analyzed from different business perspectives. Properly designed database are easy to maintain, improves data consistency and are cost effective in terms of disk storage space. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Some Data Modeling tools support this concept, where you can decide if. PMML is an XML standard that represents data mining models developed and trained by data mining tool. 013 Developer (DVL) 2 2022. Data mining generally refers to examining a large amount of data to extract valuable information. For more information on what a logical data model is and how to create one, see The Logical. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. MicroStrategy Tutorial. Python coding is short, minimal and easy. This model is typically created by business stakeholders and data architects. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. 4. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. Check Query DetailsThe process of creating a model for the storage of data in a database is termed as data modeling. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. When the MicroStrategy Developer 9. 500% salary hike received by a working professional post completion of the course*. For information on connecting to databases, see Connect to Databases. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. Basic. Gateways and Connectors. The general procedure is as follows: Create a training metric to define how to analyze the existing data. In warehouse partition mapping, a table in the warehouse associates attribute elements with the table names of the individual partitions. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. A document or dashboard can contain data from one or more MicroStrategy reports. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. You will arrive at the MicroStrategy Tutorial Home page. Adding Filters (Page level and Global) Adding Links, text and images. Business users move seamlessly between all five styles of BI and even combine multiple styles. Column data descriptions and identifiers: Attribute forms. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. Star Schema in data warehouse, is a schema in which the center of the star can have one fact table and a number of associated dimension tables. A logical table is created for each physical table that is imported into a project, using the Warehouse Catalog. MicroStrategy Project Design Guide. Click OK. Click "Ok" and enter the credentials to connect to the database. It also allows for different modeling notations and can be extended by using LUA a scripting language. Well-coordinated with the ETL team and data modeling team to build reporting database according to our requirements. For example, most databases cannot join a data type of Text to a data type. Gather information about your MicroStrategy project. For more information about the Tutorial, refer to the Basic Reporting Help. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. From the list of document templates, click Blank Document. This tutorial steps through how to switch to Free-form Layout within a Dossier. Switch from Developer to the modern Workstation to empower your architects with a one-stop shop for all things MicroStrategy. Business Analysis is the key figure in understanding business requirements and their implementation. x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. Open a grid report. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. The dimensional model is included for backward compatibility with MicroStrategy 6. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. Section:2. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze internal and external data in order to make business decisions and to develop mobile apps. Microstrategy Tutorial. Right-click the Customer attribute and select New Attribute form. Hyperion Essbase, Microsoft Analysis Services, and other data sources. If you are not already using the MicroStrategy Tutorial, log in to the project source containing the MicroStrategy Tutorial and expand the MicroStrategy Tutorial project. Projects generally also contain other. The MicroStrategy Tutorial, MicroStrategy’s. Click Save. It can connect to data warehouses, relational systems, flat files,. This business analyst tutorial for beginners is designed to help you understand Business Analysis right from Software Engineering Methods & Lifecycles to Requirements Preparation, analysis, and presentation. It is particularly relevant when exporting metadata to a target tool which supports two views of the model: a logical view and a physical view. 2 In the Tutorial project, click the MicroStrategy icon and select Shared Reports. Visit the MicroStrategy download site to download the latest supported version of this product. This will launch the "Select Data Source" window. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. The model is automatically embedded in a new predictive metric. MicroStrategy Tutorial. Azure Machine Learning is a cloud predictive analytics service that makes it possible to quickly create and deploy predictive models as analytics solutions. On the Freeform Sources tab, select Create Query Builder report. In MicroStrategy Web, log in to the Tutorial project. Clean and Transform data. MicroStrategy Project Design Guide. The Data Mining Services can be used by business users, report designers and analysts to view and build predictive reports and distribute these reports to users on any device. MicroStrategy Data Mining Services allows organizations to use predictive functions that are natively available within MicroStrategy, or import models from third-party data mining vendors. EN. MicroStrategy is a powerful Business Intelligence and Visualization software. MicroStrategy Project Design Guide. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. Build a new plugin or update an existing Teams message extension or Power Platform connector to increase users' productivity across daily tasks and workflows. •. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. You will be able to: - connect to MicroStrategy Server. Data modeling is a process of formulating data in an. It provides a way of organizing facts so that they can be analyzed from different business perspectives. Create the respective DSN's in the Intelligence Server machines. Learn how to import and export all the dataframes. Creating a filter based on business attribute forms. Advanced Metrics, explains level metrics, conditional metrics, transformation. In a data warehouse environment, data only comes to have value to end-users when it is. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the report results. This ensures that the report can be executed in a reasonable amount of time, while also providing enough data to provide relevant market basket analysis of the order information. Useful Functions: Next Topics » Creating A Dataset Report: Creating A Predictive Model: Importing The. A detailed explanation of each method for. After user upgraded the project to MicroStrategy 10. You need to compare the number of units sold today to the number of units sold from January 1 through today. Open the table menu and click “Define Relationships”. Predictive modeling is useful because it gives accurate insight into any question and allows users to create forecasts. Hierarchies define the flow of relationships between attributes in a logical data model. From Enterprise Manager to Configuration Wizard to Architect, find anything and everything you need to know about our Tools in this section. Enhancing enterprise analysis with data science. so you can still create and execute reports, but cannot run the documents/dashboards. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. When creating the attributes for your project, rename each attribute to match the names in the logical data model. Every attribute must have an ID form (identity. In the Public Objects folder, select Metrics. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. You can support data internationalization in your database by using separate tables and columns to store your translated data. project_name ¶ Name of the connected MicroStrategy Project. In the Metrics folder, open the Sales Metrics folder. A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy. Method 1: The following steps assume that in the data warehouse, the lookup table used for the attribute in question contains a column whose data type is text which defines the link to be used as a hyperlink or uniform resource locator (URL). 3 Expand Subject Areas, expand Sales and Profitability Analysis, and then click Category Sales Report to run the report and see the sample data results. Microstrategy Dossier creation. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. The REST API is designed to help developers build data-driven client applications quickly. On the Freeform Sources tab, select Create Freeform SQL report. Oracle. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. Powering. It aids in AI-assisted data exploration, automates dossier design processes, and offers tools like SQL generation and ML-based visualization methods. 1) • Support extended through June 30, 2019. Attribute forms are identifiers or descriptors of an attribute, as explained in Logical data modeling conventions. EN. 02:18. 4 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the softwareWhat is the MicroStrategy Tutorial? The MicroStrategy Tutorial is a MicroStrategy 7 i project (metadata and warehouse are included) and a set of demonstration applications designed to illustrate the rich functionality of the MicroStrategy 7 i platform. Click User Manager . Undo and redo the wrangling operations that are done on a dataset. Predictive analytics, also known as predictive analysis or predictive modeling, is the use of statistical techniques to create models that can predict future or unknown events. Using Database Views Many practical MicroStrategy-Teradata implementations do use a set of database views on top of the physical tables in Teradata. 1. Select a security filter from the Available list and click > to assign it to the user or group. With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better. - pull data out of it. The MicroStrategy metadata maintains a single list of available columns per table name. A typical project contains reports, filters to qualify the report data, metrics that calculate the data, attributes that provide context for the metric data, and mathematical functions. URL of the MicroStrategy REST API server. The retail store sells electronics, books, movies, and music. By default, the data type for a fact is inherited from the data type of the column on which the fact is defined in the data warehouse. MicroStrategy is one of the most widely used business intelligence and data analytics platforms in the world. ssl_verify ¶ If True (default), verifies the server’s SSL certificates with each request. To filter data based on business attribute formsA good reference document is the Teradata white paper Data Model Overview: Modeling for the Enterprise While Serving the Individual. AngularJS is probably one of the most popular modern-day web frameworks available today. Empower end users to easily compare and measure the performance of metrics in an intuitive way with the new multi-metric KPI visualizations. For more information on how MicroStrategy can access your data sources, see. MicroStrategy enables data scientists to import MicroStrategy data into RStudio and Jupyter Notebook. A layer is similar to a legend item on a paper map. Bypassing the login page by providing credentials in the URL. Watch on. 4. One is known as a transaction data model setup. 2. a governed, scalable, and uniquely adaptable data model that unifies and fuels your. It provides a unified environment for creating and. The report 2 -- Movie Basket Analysis Training, available with the MicroStrategy Tutorial project, includes a filter that prompts the user for which orders to return. Controlling Access to the Database: Connection Mappings. 7. And, because it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. These physical tables are referenced in the SQL. 55. The data types of columns used in a heterogeneous mapping for a given attribute must be identical or similar enough for your particular RDBMS to join them properly. The Tutorial is a sample data warehouse and demonstration project you can use to learn about the various features of the MicroStrategy platform. MicroStrategy is an enterprise BI application software. We’re here to help you align the future of AI/BI technology with your company vision. EN. If the call is successful, the resulting HTTP response returns an HTTP. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. Begin or complete a degree; fully online. It is designed to help developers build data-driven client applications quickly and easily. Use the data warehouse physical schema in Appendix B for assistance. Type the Name for the object and click OK to save your changes. 12K. MicroStrategy provides its users a powerful set of tools that make it easy to develop custom enterprise assets. MicroStrategy provides business intelligence solutions to enterprise companies. Metrics are MicroStrategy objects that represent business measures and key performance indicators. Second section is on MicroStrategy Desktop and the last part will be on MicroStrategy Web. 7/24/2019 microstrategy_2. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. 6. MicroStrategy’s OLAP functions allow business users to understand and predict business events without being trained on analytic techniques. Connect your apps to Copilot. This guide is organized into the following sections: • Chapter 1, Getting Started with MicroStrategy Desktop introduces MicroStrategy Desktop. MicroStrategy Tutorial. Choose your MicroStrategy version: 2021. Physical Data Model is the default schema in Erwin format that can be used to generate scripts for creating tables and/or as an initial design for a new data warehouse. Documents and dashboards allow you to display your business data in a user. For example, you could create qualifications for six months ago and for 8 months ago. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. This type of logical table maps directly to physical tables in the data warehouse. What is a smart metric in MicroStrategy? Ans: Smart metric allows the user to change the default evaluation order of the metric. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. MicroStrategy’s ability to build a modeled schema has historically been the standard for ensuring a single version of truth across the enterprise. A logical data model represents the definitions, characteristics, and relationships of data across an enterprise environment in business terms that any user can understand. Every attribute must have at least one form, and most have at least two: •. Power View: This component allows you to visualize, analyze, and display data. MicroStrategy’s gateways span more than 99% of the data ecosystem your organization has, and MicroStrategy is always committed to expanding these gateways to meet—or exceed— your enterprise data needs. Build your first plugin. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. The data model has two layers: The default view that you first see in the Data Source page canvas is the logical layer of the data source. Some of the main features offered by MicroStrategy are Advanced. For example, a simple logical data model for a retail company can organize all necessary facts by store. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Source systems for data collection. Build a map-enabled report In this topic. If the call is successful, the resulting HTTP response returns an HTTP. For this, it uses a relational OLAP architecture. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Taking advantage of the online resources, tutorials, and support services. The retail store sells electronics, books, movies, and music. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. For example, in the MicroStrategy Tutorial, the ID form of the attribute Day contains two expressions. MicroStrategy comes with a sample project called MicroStrategy Tutorial. This metric definition is shown below:Custom expressions are written so that data can be tested against them, and whatever data qualifies as true when it is inserted into the custom expression is returned in the data result set. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. The modeling tool allows architects to transform a complex enterprise data environment into a unified. On expanding the button, the following screen opens showing different public. It is one of the best data modeling tools that helps you to create the actual database from the physical model. Professional Summary. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. 11771 views | June 22, 2020 05:24. x-10. This template uses a single. This issue has been addressed in MicroStrategy 2021. MicroStrategy Tutorial • The theme of the MicroStrategy Tutorial project is a retail store for the time 2009 to 2012 that sells electronics, books, movies and music. MicroStrategy describes its core reporting. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. What you'll learn. iv. This chapter describes one of the major components of data modeling: the logical data model. x, "Use relational model" is selected by default. Administrator. , when Year level fact table is available and can be. 63K KB34000: "QueryEngine encountered error: Execute Query Failed. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. 1 Follow the steps above to log in to MicroStrategy Web. Frequently Asked Questions: Teradata Parallel Transporter In MicroStrategy. Or it can be more complex, with multiple tables that use different combinations of relationships, joins, and unions. Importing data in Microstrategy Dossier. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. The tutorial is. Data Warehouse Tutorial Summary. Description: This Intellipaat MicroStrategy certification training course is meant for an in-depth understanding of the MicroStrategy platform, its architecture, the significance of business intelligence, etc. Reporting remains consistently accurate in OLAP servers as the speed of data sharing does not impede the process. In MicroStrategy Developer, from the File menu, point to New, and then select Intelligent Cube. Every attribute must have an ID form (identity. It offers a wide range of analytical capabilities. This framework has been developed by a group of developers from Google. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. For details on general project design and data modeling, see the Project Design Guide. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both MicroStrategy Developer and Web. The example after the procedure shows what happens to report data when the filter is used on a report. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. offset is the start point of your response. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. If you are working with your own data, rather than Tutorial data, the current date calculation works if the project contains data for the current date. Open Workstation in smart mode. In this table, the PARENT_ID column logically points to another row in the same table (ID column). However, with the rise of ad-hoc and self-service analytics, data. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. x. The best practices are grouped into the following sections: •. •. It is known as star schema as its structure resembles a star. In MicroStrategy Desktop, log in to a project. Number of Views10. It offers multiple import/export options, enhancing data literacy and agile application development. Even without coding skills. Architect your schema based on enterprise business needs to. The primary and default DB instance(s) of the project is/are not added to the package as the object dependencies in MicroStrategy Object Manager 9. Interested in becoming a certified MicroStrategy Developer, but unsure how to get started? In this video, Senior Education Developer Nima Soleimani walks through how our detailed learning path empowers Developers to apply fundamental software development skills, coding language basics for HTML and CSS, and the MicroStrategy. project_id ¶ Id of the connected MicroStrategy Project. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. 01:06. The purpose is to organize, scope, and define business concepts and rules. Copy and past all the cube files included with the Tutorial Data download from the prerequisites section (in a folder called 'Cubes'). Double-click the CUST_LAST_NAME column to add it to the Form expression pane on the right. 213 SDK for Customizing Analytical Applications 2022. Library of Analytics Functions It has an extensive library of over 300 OLAP, mathematical, financial, and data mining MicroStrategy Tutorial schema. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. From the list of document templates, click Blank Document. MicroStrategy Delivery Engine, MicroStrategy 구독 포털, MicroStrategy Tutorial – Delivery Installation 및 MicroStrategy Tutorial – Delivery Configuration을 사용하려면 MicroStrategy Narrowcast Administrator와. Security model: Use 7. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. If you are not already using the MicroStrategy Tutorial, log in to the project source containing the MicroStrategy Tutorial and expand the MicroStrategy Tutorial project. Number of Views 9. Clean and Transform data. The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as follows: 1. MicroStrategy OAuth 2. login_mode ¶ Authentication mode. 1x security model:. Data mining examples included in the MicroStrategy Tutorial project, in \Public Objects\Reports\MicroStrategy Platform Capabilities\MicroStrategy Data Mining Services In addition, this section describes the process of how to create and use predictive models with MicroStrategy and provides a business case for illustration. arima will take care of the optimum parameter values, you just need to specify a few boolean parameters. The Tutorial project includes sample data, such as actual customer names and items purchased. Section:1. It is also known as Star Join Schema and is optimized for querying. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. We're sorry. - modify the data a little bit. to open the Shared Reports folder of the. Following are the three report types used in MicroStrategy Desktop. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. Twenty-seventh Edition, version 9. This is different from the physical data model or warehouse schema, which arranges data for efficient database use.