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)
youtube
Moving Average Formula: AVERAGEX(DATESBETWEEN([Date] , MAX([Date]) - 4 , MAX([Date])), CALCULATE(AVERAGE([KPI]))) Example for 90perc: PERCENTILE.INC(metric, 0.9)
youtube
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
This video explains all what you need to know about 4G TDD Subframe configuration types
youtube
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/
youtube
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
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
youtube
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
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/
youtube
This video provides an in-depth analysis of how different 5G NR Slot Format configurations impact key performance metrics, including throughput, latency, coverage, and 5G Random Access Channel (RACH) planning. Video materials uploaded to the below link https://www.mohamedeladawi.com/5g-nsa-nr-planning-materials/
youtube
This Video deep dive into NR Slot Format different types. There are 3 types of Slot assignment in NR TDD System which is explained in details in this video: * Static allocation (Supported with DT Logs) * Semi-Static Allocation * Dynamic Allocation Video materials uploaded to the below link https://www.mohamedeladawi.com/
youtube
In this video, I'll cover everything you need to know about ARCGIS Maps in PowerBi. Topics include: - Introduction - Plotting points with different colors (Coverage Maps) - Creating HeatMap - Clustering - Excluding areas/points from the map - Importing Postal Codes from Web
youtube
In this video, I'll cover everything you need to know about Power BI standard maps. Topics include: * Plotting points with different colors (Coverage Maps) * Creating customized legends * Zooming, Selecting or excluding areas/points from the map * Creating HeatMaps