Understanding Data Modelling in Power BI: Joins, Relationships and Schemes Explained
<p><strong>DATA MODELLING</strong><br> This is a detailed process that involves creating a visual representation of data and its relationships.</p> <p><strong>TYPES OF TABLES</strong><br> <strong>FACT TABLE</strong><br> It contains quantitative data for analysis.<br> <strong>DIMENSIONS TABLE</strong><br> Provides context to fact table data.<br> <strong>STAR SCHEMA</strong><br> It contains a single fact table in the center that connects to multiple other dimensiontables.</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fhnqptmrm9lwn09l1c6p6.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale
DATA MODELLING This is a detailed process that involves creating a visual representation of data and its relationships.
TYPES OF TABLES FACT TABLE It contains quantitative data for analysis. DIMENSIONS TABLE Provides context to fact table data. STAR SCHEMA It contains a single fact table in the center that connects to multiple other dimensiontables.
SNOW FLAKE Is an extension of a star schema where dimension tables are broken down into subdimensions.
FLAT TABLE A table that displays data in a simple, two-dimensional format without any relationships to other tables.
SQL JOINS IN POWER BI
-
INNER JOIN: Returns rows present in both tables if there is a match.
-
LEFT JOIN: Returns all rows present in the left table and matching rows from the right table.
-
RIGHT JOIN: Returns matching rows from the left table and all rows present in the SQL right table.
-
FULL OUTER: Returns all rows present in both right and left tables.
-
LEFT ANTI: Returns rows from the left table that don't have matches in the right table.
-
RIGHT ANTI:Returns rows from the right table that don't have matches in the left table.
POWER BI RELATIONSHIPS
One-to-Many (1:M) One row in table A matches many in table B. For example,
Many-to Many (M:M) Here one is recommended to use a bridge table.
0ne-to-One (1:1) One row in table A matches one in table B. For example,
Many-to-One (M:M) Many rows in table A match one in table B. For example,
Active and Inactive relationships The active relationship is used by default in reports and calculations, while the inactive relationship is not used unless specified. It is also useful for alternate paths such as multiple dates.
DIFFERENCE BETWEEN JOINS AND RELATIONSHIPS Joins; combine tables based on a condition, result in new tables with combined columns and are used in power query steps. Relationships; define connections between tables in a data model and are used for; filtering, calculations and visuals across tables.
Sign in to highlight and annotate this article
Conversation starters
Daily AI Digest
Get the top 5 AI stories delivered to your inbox every morning.
More about
modelanalysisreport
AI on Trial: Legal Models Hallucinate in 1 out of 6 (or More) Benchmarking Queries - Stanford HAI
<a href="https://news.google.com/rss/articles/CBMiogFBVV95cUxNMC0tS0FTMnJWT0J0c1NBVWItaURTT0tkN2hFVURwOFlrSTMyVDlyT3I3dnhiaUNZVG1IM3Jqbmp0M0JXaDM3NThjcXd2emhobmx2a2Z5cW9YcF95cEUxYXFWbi1Tb0txUXAxYmpZdjJXMWdRU0VUT0RuOW9NeG1XaFpfTVRseU5uYjVLeWxQeTBHZzN0anU5VXRMWTJhNVdQT1E?oc=5" target="_blank">AI on Trial: Legal Models Hallucinate in 1 out of 6 (or More) Benchmarking Queries</a> <font color="#6f6f6f">Stanford HAI</font>
Sources: SpaceX has filed confidentially for an IPO, putting it on track for a June listing; it could reportedly seek a valuation of $1.75T+ and raise ~$75B (Bloomberg)
Bloomberg : Sources: SpaceX has filed confidentially for an IPO, putting it on track for a June listing; it could reportedly seek a valuation of $1.75T+ and raise ~$75B — SpaceX has filed confidentially for an initial public offering, according to people familiar with the matter …
Meituan debuts open-source AI model - KrASIA
<a href="https://news.google.com/rss/articles/CBMiSEFVX3lxTE1ZZlBjMlJKaENXcnY4Sm5fcmd3dF93YXFyekg3Mko0VU5OWFBYeWFKc2l2S3B1TzJPOW5sR0RtVXhaX1ZWd1RhZw?oc=5" target="_blank">Meituan debuts open-source AI model</a> <font color="#6f6f6f">KrASIA</font>
Knowledge Map
Connected Articles — Knowledge Graph
This article is connected to other articles through shared AI topics and tags.
More in Analyst News
‘It’s all very possible’: Michael Patrick King on The Comeback return’s shocking AI twist – and why And Just Like That will age well
<p>Could AI write an entire sitcom series? That’s the premise of the new season of comedy drama The Comeback. Its co-creator talks about being shocked by his research – and why the world needs to catch up with AJLT</p><p>TV veteran Michael Patrick King has had a long, lively career, writing, directing and producing on shows including Murphy Brown, Will & Grace and 2 Broke Girls. He’s best-known, though, for his work on the Sex and the City franchise, serving as its showrunner for the bulk of its run, writing and directing its two films, and masterminding its controversial <a href="https://www.theguardian.com/tv-and-radio/2025/aug/02/goodbye-and-just-like-that-right-time-to-end-cursed-spin-off">2020s revival And Just Like That</a>. But this month sees the return of one of his most loved
Brain implants let paralyzed man make music with his thoughts
A diving accident at age 16 left Buckwalter paralyzed from the chest down. In 2024, he enrolled in a Caltech brain-computer interface study and underwent a craniotomy to have six Blackrock Neurotech chips implanted in his motor cortex. Read Entire Article
Health Care Funding: Information on Crisis Pregnancy Centers, Fiscal Years 2018 Through 2024
What GAO Found The Department of Health and Human Services (HHS) provides grant awards to organizations that support its mission to enhance the health and well-being of all Americans. This includes funding to engage in reproductive health-related activities, such as pregnancy testing and education that crisis pregnancy centers (CPC) offer. CPCs, also called pregnancy help organizations or pregnancy resource centers, are generally nonprofit, faith-based organizations that provide certain reproductive health-related services, encourage parenting and adoption, and do not perform or refer clients for abortion services. GAO found there is no standard definition of a CPC, and differing perspectives exist regarding their characteristics and total number. For example, in 2025, stakeholder estimate
Discussion
Sign in to join the discussion
No comments yet — be the first to share your thoughts!