Microstrategy

There are two editions. Desktop is for building dashboard as a standalone. The Enterprise Edition is a server based where the Intelligence server hosts the data and the web or mobile client will connect to this running instance. See the website to download the trial edition. The Enterprise edition requires Microsoft IIS Webserver to be installed or Apache tomcat server. These will run Microstrategy Web or Mobile application.

Getting Started

  • Prepare your dataset and connect to data source. First stage is to wrangle your data to clean it up and import the right tables. Microstrategy has several intelligent options to help you do this.
  • Next we begin creating the dynamic Enterprise Dashboard. Here are steps to follow:

Microstrategy

  • From Start menu open the Microstrategy developer. Login with Administrator with no password (this is the default upon install).
  • From Start menu open the Microstrategy Web Administrator. Enter your windows user account password to enter the Administrator screen.
  • Enter Adminstrator with no password to access the Tutorial and other sample applications.
  • Once setup select an out of the box dynamic dashboard template in Microstrategy developer and click open. This is where you will layout and add text ans heading to your dashboard.

Microstrategy2

  • Your dataset should be configured pointing to the data source. Select the Dataset. Then select your data set objects and drop it into the section place holders. Drop Row, Column and Data into the place holders.

Microstrategy3

  • Click on Add content to select the content format or Chart type to insert.

Microstrategy4

  • Enter into Graph design mode. Drag and drop data objects in the chart series and metrics.

Microstrategy5

  • Repeat for the next chart. Enter into Graph design mode. Drag and drop data objects in the chart series and metrics.

Microstrategy5

  • Define bubble selector to control other grids and graphs by right clicking on field to sort data set by i.e Region.

Microstrategy6

  • Click on ‘click here’ to manually configure the target charts to control.

Microstrategy8

  • Select Targets for the selector to control. Check Show Option for All checkbox.

Microstrategy9

  • Select Flash mode to see how the dashboard works

Microstrategy10

  • Right click on the chart to tweak the bubble gird size so it view pleasingly.

Microstrategy11

Now you should be able to click on the Region bubble and update the other charts.

Restarting Microstrategy Intelligence Server Instances

When Microstrategy Web doesn’t allow you to connect or the number of connections in the pool is exhausted you can restart the service to free up system resource.

Go to Start > Microstrategy Tools > Service Manager. > Start / Stop / Restart as shown below.

 Microstrategy Server Amdin Restarting Service

 

Website

  • Analytics Platform Trial | MicroStrategy

    Get up and running with MicroStrategy Desktop today, or request a trial of the full enterprise platform.

    Source: www.microstrategy.com/uk/free-trial

 

Tutorials

  • Microstrategy Online Training | Microstrategy Tutorials for Beginners – YouTube

    Source: www.youtube.com/watch?v=ucdF9JKGgWQ

  • BI Learning: Creating a Dynamic Enterprise Dashboard – YouTube

    Source: www.youtube.com/watch?v=bZ_urHhJo7A

  • MicroStrategy BI and Analytics Platform Capability – YouTube

    This demo covers lots of great topics -data access (social media, hadoop, MDX), visualizations and D3, promotion to governed data discovery, mobile, admin to…

    Source: www.youtube.com/watch?v=LGrKsT76Es4

  • D3 & Maps Visualize Data Like Never Before With MicroStrategy 10 – YouTube

    https://lw.microstrategy.com/msdz/MSDL/10/docs/projects/VisSDK_All/default.htm?_ga=1.144496245.155072667.1439394769#topics/HTML5/Creating_an_HTML5_visualizat…

    Source: www.youtube.com/watch?v=AEjMHrivOMs

References

 

  • Microstrategy 9 Installation on a new Windows 2008 server | Technology/தொழில்நுட்பம்

Source: thozhilnutpamdotnet.wordpress.com/2013/06/16/microstrategy-9-installation-on-a-new-windows-2008-server/

 

 

  • Analytics | Technology/தொழில்நுட்பம்

Source: thozhilnutpamdotnet.wordpress.com/category/analytics/