<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Chinthani Poornima Samarasinghe on Medium]]></title>
        <description><![CDATA[Stories by Chinthani Poornima Samarasinghe on Medium]]></description>
        <link>https://medium.com/@cpdsamarasinghe?source=rss-cc7b9b9cea56------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*hTdjs5Rvh6AvDAwP</url>
            <title>Stories by Chinthani Poornima Samarasinghe on Medium</title>
            <link>https://medium.com/@cpdsamarasinghe?source=rss-cc7b9b9cea56------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 01:12:03 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@cpdsamarasinghe/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[From Data to Destination: Building a Fully Navigable Power BI Report]]></title>
            <link>https://medium.com/@cpdsamarasinghe/from-data-to-destination-building-a-fully-navigable-power-bi-report-885ca3200b84?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/885ca3200b84</guid>
            <category><![CDATA[power-bi-basics]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[power-bi-beginners]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[drillthrough]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Thu, 27 Aug 2026 16:41:46 GMT</pubDate>
            <atom:updated>2026-08-27T16:41:46.683Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 6 of the Power BI for Beginners series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*twN-nbJ_1gdTaAmaX-h6_Q.png" /></figure><p>If you’ve been following this series, you’ve come a long way. I started with the fundamentals, built the first dashboard on a retail sales dataset, wrote the first DAX formulas, and cleaned messy data in Power Query.</p><p>Now it’s time to bring it all together. In this final article, I’ll take the retail sales report I’ve been building and turn it into something that feels less like a spreadsheet and more like an app with multiple pages, clickable navigation, drill-throughs, and bookmarks that let users explore the data on their own terms.</p><p>By the end, you’ll have a polished, presentation-ready report you can confidently share with anyone technical or not.</p><h3>Why Multi-Page Matters</h3><p>A single crowded page tries to answer every question at once and usually answers none of them well. Splitting your report into focused pages a summary overview, a product-level view, a regional view lets each page do one job clearly. It also mirrors how people actually explore data: start broad, then dig into what interests them.</p><p>For my retail sales report, I’ll build three pages,</p><ol><li><strong>Overview</strong> — high-level KPIs and trends</li><li><strong>Product Analysis</strong> — performance by category and item</li><li><strong>Regional Detail</strong> — a drill-through target for deeper investigation</li></ol><h4>Step 1: Structuring Your Pages</h4><p>In Power BI Desktop, right-click the page tab at the bottom and rename it “Overview.” Add two more pages named “Product Analysis” and “Regional Detail.”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7VETBkZ73XgVS9B0xWCabg.png" /></figure><p>A few habits that pay off immediately:</p><ul><li>Keep a consistent layout grid across pages (same header position, same filter pane placement) so navigating between them feels seamless, not jarring.</li><li>Use a consistent color theme; if you set a theme in Article 2, reuse it here rather than introducing new colors.</li><li>Design at 16:9 (the default) unless you know your report will be viewed in a specific format.</li></ul><h4>Step 2: Building Navigation Buttons</h4><p>Rather than making users hunt for page tabs, add visible navigation buttons.</p><ol><li>Go to <strong>Insert &gt; Buttons &gt; Blank</strong>.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-6ExOAdbT3nebE9WbpcubQ.png" /></figure><p>2. With the button selected, open the <strong>Format</strong> pane and turn on <strong>Action</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/705/1*vWnAsKIDG5LfFV_dUJ7tGg.png" /></figure><p>3. Set <strong>Type</strong> to “Page navigation” and choose the destination page.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/221/1*apDybUx93wZnmuz_yA8SVQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/221/1*yhJx-Y94gZwCv9RWXy0ofQ.png" /></figure><p>4. Style the button so it’s clearly clickable and add hover-state formatting under the Action settings so users get visual feedback.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/242/1*iaxNXub2po0ZlIgh4CxYlA.png" /></figure><p>Repeat this for each page and place the same set of navigation buttons in the same position on every page (a simple “header bar” works well). This consistency is what makes a report feel designed rather than assembled.</p><h4>Step 3: Drill-Through — Letting Users Dig Deeper</h4><p>Drill-through lets a user right-click a data point on one page and jump to a detail page filtered to that exact context without manually setting filters themselves.</p><p>To set this up</p><ol><li>On your <strong>Regional Detail</strong> page, open the <strong>Fields</strong> pane and drag the <strong>Region</strong> field into the <strong>Drill through</strong> filter well (found near the bottom of the Visualizations pane).</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/242/1*k4ccbtMA3Z55CtVN5f1gbg.png" /></figure><p>2. Power BI automatically adds a back button to this page keep it, since users need a way to return to where they came from.</p><p>3. Design this page to show the kind of detail that wouldn’t fit on the Overview — a table of individual transactions, regional trend lines, or category breakdowns for that specific region.</p><p>Now, on the Overview page, a user can right-click a region in a chart, choose <strong>Drill through &gt; Regional Detail</strong>, and land on a fully filtered page built just for that context.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2E1Rvux58aPbuU2PETLJbw.png" /></figure><h4>Step 4: Bookmarks — Capturing States of Your Report</h4><p>Bookmarks save a “snapshot” of your report’s current state: which filters are applied, which visuals are visible, even which slicer selections are active. They’re most powerful when paired with buttons to create toggles and guided views.</p><p>A practical example: showing “This Month vs. Last Month” as a toggle instead of two separate charts.</p><ol><li>Set your visual and filters to show this month’s data.</li><li>Open the <strong>Bookmarks</strong> pane (<strong>View &gt; Bookmarks</strong>) and click <strong>Add</strong>. Name it “This Month.”</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ex1-xmJcJeJMsmOpIqXtsg.png" /></figure><ol><li>Change the filter to show last month’s data, and add a second bookmark named “Last Month.”</li><li>Add two buttons, and assign each one’s Action to trigger the corresponding bookmark.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/240/1*qmt-TLG1VtKeXJnGQJImgg.png" /></figure><p>When configuring bookmarks, pay attention to the <strong>Data</strong>, <strong>Display</strong>, and <strong>Current Page</strong> checkboxes in each bookmark’s options; they control exactly what gets captured, which matters if you only want a bookmark to change a filter without also resetting scroll position or visual selections.</p><h4>Step 5: Tying It Together with a Bookmark-Based Menu</h4><p>For a more advanced touch, you can combine bookmarks with buttons to build a simple in-report menu; for example, a set of buttons that each show/hide different groups of visuals on the same page, simulating multiple “views” without switching pages.</p><p>This is optional, but it’s a good next step once you’re comfortable with the basics above.</p><h3>Wrapping Up the Series</h3><p>That brings us to the end of this beginner series. I went from a blank canvas to a fully navigable, multi-page Power BI report covering dashboard basics, DAX, Power Query cleaning, Copilot, and now polished navigation and interactivity, all using the same retail sales dataset from start to finish.</p><p>If you’ve followed along and built each piece, you now have a genuinely presentation-ready report and, more importantly, a working understanding of how these features fit together in a real project.</p><p>Thanks for following along. Feel free to share what you’ve built, or reach out with questions on anything covered in the series.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=885ca3200b84" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[One Table Isn’t Enough: Data Modeling and Relationships in Power BI]]></title>
            <link>https://medium.com/@cpdsamarasinghe/one-table-isnt-enough-data-modeling-and-relationships-in-power-bi-c0d70dd18f11?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/c0d70dd18f11</guid>
            <category><![CDATA[power-bi-beginners]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[data-modeling]]></category>
            <category><![CDATA[star-schema]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Fri, 21 Aug 2026 10:02:25 GMT</pubDate>
            <atom:updated>2026-08-21T10:02:25.205Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 5 of the Power BI Beginner Series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PJ70z6mG4NASoB9kuXsmFQ.png" /></figure><p>So far in this series, you’ve connected to data, built a dashboard, written DAX formulas, and cleaned messy data with Power Query. But real businesses don’t run on one flat table; they have Sales, Products, Customers, and Dates as separate pieces of information.</p><p>In this article, you’ll learn how to connect those pieces properly using <strong>data modeling</strong> and <strong>relationships</strong>.</p><h3>Why One Big Table Doesn’t Work?</h3><p>Imagine your Sales table looks like this, with everything crammed into one row per transaction</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/922/1*oHmerhLP33G0BHPviDi-lg.png" /></figure><p>Notice “Notebook,” “Stationery,” “Nimal Perera,” and “Western” repeated across rows. It feels simple at first — one table, everything in it. Then your file grows to thousands of transactions, your report slows to a crawl, and one typo in “Nimal Perera” on row 4,500 means Power BI now treats him as two different customers.</p><p>This is the trap of the one-big-table approach, and it catches almost every beginner at some point.</p><ul><li>Repeated text (item names, customer names, regions) bloats file size and slows performance</li><li>Renaming an item means updating it on every single sales row instead of once</li><li>You lose the ability to slice and filter cleanly by item, customer, or region as independent “dimensions” of the data</li></ul><p>The fix is to split our Sales table apart: pull Item Name and Category out into their own table, pull Customer Name and Region out into their own table, and connect them back to Sales with relationships.</p><h3>What Is a Schema?</h3><p>If Sales, Customers, and Sales Price List are rooms in a house, a schema is the blueprint that shows how they connect which door leads from Sales to Customers, and which leads from Sales to Sales Price List.</p><p>In Power BI terms, a schema is simply the layout of your tables and the relationships between them what tables exist, what fields they hold, and how they link together.</p><p>For our retail sales model, the schema answers questions like, “Which table holds Customer ID?” and “How does Sales know which Sales Price List an item belongs to?” Get that blueprint right, and everything you build on top visuals, DAX, filters just work.</p><h3>A Quick Look at Schema Types</h3><p>Once you start splitting Sales apart, you’ll come across a few common ways to arrange the pieces:</p><ul><li><strong>Flat/single table</strong> — everything in one wide table, like the example above. Simple, but repetitive and slow</li><li><strong>Star schema</strong> — one central Sales table surrounded by Customers, Sales Price List, and Date, each connected directly to Sales</li><li><strong>Snowflake schema</strong> — like a star schema, but a dimension is broken down further (e.g., Sales Price List splits into a separate Sales Price Name lookup table)</li><li><strong>Galaxy schema (fact constellation)</strong> — multiple fact tables (say, Sales and Returns) sharing the same Customers and Date tables, used in larger models</li></ul><h3>Meet the Star Schema</h3><p>Here’s what our retail sales star schema looks like,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/615/1*-lMPK0BlK0fxO7HwLv9W2g.png" /></figure><ul><li><strong>Sales</strong> in the center this is the fact table, holding every transaction, Document No, Date, Item No, Customer No, Quantity, Net Sales</li><li><strong>Customers, Sales Price List, Item Master, and Date</strong> around it — these are the dimension tables, describing the “who, what, when” behind each sale</li></ul><p>Each dimension table connects to Sales with a relationship, forming a shape that looks like a star when you draw it out — Sales in the middle, everything else branching outward.</p><h3>Setting Up the Tables</h3><p>Splitting our retail sales data gives us:</p><ul><li><strong>Sales</strong> (fact table): Document No, Date, Item No, Customer No, Quantity, Net Sales</li><li><strong>Customers</strong> (dimension): Customer No, Customer Name, Region</li><li><strong>Sales Price List</strong> (dimension): Item No, Starting Date, Ending Date, Customer Price Group Name, Unit Price</li><li><strong>Item Master</strong> (dimension): Item No, Description, Item Category, Base Unit of Measure, Unit Cost</li><li><strong>Date</strong> (dimension): Date, Month, Quarter, Year</li></ul><h3>Creating Relationships</h3><p>Once Sales, Customers, Sales Price List, Item Master, and Date are loaded, go to the Model view in Power BI Desktop (the icon on the left sidebar that looks like connected boxes).</p><p><strong>Steps:</strong></p><ol><li>Drag Item No from Sales onto Item No in Sales Price List</li><li>Power BI draws a line between the two tables — this is your relationship</li><li>Repeat: drag Customer No from Sales onto Customer No in Customers</li><li>Repeat again: drag Date from Sales onto Date in your Date table</li><li>Repeat again: drag Item No from Sales onto Item No in Item Master</li></ol><p>You should now see Sales sitting in the middle with four lines branching out to Sales Price List, Customers, Item Master, and Date.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/843/1*7U2H8X5_wSqF9Cl7vQoF4g.png" /></figure><p>You should now see Sales sitting in the middle with three lines branching out to Sales Price List, Customers, Item Master, Customer Price Group and Date.</p><h3>Understanding Cardinality and Cross-Filter Direction</h3><p>Double-click any relationship line say, the one between Sales and Customers to see its properties.</p><ul><li><strong>Cardinality</strong> describes how rows match between tables. This is one-to-many: one row in Customers can match many rows in Sales, but each Sales row points to only one customer</li><li><strong>Cross-filter direction</strong> controls which way filtering flows. For our star schema, single direction is the standard and safest choice</li></ul><h3>Why a Dedicated Date Table Matters</h3><p>Even though Sales already has a Date column, it’s best practice to build a separate <strong>Date table</strong> and relate it to Sales. This unlocks</p><ul><li>Clean Year/Quarter/Month hierarchies, so you can drill from “2026” down to “Q1” down to “January” in a visual</li><li>Time intelligence DAX functions (like TOTALYTD or SAMEPERIODLASTYEAR) from Article 3, applied to NetSales</li><li>One consistent calendar you can reuse if you add a Returns or Targets table later</li></ul><h3>What’s Next?</h3><p>In <strong>Article 6</strong>, we’ll put this model to work designing multi-page reports with bookmarks, drill-throughs, and navigation for a polished, presentation-ready Power BI experience.</p><p><em>Stay tuned!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c0d70dd18f11" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Mess Behind the Numbers: Cleaning Data with Power Query]]></title>
            <link>https://medium.com/@cpdsamarasinghe/the-mess-behind-the-numbers-cleaning-data-with-power-query-29534656f451?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/29534656f451</guid>
            <category><![CDATA[power-query]]></category>
            <category><![CDATA[microsoft-power-bi]]></category>
            <category><![CDATA[data-cleaning]]></category>
            <category><![CDATA[power-bi-beginner-series]]></category>
            <category><![CDATA[data-transformation]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Fri, 14 Aug 2026 11:36:11 GMT</pubDate>
            <atom:updated>2026-08-14T11:36:11.876Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 4 of the Power BI Beginner Series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vU5qBtpWn8LyAljgKpKkaQ.png" /></figure><p>In the real world, data is rarely perfect. You’ll encounter blank rows, inconsistent column names, merged cells, wrong data types, and columns that need splitting. That’s exactly where <strong>Power Query</strong> comes in.</p><h3>What is Power Query?</h3><p>Power Query is Power BI’s built-in <strong>data transformation engine</strong>. It lets you clean, reshape, and prepare your data before it reaches your data model without writing a single line of code.</p><p>Think of it this way</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/711/1*re9GGYDY7cdrWrerKqAG8w.png" /></figure><p>Every transformation you make in Power Query is recorded as a <strong>step</strong> so it’s fully repeatable and auditable.</p><h3>Getting Into the Power Query Editor</h3><p>In Power BI Desktop, go to <strong>Home → Transform Data</strong>.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vsj_jM8dS9WIUN3GT86iYg.png" /></figure><p>This opens the <strong>Power Query Editor </strong>your data cleaning workspace.</p><p>You’ll see,</p><ul><li><strong>Queries pane</strong> (left) — your tables</li><li><strong>Data preview</strong> (center) — your actual data</li><li><strong>Applied Steps</strong> (right) — every transformation recorded automatically</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4hW3W5Uh3ayHSmVk-tIHww.png" /></figure><h3>Common Real-World Problems and How to Fix Them</h3><h4><strong>Problem 1: Wrong Data Types</strong></h4><p>If a “Net Sales” column is stored as text, DAX can’t sum it. Power Query lets you fix this instantly.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XZSO91c9Ocz3010rv-OqYg.png" /><figcaption>Wrong data type</figcaption></figure><p><strong>Steps:</strong></p><ol><li>Click the data type icon on the column header (ABC for text, 123 for number)</li><li>Select the correct type — Decimal Number for Amount, Date for dates</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xV0jB_olLG6_1uXfqvNadA.png" /></figure><h4><strong>Problem 2: Blank Rows</strong></h4><p>Raw exports often contain empty rows at the top or scattered throughout.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QElGrcsJReLrLnbhd_e30w.png" /><figcaption>Blank Rows</figcaption></figure><p><strong>Steps:</strong></p><ol><li>Go to <strong>Home → Remove Rows → Remove Blank Rows</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-Thi0ArW62khV8InkUVvNg.png" /></figure><h4><strong>Problem 3: Inconsistent Column Names</strong></h4><p>Your source might have columns called “net sales”, “Net Sales”, and “Net_Sales” across different files.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*FPduxBpSI1Pt2a4fmtb-SA.png" /><figcaption>Inconsistent Column Name</figcaption></figure><p><strong>Steps:</strong></p><ol><li>Double-click the column header to rename it</li><li>Keep naming consistent. This is especially important when you’re combining multiple tables</li></ol><h4><strong>Problem 4: Splitting a Combined Column</strong></h4><p>Imagine a “Customer Name” column that holds “John Smith” and you need “First Name” and “Last Name” separately.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*e1fHWcREo6ncYTdy9xNV4g.png" /></figure><p><strong>Steps:</strong></p><ol><li>Select the column → <strong>Home → Split Column → By Delimiter</strong></li><li>Choose <strong>Space</strong> as the delimiter</li><li>Power Query creates two new columns automatically</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nxms6sksWAOdPBvcjsDFFQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mqTyQnlFK83_4Rw_GaanLw.png" /><figcaption>After Split</figcaption></figure><h4><strong>Problem 5: Removing Unnecessary Columns</strong></h4><p>Source files often come with 30+ columns when you only need 10.</p><p><strong>Steps:</strong></p><ol><li>Select the columns you <em>want to keep</em></li><li>Right-click → <strong>Remove Other Columns</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Vwl5_BgeFUPe0Ug3Q5tDOw.png" /></figure><p>This keeps your model lean and your reports fast.</p><h3>The Power of Applied Steps</h3><p>Every action you take is recorded in the <strong>Applied Steps</strong> panel on the right. You can,</p><ul><li><strong>Click any step</strong> to preview the data at that point</li><li><strong>Delete a step</strong> if you made a mistake</li><li><strong>Reorder steps</strong> by dragging</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Q7hourOSyl-ML1ZlVDR4zQ.png" /></figure><p>This is what makes Power Query so powerful. it’s not destructive. Your source data is never touched.</p><h4>Loading Clean Data into Power BI</h4><p>Once your transformations are done,</p><ol><li>Click <strong>Home → Close &amp; Apply</strong></li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*q6LOBRQ6mEFKRxfx7SxKWw.png" /></figure><p>Power Query applies all your steps and loads the clean data into your model.</p><h3>What’s Next?</h3><p>You now have a full foundation: you can connect to data, build dashboards, write DAX formulas, and clean messy sources with Power Query.</p><p>In <strong>Article 5</strong>, I’ll go deeper exploring <strong>data modeling and relationships</strong>, where you’ll learn how to connect multiple tables together and build a proper star schema for more advanced reporting.</p><p><em>Stay tuned!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=29534656f451" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Unlocking the Power of DAX: Write Your First Formulas in Power BI]]></title>
            <link>https://medium.com/@cpdsamarasinghe/unlocking-the-power-of-dax-write-your-first-formulas-in-power-bi-541a0308624a?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/541a0308624a</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[dax]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[microsoft-power-bi]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Mon, 01 Jun 2026 03:51:48 GMT</pubDate>
            <atom:updated>2026-06-01T03:51:48.465Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 3 of the Power BI Beginner Series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OB-6U1So5CCO5RDFUMurnw.png" /></figure><p>In Article 2, I built a complete sales dashboard from scratch KPI cards, charts, slicers, and all. But here’s the thing, every number on that dashboard came straight from the raw data.</p><p>What if you want a metric that doesn’t exist in your dataset yet? What if you need to calculate profit margin, year-over-year growth, or running totals?</p><p>That’s exactly what <strong>DAX</strong> is for.</p><p>In this article, I’ll demystify DAX for complete beginners. You’ll learn what it is, how it works, and write your very first formulas all using the same retail sales dataset from the previous articles.</p><h3><strong>What is DAX?</strong></h3><p><strong>DAX</strong> stands for <strong>Data Analysis Expressions</strong>. It’s the formula language built into Power BI.</p><p>Think of DAX like Excel formulas but designed specifically for data models. Instead of calculating values in a single cell, DAX works across entire columns and tables.</p><p>Here’s a simple comparison</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/640/1*uI7gjuAmBQ0J5D7qtdG7qw.png" /></figure><p>If you’ve ever written an Excel formula, you already have the right instincts for DAX. The syntax just looks a little different.</p><h3><strong>Two Types of DAX Calculations</strong></h3><p>Before writing any formulas, you need to understand two key concepts in Power BI <strong>Calculated Columns </strong>and <strong>Measure</strong>. They look similar but behave very differently.</p><h4><strong>Calculated Columns</strong></h4><p>A Calculated Column adds a <strong>new column </strong>to your table. It calculates a value <strong>row by row</strong> when the data loads.</p><p><strong>When to use it: </strong>When you want to add a new piece of information to each row like a category label, a combined field, or a row-level calculation.</p><p><strong>Example:</strong> Adding a “<strong>Profit Margin %</strong>” column to every row.</p><h4><strong>Measures</strong></h4><p>A Measure is a <strong>dynamic calculation</strong> that only computes when you use it in a visual. It responds to filters, slicers, and context on the report.</p><p><strong>When to use it: </strong>For aggregations and KPIs — Total Sales, Average Order Value, Year-over-Year Growth, etc.</p><p>Measures are the backbone of any good dashboard.</p><p><strong>Rule of thumb:</strong> If the result changes depending on what filter or slicer is selected, use a <strong>Measure</strong>. If it’s a fixed value per row, use a <strong>Calculated Column</strong>.</p><h3><strong>Getting Started: Where to Write DAX</strong></h3><p>Open the retail sales report in <strong>Power BI Desktop</strong>.</p><p>To create a <strong>Measure,</strong></p><ol><li>In the <strong>Fields</strong> pane, right-click your Sales table</li></ol><p>2. Click <strong>New Measure</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/552/1*BurIYe9MvuQ90YTN7-AJ5g.png" /></figure><p>3. A formula bar appears at the top; this is where you write DAX</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/841/1*sNxRhAd-cugfn7qd28ft_A.png" /></figure><p>To create a <strong>Calculated Column</strong></p><p>1. Right-click your Sales table</p><p>2. Click <strong>New Column</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/537/1*6SYMyabb4v5xRPJt1j7JjQ.png" /></figure><p>3. The same formula bar appears</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qurIHgocMrM8tFS6SHV8gg.png" /></figure><p>Let’s write some formulas.</p><h3><strong>Your First DAX Formulas</strong></h3><h4><strong>Formula 1: Total Revenue (Measure)</strong></h4><p>Let’s start with the most fundamental formula summing up all sales.</p><p><strong>Total Revenue=SUM(‘Sales Data’[Net Sales])</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*EMfYGbCBfGOlB46XSGlR5w.png" /></figure><p><strong>What this does:</strong> Adds up every value in the `Net Sales` column.</p><p>Once you press <strong>Enter</strong>, this measure appears in your Fields pane with a calculator icon (📱). Drag it into a Card visual you’ll see the exact same number as the Net Sales card you built in Article 2.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/254/1*AEKI1dXFpagg9WbHWsrS0A.png" /></figure><h4><strong>Formula 2: Total Profit (Measure)</strong></h4><p><strong>Total Profit=SUM(‘Sales Data’[Profit])</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/981/1*XotO6A9PnDhjPQNlaNPxpQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/300/1*W1hEon0x0rgGMNiPkXHnXQ.png" /></figure><p>Simple but now try dragging this measure into a visual alongside a Region slicer. Notice how the number <strong>automatically updates</strong> when you filter by region. That’s the power of measures.</p><h4><strong>Formula 3: Profit Margin % (Measure)</strong></h4><p>This one is more interesting. Profit Margin tells us what percentage of revenue becomes profit.</p><p><strong>Profit Margin % = DIVIDE([Total Profit], [Total Revenue], 0)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZKnOz8gVzPgUkVuiCzvvXQ.png" /></figure><p>Breaking this down,</p><p><strong>[Total Profit] </strong>and<strong> [Total Revenue] </strong>reference the measures we already created</p><p><strong>DIVIDE()</strong> is used instead of “ / ” because it safely handles division by zero the third argument “0” is what it returns if the denominator is zero.</p><p>Format this measure as a <strong>Percentage</strong> by selecting it in the Fields pane and clicking <strong>Format → Percentage</strong> in the ribbon.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1007/1*raNMNGYrwIsC1AG49KlcDw.png" /></figure><h4><strong>Formula 4: Average Order Value (Measure)</strong></h4><p>Formula,</p><p><strong>Avg Order Value = DIVIDE([Total Revenue], DISTINCTCOUNT(‘Sales Data’[Order ID]))</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yP-FISKOxTTtj-CR0AIoUg.png" /></figure><p>Breaking this down,</p><p><strong>DISTINCTCOUNT()</strong> counts unique <strong>Order ID</strong>s so each order is only counted once, even if it has multiple rows</p><p>Dividing Revenue by the number of unique orders gives us the average spend per order</p><h4><strong>Formula 5: Profit Category (Calculated Column)</strong></h4><p>Now let’s add a column to classify each row as “High Profit” or “Low Profit” based on the profit value.</p><p>1. Right-click the Sales table → <strong>New Column</strong></p><p>2. Enter this formula,</p><p><strong>Profit Category = IF(‘Sales Data’[Profit] &gt; 500, “High Profit”, “Low Profit”)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jYconboR7AgFzJcRQ-dlAQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/290/1*RighPlVXNMmUTwpXithMOg.png" /></figure><p><strong>What this does:</strong> For every single row, it checks if Profit is greater than 500. If yes, it writes “High Profit”. If no, it writes “Low Profit”.</p><p>Go to the <strong>Data view</strong> (the table icon on the left sidebar) and you’ll see your new column has been added to the table with a value in every row.</p><p>You can now use this column in slicers or chart legends to split your visuals by profit category.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*p9mfLhaIc5ZEpviiQRurwg.png" /></figure><h4><strong>A Useful DAX Function to Know: CALCULATE</strong></h4><p>“CALCULATE” is one of the most powerful and most used functions in all of DAX. It lets you change the filter context of a calculation.</p><p>Here’s a practical example,</p><p>What if you want to show <strong>only the sales from the “West” region</strong>, regardless of what’s selected in the slicer?</p><p><strong>West Region Sales = CALCULATE([Total Revenue], ‘Sales Data’[Region] = “West”)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/994/1*WyzdtkOFUxDLo9ZK6jWbJQ.png" /></figure><p><strong>What this does:</strong> It calculates Total Revenue, but forces the filter to only include rows where Region equals “West”.</p><p>This is especially useful for <strong>comparison </strong>you can show “West Sales” and “Total Sales” side by side, even when a different region is selected.</p><h3><strong>Common DAX Mistakes (and How to Avoid Them)</strong></h3><h4><strong>Referencing a column when you need a measure</strong></h4><p>Wrong: This returns an error in a Card visual</p><p>Total Revenue= Sales[Net Sales]</p><p>Correct: Use an aggregation</p><p><strong>Total Revenue= SUM(‘Sales Data’[Net Sales])</strong></p><p>You can’t use a raw column reference where a single value is expected. Always wrap it in an aggregation like “<strong>SUM”</strong>, “<strong>AVERAGE”</strong>, “<strong>MIN</strong>”, “<strong>MAX”</strong>, or “<strong>COUNT”</strong>.</p><h4><strong>Using `/` for division</strong></h4><p>Risky: Will error if denominator is 0</p><p>Margin = [Total Profit] / [Total Revenue]</p><p>Safe: Returns 0 instead of an error</p><p><strong>Profit Margin % = DIVIDE([Total Profit], [Total Revenue], 0)</strong></p><h4><strong>Forgetting brackets around measure names</strong></h4><p>Column references use parentheses: ‘Sales Data’[Total Revenue]</p><p>Measure references use square brackets only: `[Total Revenue]`</p><h3><strong>Quick Reference: DAX Functions We Used</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/622/1*vyTjGIX65CQaDoOwdVqftg.png" /></figure><h3><strong>What’s Next?</strong></h3><p>You’ve written your first DAX formulas and seen how measures and calculated columns bring your data to life. This is just the beginning DAX has hundreds of functions covering time intelligence, statistical analysis, ranking, and much more.</p><p>In <strong>Article 4</strong>, I’ll walk you through <strong>Power Query </strong>Power BI’s data transformation engine and show you how to clean, reshape, and prepare messy real-world data before it ever hits your dashboard.</p><p><em>Stay tuned!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=541a0308624a" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Building Your First Dashboard in Power BI: A Step-by-Step Guide]]></title>
            <link>https://medium.com/@cpdsamarasinghe/building-your-first-dashboard-in-power-bi-a-step-by-step-guide-6d2af8e32005?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/6d2af8e32005</guid>
            <category><![CDATA[beginner]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[microsoft-power-bi]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Wed, 27 May 2026 10:09:53 GMT</pubDate>
            <atom:updated>2026-05-27T10:41:31.473Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 2 of the Power BI Beginner Series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PazFsOj6qkBYiXFy4TVnDQ.png" /></figure><p>In the <a href="https://medium.com/@cpdsamarasinghe/from-raw-numbers-to-real-insights-your-first-steps-with-power-bi-17238a36d70f">first article of this series</a>, I covered what Power BI is, why it matters, and walked through the five-step workflow. Now it’s time to roll up our sleeves and actually build something.</p><p>In this guide, I’ll build a complete interactive dashboard from scratch using a retail sales Excel dataset. Along the way, you’ll learn how to transform raw data into meaningful insights with charts, KPI cards, and slicers.</p><p>No shortcuts, no pre-built templates. Just you, Power BI Desktop, and raw data turning into real insights.</p><h3><strong>What We’re Building</strong></h3><p>Here’s a preview of the finished dashboard we’re working toward.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*xDS6mj2632mdcHSuiINEUA.png" /></figure><p>Let’s get started.</p><h3><strong>Step 1: Import the Dataset</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AIENQuIfqxE7xiJWrU9N3Q.png" /><figcaption>Retail Sales excel file</figcaption></figure><ol><li>Open <strong>Power BI Desktop</strong>. On the Home tab, click <strong>Get Data → Excel Workbook</strong></li><li>Browse to the relevant Excel file (Retail Sales.xslx) and click <strong>Open.</strong></li><li>In the <strong>Navigator</strong> window that appears, you will see a list of available sheets in the Excel file. Select the checkbox next to the required sheet(s), then click <strong>Load</strong>.</li></ol><h3><strong>Step 2: Clean the Data in Power Query</strong></h3><p>Even though our dataset is already clean, it’s good practice to always inspect it first.</p><ol><li>On the Home tab, click <strong>Transform Data </strong>to open <strong>Power Query Editor</strong>.</li></ol><p>Here’s what to check,</p><h4><strong>Check Data Types</strong></h4><p>Look at the column headers each one has a small icon showing the data type. Verify:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/376/1*KZ2ry5SXcL5bz2Vkzm34kA.png" /></figure><p>If any type looks wrong, click the icon and select the correct type.</p><h4><strong>Close &amp; Apply</strong></h4><p>Once everything looks good, click <strong>Close &amp; Apply</strong> on the top left.</p><h3><strong>Step 3: Build the Visuals</strong></h3><p>With data loaded, you’re staring at a blank canvas. Here’s how to fill it.</p><h4><strong>3.1 KPI Cards (Total Sales, Net Sales, Profit, Orders)</strong></h4><p>Cards give readers an at-a-glance summary before they dig into the charts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/696/1*7gv4t4uBcNY1LSAyT95jPg.png" /></figure><p>1. In the <strong>Visualizations pane</strong>, click the <strong>Card </strong>visual (it looks like a single number in a box)</p><p>2. A blank card appears on the canvas drag it to the top-left area</p><p>3. From the <strong>Fields pane</strong>, drag <strong>Total Sales</strong> into the <strong>Fields</strong> area of the card</p><p>4. The card now shows the grand total of all sales</p><p>Repeat this for three more cards:</p><ul><li><strong>Net Sales</strong> (drag the Net Sales field)</li><li><strong>Profit</strong> (drag the Profit field)</li><li><strong>Order Count (</strong>drag <strong>Order ID</strong> into a card, then in the Fields well, click the dropdown arrow and choose <strong>Count (Distinct))</strong></li></ul><p>Arrange the four cards in a row across the left side of your canvas.</p><p><strong>Format the cards:</strong></p><p>Click on a card, then in the Visualizations pane click the <strong>Format</strong> tab (the paintbrush icon). Under <strong>Callout value</strong>, increase the font size to 34. Under <strong>Category label</strong>, you can rename the label to something cleaner like “Total Sales”.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/256/1*xxYps5C5_UvLvRAgf9rheQ.png" /></figure><h4><strong>3.2 Bar Chart: Sales by Category</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/703/1*4UIuYe1Tisaj1bowhhvOXw.png" /></figure><p>1. Click an empty area of the canvas, then select the <strong>Clustered Bar Chart</strong> visual</p><p>2. Drag <strong>Category</strong> to the <strong>Y-axis</strong> field</p><p>3. Drag <strong>Net Sales</strong> to the <strong>X-axis</strong> field</p><p>You now have a horizontal bar chart showing which category generates the most revenue.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/459/1*QNthujqVi4sS9AYT7TUdrg.png" /></figure><h4><strong>3.3 Line Chart: Monthly Sales Trend</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/694/1*xpmKUB24WbOQXS9aNScsLg.png" /></figure><p>1. Select the <strong>Line Chart</strong> visual</p><p>2. Drag O<strong>rder Date</strong> to the <strong>X-axis</strong> — Power BI will automatically group it by Year/Quarter/Month</p><p>3. Drag <strong>Net Sales</strong> to the <strong>Y-axis</strong></p><p>4. In the X-axis field well, click the dropdown on Order Date and select <strong>Month</strong> (not the full hierarchy) for a cleaner monthly view</p><p>This chart immediately reveals seasonal patterns which months had spikes, and which were slow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/444/1*vFqgLshHQJHBqmDEhqiBWA.png" /></figure><h4><strong>3.4 Donut Chart: Sales by Region</strong></h4><p>1. Select the <strong>Donut Chart</strong> visual</p><p>2. Drag <strong>Region</strong> to <strong>Legend</strong></p><p>3. Drag <strong>Net Sales</strong> to <strong>Values</strong></p><p>You’ll instantly see the proportion of sales coming from North, South, East, and West.</p><p><strong>Format tip:</strong></p><p>In the Format pane, enable <strong>Detail labels</strong> and set the label style to “Category, Percent of total” so each segment shows the region name and its share.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/459/1*s9e8zGlFn0MSeRJX7ig2YQ.png" /></figure><h4><strong>3.5 Table Visual: Top Sales Reps</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/699/1*5_v8CeQDzvbDoyai5pKlGA.png" /></figure><p>1. Select the <strong>Table</strong> visual</p><p>2. Drag these fields into the <strong>Columns</strong> well, one by one:</p><ul><li>Sales Rep</li><li>Net Sales</li><li>Profit</li><li>Units Sold</li></ul><p>3. To sort by Net Sales, click the <strong>Net Sales</strong> column header in the visual it will sort descending, showing your top performer first.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/443/1*Ou6zKA55_eIYhVEW3k4cjQ.png" /></figure><h4><strong>3.6 Slicers: Filter by Region</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*uzhBFEPSWQaZhgit_4T1vw.png" /></figure><p>Slicers make your dashboard interactive. When a reader clicks a region, every visual on the page updates automatically.</p><p>1. Select the <strong>Input Slicer</strong> visual</p><p>2. Drag <strong>Region</strong> into the <strong>Field</strong> well</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/252/1*lD6Twnj9pkaYrs-7fxEdpA.png" /></figure><h3><strong>Step 4: Polish the Dashboard</strong></h3><p>A functional dashboard is good. A polished dashboard is professional.</p><h4><strong>Add a Title</strong></h4><p>Click on the canvas (not on any visual), then go to <strong>Insert → Text Box</strong>. Type your title: “<strong>Sales Analysis”</strong>. Increase the font size to 22 and make it bold.</p><h4><strong>Set a Background Color</strong></h4><p>Go to <strong>View → Format → Wallpaper</strong> and choose a subtle color like a light grey (#F5F5F5) to give the canvas depth.</p><h4><strong>Align Your Visuals</strong></h4><p>Hold <strong>Ctrl</strong> and click multiple visuals to select them. Then use <strong>Format → Align</strong> to line them up perfectly.</p><h4><strong>Rename the Page</strong></h4><p>Right-click the page tab at the bottom (currently called “Page 1”) and rename it to “<strong>Sales Analysis”</strong>.</p><h3><strong>Step 5: Publish to Power BI Service</strong></h3><p>Your dashboard is ready. Now share it with the world.</p><p>1. Click <strong>Home → Publish</strong></p><p>2. Sign in with your Microsoft account if prompted</p><p>3. Choose <strong>My Workspace</strong> and click <strong>Select</strong></p><p>4. Once published, click the link to open it in your browser at <strong>app.powerbi.com</strong></p><p>In the Power BI Service, you can pin visuals to a <strong>Dashboard</strong>, set up <strong>scheduled refresh</strong>, and share the report link with anyone in your organization.</p><h3><strong>What’s Next?</strong></h3><p>In <strong>Article 3</strong>, I’ll dive into <strong>DAX (Data Analysis Expressions) </strong>Power BI’s formula language.</p><p><em>Stay tuned!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6d2af8e32005" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[From Raw Numbers to Real Insights: Your First Steps with Power BI]]></title>
            <link>https://medium.com/@cpdsamarasinghe/from-raw-numbers-to-real-insights-your-first-steps-with-power-bi-17238a36d70f?source=rss-cc7b9b9cea56------2</link>
            <guid isPermaLink="false">https://medium.com/p/17238a36d70f</guid>
            <category><![CDATA[power-bi-for-beginners]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[power-bi-training]]></category>
            <category><![CDATA[microsoft-power-bi]]></category>
            <dc:creator><![CDATA[Chinthani Poornima Samarasinghe]]></dc:creator>
            <pubDate>Thu, 21 May 2026 06:05:04 GMT</pubDate>
            <atom:updated>2026-05-21T16:10:01.388Z</atom:updated>
            <content:encoded><![CDATA[<p>Article 1 of the Power BI Beginner Series</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mhzNJ5lCvngyCttpwI68Qw.png" /></figure><p>In today’s data-driven world, raw numbers and spreadsheets are everywhere but data alone tells us very little. What matters is the ability to understand that data, find patterns, and make decisions based on real insights. That’s where Power BI comes in.</p><p>Whether you’re a business analyst, a student, a manager, or simply someone curious about data, Power BI gives you the tools to turn complex data into clear, interactive visuals without needing to write a single line of code.</p><h3><strong>What Power BI Actually Does?</strong></h3><p>At its core, Power BI is a business intelligence tool. Connect it to your data a spreadsheet, a database, a cloud service and it helps you visualize trends, track KPIs in real time, and share insights across your team. The pitch is simple better decisions, faster.</p><h3><strong>Three Products, One Ecosystem</strong></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bARpXJmEWDBCXDp3nREZGA.png" /></figure><p><strong>Power BI Desktop</strong> is the free Windows application where all the building happens. Reports, dashboards, data models it all starts here.</p><p><strong>Power BI Service</strong> is the cloud layer at app.powerbi.com. Once your report is ready, this is where you publish and share it with your organization.</p><p><strong>Power BI Mobile</strong> brings your dashboards to iOS and Android, so insights travel with you.</p><p>For beginners, Desktop is your starting point. Everything else follows from there.</p><h3>Why It’s Worth Learning</h3><p>There are many data tools out there, so why choose Power BI? Here are a few compelling reasons.</p><ol><li><strong>It’s Free to Start </strong>— Power BI Desktop is completely free to download and use. You only need a paid plan if you want to share reports in the Power BI Service and even then, there’s a free tier available.</li><li><strong>Massive Industry Adoption </strong>— 97% of Fortune 500 companies use Power BI as of 2026. Learning Power BI puts you in a strong position for roles in data analytics, business intelligence, finance, and operations.</li><li><strong>User Friendly Interface </strong>— Power BI has a drag-and-drop interface that makes it easy to get started, even if you’ve never worked with a BI tool before. Many users build their first chart within minutes of opening the app.</li><li><strong>Works with Tools You Already Know </strong>— If you use Excel, you’re already halfway there. Power BI connects seamlessly with Excel, as well as Microsoft Teams, SharePoint, Azure, and hundreds of other data sources.</li><li><strong>In-Demand Career Skill </strong>— Power BI professionals are in high demand. Roles like Business Intelligence Developer, Data Analyst, and Reporting Analyst all list Power BI as a core skill often commanding strong salaries.</li></ol><h3>Getting Started: Install in Three Steps</h3><p>Getting started is easy and completely free. Follow these steps,</p><ol><li>Open the Microsoft Store on your Windows PC</li><li>Search for “Power BI Desktop” and click <strong>Get</strong> — it’s free</li><li>Once installed, open it and sign in with a Microsoft account (or create one for free)</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ve01opB8sT6UONNGkBRKsA.png" /></figure><h3>The Five-Step Workflow</h3><p>Every Power BI project follows the same core workflow. Once you understand these five steps, everything else starts to make sense.</p><p><strong>Step 1: Import Your Data</strong></p><p>On the Home tab in Power BI Desktop, click Get Data. For beginners, an Excel file or CSV is the easiest starting point. Browse to your file, select the table you want, and you’re ready to load it.</p><p><strong>Step 2: Clean Your Data with Power Query</strong></p><p>Raw data is rarely perfect. Power Query Editor is where you fix those problems removing duplicates, renaming columns, changing data types, filtering out unwanted rows, and more. All of this is done with clicks, not code.</p><p>Once your data looks good, click Close &amp; Apply to load it into Power BI.</p><p><strong>Step 3: Build the Data Model</strong></p><p>After cleaning the data, relationships are created between tables.<br>This helps Power BI understand how different data sets are connected, making analysis more accurate and efficient.</p><p><strong>Step 4: Create Visualization</strong></p><p>This is the most exciting part of Power BI.<br>You can create charts, graphs, KPIs, cards, and dashboards to visualize business information in an interactive and easy to understand format.</p><p><strong>Step 5: Publish Reports</strong></p><p>Once the report is completed, it can be published to the Power BI Service.<br>This allows users to share dashboards and reports with teams and organizations online.</p><h3>A Quick Tour of the Interface</h3><p>When you first open Power BI Desktop, here’s what you’ll see.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*oC7ZKBOB2HeLldCuoXfPsg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fzOw-waIOutPOxA2VtevKw.png" /></figure><ul><li><strong>Ribbon</strong> (top) — Tabs like Home, Insert, View, and Modeling house all your main tools</li><li><strong>Report Canvas</strong> (center) — The blank stage where you build your visuals</li><li><strong>Visualizations Pane</strong> (right, top) — Pick your chart type and map your fields</li><li><strong>Fields Pane</strong> (right, bottom) — Your tables and columns, ready to drag onto the canvas</li><li><strong>Page Tabs</strong> (bottom) — Manage multiple report pages, just like sheets in Excel</li><li><strong>View Switcher</strong> (left sidebar) — Switch between Report view, Data view, and Model view.</li></ul><h3><strong>What’s Next?</strong></h3><p>Now that you have a basic understanding of Microsoft Power BI, the next article will guide you through creating a real dashboard step by step using a real dataset.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=17238a36d70f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>