<?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 Paulo Henrique Patrício on Medium]]></title>
        <description><![CDATA[Stories by Paulo Henrique Patrício on Medium]]></description>
        <link>https://medium.com/@paulohpatricio?source=rss-fcc86e6c6164------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*DOJZTuZwpYkwlByeApiv8w.jpeg</url>
            <title>Stories by Paulo Henrique Patrício on Medium</title>
            <link>https://medium.com/@paulohpatricio?source=rss-fcc86e6c6164------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 07:57:39 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@paulohpatricio/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[Trilha sonora do Desenvolvimento]]></title>
            <link>https://medium.com/@paulohpatricio/trilha-sonora-do-desenvolvimento-f9c0e3a38a43?source=rss-fcc86e6c6164------2</link>
            <guid isPermaLink="false">https://medium.com/p/f9c0e3a38a43</guid>
            <category><![CDATA[digital]]></category>
            <category><![CDATA[software-development]]></category>
            <category><![CDATA[deep-house]]></category>
            <category><![CDATA[music]]></category>
            <category><![CDATA[podcast]]></category>
            <dc:creator><![CDATA[Paulo Henrique Patrício]]></dc:creator>
            <pubDate>Tue, 06 Dec 2016 18:41:21 GMT</pubDate>
            <atom:updated>2019-04-15T15:27:34.702Z</atom:updated>
            <content:encoded><![CDATA[<p>Bom aqui está algumas músicas e estilos que estimulam na hora de desenvolver aquele script cabuloso.</p><p>Geralmente são músicas mais calmas com criatividade sonora que estimulam o cérebro a pensar.</p><p>Vamos lá:</p><p>10) Cubicolor — Down the wall</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2F-fMT9RD4yOY%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-fMT9RD4yOY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F-fMT9RD4yOY%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/2927b8a603aa6c5bbc2312f0ab91eb11/href">https://medium.com/media/2927b8a603aa6c5bbc2312f0ab91eb11/href</a></iframe><p>9) Boom Jinx &amp; Andrew Bayer — To The Six (Club Mix)</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fa84lAPrmTd4%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Da84lAPrmTd4&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fa84lAPrmTd4%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/161c804191eb92a2ded5ade5cba0000d/href">https://medium.com/media/161c804191eb92a2ded5ade5cba0000d/href</a></iframe><p>8) Myon &amp; Shane 54 — Lights (feat. Aruna) (5vel Remix)</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FCkyMqGALMoY%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DCkyMqGALMoY&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FCkyMqGALMoY%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/5c6034f16005edc260d0514989fe04f9/href">https://medium.com/media/5c6034f16005edc260d0514989fe04f9/href</a></iframe><p>7) Chris Malinchak — So Good To Me (Official Video)</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FKrMl32cuC2A%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DKrMl32cuC2A&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FKrMl32cuC2A%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/a53697fb38b60a11f344cc0247a959bf/href">https://medium.com/media/a53697fb38b60a11f344cc0247a959bf/href</a></iframe><p>6) Lane 8 feat. Matthew Dear — Undercover (Yotto Remix)</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FYIKKLcIBrEQ%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DYIKKLcIBrEQ&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FYIKKLcIBrEQ%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/92b978d90ed01dbd3164388c057747ff/href">https://medium.com/media/92b978d90ed01dbd3164388c057747ff/href</a></iframe><p>5) Luttrell — Need You</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FKXOR9zCJNcs%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DKXOR9zCJNcs&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FKXOR9zCJNcs%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/21090d1264cb59c687e7b7bc32d32256/href">https://medium.com/media/21090d1264cb59c687e7b7bc32d32256/href</a></iframe><p>4) RÜFÜS — Innerbloom</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FIA1liCmUsAM%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DIA1liCmUsAM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FIA1liCmUsAM%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/832024e7c190291ae59e010dda15f18f/href">https://medium.com/media/832024e7c190291ae59e010dda15f18f/href</a></iframe><p>3) Matt Lange feat. Tania Zygar — Way You Know</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FIwS6SDTOiRM%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DIwS6SDTOiRM&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FIwS6SDTOiRM%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/69a3def7d7b3a449cf6568996d2a9122/href">https://medium.com/media/69a3def7d7b3a449cf6568996d2a9122/href</a></iframe><p>2) Lane 8 — Every Night</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Ffo9oCklYqIE%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dfo9oCklYqIE&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Ffo9oCklYqIE%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/46e4abb8f4b48d18017b5d86277264ad/href">https://medium.com/media/46e4abb8f4b48d18017b5d86277264ad/href</a></iframe><p>1) 16 Bit Lolitas — Nobody Seems To Care</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FWWiC6rgljL0%3Ffeature%3Doembed&amp;url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DWWiC6rgljL0&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWWiC6rgljL0%2Fhqdefault.jpg&amp;key=d04bfffea46d4aeda930ec88cc64b87c&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/975d6edc333ade23ffd151bdff7c34a5/href">https://medium.com/media/975d6edc333ade23ffd151bdff7c34a5/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f9c0e3a38a43" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Script Valor Acumulativo Mensal qliksense]]></title>
            <link>https://medium.com/@paulohpatricio/script-valor-acumulativo-mensal-qliksense-1b11751ef13d?source=rss-fcc86e6c6164------2</link>
            <guid isPermaLink="false">https://medium.com/p/1b11751ef13d</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[busines-intelligence]]></category>
            <category><![CDATA[qlik]]></category>
            <category><![CDATA[life]]></category>
            <category><![CDATA[digital]]></category>
            <dc:creator><![CDATA[Paulo Henrique Patrício]]></dc:creator>
            <pubDate>Thu, 24 Nov 2016 18:58:24 GMT</pubDate>
            <atom:updated>2016-11-24T19:07:28.050Z</atom:updated>
            <content:encoded><![CDATA[<p>Bom, aproveitando que está acabando o ano.<br>Um conceito bastante usado pelas empresas que é acumular um valor, seja de qualquer natureza, mensalmente.</p><p>Resolvi criar essa tese usando a linguagem script da ferramenta de BI Qliksense, pretendo fazer a mesma tese, porém usando a linguagem sql.</p><p>Criamos a estrutura de dados fictício:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/852/1*WzPt0Tcb6pgf1wfwUjBV8w.png" /></figure><p>Agora usamos o seguinte script para acumular os valores:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/586/1*XkS7Fa6auHeEwJFbFE2aTg.png" /></figure><p>Não esqueçam de dropar as tbelas temporárias:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/335/1*9rnkX9tW3xiobmaiWUZ5kw.png" /></figure><p>Abaixo segue o script de boas:</p><blockquote>ContaContabilFato:<br>LOAD * INLINE [<br>Conta, DATA, VALOR<br>1.1.1,’01/01/2016&#39;,15<br>1.1.1,’02/01/2016&#39;,15<br>1.1.1,’03/01/2016&#39;,15</blockquote><blockquote>1.1.2,’01/01/2016&#39;,25<br>1.1.2,’02/01/2016&#39;,15<br>1.1.2,’03/01/2016&#39;,35</blockquote><blockquote>1.1.1,’01/03/2017&#39;,12<br>1.1.1,’02/03/2017&#39;,17<br>1.1.1,’03/02/2017&#39;,12</blockquote><blockquote>1.1.2,’01/02/2017&#39;,40<br>1.1.2,’02/01/2017&#39;,50<br>1.1.2,’03/03/2017&#39;,60</blockquote><blockquote>1.1.1,’01/02/2016&#39;,15<br>1.1.1,’03/02/2016&#39;,20<br>1.1.1,’04/02/2016&#39;,10</blockquote><blockquote>1.1.2,’01/02/2016&#39;,10<br>1.1.2,’02/02/2016&#39;,20<br>1.1.2,’03/02/2016&#39;,30];</blockquote><blockquote>NoConcatenate<br>ContaContabilFatoTemp:<br>LOAD <br>Conta,<br>MonthName(DATA) as mesano,<br>month(DATA) as mes,<br>year(DATA) as ano,<br>sum(VALOR) as VALOR</blockquote><blockquote>Resident ContaContabilFato<br>group by Conta,year(DATA),month(DATA), MonthName(DATA);</blockquote><blockquote>NoConcatenate<br>ContaContabilFatoFinal:</blockquote><blockquote>LOAD<br>Conta,<br>mesano,<br>mes,<br>ano,<br>//autonumber(Conta &amp; mesano,’idlinha’) as idlinha,<br>IF(peek(mes) &lt; mes,rangesum(Peek(svalor),VALOR),VALOR) as svalor,<br>VALOR</blockquote><blockquote>Resident ContaContabilFatoTemp<br> <br>order by Conta, ano, mes;</blockquote><blockquote>drop table ContaContabilFato;<br>drop table ContaContabilFatoTemp;</blockquote><p>Abaixo vejamos o exemplo:</p><p>Forma gráfica agrupando mensalmente</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-THF26HNuuDT1G95kjBUYA.png" /></figure><p>Forma Analítica:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9cHm5s1LkkHEAqoyYB8Fzg.png" /></figure><p>Bom é isso ai pessoal.</p><p>Até a próxima =)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1b11751ef13d" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Prelúdio: Google Data Studio Vs. Microsoft Power BI]]></title>
            <link>https://medium.com/@paulohpatricio/prel%C3%BAdio-google-data-studio-vs-microsoft-power-bi-f38a990116f9?source=rss-fcc86e6c6164------2</link>
            <guid isPermaLink="false">https://medium.com/p/f38a990116f9</guid>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[google-data-studio]]></category>
            <category><![CDATA[big-data]]></category>
            <category><![CDATA[google-analytics]]></category>
            <category><![CDATA[power-bi]]></category>
            <dc:creator><![CDATA[Paulo Henrique Patrício]]></dc:creator>
            <pubDate>Wed, 28 Sep 2016 17:53:43 GMT</pubDate>
            <atom:updated>2016-09-28T19:38:37.947Z</atom:updated>
            <content:encoded><![CDATA[<p>Com a recente chegada do Google Data Studio ao Brasil, Farei um comparativo dele com o Power BI da Microsoft.</p><p>O intuito é comparar as duas ferramentas de BI que na minha opinião são as mais completas com conectividade a Data Sources de BigData na nuvem.</p><p>Lembrando que existem outras ferramentas de BI poderosas, porém elas exigem licenças e não estão na categoria dessas duas mencionadas.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J2ANAElVmCoVRJFH56mIeQ.png" /></figure><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f38a990116f9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Comunicação dos dados em um Dashboard]]></title>
            <link>https://medium.com/@paulohpatricio/comunica%C3%A7%C3%A3o-dos-dados-em-um-dashboard-8f52b3b69836?source=rss-fcc86e6c6164------2</link>
            <guid isPermaLink="false">https://medium.com/p/8f52b3b69836</guid>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[dashboard]]></category>
            <dc:creator><![CDATA[Paulo Henrique Patrício]]></dc:creator>
            <pubDate>Thu, 25 Aug 2016 19:11:05 GMT</pubDate>
            <atom:updated>2016-08-25T19:18:15.217Z</atom:updated>
            <content:encoded><![CDATA[<p>Estive criando um projeto de desenvolvimento de Dashboards de BI para um cliente da empresa onde trabalho.</p><p>Gostaria de compartilhar um conhecimento onde é pouco discutido na minha área.</p><p>A comunicação dos dados e o objetivo das análises apuradas em um Dashboard.</p><p>Para fazer um Dashboard inteligente é necessário algo a mais do que conhecimentos em programação. É necessário desenvolver uma interface onde os objetos se comuniquem para responder questionamentos antes da tal “tomada de decisão”.</p><p>Vejamos o exemplos abaixo:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9PMvtUk1awOkqdUqa4pPOg.png" /><figcaption>Dashboard — Desempenho por Representante</figcaption></figure><p>Como vimos acima, esse gráfico apresenta um cenário comercial por representante.</p><p>Selecionei um filtro por representante para que a explicação fique de forma mais clara.</p><p>Selecionei o Representante Moreira, a informação consolidada que temos dele é que em 2016 ele atingiu os seguintes números consolidados:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/427/1*RzsF--_IxLJIFLb-8uoj7w.png" /><figcaption>KPI consolidado</figcaption></figure><p>e seu desempenho agrupado em meses num gráfico de linhas ele obteve esses resultados:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/450/1*FFN16PVIK8RplFuiPhDLfA.png" /><figcaption>Gráfico de Linhas</figcaption></figure><p>Muitos perguntam: Paulo, ok. Mas o que isso representa de fato? Afinal esse além desses números, existe outra forma de avaliar o desempenho desse Representante?</p><p>A Resposta é SIM!</p><p>O Gráfico abaixo representa se suas vendas tem sido boas ou não:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/345/1*w0PbjW1gwbDZO3g9z6va7A.png" /></figure><p>O Percentual da Margem representa o quão lucrativo das vendas reprentaram no mês.</p><p>As vezes O Representante tem um volume de vendas alto, porém pode ser que o indicador da Margem esteja baixo. Isso é ruim</p><p>Pode ser que ele vende menos e obtenha uma Margem positiva.</p><p>Esse foi meu primeiro artigo aqui no Medium, espero poder fazer outros.</p><p>Abraços,</p><p>Paulo Henrique Patrício</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8f52b3b69836" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>