endjin

While one-hot encoding has its advantages, it may not be the most suitable technique for #PowerBI. Jessica Hill explains why label encoded data is the preferred format, highlighting its benefits in simplifying DAX measures, improving performance, and optimizing semantic model size, in the second part in the series about Encoding categorical data for analysis in Power BI. https://lnkd.in/emKnkftG #PowerBI #DataAnalysis #DataEngineering #DAX #DataScience #BusinessIntelligence

Highlights from the Azure Weekly Newsletter for 9th March 2025: - Designing An Azure Hub Virtual Network (Aidan Finn) - Micro-Segmentation Security In Azure Networks (Aidan Finn) - Why The Classic DMZ/Secure Zone Design Is Worthless in Azure (Aidan Finn) - Automating Database Migration with Autogen 0.4 (Anton Slutsky, Ph.D.) - Optimize Fortinet Traffic Logs into Microsoft Sentinel (☁️ Charbel N.) - Connect to any data with Shortcuts, Mirroring and Data Factory using Microsoft Fabric (Jeremy Chapman) - Is your LLM-powered app providing safe answers? Evaluate it (Pamela Fox) - Using NVIDIA Triton Inference Server on Azure Container Apps (Chun-Han Chen) - Azure IoT Operations: Event Hub telemetry and commands (Sander van de Velde) - Azure App Service Auto-Heal: Capturing Relevant Data During Performance Issues (Shagni Hotri) - Azure Arc: Managing Azure Arc-enabled servers with Machine Configuration (Wim Matthyssen) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/e-mdyTJw

Covariance and contravariance might sound complex, but they're based on simple concepts in C#. Liam Mooney explores the topic in his latest blog post: https://lnkd.in/encG7hDQ #csharp #dotnet

Highlights from the Power BI Weekly Newsletter for 4th March 2025: - Making a Report Bilingual: The Full Story (Part 2) (Bernat Agulló Roselló) - Excel Users Struggle with These Calculations in Power BI – Here’s the Fix (Chandeep Chhabra) - Power BI Visual Calculation Magic - Conditional Formatting (Learning Science) - Power BI DataViz World Championships | 2 Weeks Left to Compete (Shannon Lindsay) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/eDgZe_ef

Highlights from the Azure Weekly Newsletter for 2nd March 2025: - How Does Azure Routing Work (Aidan Finn) - Routing Is The Security Cabling of Azure (Aidan Finn) - Practical Guidance Working with Azure Availability Zones and Physical Zones (Andrew Citera) - Setting Up a Secure Webhook in an Azure Monitor Action Group (Andrew Redman) - Custom Evaluators with AI Foundry (Carlos Mendible) - RealTime News Updates in SharePoint Online with SPFx (Elio Struyf) - Keeping .NET Base Docker Images Updated with Azure Container Registry (John Kilmister) - Application Gateway for Containers: a not-so-gentle intro 1 (Jose Moreno) - Azure FinOps Essentials (Michiel van Oudheusden ☁️) - Claude 3.7 Now Available in GitHub Copilot for Visual Studio (Rhea Patel) - From zero to hero with identity and access control in Azure Kubernetes Service (Ricardo Martins) - Comprehensive Guide to Monitoring Azure WAF Metrics and Logs (Saleem Bseeu) - Deploying to Azure: Secure Your GitHub Workflow with OIDC (Thomas Thornton) - Using WireMock to mock Business Central (Tobias Fenster) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/espv6Uwh

Highlights from the Power BI Weekly Newsletter for 25th February 2025: - Monthly Power BI Semantic Model Refreshes With Fabric Data Pipelines (Chris Webb) - Power BI February 2025 Feature Summary (Patrick LeBlanc) - Demystifying Copilot in Microsoft Fabric (with Kerry Kolosko & Kurt Buhler) (Reid Havens 🧙🏻♂️) - Power BI Performance Tuning  Aggregations Multiple Layers  Part 5 (Reza Rad) - Use the Ellipsis Operator to Raise Errors in Power Query M (And Save Your Code from Disaster) (Rick de Groot) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/edJf9WtV

Highlights from the Azure Weekly Newsletter for 23rd February 2025: - vWAN to vWAN Connectivity Options (Adam Torkar) - Azure Virtual Networks Do Not Exist (Aidan Finn) - Managing Access to Multiple VRFs from Azure VNETs (Daniele Gaiulli) - AI-Powered Customer Support: The Ultimate Multi-Agent System (David Minkovski) - Supercharge Developer Workflows with GitHub Copilot Workspace Extensions (David Minkovski) - Introducing fabric-cicd Deployment Tool (Jacob Knightley) - Encoding categorical data for Power BI: Label encoding vs one-hot encoding - which encoding technique to use? (Jessica Hill) - Using Semantic Kernel to control a BBC Microbit (John Metzger) - Data Streaming Databricks in Azure (John Miner) - Node.js, Azure Application Insights, and Fastify (John Reilly) - Implement App Service Best Practices into your Azure ARM/Bicep Templates with GitHub Copilot (Jordan S.) - Happy together paths to test semantic models in Microsoft Fabric feature workspaces with BPA (Kevin Chant) - Importance of shifting left when testing Microsoft Fabric deployments (Kevin Chant) - Azure Confidential VMs made easy (Roelf Zomerman) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/epg7keCj

Highlights from the Power BI Weekly Newsletter for 18th February 2025: - Encoding categorical data for Power BI: Label encoding vs one-hot encoding - which encoding technique to use? (Jessica Hill) - Using pie charts is not the end of the world (Kurt Buhler) - How can I decide which protection method to use to protect my sensitive data in Fabric? (Yael Biss) - DAX query 102: DAX formulas and measures with DEFINE MEASURE (Zoe Douglas) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/e3Gw4Zf9

First in a two-part series by Jessica Hill deep-diving into the differences between label encoding and one-hot encoding in #PowerBI projects. 👉 Understanding Categorical Data: What it is and why it needs encoding. 👉 Label Encoding: How it works, its advantages, and when to use it. 👉 One-Hot Encoding: How it works, its advantages, and when to use it. 👉 Comparison: Pros and cons of each technique in the context of Power BI. The post includes practical examples and real-world scenarios to help you choose the right encoding method. https://lnkd.in/ewE_32kZ #dataengineering #featureengineering

Highlights from the Azure Weekly Newsletter for 16th February 2025: - The security benefits of structuring your Azure OpenAI calls – The System Role (Asaf Harari, PhD) - A Guide to Azure Data Transfer Pricing (Cynthia Treger) - Securing API to API calls in Azure with Entra and API Management (Dan Rios) - Empowering AI innovation with Azure AI Foundry (Jhoanna Machado) - Private Link reality bites: Azure Firewall app rules (Jose Moreno) - Private Link reality bites: NXDomainRedirect (Jose Moreno) - What are Schemas in the Microsoft Fabric Lakehouse? (Koen Verbeeck) - Private ADLS Gen2 access made easy with OneLake Shortcuts: a step-by-step guide (Marc Bushong) - Entra Private Access (Nicolas Bonnet) - Four Methods to Access Azure Key Vault from Azure Kubernetes Service AKS (Paolo Salvatori) Read the full issue, subscribe to the email newsletter or RSS feed 👇 https://lnkd.in/eg-fXjKx