Posts

Showing posts with the label inflation

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

Image
Question: How do you create a gauge chart in Power BI? Suggested Answer: A gauge chart (also called a speedometer or radial gauge) visualizes a single metric’s progress toward a goal.  Here’s a step-by-step guide: Step 1: Enable the Gauge Visual Open your Power BI report in Power BI Desktop. In the Visualizations pane, click the Gauge icon (resembles a speedometer). If you don’t see it, click ... (More options) → Get more visuals → Search for "Gauge" and import it. Step 2: Add Data to the Gauge Value : Drag your KPI (e.g., Sales Amount ) to the "Value" field. Target (Optional) : Add a goal (e.g., Sales Target ) to the "Target" field. Minimum/Maximum (Optional) : Manually set the gauge’s scale range by typing values in the " Minimum " and " Maximum " fields under Format → Gauge axis . Or, drag columns to " Minimum Value " and " Maximum Value " (e.g., 0 to 100%).

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

Image
  What is the role of the M language in Power BI? Suggested Answer: The M language (also called Power Query Formula Language) is a critical component of Power BI, primarily used for data extraction, transformation, and loading (ETL). Here’s a detailed breakdown of its role: 1. Primary Role: Data Transformation M is the backbone of Power Query Editor, where it: Cleanses (e.g., removes duplicates, fixes errors). Reshapes (e.g., pivots/unpivots, splits columns). Enriches (e.g., merges tables, adds custom columns). Filters (e.g., removes irrelevant rows/columns). Example: m = Table.SelectRows(Source, each [Sales] > 1000) // Filters rows where sales exceed 1000 2. Key Features of M a) Declarative & Functional M scripts describe what to do (not step-by-step how), making it intuitive. Uses functions (e.g., Table.ReplaceValues, Text.Trim) and nested expressions. b) Query Folding Pushes transformations back to the source system (e.g., SQL Server) to improve performance. Example: A WH...

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...