Enhancing enterprise analysis with data science. 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 main. 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, unified Web interface. Predictive analytics, also known as predictive analysis or predictive modeling, is the use of statistical techniques to create models that can predict future or unknown events. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and. Every attribute must have an ID form (identity. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. Some of the main features offered by MicroStrategy are Advanced. Metric - MicroStrategy. It has a simple menu to import data for analysis and export the result of analysis. It provides a way of organizing facts so that they can be analyzed from different business perspectives. 0. • It is the most useful tool for resolving big data related issues. The following diagram describes the process of creating. 1 and 10. x GUI is set to double-byte language and Microsoft Office's primary language is set to a different language. 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. Type the Name for the object and click OK to save your changes. Properly designed database are easy to maintain, improves data consistency and are cost effective in terms of disk storage space. Take note of the following. MicroStrategy and other OLAP tools incorporate intelligent and secure Cube data sharing capabilities, ensuring the secure sharing of data. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. It delivers a streamlined data model, simpler schema and real-time monitoring. Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. Click the MicroStrategy icon, and select Create Document. )We will use the data contained within the MicroStrategy Tutorial project that is provided out-of-the-box. The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as follows: 1. EN. MicroStrategy Project Design Guide. Data is composed of observable and recordable facts that are often found in operational or transactional systems. 6. DATA SCIENTIST RESOURCES & TUTORIALS. MicroStrategy Schema Modeling. The Star Schema data model is the simplest type of Data Warehouse schema. MicroStrategy’s gateways span more than 99% of the data ecosystem your organization has, and MicroStrategy is always committed to expanding these gateways to meet—or exceed— your enterprise data needs. Copy and past all the cube files included with the Tutorial Data download from the prerequisites section (in a folder called 'Cubes'). 1. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43MicroStrategy Tutorial. iv. It is also known as Star Join Schema and is optimized for querying. Erwin is a data modeling tool that is used to create logical, physical, and conceptual data models. The SSAS full form is SQL Server Analysis. Microstrategy is rapidly increasing in popularity and is being leveraged across. Second section is on MicroStrategy Desktop and the last part will be on MicroStrategy Web. MicroStrategy MCD Practice Project â MicroStrategy Tutorial Page 1 of 38 Revised: 10/8/2009 © 2009 MicroStrategy, Inc. 11. 3. Click here to view help for the latest version of this product or search MicroStrategy Community. • It provides features for mobile analytics. HBase can store massive amounts of data from terabytes to petabytes. CONTENTS 1. A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy. A logical data model represents the definition, characteristics, and relationships of data in a technical, conceptual, or business environment. Data Wrangling. Login to MicroStrategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following tables and columns; Click Finish to Import as an In-memory Dataset and save as MTDI01Chapter 1: Defining and analyzing data requirements: Data modeling Chapter 2: Developing and maintaining schema objects Chapter 3: Optimizing the schema. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. It can connect to data warehouses, relational systems, flat files, web. 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. The Data Mining Services can be used by business users, report designers and analysts to view and build predictive. Professional Summary. This Microstrat. Source systems refer to any system or file that captures or holds data of interest. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Architect your schema based on enterprise business needs to. 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. Design intuitive analytics reports with MicroStrategy ONE. Click "Ok" and enter the credentials to connect to the database. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you get a job in the MicroStrategy domain. 55. 01:54. From the list of document templates, click Blank Document. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. 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. MicroStrategy has a wide range of native analytical capabilities, with the option to easily incorporate third-party data mining and modeling tools. It is one of the best data modeling tools that helps you to create the actual database from the physical model. MicroStrategy Project Design Guide. The Data Mining Services can be used by business users, report designers and analysts to view and build predictive reports and distribute these reports to users on any device. In 64-bit Windows operating systems, the default location of the TUTORIAL_DATA_7200. Anybody can use these data mining features like report designers, business users and analysts. 9. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. In the Form expression pane, place the cursor to the right of [CUST_LAST_NAME] and type + ", " +. EN. MicroStrategy is an enterprise BI application software. 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. What you'll learn. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. MicroStrategy applications are then defined entirely in. 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, and Hadoop distributions. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. In MicroStrategy Developer, choose File > New > Report. In MicroStrategy, there are two different types of hierarchies: System hierarchies are automatically generated when a project is created and are maintained by the. Application Development tools, 3. 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. A document or dashboard can contain data from one or more MicroStrategy reports. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Data Wrangling uses the data transformation and enrichment functionality inside MicroStrategy to prepare the data for analysis. For more information on how MicroStrategy can access your data sources, see. Data Wrangling uses the data transformation and enrichment functionality inside MicroStrategy to prepare the data for analysis. The following illustration shows how each component is represented within a logical data model: Structure of a Logical Data Model. 11 and Data Engine Version 2019, Engine picks fact tables with lower levels, e. 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…from a data source, and use that data to create and modify dashboards. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. MicroStrategy Delivery Engine, MicroStrategy 구독 포털, MicroStrategy Tutorial – Delivery Installation 및 MicroStrategy Tutorial – Delivery Configuration을 사용하려면 MicroStrategy Narrowcast Administrator와. Functions Reference. Undo and redo the wrangling operations that are done on a dataset. The default level notation {~+} is placed on the metric since the default is to group by an attribute on the report. Identity the start and end position as offset and limit request parameters. From the list of document templates, click Blank Document. The ID form (required) •. 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. Click Modify to open the Properties dialog box: Security tab. Micro. In MicroStrategy Desktop, log in to a project. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. Number of Views 9. MicroStrategy has to support double-type attribute IDs comparison. 3. Click OK. This course consists of three different sections. Microstrategy web. PMML is an XML standard that represents data mining models developed and trained by data mining tool. 6 plus years in Data warehousing, Business Intelligence systems, OLAP environments and tools. Double-click the CUST_LAST_NAME column to add it to the Form expression pane on the right. MicroStrategy Delivery Engine, MicroStrategy 구독 포털, MicroStrategy Tutorial – Delivery Installation 및 MicroStrategy Tutorial – Delivery Configuration을 사용하려면 MicroStrategy Narrowcast Administrator와. 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. 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. EN. project_name ¶ Name of the connected MicroStrategy Project. EN. PMML supports a number of different data mining algorithms, including Regression, Neural Networks, Clustering, Decision Trees and Association. Every attribute must have an ID form (identity. Open a grid report. In microstrategy architect , we define logical data model within the tool. You will arrive at the MicroStrategy Tutorial Home page. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. HBase is an open-source, column-oriented distributed database system in a Hadoop environment. Data Mining. It aids in AI-assisted data exploration, automates dossier design processes, and offers tools like SQL generation and ML-based visualization methods. login_mode ¶ Authentication mode. We use MicroStrategy Tutorial objects in the following steps. 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. 4. project_id ¶ Id of the connected MicroStrategy Project. Administrator. It has 2 variants Multidimensional and Tabular. Empower end users to easily compare and measure the performance of metrics in an intuitive way with the new multi-metric KPI visualizations. It is a Business Intelligence (BI) tool. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. Tutorials Choose your MicroStrategy version: New in MicroStrategy 2021 HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications. The New Grid dialog box opens. g. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. 500% salary hike received by a working professional post completion of the course*. Metric - MicroStrategy. 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. IntroductiontoMicroStrategy:EvaluationGuide 7 ©2016,MicroStrategyInc. 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. A good reference document is the Teradata white paper Data Model Overview: Modeling for the Enterprise While Serving the Individual. Data Modeling Data modeling is the structuring of an organization's data assets into an applicable logical model. 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. MicroStrategy Project Design Guide. EN. The physical warehouse schema organizes the logical data model in a method that makes sense from a database perspective. For customers on MicroStrategy 10. 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 dimension tables are normalized which splits data into additional tables. This procedure is using the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy. The REST API is designed to help developers build data-driven client applications quickly. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. Using this tool, users can easily transform big data into instinctive dashboards and reports for greater. 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. When a report like this is built using. EN. Data Wrangling. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. These tables include a combination of attribute and fact definitions. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. It also provides steps to create your first dashboard. 12K. c) It helps with software development. The customer needs to upgrade to these new releases to pick up the fix. We provide high earning skills MicroStrategy and live project. The logical data model provides a picture of all the pieces of information necessary to understand your data and how it relates to your business. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. The new platform version focused heavily on embedded analytics with a host of new features for HyperIntelligence, a tool first introduced in 2019 that utilizes. 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. Questions you should ask about your project include: •. x Addons and Tools:. ; 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. MicroStrategy enables data scientists to import MicroStrategy data into RStudio and Jupyter Notebook. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. To log in to a specific project, see Starting MicroStrategy, page 2. •. 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. To view the MicroStrategy Tutorial data model using Architect. In MicroStrategy Developer, choose File > New > Report. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. Answer: a) It enables organizations to make informed business decisions. ssl_verify ¶ If True (default), verifies the server’s SSL certificates with each request. MicroStrategy Project Design Guide. Symptom When a report uses a Transformation Metric with multiple transformation levels(e. MicroStrategy Internal Reference Number for this technical note is KB483727 and. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Grid Reports − These reports display only textual information in the form of grids showing rows and columns of data. 6. Source systems for data collection. Dimensional Modeling concepts. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Untuk itu, MicroStrategy HyperIntelligence hadir demi mengakselerasi pentingnya pengelolaan data dalam pengambilan keputusan bisnis. MicroStrategy Tutorial. Gather information about your MicroStrategy project. 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. Tutorial | 2009 Views | Oct 4, 2021. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. 10. In the sample that was provided, you get the data for an instance of the cube “Advanced sort” in the “MicroStrategy Tutorial” project. Customers wishing to use Platform Analytics in 11. Developer enables you to model applications using an intuitive, graphical interface. MicroStrategy is one of the most widely used business intelligence and data analytics platforms in the world. The Tutorial project includes sample data, such as actual customer names and items purchased. The mappings are typically used to take advantage of one of several RDBMS data security techniques (security views, split fact tables by rows, split fact. It is a. You can easily copy a threshold to multiple metrics on a. The Tutorial project includes sample data, such as actual customer names and items purchased. Support is provided for the following models: Association Rules, Cluster (Center-based), Decision Tree, General Regression, Mining Model, Neural Network. After user upgraded the project to MicroStrategy 10. Even though a large number of attributes were included, the resulting model includes only those attributes that were established as strong predictors-gender, age. Get Started MicroStrategy Workstation Become a More Intelligent Enterprise MicroStrategy Tutorial data model. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. Reporting remains consistently accurate in OLAP servers as the speed of data sharing does not impede the process. URL of the MicroStrategy REST API server. MicroStrategy is a powerful Business Intelligence and Visualization software. Intelligence Everywhere. In a data warehouse environment, data only comes to have value to end-users when it is. 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. 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. MicroStrategy Tutorial. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. Attribute forms are identifiers or descriptors of an attribute, as explained in Logical data modeling conventions. login_mode ¶ Authentication mode. For this, it uses a relational OLAP architecture. MicroStrategy Tutorial data model. From the Data menu, select Thresholds. a governed, scalable, and uniquely adaptable data model that unifies and fuels your. 6. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. 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. Every attribute must have at least one form, and most have at least two: •. Data mining examples included in the MicroStrategy Tutorial project, in Public ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Data Mining Services In addition, this section describes the process of how to create and use predictive models with MicroStrategy and provides a business case for illustration. TYSONS CORNER, VA, October 3, 2023 — MicroStrategy® Incorporated (Nasdaq: MSTR), the largest. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. By the end of the MicroStrategy training at Tekslate, our course participants will be able to . A detailed explanation of each method for. MicroStrategy Architect: Project Design Essentials. 63K KB34000: "QueryEngine encountered error: Execute Query Failed. MicroStrategy Project Design Guide. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. Select MicroStrategy Tutorial as data source and choose table “LU_MONTH”. The model is automatically embedded in a new predictive metric. 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. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. The data mining process involves using the predictive models based on existing and historical data to project potential outcome for business activities and transactions. MicroStrategy Education. Specifying Warehouse Connection Information. Choose your MicroStrategy version: 2021. 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. Choose your MicroStrategy version: 2021. 47K. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. 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. MicroStrategy Project Design Guide. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. Another benefit is the consistency of information and calculations. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. 1. The User Editor opens. For example, a simple logical data model for a retail company can organize all necessary facts by store. There are Power BI components are 5 main components released in the market. g. 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. BIArchitectureandtheMicroStrategyPlatform 1 Businessintelligencearchitecture 2 TheMicroStrategyplatform 8 Theprojectdesignprocess 18 2. Metadata partition mapping defines data slices by filters, where each slice maps onto a physical partition in the warehouse. 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. From automation to translation to data enrichment, MicroStrategy offers the best in BI. Due to the limitation of some WH, e. 3. Platform Analytics is a completely new product introduced in MicroStrategy 11. Power Query: It can be used to search, access, and transform public and/ or internal data sources. It offers multiple import/export options, enhancing data literacy and agile application development. Graph Reports − These reports show various graphs created from the data sets. 65K. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. MicroStrategy comes with a sample project called MicroStrategy Tutorial. Download and unzip "Tutorial Project Files" from the download site according to the. 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. ROLAP Architecture. Basic. Microstrategy tutorial Custom MicroCharts in MicroStrategy. Helps you to manipulate the database in a single package. Select the object to rename from the Object drop-down list. 25. Logical Data Model Components. MicroStrategy Tutorial. MicroStrategy. Watch on. Learn how to import and export all the dataframes. MicroStrategy Tutorial data model. Separating the data model from reports is encouraged for data reusability purposes, but isn't required. A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. 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. New in MicroStrategy 2021. For more information on what a logical data model is and how to create one, see The Logical. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Process Advisors. 227-7013 et. 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. Platform: Intellipaat. A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. 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. It is a. Select the 01 Blank Dashboard template. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. 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. When the MicroStrategy Developer 9. The main difference between report filters and view filters is how they are evaluated by the system. Data Modeling Homepage MicroStrategy’s semantic graph capabilities help you keep a structured data model and maintain a single version of the truth across your enterprise in all reporting. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. • It can associate with surviving enterprise apps and systems. Gather information about your user audience. When opening the “Mobile Analytics” Dossier and republishing the “Dimensions Cube”, users will see that data is now populated in. 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. Modeling is creating information that describes another set of data. In this example, that report attribute is Call Center. BIArchitectureandtheMicroStrategyPlatform 1 Businessintelligencearchitecture 2 TheMicroStrategyplatform 8 Theprojectdesignprocess 18 2. Design schema objects like facts, attributes, and hierarchies using architect design tool. The retail store sells electronics, books, movies, and music. Tutorial Data Model • Dimension Hierarchies: Customer, Geography, Product and Time. 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 framework is used for developing mostly Single Page applications. In a BI platform, the logical data model is designed and built using current user. 3. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. 2. Dimensional Modeling concepts. Perform the same procedure for the database instance "Operational Datamart" to update the database login information for Operational datamart. 1. 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.