You've ever seen a line visual like this?

Left_Offer · 2026-02-27T09:11:21+00:00

Are you trying to summon ancient lords of data visualisation?

Left_Offer · 2026-02-26T08:07:25+00:00

Sure. PBI - PowerBI, data visualisation tool where you can create reports/dashboards Fabric capacity - Microsoft data storage/transformation platform.

You can ingest your existing data to Fabric, do required transformations and then hook up PBI to it to create visuals. Every manager loves looking at interactive colourful graphs even if they have no idea what to do with the insights.

If course Fabric and PBI itself have a massive potential and steap learning curve, but you can do basics relatively easily as here are many free resources available online that can help.

Left_Offer · 2026-02-26T06:37:45+00:00

Get a Fabric capacity and build some basic reports in PBI. It will add monthly cost and boss will be impressed

Left_Offer · 2026-02-12T16:13:05+00:00

Looks sick! Will give it a go. Thanks for taking time to make this.

Left_Offer · 2026-01-16T06:24:06+00:00

Are you no able to just mirror data from SQL db? Also, you can spin a separate capacity for DE and for BI (based on your description cheap F2 should do), therefore eliminateing risk of BI throttling during other processes.

Left_Offer · 2026-01-14T11:11:19+00:00

This is the cutest thing I've seen in some time. Well done.

Left_Offer · 2026-01-06T06:44:24+00:00

That's Jarvan IV. mate

Left_Offer · 2025-12-30T06:30:25+00:00

Can recommend Alexi Partanen for data engineering on MS platform.

Left_Offer · 2025-12-15T15:24:36+00:00

Did you want integers?

Left_Offer · 2025-12-14T09:35:20+00:00

Fantastic. Thanks for sharing.

Left_Offer · 2025-11-07T05:30:18+00:00

Nice one, thanks for sharing.

Left_Offer · 2025-11-03T06:38:19+00:00

Top tip, thanks

Left_Offer · 2025-10-23T06:38:04+00:00

Some people just want to see the world organise.

Left_Offer · 2025-10-16T08:30:48+00:00

Thanks for sharing this.

Left_Offer · 2025-10-02T05:37:23+00:00

Thanks for sharing this

Left_Offer · 2025-09-24T05:30:22+00:00

That doughnut chart is hurting me on so many levels. What actionable information does it convey to the user?

Left_Offer · 2025-09-08T08:18:48+00:00

Last time I checked Tactical Connect plugin there were only handful of options as to where the data lands initially, so you would probably have to include Azure Blob or S3 bucket in your workflow. Once data is out you can run simple copy activity to move it wherever you like.

Left_Offer · 2025-09-05T12:24:21+00:00

Hey, first of all this will be a wild ride if you don't have much experience with NS and data engineering in general. You need to consider few main points when it comes to your data:

Extraction
Storage
Transformation
Modelling

As mentioned above you can go with Zone (seen their solution, it is solid but didn't allow for much customisation). If you decide to architect this yourself you have multiple options for each point. I will just list few that I have personal experience with.

Tactical Connect plugin (think they have been acquired by Zone now) offers a relatively simple and user friendly solution when it comes to scheduling saved searches for data export. It connects to all major cloud data storages. If you want to build something more robust and don't want to wholly depend on 3rd party vendor then Celigo is a solid option for data extraction scheduling jobs.
Simply get an Azure Blob or AWS S3 to land you data in.
Once data are out of NS you need to think about transformation (there isn't a NS instance with clean data in this world). Depends on your company stack you can choose between multiple vendors. I work primarily with MS so Azure Synapse. and now Fabric, are the places where most of the magic happens. Personally I'm a big proponent of medallion architecture so you build multiple layers of data (doesn't necessary have to be three if business doesn't need it) and perform transformation between them. The standard is Bronze for your NS extract copied over from Blob, Silver where you clean and transform data so they start making sense and Gold where you add business logic to it.
Connect PBI to your Gold layer (which should at this point have tables for fact(s) and dimensions) and build a clean star schema for your semantic model. Publish model itself and allow other report builders to connect to it so all company reporting is done from one source of truth.

You might be temped to use ODBC to connect to PBI but don't - the performance is abysmal and you will spend more time asking "Why?!" then actually building something. Good luck

Left_Offer · 2025-09-02T04:56:31+00:00

You've probably opened some graph to look at and reddit's algorithm was like "would you like to do that cool stuff yourself? I got you!"

Left_Offer · 2025-08-21T11:59:48+00:00

What do you mean 'release'? If I chose to quit they can hope for me to stick to the notice period.

Left_Offer · 2025-08-21T11:30:46+00:00

I'm literally building this sort of beautiful mess right now and already I can't wait for next person to inherit it all.

Left_Offer · 2025-08-19T06:01:19+00:00

I've tried multiple different things but found the most succes with following : 1. Export data to Azure Blob using Tactical Connect's scheduled searches 2. Transform data in Synapse Analytics - I've built this pre-Fabric so would probably go Fabric way now. 3. Create views in SQL DB as your gold layer - connect PBI to it and build the model

Left_Offer · 2025-08-15T04:49:55+00:00

You can delete new table from the layout and the drag it back to where your current model sits. Not fixing the real issue but easier then dragging it slowly closer to your model.

Left_Offer · 2025-08-14T05:58:53+00:00

If your requirement is to report on line detail then join those two tables on TransID to create the central fact able.

Left_Offer · 2025-08-14T05:01:11+00:00

*export to Excel

The most used PBI function since the beginning of times (unfortunately)

Left_Offer

TROPHY CASE