{"id":6368,"date":"2017-04-05T14:51:36","date_gmt":"2017-04-05T14:51:36","guid":{"rendered":"https:\/\/apen.onlinevalles.club\/?p=6368"},"modified":"2025-03-04T11:00:55","modified_gmt":"2025-03-04T11:00:55","slug":"analisis-de-cartera-a3erp-con-power-bi","status":"publish","type":"post","link":"https:\/\/apen.onlinevalles.club\/en\/blog\/analisis-de-cartera-a3erp-con-power-bi\/","title":{"rendered":"An\u00e1lisis de cartera a3ERP con Power BI"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Hemos creado una plantilla para poder analizar la cartera de cobros de\u00a0<strong>a3ERP<\/strong>\u00a0desde\u00a0<strong>Power BI<\/strong><br>Puede verla en funcionamiento y usar la demostraci\u00f3n que se ve a continuaci\u00f3n:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Distribuci\u00f3n de la cartera<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<br>La primera p\u00e1gina muestra la distribuci\u00f3n de la cartera para saber c\u00f3mo pagan los clientes, sea por documento de pago o por forma de pago.<br>Se analiza la cartera tanto en cantidad de clientes como en importe de los efectos.<br>Es evidente que cuantos m\u00e1s clientes tengamos que pagan al menor plazo posible, y si puede ser por recibo domiciliado\u2026mejor para la empresa.<br>&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Antig\u00fcedad de la cartera<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<br>La segunda p\u00e1gina nos muestra la cartera pendiente de cobrar y YA vencida, con la antig\u00fcedad de cada efecto, y el promedio de antig\u00fcedad de cada cliente.<br>Es una manera r\u00e1pida de ver cuantos d\u00edas de retraso llevan los clientes que a\u00fan no han pagado.<br>&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Retrasos en los pagos<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<br>Y como hay clientes que tienen la mala costumbre de pagar con retraso, hemos creado una tercera p\u00e1gina para ver qu\u00e9 efectos se cobraron con retraso respecto al vencimiento, y que promedio de retraso tiene cada cliente.<br>&nbsp;<br>Estas plantillas est\u00e1n disponibles para instalar y conectar a su propia base de datos de&nbsp;<strong>a3ERP<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Hemos creado una plantilla para poder analizar la cartera de cobros de\u00a0a3ERP\u00a0desde\u00a0Power BIPuede verla en funcionamiento y usar la demostraci\u00f3n&#8230;<\/p>","protected":false},"author":4,"featured_media":6379,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[47,44],"tags":[72],"class_list":["post-6368","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apen","category-software-de-gestio-erp","tag-a3erp"],"acf":[],"taxonomy_info":{"category":[{"value":47,"label":"Apen"},{"value":44,"label":"software gesti\u00f3n ERP"}],"post_tag":[{"value":72,"label":"a3ERP"}]},"featured_image_src_large":["https:\/\/apen.onlinevalles.club\/wp-content\/uploads\/2017\/04\/powerbi.png",850,401,false],"author_info":{"display_name":"marqueting","author_link":"https:\/\/apen.onlinevalles.club\/en\/blog\/author\/marqueting\/"},"comment_info":0,"category_info":[{"term_id":47,"name":"Apen","slug":"apen","term_group":0,"term_taxonomy_id":47,"taxonomy":"category","description":"","parent":0,"count":251,"filter":"raw","term_order":"0","cat_ID":47,"category_count":251,"category_description":"","cat_name":"Apen","category_nicename":"apen","category_parent":0},{"term_id":44,"name":"software gesti\u00f3n ERP","slug":"software-de-gestio-erp","term_group":0,"term_taxonomy_id":44,"taxonomy":"category","description":"","parent":0,"count":30,"filter":"raw","term_order":"0","cat_ID":44,"category_count":30,"category_description":"","cat_name":"software gesti\u00f3n ERP","category_nicename":"software-de-gestio-erp","category_parent":0}],"tag_info":[{"term_id":72,"name":"a3ERP","slug":"a3erp","term_group":0,"term_taxonomy_id":72,"taxonomy":"post_tag","description":"","parent":0,"count":23,"filter":"raw","term_order":"0"}],"_links":{"self":[{"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/posts\/6368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/comments?post=6368"}],"version-history":[{"count":1,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/posts\/6368\/revisions"}],"predecessor-version":[{"id":54125,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/posts\/6368\/revisions\/54125"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/media\/6379"}],"wp:attachment":[{"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/media?parent=6368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/categories?post=6368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/apen.onlinevalles.club\/en\/wp-json\/wp\/v2\/tags?post=6368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}