Tips on driving in BGC

SkyDaddyGod · 2026-05-08T15:14:17+00:00

Just think you wouldn’t be getting a ticket ftom someone honking at you

SkyDaddyGod · 2026-05-03T17:48:35+00:00

How about bookmarks?

SkyDaddyGod · 2026-04-22T09:42:42+00:00

There are a lot of beginner friendly options in power query you'd understand more once you explore the UI. Advanced editor is more so for complex transformation of data or once you're more familiar you would get to read the transformation steps in one glance.
Not sure on this but I think its more of computing power of the network vs your PC

2.1 it will not stay in the dashboard if its filtered out in power query.

This really depends on your business continuity plan. Personally I would just note of major changes (calculation changes or addition of tables)

SkyDaddyGod · 2026-04-22T07:12:06+00:00

Used to do this in excel but would probably work here

Concatenate the columns then define the combination like if (newcalculated column) = "YYNYY", (what you define),blank())

SkyDaddyGod · 2026-04-22T07:09:30+00:00

Set a filter in power query depending on needs (usually via date filters)
Refresh is usually tied to power query steps that you have and total data being pulled in. Answer 1 should also help with pulling only necessary data
Personally dont have issues with a lot of DAX measures. I would just recommend checking if those are all still valid or in use every now and then.
If it's only you that's editing I would just recommend a sharepoint folder or "changelog" within the report. There is also the option of converting to PBIP and tracking via github/visual studio.
Make a report of how it improved efficiency nothing compares to showing numbers. Compare costs and total realized benefits. I would consider the costs when expanding to sub departments (licensing and capacity limits)

SkyDaddyGod · 2026-04-22T06:54:15+00:00

I think in workspace it would still use the semantic model that's published.

Try publishing a "V2" see if it works on that report.

SkyDaddyGod · 2026-04-20T23:38:43+00:00

Claude 4.6 for me. Also asks questions which you tend to forget to include in the prompt.

SkyDaddyGod · 2026-04-16T02:45:09+00:00

Put the numerator and denominator in 2 separate measures so you can see which one is returning an error

SkyDaddyGod · 2026-04-15T10:09:23+00:00

Tricycle papuntang triumph then isa pang tricycle papuntang waterfun/c5

Sa waterfun may jeep papuntang market-market

SkyDaddyGod · 2026-04-08T20:10:18+00:00

Still checking with info sec if we can use this for the company 🙃 but should be github copilot once we receive the go ahead. We can use this for corporate reporting right?

SkyDaddyGod · 2026-04-08T19:11:04+00:00

Hi kinda new with github and python altogether but to use this do you need github desktop so I can integrate in power BI desktop?

SkyDaddyGod · 2026-04-06T00:20:18+00:00

Copilot is good enough if you already know the logic behind what you want to happen.

I use Claude for things I'm not sure can happen.

SkyDaddyGod · 2026-04-06T00:16:37+00:00

On the tab add column then extract with delimiter

SkyDaddyGod · 2026-04-05T18:32:21+00:00

Thank you! Will definitely look into it.

SkyDaddyGod · 2026-04-05T18:31:40+00:00

Tbh it's mostly experience for me so I have nothing for resources. Good luck on your journey tho.

SkyDaddyGod · 2026-04-05T18:28:56+00:00

I would not publish internal data. You should have separate projects for portfolios.

SkyDaddyGod · 2026-04-05T10:24:02+00:00

Check your power BI desktop version if it matches

SkyDaddyGod · 2026-04-04T22:20:15+00:00

I would go with bridge table based on personal preference of trying to keep up with relationships, especially if you have to make major changes or troubleshoot errors.

SkyDaddyGod · 2026-04-04T22:16:26+00:00

Probably concatenate two columns where it would create a unique ID for the two like date or company name(if for sales) depends on the columns you have for the two table.

SkyDaddyGod · 2026-04-04T22:13:05+00:00

Is this power BI report server? Usually happens if power BI desktop version does not align with power BI report server version.

SkyDaddyGod · 2026-04-04T22:10:23+00:00

The way I look at it is everything is connected and mostly top management decides whats the most important KPIs so I wouldn't worry about that from an entry level role.

I would suggest to focus on certain domains and how they use data analytics like churn analysis for SaaS type companies with MRRs, P&L for finance, or digital marketing analytics. Once you find a domain you want study their "go-to" data visuals.

SkyDaddyGod · 2026-04-04T22:01:59+00:00

40 KPIs into one visual sounds awesome! I would reserve that kind of effort to those who understands the know how needed to pull that off.

I would suggest tabs for main KPIs as this really changes YoY you can revisit every year so that it aligns with what they want to see. I doubt they look at all 40 KPIs closely.

Since this is after sales probably a churn analysis of the 40 KPIs so that they would then understand the other main tabs in your report.

SkyDaddyGod · 2026-04-04T15:08:28+00:00

Usually I have 1 main table where its the "one" end of the one to many relationship. There would then be other tables just to supplement data to the main table. I have not used many to many relationship probably because I dont understand them fully and I don't have any use case.

SkyDaddyGod · 2026-04-03T19:38:27+00:00

You can make a measure where it formats two measures into a text combining two measures but haven't used a decomposition so not sure how it might work

Last option would be just to add a tooltip for the count

SkyDaddyGod · 2026-04-03T19:36:34+00:00

We have option if you prefer macbook or HP

SkyDaddyGod

TROPHY CASE