April 2020 Free Online Courses

April 2020 Free Online Courses

One of the upsides to this COVID-19 Pandemic is the number of Free Online Courses and discounted educational offers available. Here is my list of recommended online sites. Free Courses and Certifications for Business Intelligence and Analytics Efficient Analyst offers...

read more
7 Easy MicroStrategy Filters

7 Easy MicroStrategy Filters

In this video, I show 7 easy ways to filter data in MicroStrategy, from chapter filters to the newly released visualization filters. https://www.youtube.com/watch?v=MrmxPCeF-vk You can download MicroStrategy Desktop for free from...

read more
Getting Started with MicroStrategy Desktop

Getting Started with MicroStrategy Desktop

In this video, I show how how to get started with MicroStrategy Desktop. MicroStrategy is one of the leading Business Intelligence tool, and the MicroStrategy Desktop application is available for free. https://youtu.be/e0PcgU1buc0 You can download MicroStrategy...

read more
Excel SumIf CountIf and AverageIf formulas

Excel SumIf CountIf and AverageIf formulas

Using Sum(), Count() and Average() formulas in Excel might be enough for many situations, but sometimes you might have a more complex question you're trying to answer.  For example, if you had the following data, and you wanted to know how much each customer...

read more
Excel Basic Formulas: Sum, Average, Count, Max, Min

Excel Basic Formulas: Sum, Average, Count, Max, Min

Using Excel basic formulas can help simplify your life by doing sums, averages, counts, maxs, and mins of many numbers at the same time. To follow along, go to the following link to download the Efficient Analyst Data Validation List Drop-Down Exercise Workbook:...

read more
Using the Excel VLOOKUP function

Using the Excel VLOOKUP function

Using the Excel VLOOKUP function makes it easy to link two excel tables together, and can be a great time saver. To follow along, go to the following link to download the Efficient Analyst VLOOKUP Exercise Workbook: Efficient Analyst VLOOKUP Exercise Workbook...

read more