Intro to Azure Analysis Services

Azure Analysis Services is essentially Analysis Services from SQL Server served as a platform-as-a-service in the Microsoft Azure cloud. The following are the steps I have taken to build, deploy and use Analysis Services for business intelligence. To get a complete overview and see more comprehensive steps, read What is Azure Analysis Services? In the … Continue reading Intro to Azure Analysis Services

A Basic Demo of an Azure Machine Learning Experiment

In the recent months, the hype around Machine Learning has caught my attention. Therefore, I spent reading articles and watching videos and university lectures on the topic. Wearing the developer hat, I wondered how a developer can build a machine learning solution in Azure. This blog post hopes to share how I built a machine … Continue reading A Basic Demo of an Azure Machine Learning Experiment

Building a Spark Application for HDInsight using IntelliJ Part 2 of 2

In continuation from my blog article Building a Spark Application for HDInsight using IntelliJ Part 1 of 2 which outlines my experience in installing IntelliJ, other dependent SDKs and creating an HDInsight project. To add some code, right click src, create Scala Class Project folders and MainApp Scala code: Logic Read from csv file in … Continue reading Building a Spark Application for HDInsight using IntelliJ Part 2 of 2

Re-Create HDInsight Cluster with Pre-Existing Azure Data Lake Store and Hive Metastore

Upon creating an HDInsight cluster for big data analytics development, the costs can be quite high at around $4 an hour. This adds up, especially when running idle most of the time. To save on the costs, I delete the cluster and re-create when needed. For simple development purposes, my HDInsight depends on Azure Data … Continue reading Re-Create HDInsight Cluster with Pre-Existing Azure Data Lake Store and Hive Metastore

Text Analytics of Movie Reviews using Azure Data Lake, Cognitive Services and Power BI (part 1 of 2)

Part 1 of 2: Text Analytics of Movie Reviews using Azure Data Lake, Cognitive Services and Power BI (part 1 of 2) Take a csv file, analyze with an U-SQL script in Azure Data Lake Part 2 of 2: Text Analytics of Movie Reviews using Azure Data Lake, Cognitive Services and Power BI (part 2 of 2) … Continue reading Text Analytics of Movie Reviews using Azure Data Lake, Cognitive Services and Power BI (part 1 of 2)

HiveQL Group By and Views with Visual Studio and HDInsight

This article is for beginners looking to understand the developer experience in Visual Studio and working with hive tables in HDInsight. I developed the following HiveQL statements. My cluster is HDInsight Spark 2.0 cluster. Before executing these statements, I have the database and tables: The crimes table data looks like: Let’s query the table with … Continue reading HiveQL Group By and Views with Visual Studio and HDInsight