Kenneth A. Omorodion

Kenneth A. Omorodion is passionate about BI Development and Visualisations development. He develops Business Intelligence capabilities that deliver true business value and help clients adapt to realize benefits from their systems and processes by gaining an in-depth insight into their data.

Kenneth is a Microsoft Certified Professional with years of experience in Power BI development, SQL BI Development, T-SQL scripting, stakeholders’ engagement and the design and implementation of enterprise applications to enable businesses better understand their key metrics and insights. He is also a Microsoft Certified Solutions Associate (MCSA) in the BI Reporting pathway. He has a great track records of having worked and successfully delivered full life cycle of BI and Data solutions (particularly in Power BI, SSRS development, SQL development and recently Azure Solutions Capabilities) to organizations.

2021 Awards
MSSQLTips award

2020 Awards
MSSQLTips award

Azure

Setting up Azure Log Analytics to Monitor Performance of an Azure Resource (last update: 9/22/2020)
Visualizing Azure Resource Metrics Data in Power BI (last update: 11/3/2020)

DevOps

Create Azure DevOps Analytics Visuals with Power BI OData Queries (last update: 1/13/2021)
Creating Azure DevOps Analytics metrics in Power BI using Pre-Built Analytics Views (last update: 10/6/2020)

Integration Services Data Flow Transformations

Troubleshoot New Line Breaks, Line Feeds and Carriage Returns in SSIS Flat File Destination (last update: 5/24/2021)

Power BI

Calculate Percentage Growth Over Time with Power BI (last update: 6/23/2020)
Calculate Working Days in Power BI (last update: 7/14/2021)
Combine Text Strings in Power BI Using DAX (last update: 10/21/2021)
Combining multiple files from multiple folders in OneDrive for Business in Power BI (last update: 12/9/2020)
Common Data Transformations in Power Query (last update: 3/29/2021)
Create Calendar Table Using Power Query M Language (last update: 2/26/2021)
Deep dive on Using Column from Examples in Power BI on Dates (last update: 3/5/2021)
Dynamic Power BI Slicer Using DAX Logic (last update: 12/21/2020)
Dynamically Compute Different Time Duration in Power BI Using DAX (last update: 12/1/2021)
Getting started with DAX in Power BI (last update: 6/29/2021)
How to Create Date Dimension Tables in Power BI from Text Columns (last update: 5/14/2021)
How to Manage Date Formats in the Power BI Service (last update: 4/22/2021)
Improve Power BI Performance with Auto Date/Time and DAX Variables (last update: 8/18/2020)
Improve Power BI Performance with Horizontal Filtering (last update: 9/9/2020)
Notify Users of Power BI Dataset Changes (last update: 6/3/2021)
Power BI CONCATENATE Function: How and When to Use it (last update: 11/3/2021)
Power BI DAX CONCATENATEX Function: How and When to Use It (last update: 11/23/2021)
Power BI Desktop External Tools and Why You Should be Using Them (last update: 8/25/2021)
Power BI for Business Intelligence (last update: 4/7/2021)
Power BI Incremental Refresh for SQL Sources (last update: 7/8/2020)
Power BI Performance Optimization Tips (last update: 8/5/2020)
Schedule, Export and Email Power BI Reports using Power Automate (last update: 9/3/2021)
Use Power Automate to Export and Email Power BI Reports with Row Level Security (last update: 10/6/2021)

Power BI Charts

Dynamically Show or Hide a Visual in Power BI Based on Slicer Selection (last update: 4/28/2021)

Power BI Formatting

Power BI Paginated Reports with Excel Source (last update: 6/5/2020)
Power BI RAG Icons Custom Conditional Formatting (last update: 8/28/2020)
Power BI Reports with Animated GIF (last update: 2/5/2021)