#mstrworld. No Data Left behind: 20+ new data sources with new data preparation in MicroStrategy 10

#mstrworld

No Data Left behind: 20+ new data sources with

new data preparation in MicroStrategy 10

#mstrworld

MicroStrategy Analytics

Agenda

2

• Product Workflows

• Different Data Import Processes

• Product Demonstrations

• Data Preparation

• Product Demonstration

• Next Steps

#mstrworld

MicroStrategy Analytics

From Connect to Collaborate in Minutes

3

CONNECT

DISCOVER

SHARE

#mstrworld 4

In-memory

Databases (Row\Columnar), Warehouse, Appliance, OLAP, SaaS based apps, Cloud sources, Social Data, User/departmental data.

4

#mstrworld

Simpler and Richer Data Access – Files

Enhanced Import of Excel, CSV and Text Delimited

5

Support for all Text Delimiter files and Quotes (Single, Double)

Simple, Easy to use Drag & Drop Interface Option to add multiple files

Browse a folder from a personal computer OR from server

#mstrworld

#mstrworld

Simpler and Richer Data Access – Web Scraping

Import data from any HTML page

7

http://en.wikipedia.org/wiki/List_of_largest_UK_by_population

Automatically fetch data from HTML pages

Search for <table> Tags and scrap data into a tabular form

#mstrworld

Search

• Type a string and a list of potential string matches are displayed.

• For example – Typing GDP can automatically point to suggestions like GDP of US or GDP growth, GDP per capita.

Simpler and Richer Data Access – Public Data

Public Data Connector allows user to enrich their data with external data

8

Url Matches

• Based on the string searched, MicroStrategy automatically fetches all potential Wiki URLs that contain that string • In future, we will extend to

other external sources like data.gov et al.

Preview & Scrape

• Mouse over on any URL – highlights the sample data in that URL

• Data is scraped from wiki into tabular data.

#mstrworld

#mstrworld

Simpler and Richer Data Access – Files from SaaS apps

Enhanced Import of importing files from Dropbox, Google Drive

10

oAuth support for DropBox, GoogleDrive. No need for setup for MSTR Desktop.

Use Native API to fetch files

Easy to use Browser, with Drag & Drop interface

Schedule, Refresh data

Support for your own oAuth Application

#mstrworld

Simpler and Richer Data Access – Clipboard

Clipboard allows users to quickly type Lookup Data, or Paste personal data

11

Spreadsheet like interface to quickly type data – insert

row\column, delete row\column

Option to Edit, Wrangle, Schedule, Refresh Clipboard data

#mstrworld

Simpler and Richer Data Access – Database

Enhanced Import of importing Tables from Databases, Warehouse, Appliances

12

New in v10 is the ability to Pick multiple Tables and import it into a dataset.

One click menu option in Build a Query connector makes it easy to construct complex queries

#mstrworld

Graphic Query Interfaces - Access data without writing any code

#mstrworld

Simpler and Richer Data Access – BI Tools

Ability to Import data from other BI tools (SAP BOBJ, OBIEE, Cognos) allows MSTR 10 to compliment existing BI investments in organizations

14

Create a Connection using your credentials Paste the Report Web-service URL

1

2

#mstrworld

Simpler and Richer Data Access – Twitter Social Data

15

Tweet Analysis - Build Dashboard with sample data, aimed at quick & dirty market segmentation

Use the Replacement Dataset feature to point the sample Dashboard to a larger volume of Tweets

#mstrworld

#mstrworld

MicroStrategy Analytics

Agenda

17

• Brief guide through MicroStrategy Analytics Platform

• Products Offering and Feature Comparison

• Product Workflows

• Data Import

• Product Demonstration

• Data Preparation

• Product Demonstration

• Next Steps

• Questions

#mstrworld

Data Modeling – Building a MSTR Schema is easier than ever

Multi-source: Combine Data from multiple sources into a single dataset

18

Automatically create Attributes, Metrics, Joins and relationships

Create Multi-form Attributes

Create\Edit Relationships across attributes

Change Datatypes, Rename, Map to Project Attributes to inherit Project security Filters, et al

#mstrworld

Powerful Data Preparation for More Accurate Analysis

Empowering data analysts to deliver deeper insights with intuitive and integrated data wrangling capabilities

Streamlined Workflows

to parse and prepare data

Hundreds of Inbuilt Functions

to profile and clean data

Multi-Table In-Memory Support

from different sources

Automatically parse and prepare

data with every refresh

Create Custom Groups

On the fly and without coding

Local / URL Files

Hadoop Data Preparation New Integrated Data Preparation Capability Salesforce Twitter/Facebook

#mstrworld

User experience for Data Wrangling

20

Wrangling Functions Predictive Transformation based on User Interactions

History\Script

#mstrworld

Break down of the Data Wrangler Interface

21

• Predictive Engine that

translates User interactions as Regular Expression patterns

• How does it work?

– Generate candidate

suggestions patterns using user selects some Strings – Construct Regex pattern for

each candidate suggestion. For example - /[a-z] + Virginia/

– Rank suggestions

• Library of functions aimed at data

cleaning, transformation

– Remove Whitespaces

– Split By, On, Before\After

– Extract By, On, Before\After

– Find and Replace

– Duplicate

– Padding

– Concatenating

– And many more..

• Record all User interactions

as a Descriptive language.

• Support Undo\Redo

• Reuse script during Dataset

Refresh

• Export\Import Script so that it

can be applied to other datasets

#mstrworld

#mstrworld

Enterprise Data Discovery Hands-On Workshop

Intro to

Enterprise Data Discovery

Advanced Enterprise Data Discovery

• Connect to Advanced Data Sources

• Scrape data from web pages

• Create Advanced Metrics & Integrate D3 library

• Connect to Server for Governed Data Discovery

• Access Any Data and Prepare for Analysis

• Analyze Your Data and Visualize the Insights

#mstrworld