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. Metric - MicroStrategy. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. A Datawarehouse is Time-variant as the data in a DW has high shelf life. A layer is similar to a legend item on a paper map. Select the Tutorial Data database instance. The dimension tables are normalized which splits data into additional tables. You’ll learn the basics of structured data modeling, gain practical SQL coding experience, and. Twenty-seventh Edition, version 9. 1. Hierarchies define the flow of relationships between attributes in a logical data model. Data Mining Services in Microstrategy - Data Mining Services in Microstrategy courses with reference manuals and examples pdf. Learn how to import and export all the dataframes. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43MicroStrategy Tutorial. x. Note: MicroStrategy Tutorial ships with a many-to-many relationship between Catalog and Item. It gives you the leverage of generating real-time reports and monitoring data. In MicroStrategy Developer, choose File > New > Report. - modify the data a little bit. TheLogicalDataModel 19A Datawarehouse is Time-variant as the data in a DW has high shelf life. Gather information about your user audience. Specifying Warehouse Connection Information. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Explore Our World-Class Learning Path for MicroStrategy. 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. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. For example, a simple logical data model for a retail company can organize all necessary facts by store. This video provides an overview of the functionality available to visualize data, since MicroStrategy Desktop 10. 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. Select the attributes and facts from that table. Creating and modifying fact column names and data types: Column aliases. As a result, full MicroStrategy security will be auto-enforced so users will continue to be restricted to the the reports and data that you permit them to see, even within these Office applications. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. Click “Prepare Data” to enter the Preview window. EN. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. 215 Embedding Analytics with MicroStrategy REST API 2022. 6. Using Database Views Many practical MicroStrategy-Teradata implementations do use a set of database views on top of the physical tables in Teradata. •How to configure Micro strategy •How to configure Metadata •What kind of information is stored in Meta data •How the information, objects or definitions stored in the Metadata •Creating schema, attributes, hierarchies objects •Configuring of Metadata •Roles of Meta data in Micro strategy • Repository of Micro strategy. pdf 2/451 20002014…The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, DELETE, and GET. It is a Business Intelligence (BI) tool. Apache HBase is needed for real-time Big Data applications. 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. Go to Format tab → Text and Forms → Shape → Threshold. For information on connecting to databases, see Connect to Databases. Documents and dashboards can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. Tutorial Data Model • Dimension Hierarchies: Customer, Geography, Product and Time. pdf 1/451MICROSTRATEGYARCHITECT: PROJECTDESIGNESSENTIALSCourse GuideVersion: PRJESS-941-Mar14-Color7/24/2019 microstrategy_2. In this table, the PARENT_ID column logically points to another row in the same table (ID column). 3. If prompted for file conflicts, select 'Replace'MicroStrategy Project Design Guide. Update. The Apply functions also hand off to your RDBMS functions that are specific to your database. This chapter describes one of the major components of data modeling: the logical data model. 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. It delivers a streamlined data model, simpler schema and real-time monitoring. Frequently Asked Questions: Teradata Parallel Transporter In MicroStrategy. For example, most databases cannot join a data type of Text to a data type. One is known as a transaction data model setup. Query and reporting, tools 2. Ans: The end products of OLAP service that delivers are: Microstrategy Desktop. If you have a license for the MultiSource Option, selecting a check box for a database instance also makes the database. MicroStrategy Quick Guide - As a Business Intelligence tool with wide range concerning capabilities, MicroStrategy has powerful features that helps to detect answers and understandings in trade data analysis. MicroStrategy Tutorial data model. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. For Cloud 3. Learn how to build powerful and insightful Dossiers in MicroStrategy with the tutorials below. URL of the MicroStrategy REST API server. Tutorial Data Model • Dimension Hierarchies: Customer, Geography, Product and Time. In microstrategy architect , we define logical data model within the tool. A single Power BI Desktop (pbix) file could contain a data model or report, or both. In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts. project_name ¶ Name of the connected MicroStrategy Project. Architect your schema based on enterprise business needs to. 47K. There are 3 ways of configuring thresholds: Go to Format tab → Data Points → Threshold. Powering. On the Freeform Sources tab, select Create Freeform SQL report. Column data descriptions and identifiers: Attribute forms. 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. 3. It provides a way of organizing facts so that they can be analyzed from different business perspectives. On the Freeform Sources tab, select Create Query Builder report. Hyperion Essbase, Microsoft Analysis Services, and other data sources. Graph Reports − These reports show various graphs created from the data sets. Advanced Data Science with MicroStrategy 2022. 1. Author: Intellipaat. KB441462: Licensing-Model-for-MicroStrategy-10-4-8-DE Number of Views 482 KB485145: Provide a new VLDB property "Attribute Relationship Model" for Analysts and Architect to build Data Import appli…In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. Advanced Metrics, explains level metrics, conditional metrics, transformation. Click . Please follow this product guide to MicroStrategy is a vendor of Business Intelligence application software. 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. 2987. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. EN. Support is provided for the following models: Association Rules, Cluster (Center-based), Decision Tree, General Regression, Mining Model, Neural Network. 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. The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as follows: 1. The following examples use the MicroStrategy Tutorial project for illustration purposes. It collects and consolidates analytics data from various sources, such as databases and cloud services, which helps organizations gain valuable insights to make efficient business decisions. In 64-bit Windows operating systems, the default location of the TUTORIAL_DATA_7200. . x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. There are various applications of MicroStrategy. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. 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. This Microstrat. Professional Summary. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. It offers multiple import/export options, enhancing data literacy and agile application development. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. 214 Introduction to Coding with MicroStrategy SDK 2022. x. In the "Select Data Source" window, go to the "Machine Data Source" tab and select the DSN created in Step 2. •. Predictive modeling is useful because it gives accurate insight into any question and allows users to create forecasts. DATA SCIENTIST RESOURCES & TUTORIALS. It will give a clue on how the information within an organization are related. 3. This cube has two attributes and two metrics. )We will use the data contained within the MicroStrategy Tutorial project that is provided out-of-the-box. To explore this sample project data, in the Folder List expand MicroStrategy Tutorial, then expand Public Objects, then expand Reports. Twenty-seventh Edition, version 9. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. 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. These physical tables are referenced in the SQL. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. Microstrategy web. 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. These tools and capabilities include interactive dashboards, scorecards, ad hoc queries, automated report distribution. Section:1. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. 11. PMML is an XML standard that represents data mining models developed and trained by data mining tool. Build your first plugin. MicroStrategy Project Design Guide. Erwin is a data modeling tool that is used to create logical, physical, and conceptual data models. In the Public Objects folder, select Metrics. When you add MicroStrategy business data to a map, Esri Maps for MicroStrategy creates a layer and displays it on the Contents pane. 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. It is designed to help developers build data-driven client applications quickly and easily. Enhancing enterprise analysis with data science. Attributes are grouped by hierarchies. The video also covers MicroStrategy web and MicroStrategy web dashboards in detail. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. PMML supports a number of different data mining algorithms, including Regression, Neural Networks, Clustering, Decision Trees and Association. 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. The tutorial is. Installation And Initial Setup. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. For more information on what a logical data model is and how to create one, see The Logical. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. MicroStrategy comes with a sample project called MicroStrategy Tutorial. MicroStrategy applications are then defined entirely in. •. There are mainly 5 components of Data Warehouse Architecture: 1) Database 2) ETL Tools 3) Meta Data 4) Query Tools 5) DataMarts. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Answer: a) It enables organizations to make informed business decisions. KB19194: Considerations for the use of star schemas with MicroStrategy SQL Generation Engine 9. Visit the MicroStrategy download site to download the latest supported version of this product. The Tutorial is a sample data warehouse and demonstration project you can use to learn about the various features of the MicroStrategy platform. 2. (i. 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. Advanced Metrics, explains level metrics, conditional metrics, transformation. 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. EN. In the Form expression pane, place the cursor to the right of [CUST_LAST_NAME] and type + ", " +. Gain knowledge on concepts of data warehousing, MicroStrategy analytics, and desktop objects. 1) • Support extended through June 30, 2019. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. Perform the same procedure for the database instance "Operational Datamart" to update the database login information for Operational datamart. Some of the main features offered by MicroStrategy are Advanced. Download and unzip "Tutorial Project Files" from the download site according to the. x, "Use relational model" is selected by default. Data Warehouse Tutorial Summary. 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. The New Grid dialog box opens. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. The following illustration shows how each component is represented within a logical data model: Structure of a Logical Data Model. MicroStrategy provides business intelligence solutions to enterprise companies. MicroStrategy Tutorial. MicroStrategy Internal Reference Number for this technical note is KB483727 and. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. • It is stationed in the cloud platform thus it saves your framework costs. Founded in 1989 by Michael J. Number of Views10. ) Formatting Visuals. You must log in as a user with. 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. On expanding the button, the following screen opens showing different public. 3. seq. Both partitioning schemes depend on proper treatment of attribute data. After enabling Mobile Telemetry for the project, users can run a report on the Mobile App. 2015 views | July 31, 2020 05:23. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. MicroStrategy Project Design Guide. In this example, you get the list of projects in the MicroStrategy Tutorial metadata. TYSONS CORNER, VA, October 3, 2023 — MicroStrategy® Incorporated (Nasdaq: MSTR), the largest. This is different from the physical data model or warehouse schema, which arranges data for efficient database use. Using Database Views Many practical MicroStrategy-Teradata implementations do use a set of database views on top of the physical tables in Teradata. Data Wrangling. EN. The model is automatically embedded in a new predictive metric. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. 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. Thus, for a given table name, columns and data types should match across all database instances hosting the table. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. ssl_verify ¶ If True (default), verifies the server’s SSL certificates with each request. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsSummary. MicroStrategy Schema Modeling. This template uses a single. • Warehouse and Metadata is in MS Access. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. In contrast, the logical data model is a logical arrangement of data from the perspective of the general user or business analyst. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. 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. MicroStrategy is a Business Intelligence(BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files,. Projects generally also contain other. New in MicroStrategy 2021. 1 CONTENTS BookOverviewandAdditionalResources vi Aboutthisbook vii Resources viii Feedback xvi 1. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. Documents and dashboards allow you to display your business data in a user. Opening the login page to gather user for credentials. Evaluate business needs, design a data warehouse, and integrate and visualize data using dashboards and visual analytics. 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. ; In-depth knowledge of fundamental data warehousing concepts such as entity relational modelling, dimensional modelling, star and snowflake schemas, modelling data marts, front and back room architectures, security and. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. MicroStrategy Project Design Guide. For more details on enabling the setting, refer to Change Data Engine Version After the fix, metric outer join works and data returns. 2. A process should be put in place to ensure continued. Click "Ok" and enter the credentials to connect to the database. For this, it uses a relational OLAP architecture. 1x security model:. 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. However, with the rise of ad-hoc and self-service analytics, data. 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. 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. You use the authorization token returned during login as the value for X-MSTR-AuthToken. 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. Source systems for data collection. Explore Our World-Class Learning Path for Data Scientists. In the relational database, a compound key is a primary key. Data Wrangling. 1. The MicroStrategy metadata maintains a single list of available columns per table name. Tutorials Choose your MicroStrategy version: New in MicroStrategy 2021 HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Save the relationship and the dataset. MicroStrategy Tutorial Reporting. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. AngularJS is probably one of the most popular modern-day web frameworks available today. In MicroStrategy Web, log in to the Tutorial project. 01:06. Clean and Transform data. A Snowflake Schema is an extension of a Star Schema, and it adds additional dimensions. ROLAP Architecture. 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. After analyzing the dataset with a third-party data mining application, a predictive model is developed and the PMML representation of that model is imported into MicroStrategy. Open a grid report. MicroStrategy has data mining services, which allows the users to import PMML (Predictive Model Markup Language) from third party data mining tools, which can then be used to create predictive reports. SQL Server Analysis Services (SSAS) is a multi-dimensional OLAP server as well as an analytics engine that allows you to slice and dice large volumes of data. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. Right-click the attribute and select Add to Filter. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from cubes and reports, create new datasets, add new data to existing datasets, and manage Users/User Groups, Servers, Projects, and more. The retail store sells electronics, books, movies, and music. For example, you could create qualifications for six months ago and for 8 months ago. The model is automatically embedded in a new predictive metric. Some Data Modeling tools support this concept, where you can decide if. This Specialization covers data architecture skills that are increasingly critical across a broad range of technology fields. It provides a unified environment for creating and. A data model can be simple, such as a single table. To produce the list of names, within MicroStrategy Tutorial, create a custom expression qualification filter using the steps in Custom Expression. 2987. Switch from Developer to the modern Workstation to empower your architects with a one-stop shop for all things MicroStrategy. Open Workstation in smart mode. Data Modeling Data modeling is the structuring of an organization's data assets into an applicable logical model. MicroStrategy Tutorial data model. Create the respective DSN's in the Intelligence Server machines. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. In a data warehouse environment, data only comes to have value to end-users when it is. 2) Explain various types of data models. 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. It has a simple menu to import data for analysis and export the result of analysis. 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 has to support double-type attribute IDs comparison. A data model can be simple, such as a single table. 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. It also allows for different modeling notations and can be extended by using LUA a scripting language. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. 12K. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43 MicroStrategy Tutorial. 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. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. In addition, it will also be helpful for those readers who want to pursue a career as a Data Scientist or Data Analyst. MicroStrategy describes its core reporting. It is one of the best data modeling tools that helps you to create the actual database from the physical model. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. The data mining process involves using the predictive models based on existing and historical data to project potential outcome for business activities and transactions. Select the 01 Blank Dashboard template. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1How to build and manage Intelligent Cubes. To view the MicroStrategy Tutorial data model using Architect 1 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. - push data back to MicroStrategy and save it as a new cube. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Install and configure MicroStrategy, and connect to data sources. 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. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. Overview. In MicroStrategy Web, on the Home page, click New Filter. Attributes Finally, create all 30 attributes as diagrammed in the MicroStrategy Tutorial logical data model in Appendix A. MicroStrategy enables data scientists to import MicroStrategy data into RStudio and Jupyter Notebook. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. When opening the “Mobile Analytics” Dossier and republishing the “Dimensions Cube”, users will see that data is now populated in. Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. MicroStrategy Project Design Guide. This tutorial steps through how to switch to Free-form Layout within a Dossier. A quick tutorial on how to create and Intelligent Cube, and how to schedule it to be refreshed. You can support data internationalization in your database by using separate tables and columns to store your translated data. MicroStrategy today announced the launch of MicroStrategy AI. It aids in AI-assisted data exploration, automates dossier design processes, and offers tools like SQL generation and ML-based visualization methods. Tutorial | 2009 Views | Oct 4, 2021. After user upgraded the project to MicroStrategy 10. 2090 views · September 04, 2020. 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. Open the table menu and click “Define Relationships”. Also practical examples are used in this document in order to illustrate the. A detailed explanation of each method for. Click Run newly saved report to execute the report and display the results, showing sample data from the sample data warehouse. It does not represent the physical data structure in the company. It incorporates data transformation and descriptive statistics. 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. Properly designed database are easy to maintain, improves data consistency and are cost effective in terms of disk storage space. 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. Prepare, install, and configure. In MicroStrategy Desktop, log in to a project.