3 ms·
The closest I've seen anyone come to this "dream" scenario is PowerBI. It's very visual and drag & drop, with practically no coding or query language skills req
by jiggawatts 7y ago
The closest I've seen anyone come to this "dream" scenario is PowerBI. It's very visual and drag & drop, with practically no coding or query language skills required. Yet, it can automatically generate insanely complex queries that even a seasoned developer would struggle to write manually.
- Discombulator 7y agoPowerBI is an interesting case. As long as you do “run of the mill” business analytics (Star or snowflake tables, “simple” aggregations) it is like you say. But once you need something different, you’re in for some serious rethinking and coding. I have this article printed out in a drawer for these cases: http://mdxdax.blogspot.com/2011/03/logic-behind-magic-of-dax-cross-table.html http://mdxdax.blogspot.com/2011/03/logic-behind-magic-of-dax... With DAX, Microsoft has extended the PivotTable model (instead of the relational model), and they deserve full respect for trying something new in this space. Is it a simpler model? I kinda like it, but don’t think it is simpler.