How to upload a file to Windows Azure Blob Storage with C# .Net described in a single Picture.
A workaround to use Power Query with SSIS Script Task
M is quite a nice language for Self Service ETL. The logical next step would be to include the Power Query functionality as a component in SSIS. As of now there is just the following Workaround. (Which is btw not supported but works quite well.) Create an Excel Workbook that contains the M-query and loads
Visualize Climate Change with Excel 2013 – Typhoon Haiyan – 400.000 Tweets analyzed with Microsoft`s Big Data Technology
Update 1.8.2014 This tutorial describes how to build a self service ETL solution with Excel 2013 Power Query to gather climate data from different public sources and visualize them with Power Map. The following animation is the result when you render out the story from Excel. It illustrates the intensity of tropical storms in the
SQL 2012 Operations Research – Simulated Annealing implemented in T-SQL can cut CO² Emission / Traveltime and Cost by more than 30%
Many organizations face combinational problems. Our service division has a quite interesting one. The assignment of engineers to customer workshops. The following screenshot illustrates the issue. (planned Workshop Travel EMEA subset of data) Assume Microsoft would just employ 2 engineers and would be asked to deliver 3 workshops (W1,W2,W3). Lets assume all engineers are skilled
Reporting Services Data Driven Subscriptions with Multi Value Parameters
To send a parameterized report to a list of subscribers we can use the Data Driven Subscription. If the WHERE condition in the Report Dataset just contains single parameter values (something like: Select * From Sales where Department = 123) the setup is fairly simple. (There is already a documentation on how to achieve that:
Data Explorer and Power View to analyse Stock Market Insider Trades
Boardmembers of market-listed corporations are liable to publish their share transactions. You can lookup these announcements at msn.com-> http://investing.money.msn.com/investments/insider-transactions?symbol=MSFT Yet it was quite difficult to extract all the data directly from the website. Now with the new Data Explorer it just takes a few minutes to download all the information to excel and do exciting analysis. Here is an example: The following chart