Scaling Azure Data Warehouse using Azure WebJobs Scheduler

~ nikilprabhakar ~ Leave a comment

Following link looks into various options available to scale compute power in Azure SQL Data Warehouse. Next question that one would ask is, how do I automate the capability to scale the compute power. In this article, I answer the question using Azure WebJobs. Azure WebJobs provide an easy way to run scripts or programs … Continue reading Scaling Azure Data Warehouse using Azure WebJobs Scheduler

How to Publish Azure Data Factory Artifacts

~ nikilprabhakar ~ Leave a comment

Azure Data Factory artifacts can be edited and deployed using the Azure portal. However, as an enterprise solution, one would want the capability to edit and publish these artifacts using Visual Studio. Let’s check are options available to publish using Visual Studio. Assuming you have the created a Data Factory project in Visual Studio and … Continue reading How to Publish Azure Data Factory Artifacts

Power BI Tutorial: Dynamically update Date slicer to show Current Date

~ nikilprabhakar ~ 10 Comments

Here is a common requirement that I have come across: “I want the Date slicer to automatically select current date without me having to manually change the slicer”. Here is a way to do that. We have a Power BI Desktop report that was created on April 10th 2016. When the report was created, we … Continue reading Power BI Tutorial: Dynamically update Date slicer to show Current Date

As a Vote of Non-Confidence to Its Own BI Strategy, SAP just acquired Roambi

~ Business Intelligist ~ 1 Comment

  In a not particularly surprising move, SAP's knee-jerk reaction to its a dramatic fall in Gartner BI Rankings has resulted in a yet another acquisition. I was wondering about this scenario in my previous post about Tableau's stock taking a dive, where I pondered whether SAP had enough cash to acquire the company. It … Continue reading As a Vote of Non-Confidence to Its Own BI Strategy, SAP just acquired Roambi

Tableau Stock Implodes, Microsoft Recognized by Gartner for Its Vision in Analytics… and a Few Other Things That Happened This Week

~ Business Intelligist ~ 1 Comment

This has been an interesting week for BI/Analytics industry. Lots of things happened; some of them were good and some bad… The most surprising news thus far, at least for me, was what happened with Tableau's stock. After its quarterly results were announced, the stock plummeted 50% (despite the fact that the company beat quarterly … Continue reading Tableau Stock Implodes, Microsoft Recognized by Gartner for Its Vision in Analytics… and a Few Other Things That Happened This Week

Power BI Desktop: Interaction between Visuals

~ nikilprabhakar ~ 1 Comment

November release of Power BI Desktop delivered a highly requested feature – ability to configure interaction between visual elements in a report. Here is a quick tutorial of the configuration options. I have a report with 4 visual elements, a card, a clustered column chart, a bar chart and a donut chart. By default, when … Continue reading Power BI Desktop: Interaction between Visuals

POWER BI TUTORIAL : Using Variables in DAX

~ nikilprabhakar ~ Leave a comment

Earlier this year, new version of DAX was released. One of the key features with this release is the support for variables. Variables makes writing DAX code easier. Variables also make code easier to read and understand. Download sample data here. Data represents sales for a particular store. Products are categorized by seasonality and color. … Continue reading POWER BI TUTORIAL : Using Variables in DAX