Adam VEGH
-
Time Travel with Data – Use cases and techniques
Data Historization is a pretty frequent need in data analytics that should be managed at some point in most of the companies. Let’s just think about the following use case. A company is having it’s sales order backlog in it’s ERP system. Management is interested in the backlog, but not only how much it is…
-
GANTT Chart with Custom SVG Image
In the last couple of days I spent some time learning a bit more about SVG images and their usage in Power BI. There are actually a lot of fun in that stuff, and a lot a things can be solved to create a visual as you want. First I was having some tiny tests…
-
GANTT chart using native visual in Power BI
Let me share you a method in Power BI with that a Gantt chart of projects can be created without using custom visuals. I’m using a single Clustered Bar Chart and setting it’s formatting capabilities.
-
Consolidating and Enriching Multiple Excel Sheets
In excel it happens often that multiple sheets should be consolidated in one and that should be enriched with a higher level grouping. In this short post I’m showing you how you can use Power Query to do that in a dynamic way in no more that 3 minutes. Cheers!
-
Starting my Journey in Fabric
This week I’m starting an interesting new journey with Microsoft Fabric. At my company now we have a solid data architecture with Synapse Analytics, dedicated SQL Pool and Power BI. This is what we would like to move to Fabric shortly. Why Fabric? Fabric really seems to be the strategic direction for Microsoft for the…
-
Upgrade Pipeline to New Salesforce Connector
In the last couple of days I was working on migrating my Synapse Analytics pipelines from one tenant to the other. One of my challenges was the Salesforce data ingesting. As it can be found on Microsoft’s site, the Salesforce connector has changed to V2, and all pipelines should be updated latest by the Oct…
-
Maven Rail Challenge
In the past few days I spent some time again to participate Maven Analytics’ new challenge, the Rail Challenge. Couple of months since I’ve participated last time, and now it was great to work on some off-work topic again. Here is my entry and below I’m going to explain few of the stuff I’ve made.…
-
Data Awareness as the essential skill in the 2020’s
Evolution is something that cannot be stopped. Darwin said it is not the smartest, neither the strongest who will survive, but the one who can adapt changes quickly. And this is so true. Sometimes we have to act with this principle in our private life, just as in our profession. I’m currently reading a book…
-
Basket and Repeat Purchase Analysis
Optimizing portfolio is a key activity for literally all companies to make sure the offering is ideal for the market. Selecting the right products however is not an easy task and beyond some market survey and analysis, data analytics can definitely help product management teams. I’d like to introduce you two analysis I’ve just recently…
Adam's Perspective on Data 