December 26, 2022
power query
August 26, 2021
Understanding Power BI Engine – Power Query
Power BI is more then what most think it is. Power BI is a collection of engines that all come together to provide business intelligence service, allowing users to Collect, Transform and Visualize data.
July 15, 2021
How to use Native SQL Queries on Excel Data with Power Query
Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability to push data transformation tasks to the data source level, rather than on Power Query
September 12, 2020
How To Create Calendar Tables With Power Query
If you thought DAX was the only way to bring Calendar Tables to life, you thought wrong. Power Query is not left behind in the fun and we are about to see how it’s
August 22, 2020
A Step By Step Guide To Creating A Custom Calendar Table In Power BI (Part 1)
First, why do you need a Calendar Table, also popularly referred to as Date Tables? All reports include dates; MONTHLY, YEARLY, QUARTERLY, etc. and nearly all data sets have date fields. To make it
April 16, 2020
Hidden Power Query Keyboard Shortcuts & Functionalities
Subscribe To Our YouTube Channel We all like to use shortcuts in our daily usage of various programs. For some people it’s easy access to various programs operations that can not be easily accessed,
7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos.