Still using Excel for visualization/data analysis? Watch these videos...

Blog Post created by JimGavigan Champion on May 21, 2020

If you are still using Excel to analyze time-series data most of the time, you are truly missing out. Power BI is an incredibly useful tool in analyzing time-series data. You can do most, if not all, of what I am showing with pretty much any BI tool (we do a lot of Tableau work too and all of what I show applies to Tableau as well).


The visualization capability and the ability to slice the data any way you want it is incredible. Also, you can literally type in a question and Power BI will draw a visual for you like below (I show this in video #3):



The full playlist is below:






I also did a blog recently about some visual design issues that I saw on our state’s COVID-19 website. If you are doing reports or visuals for anyone, this would be a good read. I also show a better example of a nice dashboard using similar data (COVID-19 dashboard from India that one of my LinkedIn connections shared with me):