Power BI Data Modelling: Schemas, Relationships, and DAX Functions Explained

·1 views

Power BI is a Microsoft business analytics tool used to connect, clean, model, and visualize data through components including Desktop, Service, and Mobile apps. DAX (Data Analysis Expressions) is Power BI's formula language, enabling custom calculations such as SUM, AVERAGE, COUNT, IF, and RANKX that go beyond raw dataset capabilities. Data modelling in Power BI involves structuring tables and defining relationships — One-to-Many, One-to-One, or Many-to-Many — to support accurate and scalable analysis. Tables can be organized using schemas, with the Flat Table being simple but prone to performance issues, while the Star Schema places a central fact table surrounded by dimension tables for better efficiency. The Star Schema is the recommended approach as it reduces data repetition, improves report performance, and simplifies DAX measure creation.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

AI Crawler Restrictions Could Quietly Fragment the Shared Web of Knowledge

Website owners are increasingly using robots.txt files to selectively block or allow specific AI crawlers, such as GPTBot or ClaudeBot, based on commercial deals or personal preferences. While each decision appears reasonable in isolation, experts warn that thousands of similar choices made simultaneously could erode the long-held assumption of a shared internet information environment. The fragmentation is not driven by malicious intent but by intellectual property protection and survival-level licensing negotiations in an ecosystem that no longer reliably sends traffic to publishers. Critically, the divergence is most visible at the retrieval layer: when AI systems access live web content, different bots may be permitted to cite entirely different sources in response to the same query. This means two AI systems could give different answers to identical questions not because of differences in reasoning, but purely due to differences in permitted access.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why AI Prompts Are Not a System — and How to Build Skills That Last

A senior software engineer and tech lead argues that copying and reusing AI prompts is not a reliable system, because the same words can produce inconsistent outputs across different sessions and contexts. Drawing on frameworks from Glowforge CEO Dan Shapiro and AI strategist Nate B. Jones, the author distinguishes between disposable prompts and durable 'skills' — structured instructions with versioning, output contracts, and routing signals. Unlike prompts, skills specify what to produce rather than what to consider, and their improvements persist over time for both human and AI agents. The author reviewed their own order management API project to identify the best candidate for converting a prompt into a reusable skill, settling on a Gherkin scenario quality evaluation methodology that agents had repeatedly re-derived from scratch. The piece frames this shift as foundational infrastructure work, marking the start of a new phase in the author's public learning journey toward advanced AI-assisted engineering.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Packages Reusable Claude Code Skills to Eliminate Repetitive React Setup

A developer frustrated with AI coding assistants generating generic boilerplate has created a set of reusable instruction files, called SKILL.md, for Claude Code and Cursor. These skill files encode production conventions — such as auth flows, form validation, and GDPR compliance — so the AI generates project-ready code instead of bare-bones templates. The system works by automatically activating the relevant skill when a developer describes what they are building, requiring no extra prompting. A bundle of eight skills, extracted from real SaaS codebases and covering common React features, has been packaged and made available for a one-time purchase. Each skill targets React and TypeScript but includes adaptation notes for Vue, Angular, and Svelte.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

New Databricks Tool Bars LLMs from Doing Cost Arithmetic to Prevent Financial Errors

A developer has released a cost-analysis tool called databricks-cost-leak-hunter, part of the databricks-pack v2 rebuild on the claude-code-plugins marketplace, designed to identify spending inefficiencies in Databricks workspaces. The tool's core design principle is that the AI model is architecturally prevented from performing any dollar calculations itself, as LLM-generated financial figures can be plausibly wrong while appearing credible and well-formatted. Instead, all monetary values are derived directly from the customer's own billing tables by joining system.billing.usage with system.billing.list_prices via SQL, ensuring figures reflect what Databricks actually charged. The skill also includes a fail-fast permission check that halts execution and returns precise remediation steps if the required data access grants are missing. The tool received a grade of B (88/100) from the marketplace validator with zero errors reported.

0 comments Read more at DEV Community