{"id":7696,"date":"2026-01-16T18:54:22","date_gmt":"2026-01-16T21:54:22","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=7696"},"modified":"2026-01-16T19:26:44","modified_gmt":"2026-01-16T22:26:44","slug":"curso-do-zero-ao-dashboard-manutencao-no-power-bi","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/cursos\/curso-do-zero-ao-dashboard-manutencao-no-power-bi\/","title":{"rendered":"Curso do Zero ao Dashboard &#8211; Manuten\u00e7\u00e3o no Power BI"},"content":{"rendered":"<h2>Criando Dashboards Profissionais no Power BI: Manuten\u00e7\u00e3o<\/h2>\n<p>&nbsp;<\/p>\n<p>Quer aprender a criar dashboards profissionais no Power BI de forma r\u00e1pida e objetiva? O curso <strong>Criando Dashboards Profissionais no Power BI: Manuten\u00e7\u00e3o<\/strong>. \u00e9 a solu\u00e7\u00e3o perfeita para voc\u00ea! Desenvolvido para quem deseja se tornar um expert em visualiza\u00e7\u00e3o de dados e dashboards, este curso \u00e9 focado em ensinar tudo o que voc\u00ea precisa saber para criar dashboards controle de manuten\u00e7\u00e3o impressionantes no Power BI, de maneira pr\u00e1tica e direta.<\/p>\n<h3>O que voc\u00ea vai aprender?<\/h3>\n<p>O curso \u00e9 dividido em quinze partes, cada um projetado para fornecer conhecimento e habilidades essenciais para criar o projeto no Power BI. Veja o que voc\u00ea aprender\u00e1 em cada m\u00f3dulo:<\/p>\n<h3 data-start=\"265\" data-end=\"324\">Parte 1 &#8211; Conhecendo a base de dados &#8211; manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"325\" data-end=\"522\">\n<li data-start=\"325\" data-end=\"384\">\n<p data-start=\"327\" data-end=\"384\">Apresenta\u00e7\u00e3o da base de dados do projeto de manuten\u00e7\u00e3o.<\/p>\n<\/li>\n<li data-start=\"385\" data-end=\"471\">\n<p data-start=\"387\" data-end=\"471\">Entendimento das colunas principais (equipamentos, OS, datas, categorias e horas).<\/p>\n<\/li>\n<li data-start=\"472\" data-end=\"522\">\n<p data-start=\"474\" data-end=\"522\">Vis\u00e3o geral do que ser\u00e1 constru\u00eddo no dashboard.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"524\" data-end=\"587\">Parte 2 &#8211; Fazendo o tratamento dos dados &#8211; manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"588\" data-end=\"754\">\n<li data-start=\"588\" data-end=\"643\">\n<p data-start=\"590\" data-end=\"643\">Tratamento e padroniza\u00e7\u00e3o dos dados no Power Query<\/p>\n<\/li>\n<li data-start=\"644\" data-end=\"696\">\n<p data-start=\"646\" data-end=\"696\">Ajuste de tipos de dados (data, texto, n\u00fameros).<\/p>\n<\/li>\n<li data-start=\"697\" data-end=\"754\">\n<p data-start=\"699\" data-end=\"754\">Prepara\u00e7\u00e3o da base para modelagem e cria\u00e7\u00e3o de medidas.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"756\" data-end=\"822\">Parte 3 &#8211; Configurando a Tabela Dcalendario &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"823\" data-end=\"988\">\n<li data-start=\"823\" data-end=\"883\">\n<p data-start=\"825\" data-end=\"883\">Cria\u00e7\u00e3o\/configura\u00e7\u00e3o da tabela calend\u00e1rio (Dcalendario).<\/p>\n<\/li>\n<li data-start=\"884\" data-end=\"936\">\n<p data-start=\"886\" data-end=\"936\">Colunas de tempo (ano, m\u00eas, trimestre, m\u00eas\/ano).<\/p>\n<\/li>\n<li data-start=\"937\" data-end=\"988\">\n<p data-start=\"939\" data-end=\"988\">Relacionamento com a tabela principal do projeto.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"990\" data-end=\"1037\">Parte 4 &#8211; Medidas de Qtd &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"1038\" data-end=\"1226\">\n<li data-start=\"1038\" data-end=\"1123\">\n<p data-start=\"1040\" data-end=\"1123\">Cria\u00e7\u00e3o de medidas de quantidade (ex.: total de OS, total de eventos, contagens).<\/p>\n<\/li>\n<li data-start=\"1124\" data-end=\"1177\">\n<p data-start=\"1126\" data-end=\"1177\">Medidas para alimentar cards e visuais de resumo.<\/p>\n<\/li>\n<li data-start=\"1178\" data-end=\"1226\">\n<p data-start=\"1180\" data-end=\"1226\">Ajustes para funcionar com filtros e per\u00edodos.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1228\" data-end=\"1293\">Parte 5 &#8211; Ajustando medida de Equipamentos &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"1294\" data-end=\"1483\">\n<li data-start=\"1294\" data-end=\"1349\">\n<p data-start=\"1296\" data-end=\"1349\">Estrutura\u00e7\u00e3o da l\u00f3gica de contagem de equipamentos.<\/p>\n<\/li>\n<li data-start=\"1350\" data-end=\"1430\">\n<p data-start=\"1352\" data-end=\"1430\">Ajuste para considerar regras de \u201cequipamentos ativos\u201d e contexto de filtro.<\/p>\n<\/li>\n<li data-start=\"1431\" data-end=\"1483\">\n<p data-start=\"1433\" data-end=\"1483\">Garantia de consist\u00eancia nas an\u00e1lises por per\u00edodo.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1485\" data-end=\"1537\">Parte 6 &#8211; Medidas Indicadores &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"1538\" data-end=\"1740\">\n<li data-start=\"1538\" data-end=\"1608\">\n<p data-start=\"1540\" data-end=\"1608\">Cria\u00e7\u00e3o das principais medidas de indicadores de manuten\u00e7\u00e3o (DAX).<\/p>\n<\/li>\n<li data-start=\"1609\" data-end=\"1681\">\n<p data-start=\"1611\" data-end=\"1681\">Prepara\u00e7\u00e3o dos indicadores para uso em cards, gr\u00e1ficos e relat\u00f3rios.<\/p>\n<\/li>\n<li data-start=\"1682\" data-end=\"1740\">\n<p data-start=\"1684\" data-end=\"1740\">Padroniza\u00e7\u00e3o de medidas para leitura clara no dashboard.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1742\" data-end=\"1809\">Parte 7 &#8211; Colocando Fundo e Cards Superiores &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"1810\" data-end=\"1965\">\n<li data-start=\"1810\" data-end=\"1863\">\n<p data-start=\"1812\" data-end=\"1863\">Inser\u00e7\u00e3o do plano de fundo e layout do dashboard.<\/p>\n<\/li>\n<li data-start=\"1864\" data-end=\"1904\">\n<p data-start=\"1866\" data-end=\"1904\">Cria\u00e7\u00e3o dos cards superiores (KPIs).<\/p>\n<\/li>\n<li data-start=\"1905\" data-end=\"1965\">\n<p data-start=\"1907\" data-end=\"1965\">Ajuste visual (alinhamento, t\u00edtulos, cores e organiza\u00e7\u00e3o).<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1967\" data-end=\"2027\">Parte 8 &#8211; Gr\u00e1ficos de Valores por m\u00eas &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"2028\" data-end=\"2161\">\n<li data-start=\"2028\" data-end=\"2081\">\n<p data-start=\"2030\" data-end=\"2081\">Cria\u00e7\u00e3o dos gr\u00e1ficos mensais (tend\u00eancia por m\u00eas).<\/p>\n<\/li>\n<li data-start=\"2082\" data-end=\"2124\">\n<p data-start=\"2084\" data-end=\"2124\">An\u00e1lise de evolu\u00e7\u00e3o ao longo do tempo.<\/p>\n<\/li>\n<li data-start=\"2125\" data-end=\"2161\">\n<p data-start=\"2127\" data-end=\"2161\">Ajustes para leitura e compara\u00e7\u00e3o.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2163\" data-end=\"2230\">Parte 9 &#8211; Colocando bot\u00f5es no gr\u00e1fico de m\u00eas &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"2231\" data-end=\"2392\">\n<li data-start=\"2231\" data-end=\"2287\">\n<p data-start=\"2233\" data-end=\"2287\">Inser\u00e7\u00e3o de bot\u00f5es para intera\u00e7\u00e3o no gr\u00e1fico mensal.<\/p>\n<\/li>\n<li data-start=\"2288\" data-end=\"2342\">\n<p data-start=\"2290\" data-end=\"2342\">Altern\u00e2ncia de visuais\/medidas (quando aplic\u00e1vel).<\/p>\n<\/li>\n<li data-start=\"2343\" data-end=\"2392\">\n<p data-start=\"2345\" data-end=\"2392\">Melhoria da experi\u00eancia de navega\u00e7\u00e3o e an\u00e1lise.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2394\" data-end=\"2462\">Parte 10 &#8211; Criando gr\u00e1ficos de Rosca e Barras &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"2463\" data-end=\"2634\">\n<li data-start=\"2463\" data-end=\"2535\">\n<p data-start=\"2465\" data-end=\"2535\">Cria\u00e7\u00e3o de gr\u00e1ficos de rosca (distribui\u00e7\u00e3o) e barras (comparativos).<\/p>\n<\/li>\n<li data-start=\"2536\" data-end=\"2595\">\n<p data-start=\"2538\" data-end=\"2595\">An\u00e1lises por categoria, equipamento, tipo, status, etc.<\/p>\n<\/li>\n<li data-start=\"2596\" data-end=\"2634\">\n<p data-start=\"2598\" data-end=\"2634\">Formata\u00e7\u00e3o profissional dos visuais.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2636\" data-end=\"2690\">Parte 11 &#8211; Criando Matriz de OS &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"2691\" data-end=\"2874\">\n<li data-start=\"2691\" data-end=\"2756\">\n<p data-start=\"2693\" data-end=\"2756\">Constru\u00e7\u00e3o de uma matriz detalhada de Ordens de Servi\u00e7o (OS).<\/p>\n<\/li>\n<li data-start=\"2757\" data-end=\"2826\">\n<p data-start=\"2759\" data-end=\"2826\">Exibi\u00e7\u00e3o de informa\u00e7\u00f5es por filtros (per\u00edodo, equipamento, tipo).<\/p>\n<\/li>\n<li data-start=\"2827\" data-end=\"2874\">\n<p data-start=\"2829\" data-end=\"2874\">Estrutura para an\u00e1lise detalhada e auditoria.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2876\" data-end=\"2938\">Parte 12 &#8211; Colocando Filtros no Projeto &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"2939\" data-end=\"3113\">\n<li data-start=\"2939\" data-end=\"2987\">\n<p data-start=\"2941\" data-end=\"2987\">Inser\u00e7\u00e3o de segmentadores\/filtros din\u00e2micos.<\/p>\n<\/li>\n<li data-start=\"2988\" data-end=\"3053\">\n<p data-start=\"2990\" data-end=\"3053\">Filtros por per\u00edodo, equipamento, categoria, status e outros.<\/p>\n<\/li>\n<li data-start=\"3054\" data-end=\"3113\">\n<p data-start=\"3056\" data-end=\"3113\">Organiza\u00e7\u00e3o para facilitar a an\u00e1lise e tomada de decis\u00e3o.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"3115\" data-end=\"3185\">Parte 13 &#8211; Ajustando as medidas dos indicadores &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"3186\" data-end=\"3349\">\n<li data-start=\"3186\" data-end=\"3246\">\n<p data-start=\"3188\" data-end=\"3246\">Revis\u00e3o e ajustes finos nas medidas DAX dos indicadores.<\/p>\n<\/li>\n<li data-start=\"3247\" data-end=\"3297\">\n<p data-start=\"3249\" data-end=\"3297\">Corre\u00e7\u00f5es de contexto, filtros e totaliza\u00e7\u00f5es.<\/p>\n<\/li>\n<li data-start=\"3298\" data-end=\"3349\">\n<p data-start=\"3300\" data-end=\"3349\">Garantia de consist\u00eancia entre p\u00e1ginas e visuais.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"3351\" data-end=\"3405\">Parte 14 &#8211; Montando Dashboard 2 &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"3406\" data-end=\"3566\">\n<li data-start=\"3406\" data-end=\"3472\">\n<p data-start=\"3408\" data-end=\"3472\">Constru\u00e7\u00e3o da segunda p\u00e1gina do projeto (painel complementar).<\/p>\n<\/li>\n<li data-start=\"3473\" data-end=\"3519\">\n<p data-start=\"3475\" data-end=\"3519\">Visuais adicionais e an\u00e1lises espec\u00edficas.<\/p>\n<\/li>\n<li data-start=\"3520\" data-end=\"3566\">\n<p data-start=\"3522\" data-end=\"3566\">Organiza\u00e7\u00e3o do layout e foco em usabilidade.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"3568\" data-end=\"3654\">Parte 15 &#8211; Montando Dashboard 3 e colocando bot\u00f5es de navega\u00e7\u00e3o &#8211; Manuten\u00e7\u00e3o.<\/h3>\n<ul data-start=\"3655\" data-end=\"3816\">\n<li data-start=\"3655\" data-end=\"3700\">\n<p data-start=\"3657\" data-end=\"3700\">Montagem da terceira p\u00e1gina do dashboard.<\/p>\n<\/li>\n<li data-start=\"3701\" data-end=\"3750\">\n<p data-start=\"3703\" data-end=\"3750\">Cria\u00e7\u00e3o de bot\u00f5es de navega\u00e7\u00e3o entre p\u00e1ginas.<\/p>\n<\/li>\n<li data-start=\"3751\" data-end=\"3816\">\n<p data-start=\"3753\" data-end=\"3816\">Finaliza\u00e7\u00e3o do projeto com experi\u00eancia completa e profissional.<\/p>\n<\/li>\n<\/ul>\n<p><strong>Por que escolher o Dashboard Express em Power BI?<\/strong><\/p>\n<p><strong>&#8211; Objetividade e Foco:<\/strong> Aulas diretas e pr\u00e1ticas, desenvolvidas para que voc\u00ea aprenda em poucas horas.<br \/>\n<strong>&#8211; Praticidade:<\/strong> Acompanhe o curso no seu ritmo, com exemplos pr\u00e1ticos e arquivos dispon\u00edveis para download.<br \/>\n<strong>&#8211; Acesso por 6 Meses:<\/strong> Aproveite o conte\u00fado do curso com acesso ilimitado por 6 meses, revisando e praticando sempre que necess\u00e1rio.<br \/>\n<strong>&#8211; Suporte Completo:<\/strong> Receba suporte dedicado durante o per\u00edodo do curso, garantindo que todas as suas d\u00favidas sejam respondidas.<\/p>\n<p>Transforme suas habilidades de an\u00e1lise de dados e aprenda a criar dashboards poderosos com o<strong> Curso Criando Dashboards Profissionais no Power BI: Manuten\u00e7\u00e3o. <\/strong>Inscreva-se agora e domine o Power BI em apenas algumas horas!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quer aprender a criar dashboards profissionais no Power BI de forma r\u00e1pida e objetiva? O curso <strong>Criando Dashboards Profissionais no Power BI: Manuten\u00e7\u00e3o<\/strong>. \u00e9 a solu\u00e7\u00e3o perfeita para voc\u00ea!<\/p>\n","protected":false},"featured_media":7698,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"product_brand":[],"product_cat":[339,993,176],"product_tag":[2552,2549,188,2546,2548,2543,2050,2545,2544,2550,1797,2045,2540,1835,2542,1742,2046,2047,2553,1942,2541,2042,435,1285,2551,1743,2547],"class_list":{"0":"post-7696","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-cursos","7":"product_cat-manutencao","8":"product_cat-power-bi","9":"product_tag-botoes-power-bi","10":"product_tag-cards-power-bi","11":"product_tag-dashboard-manutencao","12":"product_tag-dax","13":"product_tag-dcalendario","14":"product_tag-disponibilidade","15":"product_tag-downtime","16":"product_tag-equipamentos","17":"product_tag-falhas","18":"product_tag-filtros-power-bi","19":"product_tag-graficos-power-bi","20":"product_tag-indicadores-de-manutencao","21":"product_tag-manutencao","22":"product_tag-manutencao-industrial","23":"product_tag-matriz-de-os","24":"product_tag-medidas-dax","25":"product_tag-mtbf","26":"product_tag-mttr","27":"product_tag-navegacao-power-bi","28":"product_tag-ordem-de-servico","29":"product_tag-os-manutencao","30":"product_tag-pcm","31":"product_tag-power-bi","32":"product_tag-power-query","33":"product_tag-segmentadores","34":"product_tag-tabela-calendario","35":"product_tag-tratamento-de-dados","36":"desktop-align-left","37":"tablet-align-left","38":"mobile-align-left","40":"first","41":"instock","42":"virtual","43":"purchasable","44":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7696","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/comments?post=7696"}],"version-history":[{"count":1,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7696\/revisions"}],"predecessor-version":[{"id":7699,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7696\/revisions\/7699"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/7698"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=7696"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=7696"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=7696"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=7696"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}