<?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 Alexsandro dos Santos on Medium]]></title>
        <description><![CDATA[Stories by Alexsandro dos Santos on Medium]]></description>
        <link>https://medium.com/@alexsandro.dev?source=rss-7813ecb7d3d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*T_60iScAum-PgRYj6r31kQ.jpeg</url>
            <title>Stories by Alexsandro dos Santos on Medium</title>
            <link>https://medium.com/@alexsandro.dev?source=rss-7813ecb7d3d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sun, 22 Nov 2026 19:00:40 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@alexsandro.dev/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 Town Computers to the Dashboard: How We Generate Data Intelligence for Our Partner…]]></title>
            <link>https://medium.com/impulsogov-tech-product-blog/from-town-computers-to-the-dashboard-how-we-generate-data-intelligence-for-our-partner-d44745a8c948?source=rss-7813ecb7d3d------2</link>
            <guid isPermaLink="false">https://medium.com/p/d44745a8c948</guid>
            <category><![CDATA[public-health]]></category>
            <category><![CDATA[data-engineering]]></category>
            <dc:creator><![CDATA[Alexsandro dos Santos]]></dc:creator>
            <pubDate>Mon, 02 Dec 2024 12:22:24 GMT</pubDate>
            <atom:updated>2024-12-02T13:39:34.809Z</atom:updated>
            <content:encoded><![CDATA[<h3>From Town Computers to the Dashboard: How We Generate Data Intelligence for Our Partner Municipalities</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XxiJKjQwnvtpgUnqYY47uw.png" /><figcaption>Impulso Previne&#39;s Nominal List</figcaption></figure><p>Impulso Previne transforms raw data into valuable tools for primary healthcare in Brazil. But how do we achieve this? <strong>How does a mass of numbers and tables become actionable intelligence for our municipalities?</strong> In this text, I’ll take you behind the scenes of this process — let’s dive in!</p><p>Impulso Previne was created to address a critical need: helping frontline healthcare professionals — such as nurses and community health agents — prioritize their actions, improve care, and achieve key public health goals.</p><p>Working with these indicators is essential to guide efforts toward a healthier population.</p><p><strong>Among our key deliverables are the Nominal Lists</strong>: a feature that shows healthcare professionals which citizens have pending appointments or exams related to seven health indicators. This approach facilitates planning and action for professionals, ensuring more effective results for municipalities.</p><h3>Refining the Nominal List</h3><p>Nominal lists are essentially tables where each row represents the denominator of an indicator, outlining the criteria that need to be met for that row to appear in the numerator. For instance, an indicator might be as simple as listing all pregnant women in the municipality versus those up-to-date with exams. However, complexity grows when we want to include all prenatal visits, syphilis and HIV tests, and other relevant factors for professionals to monitor in an integrated way. To calculate this indicator, <strong>we rely on a team of public health specialists at ImpulsoGov who work alongside data engineers and analysts to collaboratively build these business rules.</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/331/1*S8b1bgvnUrfcKt-X_ebgQw.png" /><figcaption>Three different type of professionals are the core to a good Nominal List and understand of the metrics</figcaption></figure><p>At this stage, we also involve a third agent: SUS itself. Often, during the development of a nominal list, questions arise about the text or interpretation of technical notes. To resolve these, we submit requests through the Access to Information Law (LAI), ensuring greater accuracy and compliance in understanding the rules.</p><p>After several iterations and improvements in the indicator calculation’s confidence and the nominal list’s structure, it’s time to operationalize. For this, <strong>we rely on data ingestion and transformation steps developed by our data engineers.</strong></p><h3>From Municipality to the Data Lake</h3><p>At ImpulsoGov, we’ve built an independent application called “Transmissor.” This transmitter is installed on the computers of partner municipalities and sends locally generated information, such as exams, vaccinations, or any other relevant events for the previous calculation steps, to ImpulsoGov’s cloud daily. This step requires special attention, as we not only adhere to the LGPD (Brazilian General Data Protection Law) but also prioritize the security of data transmission and storage.</p><p>This integration is only possible thanks to the PEC E-SUS, an application used to nationally integrate data generated by all primary healthcare units in the municipality. It gathers information such as administered vaccines, performed procedures, and home visits, ensuring all these records are centralized in one place. This centralization, enabled by PEC, is crucial for ImpulsoGov to transform fragmented data into actionable intelligence — something that would be impractical if each professional stored data separately.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1XXMUxyTwWy9bzo_quqYLA.jpeg" /></figure><p>With data centralized in PEC, our transmitter captures relevant information and forwards it to our cloud-based data platform. There, it undergoes a <strong>three-step process</strong>: first, the data is stored in the “<strong>bronze layer</strong>,” where we receive raw information; next, it moves to the “<strong>silver layer</strong>,” where we evaluate and organize the essential data to ensure its quality; finally, it reaches the “<strong>gold layer</strong>,” where the data is ready to be used by internal or external applications we offer.</p><p>In summary:</p><p><em>Bronze Layer:</em></p><ul><li>Receives PEC E-SUS data from municipalities.</li></ul><p><em>Silver Layer:</em></p><ul><li>Cleans and enriches data.</li><li>Organizes important data.</li></ul><p><em>Gold Layer:</em></p><ul><li>Data already aggregated into indicators.</li><li>Ready-to-use nominal lists.</li></ul><p>These processed data are used by different ImpulsoGov teams to monitor municipalities’ performance, such as data analysts, impact assessment specialists, and public health specialists. However, there’s still one more step: delivering this information directly to municipal healthcare professionals, where it creates the most value. And that’s what we’ll talk about in the next section.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/542/1*o_rTTl9HJHcTr1TvIBVoMA.jpeg" /><figcaption>Impulso Previne simplified Data Lake structure</figcaption></figure><h3>From the Data Lake to the Dashboard</h3><p>We understand that healthcare professionals’ attention is valuable. Every minute spent trying to understand a tool could mean less time dedicated to citizen care. That’s why our nominal lists must be <strong>intuitive, useful, and comprehensive</strong>.</p><p>During the earlier stages of list construction, the focus is on bringing columns related to indicator calculations. However, this information alone is often insufficient. Only frontline healthcare professionals truly understand the importance of, for example, sorting a nominal list of hypertensive patients by age to prioritize care or including a column indicating the last time a citizen was attended to and by whom. To meet these demands, our tables go through an enrichment phase, incorporating contributions not only from end users but also from the product team and feedback from ImpulsoGov designers.</p><p>At the end of all these stages, we have prepared tables delivered to the frontline professionals, but the work doesn’t stop there. We continue to receive constant feedback to address possible flaws in data transformations. Health data is complex, and specific cases can sometimes go unnoticed. Our ongoing effort is to identify new information that may be relevant to users’ daily activities, striking a balance between providing valuable data and avoiding overloading the interface with unnecessary information.</p><p>Thus, our dashboards do more than inform — they transform how healthcare professionals act, optimizing processes and improving outcomes. In this way, we remain committed to continuously improving our solutions, always focusing on positive impacts for public health.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d44745a8c948" width="1" height="1" alt=""><hr><p><a href="https://medium.com/impulsogov-tech-product-blog/from-town-computers-to-the-dashboard-how-we-generate-data-intelligence-for-our-partner-d44745a8c948">From Town Computers to the Dashboard: How We Generate Data Intelligence for Our Partner…</a> was originally published in <a href="https://medium.com/impulsogov-tech-product-blog">ImpulsoGov Tech &amp; Product Blog</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>