{"id":5976,"date":"2024-11-08T15:28:47","date_gmt":"2024-11-08T18:28:47","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=5976"},"modified":"2024-11-08T16:34:23","modified_gmt":"2024-11-08T19:34:23","slug":"dashboard-em-power-bi-gestao-de-compras","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/comercial\/dashboard-em-power-bi-gestao-de-compras\/","title":{"rendered":"Dashboard Em Power BI &#8211; Gest\u00e3o de Compras"},"content":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE COMPRAS DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n<p>Funcionalidades<\/p>\n<p>Cadastros Produto<\/p>\n<p>\u2013Id, nome tecido, custo unitario, finalidade;<\/p>\n<p>Cadastros Comprador<\/p>\n<p>\u2013Id, nome comprador;<\/p>\n<p>Cadastros Fornecedor<\/p>\n<p>\u2013Id, nome fornecedor, uf;<\/p>\n<p>Lan\u00e7amentos Pedidos<\/p>\n<p>\u2013Id, pedido data, sa\u00edda data, previs\u00e3o data, entrega data, id comprador, id fornecedor, id produto, quantidade, desconto;<\/p>\n<p>Dashboard<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013 Custo l\u00edquidos por m\u00eas, saving, compras por finalidade, lead time;<\/p>\n<p>Tabela Din\u00e2mica Compradores<\/p>\n<p>\u2013Nome, custo l\u00edquido, saving, atraso m\u00e9dio, lead time, compras por uf;<\/p>\n<p><span style=\"font-size: 16px;\">Os filtros em forma de Segmenta\u00e7\u00e3o de dados:<\/span><\/p>\n<p>\u2013Ano, m\u00eas, compradores, fornecedores, produto;<\/p>\n<p>Planilha 100% edit\u00e1vel<\/p>\n<p>PR\u00c9-REQUISITOS:<br \/>\nTer qualquer vers\u00e3o do EXCEL instalada no computador e Power BI desktop.<\/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=\"Projeto em power BI   Gest\u00e3o de Compras\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/KyZhXaJgQb0?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 COMPRAS DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n","protected":false},"featured_media":5978,"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":[998,176],"product_tag":[1500,1510,1504,1496,1502,1497,1505,508,1506,1498,1509,1503,1508,1499,1507,1501],"class_list":{"0":"post-5976","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-comercial","7":"product_cat-power-bi","8":"product_tag-analise-de-compras","9":"product_tag-analise-de-custos-power-bi","10":"product_tag-compras-e-fornecedores","11":"product_tag-controle-de-compras-power-bi","12":"product_tag-controle-de-estoque-power-bi","13":"product_tag-dashboard-de-compras","14":"product_tag-dashboard-de-compras-power-bi","15":"product_tag-dashboard-logistico","16":"product_tag-economias-em-compras","17":"product_tag-gestao-de-compras-power-bi","18":"product_tag-gestao-de-fornecedores-power-bi","19":"product_tag-lead-time-compras","20":"product_tag-painel-de-controle-compras","21":"product_tag-power-bi-fornecedores","22":"product_tag-power-bi-para-negocios","23":"product_tag-saving-compras","24":"desktop-align-left","25":"tablet-align-left","26":"mobile-align-left","28":"first","29":"instock","30":"virtual","31":"purchasable","32":"product-type-simple"},"_links":{"self":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5976","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=5976"}],"version-history":[{"count":2,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5976\/revisions"}],"predecessor-version":[{"id":5985,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/5976\/revisions\/5985"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/5978"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=5976"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=5976"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=5976"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=5976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}