MICROSTRATEGY TUTORIAL PDF

adminComment(0)
    Contents:

m For examples provided in this guide, dates in the MicroStrategy. Tutorial project are updated to reflect the current year. The sample documents and images in. Business Intelligence Reports and dashboards using MicroStrategy Desktop. In addition, it in this tutorial, please notify us at [email protected] MicroStrategy Tutorial in PDF - Learn MicroStrategy starting from Overview, Environment Setup, Desktop, Architecture, Components Overview, Importing data .


Microstrategy Tutorial Pdf

Author:GWENDOLYN PELLIETIER
Language:English, Indonesian, German
Country:Paraguay
Genre:Art
Pages:419
Published (Last):07.06.2016
ISBN:461-7-18493-191-2
ePub File Size:28.89 MB
PDF File Size:10.73 MB
Distribution:Free* [*Sign up for free]
Downloads:30265
Uploaded by: LIGIA

MicroStrategy Tutorial for Beginners - Learn MicroStrategy in simple and easy steps starting from basic to advanced concepts with examples PDF Version. As part of this MicroStrategy tutorial you will learn how to get started with . Specify the scaling and orientation of the report in the PDF Options dialog box and. Microstrategy tutorial for beginners- Learn Microstrategy from basic to advanced level with this Microstrategy tutorial. Learn microstrategy to develop customized.

Click Save. Customer Age Attribute Customer Age is a derived attribute. Use an ApplySimple statement to calculate a customers age based on their birth date.

How to create a derived Customer Age Attribute: 1. Click Validate to check the syntax. Under Mapping method, ensure Automatic is selected.

In the Attribute Editor dialog box, click the Children tab. In the Save As window, rename the attribute to Customer Age.

When to Complete This Project

User Hierarchies Now that you have created the attributes and specified their parent-child relationships, you are ready to create user hierarchies. User hierarchies enable you to easily browse through attributes in Desktop. Create the following five user hierarchies according to their requirements: Time Hierarchy - Include all time-related attributes as diagrammed in the logical data model.

Customers Hierarchy - Include all customer-related attributes as diagrammed in the logical data model. In addition, include the Customer Age and Rush Order attributes created in section 8 and 9.

Microstrategy Tutorial – Learn Microstrategy from Experts

Geography Hierarchy - Include all geography-related attributes as diagrammed in the logical data model. Promotions Hierarchy - Include all promotion-related attributes as diagrammed in the logical data model.

All Rights Reserved - Allow drilling on the hierarchy. Products Hierarchy - Include all product-related attributes as diagrammed in the logical data model, except Discontinued.

How to create user hierarchies: 1. On the File menu, point to New and select Hierarchy. In the Hierarchy Editor, notice that the attributes are arranged according to their parent-child relationships. Attributes with a green check mark are entry points.

By default, any attribute without a parent is an entry point. Right-click Quarter and select Set as Entry Point. Follow the same procedure for Month and Day. To remove an entry point, right-click an attribute and select Remove as Entry Point.

To lock an attribute, right-click the attribute, point to Element Display and select Locked. At the bottom of the Hierarchy Editor, leave the Use as a drill hierarchy check box selected.

Other books: OCTAVE TUTORIAL PDF

All Rights Reserved 9. When notified that this hierarchy has been defined as a drill hierarchy, click OK. In the Save As window, rename the hierarchy to Time Hierarchy. Reports that display your business data are the focus and goal of business intelligence. Reports allow you to gather business insight through data analysis. The results displayed in any MicroStrategy report are often a starting point for further investigation. The reports in this folder appear on the right-hand side of Desktop.

Double-click the Revenue Forecast grid report to run the report and see the sample data results. That data is the focus of business analysis in a reporting environment. We can view a MicroStrategy report from different perspectives, depending on the type of work that we want to perform. A grid report is the most commonly used type of report. Grid View displays grid reports using a formatted, cross-tabular display of the report data.

A graph report is a representation of data in a visual format that can help you see overall trends easily, identify medians and exceptions, and so on. This view provides a good way to troubleshoot and fine-tune the selection of data that is retrieved from your data source and displayed in reports. However, MicroStrategy also offers other ways to display data.

While working in MicroStrategy Desktop or Web you might see boardroom-quality business presentations, invoices that go out to customers, all kinds of management reports and dashboards, and so on. Documents are a display of data from multiple reports with special formatting added, with interactive components, and so on.

Log in to MicroStrategy Tutorial. For steps, see Starting MicroStrategy Desktop. Expand the Public Objects folder, then expand the Reports folder.

Double-click any of the documents listed on the right-hand side of Desktop, to execute it and see the results. For steps, see Starting MicroStrategy Web. Click the MicroStrategy icon and select Shared Reports. Click any of the documents listed on the right-hand side of MicroStrategy Web, to execute it and see the results. An HTML document is another way to display and analyze data when you want to see multiple reports at the same time. In addition to report results, HTML documents can include text, images, hyperlinks, tables, and so on.

HTML documents are one method to create dashboards and scorecards, which are a group of related reports displayed together. In Desktop, click the View menu. A view filter is different from a report filter, which restricts how much data is retrieved from the data warehouse. A view filter dynamically restricts the data being displayed on the report without re-executing the report against the warehouse.

This capability provides improved response time and decreased database load. Derived metrics perform calculations on-the-fly with the data available in a report. They are an easy way to present data already available on the report in different ways, providing further analysis of data.

A derived element is a grouping of attribute elements on a report. These groups provide a new view of report data for analysis and formatting purposes.

Dynamic aggregation allows you to change the level of report aggregation on-the-fly, while you are reviewing the report results. This feature allows metric values to be aggregated at different levels depending on the attributes included on the report without having to re-execute the report against the data warehouse. From the File menu, select Print.

The Print dialog box opens. To preview the report before printing, to ensure that it prints correctly, click Print Preview. When you have finished previewing the report, click Print to return to the Print dialog box. For in-depth instructions, see the online help. After making your changes, click Print to return to the Print dialog box. By default, the entire report is printed.

To select which pages to print, type page numbers in the Pages field. By default, the grid that is, the report results is printed, but you can print the SQL statements instead, by selecting SQL from the Print what drop-down list. The PDF Options dialog box opens. The report opens in PDF format. Use the options on the Print dialog box to scale the print size of the report, and to specify the number of copies to print. In MicroStrategy Desktop and Web you can export data to different formats or applications, such as a spreadsheet.

MicroStrategy Tutorial

From the Data menu, select Export Options. The Export Options dialog box opens. Make any necessary changes to the export options. Click Help for details about each setting.

From the Home menu, select Export , and then select the required output format. The Export Options page opens. Open a report and, from the Data menu, point to Export To. Choose the appropriate format in which to export the file. The following applications or file types are supported:. Make any necessary changes to the export settings and click Export. The report automatically displays in the selected application.

How our support Works? Remember Me. Don't have an account? Sign up. Already have an account? Hurry up. Master Program Big Data Data Science Business Intelligence Salesforce 2. Cloud Computing 3. Mobile Development 2. Digital Marketing 5. DataBase 8. Programming Testing 5.

Project Management 9. Website Development 5.To remove an entry point, right-click an attribute and select Remove as Entry Point. Click Validate to check the syntax. Master Program Data Mining and Predictive Analysis You can deploy a wider range of data mining and data modeling tools along with MicroStrategy to augment its native analytical capabilities. Data Science Data discovery is a part of business intelligence process wherein you connect to data from disparate sources and data in the form of data silos and so on.

However, MicroStrategy also offers other ways to display data. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. The following applications or file types are supported:. These groups provide a new view of report data for analysis and formatting purposes.