{"id":6349,"date":"2025-01-30T16:21:25","date_gmt":"2025-01-30T19:21:25","guid":{"rendered":"https:\/\/pacotedeplanilhas.com\/loja\/?post_type=product&#038;p=6349"},"modified":"2025-01-30T16:54:12","modified_gmt":"2025-01-30T19:54:12","slug":"analise-comercial-de-vendas-e-metas-no-power-bi","status":"publish","type":"product","link":"https:\/\/pacotedeplanilhas.com\/loja\/store\/comercial\/analise-comercial-de-vendas-e-metas-no-power-bi\/","title":{"rendered":"Analise comercial de Vendas e Metas no Power BI"},"content":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE VENDAS E METAS DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n<p>Funcionalidades<\/p>\n<p>Cadastros<\/p>\n<p>Clientes:<\/p>\n<p>\u2013Id do cliente, cliente, cep, uf, cidade;<\/p>\n<p>Custos:<\/p>\n<p>\u2013Categoria, valor;<\/p>\n<p>Categorias<\/p>\n<p>\u2013Grupo, categoria;<\/p>\n<p>Vendedores:<\/p>\n<p>\u2013Id vendedor, vendedor, regi\u00e3o;<\/p>\n<p>Vendas<\/p>\n<p>\u2013Data, nf, gr cli, quantidade, valor mercadoria, valor frete, valor devolu\u00e7\u00f5es, quantidade devolvida, grupo, categoria, tipo de venda, id cliente, id vendedor;<\/p>\n<p>Metas<\/p>\n<p>C\u00e9lulas manuais em branco:<\/p>\n<p>\u2013Id vendedor, m\u00eas, valor, grupo, categoria;<\/p>\n<p>C\u00e9lulas em cinza que possui preenchimento autom\u00e1tico:<\/p>\n<p>\u2013Ano;<\/p>\n<p>Dashboard Comercial<\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Vendas R$, custos R$, margem bruta R$, % performace;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Faturamento no per\u00edodo, margem bruta no per\u00edodo, % performace no per\u00edodo, vendas por uf, vendas por categoria;<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Data ano\/m\u00eas, categoria, grupo, tipo venda, uf, cidade, cliente;<\/p>\n<p>Dashboard Metas<\/p>\n<p>Valores totais:<\/p>\n<p>\u2013Metas R$, vendas R$, % atingimento da meta, varia\u00e7\u00e3o R$;<\/p>\n<p>Gr\u00e1ficos:<\/p>\n<p>\u2013Faturamento x meta no per\u00edodo, an\u00e1lise por categoria, an\u00e1lise por vendedor, an\u00e1lise por cliente;<\/p>\n<p>Filtros em forma de segmenta\u00e7\u00e3o de dados<\/p>\n<p>\u2013Data, ano\/m\u00eas, categoria, vendedor;<\/p>\n<p><span style=\"font-size: 16px;\">Planilha 100% edit\u00e1vel<\/span><\/p>\n<p>PR\u00c9-REQUISITOS:<br \/>\nTer qualquer vers\u00e3o do EXCEL e POWER BI 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=\"Analise comercial de Vendas e Metas no Power BI\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/IV8GInnNXpw?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<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>FA\u00c7A O CONTROLE E ACOMPANHAMENTO DE VENDAS E METAS DA SUA EMPRESA DE MANEIRA SIMPLES E R\u00c1PIDA.<\/p>\n","protected":false},"featured_media":6351,"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":[998,176],"product_tag":[535,1635,429,381,1632,1640,1634,1631,566,1411,1633,1063,1636,705,430,1413,1639,1638,1409,1637],"class_list":{"0":"post-6349","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-vendas","9":"product_tag-controle-de-metas-de-vendedores","10":"product_tag-controle-de-vendas","11":"product_tag-controle-de-vendas-e-metas","12":"product_tag-controle-de-vendas-por-regiao","13":"product_tag-controle-de-vendedores","14":"product_tag-dashboard-de-faturamento","15":"product_tag-dashboard-de-vendas-no-excel","16":"product_tag-dashboard-interativo","17":"product_tag-excel-para-vendas","18":"product_tag-gerenciamento-de-vendas","19":"product_tag-gestao-comercial","20":"product_tag-graficos-de-vendas-no-excel","21":"product_tag-indicadores-de-vendas","22":"product_tag-relatorio-de-vendas","23":"product_tag-vendas-e-metas","24":"product_tag-vendas-por-cliente","25":"product_tag-vendas-por-fornecedor","26":"product_tag-vendas-por-produto","27":"product_tag-vendas-por-trimestre","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\/6349","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=6349"}],"version-history":[{"count":3,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/6349\/revisions"}],"predecessor-version":[{"id":6363,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product\/6349\/revisions\/6363"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media\/6351"}],"wp:attachment":[{"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/media?parent=6349"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_brand?post=6349"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_cat?post=6349"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/pacotedeplanilhas.com\/loja\/wp-json\/wp\/v2\/product_tag?post=6349"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}