Dossiers automatically adjust to look great on any screen. LOGIN? User name. The following table lists folders and files of interest that are included in the default directory structure after an installation of Enterprise Manager. The target visualizations only display data that also appears in the source. Then, select a page from a different dossier that you want to filter as the target. Using this tool, users can easily transform big data into instinctive dashboards and reports for greater. Possess strong expertise in day-to-day. - Managing a globally distributed development team. get the SQL and execute directly in DB. The summary tabs provide information like Sales, Cost, Profit and Profit Margin, and overview of how all regions are performing along with monthly trend in spark lines. NOTE: This only works on Visual Insight dashboards with at least 2 datasets. The MicroStrategy Capacity Testing Tool is a client application which connects to deployments of the MicroStrategy platform (specifically, MicroStrategy Web and MicroStrategy Library if available) and runs a user-defined set of end-to-end performance tests on content. Additionally, this role will assist in the design and construction of relational. 8. Developed a dashboard using MicroStrategy for analysing various places in India and concluding which place is the most suited for setting up a steel manufacturing company as per the clients’ needs. 2. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. Video Tutorials. If possible, instead of using lookup transformation use join in the database. Right click on the “Test Plan” and add a new thread group: Add -> Threads (Users) -> Thread Group. Home: 000-000-0000 | Cell: 000-000-0000. The first step of the cycle is to quantify the performance by measuring the time spent in each of the components that are part of a Document Execution Request, as described in the preceding sections. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data into multiple. Here are a few cons to determine Power Bi vs MicroStrategy which one is better; Microsoft Power BI. Now that users have the appropriate tools and knowledge, you can start holding them accountable to performance thresholds. Please try to see the SQL of the report and the SQL in the database and try. •Collaborating with business analysts and stakeholders to understand business requirements and translate them into technical solutions. In the edit site dialog, check the allow performance recording checkbox and click OK. Publishing reports and dashboards. Referrals increase your chances of interviewing at IDESLABS PRIVATE LIMITED by 2x. For each source, you can see how many reports/documents used a cache, how many used an Intelligent Cube, and how many used an external data source. First, define one visualization as the source. Referrals increase your chances of interviewing at IDESLABS PRIVATE LIMITED by 2x. Microstrategy Developer. Based on verified reviews from real users in the Analytics and Business Intelligence Platforms market. Significantly improves user-perceived query performance. Microstrategy Developer Resume. IBM Cognos is a BI tool that allows its users to create, manage, and visualize activity dashboards to present, track, and analyze relevant data for the company. Use Database function instead of MicroStrategy provided function 11. Connectivity between I-Server, Web-server, Database server and. On the other side, Microstrategy offers easy blending and linking to different data sources. Create Dashboard on existing SSAS Cube; Distribution Services; Ad-hoc Reporting; Multidimensional Reporting using OLAP Services; Write Back using Transaction Services. email@email. • Experience in analysis, design and implementation of BI applications using MicroStrategy product suite. 19. Lead the design and build of dashboards, visualizations and analytics. Throughput*: The maximum rate that something is processed. if it’s take less time then you’ll have something to do with MSTR or fine tune DB SQL with the help DBA. This certification demonstrates an individual’s ability to identify and resolve performance bottlenecks, as well as provides best practices for improving. However, the SQL used to execute the report can still be viewed and obtained. Professional Summary. Platform Analytics is a monitoring tool that captures real-time data from the MicroStrategy platform, and uses this data to enable smarter administration and provide a better experience to your MicroStrategy users. chartercom. Architect. 612 Advanced Big Data Administration 2022. 8+ years of Professional experience which includes Design , Technology and implementation of MicroStrategy applications with competence within creating Attribute , Tatsachen , Template , Filter , Prompts , Metric , Reports , Related and Dashboards using MicroStrategy 10. MicroStrategy 9. The key features of MicroStrategy platform are – Interactive dashboards in MicroStrategy; Includes. A user-friendly drag & drop interface empowers everyone to make sense of complex data by asking important questions and receiving answers immediately. It offers an intuitive way to create and modify BI. Creation and Design of OLAP databases and Datamarts. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. MicroStrategy Capacity Testing Tool Capabilities and Restrictions. You have to consider the performance tuning of your data source. Google Looker Studio: Best for Data Sources. When we place some. Generate Oracle AWR report or monitor the database to identify the low performance query. Get inspiration at the MicroStrategy data dashboard gallery. MicroStrategy Analytics. Tuning. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the dataPowerBI Dashboard. for Software update and setting up the features in the reports. MicroStrategy Course Overview. Answer: Go with dossier. MicroStrategy is one of the most widely used business intelligence and data analytics platforms in the world. Additionally, the custom number formatting and advanced threshold editor allow us to use colors and symbols to create a richer grid presentation. Transferred the document to the operation team to upload and schedule mappings to the production medium. Job Description. Performance tuning is always depends on the system and the users. Performance tuning and troubleshooting You are a MicroStrategy administrator who wants to manage the • Tuning Linux MicroStrategy Analytics platform in a Linux environment • Tuning MicroStrategy Web and application servers Best class experience if you have • Tuning Intelligence Server 10. 2. Our specialists can help your business stakeholders and implementation team at every phase of your data warehouse project and provide subject matter, industry and technology-specific expertise. Documents and Dashboards for MicroStrategy Report Services: MicroStrategy Report Services: Documents and Dashboards - Ebook written by MicroStrategy University. Design and maintain database enterprise assets. Adding External data from various sources to create dashboard. Then, select a page from a different dossier that you want to filter as the target. From vehicle diagnostics, data logging,. Developers gain tuning insights to improve project performance. Microstrategy Developer Resume. The tool brings together previous Data Studio features with Looker’s new business intelligence. The first step the MicroStrategy Intelligence Server does after having executed the separate datasets present in the Report Services Dashboard is to create a Virtual Dataset. If installing over previous versions of the product, the folder remains the same. Report distribution is automatic. – Extensive experience developing reports, dashboards, and cubes in MicroStrategy latest versions. I have created Free Form SQL Reports, RS Documents & Dashboards, and done performance tuning and testing of MicroStrategy reports Created Metrics , level metrics, Object Prompts and other prompts. Users may design, generate, and alter reports, dashboards, and data models with this tool. MicroStrategy Workstation Become a More Intelligent Enterprise Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Iterate quickly on new feature testing and maintain seamless app performance for users, enabling data-driven workflows wherever people are. Expertise in developing Public objects (metrics, filters, prompts, Custom Groups, and Consolidations). The New Grid dialog box opens. Tableau developers in the real world are constantly trying to balance dynamic interactions, data granularity and fast performance that keeps users in the “flow” of. Boston, MA. Start by deciding the rules that work for your. Learn our Microstrategy Training to master yourself in building reports and dashboards using MicroStrategy from scratch with hands-on training from real-time experts. After having built a DHTML dashboard following the XML generation techniques, if the usage of a large grid cannot be avoided, disabling the automatic resize option for MicroStrategy Web may improve the rendering performance significantly. Use extracts connections wherever possible to improve performance. Apply security restrictions on users and objects. Responsibilities for microstrategy developer. x. Dedicate a machine for the metadata repository. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Views 1543. A highly driven developer, experienced in Microsoft Business Intelligence technologies like Power BI, SQL Server Data Tools, and MS SQL Server Reporting Services, and well-versed in Azure SQL Database and Azure Data Factory. Creating reports by combining report objects and perform unit testing. MicroStrategy experts discuss how you can use dashboards to allocate funds while analyzing metrics and state. it should be large enough to process it quickly. MicroStrategy Analytics cubes are easy to create and deploy. In addition to this, you need a plan for tuning the system. This is a Department of Energy (DOE) computer system. Visa:-Any. Scalability and High Performance with MicroStrategy 10 Enterprise Analytics and Mobility at ScaleThe first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Creation and Design of OLAP databases and Datamarts. It helps store chains to implement the service, set up reporting, analytics and planogramming processes. Experience creating complex reports in MicroStrategy according to the software development lifecycle. Change Management. Use Cartesian Products Wisely 12. Designing and developing Power BI dashboard and visualization. Our approach, outlined below, reduced the time it takes to render Dashboards to less than • In legacy Dashboards, calculations for forecasting were executed on the MicroStrategy server. WeExperience administrating MicroStrategy including permissions, security, performance tuning, and troubleshooting. Creation of Metrics, Prompts and Filters as per the requirements. From performance tuning point of view, the SQL pass option should be. A document or dashboard can contain data from one or more MicroStrategy reports. 5+ years of experience in Snowflake. Top quality and performance automotive tuning. The speed-up may not always be linear like that, but you get the idea. 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. IBM Cognos is ranked 7th in BI (Business Intelligence) Tools with 17 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Expert data skills, including complex queries, performance tuning, expertise in a variety of approaches (e. RAC and ASM. execute in database then try to improve the performance in the database by. Financial Analysis Dashboard by Infocepts. It has user friendly interface. Details of Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. Introduction to Dossiers. The performance suffers when querying large data sets if compared to Microstrategy for the same. However, DirectQuery can be combined with Import Data to boost the. For detailed information about increasing system. Browse and incorporate these templates into your own data dashboards. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. As database joins are faster, performance will be increased. Worked on Production issues. it should be large enough to process it quickly. The next step is to choose your data sources and metrics. g. Some of the key features of dashboard software include data integration, data visualization, customization, interactivity, and real-time updates. Building, publishing customized interactive reports and dashboards, report. Visit the data visualization and data dashboard galleries for inspiration. 18. Right-click on a dossier. 1. SQL Server Index Maintenance and Performance Tuning for Large Tables; Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability. • Designing and developing MicroStrategy reports, dashboards, and scorecards for. should the software or documentation prove. highly formatted documents, scorecards, and dynamic dashboards. MicroStrategy offers a lots of built in manipulations for the users that can directly be performed with the help or URL. Tableau offers a user-friendly interface and intuitive drag and drop functionality, to create interactive and visually compelling dashboards and reports. Analytics Performance Tuning Knowledge Certification. Built on the open and flexible architecture of MicroStrategy Report Services™ as Report Services Template (RST) files, templates provide a quick and intuitive method for designing. • Performed performance tuning of reports/cubes using MicroStrategy VLDB settings • Adhered to MicroStrategy Design best practices and organizational guidelines and processes Jr. Mstr uses metadata to translate user request and this definition is used to create SQL queries using SQL Engine. Change the data of the report and re-execute it. They provide a good web-based environment to manage metadata and build out calculations and filters, which help improve self. Microstrategy Developer. Clean up your workbooks! Reduce dashboard scope. This dashboard helps Regional Managers to analyse large and complex sales data quickly and easily. Administrative access to the OS is required to modify system parameters. This article describes best practices to be taken when using an Oracle database of version 19c in MicroStrategy with DDA mode. We’re here to help you align the future of AI/BI technology with your company vision. making, and better financial performance (see figure 2). MicroStrategy software is a top-tier platform for business intelligence (BI), mobile software, and cloud-based services. filters, custom groups, consolidations, reports and documents), performance tuning, optimization of intelligent cubes and. STEP 1: Enable the MCE trace. The idea is to make faster line-of-business decisions with easy access to information, including performance and sales metrics. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. As shown below, this RS dashboard contains an area graph for daily revenue, a grid report for category analysis, and a bar graph for subcategory revenue. 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. x. good title and noninfringment, quality or accuracy. This 3-day PL 300 Course: Power BI Data Analyst training will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. , UNION, INTERSECT, EXCEPT). Power BI Mobile is an app for viewing and interacting with reports and dashboards on smartphones and tablets. 1. 9 million during the first quarter of 2023, compared to $170. In MicroStrategy Web 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. This document is intended for MicroStrategy customers who are High Performance Tuning -- A methodical approach to tuning MicroStrategy software for maximum performance, including all components of the BI ecosystem such as relational database management systems. This RS dashboard provides a company-wide view of revenue and performance. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Providing technical support services to clients in diverse capacities, technologies and functions - leveraging experience. Dashboards that inform the category manager by monitoring spend, assessing. Location:-Media,PA. MicroStrategy Platform Analytics Help. Analyze the low performance query using DBA knowledge, add. You can use these reports and dashboards to make decisions about tuning the MicroStrategy system or identify problem areas. As we know, the two key factors which decide the success of BI application software implementation are. Below tuning suggestion is based on IBM Document on Performance Tuning. Dashboard Business Intelligence. To fine-tune your data, we need to examine the data elements in our control–namely data size, data complexity, and data shape–while ensuring we can answer the questions that the dashboard intends to solve. good title and noninfringment, quality or accuracy. Use Aggregate. Over 96 percent of Power BI users say the speed drains their resources. ANALYST VIDEOS & TUTORIALS. Also, it is recommended to limit the size of a grid to 500 cells to be displayed on the page in DHTML mode. The file contained in the Block provides detailed information on all of the. Learn dashboard basics. MicroStrategy Analytics cubes are easy to create and deploy. Access to technical expertise for performance tuning, data analysis etc. - Support the team in creating reports and dashboards with MicroStrategy and PowerBI. Experience in delivering reports, metrics, and dashboard solutions against BI specificationsExperience in Power BI, Tableau,MicroStrategy, Python and. Once the best combination is determined, admins can test the deletion and see if the performance improves there. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. . 1 Certified Dashboard and Mobile Designer (CDMD) MicroStrategy Issued Nov 2016. General hardware recommendations. Mostrar menosSectors. In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget. Allows the holder to build dashboards and visualizations based on a dataset provided by colleagues. If the report takes 2 min to. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Use Aggregate tables. Hide unused and confidential data items. Password. - Platform Migrations - New implementations - Maintenance and management of the MicroStrategy platform: best practices definition, deployments, users and privileges management, security filters and configurations, platform tuning using VLDBs, usage and performance monitoring, version upgrading. Check Capterra to compare IBM Cognos Analytics and MicroStrategy Analytics based on pricing, features, product details, and verified reviews. Developers gain tuning insights to improve project performance. Excess worksheets on a dashboard can impact performance. How to Create Dashboard Report in MicroStrategy, Step by Step? Suresh. 14. All articles. Energy Jobline الجبيل. Our approach, outlined below, reduced the time it takes to render Dashboards to less than • In legacy Dashboards, calculations for forecasting were executed on the MicroStrategy server. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. Workload Management. MSTR_MEM_CACHE_AUTO_CONFIG=1. Highly accomplished and creative Microstrategy Developer with deep experience in all aspects of software development. Step 4: Enforce Governance Rules. 1 million in the first quarter of 2022. in MSTR, go to project config, increase the project memory settings. To view shared dashboards, the Snowflake user must use the same role as the session context for the queries that drive the dashboard. Clustering Option enables higher system availability and faster performance through load balancing and automatic failover. Experience inETL Data Warehouseenvironment. 574. A line chart with KPIs can display multiple data series at the same time and automatically calculate the difference rate. Have experience working with outstaffing, outsourcing, and product companies. get the SQL and execute directly in DB. MicroStrategy Dashboard Templates facilitate dashboard design by providing you with preformatted customized templates. , relational, dimensional, unstructured). Receive data-driven alerts based on specified conditions. In my mind, there are 4 main areas where there might be a slowdown: Data refresh. Willing to learn and hard working person happy to face new challenges and. • Connectivity Wizard Support for Snowflake • ODBC & JDBC drivers shipping OOTB. The Performance Analysis dashboard provides information about the past week of report and document requests from various sources, such as Developer, MicroStrategy Web, or Distribution Services. ExistBI Oracle DBA Services help you manage, maintain, and optimize your critical Oracle systems. Department of Energy (DOE). You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. MicroStrategy Web. Everything else. STEP 1: Enable the MCE trace. When you start a project using MicroStrategy with Oracle as warehouse at a very beginning state, please consider below constructions step by step for project. <br>- Strong personal communication, leadership, and organizational skills,. 4. Architect. Direct OLAP connection with the help of ODBO connector using MDX language connects directly to the SAP HANA. Summary. MicroStrategy Web. In this section, we will walk through some of the techniques applied to the warehouse to boost performance. For all other outputs, MicroStrategy Office, MicroStrategy Web in DHTML mode and MicroStrategy Web in Flash mode the Intelligence Server generate XML. Bengaluru, Karnataka,. MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, The MicroStrategy project used for the testing purposes of “1:1” modeling approach consisted of 5 dashboards using 15 reports in total as their data sources, adding up to around a total of 3000 lines of SQL. create a derived metric named "Metric Selector". However, since MicroStrategy deployments will typically rely on third-party components, several component-level settings may be outside the scope of MicroStrategy Technical Support but will nonetheless effect MicroStrategy. Have experience working with outstaffing, outsourcing, and product companies. Worked directly with End users to determine requirements. Activities included product implementation, configuration and upgrades as well as report and dashboard development, data modeling, schema architecture, requirements gathering, scoping, performance tuning and monitoring, and product training. To troubleshoot performance issues, users must identify. For example, instead of a single dashboard that takes 60 seconds to load, break it into two dashboards that can each load in 30 seconds. Common KPIs include revenue, cost, number of sales, profit margin, and. Step 1: Open a dashboard sheet: select Dashboard from menu, then New Dashboard Step 2: Add views to your dashboard by dragging sheets onto the dashboard. Create an index for the column in a lookup table which is used in lookup condition. Operating expenses include impairment losses on MicroStrategy’s digital assets, which were $18. guaranteed peak performance in pace with the changing needs. N/A. Always consider to collect database statistics as the query execution plan is generated based on that. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a. likes. A dossier is an interactive display that you can create to showcase and explore business data. Create new reports based on the customer requirement. Experience in delivering reports, metrics, and dashboard solutions against BI specificationsExperience in Power BI, Tableau,MicroStrategy, Python and Alteryx. 6% decrease compared to the first quarter of 2022. MicroStrategy - Effective Business Dashboards MicroStrategy Nederland. Finally in version 9. For. 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. Use Case 4. 4. ExistBI’s extensive industry and technology-specific knowledge, project implementation experience, and training and support services enables it to be a critical partner for clients looking to meet data. Brytlyt’s accelerated database technology and deep learning platform enables users and businesses to extract value and insight from data. 118 MicroStrategy Education: Dashboards and Data Discovery 10. Dashboard performance troubleshooting in MicroStrategy 10. KB3859: How to use the sub query VLDB setting to optimize performance for attribute relationship filtering. With its enterprise-grade performance and scalability, MicroStrategy makes it easy to use and provide great value. 9 and 79 million rows in the. Objective : Micro Strategy professional with almost 7+ years of result-driven experience in Data Modeling, Designing, Architecture Data Warehouses and BI applications in diverse industrial sectors like manufacturing, pharmaceutical, banking, retail and insurance. Accomplished System Optimization, Performance Monitoring, and Tuning in MicroStrategy Business Intelligence environment. Jr. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected. The aim of this KB is to have a look at the Live connected intelligent cubes performance considerations as it’s necessary to understand how many steps are involved in the process, of course each step consumes time, hence the more steps the more time will take a dossier to. Development products to build business abstraction objects in the metadata: MicroStrategy Architect and Desktop. 068 System Administrator: Planning and Optimizing the Analytics Infrastructure 2022. In my opinion, MicroStrategy has a better product architecture. MicroStrategy World 2022 Analytics Keynote Address. RM Performance Dyno Tuning, Pakenham, Victoria. this is the memory MSTR uses for worker set. x releases, and the new Multi-table Data Import (MTDI) cubes. This will only color every other row of your grid. 9 million during the first quarter of 2023, compared to $170. 3/9. As analytics professionals, we encounter several challenges when we develop enterprise dashboards, scorecards, or mobile BI applications. MicroStrategy use TLS v1. It is still far from being an enterprise solution. In-Memory Analytics Guide for MicroStrategy 10 OLAP Services Guide for MicroStrategy 9. Hee-Wei Tan (Inactive) · 5月 1, 2017 ·. Confidential Responsibilities: Served as Primary Micro Strategy developer for the full lifecycle of the data warehousing project from requirement gathering from business analysts to rollout. The following topics lay the foundation for the specific tuning guidelines that make up the rest of this section. After bottlenecks have been identified, certain component-level settings can be adjusted to optimize performance. A billing manager can see data in a report called Invoice Statements by Selected Customers, as well as a customer-level transaction detail report. Since the lookup table will be queried for looking up the matching data, adding an index would increase the performance. to improve it by reducing the number of passes created by the report. Browse and incorporate these templates into your own data dashboards. With this new release, R and the R Integration Pack are. Multiple certificates on Microstrategy platform and on hand experience on delivering project to clients around the globe. Instructions on using Enterprise Manager to create reports and dashboards for. Got experience in building Data Models & interpretation. With the help of this we can link MicroStrategy reports with other reports or from other system. Istanbul Metropolitan Municipality BI &. MicroStrategy Analytics delivers reports and dashboards, and enables users to conduct ad hoc analysis and share insights anywhere, anytime, via mobile devices or the Web. This is a guest blog post co-written by Amit Nayak at Microstrategy. The following table summarizes the test results of some test scenarios against Oracle 19c. • Oracle DBA 10g/11g/12c: 10 years with extensive experience. • If the final dashboard relies in the use of many objects and retrieves a large amount of data, efforts should be made to split one dashboard into multiple smaller dashboards. 6-9 years of experience as MicroStrategy Developer in building reports and dashboards. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice. KB440585. This Microsoft Power BI training will also show how to access and process data from a range of data sources including. Datadog is a SaaS platform that includes system monitoring tools. Browse and incorporate these templates into your own data dashboards. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. After having built a DHTML dashboard following the XML generation techniques, if the usage of a large grid cannot be avoided, disabling the automatic resize option for. It targets end-users and business. to improve it by reducing the number of passes created by the report. To troubleshoot performance issues, users must identify these components, then make the appropriate modifications to the environment and/or to the MicroStrategy dashboard to reduce.