RobertoMirelman

DAX: calculating maximum period of LSA non-compliance from individual probe readings

The Problem The contractor has to maintain the values of n probes under a certain threshold.Data is measured each 5 minutes, 24 hours per day.An incident is defined as the period while a probe readings are continuously over the thresholdLSA is based on the number of incidents in a month, and the maximum period of …

DAX: calculating maximum period of LSA non-compliance from individual probe readings Read More »

Power BI Embedded

MS POWER BI is occupying a leading share in today’s market of BI and Reporting tools, for its ease of integration with other Microsoft products, and the versatility of the range of products offered. This Power BI functionality allows you to use reporting reports, dashboards, and visuals in a desktop app or web page. There …

Power BI Embedded Read More »

Context Propagation details and other surprises while doing a ranking calculation

During my PowerBI courses, one of the topics that presents the most difficulties and surprises for the participants is to understand what the evaluation context is, what is the row context, the filter context, and above all, the propagation of contexts. Microsoft, as it usually does for its popular products, hides internal complexities to “facilitate” …

Context Propagation details and other surprises while doing a ranking calculation Read More »

Enable BBDD on MV (VMWARE) for access from a DATAFLOW POWERBI (step-by-step)

Leave a comment / BI & Reporting, Training Courses / By RobertoMirelman / 4 June 2020 5 June 2020 Dataflows that can be created within a PowerBI Service Workspace (Pro or Premium licensed), are useful for reusing the logic developed with PowerQuery while making ETL processes (M scripts), so we can have queries with the …

Enable BBDD on MV (VMWARE) for access from a DATAFLOW POWERBI (step-by-step) Read More »

Types of Reports

Depending on their purpose and the profile of their recipients, we can characterize three distinct types of reports. Dashboard Summary report, with clear indicators on the current situation Single page Typical visuals: Traffic lights, KPIs, Indicators (Gauge) Aimed at: command level Analytical Reports Detailed report with ratings Multiple pages Typical Visuals: Line Charts, Correlation, Bar …

Types of Reports Read More »

BI & Reporting: What is a Report?

Data-Based Management Reports In my experience as a teacher in BI and Reporting courses, I meet people with various profiles: from technicians to administrative, from operatives to senior managers. The perception of what a report is is different for each profile. For organizations and companies that want data-driven management, the reports represent the foundation for …

BI & Reporting: What is a Report? Read More »