When you enable these traces, be sure to enlarge the size of trace file to >20MB. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. de 2007 - mai. Creating and modelling advanced MicroStrategy Schema layers, including setting up joins, hierarchies, logical tables etc. MicroStrategy 2021. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. For example, if you are presenting data related to a company's financial performance, you may want to use green to represent positive growth and red to represent negative growth. Diagnostic Analytics. The impacted index sorting are basically Integer operation, and based on information online, MicroStrategy 2021 Intelligence Server is 25+% slower than MicroStrategy 2020 Intelligence Server. Logical Size in Microstrategy: Starting in MicroStrategy 2020, you can use a visualization in one dossier to filter data in a different dossier. MB. If you use Enterprise Manager, dedicate a machine for the Enterprise. Tuning. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. 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. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a. MicroStrategy 2021 can take advantage of Arrow format provided by Snowflake which can help improve the performance for customers. If you click Regional in the Select View button bar, another RS dashboard is displayed. Jan 13th, 2017;. • Involved in understanding and transmitting the business requirements for the project and. New features include data import, reusable dashboard and mobile apps, expanded mapping capability, and more Mobile enhancements. And, best of all, the. When you add a panel stack to a document, one panel is automatically added to the panel stack. • Implemented Oracle BI 12c, to create dashboards, KPI. AMD Software: Adrenalin Edition features performance tuning presets for the AMD Radeon RX 6800 and RX. 414 Designing Metrics for the Intelligent Enterprise 2021. 10. →It may take long time until the loading finishes and the dashboard is correctly displayed. 3. Bengaluru, Karnataka, India. This article will not discuss the hardware recommendations. New features include data import, reusable dashboard and mobile apps, expanded mapping capability, and more Mobile enhancements. Industry: Finance (non-banking) Industry. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. KB440585. Step 3: Copy the tracking code provided by Google Analytics. Views 1540. MicroStrategy Logical Data Model Tuning to improve report performance. x and newer. Ad hoc query. create a derived metric named "Metric Selector". Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Croatia Office. Reports. Microstrategy Dossiers With the release of MicroStrategy 10. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. To improve. To make this easier to design, you can use a panel stack, which is a collection of panels. 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. Client rendering time greatly relies in the amount of XML that needs to be parsed. 11. 3 million, a 56. Every step along the way matters. Since the Quick Search indices make use of the Change Journaling data, they can easily update their existing indexes based on this data instead of having to do a full table scan. Questions from 25/8/2014 Also study [summary metric qeustion] f(x) and E - this will be on the exam. 963. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Get inspiration at the MicroStrategy data dashboard gallery. Views 1543. to improve it by reducing the number of passes created by the report. - Full life cycle implementation encompassing. The idea is to make faster line-of-business decisions with easy access to information, including performance and sales metrics. SUMMARY: This technical note is part of How to troubleshoot Dashboard Performance document that can be found KB4100-812-0001You can use the Enterprise Manager reports and dashboards out-of-the-box, or you can modify the reports to return exactly the data you want to analyze for your MicroStrategy environment. With the release of MicroStrategy 10. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to. In the past, this is the usual thing we do in Command Manager. Their network traffic management product features MicroStrategy Dashboards for reporting. Willing to learn and hard working person happy to face new challenges and. Key performance indicators are the metrics most important to users. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. For tuning details, see the appropriate section in the Installation and Configuration Guide. When expanded it provides a list of search options that will switch the search. The ID of the Job would be useful in order to read the job trace. This information can help you determine where database tuning can be adjusted to improve overall query and reporting performance of your MicroStrategy project. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Start your new career right now!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. MicroStrategy Desktop: This Windows-based application is designed for report designers and analysts. These kinds of filters. The third most common microstrategy developer skill is templates on 5. Our customer is a leading network management solution provider. 2 by default. Data Management. Acibadem shared details on their MicroStrategy dashboards and HyperIntelligence cards. A dashboard is made up of multiple visualizations. swf file makes subsequent calls to download the definition of the Dashboard, the data and flex settings. Dedicate a machine for the metadata repository. Marktine Technology Solutions Pvt Ltd Dubai, Dubai,. It shows many attributes grouped into separate visualizations. <br>Currently a. Data quality. Adding External data from various sources to create dashboard. 3. Linking Different attributes. The XML generated to transport data and Dashboard formatting information is generated using a tree of nodes, as any other XML file, in order to separate the different sections and pieces of. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. If database and MSTR both. 068 System Administrator: Planning and Optimizing the Analytics Infrastructure 2021. This course. Then, select a page from a different dossier that you want to filter as the target. Search and apply for the latest Microstrategy developer jobs. - 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. Migrated dashboards from Power BI, Microstrategy, and Cognos into Tableau. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. 262KB. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Every MicroStrategy BI application requires at a minimum: 1. Publishing reports and dashboards. The key features of MicroStrategy platform are –. The target visualizations only display data that also appears in the source. 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. Get inspiration at the MicroStrategy data dashboard gallery. Click Next. For all other outputs, MicroStrategy Office, MicroStrategy Web in DHTML mode and MicroStrategy Web in Flash mode the Intelligence Server generate XML. SDLC implementation using Object Manager, Integrity Manager and Command Manager. Click edit. Metadata is a relational database that contains information to facilitate the transfer of data between Data warehouse and Microstrategy. The DWS exam focuses on topics. Ultimately, it. Back then, the dossier editor (formerly known as Visual Insight) was a powerful BI tool with limited design functionality. Dashboards, on the other hand, also provide key metrics but tend to summarize business intelligence information more widely. com. Familiar in Design and development of MicroStrategy Reporting documents and interactive Mobile Dashboards for tuning and optimization of. MicroStrategy Optimization: VLDB Settings. To log in to a specific project, see Starting MicroStrategy, page 2. Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. Dossier Design, Hyperintelligence and Transaction Services Development. In the Source area, select a database instance for the database to access using Freeform SQL. 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. AMD Software’s One-Click Auto Overclock feature is a simple way to get more performance out of your AMD Ryzen™ 5000 Series Processor and AMD Radeon™ 6000 Series Graphics Card. Bengaluru, Karnataka, India. This information can help you determine where database tuning can be adjusted to improve overall query and reporting performance of your MicroStrategy project. A clean workbook is a happy workbook. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. Design and maintain database enterprise assets. IBM Cognos vs. Architect. If installing over previous versions of the product, the folder remains. 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. MicroStrategy’s In-memory technology is engineered to meet the. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. This technical note is part of How to troubleshoot Dashboard. Now offering. Required Status to Perform Action. 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. When it comes to Microstrategy vs PowerBi, here are the main aspects: There is a possibility to use MicroStrategy as a source in Power Bi report, which is a powerful Microstrategy tool. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Add the data to a graphical representation, such as a bar graph or pie. Cube advisor This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. 6-9 years of experience as MicroStrategy Developer in building reports and dashboards. execute in database then try to improve the performance in the database by. However, Intelligent cube publishing performance may be affected with the agent enabled. With this new release, R and the R Integration Pack are. You can follow online guru for important updates. It is based on a single data repository strategy, whereas Cognos has two metadata repository and database-based. 12/2008 - 03/2013. The default. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. Hi, The report can be tuned. The following topics lay the foundation for the specific tuning guidelines that make up the rest of this section. Each and every layer matters, and one can encounter different. 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. Please try to see the SQL of the report and the SQL in the database and try. A tableau developer creates computer system and data visualization solutions to improve business procedures. To get a sneak-peak of new functionalities. Microstrategy Web Visual Insights . Browse and incorporate these templates into your own data dashboards. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. Capture8. Designed services and dashboards in MicroStrategy. Get inspiration at the MicroStrategy data dashboard gallery. • 30% Performance Improvement with Lookup Cube Caching. Do step 4 again to create dashboard again. Create a dummy drill map with only 1 attribute. Plus, our specialists will share tips and tricks to help you avoid common pitfalls and troubleshoot issues that can impact performance. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Sources include cloud databases, data warehouses, physical access systems and web applications. The selections a user makes when using selectors with Report Services Documents in MicroStrategy Web 9. 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 bottlenecks. Right mouse click on the report and choose to create dashboard. Power to Dominate. However, these settings depend on the type of SQL being sent to the warehouse, database load, and dataset size. 0 is a major version after Apache kylin 3. As we know, the two key factors which decide the success of BI application software implementation are. Views 1543. performance tuning of pitstop to minimize the data and rendering refresh cycles and optimize the end user experience. Inserts a panel stack. 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. The default value for Synapse Analytics is to disable Set Operator Optimization. For example, brand managers can see a report for Brand Performance by Region. During MicroStrategy performance testing with a data engine version of 2021 using MicroStrategy 2021, there was an overall 35% performance gain compared to data. Analyst Rating. Project Development Manager (supervised Business Intelligence, Senior Rail Developers, ETL developers) with 22 plus period of total IT experience in Analysis, Design, Develop, Testing, Control and Supports of large databases/Data warehouses in financial environments. 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. From the Device drop-down list, select either iPhone or iPad to create a configuration for the device. In order to facilitate users to have a more. 117 MicroStrategy Education: Enterprise Mobility 10. For example, brand managers can see a report for Brand Performance by Region. Step 3: Copy the tracking code provided by Google Analytics. 4/10/9. Chapter 1: Understanding Big Data fundamentals Chapter 2: Administering Big Data with MicroStrategy Chapter 3: Data warehouse performance tuningTuning query performance and ETL (extract,transform, and load) in order to troubleshoot issues. MicroStrategy software is a top-tier platform for business intelligence (BI), mobile software, and cloud-based services. You can add simple visual representations of the data (called visualizations) to the dashboard to make the data easier to interpret, perform manipulations on the data to customize which information to display, organize data into. For example, passing value prompt answers from one document to another in a link is a common practice, and one that can have a negative impact on. Our vision is to enable Intelligence Everywhere. MicroStrategy offers customizable dashboards that enable businesses to visualize and track key performance indicators (KPIs), including profit margins, revenue, and costs. Auto alerts. Format this dashboard yourself with the help of this 2 minutes video. Report and Dashboard Development in the fields of Profit & Loss, VaR and Risk Analysis. So all can use different techniques on case by case basis. performance tuning of pitstop to minimize the data and rendering refresh cycles and optimize the end user experience. The grouping options for levels include: Standard groups by the attribute level of the target. KB441987. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with. Just summarizing the slides I presented at World, touching on ideas and areas of optimization for lightning fast performance of your mobile apps. MicroStrategy recommends the following best practices for designing, configuring, and tuning your MicroStrategy system. These factors cannot be accurately predicted, so there may be room for improvement with respect to the default. Microsoft Power BI is positioned as a leader in Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms whereas Microstrategy is placed in the Challenger’s quadrant. 4. Updated: November 2023. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. On the opposite side, a Snowflake schema has a normalized data structure. For example, columns that are frequently accessed in the WHERE clause are good candidates for indexing. Tuning. It shows many attributes grouped into separate visualizations. Pre-selecting an attribute element in a selector might. Many dashboards include an element of interactivity so users can explore data sets as needed. This is an example of a manufacturing unit dashboard analyzing production built using Vitaracharts and Microstrategy. Group Elements. Then, select a page from a different dossier that you want to filter as the target. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. Performance tuning in MicroStrategy. Scalability and High Performance with MicroStrategy 10 Enterprise Analytics and Mobility at Scale574. 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. Professional Summary. The test is for a single cube (4M rows) republish executed on the MicroStrategy 2021 Update 2 release with platform as 32 CPU, 244 GB memory Amazon Linux machine. Data Preparation at the Intelligence Server level. 0, while MicroStrategy is rated 8. Tableau development skills, including visualization development, the use of parameters, and report optimization. If administrators or MicroStrategy Technical Support require XML generation information, it is available through the MicroStrategy Diagnostics and Performance counters. This is the name that is displayed in the configuration list. 9 and 79 million rows in the. The following table summarizes the test results of some test scenarios against Oracle 19c. Our Customers. As we know, the two key factors which decide the success of BI application software implementation are. Grouping determines how the metric aggregates. The New Grid dialog box opens. Right click on the “Test Plan” and add a new thread group: Add -> Threads (Users) -> Thread Group. Expertise in developing Public objects (metrics, filters, entries, Custom Organizations, and. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. x ODBC calls by default. microstrategy incorporated or anyone who has been involved in the creation, production, or distribution of the. To that end, we’ve designed a program of continuous training and certification for every role in your Intelligent Enterprise. A panel is an object in a dashboard used to group related data. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. MicroStrategy is a data analytics platform for conveying business insights with customizable data visualizations and dashboards. The second question is a little difficult. Vitara's MicroStrategy 2020 Dashboard Competition Winners. Configuration objects include objects such as users, database instances, database login IDs, and schedules. From Oracle DBA Consulting to Oracle App, Oracle Data Warehousing to Oracle Analytics. Chicago, IL. Upload FilesOr drop files. Create, deploy, and. 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. Microstrategy Developer. 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. 4/10/9. Job email alerts. Watch the presentation where you'll discover our top five hacks to optimize your Dossier designs including best practices for data wrangling, dataset management, and content caching. Microstrategy Web Visual Insights . Monitoring in Microstrategy: Topology and Platform Analytics. In-store and online. MicroStrategy Optimization: VLDB Settings. For this point admins need to try the three options and see which one has better performance. email@email. Workloads are useful for: Setting different access priorities for different types of requests. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. This article describes best practices to be taken when using an Oracle database of version 19c in MicroStrategy with DDA mode. From a performance perspective, not only does it help split and divide the data into multiple sets, thereby improving performance, one can also cache the linked dashboard ahead. Configure the System Design. This video shows 15 things I usually do when creating a dashboard. 4. For detailed information about these settings, see Tuning Your System for Best Performance. Stay up to date on inventory needs and avoid. • Performed performance tuning of interfaces in StreamSets Data Collector, Oracle Data Integrator, Informatica, Vertica, and Oracle DB. MicroStrategy recommends the following best practices for designing, configuring, and tuning your MicroStrategy system. , UNION, INTERSECT, EXCEPT). Tests were conducted for several concurrent users for two data size sets “1x” and “20x” having 3. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or a Data Scientist. Request free demo. Dashboards in MicroStrategy Web. For detailed instructions to print a document, see the MicroStrategy Web Help or the Document and Dashboard Analysis Guide. It showcases the use of incorporating the factory layout with thresholds, a Calendar visualization showcasing downtime by day, and microcharts showing 12-week trends for cost, overtime, and downtime. A billing manager can see data in a report called Invoice Statements by Selected Customers, as well as a customer-level transaction detail report. This dashboard helps Regional Managers to analyse large and complex sales data quickly and easily. 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. – Advanced SQL coding skills – Solid understanding of Data Modeling concepts – Excellent personal communication, leadership, and organizational skills – Hands on development in BI reporting and Performance tuningTo print a MicroStrategy Web report: 1. Adept at both long-term and short-term troubleshooting. For more details on these areas and many more, check out our whitepaper on designing efficient workbooks. Provided specific technical guidance for key customer needs. The MCP exam covers topics such as data modeling, database design, data warehouse architecture, reporting, and analytics. Starting in MicroStrategy 2021, the default data engine version is 2021. To open a document in MicroStrategy Web. 0. 611 Analytics. – Extensive experience developing reports, dashboards, and cubes in MicroStrategy latest versions. Excel spreadsheet. Starting in MicroStrategy 2021 Update 1, you can connect to the on-premise database from the MicroStrategy cloud via Gateway Agent. Cards. Tests were conducted for several concurrent users for two data size sets “1x” and “20x” having 3. 2. MicroStrategy is rated 8. This technical note is part of How to troubleshoot Dashboard Performance. Tuning Suggestions on Db2 database. /") fails when exporting to PDF. DBA Oracle 8i, 9i and 10g for DW. Maintain your competitive edge with a data-driven retail app designed to scale—from individual locations to global franchises. Visit the data visualization and data dashboard galleries for inspiration. 2. Views 1538. • 30% Performance Improvement with Lookup Cube Caching. details. A passionate Certified Business Intelligence & Data Analytics Professional with over 15 years of experience with a proven track record in managing Project Life Cycle, Application architecture. TM1: Analyze & Share Data (3 day) Learn how to create analyses and enter data in Microsoft Excel and on the Web, create custom views of the data, and build reports and forms in. Creating Documents and dashboard using slice n Dice Concepts. 414 Designing Metrics for the Intelligent Enterprise 2021. When configuring your network, follow below best practices: Place the Web server machines close to the Intelligence Server machines. 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 bottlenecking. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. - Lead AI initiative for in depth Smart analyticsWorkstation is the only space for analysts and app architects to build and manage content of all types. Multiple certificates on Microstrategy platform and on hand experience on delivering project to clients around the globe. Highly accomplished and creative Microstrategy Developer with deep experience in all aspects of software development. By fine-tuning the configuration of your datasets in Power BI, you can meet the query parallelization requirements in your environment, boosting the performance of your BI workloads in Direct Query mode. So, having a deep grasp of this software means the candidate can effectively carry out tasks like report creation, project design, system management, and performance tuning. Predictive Analytics. • Ship latest JDBC driver with Arrow Format enabled. Provide solutions by building tools, reports and. This button displays the currently selected search type. Logs name for PU, Command ID, and execution Status. MicroStrategy’s in-memory cube technology has been generally referred to as PRIME cubes since 10. OIDC Support for Snowflake. Mstr uses metadata to translate user request and this definition is used to create SQL queries using SQL Engine. Product Analytics for a leading database company using Looker - Performance Tuning by refactoring PDT tables, Dashboard using Looker features like Calculated dimensions , measures, Rolling calculations using SQL Derived Tables, Access to other legacy dashboards using HTML Link Concept, Drill Downs, Parameter Creation for dynamic. To use it you must enable it on a per-site basis. Number of Views 6. , May 6, 2010 -- MicroStrategy® Incorporated (Nasdaq: MSTR), a leading worldwide provider of business intelligence (BI) software, today announced that its In-memory technology delivers significantly higher performance for BI applications, even at the highest scale. About. Security; Next Steps; Overview. On logging in to MicroStrategy Developer, as a admin we get the Administration option under MicroStrategy. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. Full life start. Jul 13, 2023. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. MicroStrategy. 9 and 79 million rows in the. Plano, Texas, United States. Filter PanelMicrostrategy Dossiers With the release of MicroStrategy 10. Interactive dashboards in MicroStrategy. Dashboards are a powerful way to communicate data and other information, especially with a user-centered, goal-centric design that follows dashboard design best practices and proper data visualization. I will also demonstrate how to use panel stacks, s. 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. , UNION, INTERSECT, EXCEPT). In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget. 19K. Please try to see the SQL of the report and the SQL in the database and try. Learn our Microstrategy Training to master yourself in building reports and dashboards using MicroStrategy from scratch with hands-on training from real-time experts. 50%-Design and develop robust, user friendly applications, reports and dashboards using BI tools like Microstrategy and SAS 25%-Partner with leaders to identify needs and gather requirements. 9. Scorecards typically follow a specific methodology and focus on key metrics within a business area. In order to ensure that the XML generated is optimized please review the XML generation optimization techniques KB31469: Data generation for Dashboard Performance Optimizations in MicroStrategy Web 9. 2 MicroStrategy 2020 • Up to 3X Performance Improvements OOTB using Derived Table Syntax and Arrow Data Transfers.