{"id":14568,"date":"2026-02-12T20:40:50","date_gmt":"2026-02-12T19:40:50","guid":{"rendered":"https:\/\/www.leaplytics.de\/?page_id=14568"},"modified":"2026-02-12T21:01:35","modified_gmt":"2026-02-12T20:01:35","slug":"matricas-tabula","status":"publish","type":"page","link":"https:\/\/www.leaplytics.de\/lv\/matricas-tabula\/","title":{"rendered":"Matricas tabula"},"content":{"rendered":"<h3 class=\"wp-block-heading\">Vien\u012bg\u0101 matricas tabula, kas rad\u012bta finan\u0161u komand\u0101m, kur\u0101m Power BI ir nepiecie\u0161ami skait\u013ci UN vizualiz\u0101cija<\/h3>\n\n\n\n<p>Ja j\u016bs prezent\u0113jat finan\u0161u datus Power BI un ieinteres\u0113t\u0101s puses turpina raudz\u012bties uz skait\u013cu rind\u0101m... ja j\u016bs manu\u0101li pievienojat mirdzo\u0161as l\u012bnijas programm\u0101 Excel, jo Power BI tabulas nesp\u0113j par\u0101d\u012bt rindas joslas... ja j\u016bsu finan\u0161u direktors v\u0113las redz\u0113t kategorijas ar vizu\u0101liem veiktsp\u0113jas r\u0101d\u012bt\u0101jiem, bet j\u016bs to nevarat nodro\u0161in\u0101t...<\/p>\n\n\n\n<p><strong>J\u016bs neesat viens.<\/strong><\/p>\n\n\n\n<p>At\u0161\u0137ir\u012bba ir \u0161\u0101da: \u0161\u012b nav v\u0113l viena vienk\u0101r\u0161a tabulas vizualiz\u0101cija. \u0160\u012b ir profesion\u0101la matricas tabula ar ieb\u016bv\u0113t\u0101m joslu diagramm\u0101m, iesald\u0113t\u0101m kategoriju kolonn\u0101m, re\u017e\u012bmu Small Multiples vair\u0101ku m\u0113r\u012bjumu sal\u012bdzin\u0101\u0161anai, sinhroniz\u0113tu rindu izcel\u0161anu un respons\u012bvu dizainu, kas darbojas gan pane\u013ca pane\u013cu fl\u012bz\u0113s, gan pilnekr\u0101na prezent\u0101cij\u0101s.<\/p>\n\n\n\n<div style=\"height:23px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Re\u0101l\u0101s finan\u0161u komandas. Re\u0101li rezult\u0101ti.<\/h3>\n\n\n\n<p><em>\"M\u0113s katru m\u0113nesi iepaz\u012bstin\u0101m savu vad\u012bt\u0101ju komandu ar 12 izmaksu centru KPI. Pirms \u0161\u012b vizu\u0101l\u0101 risin\u0101juma mums bija skait\u013cu tabulas, uz kur\u0101m neviens negrib\u0113ja skat\u012bties. Tagad? Katr\u0101 rind\u0101 ir redzama kategorija ar l\u012bniju josl\u0101m, kas uzreiz inform\u0113 par rezult\u0101tiem. Mazo daudzk\u0101rt\u0146u re\u017e\u012bms \u013cauj mums par\u0101d\u012bt ie\u0146\u0113mumus, izmaksas un pe\u013c\u0146u vienu otram blakus. M\u016bsu vad\u012bt\u0101ji tagad patie\u0161\u0101m str\u0101d\u0101 ar datiem.\"<\/em><\/p>\n\n\n\n<p><strong>- Finan\u0161u vad\u012bt\u0101js, mazumtirdzniec\u012bbas uz\u0146\u0113mums<\/strong><\/p>\n\n\n\n<div style=\"height:23px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">L\u016bk, ko j\u016bs sa\u0146emsiet (ko nevarat sa\u0146emt nekur citur)<\/h3>\n\n\n\n<p><strong>Rindu joslu diagrammas katr\u0101 rind\u0101<\/strong><br>Skait\u013ci ir labi. Skait\u013ci ar sv\u012btr\u0101m ir lab\u0101ki. Katra v\u0113rt\u012bba tiek par\u0101d\u012bta ar proporcion\u0101lu joslu, kas nodro\u0161ina t\u016bl\u012bt\u0113ju sal\u012bdzin\u0101\u0161anu. Nevajag vairs sken\u0113t skait\u013cu kolonnas - uzreiz redziet veiktsp\u0113ju.<\/p>\n\n\n\n<p><strong>Mazo daudzk\u0101rt\u0146u re\u017e\u012bms<\/strong><br>Matricas izk\u0101rtojum\u0101 par\u0101diet vair\u0101kus m\u0113r\u012bjumus vienu blakus otram. Ie\u0146\u0113mumi, izmaksas, pe\u013c\u0146a - katrs sav\u0101 slej\u0101 ar ievilkt\u0101m josl\u0101m. Sal\u012bdziniet da\u017e\u0101das kategorijas UN da\u017e\u0101dus pas\u0101kumus vien\u0101 kompakt\u0101 vizu\u0101l\u0101 att\u0113l\u0101.<\/p>\n\n\n\n<p><strong>Sald\u0113tas kategorijas sleja<\/strong><br>Ritiniet v\u0113rt\u012bbas, kam\u0113r kategoriju eti\u0137etes paliek redzamas. Nevajag vairs aizmirst, kur\u0101 rind\u0101 skat\u0101ties. Iesald\u0113t\u0101 sleja vienm\u0113r saglab\u0101 redzamu kontekstu.<\/p>\n\n\n\n<p><strong>Sinhroniz\u0113ta rindu izcel\u0161ana<\/strong><br>Novietojiet kursoru virs jebkuras \u0161\u016bnas, un visa rinda tiks izcelta visos sald\u0113tajos un v\u0113rt\u012bbu apgabalos. Izsekojiet sniegumu visos pas\u0101kumos, nepazaud\u0113jot savu vietu.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Paties\u0101 cena par to, ka tas nav nepiecie\u0161ams<\/h3>\n\n\n\n<p><strong>Finan\u0161u komand\u0101m:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>J\u016bs iesniedzat skait\u013cu tabulas, kuras vad\u012bt\u0101ji ignor\u0113 vai ignor\u0113.<\/li>\n\n\n\n<li>V\u0113rt\u012bbu sal\u012bdzin\u0101\u0161anai starp kategorij\u0101m ir nepiecie\u0161ama ment\u0101l\u0101 matem\u0101tika, nevis vizu\u0101lie mode\u013ci.<\/li>\n\n\n\n<li>Ritinot platas tabulas, paz\u016bd konteksts, jo paz\u016bd kategoriju nosaukumi<\/li>\n\n\n\n<li>Vair\u0101ki pas\u0101kumi prasa vair\u0101kus vizu\u0101lus, kas nav pareizi saska\u0146oti.<\/li>\n\n\n\n<li>Eksport\u0113jat uz Excel, lai pievienotu nosac\u012btu format\u0113jumu un sprak\u013cl\u012bnijas.<\/li>\n<\/ul>\n\n\n\n<p><strong>Kontrolieriem un FP&amp;A:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u0113ne\u0161a p\u0101rskati aiz\u0146em vair\u0101k laika, jo ir nepiecie\u0161amas diagrammas UN tabulas par vieniem un tiem pa\u0161iem datiem.<\/li>\n\n\n\n<li>Ieinteres\u0113t\u0101s puses jaut\u0101: \"Kur\u0161 izmaksu centrs ir slikt\u0101kais?\", un j\u016bs nor\u0101d\u0101t uz skaitli, kuru vi\u0146i nevar atrast.<\/li>\n\n\n\n<li>Sal\u012bdzinot ie\u0146\u0113mumus ar izmaks\u0101m un pe\u013c\u0146u, ir j\u0101p\u0101rsl\u0113dzas starp trim atsevi\u0161\u0137iem vizu\u0101lajiem att\u0113liem.<\/li>\n\n\n\n<li>Inform\u0101cijas pane\u013ca vieta tiek iz\u0161\u0137\u0113rd\u0113ta liek\u0101m tabul\u0101m un diagramm\u0101m, kur\u0101s att\u0113loti vieni un tie pa\u0161i dati.<\/li>\n\n\n\n<li>Rindu l\u012bme\u0146a anal\u012bze ir apgr\u016btino\u0161a, jo hover st\u0101vok\u013ci neaptver visu rindu.<\/li>\n<\/ul>\n\n\n\n<p><strong>Apak\u0161\u0113j\u0101 l\u012bnija?<\/strong> J\u016bsu tabulas ir tikai datu izg\u0101ztuves. T\u0101m j\u0101b\u016bt sazi\u0146as r\u012bkiem. Skait\u013ci ar vizu\u0101lu kontekstu ir saprotami. Tikai skait\u013cus vien ignor\u0113.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group alignfull has-black-color has-text-color has-background has-link-color wp-elements-05f5ec3fa97393a00ed0d2552b272b51\" style=\"background-color:#eeeeee\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-center\"><strong>Ko j\u016bs faktiski sa\u0146emat<\/strong><\/h3>\n\n\n\n<p class=\"has-text-align-center\"><em>Katra funkcija. Bez kompromisiem. Izstr\u0101d\u0101ts finan\u0161u profesion\u0101\u013ciem, finan\u0161u profesion\u0101\u013ciem.<\/em><\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-1 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:15% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Comparison-Icon.png\" alt=\"\" class=\"size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p style=\"font-size:22px\"><strong>Rindu joslu diagrammas<\/strong><\/p>\n\n\n\n<p>Katra v\u0113rt\u012bba tiek par\u0101d\u012bta ar proporcion\u0101lu joslu. Uzreiz uzziniet, kuras kategorijas ir vado\u0161\u0101s vai atpaliek. Nav nepiecie\u0161ama pr\u0101ta matem\u0101tika - mode\u013ci par\u0101d\u0101s vizu\u0101li.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-2 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:15% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/05\/Progress-Icon.png\" alt=\"\" class=\"size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p style=\"font-size:22px\"><strong>Mazo daudzk\u0101rt\u0146u re\u017e\u012bms<\/strong><\/p>\n\n\n\n<p>Matricas izk\u0101rtojum\u0101 par\u0101diet vair\u0101kus m\u0113r\u012bjumus. Ie\u0146\u0113mumi, izmaksas, pe\u013c\u0146a - katrai kolonnai ir savi ievilkuma joslas. Sal\u012bdziniet da\u017e\u0101das dimensijas vien\u0101 kompakt\u0101 vizu\u0101l\u0101 att\u0113l\u0101.<\/p>\n<\/div><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:15% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Timeline-Icon.png\" alt=\"\" class=\"size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p style=\"font-size:22px\"><strong>Sald\u0113tas kategorijas<\/strong><\/p>\n\n\n\n<p>Kategoriju eti\u0137etes paliek redzamas, kam\u0113r ritiniet pa v\u0113rt\u012bb\u0101m. Nekad nezaud\u0113jiet kontekstu plat\u0101s tabul\u0101s. Vienm\u0113r ziniet, kuru rindu analiz\u0113jat.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-3 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:15% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/05\/Hierarchy-Icon.png\" alt=\"\" class=\"size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p style=\"font-size:22px\"><strong>Rindu izcel\u0161ana<\/strong><\/p>\n\n\n\n<p>Uzvelciet kursoru uz jebkuras vietas, un tiks izcelta visa rinda. Sekojiet l\u012bdzi v\u0113rt\u012bb\u0101m sald\u0113taj\u0101s un v\u0113rt\u012bbu kolonn\u0101s, nezaud\u0113jot vietu. Sinhroniz\u0113ts izcel\u0161ana vis\u0101s jom\u0101s.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:40px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-columns alignwide is-layout-flex wp-container-core-columns-is-layout-4 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:15% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2022\/06\/Performance-Icon.png\" alt=\"\" class=\"size-full\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p style=\"font-size:22px\"><strong>Piln\u012bb\u0101 rea\u0123\u0113<\/strong><\/p>\n\n\n\n<p>Darbojas jebkur\u0101 ekr\u0101na izm\u0113r\u0101. Pane\u013ca fl\u012bzes l\u012bdz pilnekr\u0101na prezent\u0101cij\u0101m. Autom\u0101tiski m\u0113rogo joslas, eti\u0137etes un kolonnas. Visur izskat\u0101s profesion\u0101li.<\/p>\n<\/div><\/div>\n<\/div>\n<\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<\/div><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">K\u0101 s\u0101kt (tas ir mu\u013c\u0137\u012bgi vienk\u0101r\u0161i)<\/h3>\n\n\n\n<p><strong>1. solis:<\/strong> Pieprasiet savu izm\u0113\u0123in\u0101juma licenci zem\u0101k (aiz\u0146em 30 sekundes)<\/p>\n\n\n\n<p><strong>2. solis:<\/strong> Vizu\u0101l\u0101s instal\u0113\u0161ana Power BI (aiz\u0146em 2 min\u016btes)<\/p>\n\n\n\n<p><strong>3. solis:<\/strong> Datu savieno\u0161ana - kategoriju un v\u0113rt\u012bbu lauki (aiz\u0146em 5 min\u016btes)<\/p>\n\n\n\n<p><strong>4. solis:<\/strong> Skatieties, k\u0101 ieinteres\u0113t\u0101s personas beidzot saskata likumsakar\u012bbas skait\u013cos<\/p>\n\n\n\n<p>Tas ir viss. Nek\u0101du konsultantu. Nek\u0101du apm\u0101c\u012bbu sesiju. Nek\u0101du sare\u017e\u0123\u012btu iestat\u012bjumu. Vienk\u0101r\u0161i pievienojiet datus un izmantojiet.<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Kam tas ir dom\u0101ts (un kam tas nav dom\u0101ts)<\/h3>\n\n\n\n<p><strong>Tas ir dom\u0101ts jums, ja:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>J\u016bs esat <strong>FP&amp;A<\/strong> un ir nepiecie\u0161amas tabulas, kas ne tikai par\u0101da datus, bet ar\u012b nodro\u0161ina sazi\u0146u.<\/li>\n\n\n\n<li>J\u016bs esat <strong>Kontrolieris<\/strong> izmaksu centru sal\u012bdzin\u0101jumu att\u0113lo\u0161ana ar vizu\u0101lu kontekstu.<\/li>\n\n\n\n<li>J\u016bs esat <strong>Biznesa anal\u012bti\u0137is<\/strong> inform\u0101cijas pane\u013cu veido\u0161ana, ja tabul\u0101m ir j\u0101st\u0101sta st\u0101sts.<\/li>\n\n\n\n<li>Nepiecie\u0161ams par\u0101d\u012bt vair\u0101kus pas\u0101kumus blakus, izmantojot rindu vizualiz\u0101ciju.<\/li>\n\n\n\n<li>V\u0113laties tabulas ar iesald\u0113t\u0101m kolonn\u0101m, kas ritinot nezaud\u0113 kontekstu.<\/li>\n\n\n\n<li>Jums ir apnicis, ka vad\u012bt\u0101ji ignor\u0113 j\u016bsu tabulas, jo t\u0101s ir tikai skait\u013cu sienas.<\/li>\n\n\n\n<li>J\u016bsu ieinteres\u0113taj\u0101m person\u0101m ir j\u0101redz mode\u013ci, nevis tikai j\u0101lasa skait\u013ci.<\/li>\n<\/ul>\n\n\n\n<p><strong>\u0160is pakalpojums NAV dom\u0101ts jums, ja:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Jums ir nepiecie\u0161ams tikai vienk\u0101r\u0161s datu re\u017e\u0123is bez vizu\u0101liem elementiem (izmantojiet Power BI ieb\u016bv\u0113to).<\/li>\n\n\n\n<li>Jums nav nepiecie\u0161amas rindas joslas vai vizu\u0101ls sal\u012bdzin\u0101jums starp rind\u0101m.<\/li>\n\n\n\n<li>J\u016bs neizmantojat Power BI (tas ir Power BI piel\u0101gotais vizu\u0101lais risin\u0101jums).<\/li>\n\n\n\n<li>J\u016bs mekl\u0113jat bezmaksas programmat\u016bru (\u0161is ir profesion\u0101las klases r\u012bks ar atbalstu).<\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Bie\u017e\u0101k uzdotie jaut\u0101jumi (pirms uzdodat)<\/h3>\n\n\n\n<p><strong>J: Vai tas darbojas ar manu eso\u0161o Power BI datu modeli?<\/strong><br>A: J\u0101. Jums ir nepiecie\u0161ams kategorijas lauks un v\u0113rt\u012bbas lauks. Pievienojiet vair\u0101kas v\u0113rt\u012bbas, lai izmantotu re\u017e\u012bmu Small Multiples (Mazie daudzk\u0101rt\u0146i). Darbojas ar jebkuru datu avotu, ko atbalsta Power BI.<\/p>\n\n\n\n<p><strong>J: Kas ir mazo kopiju re\u017e\u012bms?<\/strong><br>A: V\u0113rt\u012bbas laukam pievienojiet vair\u0101kus pas\u0101kumus. Katram pas\u0101kumam ir sava sleja ar ievilkt\u0101m josl\u0101m. Sal\u012bdziniet ie\u0146\u0113mumus, izmaksas un pe\u013c\u0146u vien\u0101 kompakt\u0101 matricas izk\u0101rtojum\u0101.<\/p>\n\n\n\n<p><strong>J: K\u0101 darbojas rindas joslas?<\/strong><br>A: Katra v\u0113rt\u012bba tiek att\u0113lota ar proporcion\u0101lu joslu, kas m\u0113rogota atbilsto\u0161i kolonnas datu diapazonam. Liel\u0101k\u0101m v\u0113rt\u012bb\u0101m ir gar\u0101kas joslas. Sal\u012bdzin\u0101jums ir t\u016bl\u012bt\u0113js un vizu\u0101ls.<\/p>\n\n\n\n<p><strong>J: Kas ir sald\u0113to kategoriju sleja?<\/strong><br>A: Kategoriju eti\u0137etes paliek piespraustas pa kreisi, kam\u0113r ritiniet v\u0113rt\u012bbu kolonnas. J\u016bs vienm\u0113r redzat, kur\u0101 rind\u0101 skat\u0101ties, pat plat\u0101s tabul\u0101s.<\/p>\n\n\n\n<p><strong>J: Vai es varu piel\u0101got kr\u0101sas, lai t\u0101s atbilstu m\u016bsu uz\u0146\u0113muma z\u012bmolam?<\/strong><br>A: Visu var piel\u0101got. Baru kr\u0101sas. Fona kr\u0101sas. Fontu izm\u0113ri. Kolonnu platums. Piel\u0101gojiet to savam z\u012bmolam.<\/p>\n\n\n\n<p><strong>J: Vai t\u0101 efekt\u012bvi apstr\u0101d\u0101 daudz rindu?<\/strong><br>A: J\u0101. Vizu\u0101l\u0101 inform\u0101cija ir optimiz\u0113ta veiktsp\u0113jai, un t\u0101s atveido\u0161ana ir respons\u012bva, kas piel\u0101gojas j\u016bsu datu lielumam.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Kas notiek p\u0113c izm\u0113\u0123in\u0101juma licences piepras\u012b\u0161anas<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Aizpildiet iepriek\u0161 nor\u0101d\u012bto veidlapu (30 sekundes).<\/li>\n\n\n\n<li>M\u0113s nos\u016bt\u012bsim jums izm\u0113\u0123in\u0101juma licences kodu (24 stundu laik\u0101).<\/li>\n\n\n\n<li>Instal\u0113jiet vizu\u0101lo no Microsoft AppSource (2 min\u016btes).<\/li>\n\n\n\n<li>Ievadiet licences kodu form\u0101ta log\u0101 (10 sekundes).<\/li>\n\n\n\n<li>Savienojat kategorijas un v\u0113rt\u012bbas laukus (2 min\u016btes).<\/li>\n\n\n\n<li>J\u016bs redzat savus datus k\u0101 matricas tabulu ar rindas josl\u0101m.<\/li>\n\n\n\n<li>Pievienojiet vair\u0101k pas\u0101kumu un skatieties, k\u0101 par\u0101d\u0101s mazie daudzk\u0101rt\u0146i.<\/li>\n\n\n\n<li>J\u016bsu finan\u0161u direktors jaut\u0101: \"K\u0101p\u0113c m\u0113s to nebij\u0101m dar\u012bju\u0161i agr\u0101k?\"<\/li>\n<\/ol>\n\n\n\n<p>Tad j\u016bs izlemjat: Turpiniet to izmantot (ieg\u0101d\u0101jieties licenci) vai atgriezieties pie tabul\u0101m, kuras neviens nelasa (l\u016bdzu, nelietojiet).<\/p>\n\n\n\n<div style=\"height:30px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-left\">Pieprasiet izm\u0113\u0123in\u0101juma licenci<\/h3>\n\n\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">V\u0113l viena lieta (Garantija)<\/h3>\n\n\n\n<p>M\u0113s esam p\u0101rliecin\u0101ti, ka \u0161\u012b ir lab\u0101k\u0101 matricas tabulas vizualiz\u0101cija Power BI. Periods. Bet m\u0113s negras\u0101mies tur\u0113t j\u016bsu naudu k\u0101 \u0137\u012blnieku, ja j\u016bs tam nepiekr\u012btat.<\/p>\n\n\n\n<p>Izm\u0113\u0123iniet izm\u0113\u0123in\u0101juma licenci. Ja t\u0101 neatt\u0113lo j\u016bsu datus ar skaidriem rindas josl\u0101m, neveic vienm\u0113r\u012bgu mazo reizin\u0101jumu apstr\u0101di vai nepadara j\u016bsu tabulas viegl\u0101k las\u0101mas - vienk\u0101r\u0161i past\u0101stiet mums par to. M\u0113s to atrisin\u0101sim vai atmaks\u0101sim jums naudu. Nav nek\u0101du ap\u013cu.<\/p>\n\n\n\n<p>M\u0113s to izveidoj\u0101m, jo bij\u0101m neapmierin\u0101ti ar Power BI tabul\u0101m. M\u0113s to izmantojam. M\u016bsu klienti to izmanto vad\u012bbas pane\u013ciem. Tas darbojas.<\/p>\n\n\n\n<p><strong>Pieprasiet savu izm\u0113\u0123in\u0101juma licenci zem\u0101k. P\u0101rbaudiet, k\u0101 tas darbojas j\u016bsu vid\u0113 ar j\u016bsu datiem.<\/strong><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">No izpilddirektora (k\u0101p\u0113c m\u0113s to izveidoj\u0101m)<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" class=\"wp-image-10452\" style=\"width: 150px;\" src=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile.png\" alt=\"\" srcset=\"https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile.png 612w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile-300x300.png 300w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile-150x150.png 150w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile-370x370.png 370w, https:\/\/www.leaplytics.de\/wp-content\/uploads\/2023\/01\/stefan-profile-60x60.png 60w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/p>\n\n\n\n<p>Es esmu Stefans. LeapLytics izpilddirektors.<br><br>M\u0113s to izveidoj\u0101m, jo Power BI tabulas bija boj\u0101tas.<br><br>Katras tabulas vizu\u0101lais noform\u0113jums bija vai nu p\u0101r\u0101k vienk\u0101r\u0161s (tikai skait\u013ci, bez vizu\u0101l\u0101 noform\u0113juma), vai ar\u012b p\u0101r\u0101k sare\u017e\u0123\u012bts (bija nepiecie\u0161ama piel\u0101gota izstr\u0101de, lai pievienotu iek\u0161\u0113j\u0101s diagrammas).<br><br>Finan\u0161u speci\u0101listu komandas iepaz\u012bstin\u0101ja ar skait\u013cu sienu, ko vad\u012bt\u0101ji izlaida cauri. Kontrolieri nevar\u0113ja par\u0101d\u012bt izmaksu centru sal\u012bdzin\u0101jumus ar vizu\u0101lu kontekstu. FP&amp;A bija j\u0101veido atsevi\u0161\u0137as diagrammas, lai vizualiz\u0113tu tos pa\u0161us datus, kas jau bija tabul\u0101s.<br><br>T\u0101p\u0113c m\u0113s izveidoj\u0101m to, ko paties\u012bb\u0101 v\u0113l\u0113j\u0101mies:<br><br>\u2192 Slejas joslu diagrammas katr\u0101 rind\u0101 (nevis atsevi\u0161\u0137as vizualiz\u0101cijas)<br>\u2192 Mazo daudzk\u0101rt\u0146u re\u017e\u012bms vair\u0101ku m\u0113r\u012bjumu sal\u012bdzin\u0101\u0161anai (ne vair\u0101k\u0101m tabul\u0101m)<br>\u2192 Iesald\u0113tas kategoriju kolonnas, kas saglab\u0101 kontekstu (nevis \"ritiniet un aizmirstiet\").<br>\u2192 Sinhroniz\u0113ta rindu izcel\u0161ana (nevis \"kur\u0101 rind\u0101 es biju?\")<br>\u2192 Rea\u0123\u0113jo\u0161s dizains, kas darbojas visur (nevis \"manu\u0101li main\u012bt izm\u0113ru\")<br>\u2192 Dinamiski virsraksti no j\u016bsu datiem (nevis kod\u0113tas eti\u0137etes).<br><br>\u0160o r\u012bku izmantojam iek\u0161\u0113ji. M\u016bsu konsult\u0101ciju klienti to izmanto vad\u012bbas pane\u013ciem. Tas nav nevainojams, bet tas ir lab\u0101kais matricas tabulas vizu\u0101lais r\u012bks Power BI. \u013boti.<br><br>Ja prezent\u0113jat tabulas datus un jums ir nepiecie\u0161ama vizu\u0101la sazi\u0146a, \u0161is ir dom\u0101ts tie\u0161i jums.<br><br>Stefans Preuslers<br>LeapLytics GmbH izpilddirektors<\/p>\n<\/blockquote>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading has-text-align-left\" id=\"tutorial\">S\u0101kt<\/h3>\n\n\n\n<p>Pieprasiet savu izm\u0113\u0123in\u0101juma licenci iepriek\u0161. M\u0113s nos\u016bt\u012bsim jums kodu 24 stundu laik\u0101. Instal\u0113jiet no AppSource. Ievadiet licenci. Pievienojiet savus datus. Redziet, k\u0101 j\u016bsu tabulas atdz\u012bvojas.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Pilns funkciju saraksts (lai j\u016bs prec\u012bzi zin\u0101tu, ko sa\u0146emat)<\/h3>\n\n\n\n<p><strong>Inline vizualiz\u0101cija:<\/strong> Proporcion\u0101las joslu diagrammas katr\u0101 \u0161\u016bn\u0101 - Autom\u0101tiska m\u0113rogo\u0161ana katr\u0101 slej\u0101 - Vizu\u0101ls sal\u012bdzin\u0101jums starp rind\u0101m - T\u016bl\u012bt\u0113ja mode\u013ca atpaz\u012b\u0161ana - Kr\u0101saini joslas kodi<\/p>\n\n\n\n<p><strong>Mazo daudzk\u0101rt\u0146u re\u017e\u012bms:<\/strong> Vair\u0101ki m\u0113r\u012bjumi viens otram blakus - Matricas izk\u0101rtojums ar rindas josl\u0101m katram m\u0113r\u012bjumam - Kategoriju un m\u0113r\u012bjumu sal\u012bdzin\u0101\u0161ana - Asu l\u012bnijas vis\u0101m kolonn\u0101m - M\u0113r\u012bjumu nosaukumi galven\u0113s.<\/p>\n\n\n\n<p><strong>Sasalu\u0161as kolonnas:<\/strong> Kategoriju sleja paliek redzama - Ritiniet v\u0113rt\u012bbas, nezaud\u0113jot kontekstu - Sinhroniz\u0113tas fona kr\u0101sas - Profesion\u0101ls fiks\u0113tu kolonnu izk\u0101rtojums<\/p>\n\n\n\n<p><strong>Rindu mijiedarb\u012bba:<\/strong> Sinhroniz\u0113ta pasv\u012bduma izcel\u0161ana - Pilna rindu izcel\u0161ana sald\u0113taj\u0101s un v\u0113rt\u012bbu zon\u0101s - Konteksta izv\u0113lnes atbalsts - Noklik\u0161\u0137iniet, lai atlas\u012btu un \u0161\u0137\u0113rsfiltru.<\/p>\n\n\n\n<p><strong>Dinamisk\u0101s galvenes:<\/strong> Virsraksti no datu lomas r\u0101d\u012b\u0161anas nosaukumiem - Kolonnu virsraksti no m\u0113r\u012bjumu nosaukumiem - Autom\u0101tiska mar\u0137\u0113\u0161ana no j\u016bsu datu mode\u013ca - Nav nekod\u0113ta teksta.<\/p>\n\n\n\n<p><strong>Eti\u0137etes un format\u0113\u0161ana:<\/strong> V\u0113rt\u012bbu eti\u0137etes \u0161\u016bn\u0101s - Skait\u013cu format\u0113\u0161anas atbalsts - Rea\u0123\u0113jo\u0161a fontu izm\u0113ra noteik\u0161ana - Skaidra eti\u0137e\u0161u pozicion\u0113\u0161ana - Samazin\u0101ts aizpild\u012bjums kompaktam displejam<\/p>\n\n\n\n<p><strong>Kr\u0101sas un stils:<\/strong> Piel\u0101gojamas joslu kr\u0101sas - Fona kr\u0101sas kontrole - Atbilsto\u0161s sald\u0113t\u0101s kolonnas fons - Profesion\u0101ls izskats - Gatavs korporat\u012bvajam z\u012bmolojumam<\/p>\n\n\n\n<p><strong>Power BI integr\u0101cija:<\/strong> Savstarp\u0113ja filtr\u0113\u0161ana - Atlases atbalsts - Viet\u0113j\u0101 konteksta izv\u0113lne - R\u012bkjoslu atbalsts - Sader\u012bba ar gr\u0101matz\u012bm\u0113m - Eksport\u0113\u0161ana uz PDF\/PowerPoint - Form\u0101ta pane\u013ca konfigur\u0101cija<\/p>\n\n\n\n<p><strong>Respons\u012bvais dizains:<\/strong> Darbojas no maz\u0101m fl\u012bz\u0113m l\u012bdz 4K - Visi elementi proporcion\u0101li m\u0113rogojas - Slejas piel\u0101gojas kolonnas platumam - Eti\u0137etes atbilst pieejamai vietai - Nav nepiecie\u0161ams manu\u0101li piel\u0101got izm\u0113rus.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ko j\u016bs sa\u0146emat<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Skatiet savu datu st\u0101stu \u012bsum\u0101<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Sazi\u0146ai atbilsto\u0161as rindas joslas<\/strong>: Katrai v\u0113rt\u012bbai tiek par\u0101d\u012bta proporcion\u0101la josla - izl\u0113cienu mode\u013ci, sal\u012bdzin\u0101jumi ir t\u016bl\u012bt\u0113ji, nav nepiecie\u0161ama gar\u012bg\u0101 matem\u0101tika.<\/li>\n\n\n\n<li><strong>Re\u0101la Power BI integr\u0101cija<\/strong>: Noklik\u0161\u0137iniet uz rindas \u0161eit, filtr\u0113jiet visu tur - viss pane\u013ca pane\u013ca r\u0101d\u012bt\u0101js tiek atjaunin\u0101ts, jo tas ir veidots, izmantojot Power BI arhitekt\u016bru.<\/li>\n\n\n\n<li><strong>Nelieli daudzk\u0101rt\u0146i, kas ir lietder\u012bgi<\/strong>: Vair\u0101ki pas\u0101kumi matricas izk\u0101rtojum\u0101 - ie\u0146\u0113mumi, izmaksas, pe\u013c\u0146a blakus ar vizu\u0101lu kontekstu katram no tiem.<\/li>\n\n\n\n<li><strong>Sald\u0113tas kolonnas re\u0101lai anal\u012bzei<\/strong>: Kategoriju eti\u0137etes paliek redzamas, kam\u0113r j\u016bs p\u0113t\u0101t v\u0113rt\u012bbas - nekad nezaud\u0113jiet inform\u0101ciju par analiz\u0113jamo rindu.<\/li>\n\n\n\n<li><strong>Rea\u0123\u0113 uz visu<\/strong>: Dashboard fl\u012bzes uz pilnekr\u0101na prezent\u0101cij\u0101m - joslas, eti\u0137etes un kolonnas m\u0113rogo autom\u0101tiski.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">P\u0101rtrauciet veidot atsevi\u0161\u0137as diagrammas tabulas datiem<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Inline joslas Aizst\u0101t divk\u0101r\u0161\u0101s diagrammas<\/strong>: Nav nepiecie\u0161ams tabula un joslu diagramma, kas att\u0113lo vienus un tos pa\u0161us datus - ieg\u016bstiet abus vien\u0101 vizu\u0101l\u0101 att\u0113l\u0101.<\/li>\n\n\n\n<li><strong>Mazie daudzk\u0101rt\u0146i aizst\u0101j vair\u0101kus vizu\u0101lus<\/strong>: Sal\u012bdziniet pas\u0101kumus vien\u0101 kompakt\u0101 matric\u0101, nevis tr\u012bs atsevi\u0161\u0137\u0101s tabul\u0101s.<\/li>\n\n\n\n<li><strong>Rindu izcel\u0161ana pal\u012bdz orient\u0113ties<\/strong>: Novietojiet kursoru jebkur\u0101 viet\u0101 un redz\u0113siet, k\u0101 iedegas visa rinda - bez piep\u016bles varat sekot p\u0101ri kolonn\u0101m.<\/li>\n\n\n\n<li><strong>Dinamisk\u0101s galvenes no j\u016bsu datiem<\/strong>: Pas\u0101kumu nosaukumi autom\u0101tiski k\u013c\u016bst par kolonnu nosaukumiem - nav manu\u0101las mar\u0137\u0113\u0161anas.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">J\u016bsu dati. J\u016bsu veids. Bez probl\u0113m\u0101m.<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Vienk\u0101r\u0161as datu pras\u012bbas<\/strong>: Kategoriju lauks, V\u0113rt\u012bbu lauks - pievienojiet vair\u0101k v\u0113rt\u012bbu mazajiem daudzk\u0101rt\u0146iem<\/li>\n\n\n\n<li><strong>Darbojas ar jebkuru avotu<\/strong>: Excel, SQL, SAP, Oracle, Dynamics - ja Power BI var izveidot savienojumu ar to, m\u0113s varam to vizualiz\u0113t.<\/li>\n\n\n\n<li><strong>Tie\u0161raides dati, nevis ekr\u0101n\u0161\u0101vi\u0146i<\/strong>: Atjauniniet datu kopu un vizu\u0101los atjaunin\u0101jumus - skatiet \u0161odienas, nevis pag\u0101ju\u0161\u0101s ned\u0113\u013cas skait\u013cus.<\/li>\n\n\n\n<li><strong>T\u016bl\u012bt\u0113js vizu\u0101lais konteksts<\/strong>: Pievienojiet savus datus, un rindas joslas par\u0101d\u012bsies autom\u0101tiski - nav nepiecie\u0161ama nek\u0101da konfigur\u0101cija.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Izskat\u0101s profesion\u0101li bez p\u016bl\u0113m<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Piel\u0101gojiet kr\u0101sas, lai t\u0101s atbilstu j\u016bsu z\u012bmolam<\/strong>: Bar kr\u0101sas, foni - iestatiet savas korporat\u012bv\u0101s kr\u0101sas da\u017eu sekun\u017eu laik\u0101.<\/li>\n\n\n\n<li><strong>Eti\u0137etes, kas der<\/strong>: Vieda pozicion\u0113\u0161ana, piel\u0101gota izm\u0113ra noteik\u0161ana, t\u012brs format\u0113jums katr\u0101 \u0161\u016bn\u0101<\/li>\n\n\n\n<li><strong>T\u012brs profesion\u0101ls izskats<\/strong>: Paredz\u0113ts vad\u012bbas pane\u013ciem un valdes prezent\u0101cij\u0101m.<\/li>\n\n\n\n<li><strong>Viendab\u012bga vis\u0101s ier\u012bc\u0113s<\/strong>: Kl\u0113pjdators, galddators, plan\u0161etdators - visur izskat\u0101s profesion\u0101li<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Uz\u0146\u0113mums gatavs<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Optimiz\u0113ta veiktsp\u0113ja<\/strong>: Efekt\u012bva lielu datu kopu atveido\u0161ana<\/li>\n\n\n\n<li><strong>Dro\u0161\u012bbas pras\u012bb\u0101m atbilst\u012bgs<\/strong>: Nav datu p\u0101rraides \u0101rpus Power BI vides<\/li>\n\n\n\n<li><strong>Licen\u010du p\u0101rvald\u012bba<\/strong>: Uz\u0146\u0113muma licenc\u0113\u0161ana ar valid\u0101ciju<\/li>\n\n\n\n<li><strong>Profesion\u0101ls atbalsts<\/strong>: Re\u0101li cilv\u0113ki, kas saprot finanses un Power BI<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>The Only Matrix Table Built for Finance Teams Who Need Numbers AND Visuals in Power BI If you&#8217;re presenting financial data in Power BI and stakeholders keep squinting at rows of numbers&#8230; if you&#8217;re manually adding sparklines in Excel because Power BI&#8217;s native tables can&#8217;t show inline bars&#8230; if your CFO wants to see categories &hellip; <\/p>","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-14568","page","type-page","status-publish","hentry","latest_post"],"_links":{"self":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages\/14568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/comments?post=14568"}],"version-history":[{"count":2,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages\/14568\/revisions"}],"predecessor-version":[{"id":14579,"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/pages\/14568\/revisions\/14579"}],"wp:attachment":[{"href":"https:\/\/www.leaplytics.de\/lv\/wp-json\/wp\/v2\/media?parent=14568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}