IDERA Software’s Post

Day 13/25 in today's learning what stood out for me is the fact I got to understand custom conditional columns in power query. By using conditional logic operators such as (and/or). you can make multiple conditions that refer to many different columns in your custom conditional column. #25daysofdatawithwida #powerbi #powerquery

'Dax Query View' is finally available in Power BI Desktop November 2023 release! You just need to enable the editor from the Options > Preview Features > Dax query view and it will eliminate your dependency on Dax Studio and other third party tools. Just remember to use, EVALUATE when writing Dax queries. It specifies what and how data is returned in the query. #dax #powerbideveloper #queryeditor #daxcopilot

Hello Everyone 😊 This is My First Dashboard of Power bi 🙈 Exciting news! I've just completed the Codebasics POWER BI 2.0 Course and wrapped up my inaugural project, Business Insights 360, designed for AtliQ Hardware. Problem Statement: AtliQ Technologies, a thriving hardware company specializing in peripherals, faced a significant challenge in LATIN AMERICA. Their quest? To rectify the issue through data-driven decision-making. I'm thrilled to introduce Business Insights 360, a project aimed at enabling AtliQ Technologies to make informed decisions through insights into Finance, Sales, Marketing, Supply Chain, and an Executive View. Key Insights: Finance View: Analyzed crucial KPI indicators such as Net Sales, Gross Margin %, and Net Profit %. Created a comprehensive P & L Statement with YOY growth. Sales View: Explored Customer Performance based on Net Sales and Gross Margin. Marketing View: Enhanced Marketing insights with segment performance and Net Profit metrics. Supply Chain View: Surveyed the variance of Actual Sales and Forecast accuracy. Executive View: Examined Yearly Trends by Revenue, GM %, NP % & Market Share %. Listed the TOP 5 Customers & Products by Revenue Contribution. Learnt Tech Stacks 🔹SQL 🔹Power BI Desktop 🔹Excel 🔹DAX Language 🔹DAX Studio(for optimizing the report)  🔹Project charter file Learnt POWER BI Techniques 🔹From calculated columns to dynamic titles, I've delved into data modelling, bookmarks, page navigation, M Language, and beyond. Business Exploits 💰 Pre-invoice deduction 💰 Post-invoice deduction 💰 Gross margin 💰 Net sales 💰 Net Profit 💰 YTD - Year To Date 💰 YTD - Year To Go 💰 Forecast accuracy 💰 Net error 💰 Absolute error To interactive dashboard : https://lnkd.in/gcsJVGKV Thanks to Codebasics for creating this amazing course and special thanks to Dhaval Patel sir and Hemanand Vadivel for such an engaging content throughout the course. #PowerBI #SQL #DAX #Dashboards #PowerQuery #Analytics #Sales #Finance #SupplyChain #Marketing #Insights #BusinessIntelligence #DataAnalysis #DataVisualization #BIReporting #DataInsights #BIAnalytics #DataDriven #DataManagement #DataScience #BIConsulting #BusinessAnalysis #BusinessReporting #DataTransformation #BusinessMetrics #DataMining #BIPlatform #BusinessIntelligenceTools #DataVisualizationTools #codebasics #buisnessinsight360

Tabular Model Definition Language (TMDL) in Power BI Desktop developer mode (Preview) @RajeevPentyala https://bit.ly/3wyG7Jy #PowerBI #PowerPlatform #DataVisualization

Another fantastic feature has just been added to Power BI! Visual level format strings have arrived, offering you enhanced options for configuring formatting. Initially designed for visual calculations, their core capability lies in formatting these calculations. Previously, since visual calculations weren’t part of the model, you couldn’t format them unless they were used in data labels or specific sections of the new card and slicer visuals. Now, with visual level format strings, you can! #powerbi #datavisualization #dax

𝒗3 𝑹𝒆𝒈𝒊𝒐𝒏-𝑪𝒆𝒏𝒕𝒓𝒊𝒄 Scatter Insight + Labels Hello everyone, presenting v3 from the previous post. Managed to integrate labels and labels with values for specific selected points, along with adding flexibility to the scatter chart. Now you can choose between filled points, unfilled points, or none. Additionally, you can opt to show selected points only or all. Looking forward to your feedback Guiding Light in Data Visualization Gustaw Dudek carlos barboza #microsoftpowerbi #microsoft #LetsWorkoutBI #dataviz #datavisualization #powerbideveloper #dax #uiuxdesign #powerbi #analytics #datavisualization #report #dashboard #reporting #visualization #microsoftpowerbi #business #kpi #businessanalytics #bi #storytelling #finance #pbicorevisuals #excelskills

🔥 The power of virtual tables in DAX 👇 If you have been using DAX for a while, you might have created VIRTUAL TABLES without noticing. Virtual tables are in-memory tables that we build using DAX functions or constructors. It's typical to use virtual tables in measures. How do you visualize your virtual tables? You can create a calculated table in Power BI Desktop or use DAX Studio. #DAXStudio #PowerBI #NestorAdrianzen #QuipuAnalytics #DAX

💡 Power BI Tip Use DAX to create dynamic visual titles. This formula dynamically generates visual title when filtering is being applied. This will enhance the clarity of your Power BI dashboard by adapting the titles based on user-selected filters, providing a more insightful and user-friendly data presentation. #powerbi #dax #uidesign

📊Preventing Errors with DIVIDE() Function in DAX In this DAX code snippet, Measure1 uses the traditional (/) operator to divide the sum of values by zero, which would result in an error. On the other hand, Measure2 uses the DIVIDE() function, which gracefully handles the divide-by-zero scenario by returning a blank instead of raising an error. This demonstrates how using the DIVIDE() function can prevent errors and maintain the integrity of your calculations in Power BI or other DAX-supported environments. #DataAnalysis #DAX #PowerBI #DataModeling #ErrorHandling 🚀

DAX- Data Analysis Expression It is a collection of operators(+,-,>,<), functions(SUM, Mean, Max,Count and many more), constants that will be used in expressions(formula) to create custom calculations. With the help of DAX formula we can create Customized tables, Columns and values Dax will return one or more than one value Diff types of DAX- 1. Table Dax 2. Column Dax 3. Dax Measure (Combination of Table Dax & Column Dax) 4. Quick Measure #timeintelligence #dax #powerbi #powerquery #tables #expressions #formulas #operators #functions