+234 806 299 1199

power bi

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
Budget collaboration

Open Analytics – Nigeria 2020 Proposed Budget

Tons and tons of data remain largely unexploited. The key to unlocking and achieving innovative feats and designing the most ingenious solutions may lie in being able to extract insights from the data. With the availability of and accessibility to a wealth of tools and resources that can help us better understand ourselves, it’s time […]
Read More
Breakdown of Nigeria's budget expenditure

Breaking Down and Analysing Nigeria’s 2020 Executive Budget Proposal in Power BI – Part 1

Introduction On the 8th of October, 2019, President Muhammadu Buhari presented to the National Assembly, the proposed budget for the year 2020. Details of the speech can be reviewed here. By consensus, Nigeria’s revenue of N8.15tn is inadequate to fund the N10.33tn proposed expenditure, leaving a deficit of N2.18tn. According to Budgit analysis, a simple breakdown of […]
Read More
Diesel Price in Nigeria

Upward Trend in Diesel Pump Price in Nigeria – NBS

While it may not sound like much, the average price of diesel (AGO) per litre has increased by 1.7% from N225.09/L in January 2019 to N229.08/L in August 2019. Compared to August 2018, there has been a year-on-year increase of over 10% in diesel price. Data released in August by the National Bureau of Statistics […]
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