<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>Data Stories Gallery topics</title>
    <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/bd-p/DataStoriesGallery</link>
    <description>Data Stories Gallery topics</description>
    <pubDate>Fri, 06 Nov 2026 06:32:08 GMT</pubDate>
    <dc:creator>DataStoriesGallery</dc:creator>
    <dc:date>2026-11-06T06:32:08Z</dc:date>
    <item>
      <title>The Book of a Paper Trader: 355 trades, one honest question. Is there an edge?</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/The-Book-of-a-Paper-Trader-355-trades-one-honest-question-Is/m-p/5396551#M16603</link>
      <description>&lt;P&gt;&lt;STRONG&gt;ALPACA · PAPER ACCOUNT · 27 AUG – 30 OCT 2026&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Most trading dashboards show you a P&amp;amp;L number and stop. This report keeps asking &lt;EM&gt;why&lt;/EM&gt;. Over ten weeks an automated bot won &lt;STRONG&gt;+$23,859&lt;/STRONG&gt;, and still closed the book at &lt;STRONG&gt;▼ −$4,711&lt;/STRONG&gt;. The story is about where that money went, which part of the system actually works, and what is sitting on the desk right now.&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;P&gt;Profit factor &lt;STRONG&gt;0.84&lt;/STRONG&gt; · win rate &lt;STRONG&gt;50.1%&lt;/STRONG&gt; · expectancy &lt;STRONG&gt;▼ −$13.27&lt;/STRONG&gt; per trade · account equity &lt;STRONG&gt;$95,819&lt;/STRONG&gt;&lt;/P&gt;&lt;/BLOCKQUOTE&gt;&lt;H3&gt;The story in five pages&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Cover · What am I looking at?&lt;/STRONG&gt; Three headline numbers, one candle per trading day, and a “how to read” strip for R-multiple, profit factor and why &lt;EM&gt;PAPER&lt;/EM&gt; matters.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;The Book · Is the account growing?&lt;/STRONG&gt; No. Stop exits alone erase &lt;STRONG&gt;54%&lt;/STRONG&gt; of all gains. September was the bleed (▼ −$6,828), October stopped it (▼ −$13). &lt;STRONG&gt;Only crypto pays&lt;/STRONG&gt; (▲ +$631, PF 1.14).&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;The Edge · Where do wins and losses come from?&lt;/STRONG&gt; &lt;STRONG&gt;Shorts carry the book&lt;/STRONG&gt;: ▲ +$4,727 at 62% win vs longs ▼ −$9,438 at 44%. &lt;STRONG&gt;40 trades slipped past −1R&lt;/STRONG&gt; (▼ −$8.2K), while trailing stops made ▲ +$2,845 at 81% win.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;The Desk · What is open right now?&lt;/STRONG&gt; &lt;STRONG&gt;74% of equity sits in cash&lt;/STRONG&gt; ($71.3K). One name (KO) is 39% of exposure. 631 orders: 43.9% filled, 52% cancelled by design.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;The Ledger · Let me explore it myself.&lt;/STRONG&gt; Every strategy by asset class with trades, a net P&amp;amp;L heat bar, win rate, avg R, profit factor and an &lt;STRONG&gt;EDGE / WATCH / CUT&lt;/STRONG&gt; verdict.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Storytelling choices&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Titles state the finding, not the chart type.&lt;/STRONG&gt; “From $23.9K won to $4.7K lost”, “Shorts carry the book”, “One name carries the gain”. Every title is a DAX measure, so it rewrites itself when the data changes.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;One question per page&lt;/STRONG&gt;, in the order a trader would ask it: am I growing → why → what is at risk now → let me dig.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Honest framing.&lt;/STRONG&gt; A &lt;EM&gt;PAPER&lt;/EM&gt; badge on every page, the 15 crypto pairs with no price data are called out instead of hidden, and the cover explains every metric before you see it.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Markers inside the chart&lt;/STRONG&gt; instead of legends: PEAK / LOW chips on the equity curve, a win-rate chip on every strategy, “+N smaller” for treemap tiles too small to label.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;How it is built&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Microsoft Fabric end to end.&lt;/STRONG&gt; Notebooks pull Alpaca (paper) and Binance data into a lakehouse and move it bronze → silver → gold as Delta tables.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Two semantic models.&lt;/STRONG&gt; A Direct Lake model for daily work, plus an Import copy for Publish to web (Direct Lake can't be published publicly).&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;146 DAX measures, zero custom visuals.&lt;/STRONG&gt; Every chart (equity curve with drawdown, waterfall, lollipop, R-multiple dot plot, treemap, order-flow sankey, cover candles) is drawn in DAX as SVG or HTML. It is fully data-driven and loads as plain images.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;One design system.&lt;/STRONG&gt; A single token set (colour, type scale, radius, 8px spacing) generates the DAX, a tokens.css file and the Power BI theme JSON, so native and custom visuals look identical. Serif display titles, sans labels, tabular figures.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Navigation and accessibility.&lt;/STRONG&gt; A dark rail with an active pill, made clickable by an invisible vertical Page navigator. Gain/loss colours pass WCAG AA, ▲▼ arrows mean colour is never the only signal, and alt-text measures are written for the main visuals.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Explore&lt;/H3&gt;&lt;P&gt;▶ Live report: embedded above (start on the cover and use the left rail)&lt;/P&gt;&lt;P&gt;↗ GitHub (notebooks, all DAX measures, theme and design tokens): github.com/PatricRc/trading-analytics-fabric&lt;/P&gt;&lt;P&gt;↗ LinkedIn: linkedin.com/in/patriciorioscanepa · Portfolio: data-pat-ai.netlify.app&lt;/P&gt;&lt;P&gt;&lt;EM&gt;Paper trading only. Simulated fills, no real money, not financial advice. Built by Patricio Rios with Microsoft Fabric + Power BI.&lt;/EM&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 05 Nov 2026 13:57:52 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/The-Book-of-a-Paper-Trader-355-trades-one-honest-question-Is/m-p/5396551#M16603</guid>
      <dc:creator>PatricRc</dc:creator>
      <dc:date>2026-11-05T13:57:52Z</dc:date>
    </item>
    <item>
      <title>Workout Wednesday 2026 W45 | Big Numbers and Key Point Indicators</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-W45-Big-Numbers-and-Key-Point-Indicators/m-p/5382615#M16602</link>
      <description>&lt;P&gt;This weeks Workout Wednesday challenge is all Big Numbers and Key Point Indicators!&amp;nbsp;&lt;/P&gt;&lt;P&gt;Varying stakeholder requirements mean we need to have different visuals ready to go, this week we set out a large range of options for you to work on. How many can you build?&lt;/P&gt;&lt;P&gt;For more info: &lt;A class="lia-external-url" href="https://www.workout-wednesday.com/pbi-2026-w45/" target="_blank"&gt;https://www.workout-wednesday.com/pbi-2026-w45/&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 02 Nov 2026 17:05:07 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-W45-Big-Numbers-and-Key-Point-Indicators/m-p/5382615#M16602</guid>
      <dc:creator>Robbinv8</dc:creator>
      <dc:date>2026-11-02T17:05:07Z</dc:date>
    </item>
    <item>
      <title>Notes on refresh scheduling in shared workspaces</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Notes-on-refresh-scheduling-in-shared-workspaces/m-p/5375996#M16590</link>
      <description>Some notes on scheduling refreshes when datasets are shared across workspaces, hoping this helps someone.</description>
      <pubDate>Wed, 21 Oct 2026 03:06:16 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Notes-on-refresh-scheduling-in-shared-workspaces/m-p/5375996#M16590</guid>
      <dc:creator>zzqr13w2</dc:creator>
      <dc:date>2026-10-21T03:06:16Z</dc:date>
    </item>
    <item>
      <title>Workout Wednesday 2026 Week 42 | Power BI: Overlay Information With Bookmarks</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-42-Power-BI-Overlay-Information-With/m-p/5374495#M16575</link>
      <description>&lt;P&gt;Hi everyone, this is my submission for this week's Workout Wednesday!&lt;/P&gt;&lt;P&gt;Bookmarks can be a little bit tricky sometimes especially when there's lots of elements to show and hide. This Workout Wednesday uses 4 bookmarks (and even more for the bonus challenge) but it's so satisfying when it comes together. This is especially useful if there's parts of your dashboard that you'd like to explain to the user and you don't feel like a tooltip is enough.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 14 Oct 2026 09:10:31 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-42-Power-BI-Overlay-Information-With/m-p/5374495#M16575</guid>
      <dc:creator>vivienlee</dc:creator>
      <dc:date>2026-10-14T09:10:31Z</dc:date>
    </item>
    <item>
      <title>Grão Raro: assinaturas de café especial</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Gr%C3%A3o-Raro-assinaturas-de-caf%C3%A9-especial/m-p/5374430#M16574</link>
      <description>&lt;P&gt;Relatório de acompanhamento de um clube de assinatura de cafés especiais. A Grão Raro é uma empresa fictícia e todos os dados são fictícios, criados para este portfólio.&lt;/P&gt;&lt;P&gt;O relatório foi pensado para quem gerencia a operação de assinaturas: receita, base de assinantes, cancelamentos e entregas, um mês de cada vez, com comparação contra o mês anterior.&lt;/P&gt;&lt;P&gt;Visão geral: o resumo do mês. Receita recorrente, assinantes ativos, novas assinaturas e taxa de cancelamento, com a receita por mês e plano, o saldo semanal de entradas e saídas, os cafés mais pedidos, o mapa de assinantes por estado e a preferência de torra.&lt;/P&gt;&lt;P&gt;Manual do relatório: o que cada página mostra e como usar cada controle.&lt;/P&gt;&lt;P&gt;As páginas Assinantes, Cancelamentos e Pedidos e entregas estão em construção e aparecem no menu com cadeado.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Recursos de experiência de uso:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Central de ajuda: uma janela de conversa, aberta pelo menu, que simula uma assistente de IA dentro do relatório. A pessoa digita uma pergunta em linguagem natural (“quanto faturou em março?”, “qual café mais vende no Sul?”, “quantos cancelaram por região?”) ou escolhe uma sugestão por assunto, e recebe o número, a comparação, um mini gráfico de barras e, quando cabe, a foto do café. Responde para qualquer mês, por café, torra, região, plano e canal. A conversa é mantida ao trocar de página, e há botões de nova conversa, copiar e avaliar a resposta.&lt;/P&gt;&lt;P&gt;Filtros: reunidos em um painel próprio, em botões com estado de hover, com contador de filtros ativos e Limpar filtros.&lt;/P&gt;&lt;P&gt;Manual e tour guiado: a página Manual do relatório descreve cada página e cada controle, e o tour “Como usar” apresenta os recursos passo a passo.&lt;/P&gt;&lt;P&gt;Acessibilidade: contraste no nível AA em todos os textos, e todos os indicadores batem com os visuais de onde saem.&lt;/P&gt;</description>
      <pubDate>Tue, 13 Oct 2026 23:11:12 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Gr%C3%A3o-Raro-assinaturas-de-caf%C3%A9-especial/m-p/5374430#M16574</guid>
      <dc:creator>nayarahellen</dc:creator>
      <dc:date>2026-10-13T23:11:12Z</dc:date>
    </item>
    <item>
      <title>Workout Wednesday 2026 Week 41: Stripe Chart Using Native Column Chart</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-41-Stripe-Chart-Using-Native-Column/m-p/5374367#M16573</link>
      <description>&lt;P&gt;This week's challenge is from &lt;A class="lia-external-url" href="https://www.linkedin.com/in/santhanalakshmip/" target="_blank" rel="noopener"&gt;Santhana Lakshmi Ponnurasan&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;What if a column chart could tell a story through color? A stripe chart uses colored stripes to reveal patterns and changes in data at a glance.&lt;/P&gt;
&lt;P&gt;In this exercise, we’ll transform Power BI’s native column chart into a stripe chart where each stripe represents a data point, and its color helps us spot patterns, changes, and unusual values.&lt;/P&gt;
&lt;P&gt;Same visual, a different way to see the data. Ready to give your column chart a makeover?&lt;/P&gt;
&lt;P&gt;For more info, see: &lt;A class="lia-external-url" href="https://www.workout-wednesday.com/pbi-2026-w41/" target="_blank" rel="noopener"&gt;https://www.workout-wednesday.com/pbi-2026-w41/&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 13 Oct 2026 16:09:55 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-41-Stripe-Chart-Using-Native-Column/m-p/5374367#M16573</guid>
      <dc:creator>Meagan</dc:creator>
      <dc:date>2026-10-13T16:09:55Z</dc:date>
    </item>
    <item>
      <title>ANALISI GLOBALE DI FATTURATO E VOLUMI</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/ANALISI-GLOBALE-DI-FATTURATO-E-VOLUMI/m-p/5373791#M16572</link>
      <description>&lt;P&gt;Il sistema visualizza immediatamente i KPI macroscopici:&amp;nbsp;&lt;STRONG&gt;Fatturato Totale&lt;/STRONG&gt;, &lt;STRONG&gt;Pezzi Venduti&lt;/STRONG&gt;, &lt;STRONG&gt;Margine Medio&lt;/STRONG&gt;&amp;nbsp;e la &lt;STRONG&gt;Crescita Anno su Anno&lt;/STRONG&gt;. Permette di esplorare il dettaglio delle vendite per singolo Paese e per specifico modello di prodotto, analizzando l'andamento mensile del fatturato e della marginalità per identificare istantaneamente i picchi stagionali o i mesi critici.&lt;/P&gt;&lt;P&gt;Strumento di simulazione predittiva (&lt;EM&gt;What-If Analysis&lt;/EM&gt;) applicato al controllo di gestione. In condizioni di mercato stabili, impostando il &lt;STRONG&gt;Parametro Costi su un valore pari a 0&lt;/STRONG&gt;, il sistema calcola la baseline del Margine Assoluto e del Margine Simulato per ciascuna combinazione di Paese e Prodotto.&lt;/P&gt;&lt;P&gt;Valutazione dell'impatto dei fattori macroeconomici sulla redditività aziendale. L’azienda può anticipare le criticità vedendo quali prodotti o interi mercati andrebbero in perdita (valori in rosso), permettendo di rimodulare i listini di vendita prima che l'erosione del margine si rifletta sui bilanci ufficiali.&lt;/P&gt;&lt;P&gt;Segmentazione strategica del portafoglio clienti basata sul principio di Pareto.&lt;/P&gt;&lt;P&gt;Correlazione avanzata tra volumi di vendita e guadagno reale per singolo cliente. Questa vista incrocia la Classe ABC del fatturato con la reale &lt;STRONG&gt;Classe ABC del Margine&lt;/STRONG&gt;. Consente di smascherare i "falsi leader": clienti che generano un fatturato altissimo (Classe A) ma che erodono marginalità a causa di sconti eccessivi o costi logistici elevati, venendo così declassati nella classificazione del margine.&lt;/P&gt;&lt;P&gt;Rappresentazione visiva immediata del posizionamento del portafoglio clienti tramite un grafico a dispersione. L'asse orizzontale misura il Fatturato Totale, mentre l'asse verticale indica la percentuale di Margine. Le linee di media dividono il grafico in &lt;STRONG&gt;quattro quadranti strategici&lt;/STRONG&gt;: in alto a destra si posizionano i clienti "Campioni" (alto fatturato, alto margine), in basso a destra i clienti "A rischio" (volumi elevati ma bassa redditività), mentre i punti verdi a sinistra identificano la clientela frammentata a basso fatturato.&lt;/P&gt;&lt;P&gt;Interattività avanzata tramite funzioni di &lt;EM&gt;Drill-Through&lt;/EM&gt; e &lt;EM&gt;Tooltip dinamici&lt;/EM&gt;. Navigando con il cursore sopra i punti di dispersione del grafico, il sistema fa emergere finestre informative contestuali senza costringere l'utente a cambiare schermata.&lt;/P&gt;</description>
      <pubDate>Sun, 11 Oct 2026 05:43:59 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/ANALISI-GLOBALE-DI-FATTURATO-E-VOLUMI/m-p/5373791#M16572</guid>
      <dc:creator>luca_bartolomei</dc:creator>
      <dc:date>2026-10-11T05:43:59Z</dc:date>
    </item>
    <item>
      <title>Workout Wednesday 2026 Week 40: Metric Navigator</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-40-Metric-Navigator/m-p/5373420#M16569</link>
      <description>&lt;P&gt;This week's challenge comes from &lt;A class="lia-external-url" href="https://www.linkedin.com/in/andgenn/" target="_blank"&gt;Andrei Khaidarov&lt;/A&gt;&lt;/P&gt;&lt;P&gt;A profit card tells you the result. It does not show how that result is built, which components changed, or where to investigate next.&lt;/P&gt;&lt;P&gt;This week, build an interactive&lt;STRONG&gt; &lt;/STRONG&gt;Financial Metric Map in Power BI. Start with Net profit and reveal its components one branch at a time: revenue, cost of goods sold, operating expenses, interest and tax. Continue down to order volumes, basket size, unit economics, discounts and returns.&lt;/P&gt;&lt;P&gt;The goal is not to put more KPI cards on a page. It is to connect each number to its calculation and comparison. A reader should be able to follow a change in profit down to a smaller, understandable component, inspect the formula, and compare the same structure across countries and years.&lt;/P&gt;&lt;P&gt;For more info, see &lt;A class="lia-external-url" href="https://www.workout-wednesday.com/pbi-2026-w40/" target="_blank"&gt;https://www.workout-wednesday.com/pbi-2026-w40/&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 08 Oct 2026 16:20:09 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2026-Week-40-Metric-Navigator/m-p/5373420#M16569</guid>
      <dc:creator>Meagan</dc:creator>
      <dc:date>2026-10-08T16:20:09Z</dc:date>
    </item>
    <item>
      <title>Daylight Check: Window to Floor Area Ratio on a BIM Model</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Daylight-Check-Window-to-Floor-Area-Ratio-on-a-BIM-Model/m-p/5373207#M16567</link>
      <description>&lt;P&gt;This report checks the window to floor area ratio of a residential building level by level, directly on its BIM model. Most building codes require the glazed area to be at least one eighth of the floor area: here every level gets its ratio, compared against that threshold, and the levels that fall short turn red on the 3D model.&lt;/P&gt;&lt;P&gt;The model is an IFC file converted into tabular data with Vcad, so glazed areas, floor areas and levels come straight from the model, with no manual schedules.&lt;/P&gt;&lt;P&gt;How to use it:&lt;BR /&gt;- Click a level in the bar chart or in the table to isolate it. Cards, donut, table and 3D model filter together.&lt;BR /&gt;- Use the Level slicer to jump to a specific floor.&lt;BR /&gt;- Switch between As designed and What-if. The what-if scenario reduces the glazing on levels 2, 8 and 14 to 35% and shows which levels stop complying.&lt;BR /&gt;- The donut shows where the glass is, grouped by band of levels.&lt;/P&gt;&lt;P&gt;Colors on the model: blue for glazing, yellow for levels that pass, red for levels below 1/8.&lt;/P&gt;&lt;P&gt;The ratio is computed on the gross floor area of each level, which makes it a conservative early check rather than a room by room verification.&lt;/P&gt;</description>
      <pubDate>Thu, 08 Oct 2026 06:47:25 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Daylight-Check-Window-to-Floor-Area-Ratio-on-a-BIM-Model/m-p/5373207#M16567</guid>
      <dc:creator>powerbiblogic</dc:creator>
      <dc:date>2026-10-08T06:47:25Z</dc:date>
    </item>
    <item>
      <title>Daylight Check: Window to Floor Area Ratio on a BIM Model</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Daylight-Check-Window-to-Floor-Area-Ratio-on-a-BIM-Model/m-p/5373204#M16566</link>
      <description>&lt;P&gt;This report checks the window to floor area ratio of a residential building level by level, directly on its BIM model. Most building codes require the glazed area to be at least one eighth of the floor area: here every level gets its ratio, compared against that threshold, and the levels that fall short turn red on the 3D model.&lt;/P&gt;&lt;P&gt;The model is an IFC file converted into tabular data with Vcad, so glazed areas, floor areas and levels come straight from the model, with no manual schedules.&lt;/P&gt;&lt;P&gt;How to use it:&lt;BR /&gt;- Click a level in the bar chart or in the table to isolate it. Cards, donut, table and 3D model filter together.&lt;BR /&gt;- Use the Level slicer to jump to a specific floor.&lt;BR /&gt;- Switch between As designed and What-if. The what-if scenario reduces the glazing on levels 2, 8 and 14 to 35% and shows which levels stop complying.&lt;BR /&gt;- The donut shows where the glass is, grouped by band of levels.&lt;/P&gt;&lt;P&gt;Colors on the model: blue for glazing, yellow for levels that pass, red for levels below 1/8.&lt;/P&gt;&lt;P&gt;The ratio is computed on the gross floor area of each level, which makes it a conservative early check rather than a room by room verification.&lt;/P&gt;&lt;P&gt;Built with Power BI and the Vcad 3D visual. How it works: https://www.vcad.it/window-to-floor-area-ratio-bim-power-bi/&lt;/P&gt;</description>
      <pubDate>Thu, 08 Oct 2026 06:42:33 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Daylight-Check-Window-to-Floor-Area-Ratio-on-a-BIM-Model/m-p/5373204#M16566</guid>
      <dc:creator>powerbiblogic</dc:creator>
      <dc:date>2026-10-08T06:42:33Z</dc:date>
    </item>
    <item>
      <title>30 years of Paraguay's exports</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/30-years-of-Paraguay-s-exports/m-p/5373016#M16565</link>
      <description>&lt;P&gt;Hi, my name is Facundo, and this is my first dashboard. I built it to showcase Paraguay's exports from 1994 to 2025, using data from the Central Bank of Paraguay (BCP). The dashboard lets you explore the total value of exports, the main products, and their destinations. You can also filter by time period (within the 1994–2025 range) and by product.&lt;/P&gt;&lt;P&gt;One of the most interesting findings: electricity went from more than half of Paraguay's exports in the 1990s to just 10.9% in 2025, while agriculture now accounts for 64%.&lt;/P&gt;</description>
      <pubDate>Wed, 07 Oct 2026 15:35:06 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/30-years-of-Paraguay-s-exports/m-p/5373016#M16565</guid>
      <dc:creator>fsamaniegoc</dc:creator>
      <dc:date>2026-10-07T15:35:06Z</dc:date>
    </item>
    <item>
      <title>PMO Portfolio: From Strategy to Success</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/PMO-Portfolio-From-Strategy-to-Success/m-p/5372969#M16564</link>
      <description>&lt;P&gt;&lt;STRONG&gt;What decisions should a PMO make about its live projects?&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;This three-page report turns 36 months of portfolio snapshots (100 projects, 1,696 monthly records) into one clear answer: fund 4, fix 22, pause 5, stop 3, and confirm 18 projects nobody is watching.&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;&lt;STRONG&gt;Pulse: how is the portfolio trending?&lt;/STRONG&gt;&lt;BR /&gt;Health is holding at 84.5, but cost overrun has climbed back to +12.9% and average delay has grown by 15 days in a year. A snapshot slicer lets you rewind any month, and the headlines rewrite themselves.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Diagnose: what drives the outcomes?&lt;/STRONG&gt;&lt;BR /&gt;Scope changes, overdue risk mitigations and capacity gaps hurt every outcome. Projects with 2+ scope changes overrun by +22%, against +6% with one. Strategic alignment, priority and budget size show no link to delivery at all.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Decide: what should leaders do?&lt;/STRONG&gt;&lt;BR /&gt;Every live project gets a call from five transparent rules, documented in the report's About panel. Two ZoomCharts Drill Down visuals work together:&lt;/LI&gt;&lt;/OL&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Drill Down Combo Bar PRO&lt;/STRONG&gt; compares planned vs forecast return by decision, then drills into the Recover types.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Drill Down Scatter PRO&lt;/STRONG&gt; maps strategic value against delivery health and filters when you click a bar.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;The key insight: Recover projects were approved at 2.42× return but are now forecasting 2.05×, so the most valuable work is leaking value while it waits to be fixed. Six sized actions show what to do first, starting with moving 42,076 hours a month from paused and stopped work into recoveries.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Built with&lt;/STRONG&gt;&lt;BR /&gt;Power BI · DAX (dynamic snapshot logic, measure-driven decision rules, SVG visuals for panels and dumbbells) · ZoomCharts Drill Down PRO visuals · bookmarks, field parameters and synced slicers&lt;/P&gt;&lt;P&gt;🔗 Interactive report: https://app.powerbi.com/view?r=eyJrIjoiNjU3YTk3NDYtNWRmMC00MzdkLWI1MjEtYWFjYmFlYThmYjBhIiwidCI6IjQ2NTRiNmYxLTBlNDctNDU3OS1hOGExLTAyZmU5ZDk0M2M3YiIsImMiOjl9&lt;/P&gt;&lt;P&gt;Dataset: FP20 Analytics Challenge 41, with ZoomCharts&lt;/P&gt;&lt;P&gt;Feedback is very welcome.&lt;/P&gt;</description>
      <pubDate>Wed, 07 Oct 2026 13:00:55 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/PMO-Portfolio-From-Strategy-to-Success/m-p/5372969#M16564</guid>
      <dc:creator>Ali_India</dc:creator>
      <dc:date>2026-10-07T13:00:55Z</dc:date>
    </item>
    <item>
      <title>Emergency Department Operations: patient flow, triage and a shift staffing simulator</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Emergency-Department-Operations-patient-flow-triage-and-a-shift/m-p/5372775#M16563</link>
      <description>&lt;P&gt;&lt;STRONG&gt;Description&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;This report follows a fictitious network of six emergency departments through one month of care: August 2026, 47,357 visits. It was designed for the medical coordination team, and the question behind every page is where and when the team needs reinforcement. All data is made up, with no real patients or hospitals involved. The report is in Brazilian Portuguese.&lt;/P&gt;&lt;P&gt;The eight pages follow the patient's path: Overview, Patient flow, Triage, Journey to the doctor, Left without being seen, Outcome, Returns within 72 hours, and a Detail page for drill-through.&lt;/P&gt;&lt;P&gt;What to look for:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Overview: the five KPI cards are also selectors. Clicking one switches the charts on the page to that metric. The Manchester triage colors stay off until you turn on the Colors toggle, so the page doesn't open as a rainbow.&lt;/LI&gt;&lt;LI&gt;Patient flow: average arrivals by hour and weekday, plus a staffing simulator. Sliders set the doctors on duty in each shift (overnight, morning, afternoon and evening) and how many patients a doctor sees per hour. The matrix shows the occupancy of the busiest unit in every hour of a typical week in three bands: idle team below 60%, adequate from 60% to 85%, overloaded above 85%. It runs on what-if parameters, a matrix colored by measure and bookmarks.&lt;/LI&gt;&lt;LI&gt;Triage: nurses needed against nurses scheduled, hour by hour, and how many hours each unit runs short.&lt;/LI&gt;&lt;LI&gt;Journey: a timeline of the stages from arrival to the doctor, with door-to-doctor time by unit and by arrival hour.&lt;/LI&gt;&lt;LI&gt;Left without being seen: the stage where patients give up, and a quadrant chart of that rate against door-to-doctor time, with the alert zone shaded.&lt;/LI&gt;&lt;LI&gt;Returns within 72 hours: a Pareto chart of diagnosis groups.&lt;/LI&gt;&lt;LI&gt;Detail: right-click a unit, specialty or risk bar anywhere to drill through. The title names the slice you came from, and the table uses data bars and native status icons against the 85% target, with the rule in the tooltip.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;A guided tour opens from the "Como usar" button and walks through each page with bookmarks. The report was first designed as an HTML mockup to settle layout and hierarchy, then built in Power BI on a star schema. Text contrast meets WCAG AA, and color never carries meaning on its own: every color comes with a label or an icon.&lt;/P&gt;</description>
      <pubDate>Tue, 06 Oct 2026 23:05:26 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Emergency-Department-Operations-patient-flow-triage-and-a-shift/m-p/5372775#M16563</guid>
      <dc:creator>nayarahellen</dc:creator>
      <dc:date>2026-10-06T23:05:26Z</dc:date>
    </item>
    <item>
      <title>Brazilian E-Commerce</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Brazilian-E-Commerce/m-p/5372447#M16561</link>
      <description>&lt;P&gt;An interactive dashboard developed as part of my data analytics portfolio to explore sales performance across the Brazilian E-Commerce Public Dataset. About 100k orders placed between Sep 2016 and Aug 2018.&lt;BR /&gt;&lt;BR /&gt;The data was modeled in a SQL Server data warehouse and exposed to Power BI as a star schema with 4 fact tables and 6 dimensions. Every visual has a dynamic subtitle that states its takeaway for the selected filters.&lt;BR /&gt;&lt;BR /&gt;Key findings: net revenue reached R$ 13.49M from 98,199 orders, with 65.4% coming from the Southeast and 80% from only 18% of sellers. Orders delivered late score 2.3 stars on average, against 4.3 when on time, and 171 top sellers ship late more often than the 9.3% average, putting 24.7% of revenue at risk.&lt;BR /&gt;&lt;BR /&gt;The report has three pages:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Sales Overview&lt;/STRONG&gt;&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Sellers &amp;amp; Logistics&lt;/STRONG&gt;&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Delivery &amp;amp; Reviews&lt;/STRONG&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;You can navigate using the icons on the left panel.&lt;/P&gt;&lt;P&gt;Skills: Data modeling, DAX, KPI development, interactive visualization.&lt;/P&gt;&lt;P&gt;Feedback on the design, analysis and storytelling is welcome!&lt;/P&gt;</description>
      <pubDate>Mon, 05 Oct 2026 18:30:34 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Brazilian-E-Commerce/m-p/5372447#M16561</guid>
      <dc:creator>fsck</dc:creator>
      <dc:date>2026-10-05T18:30:34Z</dc:date>
    </item>
    <item>
      <title>Golden Wok Delivery Network Intelligence</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Golden-Wok-Delivery-Network-Intelligence/m-p/5372117#M16560</link>
      <description>&lt;P&gt;From network pressure to service reliability and corridor-level action&lt;/P&gt;&lt;P&gt;Golden Wok’s delivery network presents a connected operational challenge: understanding where delivery pressure originates, when service reliability begins to deteriorate, and which corridors require attention.&lt;/P&gt;&lt;P&gt;The report follows a three-stage analytical journey:&lt;/P&gt;&lt;P&gt;Network Performance → Service Reliability → Network Optimization&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;01 | Network Performance&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The first page explores where delivery pressure originates across the network.&lt;/P&gt;&lt;P&gt;Delivery radius, traffic friction, weather conditions and zone tiers provide the context for understanding where operational pressure is concentrated and how those conditions affect delivery performance.&lt;/P&gt;&lt;P&gt;Outcome: Identify where network conditions create the greatest delivery pressure.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;02 | Service Reliability&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The second page focuses on what happens as delivery performance deteriorates.&lt;/P&gt;&lt;P&gt;One of the clearest findings was the relationship between delivery duration and SLA risk. Breach rates increased sharply across longer delivery-time bands, while customer ratings remained comparatively stable.&lt;/P&gt;&lt;P&gt;This made service reliability a stronger operational signal than the customer-rating response in the supplied data.&lt;/P&gt;&lt;P&gt;Outcome: Understand when delivery performance begins to translate into significant SLA risk.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;03 | Network Optimization&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The final page moves from diagnosis to action.&lt;/P&gt;&lt;P&gt;I combined Profit Efficiency and SLA Risk to classify delivery corridors into Priority Intervention, Service Intervention, Economic Optimization, and Protect &amp;amp; Maintain.&lt;/P&gt;&lt;P&gt;ABC classification then adds economic importance, helping distinguish valuable corridors that should be protected or repaired from weaker, higher-risk corridors that may warrant deeper review.&lt;/P&gt;&lt;P&gt;Interactive tooltips provide additional corridor and intervention context without overcrowding the main report.&lt;/P&gt;&lt;P&gt;Outcome: Prioritize corridor-level action based on economic value and service reliability.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Validation Before Visualization&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The brief served as a checklist for testing key assumptions against the supplied data. Where discrepancies appeared, values were adjusted only when defensible or excluded when they could not be reliably interpreted.&lt;/P&gt;&lt;P&gt;This kept the analysis grounded in the brief while allowing validated evidence to determine the final story.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Final Takeaway&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Golden Wok became a simple decision journey:&lt;/P&gt;&lt;P&gt;Diagnose → Understand → Prioritize&lt;/P&gt;&lt;P&gt;The project reinforced the importance of validating assumptions before visualization and keeping each report page focused on a clear business question.&lt;/P&gt;&lt;P&gt;A rich operational dataset does not need a crowded report. Every visual should help move the analysis closer to a decision.&lt;/P&gt;&lt;P&gt;Data Source: &lt;A class="lia-external-url" href="https://datadna.onyxdata.co.uk/challenges/september-2026-datadna-golden-wok-food-delivery-analytics-challenge/" target="_blank" rel="noopener"&gt;September 2026 DataDNA – Golden Wok Food Delivery Analytics Challenge&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 03 Oct 2026 18:53:30 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Golden-Wok-Delivery-Network-Intelligence/m-p/5372117#M16560</guid>
      <dc:creator>ugon</dc:creator>
      <dc:date>2026-10-03T18:53:30Z</dc:date>
    </item>
    <item>
      <title>F&amp;B Sales Performance Dashboard</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/F-B-Sales-Performance-Dashboard/m-p/5371902#M16559</link>
      <description>&lt;P&gt;F&amp;amp;B Sales Intelligence Dashboard&lt;/P&gt;&lt;P&gt;An interactive dashboard developed as part of my data analytics portfolio to explore sales performance across three F&amp;amp;B outlets in Indonesia. It uses the Anonymous Transactional Dataset from Mendeley Data, containing historical POS transactions and product metadata for January–September 2025.&lt;/P&gt;&lt;P&gt;The dashboard covers sales KPIs, outlet performance, weekly trends, transaction intensity by day and operating hour, and product rankings. It also incorporates RFM-based transaction segmentation using K-Means, replicating a published methodology with the full dataset. Four transaction segments are summarized by volume, average spending, and total transaction value.&lt;/P&gt;&lt;P&gt;The analysis covers 53,820 transactions with a total transaction value of approximately IDR 1.32 billion. Key findings include SHOP001 contributing nearly 49% of total transaction value and high-value transactions contributing a substantial share despite their smaller volume.&lt;/P&gt;&lt;P&gt;Tools: Power BI and Google Colab (Python)&lt;BR /&gt;Skills: Data modeling, DAX, KPI development, interactive visualization, RFM analysis, K-Means clustering, and insight communication.&lt;/P&gt;&lt;P&gt;Dataset: &lt;A href="https://data.mendeley.com/datasets/kcgf45y24m/2" target="_blank"&gt;https://data.mendeley.com/datasets/kcgf45y24m/2&lt;/A&gt;&lt;/P&gt;&lt;P&gt;Feedback on the dashboard’s design, analysis, and usability is welcome.&lt;/P&gt;</description>
      <pubDate>Sat, 03 Oct 2026 13:20:00 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/F-B-Sales-Performance-Dashboard/m-p/5371902#M16559</guid>
      <dc:creator>talentaps</dc:creator>
      <dc:date>2026-10-03T13:20:00Z</dc:date>
    </item>
    <item>
      <title>Telecom Customer Churn Dashboard | DataFlip</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Telecom-Customer-Churn-Dashboard-DataFlip/m-p/5371636#M16555</link>
      <description>&lt;P&gt;Customer churn can quickly turn into lost revenue when teams cannot see which customers are leaving or why. This Telecom Customer Churn Dashboard brings customer, contract, service, and revenue data together to identify churn drivers, high-risk segments, and retention opportunities.&lt;/P&gt;&lt;H2&gt;&lt;STRONG&gt;Business Impact&lt;/STRONG&gt;&lt;/H2&gt;&lt;UL&gt;&lt;LI&gt;Identify high-churn customer segments and key churn drivers&lt;/LI&gt;&lt;LI&gt;Track revenue lost from customer churn and customer value&lt;/LI&gt;&lt;LI&gt;Compare churn across contract types, tenure, offers, and services&lt;/LI&gt;&lt;LI&gt;Identify high-risk customers using key customer dimensions&lt;/LI&gt;&lt;LI&gt;Understand how service adoption relates to customer churn&lt;/LI&gt;&lt;LI&gt;Find retention and revenue recovery opportunities&lt;/LI&gt;&lt;LI&gt;Monitor customer, churn, and financial KPIs in one executive-ready view&lt;/LI&gt;&lt;LI&gt;Support more focused customer retention strategies&lt;/LI&gt;&lt;/UL&gt;&lt;H2&gt;&lt;STRONG&gt;Who Can Use This Template&lt;/STRONG&gt;&lt;/H2&gt;&lt;UL&gt;&lt;LI&gt;Telecom &amp;amp; Communications Companies&lt;/LI&gt;&lt;LI&gt;Customer Retention Teams&lt;/LI&gt;&lt;LI&gt;Customer Success Teams&lt;/LI&gt;&lt;LI&gt;CRM &amp;amp; Loyalty Teams&lt;/LI&gt;&lt;LI&gt;Marketing Teams&lt;/LI&gt;&lt;LI&gt;Sales &amp;amp; Account Management&lt;/LI&gt;&lt;LI&gt;Revenue &amp;amp; Commercial Teams&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;STRONG&gt;Discover more insight-driven templates built for real business decisions. Visit &lt;A href="http://www.dataflip.co/" target="_blank"&gt;DataFlip&lt;/A&gt;&lt;/STRONG&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 01 Oct 2026 12:23:50 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Telecom-Customer-Churn-Dashboard-DataFlip/m-p/5371636#M16555</guid>
      <dc:creator>dataflip</dc:creator>
      <dc:date>2026-10-01T12:23:50Z</dc:date>
    </item>
    <item>
      <title>E-COMMERCE SALES REPORT</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/E-COMMERCE-SALES-REPORT/m-p/5371463#M16554</link>
      <description>&lt;P&gt;Hii i am Yash Garg. This is my first Power BI report published to the community. This report is related to an e-commerce sales report&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 02 Oct 2026 16:02:16 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/E-COMMERCE-SALES-REPORT/m-p/5371463#M16554</guid>
      <dc:creator>yash426</dc:creator>
      <dc:date>2026-10-02T16:02:16Z</dc:date>
    </item>
    <item>
      <title>Canada's Hiring Pressure Monitor: where hiring is getting harder, and where talent is overlooked</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Canada-s-Hiring-Pressure-Monitor-where-hiring-is-getting-harder/m-p/5371269#M16552</link>
      <description>&lt;P&gt;Is hiring getting harder in Canada, and for whom? This report answers that in five steps, using public Statistics Canada data for July 2026.&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;&lt;STRONG&gt;Market direction:&lt;/STRONG&gt; unemployed people per job vacancy fell from 3.1 to 2.9 over the year.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Provincial pressure:&lt;/STRONG&gt; Alberta and Manitoba had the highest job vacancy rate, at 3.3%.&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Industry and pay:&lt;/STRONG&gt; health care and social assistance added the most payroll jobs (+82,455).&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Occupation demand:&lt;/STRONG&gt; which jobs employers are trying to fill (quarterly).&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Untapped talent:&lt;/STRONG&gt; which groups have lower employment or participation (annual).&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Every page starts with a question and a finding that updates with your filters. Hovering over any measure explains it, and each page has a colour key. Methodology and sources are on the last page.&lt;/P&gt;&lt;P&gt;The data is prepared and checked in Python against the original Statistics Canada files before it reaches Power BI.&lt;/P&gt;&lt;P&gt;Built by Pol Smirnov, talent intelligence analyst, Toronto. The live site also has an AI guide: &lt;A href="https://polsmirnov.com" target="_blank"&gt;https://polsmirnov.com&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 01 Oct 2026 00:10:37 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Canada-s-Hiring-Pressure-Monitor-where-hiring-is-getting-harder/m-p/5371269#M16552</guid>
      <dc:creator>polsmirnov</dc:creator>
      <dc:date>2026-10-01T00:10:37Z</dc:date>
    </item>
    <item>
      <title>U.S. Airsoft Market Analysis</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/U-S-Airsoft-Market-Analysis/m-p/5370604#M16551</link>
      <description>&lt;P&gt;📊 &lt;STRONG&gt;From almost no structured data to a complete Power BI market analysis&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I was approached by people who are considering launching an airsoft business and asked to analyze the &lt;STRONG&gt;U.S. airsoft market&lt;/STRONG&gt;, with a particular focus on &lt;STRONG&gt;Washington State&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;And the biggest challenge became obvious almost immediately:&lt;/P&gt;&lt;P&gt;🔎 &lt;STRONG&gt;There was very little structured market data available.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;For the first time, I had to use &lt;STRONG&gt;Python not only for analysis, but also for data collection&lt;/STRONG&gt;. I gathered information from Google, Facebook, company websites, and other online sources, using APIs where available.&lt;/P&gt;&lt;P&gt;🧩 &lt;STRONG&gt;Collecting the data was only the beginning.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;This turned out to be one of the most challenging parts of the project. I am not a web-scraping specialist, and the raw data was far from analysis-ready. Business names were inconsistent, categories overlapped, information was missing or outdated, and the same companies could appear differently across multiple sources.&lt;/P&gt;&lt;P&gt;Honestly, this part exhausted me. 😅&lt;/P&gt;&lt;P&gt;I started building the Power BI report several times, only to discover another issue in the underlying data and go back to cleaning and validating it again.&lt;/P&gt;&lt;P&gt;Eventually, I was able to build a dataset that was consistent enough for analysis.&lt;/P&gt;&lt;P&gt;⚙️ &lt;STRONG&gt;The overall pipeline looked like this:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Data Collection → Data Cleaning → Business Verification → Data Enrichment → Pricing &amp;amp; Services Analysis → Customer Review Analysis → Power BI Data Model → Interactive Dashboard → Business Scenario&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;🇺🇸 &lt;STRONG&gt;U.S. Market&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The final dataset included &lt;STRONG&gt;851 U.S. businesses&lt;/STRONG&gt;, from which I identified &lt;STRONG&gt;194 confirmed airsoft operators&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;I then focused on Washington State, where I verified &lt;STRONG&gt;10 active game operators&lt;/STRONG&gt; and analyzed their locations, pricing, services, ratings, and customer feedback.&lt;/P&gt;&lt;P&gt;📍 &lt;STRONG&gt;Washington Market&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The analysis showed:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;10&lt;/STRONG&gt; verified game operators&lt;BR /&gt;• &lt;STRONG&gt;$22.50&lt;/STRONG&gt; median published open-play price&lt;BR /&gt;• &lt;STRONG&gt;4.8&lt;/STRONG&gt; average Google rating&lt;BR /&gt;• &lt;STRONG&gt;1,096&lt;/STRONG&gt; Google reviews across the verified operators&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;💬 &lt;STRONG&gt;Customer Voice&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;I also analyzed customer review text to understand not just &lt;STRONG&gt;how businesses were rated, but what customers were actually talking about&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;The analysis highlighted recurring issues around &lt;STRONG&gt;operations &amp;amp; communication, price &amp;amp; value, rental equipment, and consistency in safety &amp;amp; rule enforcement.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;📈 &lt;STRONG&gt;From analysis to a business scenario&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;Finally, I brought everything together in &lt;STRONG&gt;Power BI&lt;/STRONG&gt; and built an interactive business scenario where assumptions such as &lt;STRONG&gt;daily attendance, operating days, admission price, rental usage, and private bookings&lt;/STRONG&gt; can be changed to explore their impact on estimated monthly revenue.&lt;/P&gt;&lt;P&gt;💡 &lt;STRONG&gt;What this project became&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;For me, this project became much more than a Power BI dashboard.&lt;/P&gt;&lt;P&gt;It was an end-to-end data project:&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;finding the data → building the dataset → validating it → analyzing it → turning it into something that could support a real business discussion.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;And, perhaps most importantly, it taught me how much work can happen &lt;STRONG&gt;before the first chart ever appears on a dashboard.&lt;/STRONG&gt; 😅&lt;/P&gt;&lt;P&gt;#PowerBI #DataAnalytics #Python #DataVisualization #BusinessIntelligence #MarketResearch #DataAnalysis #PortfolioProject&lt;/P&gt;</description>
      <pubDate>Sat, 24 Oct 2026 02:36:27 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/U-S-Airsoft-Market-Analysis/m-p/5370604#M16551</guid>
      <dc:creator>CyberKalachik</dc:creator>
      <dc:date>2026-10-24T02:36:27Z</dc:date>
    </item>
  </channel>
</rss>

