{"id":5830,"date":"2024-10-10T15:35:03","date_gmt":"2024-10-10T18:35:03","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=5830"},"modified":"2024-10-10T16:04:00","modified_gmt":"2024-10-10T19:04:00","slug":"dashboard-gestao-de-frota-transportadoras","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/logistica\/dashboard-gestao-de-frota-transportadoras\/","title":{"rendered":"Dashboard Gest\u00e3o de Frota Transportadoras"},"content":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE GEST\u00c3O DE FROTA TRANSPORTADORA DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n<p><strong><em>Funcionalidades<\/em><\/strong><\/p>\n<p><strong>Cadastro:<\/strong><\/p>\n<p>\u2013Uf, estado, m\u00eas, meta;<\/p>\n<p><strong>Lan\u00e7amentos<\/strong><\/p>\n<p><span style=\"font-size: 14pt;\"><em>C\u00e9lulas manuais em branco<\/em><\/span><\/p>\n<p>\u2013Nota fiscal, data emiss\u00e3o, raz\u00e3o social, uf destino, cidade destino trat, transporte reduzido, previs\u00e3o entrega, status, data entrega, valor nf, valor frete, volumes, cte, cnpj destinat\u00e1rio;<\/p>\n<p><span style=\"font-size: 14pt;\"><em>C\u00e9lulas em cinza que tem preenchimento autom\u00e1tico<\/em><\/span><\/p>\n<p>\u2013% Frete, prazo, status 2, no prazo, fora do prazo, estado;<\/p>\n<p><strong>1- Dashboard Financeiro<\/strong><\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Total de vendas, total de fretes, % de fretes, performance;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Vendas por m\u00eas x meta, vendas por estado, vendas x percentual de frete por uf;<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Ano, m\u00eas, transportadora, estado;<\/p>\n<p><strong>2- Dashboard Operacional 1<\/strong><\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Total de vendas, total de fretes, % de fretes, performance;<\/p>\n<p><span style=\"font-size: 16px;\">Gr\u00e1ficos:<\/span><\/p>\n<p>\u2013Valor de frete por % de frete (m\u00e9dia) &#8211; transportadora, lead time em dias por transportadora, percentual frete por transpotadora, volume frete por transportadora, lead time em dias por uf,<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Ano, m\u00eas, transportadora, estado;<\/p>\n<p><strong>3- Dashboard Operacional 2<\/strong><\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Total de vendas, total de fretes, % de fretes, performance, fretes no prazo, fretes fora do prazo, quantidade total de fretes;<\/p>\n<p><span style=\"font-size: 16px;\">Gr\u00e1ficos:<\/span><\/p>\n<p>\u2013Quantidade de fretes por m\u00eas, quantidade de fretes por transportadoras, performance por transportadora, quantidade de entregas por estado, entrega por status;<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Ano, m\u00eas, transportadora, estado;<\/p>\n<p>Planilha 100% edit\u00e1vel<\/p>\n<p>PR\u00c9-REQUISITOS:<br \/>\nTer qualquer vers\u00e3o do EXCEL instalada no computador.<\/p>\n<p>VANTAGENS:<br \/>\nSimplicidade em usar e c\u00e1lculos precisos.<\/p>\n<p>INFORMA\u00c7\u00d5ES \u00daTEIS:<br \/>\nSuporte p\u00f3s-venda, via e-mail, para esclarecer quaisquer d\u00favidas que possam surgir. Planilha original, comercializada pelo pr\u00f3prio desenvolvedor.<\/p>\n<p>Video explicativo da planilha:<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Dashboard em Power BI - Gest\u00e3o de frota Transportadoras 1.0\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/Nrpy3gYy-eI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n","protected":false},"excerpt":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE GEST\u00c3O DE FROTA TRANSPORTADORA DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA. Funcionalidades Cadastro: \u2013Uf, estado, m\u00eas, meta; Lan\u00e7amentos C\u00e9lulas manuais em branco \u2013Nota fiscal, data emiss\u00e3o, raz\u00e3o social, uf destino, cidade destino trat, transporte reduzido, previs\u00e3o entrega, status, data entrega, valor nf, valor frete, volumes, cte, cnpj destinat\u00e1rio; [&hellip;]<\/p>\n","protected":false},"featured_media":5831,"comment_status":"open","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","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":"default","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":[989,176],"product_tag":[1089,1387,1380,857,443,1379,1278,1291,1378,469,1384,925,1381,1386,1382,1385,435,978,1377,1383],"class_list":{"0":"post-5830","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-logistica","7":"product_cat-power-bi","8":"product_tag-acompanhamento-de-fretes","9":"product_tag-analise-de-frete-no-prazo","10":"product_tag-analise-de-fretes-power-bi","11":"product_tag-controle-de-fretes","12":"product_tag-controle-de-frota","13":"product_tag-dashboard-de-frete","14":"product_tag-dashboard-power-bi","15":"product_tag-excel-e-power-bi","16":"product_tag-fretes-no-power-bi","17":"product_tag-gestao-de-frotas","18":"product_tag-gestao-de-transporte-power-bi","19":"product_tag-gestao-de-transportes","20":"product_tag-indicadores-de-fretes","21":"product_tag-lead-time-transportadoras","22":"product_tag-logistica-power-bi","23":"product_tag-performance-de-transportadoras","24":"product_tag-power-bi","25":"product_tag-power-bi-para-empresas","26":"product_tag-transportadoras","27":"product_tag-transporte-rodoviario","28":"desktop-align-left","29":"tablet-align-left","30":"mobile-align-left","32":"first","33":"instock","34":"virtual","35":"purchasable","36":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5830","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=5830"}],"version-history":[{"count":3,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5830\/revisions"}],"predecessor-version":[{"id":5839,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5830\/revisions\/5839"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/5831"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=5830"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=5830"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=5830"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=5830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}