Kenneth A. Omorodion

Kenneth A. Omorodion is a Microsoft Certified Solutions Associate (MCSA) with 12+ years of enterprise application experience in Power BI, DAX, Microsoft Fabric, Business Intelligence, data warehousing, SSRS, T-SQL, and Azure. Beyond his technical skills, Kenneth has expertise working with stakeholders’ and business leaders to help them better understand key insights. He has a great track record of successfully delivering full life cycle Business Intelligence and data solutions to organizations with measurable business impact.
  • MSSQLTips Awards
    • Achiever Award (75+ Tips) - 2025
    • Author of the Year-2021
    • Author Contender-2022/2023/2024
Title Category Date
Azure Reporting for Resource Usage with Power BI Azure2026-06-11
Power Query Common Data Transformations Power BI2026-06-09
Prevent Future Date Spillage in Power BI Visuals Power BI2026-06-08
Connect Power BI Desktop to a Power BI Datamart Power BI2026-06-02
Partitioning Data in Microsoft Fabric to Improve Performance Microsoft Fabric2026-05-27
Free Power BI Desktop External Tools for Development and Deployment Power BI2026-05-20
Extract Email Attachments and Save Files in SharePoint Folder Power Apps2026-05-20
Automate Extraction of a SharePoint List Dataset using Power Automate Power Apps2026-05-13
Display Active Slicers in Power BI using Dynamic DAX Power BI2026-05-10
Design Data Warehouse with Medallion Architecture in Microsoft Fabric Microsoft Fabric2026-05-09
Building a Dynamic Countdown Timer in Power BI Power BI2026-03-06
Power BI Custom Calendars for Gregorian, Fiscal, Retail, 13-Month, and Lunar Power BI2026-03-06
Simplify Data Quality Validation with SQL TSQL2026-03-06
Implement Snapshot Reporting in Microsoft Fabric using Fabric Pipelines Microsoft Fabric2026-02-16
Track Historical Changes in Microsoft Fabric using Dataflow Gen2 Snapshots Microsoft Fabric2025-12-09
A Practical Guide to Implement Data Quality Rules in SQL Server TSQL2025-11-13
SQL Server Triggers for Business Rules Automation Triggers2025-08-13
Create Power BI Calendar Table with Power Query M Language Power BI2025-06-19
Power BI Deployment Pipeline Features Power BI2025-06-13
How to Sort Combo Box Values in a Power Apps Canvas App Power Apps2025-05-13
Power BI Workspaces Management and Archiving Best Practices Power BI2025-04-04
Optimize Delta Tables with VACUUM in Microsoft Fabric Microsoft Fabric2025-03-12
Data Retention Management for Lakehouse Files in Microsoft Fabric Microsoft Fabric2025-01-29
Dynamically Create Tables in Power BI with DAX Functions Power BI2025-01-12
Data Warehouse Considerations – SCD Type 2 vs Overwrite Dimensions Data Warehousing2024-11-14
Power BI Export to Excel Power BI2024-09-12
Slice Data by Fiscal Month using DAX for Power BI Reports Power BI2024-08-01
Dynamically Display Top N and Bottom N Records in One Power BI Chart Power BI Charts2024-06-13
Sort String Date Values on a Power BI Slicer Visual Power BI2024-05-16
Rank and Sort Data Based on Multiple Columns in Power BI with DAX Power BI2024-04-18
Simplify Data Merging in Power BI with DAX NATURALINNERJOIN Power BI2024-03-11
Analyze Data in Power BI like Excel Pivot Tables Power BI2023-12-18
Power BI Bookmarks, Excel Analysis, PowerPoint Export, Teams and more Power BI2023-10-30
Power BI Drill Through in the New Report User Interface Power BI2023-08-17
Turn Power BI Card Visuals into Slicers Power BI2023-08-11
SQL Variables for T-SQL Code and Queries TSQL2023-07-20
Working with a Historical Dataset in Power BI Power BI2023-06-29
Automate Sending and Scheduling Emails using Power Automate Power Apps2023-05-19
Power BI KPI Visual Changing the Default Output Power BI Formatting2023-04-27
Build a Time Slicer by Week using DAX Dates2023-04-12
Unpivot Repeated Data Columns in Power BI to Normalize the Data Power BI2023-01-06
Incremental Refresh for Non-Query Folding Sources in Power BI Desktop Power BI2022-11-10
Power BI Incremental Refresh for non-Query Folding Sources Power BI2022-09-30
Calculating Work Days in Power BI with DAX NETWORKDAYS Function Power BI2022-08-16
Dynamically Display X and Y Axis Data in Power BI Power BI Charts2022-07-29
Power BI Preview Data Refresh Feature Power BI2022-07-19
Increase Power BI Canvas Size Power BI Formatting2022-06-23
DAX round, rounddown, floor, trunc, mround, ceiling, roundup and more Power BI Formatting2022-06-01
DAX LOOKUPVALUE and DAX RELATED Usage in Power BI Power BI2022-05-06
Convert Integer Date Fields with Power Query in Power BI Reports Power BI2022-03-28
Combine Files in Power BI with Column Name or Column Count Changes Power BI2022-03-16
Create a Power BI Grouping Report Power BI Formatting2022-02-22
Compute Fiscal Week Calculations with Power BI and DAX Power BI2022-02-07
Power BI Concatenate Stings with Power Query M Language Power BI2022-01-05
Calculate Date Difference in Power BI using DAX Power BI2021-12-01
Concatenate Data in Power BI with the DAX CONCATENATEX Function Power BI2021-11-23
Concatenate Data in Power BI with the DAX CONCATENATE Function Power BI2021-11-03
Combine Text Strings in Power BI Using DAX Power BI2021-10-21
Power BI Email Reports with Power Automate Power BI2021-10-06
Power BI Automated Reports using Power Automate Power BI2021-09-03
Working Days Calculator in Power BI Power BI2021-07-14
Getting started with DAX in Power BI Power BI2021-06-29
Notify Users of Power BI Dataset Changes Power BI2021-06-03
Troubleshoot New Line Breaks and Carriage Returns in SSIS Integration Services Data Flow Transformations2021-05-24
Create Date Dimension in Power BI from Text Columns Power BI2021-05-14
Dynamically Show or Hide Power BI Visual Based on Slicer Selection Power BI Charts2021-04-28
Manage Date Formats in the Power BI Service Power BI2021-04-22
Power BI for Business Intelligence Power BI2021-04-07
Using Column from Example in Power BI on Dates Power BI2021-03-05
Power BI Reports with Animated GIF Power BI Formatting2021-02-05
Create Azure DevOps Analytics Visuals with Power BI OData Queries DevOps2021-01-13
Dynamic Power BI Slicer Using DAX Logic Power BI2020-12-21
Power BI OneDrive Data Source Power BI2020-12-09
Azure Devops Metrics in Power BI for Analytics DevOps2020-10-06
Azure Log Analytics to Monitor Azure Resource Performance Azure2020-09-22
Improve Power BI Performance with Horizontal Filtering Power BI2020-09-09
Power BI RAG Icons Custom Conditional Formatting Power BI Formatting2020-08-28
Improve Power BI Performance with Auto Date/Time and DAX Variables Power BI2020-08-18
Power BI Performance Optimization Tips Power BI2020-08-05
Power BI Incremental Refresh for SQL Sources Power BI2020-07-08
Calculate Percentage Growth Over Time with Power BI Power BI2020-06-23
Power BI Paginated Reports with Excel Source Power BI Formatting2020-06-05