ResagratiaResagratiaResagratia
+234 806 299 1199
contact@resagratia.com

DAX

Data Challenge: Excel Wildcard with Multiple Criteria

Hi Tribe, To continue our Data Challenge series, this tutorial will focus on more advanced use cases of Excel wildcard. The goal of our data challenge series is to motivate you, our users and readers, to imbibe an attitude of continuous learning and to solve some common problems encountered in the field of data analytics […]
Read More

Excel Wildcards

Excel Wildcards: What are they? Microsoft Excel is a powerful software that uses a spreadsheet to organise data and numbers with functions and formulas. It is well used around the world and can be used by businesses of all sizes. Excel wildcards are simply three characters used for comparison in text filtering, searching and replacing […]
Read More

July 2020 Power BI Update

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Every month since the release of Power BI in 2014 there are updates to improve its functionalities and features to provide Bussines Intelligence Analysts with the necessary tools and resources […]
Read More

The Importance of Data Analysis

What does it mean to make data-driven decisions? it means to make strategic decisions based on data analysis, and interpretation. A data-driven approach enables companies, and individuals to examine and organize their data with the goal of better serving their customers, and consumers. Being data-driven means using facts, metrics, and data to guide strategic business decisions that align with […]
Read More

The Most Commonly Used Charts For Analysis

We’ve got something to satisfy your curiosity on commonly used charts for data analysis. In this post, we focus on four of the most commonly used charts for data visualization. They include; Line Charts The line chart is best for showing trends. It is the perfect visual for showing the movement of value over time. […]
Read More

June 2020 Power BI Update

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Every month since the release of Power BI in 2014 there are updates to improve its functionalities and features to provides Bussines Intelligence Analysts with the necessary tools and resources […]
Read More

Introduction to Power Query

Power Query commonly found in Power BI and Excel is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy to use, engaging, and no-code user experience. Supported data sources include a wide range […]
Read More
Introduction to DAX in Power BI

A Gentle Introduction to DAX in Power BI

DAX stands for Data Analysis Expressions used in Power BI. DAX is a formula language and is a collection of functions, operators, and constants that can be used in a formula or expression to calculate and return one or more values. DAX is the formula language associated with the Data Model of Microsoft Excel Power […]
Read More