8 ms·

Can you elaborate on BI stack? How MS covers all chain?

by iwintermute 10y ago

broknbottle 10y ago
I believe he is referring to Business Intelligence.
- iwintermute 10y ago
  Yes, I got it, there's SSIS, DB/OLAP, but after that? and I'm not sure, that SSIS & etc. is present in Express version.
  - UK-AL 10y ago
    This is for developers building apps locally, you create your own dockerised container for prod. Express is basically free, its the real production versions that cost.
    - kemiller2002 10y ago
      What's interesting about MS too, is that depending on what you do, the production versions still aren't that much money. If you do any sort of commercial software development, MS will pretty much give you a bunch of free software (including MSSQL to a point) just to keep you on the stack and to advertise that you use their products over others. Between BizSpark and the Partnership Network, it's very reasonable.
  - coredog64 10y ago
    Not sure about 2016, but the 2012 version of Express did have a SKU that included SSRS. There are some limitations to the version. A looong time ago I wrote a utility[0] to work around some of those limitations as we had the licensed version but we were working with partners who had Express. There are also some questions/answers on StackOverflow [1] that suggest you can mostly get by with doing SSIS stuff against the Express version as well, but you don't get all the capabilities. [0] https://github.com/spc-ofp/RelinkSSRS https://github.com/spc-ofp/RelinkSSRS [1] http://stackoverflow.com/questions/292564/can-i-run-ssis-packages-with-sql-server-express-or-web-or-workgroup-editions http://stackoverflow.com/questions/292564/can-i-run-ssis-pac...
darylteo 10y ago
SQL Server, SSIS, SSAS, SSRS.
- petepete 10y ago
  and PowerBI https://powerbi.microsoft.com https://powerbi.microsoft.com
  - blahi 10y ago
    And Excel has cube formulas (= MDX) which can process both SSAS and Power BI datasets. It's not even funny how far ahead MS are in the BI space (ask $DATA shareholders). It's not healthy to be honest.
  - madenine 10y ago
    Loving Power BI. Dashboards, reports, etc are a pain - but its what the clients want. They don't really care what we're doing in the background, they just want their metrics and analytics reports. Power BI has made that part of my job 100x better.
    - thomasthomas 10y ago
      user management is a little cumbersome but overall i agree. theyre constantly adding integrations with google analytics ,tableau, marketo, etc too
  - eloff 10y ago
    PowerBI seems to work with other SQL databases as well looking at the front page? Does anybody know anything about that?
    - greggyb 10y ago
      Power BI can connect directly to many database engines. Queries are generated on the fly by the reporting engine in a proprietary language called DAX, and DirectQuery is a technology that translated DAX into SQL queries. This is a mode of operation that has been supported by Microsoft's SSAS OLAP engine for years. It works quite well, but you do run into some performance overhead with the transpiling step. Feel free to reach out if you have more detailed questions. I work for an analytics consultancy and we're a Microsoft partner. I live in the Microsoft data platform (SQL Server and all related products).

Can you elaborate on BI stack? How MS covers all chain?

broknbottle 10y ago

I believe he is referring to Business Intelligence.

iwintermute 10y ago
Yes, I got it, there's SSIS, DB/OLAP, but after that? and I'm not sure, that SSIS & etc. is present in Express version.
- UK-AL 10y ago
  This is for developers building apps locally, you create your own dockerised container for prod. Express is basically free, its the real production versions that cost.
  - kemiller2002 10y ago
    What's interesting about MS too, is that depending on what you do, the production versions still aren't that much money. If you do any sort of commercial software development, MS will pretty much give you a bunch of free software (including MSSQL to a point) just to keep you on the stack and to advertise that you use their products over others. Between BizSpark and the Partnership Network, it's very reasonable.
- coredog64 10y ago
  Not sure about 2016, but the 2012 version of Express did have a SKU that included SSRS. There are some limitations to the version. A looong time ago I wrote a utility[0] to work around some of those limitations as we had the licensed version but we were working with partners who had Express. There are also some questions/answers on StackOverflow [1] that suggest you can mostly get by with doing SSIS stuff against the Express version as well, but you don't get all the capabilities. [0] https://github.com/spc-ofp/RelinkSSRS https://github.com/spc-ofp/RelinkSSRS [1] http://stackoverflow.com/questions/292564/can-i-run-ssis-packages-with-sql-server-express-or-web-or-workgroup-editions http://stackoverflow.com/questions/292564/can-i-run-ssis-pac...

darylteo 10y ago

SQL Server, SSIS, SSAS, SSRS.

petepete 10y ago
and PowerBI https://powerbi.microsoft.com https://powerbi.microsoft.com
- blahi 10y ago
  And Excel has cube formulas (= MDX) which can process both SSAS and Power BI datasets. It's not even funny how far ahead MS are in the BI space (ask $DATA shareholders). It's not healthy to be honest.
- madenine 10y ago
  Loving Power BI. Dashboards, reports, etc are a pain - but its what the clients want. They don't really care what we're doing in the background, they just want their metrics and analytics reports. Power BI has made that part of my job 100x better.
  - thomasthomas 10y ago
    user management is a little cumbersome but overall i agree. theyre constantly adding integrations with google analytics ,tableau, marketo, etc too
- eloff 10y ago
  PowerBI seems to work with other SQL databases as well looking at the front page? Does anybody know anything about that?
  - greggyb 10y ago
    Power BI can connect directly to many database engines. Queries are generated on the fly by the reporting engine in a proprietary language called DAX, and DirectQuery is a technology that translated DAX into SQL queries. This is a mode of operation that has been supported by Microsoft's SSAS OLAP engine for years. It works quite well, but you do run into some performance overhead with the transpiling step. Feel free to reach out if you have more detailed questions. I work for an analytics consultancy and we're a Microsoft partner. I live in the Microsoft data platform (SQL Server and all related products).