youtube
Power BI Advanced Visuals: Creating Moving Average and Percentile Charts
Moving Average Formula: AVERAGEX(DATESBETWEEN([Date] , MAX([Date]) - 4 , MAX([Date])), CALCULATE(AVERAGE([KPI]))) Example for 90perc: PERCENTILE.INC(metric, 0.9)
Mohamed ELAdawi
I have 14 Years of RF Mobily communication experience in 4G/5G Design, Planning, and Optimization. I have gained international experience by working in 6 Countries with 9 Mobile Operators.
youtube
Power BI Advanced Visuals: Creating Automated CDF Charts with DAX
Learn how to create and customize a Cumulative Distribution Function (CDF) chart using Power BI DAX. DAX CDF Formula: CDF Formula: CALCULATE(COUNT([KPI]), FILTER(ALLSELECTED([BINS]), [(BINS)]<= MAX([(BINS)]))) / CALCULATE(COUNT([KPI]), ALL(BINS])) CDF Creation Steps Step 1: Create a Line/Scatter Chart Step 2: Drag the
youtube
4G TDD Subframe Configuration Types
This video explains all what you need to know about 4G TDD Subframe configuration types
youtube
NR SSB Calculation Explained
This video covers the following important aspects of SSB: * The main differences between 4G and 5G PBCH and synchronization signal * The differences between channel raster and synchronization raster * Identification of SSB frequency locations and methods for calculation Materials are available at the link below. https://www.mohamedeladawi.com/nr-ssb-calculation-materials/
materials
NR SSB Calculation - Materials
This video covers the following important aspects of SSB: - The main differences between 4G and 5G PBCH and synchronization signals - The differences between channel raster and synchronization raster - Identification of SSB frequency locations and methods for calculation YouTube Video: Video Materials: 5G Planning Inputs5G Planning Inputs.xlsx4
youtube
QGIS Advanced: Auto Polygon Creation Using Voronoi
In this QGIS video, you'll learn how to automatically make polygons using the Voronoi tool. We'll show you how to set up your data, run the Voronoi tool, and change the polygons. By the end, you'll know how to quickly create custom polygon layers
youtube
Learn About 5G MFBI Feature and SUL/SDL Use Cases
In this video, you will learn about the following important 5G concepts and features: * How to read ENDC Band and NR CA Band combinations from UE logs * The meaning of NR Operating Bands Overlap and the NR MFBI (Multi-Frequency Band Indicator) feature * The meaning and use cases of SUL (Supplementary
materials
5G UL Reference Signals: (SRS) Sounding Reference Signal - Material
materials
5G DMRS- Materials
youtube
Master Power BI Query Editor: Best Practical Practices
In this video, you'll learn how to master the Power BI Query Editor and apply the best practical techniques for efficient data transformation and preparation. Everything you need to know about the Query Editor is almost covered, with several of practical examples to reinforce the concepts.
youtube
5G Cross-Link Interference: Understanding the Challenges of 4G-LTE Coexistence and Dynamic TDD
In this video, you will gain a comprehensive understanding of 5G Cross-Link Interference, including its definition and potential causes that can lead to cross-link interference. Video materials uploaded to the below link https://www.mohamedeladawi.com/5g-nsa-nr-planning-materials/
materials