Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Consolidations vs Custom Groups. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)where: customgroup_name is the name of the custom group, of type string, between double quotes ("). The following window appears on completing the above step. Number of consultants & teachers ___. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Define the advance sort on the derived. Below were my list of questions to be aware as an basic MicroStrategy Developer from my personal experience (dusted from my backup to share with you all). Custom Groups : Custom groups are set of filters and. You can consider custom groups as many different reports "stacked up" together. The five Apply statements enable you to take advantage of your database's native functionality. $50,000 per year [includes deployment, hosting, maintenance, and 80 hours of custom course creation]As shown in the table in Custom Group Structure on Reports, you can enable custom group subtotals at the report or custom group level in Developer, as described below: The report level is governed by the Report Data Options, which allow you to disable or enable subtotals for each custom group on a particular report. In contrast, consolidations. 5. For example, you may want to see all the customers in a retail store that bring in over. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. x, select 'Project Documentation' from the Tools menu to. And leverage the Page-By function to focus your analysis on one element. Next, browse and choose the required attributes to create the. The Code Editor tab should be open. 3. {&GROUPLABEL} Name of the graph. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Note: Since performance of any query depends on factors outside MicroStrategy's control (especially database tuning and indexing), MicroStrategy cannot guarantee that there will be an improvement in performance using this technique. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Such as Sum Metric = Metric 1 + Metric 2 + Metric 3The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. community. The MicroStrategy Tutorial project uses aggregate tables by default. There are several ways to do this but I guess the easiest one will be creating a Metric which is the sum of all the metrics to be used in the report. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Moving the CG/Consolidation to the left as a first column may fix the problem. Description: MicroStrategy lets you create consoli. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Type the Name of the personal view. When creating a VI Dashboard which contains a grid dataset along with either a consolidation or custom group object, the 'Create Attribute' option does not display for any other normal attribute in the dataset. For example, the report below contains Region, Category, and Profit. template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment. For tp & TPPARAM: System Overview Screen -> SAP System -> Check -> Transport Tool. To display a group horizontally. 5. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. The Custom Group Options dialog box opens. 3. Microstrategy Dossiers With the release of MicroStrategy 10. for each successive object passed. Dynamic Custom Group in Dashboards or Dossiers. 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 >. Qualifications are the actual conditions that must be met for data to be included in the custom group element. By the way, there is no. Get Started. When a user has additional attributes in the report objects window, the aggregation causes the consolidation to add up the percentages for the results for each attribute instead of dividing the overall numbers. com. In the Order column, select Ascending or Descending. Change the band names to Top Performers, Average Performers, and Under-Performers. Follow the simple steps below to create a datamart report: 1. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Learn how to switch to a compound grid, add column sets in this new visualization. There's a reason we're at the top of the list. Follow the steps below. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Summer consists of June + July + August, fall consists of September + October + November, and so on. These values are set by default when the "Hive 0. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. Select the environment and project where you want to create your consolidation. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. Add the derived metric to the report and hide it by setting the column width to 0. Consolidations are used to define the data you want to view in your report. Syntax. To Create a Custom Group. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Article outlines why available cache is not utilised when drilling to an attribute inside of an Intelligent Cube report that contains a consolidation or custom group in MicroStrategy Developer (formerly Developer) and WebOnly 29% of organizations consolidate to reduce spending on licensing. Adding consolidations and custom groups . MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. Your separator may vary depending on your number and date format locale. simply a grouping of attribute elements is called Consolidation. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Click Save to save changes. The recommended VLDB optimizations for Hive 0. The report displays derived elements defined using. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. Get inspiration at the MicroStrategy data visualization gallery. Each of the individual "mini-reports" that make up the entire custom group report will have at least one, if not more, SQL passes of its own. The trouble of modifying custom SQL for every object which uses an Apply function when customers switch to different RDBMS and the SQL pattern changes for functions. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. I have a bunch of table that looks like this: Fact table 1. For example, the following image shows two facts with an Item/Day/Call Center level. When this custom group is placed on a report with the metric and an answer of '8' for the prompt, the following results are returned:Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format. Consolidations vs Custom Groups. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. A split hierarchy is one - that at the lowest level - has more than one child. Online Analytical Processing (OLAP) is a multidimensional analysis of business data. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. For more details, see the Custom Groups and Consolidations chapter. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. Subtotals are totals of selected groups of your metric data, totaled at a level you select. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Select only Configuration Objects for documentation. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. Custom groups are used to apply different filters to different rows of a report. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. Custom groups are used to apply different filters to different rows of a report. Each of the individual "mini-reports" that make up the entire custom group report will have at least one, if not more, SQL passes of its own. This feature is only implemented for element list prompts. Create or edit. . Metrics: Component Objects. Development/ Integration system is taken as the source of these consolidation routes. 1, custom group selector does not have the custom group elements, while in 9. Close the Visualization Builder, and then re-open it. 4. 7x. Under 'Level…' choose the attribute. 1K views 5 years ago MicroStrategy. Creating consolidations. consolidation elements, which can be individually formatted. 1 and 10. – Calculations. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a virtual attribute, which is a new grouping of attribute elements, and use it on reports. This helps the BI platform to extensively. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. Therefore, by default, custom groups are not sorted on reports and you cannot use the sort accessible from the toolbar or right-click menu option to sort custom groups. The Metric Qualification dialog box opens. The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it gives the ability to create several mini-reports inside a Report. This feature is similar to what we see in. To Modify Permissions for an Object in MicroStrategy Web. This 'Top 10 Customers vs All' custom group will have two elements. Click Advanced, then New to create a custom subtotal. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. Create a report with Year, the Region consolidation, and the Profit metric. Derived element groups are defined by a list, filter, or calculation. The schema looks like the following diagram. The report is showing the correct results: Next, I created a Custom Group as follows: Now, add this custom group to the report and remove the Subcategory. MicroStrategy AI is here. A custom group is a set of filters that can be placed on a template. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. Custom groups enable users to view specific elements based on a metric or specification. Yes. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. Follow the steps below for an example of how to do this. Enable Subtotals and enable a basic total. Open the custom group editor and drag an object from the object browser to create a custom group. Place the newly created consolidation in the template. new_customgroup_name is the new name of the custom group, of type string, between double quotes ("). Consolidations are used to specify the data that you want to view in your report. The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it. The 'Select Objects' dialog box opens. You can rename the. 5K subscribers Subscribe 3. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default VLDB Properties for Hive 0. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Business Consolidation: The consolidation of several business units or several different companies into a larger organization. The Configure Transactions Editor opens. Say you have product group A, product group B, product group A+B. Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. 4. This tool is known for its flexibility and speed of data study without losing on. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. Add a condition to a custom group element. The Consolidation Editor contains the following sections: The left pane contains an element list that includes the consolidation element you add. These auto text codes are automatically replaced by information about the document. Invoke the MicroStrategy Integrity Manager executable MIntMgr. However, it is not expected to see a metric value corresponding to the Custom Group. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. It is made up of an ordered collection of elements referred as custom group elements. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. The Custom Group Editor appears. 743,656 professionals have used our research since 2012. This is caused by subtotals for the custom group object being disabled at the report level. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. The report displays derived elements defined using. The abundant design options deliver full control over position, formatting, and interactivity. Relate tables are often used to create relationships between attributes. Updated: November 2023. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. 3. cache; com. Change the formatting of the values to have different colors. In MicroStrategy Web, edit or execute a report. Why MicroStrategy Why MicroStrategy; Customer StoriesThe user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. Step 1. Also, a percent-to-total derived metric has been added to the report using the Insert > Percent to Total > Over Rows menu option, obtained by right-clicking on the metric whose percentage is desired. The settings are numbered 1-5. For example you can determine Top 20 customers, report the revenue of all customes with M, and add some regional figures in a single custom group. The metric value of the first element (which is already the total of the individual items in the element) is added in the Total Subtotal displayed in the grid report. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. ALTER CUSTOMGROUP "My Custom Groups" IN FOLDER "Public ObjectsCustom Groups" NAME "Modified My Custom Groups" DESCRIPTION "Modified Copy of My Custom Groups" FOLDER "Public ObjectsCustom GroupsModified Custom Groups" ENABLEHIERARCHICALDISPLAY FALSE ENABLESUBTOTALDISPLAY TRUE. Adding consolidations and custom groups . To apply the same tooltip to every item in the graph, select the Labels and Values category. Examples of this category are simple mathematical. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The Custom Group Editor appears. Mastering Business Intelligence with MicroStrategy. We will explore two objects that serve this purpose: Custom Groups and Consolidations. Find an event in a city near you. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Custom groups are used to apply different filters to different rows. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. Problem. Select Data > Report Data Options. Asked 4 years, 11 months ago. For example - We need to see a…Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. Group 1: Atlanta, San Diego, Berlin and San Francisco. How MicroStrategy empowers you to design and deploy compelling, responsive Dossiers suited for all audiences and devices in under a day Speakers: Amy Laresch, Product Manager, MicroStrategy; Keng-Fu Chu, Principal UX Designer, MicroStrategy; Jeff Courcelle, VP of UX Design, MicroStrategy; Julia Zhu, Sr. Reports that contain B or C will ignore filters on the other. microstrategy. Connect to and interact with the MicroStrategy environment. Add this custom group into a report and select 'Yes' for the Allow Subtotals column under the Report Data Options function. 6 and later) Installation Instructions. There are three types of objects: schema objects, application objects, and configuration objects. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. ). Video Tutorials. Custom Group Editor. Syntax . blogspot. KB46734: In MicroStrategy Web 9. From the Schedule drop-down list, select a schedule or event on which to deliver the report or document. Derived element groups are defined by a list, filter, or calculation. An object is a basic building block in MicroStrategy. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. How MicroStrategy empowers you to design and deploy compelling, responsive Dossiers suited for all audiences and devices in under a day Speakers: Amy Laresch, Product Manager, MicroStrategy; Keng-Fu Chu, Principal UX Designer, MicroStrategy; Jeff Courcelle, VP of UX Design, MicroStrategy; Julia Zhu, Sr. microstrategy. 9K views 4 years ago MicroStrategy In this video I will discuss. Derived elements are available only from MicroStrategy web. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. Follow the steps below in order to reproduce this scenario using MicroStrategy Tutorial: 1) Create a consolidation using the Call Center attribute elements: Group 1: Atlanta, San Diego, Berlin and San Francisco Group 2: Washington, DC, Salt Lake City, Miami and Milwaukee Group 3: New Orleans, Seattle, Boston and New YorkOn the MicroStrategy side you could create a Custom Group with an element for each Dept, except for Dept 2, Dept 1 and Dept 2 will be part of the same group. microstrategy. From the File menu, click Open. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. A custom group is made up of an ordered collection of components called custom group elements. Microstrategy Dossiers With the release of MicroStrategy 10. Refresh. If the quarter attribute is removed from the template, all custom group elements are displayed, with empty metric values for the custom group elements that lie outside of the report filter. A consolidation is a set of attribute elements grouped in a way that they were not originally grouped within the project, so that you can use the consolidation (the newly consolidated elements) just like a regular attribute on a report. Mastering Business Intelligence with MicroStrategy; Credits. Learn more. The Document Properties dialog box opens. Watch this on-demand webinar to learn why MicroStrategy Workstation is such a valuable tool and how you can leverage it as a one-stop shop for operating and administering your MicroStrategy ecosystem. Split Hierarchy with M-M relationships: Explanation. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. It queries SQL databases. Click the Options icon . If an environment does not already exist, an environment will need to be created first. For example, the report below contains Region, Category, and Profit. West = Northwest, Southwest. Open the Desktop Window with the Navigation pane in Smart Mode. In the Calculations - Subtotals window, Select the desired Custom Group and select Yes in the Allow subtotals drop down. Run the document on iPad, as shown below: 12. Copy the code for the D3 visualization you are using. Consolidations vs. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. comA selector can change panels, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack. comArchitects can now do more with MicroStrategy Workstation. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. Step 7) In the next screen, Enter Field Status Groups for the Field Status Variant. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs. The following table summarizes the similarities and differences between consolidations and custom groups. 0). Dashboard performance troubleshooting in MicroStrategy 10. A user may have a report with a custom group/consolidation and attributes and want to return the total within each custom group/consolidation element. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. We will explore two objects that serve this purpose: Custom Groups and Consolidations. Consolidations allow you to qualify a report on a row-by-row basis. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. An object is a basic building block in MicroStrategy. A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. {&GROUPLABEL} Name of the graph item's category. In general, a user specifies a list of conditions and corresponding return values. 2. Consolidations Homepage Consolidations, custom groups, derived elements, derived attributes and attribute groups are different methods in MicroStrategy to allow. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Microstrategy - how to create a custom group with boolean band. Microstrategy Dossiers With the release of MicroStrategy 10. Custom groups allow for unique aggregations of data elements and bands to provide a way for business users to analyze data in groups that do not exist in the original data source. Fu nction Types. Fact table levels: The context of your data. From the Visualizations panel, select Grid . We need to establish a consolidation route for each transport layer. Go to project configuration by right clicking on specific project (You need admin rights to do this). Edit the custom group "Top 5 Contributors vs. 1, custom group selector does not have the custom group elements, while in 9. Click the name of a custom group element and type a new name in the field. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. This option is only available for alerts sent to email addresses. The fuel for business dashboards is data, so each one needs to have one or more data sources. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. Sankey diagrams visually emphasize the major transfers or flows within a system, helping users locate dominant contributions to an overall flow. DEFINITION: This custom group is a custom group banding qualification created on the metric, with band size banding type and a step size of '1' (integers). In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. Enable hierarchical display for the custom group. CSS ErrorAnswer You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. Experience. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. A custom group is made up of an ordered collection of components called custom group elements. The image below shows how the East Coast group derived element is created in the Derived Elements Editor: We provide industry standard online training on MicroStrategy Development , Administration and live project development with hand-holding support of expert t. blogspot. The essential distinction is that consolidations work with attributes and custom groups use filters. com A selector can change panels, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. The numbers above the scale represent the minimum and maximum axis values. 9K views 4 years ago MicroStrategy In this video I will discuss when you should use a. Data can be connected through an API, flat file, or database. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews while Tableau is ranked 2nd in BI (Business Intelligence) Tools with 48 reviews. 1. Using the. 2. Definition. Custom Group or Consolidation? - MicroStrategy James Oliver 10. For detailed steps to define a condition, see Condition Editor. Both products' features range. 1031 views | July 14, 2020 56:15. The following is a quick reference table for a MicroStrategy Custom Group: A Custom. Source: MicroRooster. A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. KB42896: How to grant privileges to a user, user group or security role using MicroStrategy Command. In the list of categories on the left, click Subtotals. Report will display result as below. Right-click on an existing environment and choose Properties. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. A custom group element is a logical expression of qualifications. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Enter a name for the custom group in the Enter Custom Group Name Here field. ) A subtotal lets you see the. objects that you can place on a report template. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Viewed 13k times. certificateOn the Graph menu, choose Preferences. The Condition Editor opens. September 22, 2023. For this class,. simply a grouping of attribute elements is called Consolidation. The. MicroStrategy is a data visualization tool. Click "Add Photo" and select photos to upload.