Get Free Tips
MSSQLTips.com

Author: Kenneth A. Omorodion

Home » Archives for 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.

  • MSSQLTips Awards: Rising Star (50+ tips)-2023 | Author of the Year-2021 | Author Contender-2022/2023/2024

TitleCategoryDate
Building a Dynamic Countdown Timer in Power BIPower BI2025-09-10
SQL Server Triggers for Business Rules AutomationTriggers2025-08-13
Create Power BI Calendar Table with Power Query M LanguagePower BI2025-06-19
Power BI Deployment Pipeline FeaturesPower BI2025-06-13
How to Sort Combo Box Values in a Power Apps Canvas AppPower Apps2025-05-13
Power BI Workspaces Management and Archiving Best PracticesPower BI2025-04-04
Optimize Delta Tables with VACUUM in Microsoft FabricMicrosoft Fabric2025-03-12
Data Retention Management for Lakehouse Files in Microsoft FabricMicrosoft Fabric2025-01-29
Design Data Warehouse with Medallion Architecture in Microsoft FabricMicrosoft Fabric2025-01-28
Dynamically Create Tables in Power BI with DAX FunctionsPower BI2025-01-12
Partitioning Data in Microsoft Fabric to Improve PerformanceMicrosoft Fabric2024-12-19
Data Warehouse Considerations – SCD Type 2 vs Overwrite DimensionsData Warehousing2024-11-14
Power BI Export to ExcelPower BI2024-09-12
Slice Data by Fiscal Month using DAX for Power BI ReportsPower BI2024-08-01
Dynamically Display Top N and Bottom N Records in One Power BI ChartPower BI Charts2024-06-13
Sort String Date Values on a Power BI Slicer VisualPower BI2024-05-16
Rank and Sort Data Based on Multiple Columns in Power BI with DAXPower BI2024-04-18
Simplify Data Merging in Power BI with DAX NATURALINNERJOINPower BI2024-03-11
Analyze Data in Power BI like Excel Pivot TablesPower BI2023-12-18
Power BI Bookmarks, Excel Analysis, PowerPoint Export, Teams and morePower BI2023-10-30
Power BI Drill Through in the New Report User InterfacePower BI2023-08-17
Turn Power BI Card Visuals into SlicersPower BI2023-08-11
SQL Variables for T-SQL Code and QueriesTSQL2023-07-20
Working with a Historical Dataset in Power BIPower BI2023-06-29
Automate Sending and Scheduling Emails using Power AutomatePower Apps2023-05-19
Power BI KPI Visual Changing the Default OutputPower BI Formatting2023-04-27
Build a Time Slicer by Week using DAXDates2023-04-12
Automate Extraction of a SharePoint List Dataset using Power AutomateSharePoint2023-03-24
Extract Email Attachments and Save Files in SharePoint FolderPower Apps2023-01-31
Unpivot Repeated Data Columns in Power BI to Normalize the DataPower BI2023-01-06
Incremental Refresh for Non-Query Folding Sources in Power BI DesktopPower BI2022-11-10
Connect Power BI Desktop to a Power BI DatamartPower BI2022-10-10
Power BI Incremental Refresh for non-Query Folding SourcesPower BI2022-09-30
Calculating Work Days in Power BI with DAX NETWORKDAYS FunctionPower BI2022-08-16
Dynamically Display X and Y Axis Data in Power BIPower BI Charts2022-07-29
Power BI Preview Data Refresh FeaturePower BI2022-07-19
Increase Power BI Canvas SizePower BI Formatting2022-06-23
DAX round, rounddown, floor, trunc, mround, ceiling, roundup and morePower BI Formatting2022-06-01
DAX LOOKUPVALUE and DAX RELATED Usage in Power BIPower BI2022-05-06
Convert Integer Date Fields with Power Query in Power BI ReportsPower BI2022-03-28
Combine Files in Power BI with Column Name or Column Count ChangesPower BI2022-03-16
Create a Power BI Grouping ReportPower BI Formatting2022-02-22
Compute Fiscal Week Calculations with Power BI and DAXPower BI2022-02-07
Power BI Concatenate Stings with Power Query M LanguagePower BI2022-01-05
Calculate Date Difference in Power BI using DAXPower BI2021-12-01
Concatenate Data in Power BI with the DAX CONCATENATEX FunctionPower BI2021-11-23
Concatenate Data in Power BI with the DAX CONCATENATE FunctionPower BI2021-11-03
Combine Text Strings in Power BI Using DAXPower BI2021-10-21
Power BI Email Reports with Power AutomatePower BI2021-10-06
Power BI Automated Reports using Power AutomatePower BI2021-09-03
Free Power BI Desktop External Tools for Development and DeploymentPower BI2021-08-25
Working Days Calculator in Power BIPower BI2021-07-14
Getting started with DAX in Power BIPower BI2021-06-29
Notify Users of Power BI Dataset ChangesPower BI2021-06-03
Troubleshoot New Line Breaks and Carriage Returns in SSISIntegration Services Data Flow Transformations2021-05-24
Create Date Dimension in Power BI from Text ColumnsPower BI2021-05-14
Dynamically Show or Hide Power BI Visual Based on Slicer SelectionPower BI Charts2021-04-28
Manage Date Formats in the Power BI ServicePower BI2021-04-22
Power BI for Business IntelligencePower BI2021-04-07
Power Query Common Data TransformationsPower BI2021-03-29
Using Column from Example in Power BI on DatesPower BI2021-03-05
Power BI Reports with Animated GIFPower BI Formatting2021-02-05
Create Azure DevOps Analytics Visuals with Power BI OData QueriesDevOps2021-01-13
Dynamic Power BI Slicer Using DAX LogicPower BI2020-12-21
Power BI OneDrive Data SourcePower BI2020-12-09
Azure Reporting for Resource Usage with Power BIAzure2020-11-03
Azure Devops Metrics in Power BI for AnalyticsDevOps2020-10-06
Azure Log Analytics to Monitor Azure Resource PerformanceAzure2020-09-22
Improve Power BI Performance with Horizontal FilteringPower BI2020-09-09
Power BI RAG Icons Custom Conditional FormattingPower BI Formatting2020-08-28
Improve Power BI Performance with Auto Date/Time and DAX VariablesPower BI2020-08-18
Power BI Performance Optimization TipsPower BI2020-08-05
Power BI Incremental Refresh for SQL SourcesPower BI2020-07-08
Calculate Percentage Growth Over Time with Power BIPower BI2020-06-23
Power BI Paginated Reports with Excel SourcePower BI Formatting2020-06-05

Categories

Recent Articles

  • Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

  • State of the DBA in 2025

  • Natural Language Query for SQL Server

  • Building a Dynamic Countdown Timer in Power BI

  • Optimizing SQL Server Integration: Automated Data Movement for Analytics and Operations

mssqltips white logo

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
Facebook X-twitter Rss Envelope Linkedin
Copyright (c) 2006-2025 Edgewood Solutions, LLC All rights reserved
sql server 2025 guide