bi
15 TopicsAnálisis Vertical y Horizontal de Estados Financieros con PowerBI
Análisis Vertical y Horizontal de Estados Financieros con PowerBI Las herramientas de Business Intelligence ayudan a empoderar a los usuarios del negocio de sus datos para poder gestionar información a medida desde prácticamente cualquier fuente de datos. En esta sesión, nos meteremos con los analistas financieros, los contadores, los dueños de negocios, que lidian mensualmente con la presentación y el análisis de informes financieros, comparar presente y pasado, conocer la composición de una cuenta, y cuyas principales decisiones se basan en la salud financiera de la empresa, Acompáñanos a aprender sobre: Estructura, Visualización y Funciones DAX, para poder presentar: Análisis Vertical y Horizontal de Estados Financieros con PowerBI696Views0likes0CommentsMartigny - 2ème rencontre du User Group Power BI/Fabric en Valais [SUR SITE]
Rejoignez le prochain User Group Power BI / Fabric à Martigny ! Nous sommes ravis de vous inviter à la prochaine rencontre du User Group Power BI/Fabric qui se tiendra le 27 septembre prochain à 16h15, à l'occasion de l'ouverture de la foire du Valais à Martigny. Agenda 16h00 - 16h15 Accueil des participants 16h15 - 16h30 Mot de bienvenue, introduction 16h30 - 17h00 De la Self-Service BI à la BI d'entreprise, l'importance de la gouvernance Power BI 17h00 - 17h30 Des données aux actes : dynamiser ses rapports avec Data Activator 17h30 - 18h00 Apéritif Pourquoi participer ? - Partage d'expériences : Échangez avec d'autres passionnés de Power BI et Fabric, partagez vos astuces et résolvez ensemble vos problématiques. - Veille technologique : Soyez les premiers informés des dernières nouveautés et tendances du marché. - Networking : Développez votre réseau professionnel et rencontrez de nouveaux partenaires. Synchrotech vous accueille dans l'Innothèque, un espace dédié à l'innovation proposé par CimArk dans le cadre de la Foire du Valais. Cet environnement stimulant sera propice aux échanges et à la découverte. Les places sont limitées à 40 personnes. N'attendez plus et inscrivez-vous dès aujourd'hui ! Infos pratiques : - Utilisez ce formulaire dans le cas où vous auriez besoin d'un billet d'entrée pour la Foire du Valais ce jour-là - Accès et mobilité - Foire du Valais, Martigny Nous avons hâte de vous retrouver nombreux à cette occasion !633Views0likes0CommentsLa antimateria del BI: Tablas de NO Hechos
En esta sesión hablaremos de tablas de hechos, de hechos sin hechos y tablas de no hechos haciendo una comparación con temas de la física. Para un arquitecto de datos o analista de negocio representa un cambio de paradigma importante de como modelar y como brindar una compresión mucho más profunda del negocio. Veremos casos prácticos y en una sesión altamente interactiva podrán los asistentes agregar poderosas herramientas de análisis a su caja de herramientas.3.1KViews0likes0CommentsFribourg - Prochaine rencontre du User Group Power BI/Fabric [REPORTÉ]
Nous sommes ravis de vous inviter à la prochaine rencontre du User Group Power BI/Fabric. La prochaine rencontre initialement prévue le 7 novembre est REPORTÉE. La nouvelle date sera communiquée dès que possible. Agenda 17h00 - 17h10 Accueil des participants et mot de bienvenue 17h10 - 17h30 De la Self-Service BI à la BI d'entreprise, l'importance de la gouvernance Power BI 17h30 - 17h50 Des données aux actes : dynamiser ses rapports avec Data Activator 17h50 - 18h10 Positionnement des données : de l'opérationnel à l'Analytics 18h10 - 19h00 Apéritif Pourquoi participer ? - Partage d'expériences : Échangez avec d'autres passionnés de Power BI et Fabric, partagez vos astuces et résolvez ensemble vos problématiques. - Veille technologique : Soyez les premiers informés des dernières nouveautés et tendances du marché. - Networking : Développez votre réseau professionnel et rencontrez de nouveaux partenaires. Les places sont limitées à 30 personnes. N'attendez plus et inscrivez-vous sur cette page dès aujourd'hui ! Nous avons hâte de vous retrouver nombreux à cette occasion !375Views0likes0CommentsL’architecture ultime d’un projet Power BI
La quantité d’outils mis à la disposition des développeurs pour réaliser des projets Power BI est étourdissante. L’ajout de Microsoft Fabric n’aura pas amélioré la situation, car cette plateforme mélange les outils spécialisés et souvent immatures de tous les métiers de la donnée. Il en résulte de mauvaises combinaisons d’outils, des efforts de développements moins efficaces et une incapacité de séparer clairement les rôles entre les équipes TI et affaires. C’est basé sur l’expérience d’une centaine de projets que l’auteur de la conférence vous présente une architecture ultime de projets Power BI. Vous comprendrez le rôle des outils les plus pertinents, leurs forces et leurs faiblesses, ainsi que la séparation des tâches dans une organisation idéale.Power BI - Deneb visual - Read a JSON to create the visuals
Hi everyone, I have a graphic which work correctly. I use at the moment a table in power BI dedicated for this visual. It seems possible for deneb to read JSON data because when I provide the original table with the JSON column, I can see the data but when I try to use JSON.parse(), I have lot of errors Please find my current code which work perfectly from my Power BI. { "$schema": "https://vega.github.io/schema/vega/v5.json", "description": "Final trusted version with a correctly implemented 'No Schedule Data' message.", "width": 372, "height": 48, "signals": [ { "name": "pbi_time_offset_seconds", "init": "isValid(data('pbi_summarize')[0]) ? data('pbi_summarize')[0].DST_ClockDiffBtwLocationAndLocalOffset : 0" }, { "name": "utc_now", "init": "now()", "on": [ { "events": {"type": "timer", "throttle": 10000}, "update": "now()" } ] }, { "name": "remote_now", "update": "utc_now + (pbi_time_offset_seconds * 1000)" }, { "name": "remote_day", "update": "day(remote_now)" }, { "name": "remote_hour_decimal", "update": "hours(remote_now) + (minutes(remote_now) / 60) + (seconds(remote_now) / 3600)" }, { "name": "remote_time_label", "update": "timeFormat(remote_now, '%H:%M')" }, { "name": "has_data_for_today", "update": "data('daily_schedule').length > 0" } ], "data": [ { "name": "dataset" }, { "name": "pbi_summarize" }, { "name": "daily_schedule", "source": "dataset", "transform": [ {"type": "filter", "expr": "datum.day_num != null && datum.day_num == remote_day"} ] }, { "name": "schedule_bands", "source": "daily_schedule", "transform": [ { "type": "filter", "expr": "datum.ScheduleType == 'Production' || datum.ScheduleType == 'ITSupport'" }, { "type": "formula", "as": "display_type", "expr": "datum.type == 'Normal' ? (datum.ScheduleType == 'Production' ? 'Working hours' : 'Support hours') : datum.type == 'Flexible' ? 'Flexible hours' : 'No Working hours'" } ] }, { "name": "site_opening_start", "source": "daily_schedule", "transform": [ {"type": "filter", "expr": "datum.ScheduleType == 'SiteOpening'"}, {"type": "project", "fields": ["startTime"], "as": ["time_value"]} ] }, { "name": "site_opening_end", "source": "daily_schedule", "transform": [ {"type": "filter", "expr": "datum.ScheduleType == 'SiteOpening'"}, {"type": "project", "fields": ["endTime"], "as": ["time_value"]} ] } ], "scales": [ { "name": "xscale", "type": "linear", "range": "width", "domain": [0, 24] }, { "name": "yscale", "type": "band", "range": [1, 50], "domain": ["ITSupport", "Production"], "padding": 0.1 }, { "name": "color", "type": "ordinal", "domain": ["Working hours", "Support hours", "Flexible hours", "No Working hours"], "range": ["#a6cee3", "#b2df8a", "#1f78b4", "#d3d3d3"] } ], "axes": [ { "orient": "bottom", "scale": "xscale", "tickCount": 25, "title": { "signal": "timeFormat(remote_now, 'Time & Day (%Y-%m-%d)')" }, "labelFontSize": 9, "titleFontSize": 9 } ], "marks": [ { "type": "group", "name": "custom_legend", "encode": {"enter": {"x": {"value": 0}, "y": {"value": -40}}}, "marks": [ {"type": "rect", "encode": {"enter": {"x": {"value": 0}, "y": {"value": 0}, "width": {"value": 10}, "height": {"value": 10}, "fill": {"value": "#a6cee3"}}}}, {"type": "text", "encode": {"enter": {"x": {"value": 15}, "y": {"value": 9}, "text": {"value": "Working hours"}, "fontSize": {"value": 10}, "align": {"value": "left"}}}}, {"type": "rect", "encode": {"enter": {"x": {"value": 120}, "y": {"value": 0}, "width": {"value": 10}, "height": {"value": 10}, "fill": {"value": "#1f78b4"}}}}, {"type": "text", "encode": {"enter": {"x": {"value": 135}, "y": {"value": 9}, "text": {"value": "Flexible hours"}, "fontSize": {"value": 10}, "align": {"value": "left"}}}}, {"type": "rect", "encode": {"enter": {"x": {"value": 240}, "y": {"value": 0}, "width": {"value": 10}, "height": {"value": 10}, "fill": {"value": "#d3d3d3"}}}}, {"type": "text", "encode": {"enter": {"x": {"value": 255}, "y": {"value": 9}, "text": {"value": "No Working hours"}, "fontSize": {"value": 10}, "align": {"value": "left"}}}}, {"type": "rect", "encode": {"enter": {"x": {"value": 0}, "y": {"value": 15}, "width": {"value": 10}, "height": {"value": 10}, "fill": {"value": "#b2df8a"}}}}, {"type": "text", "encode": {"enter": {"x": {"value": 15}, "y": {"value": 24}, "text": {"value": "Support hours"}, "fontSize": {"value": 10}, "align": {"value": "left"}}}}, {"type": "rule", "encode": {"enter": {"x": {"value": 122}, "y": {"value": 13}, "x2": {"value": 122}, "y2": {"value": 23}, "stroke": {"value": "black"}}}}, {"type": "symbol", "encode": {"enter": {"x": {"value": 122}, "y": {"value": 22}, "shape": {"value": "triangle-up"}, "size": {"value": 25}, "fill": {"value": "black"}}}}, {"type": "rule", "encode": {"enter": {"x": {"value": 128}, "y": {"value": 15}, "x2": {"value": 128}, "y2": {"value": 24}, "stroke": {"value": "black"}}}}, {"type": "symbol", "encode": {"enter": {"x": {"value": 128}, "y": {"value": 15}, "shape": {"value": "triangle-down"}, "size": {"value": 25}, "fill": {"value": "black"}}}}, {"type": "text", "encode": {"enter": {"x": {"value": 135}, "y": {"value": 24}, "text": {"value": "Site Opening"}, "fontSize": {"value": 10}, "align": {"value": "left"}}}} ] }, { "type": "text", "interactive": false, "encode": { "enter": { "x": {"field": {"group": "width"}, "mult": 0.5}, "y": {"field": {"group": "height"}, "mult": 0.5}, "text": {"value": "No Schedule Data for Today"}, "fontSize": {"value": 12}, "fontWeight": {"value": "bold"}, "fill": {"value": "gray"}, "align": {"value": "center"} }, "update": { "opacity": [{"test": "has_data_for_today", "value": 0}, {"value": 1}] } } }, { "type": "rect", "from": {"data": "schedule_bands"}, "encode": { "enter": { "x": {"scale": "xscale", "field": "startTime"}, "x2": {"scale": "xscale", "field": "endTime"}, "y": {"scale": "yscale", "field": "ScheduleType"}, "height": {"scale": "yscale", "band": 1}, "fill": {"scale": "color", "field": "display_type"} }, "update": { "opacity": [{"test": "has_data_for_today", "value": 1}, {"value": 0}] } } }, { "type": "rule", "from": {"data": "site_opening_start"}, "encode": { "enter": {"x": {"scale": "xscale", "field": "time_value"}, "y": {"value": 0}, "y2": {"value": 50}, "stroke": {"value": "black"}, "strokeWidth": {"value": 2}}, "update": {"opacity": [{"test": "has_data_for_today", "value": 1}, {"value": 0}]} } }, { "type": "symbol", "from": {"data": "site_opening_start"}, "encode": { "enter": {"x": {"scale": "xscale", "field": "time_value"}, "y": {"value": 50}, "shape": {"value": "triangle-up"}, "size": {"value": 50}, "fill": {"value": "black"}}, "update": {"opacity": [{"test": "has_data_for_today", "value": 1}, {"value": 0}]} } }, { "type": "rule", "from": {"data": "site_opening_end"}, "encode": { "enter": {"x": {"scale": "xscale", "field": "time_value"}, "y": {"value": 0}, "y2": {"value": 50}, "stroke": {"value": "black"}, "strokeWidth": {"value": 2}}, "update": {"opacity": [{"test": "has_data_for_today", "value": 1}, {"value": 0}]} } }, { "type": "symbol", "from": {"data": "site_opening_end"}, "encode": { "enter": {"x": {"scale": "xscale", "field": "time_value"}, "y": {"value": 3}, "shape": {"value": "triangle-down"}, "size": {"value": 50}, "fill": {"value": "black"}}, "update": {"opacity": [{"test": "has_data_for_today", "value": 1}, {"value": 0}]} } }, { "type": "rule", "encode": { "update": { "x": {"scale": "xscale", "signal": "remote_hour_decimal"}, "y": {"value": 2}, "y2": {"value": 50}, "stroke": {"value": "red"}, "strokeWidth": {"value": 2} } } }, { "type": "text", "encode": { "update": { "x": {"scale": "xscale", "signal": "remote_hour_decimal"}, "y": {"value": 3}, "text": {"signal": "remote_time_label"}, "baseline": {"value": "bottom"}, "align": {"value": "center"}, "fill": {"value": "red"} } } } ] } Please find an example of my JSON file stored in Sharepoint (Text multi-lines) {"schedule_rules":[{"day_num":"0","segments":[{"approval_needed":null,"communication_needed":"Mandatory","end_time":"23:59","start_time":"00:00","type":"No Production"}]},{"day_num":"1","segments":[{"approval_needed":"Yes","communication_needed":null,"end_time":"12:30","start_time":"08:30","type":"Normal"},{"approval_needed":"Yes","communication_needed":null,"end_time":"16:30","start_time":"13:30","type":"Normal"}]},{"day_num":"2","segments":[{"approval_needed":"Yes","communication_needed":null,"end_time":"12:30","start_time":"08:30","type":"Normal"},{"approval_needed":"Yes","communication_needed":null,"end_time":"16:30","start_time":"13:30","type":"Normal"}]},{"day_num":"3","segments":[{"approval_needed":"Yes","communication_needed":null,"end_time":"12:30","start_time":"08:30","type":"Normal"},{"approval_needed":"Yes","communication_needed":null,"end_time":"16:30","start_time":"13:30","type":"Normal"}]},{"day_num":"4","segments":[{"approval_needed":"Yes","communication_needed":null,"end_time":"12:30","start_time":"08:30","type":"Normal"},{"approval_needed":"Yes","communication_needed":null,"end_time":"16:30","start_time":"13:30","type":"Normal"}]},{"day_num":"5","segments":[{"approval_needed":"Yes","communication_needed":null,"end_time":"12:30","start_time":"08:30","type":"Normal"},{"approval_needed":"Yes","communication_needed":null,"end_time":"16:30","start_time":"13:30","type":"Normal"}]},{"day_num":"6","segments":[{"approval_needed":null,"communication_needed":"Mandatory","end_time":"23:59","start_time":"00:00","type":"No Production"}]}]} How to import this JSON in Deneb ? I tried with JSON.parse but fails each time Thank you for your supportSolvedBest choice of custom visual
Hello, I've been asked to prepare a visualisation in line with the following example: I'm somewhat stumped with regards to which custom visual (if any) to pick, and thought to branch out to the wisdom of the Power BI-community 🙂 Any and all assistance in this matter would be greatly appreciated! Best regardsPowerBI: Create Burndown Chart
HI all, I am having trouble using measurements to create a dynamic calculated values for TotalHours, RemainingHours and TotalUserStoryPts so that I can create a burndown in PowerBI. Goal: Create a burndown chart using the following data: Sprint Start = 8/8/2022 Sprint End = 8/20/2022Solved6.7KViews0likes3CommentsHow to get the count of Products where actuals+forecast values are greater than 0 in a card visual?
Hi All, In a card visual, I have used a measure which takes the distinct count of product no. Now in additional to that, I have to include a logic to get the distinct count of product no where Actuals + Forecast > 0. In the below example, the distinct count of product no where Actuals + Forecast > 0 is 4. This logic I need to achieve in a Card visual. Can anybody help me with the logic here? Product No Actuals Forecast 1 0 30 2 0 0 3 65 100 4 50 0 5 0 0 6 100 150 Thanks in advance!!Solved550Views0likes1Comment