data engineer
Understanding dataflow in Azure Data Factory
Getting a feeling of the dataflow mapping in ADF Data ingestion and migration from one storage to another are becoming more common for every data engineer and at the same…
Calendar Table using Python & Power Query
This is an introduction to the use of Python and Power Query to create a calendar table for Business Intelligence purposes Introduction In the area of business intelligence and analysis,…
Using DAX Studio to Export Data From Power BI
Using DAX Studio to Export Over 1 Million Rows of Data From Power BI
The word Big Data is becoming a household name, with millions of data being generated on a daily basis. As a BI analyst, the need to export a large amount…
Creating an Azure SQL Database
The first question that might come to mind is why should I create an Azure SQL database and what makes it unique from other kinds of databases. I will start…
Microsoft Azure SQL
We are in an era where more companies are beginning to adopt cloud computing more than ever before. We can boldly say cloud computing is here to stay and Microsoft…
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…
A Digitally Bright Future After Prison
Some weeks back I had the opportunity to train inmates in Nigeria Prison Akure who got in due to cybercrimes and other internet-related fraud.Cybercrimes are crimes that take place in…
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…
PERCENTILES AND QUARTILES IN EXCEL
The terms percentiles and quartiles in Excel with related term percentile rank are often used in the reporting of scores from norm-referenced tests. It indicates the value below which a…
Create Data Entry Form in Excel without using VBA or Coding
Those not familiar with the Data Entry Form feature in Excel often relies on Excel VBA user form to create a user-friendly visually engaging data entry form in Excel. In…