{"id":661,"date":"2020-04-08T18:52:42","date_gmt":"2020-04-08T18:52:42","guid":{"rendered":"http:\/\/puneetkhosla.com\/?p=661"},"modified":"2020-04-08T18:53:42","modified_gmt":"2020-04-08T18:53:42","slug":"what-is-dataset-in-einstein-analytics","status":"publish","type":"post","link":"https:\/\/puneetkhosla.com\/?p=661","title":{"rendered":"What is Dataset in Salesforce Einstein?"},"content":{"rendered":"\n<p>A <strong><span class=\"has-inline-color has-bright-blue-color\">dataset<\/span><\/strong> is simply a collection of rows and columns. If you have used Excel or Google Sheets, then one dataset is one worksheet. If you have built databases, it is one table. <\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-bright-blue-color\">Column<\/span><\/strong> of the dataset indicates various fields.  <strong><span class=\"has-inline-color has-bright-blue-color\">Rows<\/span><\/strong> of the dataset indicates various records.<\/p>\n\n\n\n<p>A dataset can contain the following type of data\n<ul> <li> <strong><span class=\"has-inline-color has-bright-blue-color\">Dimension <\/span><\/strong><\/li>\n<li> <strong><span class=\"has-inline-color has-bright-blue-color\">Measure<\/span><\/strong> <\/li>\n<li> <strong><span class=\"has-inline-color has-bright-blue-color\">Date<\/span><\/strong> <\/li>\n<\/ul>\n<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-bright-blue-color\">Dimension<\/span><\/strong> is a qualitative value \/ text \/  a field that you want to group your data with \/ measure your data against \/ use it as filter eg: City Name, Status, Salesperson, product number, etc. A number (like Product Number) can also be a dimension as the number represents something you can group by. In a Lens (Chart) Dimension is used in <strong><span class=\"has-inline-color has-bright-blue-color\">Bar<\/span><\/strong> &amp; <strong><span class=\"has-inline-color has-bright-blue-color\">Filter<\/span><\/strong>.<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-bright-blue-color\">Measure<\/span><\/strong> is a quantitative value \/ number \/ a field that gives actual value eg: Amount, Number of Cases, etc. While creating the dataset, it is important to identify the value fields and ensure that the column is marked as Measure.  A measure can further be aggregated (like Count of Rows , Sum of Rows, etc.). In a Lens (Chart) Measure is used in <strong><span class=\"has-inline-color has-bright-blue-color\">Bar Length<\/span><\/strong> &amp; <strong><span class=\"has-inline-color has-bright-blue-color\">Filter<\/span><\/strong>.<\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-bright-blue-color\">Date<\/span><\/strong> is used to denote Date fields in Dataset. If we mark the column as Date, then it helps in analysis by automatically allowing the grouping \/ filtering by Days, Months, Year and also Relative Dates like Last Week, Last Month, etc. In a Lens (Chart) Date is used in <strong>Bar<\/strong> &amp; <strong>Filter<\/strong>. <\/p>\n\n\n\n<p>Once the dataset is setup and ready to use, we can then build various charts and dashboards on top the datasets to provide useful analysis and insights for the business.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A dataset is simply a collection of rows and columns. If you have used Excel or Google Sheets, then one dataset is one worksheet. If you have built databases, it is one table. Column of the dataset indicates various fields. Rows of the dataset indicates various records. A dataset can contain the following type of [&hellip;]<\/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],"tags":[15,11,12,16],"class_list":["post-661","post","type-post","status-publish","format-standard","hentry","category-einstein","tag-dataset","tag-einstein","tag-einstein-analytics","tag-salesforce"],"_links":{"self":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/661","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=661"}],"version-history":[{"count":6,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/661\/revisions"}],"predecessor-version":[{"id":667,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=\/wp\/v2\/posts\/661\/revisions\/667"}],"wp:attachment":[{"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/puneetkhosla.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}