News for hackers. Stuff that matters.
Re:Microsoft SQL Server 2016 Express by iwintermute on Wednesday October 12, 2016 @07:23AM (#12691912)
Can you elaborate on BI stack? How MS covers all chain?
Re:Microsoft SQL Server 2016 Express by darylteo on Wednesday October 12, 2016 @07:49AM (#12692016)
SQL Server, SSIS, SSAS, SSRS.
Re:Microsoft SQL Server 2016 Express by petepete on Wednesday October 12, 2016 @08:31AM (#12692211)
Re:Microsoft SQL Server 2016 Express by blahi on Wednesday October 12, 2016 @10:07AM (#12692920)
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.

Re:Microsoft SQL Server 2016 Express by madenine on Wednesday October 12, 2016 @10:18AM (#12693029)
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.

Re:Microsoft SQL Server 2016 Express by thomasthomas on Thursday October 13, 2016 @03:11AM (#12699043)
user management is a little cumbersome but overall i agree. theyre constantly adding integrations with google analytics ,tableau, marketo, etc too
Re:Microsoft SQL Server 2016 Express by zaroth on Wednesday October 12, 2016 @12:36PM (#12694340)
It looks really pretty. But, am I right in saying that this all works by sending all your critical business data to Microsoft servers to run the analysis and generate the reports? Businesses actually do this?

Why would you send data offsite to generate pretty graphs of it? Is this really not available as a self-hosted service?

Re:Microsoft SQL Server 2016 Express by greggyb on Wednesday October 12, 2016 @01:43PM (#12694984)
Microsoft is cloud-first in development now.

There is a Power BI Desktop program that is 100% free as in beer available, which runs a private instance of an in-memory columnstore OLAP engine, Power Pivot (same internals as SSAS). It also includes the reporting layer and Power Query, a lightweight ETL tool.

There is an on-prem version of Power BI that the team has committed to including as a feature of SSRS in SQL Server 2016, but the timeline is still fuzzy.

The point of the Power BI hosted portal is not the pretty visuals, but a low-maintenance collaboration portal that includes natural language Q&A on your data, automatic analysis to identify trends in the data, and tight integration with Office 365.

If you want to go on-prem, there is a third party named Pyramid Analytics which offers a solution that allows Power BI hosting.

Power BI is actually a continuation of a number of products. If you want a somewhat equivalent experience on-prem, you can use Power Pivot in Excel (2010+), with Power View on SharePoint (SSRS 2012+, SharePoint 2010+), which gives you an older Silverlight-based report engine that has similar capabilities.

The real useful piece, though is the semantic layer in Power Pivot, which is identical to SSAS. The power in any BI tool is not the reporting layer (though Power View is a pretty good one for the use cases it targets), but in the power and expressivity of the data model. This is an area where Microsoft shines.

I could go on for hours about this - I work in technical presales (and do at least 50% time in a technical delivery role) for an analytics consulting firm that is a Microsoft partner.

Re:Microsoft SQL Server 2016 Express by blahi on Wednesday October 12, 2016 @03:17PM (#12695713)
Of course they have on-prem versions. A lot of people are content with using cloud services though, so on-prem solutions cost a pretty penny.
Re:Microsoft SQL Server 2016 Express by greggyb on Wednesday October 12, 2016 @05:41PM (#12696621)
See my sibling. There is no Microsoft offering for on-prem Power BI. You can get close to it with sibling products on SharePoint.

There is a third party offering an on-prem solution.

Re:Microsoft SQL Server 2016 Express by blahi on Thursday October 13, 2016 @01:56AM (#12698796)
There's Pyramid Analytics which is officially endorsed by Microsoft as "Power Bi onprem" and present on the Power BI's homepage.
Re:Microsoft SQL Server 2016 Express by greggyb on Thursday October 13, 2016 @06:06PM (#12704475)
Pyramid is the third party I mentioned in my post. It is not a Microsoft product, as I mentioned in my post.

Pyramid offers .pbix file hosting and web rendering. It does not offer the Power BI portal that is a cloud offering from Microsoft. There is a big difference between these things.

Re:Microsoft SQL Server 2016 Express by eloff on Wednesday October 12, 2016 @11:53AM (#12693952)
PowerBI seems to work with other SQL databases as well looking at the front page? Does anybody know anything about that?
Re:Microsoft SQL Server 2016 Express by greggyb on Wednesday October 12, 2016 @05:45PM (#12696652)
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).

Re:Microsoft SQL Server 2016 Express by broknbottle on Wednesday October 12, 2016 @07:29AM (#12691936)
I believe he is referring to Business Intelligence.
Re:Microsoft SQL Server 2016 Express by iwintermute on Wednesday October 12, 2016 @07:43AM (#12691989)
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.
Re:Microsoft SQL Server 2016 Express by coredog64 on Wednesday October 12, 2016 @10:59AM (#12693439)
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 [1] http://stackoverflow.com/questions/292564/can-i-run-ssis-pac...

Re:Microsoft SQL Server 2016 Express by UK-AL on Wednesday October 12, 2016 @08:50AM (#12692309)
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.

Re:Microsoft SQL Server 2016 Express by kemiller2002 on Wednesday October 12, 2016 @09:50AM (#12692772)
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.