ResagratiaResagratiaResagratia
+234 806 299 1199
contact@resagratia.com

excel

Custom Excel Charts – Part 2

What are custom Excel charts? You can think of them as infographic charts: a visual representation of information, data or knowledge intended to present information quickly and clearly. They can improve cognition by utilizing simplified graphics to enhance the human visual system’s ability to see patterns and trends. Sequel to the article on Customs Charts […]
Read More

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

Custom Charts and Infographics in Excel

Do you ever get tired of the mundane Excel charts? Do you feel you can make your Excel charts more intuitive by adding custom infographic charts? There may be times when the default chart formats just aren’t what you need. If you want to make your visuals more user-friendly, I suggest you tag along with […]
Read More
Resa Academy Analysis

A Visual Display of Resa Academy’s Survey Form Respondents

Resa Academy is scheduled to launch on March 7, 2020, and we’re very excited to deliver sterling, hands-on and interactive workshops on analytics using Power BI, Excel and Python. A core part of what we do at Resagratia is working on Open Analytics projects. We’re committed to building quality analytics solutions that can be reproduced […]
Read More
Power Query Power BI Transformation

How to Format Dates into X-Axis for a Line Chart

A question was asked by a newbie in the Power BI community. To paraphrase, “How do I convert this table to a line chart with the date on the x-axis?” This task requires only a few transformations in order to generate the line chart. Before beginning any analytics exercise, it’s important to understand the underlying […]
Read More