SSAS Other Presentation Tool

IC IC 236 Reputation points
2020-10-15T07:54:41.203+00:00

Hi,

I have a sql enterprise 2014 with SSIS, SSAS, SSAS Tabular & Powerbi

Powerbi is used more for gaphical view of cubes, with olap presnted in excel

Mostly finance users so they love their excel but i have other business units who would like more analytics

  1. is there other options to present ssas cube but not excel & powerbi?
  2. I thought of olap online or in cloud?
  3. More self service tool, connecto to dw and users drag and drop their dim etc

I'm trying to bridge the gap between excel olap finance users and powerbi, analtical tool on top of olap or onto data warehouse
Excel Olap > ? > Powerbi or even on top of powerbi

Please help, i need to evolve and data storage to azure is not an option

regards

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,231 questions
{count} votes

8 answers

Sort by: Most helpful
  1. Olaf Helper 38,861 Reputation points
    2020-10-16T05:53:27.327+00:00

    which one is the best?

    That depends on your requirements and preferences.
    I still prefer Excel, easy to use, supports cube formula for further calculation and many more features.

    1 person found this answer helpful.
    0 comments No comments

  2. m 4,266 Reputation points
    2020-10-15T08:04:39.963+00:00

    Hi @IC IC ,

    Duplicated? Please reference my reply from this case: ssas-other-presentation-tool.html

    BR,
    Mia


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  3. IC IC 236 Reputation points
    2020-10-15T08:05:56.007+00:00

    Apologies, i really didnt know where. Please close this one


  4. Olaf Helper 38,861 Reputation points
    2020-10-15T11:34:50.477+00:00
    0 comments No comments

  5. IC IC 236 Reputation points
    2020-10-15T19:15:47.137+00:00

    Thank You, which one is the best?
    I want to keep excel but move to biggr things

    0 comments No comments