Nerds-Turned-Bullies, The Rise Of The Brogrammer, And Are Analytics Good For SQL People?

Nerds-Turned-Bullies, the Rise of the Brogrammer, and Are Analytics Good for SQL People?

Don’t Do This.  And Don’t Stand for it Either. The Greatest Treason? Today I want to go off-topic just a little bit, but in a way that I think is relevant to many of us as professionals.  And then bring it home, so to speak, specifically at the intersection of Analytics and Databases. To me, there are few treasons greater than spending time on the receiving end of abuse, learning firsthand what that abuse feels like, and then subsequently becoming…

Read the Rest
Designing For Usability In Power Pivot And Power BI

Designing for Usability in Power Pivot and Power BI

Usability Can your data model (Power Pivot or Power BI) easily be used by 100s of users? Is your model fairly intuitive to understand for the end-user even with little or no training? Usability may be the key to achieving the Self-Service BI nirvana. The very first Power Pivot model that I had designed… Number of users I expected to use my first Power Pivot Model    1 (myself) Number of users that actually ended up using the model   …

Read the Rest
Two Hours To Change Your Business (Or Job. Or Life.)

Two Hours to Change Your Business (Or Job. Or Life.)

Two Hours. Data Superpowers.  Victory.  Not Kidding. A New Way.  Tearing Down Old Paradigms. Folks, today I want to share a source of personal pride – literally share it, and make sure YOU experience it.  I saw something, back in 2010, that changed my career (and life) forever:  I saw the Power Pivot v1 product in action, as I re-implemented a project that I’d paid $50k for originally in 2005, using a traditional BI methodology.  In 2010 I re-built it,…

Read the Rest
Atlanta Needs You: Speak At The User Group Reboot

Atlanta Needs You: Speak at the User Group Reboot

Hi folks!  Next week, on Wednesday May 18th, Atlanta is going to reconvene the Modern Excel User Group. Due to some scheduling shuffles, our own Austin Senseman, who was originally going to be the speaker, now needs to be elsewhere, and I promised to help find his replacement. If you’re interested in helping out, please leave us a comment on this post and we will be in touch ASAP! Thanks!

Read the Rest
Trending And Smoothing At PASS BA Conference 2016

Trending and Smoothing at PASS BA Conference 2016

Level: Intermediate Last week I attended the 2016 PASS Business Analytics Conference in San Jose.  I attended my first BA Conference last year and had a blast - this year was equally as good.   However I had a really interesting week in the lead up to this year’s conference.  As you may have read last week, Rob had a mishap a couple of weeks ago that has left him less mobile than he would like.  Seriously, I have seen the…

Read the Rest
Why Has The Blog Been On “break,” And My Presentations From Microsoft Data Insights Summit Last Month.

Why has the blog been on “break,” and my presentations from Microsoft Data Insights Summit last month.

Get it???  On break??? Sorry for the radio silence around here lately folks.  A series of biz trips and conferences had made regular blog production difficult, but then… well, apparently every three years I need a trip to the emergency room. Longtime readers may remember the time I wrecked my knee.  Well, a couple weeks back, I wrecked my leg, my hand, and tore up a reasonable percentage of my surface area on a motorcycle.  Well actually it was a…

Read the Rest
Reminder: “Dueling Dashboards” Pre-Conference Class In San Jose May 2nd

Reminder: “Dueling Dashboards” Pre-Conference Class in San Jose May 2nd

Less than three weeks away! Just way too much going on this year, folks.  In a good way, but still, it means we struggle to keep up with making you aware of everything we’re doing. Coming up on May 2nd, at the PASS BA conference in San Jose CA, Avi and I are going to be giving a brand-new, never-seen-before full-day class called “Dueling Dashboards – Practical Patterns for Your Business.” Here’s the abstract: Microsoft’s evolving strategy in BI and…

Read the Rest
Power Query As A File Audit Tool

Power Query as a File Audit Tool

Today I am sharing how I use Power Query as a file audit tool to support a regular task I complete every week.  The objective of this post is to create broader awareness of how great Power Query is to solve different types of problems, and to possibly get you thinking about other problems you have that could be solved with this tool. Copying files between folders My use case is this.  I refresh multiple workbooks for a client each…

Read the Rest