1 Follow the steps above to log in to MicroStrategy Web. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. 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. 2 In the Tutorial project, click the MicroStrategy icon and select Shared Reports. 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. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. The general procedure is as follows: Create a training metric to define how to analyze the existing data. arima will take care of the optimum parameter values, you just need to specify a few boolean parameters. REPOSITORY_MODEL MicroStrategy Tutorial (Direct. Azure Machine Learning is a cloud predictive analytics service that makes it possible to quickly create and deploy predictive models as analytics solutions. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. Data Mining. Type the Name for the object and click OK to save your changes. 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. 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 New Grid dialog box opens. Useful Functions: Next Topics » Creating A Dataset Report: Creating A Predictive Model: Importing The. In a BI platform, the logical data model is designed and built using current user. Here's how sql server is used on microstrategy developer resumes:Freeform SQL Report Error. Devising a logical data model for your business. Some of the main features offered by MicroStrategy are Advanced. mdb is in Program Files (x86)MicroStrategyTutorial Reporting. Also practical examples are used in this document in order to illustrate the. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Download and unzip "Tutorial Project Files" from the download site according to the. Logical Data Model Components. You can then build predictive analytics reports on top of it and. BI tools provide insights in the form of dashboards, visualizations, and reports. Apache HBase is needed for real-time Big Data applications. 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. In MicroStrategy Developer, choose File > New > Report. 11. For example, a simple logical data model for a retail company can organize all necessary facts by store. 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. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. Intelligence Everywhere. This means that, while the PMML may contain valuable descriptive information about the model creation process, it does not contain a model worthy of deployment for scoring. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. g. Full control. From the Data menu, choose Rename/Edit Objects. PMML supports a number of different data mining algorithms, including Regression, Neural Networks, Clustering, Decision Trees and Association. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Data Modeling Data modeling is the structuring of an organization's data assets into an applicable logical model. Combined Reports − These reports can show the combination of both the Grid. The Rename/Edit Objects dialog box (DHTML) or panel (HTML) is displayed. What you'll learn. MicroStrategy comes with a sample project called MicroStrategy Tutorial. 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. A data model can be simple, such as a single table. 1x security model:. Choose the MicroStrategy Tutorial application and click Select. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. 1. The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as follows: 1. A layer is similar to a legend item on a paper map. It is a graphic-intensive technique that results in a data model representing the definition, characteristics, and relationships of data in a business, technical, or conceptual environment. The retail store sells electronics, books, movies, and music. What you'll learn. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Create a second metric identical to the first, but add the predefined Year to Date transformation. Advanced Metrics, explains level metrics, conditional metrics, transformation. Empower end users to easily compare and measure the performance of metrics in an intuitive way with the new multi-metric KPI visualizations. To Create a Query Builder Report. MicroStrategy is an enterprise BI application software. Attribute forms are identifiers or descriptors of an attribute, as explained in Logical data modeling conventions. Note: MicroStrategy Tutorial ships with a many-to-many relationship between Catalog and Item. Advanced. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. MicroStrategy Project Design Guide. A data model can be simple, such as a single table. MicroStrategy Tutorial Reporting. Section:2. We're sorry. For more details on enabling the setting, refer to Change Data Engine Version After the fix, metric outer join works and data returns. 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. The MicroStrategy Tutorial is an interactive product. username ¶ Username. The MicroStrategy Tutorial, MicroStrategy’s. 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. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. Business users move seamlessly between all five styles of BI and even combine multiple styles. The Apply functions also hand off to your RDBMS functions that are specific to your database. Helps you to manipulate the database in a single package. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. Power Pivot: It is used for data modeling for in-memory analytics. Take note of the following. Select MicroStrategy Tutorial as data source and choose table “LU_MONTH”. The customer needs to upgrade to these new releases to pick up the fix. Both partitioning schemes depend on proper treatment of attribute data. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. 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. What is the MicroStrategy Tutorial? 235 B MICROSTRATEGY TUTORIAL Introduction This appendix provides information on the MicroStrategy. For new installations of MicroStrategy 8. It provides a way of organizing facts so that they can be analyzed from different business perspectives. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsSummary. The MicroStrategy dashboard: Become acquainted with the dashboard, which is the. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and. Number of Views2. Administrator. Section:2. Use the predictive metric in reports to produce forecasts. • It permits you to directly access a database with in. Another benefit is the consistency of information and calculations. A Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. Architect your schema based on enterprise business needs to. 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. 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. 1 and 10. This MicroStrategy tutorial is designed for readers who want to learn the fundamentals of Microstrategy such as how to read, create, write, and modify BI Reports and dashboards using MicroStrategy reporting tools. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. Metric - MicroStrategy. This video provides an overview of the functionality available to visualize data, since MicroStrategy Desktop 10. CONTENTS BookOverviewandAdditionalResources vi 1. It offers a wide range of analytical capabilities. Support is provided for the following models: Association Rules, Cluster (Center-based), Decision Tree, General Regression, Mining Model, Neural Network. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. For more information on what a logical data model is and how to create one, see The Logical. In microstrategy architect , we define logical data model within the tool. In the Public Objects folder, select Metrics. The following examples use the MicroStrategy Tutorial project for illustration purposes. Use the data warehouse physical schema in Appendix B for assistance. Data warehouse for data storage and relational design, page 4. 02:18. This video walks through an overview of how to model your data using MicroStrategy Desktop 10. 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. Security model: Use 7. Prepare, install, and configure. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. EN. (i. Look for "Tutorial Data" and "Operational Datamart". Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. MicroStrategy Tutorial. From automation to translation to data enrichment, MicroStrategy offers the best in BI. Data model table design level: Controls the design level of the imported tables. Adding Filters (Page level and Global) Adding Links, text and images. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. The default level notation {~+} is placed on the metric since the default is to group by an attribute on the report. Grid Reports − These reports display only textual information in the form of grids showing rows and columns of data. MicroStrategy provides Apply functions as a means of handing off these data and RDBMS-specific functions to your database, which results in your database—not. 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. Designing the Logical Data Model. Tutorial | 2009 Views | Oct 4, 2021. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. The physical warehouse schema is based on the logical data model, such. 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. A logical data model graphically depicts the flow and structure of data in a business environment. After the third-party application develops the PMML-based predictive model based on the dataset, MicroStrategy imports the model to generate reports. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. The modeling tool allows architects to transform a complex enterprise data environment into a unified. It uses Business Scenarios to provide examples of each concept illustrated. This process can help you think about the various elements that compose your company's business data and how those elements relate to one another. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. You need to compare the number of units sold today to the number of units sold from January 1 through today. Anybody can use these data mining features like report designers, business users and analysts. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Data Wrangling uses the data transformation and enrichment functionality inside MicroStrategy to prepare the data for analysis. MicroStrategy Schema Modeling. For example, the MicroStrategy Tutorial project includes a Month of Year attribute which retrieves its. To alias an object name in MicroStrategy Web: 1. •. With MicroStrategy, business users look for patterns, trends, and exceptions and intuitively change their views of the data through simple slice-and-dice analysis. seq. PMML is an XML standard that represents data mining models developed and trained by data mining tool. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Expand the Object Templates category, select General, and from the. Data Wrangling uses the data transformation and enrichment functionality inside MicroStrategy to prepare the data for analysis. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Learn how to build powerful and insightful Dossiers in MicroStrategy with the tutorials below. 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. On the Freeform Sources tab, select Create Query Builder report. Developer enables you to model applications using an intuitive, graphical interface. Gather information about your user audience. 12K. Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. 2015 views | July 31, 2020 05:23. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1How to build and manage Intelligent Cubes. x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. The dimensional model is included for backward compatibility with MicroStrategy 6. Explore Our World-Class Learning Path for MicroStrategy. . • It provides features for mobile analytics. EN. What is the MicroStrategy Tutorial? 235 B MICROSTRATEGY TUTORIAL Introduction This appendix provides information on the MicroStrategy Tutorial,… Log in Upload FileAttributes Finally, create all 30 attributes as diagrammed in the MicroStrategy Tutorial logical data model in Appendix A. 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. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . The MicroStrategy Analytical Engine prepares data for display in the cross-tabbing step by extracting, from the result table, several normalized tables for each attribute and. For example, you could create qualifications for six months ago and for 8 months ago. Users can also utilize historical. MicroStrategy GUI in Japanese and MicroSoft Office primary language in English), the characters are broken when exporting a predictive model to CSV file and open it from Excel. Upon opening your Project Source for a particular environment, the 'Administration' section provides all the tools. You can also drag and drop the attribute to the right pane. x GUI is set to double-byte language and Microsoft Office's primary language is set to a different language. HBase is an open-source, column-oriented distributed database system in a Hadoop environment. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. MicroStrategy 10 is an optimized easy-to-use analytics platform that consolidates analytics, mobility, and security in a single integrated platform and delivers dashboards and compelling visualizations to enable data driven decision making to organizations and end-users through the AWS market place. This framework has been developed by a group of developers from Google. Open the table menu and click “Define Relationships”. In the "Select Data Source" window, go to the "Machine Data Source" tab and select the DSN created in Step 2. The MicroStrategy Project Design Guide provides comprehensive information on planning, creating, and modifying a project in MicroStrategy and covers a wide range of project-related topics, including the following: BI Architecture and the MicroStrategy Platform, provides an introduction to business intelligence architecture and some of the. Thus, for a given table name, columns and data types should match across all database instances hosting the table. HBase can store massive amounts of data from terabytes to petabytes. The ID form (required) •. Open a grid report. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5). Right click on the metric in Editor tab and select Edit Threshold. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Simultaneous phases provide content. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. KB19194: Considerations for the use of star schemas with MicroStrategy SQL Generation Engine 9. This knowledge base article explains how to create an attribute form as a hyperlink or uniform resource locator (URL) in MicroStrategy Developer 9. 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. 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. We’re here to help you align the future of AI/BI technology with your company vision. Identity the start and end position as offset and limit request parameters. Reporting remains consistently accurate in OLAP servers as the speed of data sharing does not impede the process. Azure Machine Learning not only provides tools to model predictive analytics, but also provide a fully managed service that you can use to deploy. A detailed explanation of each method for. Home; Microstrategy Tutorial ; Data Mining Services - Microstrategy; Data Mining Services - Microstrategy. Chapter 1: Defining and analyzing data requirements: Data modeling Chapter 2: Developing and maintaining schema objects Chapter 3: Optimizing the schema. MicroStrategy describes its core reporting. Save the relationship and the dataset. This course consists of three different sections. Gateways and Connectors. 4. MicroStrategy Project Design Guide. Set Freeform SQL and MDX objects default security. This data can then be added to your map in Esri Maps for. 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. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43MicroStrategy Tutorial. Click Save. This type of logical table maps directly to physical tables in the data warehouse. It does not represent the physical data structure in the company. Standard = 1 (default) or LDAP = 16. 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. Build your first plugin. Data Wrangling. For example, most databases cannot join a data type of Text to a data type. Select the 01 Blank Dashboard template. AngularJS is probably one of the most popular modern-day web frameworks available today. 01:54. In MicroStrategy Desktop, log in to a project. Gather information about your data source. For example, a simple logical. Data Warehouse Tutorial Summary. x-10. 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. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. 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. Install and configure MicroStrategy, and connect to data sources. Every attribute must have an ID form (identity. It is also known as Star Join Schema and is optimized for querying. xIn 2022, architects have everything they need to build and manage the data model in just minutes through Workstation. Every attribute must have an ID form (identity. Right-click the Customer attribute and select New Attribute form. You will arrive at the MicroStrategy Tutorial Home page. URL of the MicroStrategy REST API server. Section:1. 3. It is a Business Intelligence (BI) tool. Click within the Dataset Objects area to add datasets for the document. MicroStrategy Project Design Guide. g, the fact table used before was at Year level, now become at the Day level. 11771 views | June 22, 2020 05:24. Documents and dashboards allow you to display your business data in a user. Within each hierarchy, the directLogical data model represents the flow of data in an organization. 227-7013 et. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and. 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. 10. Data modeling is a process of formulating data in an. EN. 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 Tutorial project. 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). Attributes Finally, create all 30 attributes as diagrammed in the MicroStrategy Tutorial logical data model in Appendix A. In MicroStrategy Desktop, log in to a project. You can easily copy a threshold to multiple metrics on a. A Data Lake is a storage repository that can store large amount of structured, semi-structured, and unstructured data. In this table, the PARENT_ID column logically points to another row in the same table (ID column). Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create filters, prompts and metrics. After user upgraded the project to MicroStrategy 10. Data modeling is often the most important step in database design, as it sets up a foundation for the analytics infrastructure. EN. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you get a job in the MicroStrategy domain. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. In MicroStrategy 7i, new methods were introduced to evaluate the calculation level of metrics which prevent the incorrect result demonstrated in this document. These suggestions will help you design an effective, attractive, and practical document. MicroStrategy Project Design Guide. On expanding the button, the following screen opens showing different public. 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. Initially, it was Google Big Table, afterward; it was renamed as HBase and is primarily written in Java. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. 4. There should be at least ten input records in the training data. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. As an example consider the the MicroStrategy Tutorial warehouse and metadata, the lowest level for the INVENTORY_ORDERS fact table is Item, Quarter and Region. In MicroStrategy Web, log in to the Tutorial project. Source systems refer to any system or file that captures or holds data of interest. It will give a clue on how the information within an organization are related. It is a. The MicroStrategy Tutorial data model A data model is a logical map that represents the inherent properties of enterprise data, disregarding software, hardware, or machine performance considerations. Standard = 1 (default) or LDAP = 16. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. The MicroStrategy Tutorial is an interactive product demonstration designed to showcase the rich functionality of MicroStrategy ONE. Enhancing enterprise analysis with data science. It can connect to data warehouses, relational systems, flat files,. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. It uses the sample MicroStrategy Tutorial project. Once the layer is created, you can. Gather information about your MicroStrategy project. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. When the MicroStrategy Developer 9. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. It can connect to data warehouses, relational systems, flat files, web. Functions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. EN. You must log in as a user with. The REST API is designed to help developers build data-driven client applications quickly. CONTENTS 1. 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. ACTION The issue has been addressed in m2019U3 and m2020. Author: Intellipaat. Predictive analytics is a powerful tool to forecast trends within a business, industry, or on a more macro level. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. so you can still create and execute reports, but cannot run the documents/dashboards. 2. MicroStrategy provides its users a powerful set of tools that make it easy to develop custom enterprise assets. This chapter describes one of the major components of data modeling: the logical data model. Data is composed of observable and recordable facts that are often found in operational or transactional systems. Column data descriptions and identifiers: Attribute forms. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. 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 Project Design Guide. When creating the attributes for your project, rename each attribute to match the names in the logical data model. The goal is to derive profitable insights from the data. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. MicroStrategy applications are then defined entirely in. The Tutorial project includes sample data, such as actual customer names and items purchased. Attributes. For example, you can use a Report Services document or dashboard from the MicroStrategy Tutorial project in your own project. Combined Reports − These reports can show the combination of both the Grid. project_id ¶ Id of the connected MicroStrategy Project.