Switch Function in PowerBI and MS Excel
Do you ever get frustrated when you have to nest multiple conditions using the IF function in Excel? If YES, you are not alone on the table. Let me introduce…
Custom Shape Map in Power BI
Introduction Maps are excellent chart choices for presenting geographic information as they overlay the numerical data on top of the geo-coordinates of the places. This makes the report user see…
Data Model and Table Relationships for a Required Report
Assuming you were already done with the import and cleaning of your dataset in Power Query. You can then proceed to the Model Tab and build the relationship between the…
The Relationship Between DAX and Visualization in Power BI (Part 2)
In the previous lesson, we were able to use DAX to ascertain the Number of Staff born on a particular year which was then represented on a Matrix Visual where…
Fully Online Delivered Power BI and Dashboards for the Busy Professional
Make the most of this lockdown and work-from-home situation, even get your HR to see this as a way of achieving their staff learning and development goals with a reduced…
Power BI DAX #6: UNION
UNION is an interesting DAX formula. Simple yet powerful in what it makes possible for you to achieve. I will be demonstrating with a simplified version of one of my…
Power BI #3: The Query Editor
When you launch the Power BI Desktop, the start up screen you get has Get Data on the top left side.The Get Data is the your first window into the…
Power BI #2: Getting To Know The Power BI Desktop
The Power BI Desktop is the main tool you would be using in creating Power BI reports. You can freely download it here from Microsoft. Once you are done installing it. You…
Comprehensive Introduction To Power BI And The Value Proposition
Power BI is Microsoft's self-service Business Intelligence solution and is the most popular self-service BI solution in Nigeria. Many companies in Nigeria are beginning to realise the huge importance of having…
Training: Data Analysis and Business Intelligence Using Power BI
Data is the new crude oil. And business success in the 21st century is heavily reliant on the ability to mine and use relevant data about consumers, internal operations, financial…