I totally agree with you on Azure DB taking over transactional SQL servers. We already use number of web apps connected to Azure DB. However, we still keep a...

Azure Database is a database not a server. Imagine you create a database on your on premises SQL Server and give access to your developers. Your programmers will...

You are correct. It is the hardest. But for some reason Microsoft is including R in SQL server 2016 and Power BI and seems that it will be...

I would add that there is a third way of analytics in Microsoft Universe. Writing your own code directly in R and using 2016 SSRS to display results.

Great post. One page and 20 minutes of work to move a database to Azure. Love it.

Thanks for your suggestion. I will forward it to our web developers. Do you work for Microsoft?

That is an interesting problem. How do you currently handle your Territories? Do you have separate Territory dimension or is it part of the Customer dimension?

Are you using T-SQL or MDX for your datasets? There will be different approaches based on different SQL services.

I don't think you can. You may have to create 3 datasets in SSRS with 3 different SP's.

It would help if you added your query

Here is a good start for R

"R for Everyone Advanced Analytics and Graphics" by Jared P. Lander

Great topic, very short article. I think you should follow with more details. For example; try to explain why the year Dimension only has 2 columns.

You were hired as a BI specialist and sooner or later you will be asked for BI solutions. Therefore, I would start working on multidimensional or tabular models ASAP....

Will share this article with others at the office.

Will the Big Data replace Data Warehouse technology? The experts say no.

However, Big Data will change the way we look at data. Good article, nice summary.