MicroStrategy describes its core reporting. Build a map-enabled report In this topic. For details on general project design and data modeling, see the Project Design Guide. •. Chapter 1: Defining and analyzing data requirements: Data modeling Chapter 2: Developing and maintaining schema objects Chapter 3: Optimizing the schema. (i. Predictive modeling is useful because it gives accurate insight into any question and allows users to create forecasts. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. TheLogicalDataModel 19View Schema Information. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. Following are multiple of that significant features. Bypassing the login page by providing the session state in the URL. Installation And Initial Setup. 0 workflow with Okta can be seen here. To do this, you use the portable documents feature. Database Instance. It does not represent the physical data structure in the company. Separating the data model from reports is encouraged for data reusability purposes, but isn't required. Update. The logical data model. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. EN. Click the MicroStrategy icon, and select Create Document. 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. PMML is an XML standard that represents data mining models developed and trained by data mining tool. MicroStrategy is an enterprise business intelligence ( BI) application software vendor. Powering. Watch on. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. MicroStrategy Tutorial. 6. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. Projects generally also contain other. For the structures to match, the tables must have the same column names and the data types for each column must be "compatible" across databases. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Data Modeling Data modeling is the structuring of an organization's data assets into an applicable logical model. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. Click within the Dataset Objects area to add datasets for the document. A logical data model graphically depicts the flow and structure of data in a business environment. mdb is in Program Files (x86)MicroStrategyTutorial Reporting. Design intuitive analytics reports with MicroStrategy ONE. The MicroStrategy Tutorial, MicroStrategy’s. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. 9. Using this tool, users can easily transform big data into instinctive dashboards and reports for greater. Install and configure MicroStrategy, and connect to data sources. A data model can be simple, such as a single table. Take note of the following. 0 can do so by running the MicroStrategy. It is known as star schema as its structure resembles a star. Gather information about your MicroStrategy project. g, the fact table used before was at Year level, now become at the Day level. MicroStrategy Tutorial. TheLogicalDataModel 19A Datawarehouse is Time-variant as the data in a DW has high shelf life. Advanced Metrics, explains level metrics, conditional metrics, transformation. MicroStrategy Tutorial. MicroStrategy Education. The retail store sells electronics, books, movies, and music. If the call is successful, the resulting HTTP response returns an HTTP. PMML supports a number of different data. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. From the drop-down list in the toolbar, select the metric to which you want to apply the threshold. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. Another benefit is the consistency of information and calculations. This tutorial steps through how to switch to Free-form Layout within a Dossier. MicroStrategy is an enterprise BI application software. The retail store sells electronics, books, movies, and music. It is designed to help developers build data-driven client applications quickly and easily. 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. 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. Dimensional Modeling. 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. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\MicroStrategy\Data Sources To connect to a remote Intelligence Server that has not yet been registered on the local computer, when a Project Source pointing to this Intelligence Server is not yet defined, create this Project Source first in MicroStrategy. This cube has two attributes and two metrics. Regression analysis using data mining functions is described in. The ID form (required) •. After enabling Mobile Telemetry for the project, users can run a report on the Mobile App. MicroStrategy Internal Reference Number for this technical note is KB483727 and. Here's how sql server is used on microstrategy developer resumes:Freeform SQL Report Error. Administrator. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. Star Schema in data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. • It provides features for mobile analytics. Select the attributes and facts from that table. Chapter 2: Administering Big Data with MicroStrategy Chapter 3: Data warehouse performance tuning Chapter 4: Optimizing data: Strategies and techniquesThe Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. Build a new plugin or update an existing Teams message extension or Power Platform connector to increase users' productivity across daily tasks and workflows. 4. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . This is where the main fact/driving table has a transaction key column which is mapped as a child of all the different real attributes for the different hierarchies present on the driving table. You will gain expertise to do multidimensional data modeling involving hierarchies, levels, measures and schemas. so you can still create and execute reports, but cannot run the documents/dashboards. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Compared to other Business Intelligence tools, MicroStrategy is capable of providing a complete enterprise-level reporting solution that is flexible, scalable, robust, and user-friendly. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. . To build a report using the Report Wizard: To start the Report Wizard. Open Workstation in smart mode. It is a. If the call is successful, the resulting HTTP response returns an HTTP. MicroStrategy today announced the launch of MicroStrategy AI. This article addresses the change starting from MicroStrategy version 2021 Update 8 where privileged users are allowed to convert data sources based on DSN to be DSN-Less through REST APIs and the change starting from MicroStrategy version 2021 Update 9 where privileged users are allowed to convert data sources based on DSN to. The following examples use the MicroStrategy Tutorial project for illustration purposes. Due to the limitation of some WH, e. 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 Star Schema data model is the simplest type of Data Warehouse schema. to open the Shared Reports folder of the. Every attribute must have at least one form, and most have at least two: •. Gather information about your user audience. The following diagram shows an overall architecture of MicroStrategy platform describing how it accesses data from various sources. 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. What is the MicroStrategy Tutorial? 235 B MICROSTRATEGY TUTORIAL Introduction This appendix provides information on the MicroStrategy. EN. From the Data menu, choose Rename/Edit Objects. 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 reflect relationships. The goal is to derive profitable insights from the data. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43 MicroStrategy Tutorial. Explore Our World-Class Learning Path for MicroStrategy. It is ready to be used and requires no additional configuration tasks. For example, a simple logical data model for a retail company can organize all necessary facts by store. Connect to MicroStrategy Web (this example) or MicroStrategy Desktop. PMML supports a number of different data. The Relational database modelling represents the database as a collection of relations (tables) Attribute, Tables, Tuple, Relation Schema, Degree, Cardinality, Column, Relation instance, are some important components of Relational Model. Apache HBase is needed for real-time Big Data applications. Open the table menu and click “Define Relationships”. The MicroStrategy REST API is an Application programming interface that lets developers quickly extract subsets of pre-processed data in JSON format. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. Security model: Use 7. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. Oracle. There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5) DataMarts. The concept of Dimensional Modelling was developed by Ralph Kimball and consists of “fact” and “dimension” tables. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. Clean and Transform data. Begin or complete a degree; fully online. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. A product bundle (consisting of Reporter, Reporter (Server), and Distribution) designed to meet the specific needs of data consumers: users who only want to view and interact with MicroStrategy Dossiers, reports, and documents. 2015 views | July 31, 2020 05:23. It is a. 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. A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. Data preparation: Explore how to connect various data sources to MicroStrategy as well as configuring connections and importing data from other BI tools, databases, or spreadsheets. 11. Watch on. I'm coming from a microsoft shop into a microstrategy shop and I'm looking for free tutorials/training similar to what I am able to find for…© 2004 MicroStrategy, Inc. , unveiled its first 2021 platform update. For this, it uses a relational OLAP architecture. Documents and dashboards allow you to display your business data in a user. In MicroStrategy 2019 and earlier, a visualization with data from an In-Memory Intelligent Cube returns incorrect data for an Aggregate From Base metric made using the Case() function when there is a Derived Attribute on the template, and the dossier contains an unused dataset. It can connect to data warehouses, relational systems, flat files,. MicroStrategy provides an extensive library of native analytical functions and scoring algorithms, along with an SDK to integrate with 3 rd-party and open source statistical and data mining products. 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 softwarePerform the same procedure for the database instance "Operational Datamart" to update the database login information for Operational datamart. 6. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. 11 Critical Update 1 (v10. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 2 Openingareport 6 Componentsofareport 7MicroStrategy Data Mining Services allows organizations to use predictive functions that are natively available within MicroStrategy, or import models from third-party data mining vendors. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. Dimensional Modeling concepts. The Apply functions also hand off to your RDBMS functions that are specific to your database. 500% salary hike received by a working professional post completion of the course*. BIArchitectureandtheMicroStrategyPlatform 1 Businessintelligencearchitecture 2 TheMicroStrategyplatform 8 Theprojectdesignprocess 18 2. You can easily copy a threshold to multiple metrics on a. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. ) Formatting Visuals. offset is the start point of your response. In this example, that report attribute is Call Center. wanttobuildandresellMicroStrategy-basedproductsorapplicationssuitedto particularindustries. 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 purpose is to organize, scope, and define business concepts and rules. For Cloud 3. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. Diagnostic Analytics. login_mode ¶ Authentication mode. 1. KB19194: Considerations for the use of star schemas with MicroStrategy SQL Generation Engine 9. The report is displayed in Grid View, as shown below. username ¶ Username. 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 game-changing enterprise analytics tool that turns data into actionable insights and intelligence. In the Navigation pane, click Create a New Document next to Documents. g. Metric - MicroStrategy. Micro Strategy also supports mobile BI. A logical data model is a logical arrangement of data as experienced by the general user or business analyst. A logical table is created for each physical table that is imported into a project, using the Warehouse Catalog. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Click within the Dataset Objects area to add datasets for the document. Useful Functions: Next Topics » Creating A Dataset Report: Creating A Predictive Model: Importing The. Data warehouse for data storage and relational design, page 4. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. This will launch the "Select Data Source" window. MicroStrategy comes with a sample project called MicroStrategy Tutorial. It uses Business Scenarios to provide examples of each concept illustrated. Create a second metric identical to the first, but add the predefined Year to Date transformation. Convert your message extension to a plugin. This new addition to its AI/BI platform allows organizations to integrate transformative AI experiences into their applications and products, all based on trusted data. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Download and unzip "Tutorial Project Files" from the download site according to the. Full control. Set Freeform SQL and MDX objects default security. Go to Format tab → Text and Forms → Shape → Threshold. or subparagraphs (c)(1) and (2 ) of the Commercial Computer Software—Restricted Rights. Prepare, install, and configure. A description form. For example, a simple logical data model for a retail company can organize all necessary facts by store. There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5). When the MicroStrategy Developer 9. When opening the “Mobile Analytics” Dossier and republishing the “Dimensions Cube”, users will see that data is now populated in. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. A document or dashboard can contain data from one or more MicroStrategy reports. 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. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. incorporate third-party data mining and modeling tools. MicroStrategy is an enterprise BI application software. 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. Microstrategy tutorial Custom MicroCharts in MicroStrategy. Attributes. In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts. 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. In MicroStrategy Developer, open the Basic Report from the MicroStrategy Tutorial. 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. You use the trusted data available to you in MicroStrategy to find those insights and present them to your business stakeholders in the form of interactive, beautiful, and insightful visualizations within a Dossier. MicroStrategy Tutorial Reporting. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Worked with ETL team to identify the data transformation from source database to target MicroStrategy data warehouse. You combine data in the logical layer. You must log in as a user with administrative privileges. Data Wrangling. x. In microstrategy architect , we define logical data model within the tool. Hierarchies define the flow of relationships between attributes in a logical data model. This Python script example will help you to: 1) List all OLAP cubes in your project 2) Download real SQL query for each cube 3) Parse the SQL and extract details about tables and columns being used 4) Export gathered details to CSV files for further. 56K. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. Advanced Data Science with MicroStrategy 2022. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and. For more details on enabling the setting, refer to Change Data Engine Version After the fix, metric outer join works and data returns. Self-Service Analytics with Amica. You can use various combinations of tables and columns to support and identify the translated data in your database. CONTENTS BookOverviewandAdditionalResources vi 1. To effectively use MicroStrategy for data visualization, it's important to have a backup and recovery plan in place. URL of the MicroStrategy REST API server. Specifying Warehouse Connection Information. For example, most databases cannot join a data type of Text to a data type. This template uses a single. The New Grid dialog box opens. Data mining generally refers to examining a large amount of data to extract valuable information. In addition, it will also be helpful for. Create a metric that sums the fact Units Sold. Step 3: Modeling. Connect your apps to Copilot. On expanding the button, the following screen opens showing different public. A single Power BI Desktop (pbix) file could contain a data model or report, or both. 4. SQL Server. Data Mining and Predictive Analysis You can deploy a wider range of data mining and data modeling tools along with MicroStrategy to augment its native analytical capabilities. 215 Embedding Analytics with MicroStrategy REST API 2022. x GUI is set to double-byte language and Microsoft Office's primary language is set to a different language. Wherever you can define an expression, you can use a function. On the Freeform Sources tab, select Create Freeform SQL report. When creating the attributes for your project, rename each attribute to match the names in the logical data model. Right-click the attribute and select Add to Filter. EN. 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. Click OK. ssl_verify ¶ If True (default), verifies the server’s SSL certificates with each request. In the Metrics folder, open the Sales Metrics folder. MicroStrategy Tutorial : Login user:. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. Click 'Add External Data' and then 'File From Disk'. The data mining process involves using the predictive models based on existing and historical data to project potential outcome for business activities and transactions. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. g. Intelligence Everywhere. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. A data model can be simple, such as a single table. 1) • Support extended through June 30, 2019. 01:06. Click the MicroStrategy icon, and select Create Document. Support is provided for the following models: Association Rules, Cluster (Center-based), Decision Tree, General Regression, Mining Model, Neural Network. Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. Founded in 1989 by Michael J. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. 2014 MicroStrategy Inc. The figure shown below shows the modeling window for MySQLWorkbench. Helps you to manipulate the database in a single package. 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. MicroStrategy comes with a sample project called MicroStrategy Tutorial. 1 Follow the steps above to log in to MicroStrategy Web. In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts. The REST API is designed to help developers build data-driven client applications quickly. Source systems refer to any system or file that captures or holds data of interest. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. To Create an Attribute Qualification Using a Dynamic Date Create the Today FilterMicroStrategy Quick Guide - As a Business Intelligence tooling with wide range of capabilities, MicroStrategy has powerfully features that helps to find answers and insights in business information analysis. Open a grid report. We use MicroStrategy Tutorial objects in the following steps. Support is provided for the following models: Association Rules, Cluster (Center-based), Decision Tree, General Regression, Mining Model, Neural Network. 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 enables data scientists to import MicroStrategy data into RStudio and Jupyter Notebook. Opening the login page to gather user for credentials. 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. Undo and redo the wrangling operations that are done on a dataset. 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. 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. - modify the data a little bit. A description form. A Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. Power View: This component allows you to visualize, analyze, and display data. 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. Type the Name for the object and click OK to save your changes. This type of logical table maps directly to physical tables in the data warehouse. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Use the data warehouse physical schema in Appendix B for assistance. 3. The project schema refers to an internal map that MicroStrategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within a project. In addition, it will also be helpful for those readers who want to pursue a career as a Data Scientist or Data Analyst. It offers a wide range of analytical capabilities. These tables include a combination of attribute and fact definitions. In MicroStrategy Desktop, log in to a project. xIn 2022, architects have everything they need to build and manage the data model in just minutes through Workstation. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. iv. 3. TYSONS CORNER, VA, October 3, 2023 — MicroStrategy® Incorporated (Nasdaq: MSTR), the largest. CONTENTS 1. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. , when Year level fact table is available and can be. Select the object to rename from the Object drop-down list. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. project_name ¶ Name of the connected MicroStrategy Project. Erwin is a data modeling tool that is used to create logical, physical, and conceptual data models. Python coding is short, minimal and easy. Attributes. Query and reporting, tools 2. The following diagram describes the process of creating. Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Select the Tutorial Data database instance. To build a report using the Report Wizard: To start the Report Wizard. project_name ¶ Name of the connected MicroStrategy Project. You can support data internationalization in your database by using separate tables and columns to store your translated data. Customers wishing to use Platform Analytics in 11. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. It calculates the subtotal elements of a compound metric. There are mainly three different types of data models: Conceptual: Conceptual data model defines what should the system contain. Summary. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. MicroStrategy Tutorial Reporting. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. Library of Analytics Functions It has an extensive library of over 300 OLAP, mathematical, financial, and data mining MicroStrategy Tutorial schema. Overview of Data warehousing. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. 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. These physical tables are referenced in the SQL. When modeling a database inside MicroStrategy there are a few methods to try when mapping data. 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. Following are the three report types used in MicroStrategy Desktop. A project is the highest-level intersection of a dataColumn data descriptions and identifiers: Attribute forms. It is also known as Star Join Schema and is optimized for querying.