Category: microstrategy

MicroStrategy – Rollup ”; Previous Next Rollup is the process of moving up in the hierarchy of dimensions in a given data set. As we move up, the values of the measure become less granular and more summarized. It is the opposite of drilldown. For example, in the hierarchy of Area → region → country, we move from an area to a country and finally the values get summarized at the country level. This process is called Rollup. Example In the dataset named All_Sales, let’s consider the following dimensions for a rollup. Product Line category Subcategory Step 1 Create a visualization with all the three dimensions mentioned above and sales as the measure value. Step 2 Let’s remove the dimension subcategory from the above visualization. Now, the result shows the summary at the Category level. To remove, right-click and choose remove from the options. Step 3 The result now shows sales value at the category level. Print Page Previous Next Advertisements ”;

MicroStrategy – Slicing ”; Previous Next The Slicing operation of a data set involves creating a smaller data set by filtering one dimension. It helps in analyzing the relationship between a given dimension and all the remaining variables of the data set. Consider the data set, All-Sales, which contains the following dimensions − Business Line Product line Category Subcategory Sales The following screenshot shows a chart with the entire data set projecting all the variables. Now, let’s find out the Sales value for each value in the category dimension. For this, we can go to Editor → Visualization, and keep the dimension Category in the vertical axis. Then keep Sales in the horizontal axis. Also choose the Color By option as sales. This will produce the following screenshot with the diagram showing the sales data for each category. Print Page Previous Next Advertisements ”;

MicroStrategy – Drilldown ”; Previous Next Drilldown is the process of going down in a hierarchy of dimensions to get more granular values of the measures. In a data set with more than one dimension, which is linked to each other in an hierarchical fashion, we start with a dimension at the top and then gradually add more dimensions to get new granular values. Drill-down options give more insight into how different values at each level get aggregated. Example In the all_slaes data set, let’s consider the following 3 dimensions applied to the measure Sales. Product Line Category Subcategory Following are the steps to perform a drill-down. Step 1 Create a visualization with dimension – product line and measure sales as shown in the following screenshot. Step 2 Add the dimension category to the visualization below Product Line. As you can see the value of the sales column changes, reflecting the values for each category under the product line. Step 3 Next, let’s add the dimension sub-category below the dimension category and it further changes the values in the sales column. Print Page Previous Next Advertisements ”;

MicroStrategy – Public Objects ”; Previous Next When a new MicroStrategy project is created, users with access to that project can create objects and store them only in their personal folders under that project. However, it is desirable sometimes to make many MicroStrategy objects available to other users. For such a scenario, a user of the administrative group can create and place various MicroStrategy Objects under the public folder. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. On expanding the button, the following screen opens showing different public objects available in MicroStrategy. Print Page Previous Next Advertisements ”;

Discuss MicroStrategy ”; Previous Next MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. It can connect to data warehouses, relational systems, flat files, web services and a host of other types of sources to pull data for analysis. Features such as highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution makes MicroStrategy an industry leader in BI software space. It is recognized as a visionary by Gartner Magic Quadrant. Print Page Previous Next Advertisements ”;

MicroStrategy – Architecture ”; Previous Next MicroStrategy has a metadata-driven architecture. The metadata is a central repository, which stores all the objects used by it. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. The objects stored in the metadata are reusable. Object Layers The following diagram represents the different layer of objects created and stored in MicroStrategy metadata. Administration Objects − This Objects layer establishes the security, user grouping, and performance parameters that govern the MicroStrategy applications. Report Objects − This objects layer assembles the building blocks from the Schema and Analysis Object Layers to provide insightful textual and visual analysis. Analysis Objects − This objects layer provides the building blocks for sophisticated analysis. The analysis objects are built on the objects developed in the schema layer. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. ROLAP Architecture MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. For this, it uses a relational OLAP architecture. The following diagram shows an overall architecture of MicroStrategy platform describing how it accesses data from various sources using the metadata objects. Dynamic MDX Engine − It generates optimized Multidimensional Expressions (MDX) for interactively accessing cube databases from SAP, Microsoft Analysis Services, Hyperion Essbase, etc. Dynamic SQL Engine − It generates optimized SQL for interactively accessing data warehouses. Freeform SQL Engine − It provides direct access to operational databases, text files, and spreadsheets via a graphical Query Builder or through freehand SQL. Unified Metadata Finally, MicroStrategy Architect can model multiple sources as if they were a single data source, storing all this information in MicroStrategy”s unified metadata. Print Page Previous Next Advertisements ”;

