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

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 expectations). The stock is now

Read more

POWER BI TUTORIAL : Using Variables in DAX

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. We want to calculate the

Read more

More Robust Tile Pinning to Dashboards Introduced in Last Power BI Service Update

091615_1530_MoreRobustT1.png

Microsoft is making pinning a tile to a dashboard more user friendly with its last weekly Power BI service update. It was not always apparent what dashboard the tile would be pinned to; therefore, the dialog box above will make it much clearer to a user. More details for the weekly update are available here. There are couple of interesting

Read more

Power BI Desktop : Merge Query Options

In Power BI Desktop, there are multiple options available when using Merge Query feature. This tutorial reviews each of the options. Data for the tutorial can be obtained by downloading Excel file from here . The file has Product sheet which has details of all the products my company sells The file also has a Manufacturer sheet. This lists the

Read more
« Older Entries