We don't have data warehouse, we want to add Reports in SharePoint dashboard designer from SharePoint list as data-source, but Reports accepts only analysis service as Data source.
So can anyone guide me step by step guide how to create Analysis Service Data-Source ( cubes, Di-mentions, measures) from SharePoint lists ?