![]() Subsequently, you might want to use a slicer ( 01:59), to add the sales territory, to permit a more in-depth analysis of the sales figures, and so on, adding more slicers as you need to. For example, as shown in this video ( 00:59), you can first slice-and-dice sales amounts by the date of the sale and the product categories. While older versions supported cubes, Excel 2010 introduced s licers, which allow for truly multidimensional analysis, as you can now add any number of dimensions to your worksheet, easily allowing for even complex filtering scenarios. ![]() If you use Microsoft Office, however, it is hard to beat the familiarity of Excel coupled with its deep cube integration, including even more specialised features, such as What-If analysis (cube writebacks). There are many tools that can be used to work with OLAP cubes running inside SQL Server Analysis Services (SSAS). In this short demo you can also see how to perform basic slice-and-dice analysis, drill into and filter using dimensions, and summarise trends with a sparkline. For most people, the easiest tool for opening and navigating a multidimensional (OLAP) cube is Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |