This knowledge-base article provides best practices for configuring, monitoring and troubleshooting Platform Analytics. The. This article provides some best practices for decreasing the Intelligent cube publish time against Oracle in MicroStrategy. Indexes are created in memory on the Intelligence server as part of the in-memory cube instance. What are the methods to implement Intelligent cube technology in MicroStrategy? Intelligent cubes allow a user to access OLAP service features on reports, a shared set of data can be shared among multiple reports. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. This technical note provides a detailed explanation on how Intelligent Cube index generation works in MicroStrategy 9. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. 4, the below command does not work for Data Import cube: LIST [ALL] PROPERTIES FOR INTELLIGENT CUBE CACHE (NAME "<intelligent_cube_name>" [FOLDER "<folder_name>"]) FOR PROJECT "<project_name>" However using cube GUID will return correct result: CAUSE: This is a. pdf", Dynamic Sourcing -> Best practices for supporting dynamic. Talk to an expert. To learn more about Super Cubes and relevant best practices, refer to the following Community Article: Then in the cube editor, go to the menu: Data > VLDB Properties to open the VLDB Properties window. It serves as the starting point for new developers to getThis article describes the best practices for using dynamic sourcing in MicroStrategy. Prior to MicroStrategy 2020 the Maximum % of growth of an intelligent cube due to indexes governing setting was used to limit the growth of Intellgent cubes over time due to the creation of indexes. Discover MicroStrategy 2021 > It serves as the starting point for new developers to get familiar with the MicroStrategy architecture and development framework. To fully leverage Teradata for analytical SQL requests, the Teradata DSN configuration should be modified from its default values as follows: · Maximum Response Buffer Size - should be increased to an acceptable value. First, you open a blank document and select a report to use as the document's dataset. You can control users' access to data with security filters. mstr) file size (MB) setting. Then, select a page from a different dossier that you want to filter as the target. IS_CUBE_ACT_ID. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. When we mention performance, we mean the speed by which HyperWeb scans keywords to present data via HyperIntelligence cards. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. The solution is to republish the cube after upgrading instead of reusing old cube caches. Using Object Manager, the above cube based reports are migrated into Production. This presentation helps users understand MicroStrategy's in-memory architecture. All articles. If you use Enterprise Manager, dedicate a machine for the Enterprise Manager. In MicroStrategy 10. Description: Intelligent Cube design and utilization; how to build cubes. x. ” in the Help menu of your software. This can improve the performance of. 000007431. Define MicroStrategy Best practices for development, testing. The Full Refresh option is the default. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. KB41988: Is it possible to add prompts to Intelligent Cubes in MicroStrategy Developer 9. x Number of Views 8. Right mouse click on the cube, and “Search for dependent subscriptions” as shown below; it shows two subscriptions have been created based on the Intelligent Cube. CAUSE This has been identified as a defect in MicroStrategy Secure Enterprise 10. While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Creating an Intelligent cube is similar to creating a report. Publisher (s): Packt Publishing. x ODBC calls by default. Text and CSV files: Varies depending on the Intelligence Server memory. Using. 4. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. We’ll summarize how you can use collected data to help you effectively and efficiently manage and maintain peak performance across your MicroStrategy ecosystem, and walk you through tips and. MicroStrategy Intelligent Cube Technology™ allows you to create these Intelligent Cubes, which operate within MicroStrategy Intelligence Server. Hear from Jeff Stitzel, Business Intelligence Architect at eBay, as he discusses big data migrations, intelligent cube use cases, and cube optimization techniques with MicroStrategy. An Enhancement Request for implementing this functionality is. xTo Create a Report that Accesses an Intelligent Cube. Run the Report and check the SQL View. Intelligence Server Statistics . IS_CUBE_REP_ID. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Platform Analytics and to address issues encountered during the statistics logging and data load. 10 MicroStrategy Design Challenges Design Tips & Best Practices for MicroStrategy BI Architects and Developers. When obtaining cache and history list (inbox) files for troubleshooting purposes in the MicroStrategy Intelligence Server 9. This status can appear due to a n environment issue such as the network, database connection, or a PC resource usage issue. 4. Select the data set and click Prepare Data. Set the path for the cube cache file directory to . Use the Intelligent Cube Editor to access all of the features and functionality for creating cubes. For example, derived metrics can be used to subtract the data of one. Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. x product documentation "InMemoryAnalytics. x, with the Intelligence Server running on Linux, the image in the. The status of each Intelligent Cube is listed in the. DESCRIPTION: Starting MicroStrategy 10. 3) Select the LU_YEAR table from the Tutorial database instance and then select "Connect Live. Type of action against the Intelligent Cube: •Users of the OLAP Services Intelligent Cubes feature in a MicroStrategy 9. Choose File > New > Intelligent Cube. Choose one of the following options: Full Refresh: This is the default. In MicroStrategy Command Manager 10. In order to set a limit of rows for report that uses an Intelligent Cubes use the following steps as workaround: 1 - Create a similar regular report using the same attributes and metrics of the Intelligent Cube. Click OK. File from URL: Unlimited. 3. You must belong to the System Administrators group to use this feature. Assuming statistics are enabled for the project in question, users can monitor IS_REPORT_STATS to determine when the Intelligent Cube has been refreshed. On the toolbar, choose Data > Configure Intelligent Cube. 86K KB31566: MicroStrategy 9. Published: Jan 29, 2019;. Integer ID of the Intelligent Cube report that was published, if any. This will render the attribute as an image. Best practice to split large files in Linux Operating Systems. To achieve the best performance possible, it's important to delete all unused objects like datasets, visualizations, tabs (for VIs. In Developer, from the File menu select New, and then Intelligent Cube. 29K. x, create a simple Intelligent Cube with attribute Category and metric Revenue. 4. 4: Persisted. 31K. Details on MicroStrategy recommendations can be found in this TN. Place Intelligence Server close to the both the data warehouse and the metadata repository. CONTENT: Enable cube partitioning, the partition attribute should be the attribute with more cardinality in the cube (more. blogspot. Intelligent Cube refresh options supported for dynamic sourcing MicroStrategy 10. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in MicroStrategy 9. Published: Dec 31, 2018; Last updated: Jul 25, 2023Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Will it affect the performance of already existing MicroStrategy components?How to Start and Stop Intelligence Server Services in Microstrategy By Mohan Vamsi PentakotaOverview of MicroStrategy Training in Chennai. In your Datasets panel, hover over the name of your dataset. Version 9. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Then go to the key “Query Optimization” > “Data Population for Intelligent Cubes” and choose the optimal option. The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. Best practices for mapping MDX. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. MicroStrategy Developer, Web, and Office users can slice and dice data in reports within Intelligent Cubes without having to re-execute SQL against the data warehouse. " maps to the Intelligence Server working directory (when using default locations, this will be C:Program Files (x86)MicroStrategyIntelligence Server). Intelligent Cube design and utilization; how to build cubes, schedule them, and utilize them to improve user experience and report performance. g. Number of Views 5. Published: May 29, 2019; Last updated: Oct 29, 2019; Related versions: To build an Intelligent Cube. If prompting is not a requirement for this dataset then the best method to improve performance is to directly utilize the Intelligent Cube within the Dossier to reduce both the. The range of analytical functionality of MicroStrategy is supplemented by the features and processing power provided by SQL Data Warehouse. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. For example, these reports go from basic execution pointers, quarterly deals by item. foundation to build a career in Analytics, proving expertise in using MicroStrategy. There are multiple components and services replying on MicroStrategy Messaging Services. x. To enable or disable dynamic sourcing for an Intelligent Cube. Refer to Product Manual for more detailed information. -10. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. 1 and 10. OLAP cubes, or the traditional Intelligent Cubes have existed since 9. This. Number of Views 18. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes" The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. To enable or disable dynamic sourcing for an Intelligent Cube. In Developer, log in to a project with a user account with administrative privileges. If you need to delegate administrative responsibilities among several people, create a. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. The ‘’ at the start of the path is required to indicate to the MicroStrategy Intelligence Server that the specified path is a remote location. Published: How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. 4. We did internal performance test for both report execution and cube publishing. Our MicroStrategy certification training helps you to learn the basics of MicroStrategy, so you can easily apply what you’ve learned in the real world. Filters on the report must meet the following criteria: Attributes used in the filter should also be on the Intelligent Cube's definition. The related section is located in. The dataset is a set of data that can be displayed on the document. Download the attached PDF for an in-depth understanding of Object Migration best practices. 4. x) and view reports based on MicroStrategy 9. The Intelligent Cube refresh settings change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule. 3. In MicroStrategy Desktop 9. McLean, Va. If the Intelligent Cube must be re-processed based on a metric. KB441987: Best Practices for increasing performance of publishing large Intelligent Cubes Number of Views 8. Starting in MicroStrategy 10. REPRODUCING STEPS IN TUTORIAL PROJECT: 1. Intelligent Cube size increases over time in the MicroStrategy Intelligence Server 9. Ab MicroStrategy 2021 Update 5 können Sie Intelligent Cubes erstellen. Complete the "sessionState" field (e. Refer to below technical note for the best practices for Data Import: KB34495: Best practices for Data Import in. The user then updates the cube. MicroStrategy Real-Time Analytics. KB37579: Dynamic Sourcing is not used when an Intelligent Cube includes a metric defined as Sum (fact A / fact B) in MicroStrategy 9. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. If you are new to designing documents, see Best practices for designing effective documents before you begin a new document. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. To stay current with the best available scientific evidence and ensure that people have. KB441987: Best Practices. 4. Publish the cube. The data in this cube is as given below. Starting in MicroStrategy 10. The Intelligent Cube opens in the Report Editor. MicroStrategy Best Practices Removing Duplicate Rows Sometimes you need to deal with a data source that has duplicated data. 3. It illustrates tips and tricks, such as enabling parallel data fetch, enabling the correct number of partitions, enabling partition on the appropriate attribute, and using cubes vs. the project configuration: ACTION . Web XML API log. Multiple reports are built that gather data from the Intelligent Cube instead of querying the data warehouse. Connectivity. Generate Oracle AWR report or monitor the database to identify the low performance query. Number of Views 1. VI). A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data. When an Intelligent Cube is in this status, any reports based on this cube have. The target visualizations only display data that also appears in the source. Refer to Product Manual for more detailed information. Published: 4월 6, 2017. MicroStrategy Platform is an enterprise analytics, data management, and BI software platform for managing big data. These. x. Updating Intelligent Cubes without re-processing: Incremental Refresh. Supported data structure and distribution on Gateway. The Java XML API log will record all the XML communications between Intelligence Server and Web. Prerequisites to creating Intelligent Cubes. MicroStrategy recommends the following best practices to reduce the memory size of your Intelligent Cubes: Attributes commonly use numeric values for their ID forms. 3. 4. xMicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. The New Grid dialog box opens. Save the Report and close. 13K. In MicroStrategy Developer, browse to an Intelligent Cube, and then right-click the Intelligent Cube and select Edit. The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Lifetime Access for Student’s Portal, Study Materials, Videos & Top MNC Interview Question. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Agile BI - Learn how to stream data In-Memory within the MicroStrategy platform, and run analytics on top of that live data. Open Command Manager and type the following commands to execute the Intelligent Cubes. 2. How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr… Number of Views 18. 0 introduced the next generation of in-memory analytics, also referred to as in-memory partitioning or PRIME (Parallel Relational In-Memory Engine). For a new column to be added to an existing Intelligent Cube, users need to edit an existing Intelligent Cube and map the new column manually, as. 8. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. For detail information regarding dynamic sourcing for incrementally refreshed Intelligent Cubes, refer to MicroStrategy 10. The Data population for Intelligent Cubes VLDB property allows you to define if and how Intelligent Cube data is normalized to save memory resources. Required Status to Perform Action. KB442526. KB45837: How does the Incremental Refresh option work in MicroStrategy Analytics Enterprise 9. Right-click the project and select Project Configuration. Click Finish. Learn more about it at MicroStrategy. Product information. Therefore we need 20GB RAM memory to store the cube. Afterwards the cube will start executing. 35K. From the results of single cube publish testing which records and compares the time spent for a single cube (4M rows) republish, JDBC driver has better performance than ODBC driver. The Training Metric Wizard opens. Click 'Prepare Data' if further processing is required or click 'Finish' if it is not required. 1 or later, with the following characteristics:. The objects stored in the metadata are reusable. Trending Articles. This value can be adjusted in the PA project settings. A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. STATUS_LIST: A ResultSet listing the statuses of the Intelligent Cube. Starting in MicroStrategy 10. C:Program Files (x86)MicroStrategyWeb ASPxWEB-INFlog. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. KB415730. In order to allow an Intelligent Cube occupying more than the default 250MB to be loaded, the above memory governing must be modified accordingly. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. The MicroStrategy certification training course is designed for those who wish to enhance their knowledge and skills in the field of Business Intelligence and Data Warehousing. Type of action against the Intelligent Cube: •What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. One of the first steps in formatting HyperIntelligence cards is to choose the best-fit template. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. This data is stored in cubes or other SAP objects. 3. Intelligent Cubes Intelligent Cubes With OLAP Services features, your report designers can create Intelligent Cube reports. In MicroStrategy 2021, we introduce a new cube type called Attribute Form Caching cube. Number of Views 2. This section describes only the most basic guidelines. x If the Administrator wants to create a user that is only allowed to create an Intelligent Cube from a grid report in MicroStrategy Developer 10. Open the Intelligent Cube monitor, two instances of the Intelligent Cube are generated with different Instance IDs. 2 - Check the Enable Dynamic Sourcing option under Project Configuration > Intelligent Cubes. x releases. The Java XML API log will record all the XML communications between Intelligence Server and Web. Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. Once you select a specific. The cube population process is the one that retrieves the information from the Warehouse and transfer it to the MicroStrategy Intelligence Server memory in a format which can readily be consumed by different reports requests. Try to include only information that would be imperative at-a-glance. In your multi-form attribute, right-click on the Image attribute and select Change Data Type > HTML Tag. MicroStrategy Internal Reference Number for this technical note. Intelligent Cubes are multi-dimensional cubes (sets of data) that can be shared as a single in-memory copy among many different report created by multiple users. Click the link below to view this article: This document summarizes the best practices and the general conventions for MicroStrategy product suite. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. Currently, project duplication does not involve Intelligent Cube File Directory. Defining Intelligent Cube refresh settings. Shipped vs Native. Use the same attribute in filter in Intelligent Cube and incremental refresh filter. This command will list the table information only when the intelligent cube is a super cube. This article describes a limitation of partitioning when used with database side normalized Intelligent CubesThis technical note documents an issue that occurs when an Intelligent Cube created through Live Connection to an OLAP data source is migrated to another environment, with MicroStrategy Object Manager 10. Dynamic Sourcing. With OLAP Services features, your report designers can create Intelligent Cube reports. x and later, users should make sure to take into account the following. They were used to improve subsequent query. PublishCube". In-memory Cube Reporting: OLAP vs MTDI and Best Practices. The attached document details the differences between OLAP and MTDI cubes, including the basis for the performance profile of each and the available. Set the number of partitions equal to the number of CPU cores in MicroStrategy Intelligence Server host computer. 4. This article covers best practices for the following topics: 1. Attributes in the security filter are related to attributes in the Intelligent Cube: No data is returned, to maintain data access security. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. The motivation of using the semantic layer in MicroStrategy SQL Query Engine when connecting to Snowflake. In MicroStrategy 10. Starting in MicroStrategy 2021 Update 5, you can create Intelligent cubes. We're using a RaspberryPi with Sense HAT to capture telemetry, which is directly pushed in a MicroStrategy In-Memory cube. x). If the Intelligent Cube is at Month level, the user's report should also be at Month level. In this case, the dataset is a MicroStrategy Intelligent Cube. The maximum file size of dashboard (. In some business scenarios, users may wish to delete old data from Intelligent Cubes by utilizing the Incremental Refresh option as explained in KB45837. This can be done in one node of the cluster because the information is stored in the metadata then used. If user downloads the . x Intelligent Cube status indication and workflowInvoke the MicroStrategy Integrity Manager executable MIntMgr. In the VLDB Properties dialog go to the menu: Tools > Show Advanced Settings. ElasticSearch is an open-source search engine based on Lucene that provides multitenant-capable full-text search capabilities. Expand Intelligent Cubes, and then select General. This documentation is intended to provide some guidelines for BI administrators to maintain Messaging Services. Either import tables using Warehouse Catalog in MicroStrategy Developer or create Intelligent Cubes directly using MicroStrategy Web Data Import with the 'Databases' option. For information on creating Intelligent Cubes using Cube Advisor, see Reviewing and creating recommended Intelligent Cubes. Job ID for the action on the Intelligent Cube. If you need to delegate administrative responsibilities among several people, create a. This cube can be used to improve the performance for normal report execution that run against databases, Intelligent cube publishing and connect live to project dossier execution. Create a report based on the Intelligent Cube with Year, Quarter, and Revenue. Save the dataset as Employee Dataset. Compound attributes and joint element lists. The Training Metric Wizard contains the following steps to guide you through the creation of a training metric: Select Type of Analysis. In MicroStrategy Web, it is possible to publish an Intelligent Cube using the task "qbuilder. MicroStrategy - Intelligent Cubes - Online Training Video by MicroRooster. A dataset is a set of data that can be displayed on a document. Business intelligence is becoming more important by the day, with cloud offerings and mobile devices gaining wider acceptance and achieving better market penetration. Let us assume the Intelligent Cube is published on Node B: Create an event called "Refresh Cubes" Create an event-based schedule called "Refresh Cubes"Best Practices Super Cubes in MicroStrategy 2019. Rather than returning data from the data warehouse for a single report, Intelligent Cubes return sets of data from the data warehouse and saves. MicroStrategy - Microsoft Office Integration - Online Training Video by MicroRooster. . 84K. IS_PROJ_ID. You can assign related privileges to different user groups on Developer or Web to perform specific tasks. 4. SHOPMAN, powered by MicroStrategy, delivers sensor data, inventory management, and financial data to enable users make data-driven. As part of generating an Intelligent Cube MicroStrategy uses a normalized data structure similar to a Relational Database with a series of Fact and Lookup tables. ACTION This. Learn more about it at MicroStrategy. Before MicroStrategy 10. view reports. When an Intelligent Cube is published, the description information for the attributes (all data mapped to non-ID attribute forms) included on the Intelligent Cube is repeated for every row. Existing best practice recommendations for needle and syringe programs are out of date. Click Close, then "Finish" on the "prepare data" view and save the cube. x. 3 - Check the Make Intelligent Cubes. Create Intelligent Cube Reports; Explain different types of derived elements; Creating derived elements; Group and Filter derived elements;This procedure is using MicroStrategy Tutorial WH that is shipped with MicroStrategy products. When editing an Intelligent Cube which is published via Data Import, by default the Intelligent Cube Editor is opened in Read Only mode, any modification performed on top of the Intelligent Cube could not be saved. From the Edit menu, select Training Metric Wizard. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. 0 has a dedicated section to memory used for Intelligent Cubes. Go to the "All Objects View" option in the top left corner. Log the communication between the MicroStrategy Web server and the MicroStrategy Intelligence Server. Ensure that the Dependency Search, Conflict Resolution, International, and Migration options in the. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] This article describes best practices to be taken when using a Teradata database in MicroStrategy. When you choose to filter data within another dossier, you also have the option to pass the filter conditions in the source dossier to the. . x Intelligent Cube status indication and workflow. The following steps will show how to allow the user group 'I-Cube Report Designer' to solely build reports upon Intelligent Cubes: As System Administrator, find the existing report templates in the hidden folder 'Object Template' > 'Reports' and adapt the security options to deny access to the user group 'I-Cube report designer'. Select/clear the Join Behavior option - Allow joins across datasets based on unrelated common attributes. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. In Intelligent Cube editor, the default display attribute forms cannot be modified after choosing "Use the following attribute forms" and adding a new attribute form in "Attribute Display". When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. How an Intelligent Cube is chosen to be hit if there are multiple Intelligent Cubes available for Dynamic Sourcing in MicroStrategy 9. Published: Dec 31, 2018 Intelligent Cubes. Number of Views 15. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. Notice surprising patterns with visualizations. How to publish Intelligent Cubes using Task Administrator in MicroStrategy Web. 1. Creating an Intelligent cube is similar to creating a report. 0, the only way to create an intelligent cube (also. table_name: is the name of a table. Version 10. 46K. Go to the Intelligent Cube monitor to identify the cube instance ID: under the three-tier project source, Administration > System Monitors > Caches > Intelligent Cubes. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformHello<br><br>Please allow me to elucidate how my data analyst skills can significantly contribute to your organisation's business growth. In MicroStrategy 10.