{"id":344,"date":"2024-06-27T00:00:46","date_gmt":"2024-06-27T00:00:46","guid":{"rendered":"https:\/\/iamariadne.com\/Chronicles\/?p=344"},"modified":"2024-06-27T00:17:42","modified_gmt":"2024-06-27T00:17:42","slug":"kpis-power-bi-excel","status":"publish","type":"post","link":"https:\/\/iamariadne.com\/Chronicles\/2024\/06\/27\/kpis-power-bi-excel\/","title":{"rendered":"KPI&#8217;s | Power BI | Excel"},"content":{"rendered":"\n<p>Wasn&#8217;t I thrown a curveball today! Seems like I&#8217;m running behind on things. When I was working continuously in Excel, Power BI was part of the Ribbon. <a href=\"https:\/\/www.ccslearningacademy.com\/power-bi-vs-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">No longer<\/a>. And it took a while to find out that now we&#8217;re talking about <a href=\"https:\/\/learn.microsoft.com\/en-us\/fabric\/enterprise\/licenses\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Fabric<\/a> &#8211; uploading your workbook to Power BI, for which you need an work account to have a free trial of 60 days. MAN! I need to upgrade, and upgrade fast!<\/p>\n\n\n\n<p>All of this came to be as I gotten the request to do a training. And as I love providing courses for others, this didn&#8217;t feel as no other. Then came the list of things that they wanted to get taught. Oh my goodness! That list was quite impressive! Words were given like KPI&#8217;s, Power BI, Case Studies, R&amp;D and more were words that I&#8217;ve not been around for quite some time.<\/p>\n\n\n\n<p>Not to be intimidated in any way, I went to explore the additional items that were requested and my eye fell on Power BI. For anyone who doesn&#8217;t know, Power BI is a powerful (get it?) data analysis and data intelligence tool being used nowadays. Gone are the days where complex formulas need to be pushed out of &#8230; well somewhere: now it&#8217;s much more intuitive and easy to get your reports, and dashboards ready for management. I think I fell in love again&#8230;<\/p>\n\n\n\n<p>So not to be deterred, I&#8217;ve created my account to be able to test this out in practice and boy am I impressed! The blop of data I uploaded became a beautifully tailored report. Now it&#8217;s up to me to make sense of all the graphs to make it all make sense.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-1024x578.png\" alt=\"\" class=\"wp-image-345\" srcset=\"https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-1024x578.png 1024w, https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-300x169.png 300w, https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-768x433.png 768w, https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image.png 1484w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>I can&#8217;t say though, that this went without any &#8216;frustration&#8217;. The fact that you <em>have to, must, are required to<\/em> have either OneDrive or SharePoint to handle your folders, bugs me to no end. I understand it&#8217;s MS&#8217; right to demand us to use ONLY their products, but HELLO! Some of us simply just don&#8217;t wanna. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"253\" src=\"https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-1.png\" alt=\"\" class=\"wp-image-351\" srcset=\"https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-1.png 726w, https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/image-1-300x105.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>So to get around that, I just manually copy and pasted it directly into Power Bi. HA! Take that Microsoft \ud83d\ude00<\/p>\n\n\n\n<p>In any case: I am happy to say that I found some joy again in preparing for a training. It&#8217;s a challenge, and I thrive in challenges. I have about a week to prepare after which it&#8217;s play time!<\/p>\n\n\n\n<p>Wish me luck &#8211; or better yet &#8211; pray for me, will y&#8217;a?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wasn&#8217;t I thrown a curveball today! Seems like I&#8217;m running behind on things. When I was working continuously in Excel, Power BI was part of the Ribbon. No longer. And it took a while to find out that now we&#8217;re talking about Microsoft Fabric &#8211; uploading your workbook to Power BI, for which you need [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":346,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[15],"tags":[],"class_list":["post-344","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-work-thingies"],"aioseo_notices":[],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/iamariadne.com\/Chronicles\/wp-content\/uploads\/2024\/06\/pexels-tima-miroshnichenko-7567426-scaled.jpg","_links":{"self":[{"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/posts\/344","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/comments?post=344"}],"version-history":[{"count":4,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/posts\/344\/revisions"}],"predecessor-version":[{"id":353,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/posts\/344\/revisions\/353"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/media\/346"}],"wp:attachment":[{"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/media?parent=344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/categories?post=344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iamariadne.com\/Chronicles\/wp-json\/wp\/v2\/tags?post=344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}