I think the first step is finding the right tool for the job. For doing analytics, I would recommend an analytics reporting tool (SAS Visual Analytics, PowerBI, Excel, Tableau, etc). I wouldn't use SSMS as an analytics tool myself except for some small one-off analytic things.
If you don't have any analytical tools except Excel, I would pull the data from the cube into a worksheet with the "raw" data. Once you have that, you can do all sorts of fun stuff with the data. Formulas on the data (COUNT, COUNTIF, COUNTIFS), pivot tables, power pivot, etc. Something to note though - if you start doing a LOT of calculations on the data, it can get slow. COUNTIFS are notorious for slowing things down. But even without using power pivot, pivot tables on your data will give you exactly what you are looking for.
Pull the data into a worksheet (I usually name it something like "RAW DATA" so it can be validated if end users think the pivot tables are bad), then make a new worksheet called something like Analytics. Then you use a pivot table on the raw data and add things as you see fit. You can filter the data, group the data, do aggregates on the data, graph the data... it's a powerful tool. The downside is it is all running on your local machine. This is a downside because servers generally have beefier cores and more memory than a workstation and that is where tools like PowerBI, Tableau, SAS VA, etc come into play.
The other nice thing with Excel is that end users can refresh the data to show current, or they can prepare the data (for example, before a meeting) and have a snapshot. Some of the other tools are not very good at "snapshot" data.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!