MicroStrategy – Filtering Data in Dashboard ”; Previous Next A dashboard is a document containing many visualizations displaying the results simultaneously. While carrying out data analysis, we may need to apply filter which will show the effect of the filter on each of the visualizations present in the dashboard. Also, all the results should have a synchronized value. This is possible by creating a normal filter and applying it to the dashboard. Following is an example of applying a filter to the dashboard. Step 1 Let’s consider the dashboard which we created in the last chapter. Let’s create a filter as shown in the following screenshot. Step 2 Click the Select Target option and apply the filter to visualization2. This will change the displayed values in visualization2, however visulaization1 will display a synchronized result. Step 3 After applying the filter, click some of the values of the product category visible in the top bar filter section. This will change the diagrams, depending on the value selected. In the following example, we have selected multiple values and you can notice how the pie-chart changes as each of the values are selected. Print Page Previous Next Advertisements ”;

MicroStrategy – Adding Web Content ”; Previous Next Besides data from different sources, we can also add data from web in a MicroStrategy report. It becomes a part of the visualization. Visualization shows the entire webpage, which appears embedded in it. Following are the steps to get the content from the web. Step 1 Go to the + menu and choose the option HTML Container as shown in the following screenshot. Step 2 Now, an Iframe Box pops up asking us to enter the URL of the website we want to show. Enter the complete URL as shown in the following screenshot. Step 3 Finally, the webpage appears as shown in the following screenshot. Print Page Previous Next Advertisements ”;

MicroStrategy Tutorial PDF Version Quick Guide Resources Job Search Discussion MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. It can connect to data warehouses, relational systems, flat files, web services and a host of other types of sources to pull data for analysis. Features such as highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution makes MicroStrategy an industry leader in BI software space. It is recognized as a visionary by Gartner Magic Quadrant. Audience This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or a Data Scientist. Prerequisites Before proceeding with this tutorial, you should have a basic understanding of Computer Programming terminologies and Data analysis. You should also have some knowledge on various types of graphs and charts. Familiarity with SQL will help in fast learning. Print Page Previous Next Advertisements ”;

MicroStrategy – Grid Visualizations ”; Previous Next Grid Visualization is the simplest form of visualization in MicroStrategy, yet a very powerful analysis method. Here, data is presented as a grid with rows and columns as well as headers of the columns. It provides features such as sorting and drilling the data. Creating a Grid Visualization After loading the required data set into the MicroStrategy Environment, we pull the required fields to the editor panel. This automatically creates the Grid visualization. In the following example as shown, we pull the relevant fields from the data set and create a grid. Operations in Grid Visualization Following operations can be carried out in a grid visualization. Sorting data on multiple columns Swapping column and rows Drill on an attribute Sorting Data on Multiple Columns Grid visualization provides a facility to sort on multiple columns simultaneously. Right-click on a column name and choose the option advanced sort. This brings us to a screen where we can select all the columns and their order to do the sorting. Swapping Column and Rows We can swap the columns and rows in the grid visualization to make a pivot report. Just drag and drop the columns into rows as shown in the following screenshot. Drill on an Attribute We can drill on an attribute on the grid visualization to get down to the values of the next attribute in the hierarchy. Right-click the column name and choose the drill option as shown in the following screenshot. Print Page Previous Next Advertisements ”;