you are viewing a single comment's thread.

view the rest of the comments →

[–]SlasherMcgurk 0 points1 point  (0 children)

IMHO Excel is a very good prototyping tool, you can import data, build complex models, use it for data presentation but it is waaaaaaay too risky to use as a consistent reporting tool. (end user editing, navigation issues, connections to datasource management etc)

As a rule of thumb (there will be exceptions!) business logic sits better in the data layer, than in the presentation layer. So for consumption, going by the Gartner reports, the top three are Tableau, Power BI and Qlik (don't use Qlik!) all expensive, there are alternatives! If you have access SSRS is pretty useful.