Posts

Showing posts with the label dynamic

Power BI - Questions & Answers | Business Analytics & Intelligence | Processes & Tools | Part 5

Image
  Question: State all the commonly used DAX Functions in Power BI. Suggested Answer: Data Analysis Expressions (DAX) is the native formula and query language for Microsoft PowerPivot , Power BI Desktop and SQL Server Analysis Services (SSAS) Tabular models. DAX includes some of the functions that are used in Excel formulas with additional functions that are designed to work with relational data and perform dynamic aggregation. DAX data types Integer Real Currency Date (datetime) TRUE/FALSE (Boolean) String Variant Note: The BLOB (binary large object) data type is managed by the Tabular model but cannot be directly manipulated by DAX expressions. Most Common  DAX Function Types with examples 1. Aggregation Functions Calculate sums, averages, counts, etc. SUM() : Total Sales = SUM (Sales[Amount])  // Sum of sales amounts AVERAGE() : Avg Price = AVERAGE (Products[Price])  // Average product price COUNTROWS() : Order Count = COUNTROWS (Orders)  // Number of orde...

Knowledge Inflation and Skill Depreciation

Image
While the idea of a general increase in knowledge among the population sounds promising, is this knowledge truly benefiting us? I enjoy reading articles about the latest technological advancements and the leaps the tech world is making (not that I understand all of it). The rise of behemoths like OpenAI and the AI systems derived from it has rendered much of our knowledge redundant. Take, for example, someone aiming to master a programming language like Swift , Ruby , or Kotlin . Who can guarantee that these languages will still be relevant in 10–15 years? A decade or so ago, our parents and grandparents could retire after excelling in one or two specialized areas. But now, the race is non-stop—it’s on nitro-boost; it’s on steroids. Online platforms have made acquiring knowledge and basic skills easier than ever. But these skills are transient. If you don’t use them, you lose them. Everything on the internet is already accessible to AI models. Skills you pick up from an AI assistant ma...