Power BI integrated with Azure Stream Analytics
One of the common use cases for Azure Stream Analytics is to analyse high volume streaming data in real-time and get the insight in a live dashboard (a dashboard that updates in real time without user having to refresh the browser). Microsoft Power BI is perfect for building a live dashboard in no time. Check out this Power BI and Azure Stream Analytics demo video to see how easy it is. Power BI output makes it very easy to uncover real-time insights (IoT) from devices, sensors and applications data in a live real-time updating dashboard!
Read MoreAzure, Mobility and Big Data dominates at Microsoft’s Build 2015 Conference
Satalyst’s Chief Technical Officer, Aidan Morgan, has returned from Microsoft’s Build 2015 developers’ conference in San Francisco. Some of the fun and more buzzworthy sessions and demos outside the keynote addresses were around Microsoft’s efforts for the Internet of Things (both with Windows 10 and Azure) and the “Holographic Academy” sessions for Microsoft’s HoloLens. But the dominant themes were around Azure, mobility and big data. Azure data centres now support 19 unique regions around the world, more than Amazon Web Services and Google’s cloud. In the past year alone, Microsoft launched 500 new Azure services. In his keynote speech, Scott Guthrie (Executive VP of the Cloud and Enterprise group) announced new options for big data: Azure SQL data warehouse service – a broad-scale data warehousing platform that runs in the cloud; and a Azure Data Lake – a hyper-scale data store for big data analytic workloads integrated with Azure Machine Learning and other big data services from Microsoft. Read from Scott Guthrie on Microsoft’s Official Blog.
Read More
Power Query: How to iterate over a list
If you’ve been using Power BI or you’ve seen the demos, then like me, you’re probably excited about Power Query. As a data nerd, I’ve been having a lot of fun pulling data sets off the web and mashing them up. Getting web data used to be quite a manual task for me, since I wasn’t about to write a custom screen-scraper. I really love the “From Web” functionality that mines web pages for HTML tables. But I’m a developer, so of course, I wanted to load a list of files, or a list of websites, and I had some trouble figuring out how to do it. Hopefully, my experiences will help someone else. One of the tricks that I found was that the list that you want to iterate over has to be pulled into Power Query designer. So let’s start with looping over a list of files – this is something that EVERYONE will want to do at some point. So first, launch the Power Query designer from the Power Query ribbon, and use the folder that you want as your data source: As you can see, you get a lot of meta data about your folder contents. The most important…
Read More