Excel

Fast Track Your BI Requirements: Azure and PowerBI

Power BI is a suite of business analytics tools to analyze data and share insights. Power BI dashboards provide a 360-degree view for business users with their most important metrics in one place, updated in real time, and available on all of their devices. With one click, users can explore the data behind their dashboard [...]

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 [...]

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 [...]

The Bad Way To Create An Excel Enterprise Dashboard (And What You Can Do About It)

Every organization needs to know its numbers and an Excel Enterprise Dashboard is an awesome way to make that happen. It creates a "shared picture" to inform your strategy, your direction and your current work, while leveraging existing Excel skills. That value is HUGE.  But many organizations do it the wrong way. Check out the [...]

By | December 4th, 2014|Enterprise Reporting, Excel|0 Comments

How did Nashville score on the ACT?

7,443 MNPS students took the ACT over two years. How did they do? Below is an infographic of how they did if the 7,443 students were a class of 25 students. In Tennessee, a minimum ACT test score of 19 is the entrance requirement for state colleges and universities. An ACT score of 21 is the minimum necessary to [...]

By | October 6th, 2014|Excel, Office 365|4 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

Creating Infographics with Excel, Part 1

Infographics are powerful communication tools.  This is evidenced by how popular they are in magazines and newspapers.  Graphic designers usually create infographics through a manual process. What if you could create an infographic that updates with the change of a slicer? That would be powerful! Live Example: See this example in Excel Online. The basic construction is [...]

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