{"id":7715,"date":"2026-02-02T23:12:51","date_gmt":"2026-02-03T02:12:51","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=7715"},"modified":"2026-02-02T23:39:09","modified_gmt":"2026-02-03T02:39:09","slug":"curso-do-zero-ao-dashboard-no-power-bi-controle-abastecimento-de-frota","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/cursos\/curso-do-zero-ao-dashboard-no-power-bi-controle-abastecimento-de-frota\/","title":{"rendered":"Curso do zero ao Dashboard no Power BI: Controle Abastecimento de Frota"},"content":{"rendered":"<h2>Curso do zero ao Dashboard no Power BI: Controle Abastecimento de Frota<\/h2>\n<p>&nbsp;<\/p>\n<p>Quer aprender a criar dashboards profissionais no Power BI de forma r\u00e1pida e objetiva? O Curso do zero ao Dashboard no Power BI: Controle Abatecimento de Frota. \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 acidentes 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 quatorze 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=\"78\" data-end=\"124\">Parte 1 &#8211; Entendendo a Base de dados.<\/h3>\n<ul data-start=\"125\" data-end=\"353\">\n<li data-start=\"125\" data-end=\"185\">\n<p data-start=\"127\" data-end=\"185\">Apresenta\u00e7\u00e3o da base de dados de abastecimento de frota.<\/p>\n<\/li>\n<li data-start=\"186\" data-end=\"302\">\n<p data-start=\"188\" data-end=\"302\">Entendimento dos campos principais (data, ve\u00edculo, motorista, combust\u00edvel, litros, valor, km, posto\/fornecedor).<\/p>\n<\/li>\n<li data-start=\"303\" data-end=\"353\">\n<p data-start=\"305\" data-end=\"353\">Vis\u00e3o geral do que ser\u00e1 constru\u00eddo no dashboard.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"355\" data-end=\"407\">Parte 2 &#8211; Tratando os dados no Power Query.<\/h3>\n<ul data-start=\"408\" data-end=\"592\">\n<li data-start=\"408\" data-end=\"460\">\n<p data-start=\"410\" data-end=\"460\">Limpeza e padroniza\u00e7\u00e3o dos dados no Power Query.<\/p>\n<\/li>\n<li data-start=\"461\" data-end=\"534\">\n<p data-start=\"463\" data-end=\"534\">Ajuste de tipos (data, texto, n\u00fameros) e corre\u00e7\u00e3o de inconsist\u00eancias.<\/p>\n<\/li>\n<li data-start=\"535\" data-end=\"592\">\n<p data-start=\"537\" data-end=\"592\">Prepara\u00e7\u00e3o da base para modelagem e cria\u00e7\u00e3o de medidas.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"594\" data-end=\"642\">Parte 3 &#8211; Criando a tabela DCalendario.<\/h3>\n<ul data-start=\"643\" data-end=\"824\">\n<li data-start=\"643\" data-end=\"705\">\n<p data-start=\"645\" data-end=\"705\">Cria\u00e7\u00e3o e configura\u00e7\u00e3o da tabela calend\u00e1rio (DCalendario).<\/p>\n<\/li>\n<li data-start=\"706\" data-end=\"765\">\n<p data-start=\"708\" data-end=\"765\">Colunas de tempo (Ano, M\u00eas, M\u00eas\/Ano, Trimestre e Data).<\/p>\n<\/li>\n<li data-start=\"766\" data-end=\"824\">\n<p data-start=\"768\" data-end=\"824\">Relacionamento com a tabela principal de abastecimentos.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"826\" data-end=\"897\">Parte 4 &#8211; Criando Medidas de Qtd e colocando fundo no projeto.<\/h3>\n<ul data-start=\"898\" data-end=\"1123\">\n<li data-start=\"898\" data-end=\"1014\">\n<p data-start=\"900\" data-end=\"1014\">Cria\u00e7\u00e3o de medidas (DAX) de quantidade e totais (ex.: total de abastecimentos, total de litros, total de valor).<\/p>\n<\/li>\n<li data-start=\"1015\" data-end=\"1064\">\n<p data-start=\"1017\" data-end=\"1064\">Prepara\u00e7\u00e3o das medidas para cards e gr\u00e1ficos.<\/p>\n<\/li>\n<li data-start=\"1065\" data-end=\"1123\">\n<p data-start=\"1067\" data-end=\"1123\">Inser\u00e7\u00e3o do plano de fundo e in\u00edcio do layout do painel.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1125\" data-end=\"1169\">Parte 5 &#8211; Criando cards superiores.<\/h3>\n<ul data-start=\"1170\" data-end=\"1360\">\n<li data-start=\"1170\" data-end=\"1228\">\n<p data-start=\"1172\" data-end=\"1228\">Constru\u00e7\u00e3o da \u00e1rea superior do dashboard (cards\/KPIs).<\/p>\n<\/li>\n<li data-start=\"1229\" data-end=\"1310\">\n<p data-start=\"1231\" data-end=\"1310\">Destaque de indicadores principais (litros, valor total, quantidade, m\u00e9dias).<\/p>\n<\/li>\n<li data-start=\"1311\" data-end=\"1360\">\n<p data-start=\"1313\" data-end=\"1360\">Ajuste de formata\u00e7\u00e3o, t\u00edtulos e leitura r\u00e1pida.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1362\" data-end=\"1417\">Parte 6 &#8211; Criando gr\u00e1ficos por M\u00eas com bot\u00f5es.<\/h3>\n<ul data-start=\"1418\" data-end=\"1621\">\n<li data-start=\"1418\" data-end=\"1492\">\n<p data-start=\"1420\" data-end=\"1492\">Cria\u00e7\u00e3o de gr\u00e1ficos mensais para acompanhar evolu\u00e7\u00e3o do abastecimento.<\/p>\n<\/li>\n<li data-start=\"1493\" data-end=\"1576\">\n<p data-start=\"1495\" data-end=\"1576\">Implementa\u00e7\u00e3o de bot\u00f5es para alternar visualiza\u00e7\u00f5es\/medidas (quando aplic\u00e1vel).<\/p>\n<\/li>\n<li data-start=\"1577\" data-end=\"1621\">\n<p data-start=\"1579\" data-end=\"1621\">Melhoria de intera\u00e7\u00e3o e an\u00e1lise do painel.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1623\" data-end=\"1672\">Parte 7 &#8211; Criando os gr\u00e1ficos &#8211; parte 2.<\/h3>\n<ul data-start=\"1673\" data-end=\"1867\">\n<li data-start=\"1673\" data-end=\"1746\">\n<p data-start=\"1675\" data-end=\"1746\">Expans\u00e3o do conjunto de visuais do projeto (comparativos e rankings).<\/p>\n<\/li>\n<li data-start=\"1747\" data-end=\"1817\">\n<p data-start=\"1749\" data-end=\"1817\">Gr\u00e1ficos por ve\u00edculo, motorista, tipo de combust\u00edvel e fornecedor.<\/p>\n<\/li>\n<li data-start=\"1818\" data-end=\"1867\">\n<p data-start=\"1820\" data-end=\"1867\">Ajustes de formata\u00e7\u00e3o para visual profissional.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"1869\" data-end=\"1929\">Parte 8 &#8211; Colocando Segmenta\u00e7\u00e3o de Dados no painel.<\/h3>\n<ul data-start=\"1930\" data-end=\"2123\">\n<li data-start=\"1930\" data-end=\"1988\">\n<p data-start=\"1932\" data-end=\"1988\">Inser\u00e7\u00e3o de segmentadores\/filtros din\u00e2micos (slicers).<\/p>\n<\/li>\n<li data-start=\"1989\" data-end=\"2063\">\n<p data-start=\"1991\" data-end=\"2063\">Filtros por per\u00edodo, ve\u00edculo, motorista, combust\u00edvel, fornecedor, etc.<\/p>\n<\/li>\n<li data-start=\"2064\" data-end=\"2123\">\n<p data-start=\"2066\" data-end=\"2123\">Organiza\u00e7\u00e3o para facilitar an\u00e1lises r\u00e1pidas e detalhadas.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2125\" data-end=\"2196\">Parte 9 &#8211; Cards Superiores do painel de Abastecimento Interno.<\/h3>\n<ul data-start=\"2197\" data-end=\"2374\">\n<li data-start=\"2197\" data-end=\"2274\">\n<p data-start=\"2199\" data-end=\"2274\">Montagem\/ajuste dos cards espec\u00edficos do painel de abastecimento interno.<\/p>\n<\/li>\n<li data-start=\"2275\" data-end=\"2324\">\n<p data-start=\"2277\" data-end=\"2324\">KPIs para vis\u00e3o executiva do consumo interno.<\/p>\n<\/li>\n<li data-start=\"2325\" data-end=\"2374\">\n<p data-start=\"2327\" data-end=\"2374\">Padroniza\u00e7\u00e3o visual e alinhamento com o layout.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2376\" data-end=\"2431\">Parte 10 &#8211; Dashboard de Abastecimento Interno.<\/h3>\n<ul data-start=\"2432\" data-end=\"2630\">\n<li data-start=\"2432\" data-end=\"2502\">\n<p data-start=\"2434\" data-end=\"2502\">Constru\u00e7\u00e3o de uma p\u00e1gina completa focada no abastecimento interno.<\/p>\n<\/li>\n<li data-start=\"2503\" data-end=\"2582\">\n<p data-start=\"2505\" data-end=\"2582\">Visuais e indicadores para controle interno (consumo, valores, frequ\u00eancia).<\/p>\n<\/li>\n<li data-start=\"2583\" data-end=\"2630\">\n<p data-start=\"2585\" data-end=\"2630\">Organiza\u00e7\u00e3o do painel para tomada de decis\u00e3o.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2632\" data-end=\"2680\">Parte 11 &#8211; Dashboard Compras de Diesel.<\/h3>\n<ul data-start=\"2681\" data-end=\"2854\">\n<li data-start=\"2681\" data-end=\"2740\">\n<p data-start=\"2683\" data-end=\"2740\">Cria\u00e7\u00e3o de um painel espec\u00edfico para compras de diesel.<\/p>\n<\/li>\n<li data-start=\"2741\" data-end=\"2802\">\n<p data-start=\"2743\" data-end=\"2802\">Indicadores de volume, custo e comportamento por per\u00edodo.<\/p>\n<\/li>\n<li data-start=\"2803\" data-end=\"2854\">\n<p data-start=\"2805\" data-end=\"2854\">An\u00e1lises e comparativos para controle de compras.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2856\" data-end=\"2908\">Parte 12 &#8211; Gr\u00e1fico do Preenchimento Diesel.<\/h3>\n<ul data-start=\"2909\" data-end=\"3126\">\n<li data-start=\"2909\" data-end=\"3001\">\n<p data-start=\"2911\" data-end=\"3001\">Constru\u00e7\u00e3o de visual espec\u00edfico para acompanhamento do \u201cpreenchimento\u201d\/volume de diesel.<\/p>\n<\/li>\n<li data-start=\"3002\" data-end=\"3071\">\n<p data-start=\"3004\" data-end=\"3071\">An\u00e1lise da varia\u00e7\u00e3o ao longo do tempo e identifica\u00e7\u00e3o de padr\u00f5es.<\/p>\n<\/li>\n<li data-start=\"3072\" data-end=\"3126\">\n<p data-start=\"3074\" data-end=\"3126\">Ajustes de leitura e destaque dos per\u00edodos cr\u00edticos.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"3128\" data-end=\"3171\">Parte 13 &#8211; Dashboard Compras Arla.<\/h3>\n<ul data-start=\"3172\" data-end=\"3333\">\n<li data-start=\"3172\" data-end=\"3227\">\n<p data-start=\"3174\" data-end=\"3227\">Montagem do painel espec\u00edfico para compras de ARLA.<\/p>\n<\/li>\n<li data-start=\"3228\" data-end=\"3289\">\n<p data-start=\"3230\" data-end=\"3289\">Indicadores de consumo\/compra e comparativos por per\u00edodo.<\/p>\n<\/li>\n<li data-start=\"3290\" data-end=\"3333\">\n<p data-start=\"3292\" data-end=\"3333\">Vis\u00e3o organizada para controle do insumo.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"3335\" data-end=\"3401\">Parte 14 &#8211; Colocando os bot\u00f5es e finalizando o Dashboard.<\/h3>\n<ul data-start=\"3402\" data-end=\"3603\">\n<li data-start=\"3402\" data-end=\"3473\">\n<p data-start=\"3404\" data-end=\"3473\">Inser\u00e7\u00e3o de bot\u00f5es de navega\u00e7\u00e3o entre p\u00e1ginas e atalhos do projeto.<\/p>\n<\/li>\n<li data-start=\"3474\" data-end=\"3529\">\n<p data-start=\"3476\" data-end=\"3529\">Ajustes finais de layout, formata\u00e7\u00e3o e usabilidade.<\/p>\n<\/li>\n<li data-start=\"3530\" data-end=\"3603\">\n<p data-start=\"3532\" data-end=\"3603\">Finaliza\u00e7\u00e3o do dashboard completo, interativo e pronto para apresentar.<\/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><span style=\"font-size: 18pt;\"><span style=\"font-size: 14pt;\"> Curso do zero ao Dashboard no Power BI: Controle Abastecimento de Frota<\/span><\/span>. <\/strong>Inscreva-se agora e domine o Power BI em apenas algumas horas!<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span style=\"font-size: 18pt;\"><strong>Curso do zero ao Dashboard no Power BI: Controle Abastecimento de Frota<\/strong><\/span><\/p>\n","protected":false},"featured_media":7716,"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,989,176],"product_tag":[438,2559,2556,2552,2549,2558,2557,2560,285,2567,2568,2561,2554,566,2546,2548,2555,2563,2550,445,1797,2564,2562,1742,435,1285,2565,2566,1743,2547],"class_list":{"0":"post-7715","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-cursos","7":"product_cat-logistica","8":"product_cat-power-bi","9":"product_tag-abastecimento-de-frota","10":"product_tag-abastecimento-interno","11":"product_tag-arla","12":"product_tag-botoes-power-bi","13":"product_tag-cards-power-bi","14":"product_tag-compras-de-arla","15":"product_tag-compras-de-diesel","16":"product_tag-consumo-de-combustivel","17":"product_tag-controle-de-combustivel","18":"product_tag-curso-em-power-bi","19":"product_tag-curso-gestao-de-frota","20":"product_tag-custo-por-km","21":"product_tag-dashboard-abastecimento","22":"product_tag-dashboard-interativo","23":"product_tag-dax","24":"product_tag-dcalendario","25":"product_tag-diesel","26":"product_tag-eficiencia-de-combustivel","27":"product_tag-filtros-power-bi","28":"product_tag-gestao-de-frota","29":"product_tag-graficos-power-bi","30":"product_tag-indicadores-de-frota","31":"product_tag-km-por-litro","32":"product_tag-medidas-dax","33":"product_tag-power-bi","34":"product_tag-power-query","35":"product_tag-relatorio-de-abastecimento","36":"product_tag-segmentacao-de-dados","37":"product_tag-tabela-calendario","38":"product_tag-tratamento-de-dados","39":"desktop-align-left","40":"tablet-align-left","41":"mobile-align-left","43":"first","44":"instock","45":"virtual","46":"purchasable","47":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7715","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=7715"}],"version-history":[{"count":2,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7715\/revisions"}],"predecessor-version":[{"id":7719,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/7715\/revisions\/7719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/7716"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=7715"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=7715"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=7715"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=7715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}