{"id":1115,"date":"2020-04-13T09:00:00","date_gmt":"2020-04-13T07:00:00","guid":{"rendered":"https:\/\/www.phanexperts.com\/?p=1115"},"modified":"2020-06-30T12:37:49","modified_gmt":"2020-06-30T10:37:49","slug":"how-to-prepare-an-income-statement-with-power-bi","status":"publish","type":"post","link":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/","title":{"rendered":"How to prepare an income statement with Power BI ?"},"content":{"rendered":"\n<p>The increasing usage of Power BI to draft an income statement constitutes a major turning point for accounting and finance professionals. The challenge for the latter consists to use the accounting data to draw meaningful insights. In the era of Big Data, processing large volumes of data has become more mainstream. Power BI is helping to reinforce this trend.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Moving from Excel to Power BI<\/h3>\n\n\n\n<p>However, to prepare financial analysis for decision-makers, Excel remains the most widely used tool nowadays. But, from the perspective of transforming large datasets (as with the FEC, the French consolidated file of accounting entries mandatory in case of a tax audit), Excel&#8217;s limitations are numerous and significant :<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>1 million lines maximum<\/li><li>Manual and repetitive tasks<\/li><li>Obligation to learn VBA to automate some processes<\/li><li>Risk of errors<\/li><li>Duplication of work and data<\/li><li>Etc<\/li><\/ul>\n\n\n\n<p>Power BI allows these limitations to be overcome by writing queries. These can simply be refreshed each time the dataset is updated. Not to mention the advanced functions for data visualisation and report sharing that are not included in Excel. Below are some of the best practices to build a Power BI income statement using large datasets such as the FEC.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 : transform the data<\/h3>\n\n\n\n<p>The first step is to import and transform the data. The goal here is to present the data in the form of tables containing as few columns as possible. If in Excel, we tend to present the data in columns in a single table to use the pivot tables and the VLOOKUP function, the approach must be quite different in Power BI. Indeed, the separation of data into fact tables (accounting daily transactions) and dimension tables (axes of analysis) will optimize the data model. In practice, this will consist of &#8220;wrangling&#8221; the data so as to keep only the rows and columns essential for the analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"411\" src=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image.png\" alt=\"Accounting data after transformation in Power Query\" class=\"wp-image-1120\" srcset=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image.png 605w, https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-300x204.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><figcaption>After data transformation, only 4 columns left for analysis<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 : build the dimension tables<\/h3>\n\n\n\n<p>Then, the task will consist in building a table of dimensions containing the hierarchy of statutory accounts. This step will allow to display the different sections of the financial statements in the appropriate order. Several methods are possible for this. A first method is to add an index column and sort the labels by this column. Which will display the labels in the correct order. This method, if simple, can however quickly reveal its limits when the labels are numerous. Another more advanced and robust method for exploiting large sets of data is to take advantage of the parent \/ child DAX functions to build the desired hierarchy. On this subject, you can refer to <a rel=\"noreferrer noopener\" href=\"https:\/\/www.daxpatterns.com\/parent-child-hierarchies\/\" target=\"_blank\">the article written by Marco Russo<\/a> which explains in detail the use of these functions.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"317\" src=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-1.png\" alt=\"The table containing the accounts hierarchy leveraging the parent \/ child functions\" class=\"wp-image-1122\" srcset=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-1.png 605w, https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-1-300x157.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><figcaption>Parent\/child functions leveraged in calculated columns<\/figcaption><\/figure>\n\n\n\n<p>Then, in order to harness the full power of Power BI time intelligence functions, you will need to build a separate date table. We can do this either in the data view with the DAX functions, or in Power Query using the M language.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"352\" src=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-2.png\" alt=\"The date table built in Power Query using M language\" class=\"wp-image-1124\" srcset=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-2.png 605w, https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-2-300x175.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><figcaption>A custom date table built with M functions<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3 : link the tables together and build the visualizations<\/h3>\n\n\n\n<p>Once the tables constructed, simply link them together in the data model, then write the appropriate measures to calculate the main items of the income statement.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"334\" src=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-3.png\" alt=\"The final model ready to be analyzed\" class=\"wp-image-1126\" srcset=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-3.png 605w, https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-3-300x166.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><figcaption>A star schema model compliant with the best standards of data modeling<\/figcaption><\/figure>\n\n\n\n<p>Once the model finished, you can unleash your creativity to draft the most impactful visualizations for your dashboard !<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"605\" height=\"297\" src=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-4.png\" alt=\"An example of a visualisation of an income statement thanks to the parent\/child functions in DAX\" class=\"wp-image-1128\" srcset=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-4.png 605w, https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/image-4-300x147.png 300w\" sizes=\"auto, (max-width: 605px) 100vw, 605px\" \/><figcaption>The detailed income statement in a matrix visual with a waterfall alongside<\/figcaption><\/figure>\n\n\n\n<p>In a nutshell, while building a detailed income statement is far from simple, the task remains feasible under Power BI. Do not hesitate to contact us you need support in producing <a href=\"https:\/\/www.phanexperts.com\/en\/business-intelligence\/\">dashboards<\/a> from your accounting data !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The increasing usage of Power BI to draft an income statement constitutes a major turning point for accounting and finance professionals. The challenge for the latter consists to use the accounting data to draw meaningful insights. In the era of Big Data, processing large volumes of data has become more mainstream. Power BI is helping [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":1108,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[93,39],"tags":[95,113,112,73],"class_list":["post-1115","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounting","category-data-analytics","tag-fec-2","tag-income-statement","tag-pl","tag-power-bi-2"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to prepare an income statement with Power BI ? - PHAN Experts<\/title>\n<meta name=\"description\" content=\"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to prepare an income statement with Power BI ? - PHAN Experts\" \/>\n<meta property=\"og:description\" content=\"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"PHAN Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/PHAN-Experts-989733077878895\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-13T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-06-30T10:37:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1806\" \/>\n\t<meta property=\"og:image:height\" content=\"525\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"admin-phan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin-phan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/\"},\"author\":{\"name\":\"admin-phan\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#\\\/schema\\\/person\\\/2141451138e3b634f3ace52992b8ee03\"},\"headline\":\"How to prepare an income statement with Power BI ?\",\"datePublished\":\"2020-04-13T07:00:00+00:00\",\"dateModified\":\"2020-06-30T10:37:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/\"},\"wordCount\":631,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/data-transformation.jpg\",\"keywords\":[\"FEC\",\"Income statement\",\"P&amp;L\",\"Power BI\"],\"articleSection\":[\"Accounting\",\"Data Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/\",\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/\",\"name\":\"How to prepare an income statement with Power BI ? - PHAN Experts\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/data-transformation.jpg\",\"datePublished\":\"2020-04-13T07:00:00+00:00\",\"dateModified\":\"2020-06-30T10:37:49+00:00\",\"description\":\"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/data-transformation.jpg\",\"contentUrl\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2020\\\/04\\\/data-transformation.jpg\",\"width\":1806,\"height\":525,\"caption\":\"data transformation\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/how-to-prepare-an-income-statement-with-power-bi\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/accueil\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to prepare an income statement with Power BI ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#website\",\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/\",\"name\":\"PHAN Experts\",\"description\":\"Cabinet d&#039;expertise-comptable et de conseil\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.phanexperts.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#organization\",\"name\":\"PHAN EXPERTS\",\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Phan-Experts-logo-rvb.jpg\",\"contentUrl\":\"https:\\\/\\\/www.phanexperts.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/Phan-Experts-logo-rvb.jpg\",\"width\":1425,\"height\":916,\"caption\":\"PHAN EXPERTS\"},\"image\":{\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/PHAN-Experts-989733077878895\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/phan-experts\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.phanexperts.com\\\/#\\\/schema\\\/person\\\/2141451138e3b634f3ace52992b8ee03\",\"name\":\"admin-phan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g\",\"caption\":\"admin-phan\"},\"url\":\"https:\\\/\\\/www.phanexperts.com\\\/en\\\/author\\\/admin-phan\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to prepare an income statement with Power BI ? - PHAN Experts","description":"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/","og_locale":"en_US","og_type":"article","og_title":"How to prepare an income statement with Power BI ? - PHAN Experts","og_description":"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.","og_url":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/","og_site_name":"PHAN Experts","article_publisher":"https:\/\/www.facebook.com\/PHAN-Experts-989733077878895\/","article_published_time":"2020-04-13T07:00:00+00:00","article_modified_time":"2020-06-30T10:37:49+00:00","og_image":[{"width":1806,"height":525,"url":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg","type":"image\/jpeg"}],"author":"admin-phan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin-phan","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#article","isPartOf":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/"},"author":{"name":"admin-phan","@id":"https:\/\/www.phanexperts.com\/#\/schema\/person\/2141451138e3b634f3ace52992b8ee03"},"headline":"How to prepare an income statement with Power BI ?","datePublished":"2020-04-13T07:00:00+00:00","dateModified":"2020-06-30T10:37:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/"},"wordCount":631,"commentCount":0,"publisher":{"@id":"https:\/\/www.phanexperts.com\/#organization"},"image":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg","keywords":["FEC","Income statement","P&amp;L","Power BI"],"articleSection":["Accounting","Data Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/","url":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/","name":"How to prepare an income statement with Power BI ? - PHAN Experts","isPartOf":{"@id":"https:\/\/www.phanexperts.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#primaryimage"},"image":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#primaryimage"},"thumbnailUrl":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg","datePublished":"2020-04-13T07:00:00+00:00","dateModified":"2020-06-30T10:37:49+00:00","description":"Using Power BI to prepare an income statement can be done in an efficient manner, especially when dealing with large datasets. Read more to see how.","breadcrumb":{"@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#primaryimage","url":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg","contentUrl":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2020\/04\/data-transformation.jpg","width":1806,"height":525,"caption":"data transformation"},{"@type":"BreadcrumbList","@id":"https:\/\/www.phanexperts.com\/en\/how-to-prepare-an-income-statement-with-power-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.phanexperts.com\/en\/accueil\/"},{"@type":"ListItem","position":2,"name":"How to prepare an income statement with Power BI ?"}]},{"@type":"WebSite","@id":"https:\/\/www.phanexperts.com\/#website","url":"https:\/\/www.phanexperts.com\/","name":"PHAN Experts","description":"Cabinet d&#039;expertise-comptable et de conseil","publisher":{"@id":"https:\/\/www.phanexperts.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.phanexperts.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.phanexperts.com\/#organization","name":"PHAN EXPERTS","url":"https:\/\/www.phanexperts.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.phanexperts.com\/#\/schema\/logo\/image\/","url":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2019\/07\/Phan-Experts-logo-rvb.jpg","contentUrl":"https:\/\/www.phanexperts.com\/wp-content\/uploads\/2019\/07\/Phan-Experts-logo-rvb.jpg","width":1425,"height":916,"caption":"PHAN EXPERTS"},"image":{"@id":"https:\/\/www.phanexperts.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/PHAN-Experts-989733077878895\/","https:\/\/www.linkedin.com\/company\/phan-experts\/"]},{"@type":"Person","@id":"https:\/\/www.phanexperts.com\/#\/schema\/person\/2141451138e3b634f3ace52992b8ee03","name":"admin-phan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70501b0d500a0c367da43d932749af5c1abb491de129989359bc2f483bccc814?s=96&d=mm&r=g","caption":"admin-phan"},"url":"https:\/\/www.phanexperts.com\/en\/author\/admin-phan\/"}]}},"_links":{"self":[{"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/posts\/1115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/comments?post=1115"}],"version-history":[{"count":16,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/posts\/1115\/revisions"}],"predecessor-version":[{"id":1302,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/posts\/1115\/revisions\/1302"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/media\/1108"}],"wp:attachment":[{"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/media?parent=1115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/categories?post=1115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.phanexperts.com\/en\/wp-json\/wp\/v2\/tags?post=1115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}