30 Dec 2014
Looking to get up to speed with Power BI in limited time? You might be interested in this. ”Power BI fundamentals” is a new course published to Microsoft Virtual Academy:
http://www.microsoftvirtualacademy.com/training-courses/excel-2013-power-bi-fundamentals
Enjoy!
23 Dec 2014
Here is a short video on how to connect to Salesforce.com from Power BI:
https://www.youtube.com/watch?v=ZVxRqUwUs3Q
You can now easily get data from Salesforce.com into your Excel / Power BI solution. Enjoy!
16 Dec 2014
Here is a short how-to video on how to connect to SAP Business Objects Universe through Power BI:
https://www.youtube.com/watch?v=Ay-J0ddBpRk
Enjoy!
25 Nov 2014
The First Look series focusses on new products, recent announcements, previews or things I have not had the time to provide a first look at and serves as introduction to the subject. First look posts are fairly short and high level.
In this First Look: Azure DocumentDB. DocumentDB is a NoSQL document database service designed for mobile / web applications. Since it is a NoSQL database it is a schema-free system it allows flexible storage and processing of data with scale up and down on demand, while still allowing easy querying using a SQL dialect. As such it operates in the same space as other NoSQL systems such as Cassandra, MongoDB, HBase and CouchDB and provides a feature-rich, cost effective and enterprise ready solution.
Development against DocumentDB can be done using .NET, Node.js, JavaScript and Python. On top of this DocumentDB provides a SQL Query language and it is elastically scalable both on throughput and storage.
More info is available at http://azure.microsoft.com/en-us/documentation/articles/documentdb-introduction/.
More to come!
18 Nov 2014
The First Look series focusses on new products, recent announcements, previews or things I have not had the time to provide a first look at and serves as introduction to the subject. First look posts are fairly short and high level.
Today in First Look: Azure Stream Analytics. This service is currently in preview and provides low latency, high available and scalable complex event processing in the cloud. To do complex event processing SQL Server has StreamInsight; with Azure Stream Analytics we provide a CEP engine in the cloud.
Azure Stream Analytics is built to read data from a source, let’s say a device sensor and collect, process and take action on it in a blink of the eye. A simple example would be to read temperatures from a sensor, aggregate them to calculate an average temperature per 5 seconds and store that data into SQL server. Or a fairly more complex example would be to take output from a video camera that reads license plates, run the license plate through a list of license plates of stolen cars and immediately send a message to a police car nearby.
Because this solution is cloud based it is easy to get started. You can be up and running in literally minutes.
More info is available on http://azure.microsoft.com/en-us/documentation/articles/stream-analytics-introduction/
More to come!