Power BI Filter a Slicer by Removing Entries With no Data
Using a slicer, you can turn your dashboard into an interactive experience, enabling your users to quickly filter different values. https://youtu.be/nBI1-h0zd1M If you use a dimensional model as the source of your Power BI model, chances are at some point you will...
Excel Combine Text from Multiple Columns
Today we will explore 3 ways of quickly combine text from multiple columns in Excel. In this example, we will combine the name of the City and the Country, while adding a comma in between. For example Ottawa, Canada. https://youtu.be/1-U4RAj9qec To follow along, go to...
Create Excel Pivot Table
When you know how to Create Excel Pivot Tables, you can quickly summarize data and gather additional insights.
Introducing our new Interactive COVID-19 Dashboard
Introducing the newest version of my COVID-19 dashboards, now interactive! You can select a country in the top-left drop-down to show the KPIs and line charts for that country, or you can scroll down the grid on the right to see all the countries. To see the new...
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. https://youtu.be/fFiOC_Dw6cU To follow along, go to the following link to download the Efficient Analyst Data Validation List...
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...