BI Exercise using the MicroStrategy Site

1
BI Exercise using the MicroStrategy Site

• Sean Eom

2
Entering Teradata Student Network

• Click teradata student network on the course
  schedule page
• Enter password smartdecisions (not case
  sensitive).

3

• Choose the software area
• Software This section includes software for
  your classes.To access this area, click here!  
• Choose Teradata Database - This is your Teradata
  Student Network resource that is dedicated to
  providing you with learning opportunities
  centered around Teradata SQL Assistant/Web
  Edition. 

4
Registering to the Network

• If you have not registered for your course, click
  the link below to register and create your
  Teradata SQL Assistant/Web Edition account.
• Choose the following
• Register to Use Teradata SQL Assistant/Web
  Edition in a Course

5
Fill out the registration form
6

• After entering university, Instructor, and
  course, do not add course password.
• Add the following
• SQL UserID (this is your user id, you decide it)
• SQL PW (you decide it)
• E-mail address (your e-mail address)
• Hint Phrase
• Hint Answer
• Click Register, Congrat! You are done!!

7
BI Exercise Using the MicroStrategy Site

• Overview of MicroStrategy 8i BI Intelligence
  Platform
• Major styles of BI are
• Ad Hoc Query (OLAP) and Analysis on real world
  data using OLAP functionality such as drill
  down, pivot, subtotal, sort, filter, rank, and
  export
• Statistical analysis and data mining on real
  world data
• Enterprise Reporting Reports can be received
  via any device (e-mail, printer, text message,
  PDA, pager, fax, and voice.

8
The MicroStrategy Home Page

• MicroStrategy Product Documentation
• MicroStrategy White Papers
• Scripted demo and tutorials
• MicroStrategy eTrainer
• MicroStrategy Anlytic Modules

9
MicroStrategy Anlytic Modules

• The modules allow you explore reporting and
  analysis in key functional areas (Customer,
  Finance, Sales)
• Customer analysis module
• point of sale data
• Demographic customer history information
• Customer segmentation
• Loyalty
• Cross-sell

10

• Financial Reporting Analysis Module
• Analysis of financial information captured by
  general ledger, forecasting systems, etc.
• Analysis of A/P, A/R, BS, Profit and loss,
  expenses, and forecasting

11

• Sales force analysis module
• Analysis of info captured during the sales
  process (point of sales and sales operations
  systems)
• Area of analysis include
• Leads
• Pipelines
• Pruduct
• Sales performance

12
In-Class Assignmentsclick Software
13
MicroStrategy 8 Biclick it
14
clickMicroStrategy Course Contents
15
clickLearn More, under MicroStrategy Scripted
Demo
16
In_class assignment

• Follow scripted demos steps 1-30 and the final
  outcomes must be exported as PDF files and upload
  them to the dropbox.

17
How to export? This example shows how to export
using the first tutorial. In fig 11, click on the
Report Menu select Export and PDF. Then,
you will see the following. Follow the similar
step to do the second titorial.
18
Step 13- add Prepared by your name as shown
below, click apply, in the next screen, click
export
19

• Upload your exported PDF files to the drop box.