Viewing 15 posts - 1 through 15 (of 37 total)
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...
July 26, 2016 at 9:03 am
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...
July 26, 2016 at 6:56 am
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...
May 4, 2016 at 1:08 pm
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.
May 4, 2016 at 9:22 am
Great post. One page and 20 minutes of work to move a database to Azure. Love it.
April 21, 2016 at 9:49 am
Thanks for your suggestion. I will forward it to our web developers. Do you work for Microsoft?
September 9, 2015 at 11:42 am
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?
January 2, 2015 at 8:01 am
Are you using T-SQL or MDX for your datasets? There will be different approaches based on different SQL services.
December 29, 2014 at 12:46 pm
I don't think you can. You may have to create 3 datasets in SSRS with 3 different SP's.
December 1, 2014 at 12:19 pm
It would help if you added your query
November 3, 2014 at 10:02 am
Here is a good start for R
"R for Everyone Advanced Analytics and Graphics" by Jared P. Lander
November 3, 2014 at 9:54 am
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.
September 9, 2014 at 6:34 am
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....
January 6, 2014 at 11:43 am
Will share this article with others at the office.
August 5, 2013 at 8:16 am
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.
June 27, 2013 at 8:43 am