Adam's Perspective on Data

Adam VEGH

  • Corrupted Measures on Measure Drill-through page

    I’ve just faced an interesting issue in Power BI when I tried to setup a new measure on a page which is a drill-through page by measure. Scenario: I have a measure, call it Nr of Deliveries. This measure is based on a Order Table, which have Order Date and Delivery Date assigned to the…

    Adam VEGH

  • Override When Created/Modified trigger on SQL Server

    I’ve recently fallen into trouble when I wanted to setup a new workflow in Logic Apps. The scenario was pretty simple. Do something when a new Item is created in an on-prem SQL Server data table. This scenario was one of the basic methods learning materials was covering so I’ve started the creation of the…

    Adam VEGH

    , ,

  • The “Data Ferrari” vs “Data Toyota”

    When I’ve learned about data engineering and started to setup our own system first I was in trouble how to do that the best way. How the architecture should look like for our exact needs? Those questions were even harder after having some consultations with other experts and completing more and more training materials. Ultimately the…

    Adam VEGH

    , , , ,

  • Dynamic Column Level Security

    I had a project in 2023 in my work where I should secure one column in the data or let’s say a level of data but in a dynamic way. Imaging that as a normal business users you can see Costs and Revenue for the different product categories and their Margin. It is public for…

    Adam VEGH

  • Linear Regression with DAX

    I’m not sure is the new LINEST and LINESTX functions were introduced in 2022 or 2023 but I immediately saw they are very useful ones. Definitely their main purpose is to work on linear regression with that you can predict some future values, but I found another aspect I could use them effectively. The scenario:…

    Adam VEGH

  • Data Visualization Challenges are great to improve your skills

    I was participating a few visualization challenges in 2022 and 2023 organized by Maven Analytics. The concept is pretty simple. You can download a dataset from the challenge’s portal about a specific topic. For example, you are consulting a Pizza Restaurant and you should create a one pages report to show them how they can…

    Adam VEGH

  • I’m starting it

    Hello Dear Visitor, My name is Adam VEGH and I’m from Hungary. I’m living in a small village together with my beautiful family. I’m working with data from multiple perspectives. Started my career as a Data Analyst / BI Developer, but then I could widen my knowledge and I’ve become a Data Engineer. Recently I’ve…

    Adam VEGH