{"id":668,"date":"2020-04-12T21:39:50","date_gmt":"2020-04-12T21:39:50","guid":{"rendered":"http:\/\/puneetkhosla.com\/?p=668"},"modified":"2021-04-14T05:15:21","modified_gmt":"2021-04-14T05:15:21","slug":"create-a-dataset-with-csv-file","status":"publish","type":"post","link":"https:\/\/puneetkhosla.com\/?p=668","title":{"rendered":"Create a Dataset with CSV file"},"content":{"rendered":"\n

Lets start creating the first dataset (you can read more about dataset in my blog on Datasets – Click Here<\/a>) using a CSV file. <\/p>\n\n\n\n

STEP 1 : Click on Create Button & Select Dataset<\/span><\/strong><\/p>\n\n\n\n

There are multiple ways to start creating a dataset. After entering Analytics Studio, you can either click on the “Create<\/span><\/strong>” button (on the top right corner) or you can go into your Einstein Analytics app and click the button, etc. Select Dataset.
<\/p>\n\n\n\n

\"Create<\/figure>\n\n\n\n

STEP 2 : Choose Data Source<\/span><\/strong><\/p>\n\n\n\n

Choose CSV File as we are creating dataset from csv.<\/p>\n\n\n\n

\"Data<\/figure>\n\n\n\n

STEP 3 : Upload the CSV File<\/span><\/strong><\/p>\n\n\n\n

Upload \/ Drag and Drop the csv file to upload. Here we are uploading Opportunity Data. I am using the data available in my org (built as part of one of the trailhead modules)<\/p>\n\n\n\n

\"File<\/figure>\n\n\n\n

STEP 4 : Define the properties of the Dataset<\/span><\/strong><\/p>\n\n\n\n

This is the place to give the name and the App where you want to save the dataset. You can also check the file properties (Auto detected) in case it needs a change. Data Schema file will be covered in later blogs, however the file (also known as Extended Metadata or XMD file) is used for some formatting options of the dataset fields and their values. Click Next button to move to the next step.<\/p>\n\n\n\n

\"New<\/figure>\n\n\n\n

STEP 5 : Preview and Edit the Field Attributes<\/span><\/strong><\/p>\n\n\n\n

This step now allows you to preview the data being loaded and to change any settings. This is the step where you define the type of column (Dimension, Measure and Date) and set its attribute. By default Einstein Analytics automatically detects the data type but you can change it as well.<\/p>\n\n\n\n

In this step, you can check the fields that would be part of the dataset. As we can see we have Account.Name, Amount, CloseDate, Id, etc. as the columns (or fields) of the dataset.<\/p>\n\n\n\n

\"Dataset<\/figure>\n\n\n\n

You can preview the data getting loaded. Here I have a screen of 3 columns, where we will now make some changes.<\/p>\n\n\n\n

\"Edit<\/figure>\n\n\n\n

We have a column as Account.Name. This is because in Opportunity Data, we also extracted Parent Account’s Name field and in the csv it got extracted as Account.Name. Further to note Analytics Studio automatically picked the field as dimension (qualitative value).<\/p>\n\n\n\n

\"Dimension<\/figure>\n\n\n\n

You can choose to fix column name in CSV file before loading or you can change the field label in this Step. So now we will change Account.Name to Account.<\/p>\n\n\n\n

\"Changing<\/figure>\n\n\n\n

The Next field to check is the Amount field. This field is auto-detected as a Measure (value) field as the data in this column is numeric.<\/p>\n\n\n\n

\"Measure<\/figure>\n\n\n\n
\"Measure<\/figure>\n\n\n\n

Since its a currency, we will change the number format to 0.00. Furthermore we will add a grouping symbol and a Decimal Symbol to our data.<\/p>\n\n\n\n

\"Changing<\/figure>\n\n\n\n

We will now check the Close Date field. This field is of type Date which has been auto-picked by Einstein Analytics.<\/p>\n\n\n\n

\"Date<\/figure>\n\n\n\n

After doing checks \/ changes to the attributes of the fields, we move to the next step.<\/p>\n\n\n\n

STEP 6 : Einstein builds Dataset<\/span><\/strong><\/p>\n\n\n\n

This is where Einstein Analytics Engine builds the dataset. It can take a few seconds for the while to load. Though I like the page as we can see Mr. Einstein doing the magic.<\/p>\n\n\n\n

\"Creating<\/figure>\n\n\n\n

STEP 7 : Review the prepared Dataset<\/span><\/strong><\/p>\n\n\n\n

Once the dataset is loaded, you will automatically get transferred to the dataset page. There you can check your dataset properties and also add Security predicates and XMD file. A good check here is to check the number of rows loaded.<\/p>\n\n\n\n

\"Dataset\"<\/figure>\n\n\n\n

You can even the view the dataset data by clicking “Explore” button. This opens a Lens where you can add your filters, bars (or the dimension) , bar length (measure or calculation on measure)metc. and choose a chart to display.<\/p>\n\n\n\n

I added a filter saying Account contains “Einstein”. Bar Length has been kept as Sum of Amount. Bars have been kept as Closed Date (Quarter) and Account (and not Account.Name). Just to add, we only loaded Closed Date, however Einstein Analytics provided us with various groupings like Year, Quarter, Month, Year-Month, Year-Month-Day, etc.<\/p>\n\n\n\n

\"Lens<\/figure>\n\n\n\n

We will soon use this dataset in our dashboard. <\/p>\n","protected":false},"excerpt":{"rendered":"

Lets start creating the first dataset (you can read more about dataset in my blog on Datasets – Click Here) using a CSV file. STEP 1 : Click on Create Button & Select Dataset There are multiple ways to start creating a dataset. After entering Analytics Studio, you can either click on the “Create” button […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7,21],"tags":[11,12,13,16,22],"class_list":["post-668","post","type-post","status-publish","format-standard","hentry","category-einstein","category-tableau-crm","tag-einstein","tag-einstein-analytics","tag-einstein-discovery","tag-salesforce","tag-tableau-crm"],"_links":{"self":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=668"}],"version-history":[{"count":23,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/668\/revisions"}],"predecessor-version":[{"id":713,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/668\/revisions\/713"}],"wp:attachment":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}