Power BI

Final Thoughts From PASS Business Analytics

As I sat at 39,000 feet flying back home to Nashville last night, I was struck at the amount of things I have seen, heard, and done in the last 6 days in the South Bay area of California.  I took a little personal detour with my sons over the weekend.  Oh my, what a beautiful [...]

By | April 23rd, 2015|Data Analysis, Excel, User Groups|0 Comments

Thoughts from PASS Business Analytics Conference

I've been in the California "South Bay" area now since Friday evening. If you have never been, it is an amazing place to visit. The landscape and weather diversity in the San Francisco area is quite a site to behold. This was my first trip here, and I have loved every minute of it. One [...]

PASS Business Analytics Conference 2015

We are so excited here at Think Data Insights. So many great things are happening in the field of business analytics. Now, more than ever before, business users can create and leverage extremely agile analytics throughout the organization. There is a revolution happening, and much of it is happening in the most unlikely of places. [...]

Power Update for Power BI

If you have been using Microsoft's Excel Power BI add-ins for Excel for any length of time, you know the amazing power they provide the analytics process. You also know that automating the refresh of Power Pivot workbooks or Power Query queries is not as simple as it should be. Until now: You'll be delighted [...]

By | February 4th, 2015|Excel, Office 365, Power Query, PowerPivot, SharePoint|0 Comments

How 1 Company Got Into The Analytics Flow with Power BI

In my previous post on Get In The Data Analytic Flow, I described how companies are uncovering amazing insights and achieving greater performance through the use of advanced analytics. One of the important tools they use is Microsoft Power BI. It has been a key enabler of these insights. Here at Think Data Insights, we've seen [...]

Get In The Data Analytic Flow

The Flow State In the bestselling book The Rise of Superman, Stephen Kolter highlights the amazing achievements humans have made in recent years. Extreme athletes are surfing 100-foot waves, snowboarding over 250 foot chasms and free-climbing cliffs in pursuit of the next rush of adrenaline. All in something called “the flow state.” According to Steven’s research, the flow state is a neuro-chemically induced state of mind and body that allows a human to achieve greater things than ever before. Flow hacking is the art of tapping into the physical, social, and mental triggers that will move a person closer to the state of flow in all areas of life, where time slows down, self vanishes, and action and awareness merge. What does the flow state have to do with data analytics? Everything. […]

By | January 4th, 2015|Data Analysis|0 Comments

Creating Infographics with Excel, Part 3

In this post, we are going to try something more advanced. If you feel lost, try starting with Part 1. Hopefully this will inspire you and give you a flavor of what types of infographics you can create with Excel. Our subject is going to be high schools in Nashville. We are going to create [...]

By | September 26th, 2014|Excel|0 Comments

Creating Infographics with Excel, Part 2

In my last post, I described the basic steps to create an infographic in Excel: put a cut out image in front of a bar chart. However, I did not explain how to create the all-important cut out image. In this post, I will explain how to create any cut out image. True confession...I was dreading [...]

By | August 30th, 2014|Excel|0 Comments

Excel! With Data

Do you currently use Microsoft Excel to build reports or manipulate data? Have you spent countless frustrating hours developing reports in Excel, copying VLOOKUP formulas, and writing formulas to cleanup the data... only to find out you need to reproduce the report on a daily or weekly basis? You may be one of the fortunate [...]

By | August 18th, 2014|Excel, PowerPivot|0 Comments