DAX for Visual Studio Reports

Before I delve into a few technical details on DAX usage in reports, let’s set the stage a bit. If you’re a BI developer, skip the next paragraph. At Applied Tech we have a team of BI people that focus on the entire Microsoft BI stack. This includes SQL Server, Office 365, and Azure solutions. A few of us specialize …

Office Remote

Quick-hit on a new Microsoft Tool A big part of my job is preparing and delivering presentations. I present in a lot of different locations, and often don’t have a lot of control over the presentation equipment. In addition to my Surface Pro or HP laptop, I travel with an interesting array of adapters, cables, memory cards and other “dongles.” A …

What is the NOC, Anyway?

A significant portion of the service Applied Tech provides is technical support for our clientele. You dial our number, talk to someone about your problem, and we attempt to fix it in a timely manner. But what else goes on in the NOC? What does our job entail? Who are you talking to on the other end of the phone? …

Dashboarding Charts

I’ve had a few issues recently with PivotCharts (which is normally what your use with PowerPivot). PivotCharts do not allow you to use formulas in the title, or data call-outs. They also do not allow static call-outs (like always having a call-out or data label on the ​last point only). Also I noticed that they don’t allow you to add any additional …

DLP – “How would I know? Why should I care?”

Maybe I’m dating myself by starting with a quote from the 1964 hit song by the Zombies (later  covered by Santana), but in the same way the song sets up the mystery of who “she” is and where “she” may have gone, Microsoft’s Data Loss Prevention (DLP) is a feature that warrants a deeper investigation. Data Loss Prevention, part of the …