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...
MicroStrategy Create Derived Attribute – Convert Year to Decade
In this tutorial, I show how to create a derived attribute in MicroStrategy. In this example, we convert years to decades. https://youtu.be/8zDLJHXNlkE To create a MicroStrategy Derived Attribute, click the option button (ellipsis ...) next to your dataset. In the...
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...
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...
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...
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:...
Creating an Excel Drop-down list using Data Validation List
Adding an Excel Drop-down list is a great way to make data entry faster, more efficient, and also more accurate. There are a few ways they can be done, and in this article we show how to do them using the Data Validation lists. To follow along, go to the following...
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...