EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

How to Wrangle Your Data with MicroStrategy Desktop (Video)


Stefan Zepeda

Salesforce Solutions Architect • Strategy


The Part 1 video covers basic data wrangling features, such as converting attributes to metrics, filling in empty cells in a column, history script, and profiling data using text/number facets. The Part 2 video covers additional data wrangling features, such as splitting columns, transformation functions, advanced faceting, and history script saving & loading

Once data is imported into Strategy, it is instantly available for Data Discovery. Optionally users have the means  to enrich and reorganize using the Data Wrangler.  The following two videos illustrate how to add data from a spreadsheet and how to prepare it for analysis using Data Wrangler.
​
 The Part 1 video covers basic data wrangling features, such as converting attributes to metrics, filling in empty cells in a column, formatting the contents of column, history script, and profiling the data in a column using text/number facets to fix spelling errors or any other inconsistencies.
  ​
The Part 2 video covers additional data wrangling features such as splitting columns, replacing values of a column, changing data types, transformation functions, advanced faceting using "cluster and edit" function, and history script saving & loading.


Comment

0 comments

Details

Knowledge Article

Published:

April 4, 2017

Last Updated:

April 6, 2017