MicroStrategy - Creating Dashboard. STUDY. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. In-store and online. Take Universal Benchmark data for example: The following image shows trends using default settings with 32vCPU and 244GB memory configuration for both MicroStrategy and the. 0. 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. For future reference, when the term “Dossier” is used in this document it also refers to Visual Insight Dashboards. A visualization is a visual representation of the data in a dashboard, such as a grid, line chart, or heat map. NTTA (North Texas Toll Authority) Nov 2021 - Mar 20231 year 5 months. Add Thread Group. Click edit. • Connectivity Wizard Support for Snowflake • ODBC & JDBC drivers shipping OOTB. Understand your data characters and choose the matched configuration could enhance the performance and accelerate the process to view the latest data. Responsibilities for microstrategy developer. This section describes only the most basic guidelines. 11. To run a report in the Enterprise Manager project, you connect to the project as you would any of your other projects. Mstr uses metadata to translate user request and this definition is used to create SQL queries using SQL Engine. sfw file. Configuration objects include objects such as users, database instances, database login IDs, and schedules. The most common microstrategy developer hard skill is dynamic dashboards. Predictive Analytics. Applied Teradata Application Utilities and Teradata SQL . KB484932: Best Practice for Performance Tuning using Oracle. Key performance indicators are the metrics most important to users. Power to Dominate. Design and maintain database enterprise assets. Apache kylin 4. MicroStrategy Desktop: This Windows-based application is designed for report designers and analysts. Full-time, temporary, and part-time jobs. Dashboards, like scorecards, are made up of a group of reports and metrics that are tied together by business logic. MicroStrategy comes with a large, flexible, and easily extensible library of interactive graphs, advanced visualizations, and maps that make understanding your data easier than ever before. The latest information on the data including the addition of new objects, modifications can automatically be derived from the warehouse directly. • Ship latest JDBC driver with Arrow Format enabled. 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. Utilizes understanding of dimensional data modeling techniques, data warehousing, design and concepts to produce balanced scorecard design, and design of dashboards and KPI’s (Key Performance Indicators) Build and test production deployment packages and implementation plans for. Additional performance tuning best practices for OLAP Services are provided in the System Administration Help. Ad hoc query. This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. microstrategy incorporated or anyone who has been involved in the creation, production, or distribution of the. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. Notice that the image displays with no issue in MicroStrategy Web. Referrals increase your chances of interviewing at IDESLABS PRIVATE LIMITED by 2x. 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. MicroStrategy Intelligence Server is the architectural foundation of the MicroStrategy platform. Importing Dashboards; Exporting Dashboards. Browse and incorporate these templates into your own data dashboards. • Connectivity Wizard Support for Snowflake • ODBC & JDBC drivers shipping OOTB. 12+ years of work experience in Data and Analytics Sound knowledge of Data warehousing methodologies and Data modelling with extensive experience in MicroStrategy and Tableau Technical Program. OIDC Support for Snowflake. Possess strong expertise in day-to-day. x. When you enable these traces, be sure to enlarge the size of trace file to >20MB. As a senior Business Intelligence Developer with a strong focus on MicroStrategy, I bring over 13+years of experience in creating and implementing data-driven solutions for various businesses. From the Report Selection panel, go to the File menu > Open. , UNION, INTERSECT, EXCEPT). Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on. 1 million in the first quarter of 2022. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Select Test Plan on the tree. CAUSE: This issue is caused by the way the image is referenced when defining the path. Arria NLG Studio for MicroStrategy gives you the ability to create dashboards that are faster to interpret by instantly generating expert narrative to accompany the visuals on your MicroStrategy Dossiers. Our typical enterprise data warehouse ( EDW) project is divided in four main phases and focuses on using the. On the Freeform Sources tab, select Create Freeform SQL report. Senior Developer BI & Analytics. Jr. MicroStrategy Dashboard Templates facilitate dashboard design by providing you with preformatted customized templates. Our customer is a leading network management solution provider. To access this information, on your selected visualization click more > Query Details: For more information on this feature, see this PDF . In MicroStrategy Desktop, log in to a project. STEP 1: Enable the MCE trace. Dashboards and Scorecards: This folder contains several examples of dashboards. Microstrategy Dossiers With the release of MicroStrategy 10. Many dashboards include an element of interactivity so users can explore data sets as needed. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. The major usage of the tool is for analytical purposes (reporting) by interacting with Hadoop, Microsoft SQL Server Tables, and SSAS MDX. likes. Bengaluru, Karnataka,. In the Source area, select a database instance for the database to access using Freeform SQL. Sources include cloud databases, data warehouses, physical access systems and web applications. Reduce objects on the dashboard by: (A) Using links to another dashboard. 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. These dashboards can be tailored to specific business needs and provide real-time insights into profit margin performance. Administrative access to the OS is required to modify system parameters. The bigger the Dashboard size the. SJK Consulting, LLC. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Best Practices for Using Customized Heatmaps in MicroStrategy Dashboards and Reports. 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. This is the name that is displayed in the configuration list. Lets see a use case to understand this better: List all reports and dashboards in a particular folder and get its details (Report name, Owner, Location, Create date, Mod date, etc). The DSN and Login ID are provided based on the server configuration that you did previously. Bengaluru, Karnataka, India. 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. a) Attribute form qualification. 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. First, define one visualization as the source. WeQlik Sense relies on WIP, a third-party solution, for source control and version management and Qlik NPrinting for report delivery. Bencekovićeva 33, 10000 Zagreb, Croatia. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. . Our vision is to enable Intelligence Everywhere. The DWS exam focuses on topics. These fixes address performance (2), security (3), and stability (12), among other issues. Additionally, when using Teradata as MicroStrategy Metadata, the Teradata ODBC driver options should be set as follows. 2 MicroStrategy 2020 • Up to 3X Performance Improvements OOTB using Derived Table Syntax and Arrow Data Transfers. Marktine Technology Solutions Pvt Ltd Dubai, Dubai,. For detailed information refer to the System Administration Help. 262KB. For information on connecting to databases, see Connect to Databases. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. MicroStrategy. Hee-Wei Tan (Inactive) · May 1, 2017 ·. 1/9. Dossiers automatically adjust to look great on any screen. For tuning details, see the appropriate section in the Installation and Configuration Guide. Typically, a long duration is seen in the Data Transfer time which indicates the time it takes to fetch data from the warehouse. The DashboardViewer. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with. and select the Project-Name. Click on the drop down for the corresponding 'File Log' and choose the log file to which the SQL Trace needs to be written into. - Full life cycle implementation encompassing. 0. 1. 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. - Query plan performance tuning frequently involves altering the query, the database design, or the database configuration to increase query performance. If you manually enable this setting. 2. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. Check the attached . To improve. If you use Enterprise Manager, dedicate a machine for the Enterprise. Nahiyan Khan (Inactive) · Jun 21, 2017 ·. PNG. Analyze the low performance query using DBA knowledge, add. 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. 0-alpha, the first version of Apache kylin 4. 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. 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. de 2007 - mai. Apply online instantly. In the Thread Group control panel, enter Thread Properties as follows: Number of Threads: 100 (Number of users connects to the target website: 100) Loop Count: 10 (Number of time to execute. Step 6: Click on "Web Integration" and paste the Google Analytics tracking code into the. Classroom Review questions for Microstrategy Documents & Dashboards + Visual Insights. Referrals increase your chances of interviewing at IDESLABS PRIVATE LIMITED by 2x. On the dataset "Generic Metrics List". With market competition being cutthroat, companies. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. x ODBC calls by default. Kylin4 uses a new spark build engine and parquet as storage, and uses spark as query engine. The following diagram depicts the role of the intelligent cube. These four Dashboards display high quality layouts and design and utilize many of the new MicroStrategy 2020 features with VitaraCharts visualizations. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. performance tuning of pitstop to minimize the data and rendering refresh cycles and optimize the end user experience. 0-beta and official version were released. Client rendering time greatly relies in the amount of XML that needs to be parsed. Migrated dashboards from Power BI, Microstrategy, and Cognos into Tableau. Data Preparation at the Intelligence Server level. Starting in MicroStrategy 2021, the default data engine version is 2021. There are multiple ways to intervene the database to generate a better SQL execution plan. 1670. When expanded it provides a list of search options that will switch the search. The newest feature release of Microstrategy, Microstrategy 10. Ultimately, we felt that it was time to. 0. Pros and Cons. 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. Set this dummy map as project default drill map in Step 2. Define the statistics and enterprise warehouse database. Browse and incorporate these templates into your own data dashboards. Interactive dashboards in MicroStrategy. However, these settings depend on the type of SQL being sent to the warehouse, database load, and dataset size. 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. Business Intelligence Reports and dashboards using MicroStrategy Desktop. MicroStrategy: An Overview. The January release includes the latest versions of all our applications, including mobile. The default folder is: C:\Program Files (x86)\MicroStrategy\Product Name when installed on a 64-bit Windows environment. Filter PanelMicrostrategy Dossiers With the release of MicroStrategy 10. Dashboards, on the other hand, also provide key metrics but tend to summarize business intelligence information more widely. 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. When you add a panel stack to a document, one panel is automatically added to the panel stack. Double-click the security role you want to assign to the user or group. Provide solutions by building tools, reports and. 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. Select the Members tab. 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. Answer: Go with dossier. The key features of MicroStrategy platform are –. 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. However, these Dashboards did not perform well and lacked additional functionality desired by the end users. 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. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. 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. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the dataThe 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. To get a sneak-peak of new functionalities. Inserting Panel Stacks ,Layouts ,Selectors and widget in Documents and Dashboard. Each panel can contain groups of objects. 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. Microstrategy Dossiers With the release of MicroStrategy 10. 0. For example, brand managers can see a report for Brand Performance by Region. To start the Report Wizard. We empower you with the skills to get the most out of your analytics investment. As we know, the two key factors which decide the success of BI application software implementation are. Highly accomplished and creative Microstrategy Developer with deep experience in all aspects of software development. These factors cannot be accurately predicted, so there may be room for improvement with respect to the default. Although links in documents help you reduce data and increase performance, they do have some limitations. set. 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. Data quality. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. Have experience working with outstaffing, outsourcing, and product companies. MicroStrategy provides modern analytics on an open, comprehensive enterprise platform used by many of the […] Answer: Go with dossier. Design and maintain database enterprise assets. Their network traffic management product features MicroStrategy Dashboards for reporting. The following dashboard, designed and built using MicroStrategy and Vitaracahrts, was created as a part of a challenge conducted by Maven Analytics to showcase Unicorn companies' data worldwide. The third most common microstrategy developer skill is templates on 5. MicroStrategy Web: In contrast, MicroStrategy Web is a web-based application accessible through web browsers. Microstrategy Mobile platform project professional and growing project manager and team leader. To access documentation resources on Windows. Provider, MicroStrategy SDK, MicroStrategy Support, MicroStrategy Telecaster, MicroStrategy Transactor, MicroStrategy Web, MicroStrategy Web Business Analyzer, MicroStrategy World, Application Development and Sophisticated Analysis, Best In Business Intelligence, Centralized Application The following topics describe sizing guidelines to consider when you initially set up MicroStrategy. 10. Teradata suggests the use of fully normalized physical schemas (specifically, Third Normal Form or 3NF). Cube advisor This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. Advanced Apps. We will take a look at two main BI tools, Microstrategy and Power BI that are seeing widespread adoption in the industry today. The metric calculates at the level of the target, if possible. The amount of data retrieved and objects being used in a Report Services Dashboard have a direct impact in the size of the final Dashboard. To log to your screen, select. Operating expenses include impairment losses on MicroStrategy’s digital assets, which were $18. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. 3. to improve it by reducing the number of passes created by the report. Apply Microstrategy Developer. The stand-alone filter can then be used on many different reports, as well as on metrics and other objects. Workload Management. 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. highly formatted documents, scorecards, and dynamic dashboards. Experience creating complex reports in MicroStrategy according to the software development lifecycle. - Over 16 years of experience in Business Intelligence, with expertise in data visualization and analytics using MicroStrategy and Power BI. Place Intelligence Server close to the both the data warehouse and the metadata repository. Title: MicroStrategy Dashboard Performance for Network Analytics Apps, Author: InfoCepts, Length: 3 pages, Published: 2013-12-17. Capture8. Scalability and High Performance with MicroStrategy 10 Enterprise Analytics and Mobility at Scale574. Whether it is to display the changes between two metrics, to show the KPI performance over time, or to present ranking among employees, these simple arrows can tell strong stories. What is the auto text feature? The auto text feature is used to add dynamic text/dataMicroStrategy Analytics Enterprise, MicroStrategy Evaluation Edition, MicroStrategy Suite, MicroStrategy Web, MicroStrategy Mobile, MicroStrategy Server, MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy MultiSource, MicroStrategy OLAP Services,Proficient in evaluating data models to design Tableau solutions and fine tuning dashboards to increase performance. Designing, building, and maintaining data integration processes in test and production environments of ETL processes, and design data models. The second question is a little difficult. Format, analyze, filter, and layer the visualizations to create appealing, insightful dashboard-style dossiers through. So all can use different techniques on case by case basis. You can use these reports and dashboards to make decisions about tuning the MicroStrategy system. 3. 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. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. However, in MicroStrategy, filters can also be created as part of a given report, at the same time the report itself is being created. 9. Rarely Data Preparation is the performance bottleneck when executing Report Services dashboards. 4/10/9. ”. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. It shows many attributes grouped into separate visualizations. It is based on a single data repository strategy, whereas Cognos has two metadata repository and database-based. Core Qualifications. Wordsmith is the world’s only self-service natural language generation engine. • 30% Performance Improvement with Lookup Cube Caching. •. Developed POC dynamic dashboards for HISNA clients. 10. Core server to manage users, security, database communications, report formatting, and distribution: MicroStrategy Intelligence Server. MicroStrategy’s In-memory technology is engineered to meet the. Tests were conducted for several concurrent users for two data size sets “1x” and “20x” having 3. MicroStrategy Modeling and Schema Development for a Capital Markets BI project on Netezza. 0, while Tableau is rated 8. 19K. Once the best combination is determined, admins can test the deletion and see if the performance improves there. If report taking longer time to run then before checking other things, first check the report SQL and try to run the same in the database . 611 Analytics. 2. Updated: November 2023. Step 3: Copy the tracking code provided by Google Analytics. View AllFiles. good title and noninfringment, quality or accuracy. From Oracle DBA Consulting to Oracle App, Oracle Data Warehousing to Oracle Analytics. The default value for Synapse Analytics is to disable Set Operator Optimization. Designing and developing Power BI dashboard and visualization. For details, see the MicroStrategy Tech Notes. Dashboards provide a distilled view of. Follow-up of SRs in Oracle's Metalink support center. x. The legend frame is moved to one of the default locations on the graph report. Metadata is a relational database that contains information to facilitate the transfer of data between Data warehouse and Microstrategy. Enterprise Manager is a MicroStrategy project that uses the Intelligence Server statistics database as its data warehouse. Create, share, and maintain dashboards and dossiers. Auto alerts. 0: Add to section as shortcut. Just summarizing the slides I presented at World, touching on ideas and areas of optimization for lightning fast performance of your mobile apps. Then, select a page from a different dossier that you want to filter as the target. For all other outputs, MicroStrategy Office, MicroStrategy Web in DHTML mode and MicroStrategy Web in Flash mode the Intelligence Server generate XML. - 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. 8+ years of Professional experience this includes Design , Development and implementation of MicroStrategy request with proficiency in creating Attribute , Facts , Patterns , Filter , Prompts , Metric , Reports , Documents and Dashboards using MicroStrategy 10. The ODBC connection uses 3. (720) 399-4525. 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. Job email alerts. MicroStrategy is a data analytics platform for conveying business insights with customizable data visualizations and dashboards. We will take a look at two main BI tools, Microstrategy and Power BI that are seeing widespread adoption in the industry today. It calculates the subtotal elements of a compound metric. import data into MicroStrategy Desktop, for use in creating dashboards. Below are the new features exclusive to. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a. Expertise in developing Public objects (metrics, filters, entries, Custom Organizations, and. It’s like having an expert speak directly to every user, telling them what the data means and what they should do about it. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. 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. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. Significantly improves user-perceived query performance. On the Freeform Sources tab, select Create Freeform SQL report. Gain insight into services, jobs running, and quick search indices for seamless operations. Ad hoc query. Jul 13, 2023. Architect. MicroStrategy provides an extensive library of visualizations and an intuitive drag-and-drop interface make it easy for users to build data discovery dashboards. T-Systems. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Main achievements:Apply for a Resource Informatics Group Inc Microstrategy Lead job in Media, PA. Interactive Elements: With Power BI, dashboards are not just static visuals; users can drill down, apply filters, and interact with data for deeper insights. IBM Cognos also connects you with the company data you collect on their. Strong. Apr 2019 - Present 4 years 8 months. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . However, Intelligent cube publishing performance may be affected with the agent enabled. SQL Server Performance Tuning and Optimization -Languages English. View this and more full-time & part-time jobs in Media, PA on Snagajob. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. Best Practices Articles (Performance Tuning Based on IBM Db2) This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. We have found that educated users are more likely to use the product on a daily basis. I joined the dossier authoring team in 2018. These are represented in dashboards either as a part of visualizations or tables. #MSTR #microstrategy #sql #developer #Teradata #powerbi #schema #dossierPlease share your resume…See this and similar jobs on LinkedIn. Another report takes 2. Data Mining. This technical note is part of How to troubleshoot Dashboard Performance document that can be found in KB19625: Dashboard performance troubleshooting in MicroStrategy 9. Always consider to collect database statistics as the query execution plan is generated based on that. With this new release, R and the R Integration Pack are. This dashboard helps Regional Managers to analyse large and complex sales data quickly and easily. This information can help you determine where database tuning can be adjusted to improve overall query and reporting performance of your MicroStrategy project. In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget. 4. 111 Overview of Enterprise Analytics 2021. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Mstr uses metadata to translate user request and this definition is used to create SQL queries using SQL Engine. Dashboards and Scorecards: This folder contains several examples of dashboards. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. As a high-level overview of tuning the system, you should first define your system requirements, and then configure the system's design using those requirements.