{"id":183,"date":"2025-08-14T13:23:26","date_gmt":"2025-08-14T13:23:26","guid":{"rendered":"https:\/\/www.projektiox.fi\/?p=183"},"modified":"2026-03-12T11:55:48","modified_gmt":"2026-03-12T11:55:48","slug":"osaketunnusluvut","status":"publish","type":"post","link":"https:\/\/www.projektiox.fi\/index.php\/2025\/08\/14\/osaketunnusluvut\/","title":{"rendered":"IREN Limited (IREN) tuloslaskelma, tase ja kassavirta aikasarjoina visualisointi"},"content":{"rendered":"\n<p class=\"has-small-font-size\">Visualisointi: tuloslaskelma, tase ja kassavirta kvartaaleittain 2010-2025 (oletuksena 2016-2025) sek\u00e4 tunnusluvut.<\/p>\n\n\n\n<p class=\"has-small-font-size\">Tekninen toteutus: Azure Datalake (blob container) &#8211; Azure Data Factory (HTTPJson, pipeline) &#8211; Power bi (ADLS gen2)<\/p>\n\n\n\n<p class=\"has-small-font-size\">P\u00e4ivitys: Automaattinen (p\u00e4ivitt\u00e4in 06.00)<\/p>\n\n\n\n<p class=\"has-small-font-size\">L\u00e4hteet: Alpha Vantage (API)<\/p>\n\n\n\n<p class=\"has-text-align-center\">&#8211;<\/p>\n\n\n\n<p><strong>Yleiskatsaus:<\/strong><\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Stock_overview\" width=\"600\" height=\"373.5\" src=\"https:\/\/app.fabric.microsoft.com\/view?r=eyJrIjoiZjIzNjBhOGEtY2Q1YS00NmI1LWJjZGUtNThiMjhhYzM1NDEwIiwidCI6Ijc2MzBlYjQyLTk0YjEtNGMxNy1iNGRlLTgxMzRjMmNiMzAwNyIsImMiOjh9\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-text-align-center\">_<\/p>\n\n\n\n<p><strong>Tuloslaskelma<\/strong>:<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Alphav_incStatement_qtr\" width=\"600\" height=\"373.5\" src=\"https:\/\/app.fabric.microsoft.com\/view?r=eyJrIjoiMGM2YmViYmItNDgyZS00MTcwLThmN2MtN2VkZmI0MDUzYjIzIiwidCI6Ijc2MzBlYjQyLTk0YjEtNGMxNy1iNGRlLTgxMzRjMmNiMzAwNyIsImMiOjh9\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe><\/p>\n\n\n\n<p class=\"has-text-align-center\">&#8211;<\/p>\n\n\n\n<p><strong>Tase<\/strong>:<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Alphav_BalanceSheet_qtr\" width=\"600\" height=\"373.5\" src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiNzZmM2E4ZjQtZjFhNC00ZmUyLWE3YjAtOGMwZGQ4ZjgyODNhIiwidCI6Ijc2MzBlYjQyLTk0YjEtNGMxNy1iNGRlLTgxMzRjMmNiMzAwNyIsImMiOjh9\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe><\/p>\n\n\n\n<p class=\"has-text-align-center\">&#8211;<\/p>\n\n\n\n<p><strong>Kassavirta<\/strong>:<\/p>\n\n\n<p><iframe loading=\"lazy\" title=\"Alphav_Cashflow\" width=\"600\" height=\"373.5\" src=\"https:\/\/app.fabric.microsoft.com\/view?r=eyJrIjoiYjljZjhiNmMtMzNhMi00YTU5LWFiMzItZTgyNGZmZWNjNzI0IiwidCI6Ijc2MzBlYjQyLTk0YjEtNGMxNy1iNGRlLTgxMzRjMmNiMzAwNyIsImMiOjh9\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p class=\"post-excerpt\">Visualisointi: tuloslaskelma, tase ja kassavirta kvartaaleittain 2010-2025 (oletuksena 2016-2025) sek\u00e4 tunnusluvut. Tekninen toteutus: Azure Datalake (blob container) &#8211; Azure Data&#8230;<\/p>\n","protected":false},"author":1,"featured_media":185,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,17,18,8,19,12,20,21],"tags":[],"class_list":["post-183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-api","category-azure","category-data-factory","category-data-analytiikka","category-pipeline","category-powerbi","category-sijoittaminen","category-tuloslaskelma"],"_links":{"self":[{"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/posts\/183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/comments?post=183"}],"version-history":[{"count":19,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/posts\/183\/revisions"}],"predecessor-version":[{"id":223,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/posts\/183\/revisions\/223"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/media\/185"}],"wp:attachment":[{"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/media?parent=183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/categories?post=183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.projektiox.fi\/index.php\/wp-json\/wp\/v2\/tags?post=183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}