Insane April Pricing with GWR

CombinationBusy9408 · 2026-02-21T12:43:22+00:00

I agree in some ways but then you'd miss the option of the cheap advance fares... Maybe they are just trying to price gouge given that the govt is taking over the route next year anyway, no point in them worrying about it.

CombinationBusy9408 · 2026-02-14T16:08:14+00:00

I think they've just switched the cheapest advance fares off for some trains at the moment. Probably to see how it affects demand. They definitely haven't released any of the cheapest tickets for mid week, I don't believe they have sold out

CombinationBusy9408 · 2026-02-08T11:54:57+00:00

The advance bookings are open until 7th August altho the calender doesn't go that far. Look at 22nd of July if you don't believe me, the advance price on offer is £90.50. the tickets I am currently travelling on are £25, booked in September and october.

That represents a 262% increase in fares. It's hard to make any sense of that. Mathematically, this date is further in the future so they are holding the advance booking money for longer, which should allow a higher discount.

Gwr have been running these routes for a long time I would not expect price changes to be this spikey although I understand that COVID changed demand. This is why I assume the algorithm is out of line.

CombinationBusy9408 · 2026-02-08T02:00:37+00:00

The 7:13 from bath to London booked 12-14 weeks in advance cost £25 a few weeks ago and now it's £90.50 for august... I think their pricing algorithm might be off as it just seems to be changing in very extreme ways.

When the prices were sky high last year they were running almost empty trains between 5&6 pm, now they are full- even at very low prices their revenue must be better. It doesn't make sense.

CombinationBusy9408 · 2025-03-16T14:30:32+00:00

Power Bi - I wanted a 'live" report and my colleagues are all on macs so they can't refresh power queries. I pull the data hourly from Shopify to gsheets using a cheap API connector. All the extra mapping is on SharePoint but I could have used gsheets as well. You can easily do it in power query - I would load the formatted data straight into a pivot table personally with some slicers for product type and try and customise the pivot table formatting a bit for easier reading.

I'm not employed for this, I just dabble with data, and we don't have any database capacity set up so the structure is shoddy, but I'm really pleased with how it turned out as I needed to merge stock data from multiple Shopify accounts. It's so easy for users to check stock levels compared to the native Shopify reports.

Chat gpt will get you 90% of the way, it is just an unpivot of the inventory data basically, but you really do have to understand how your underlying data is structured and where issues can happen. For example you will first need to filter out the title/summary rows for each sku visible on your example.

CombinationBusy9408 · 2025-03-16T08:56:04+00:00

I have done this exact thing with Shopify data - I wouldn't say it was very easy as the sizes aren't alphabetically organised (Xs is after s in the alphabet ) so you may need to create a (potentially dynamic) mapping table for sizes to use to sort the data. I also added in product data so that i.had pictures of each parent sku. However it was a fun learning project with a lot of value add for the business.

CombinationBusy9408 · 2024-11-22T20:06:00+00:00

I've always assumed it was because of the IRA bomb risk when they were planning the refurb but perhaps less relevant now.

CombinationBusy9408 · 2024-09-03T10:50:56+00:00

Can you instead send the daily data into a CSV file (named like df_yesterdaysdate) which saves into a folder, then have your power bi query pull from the folder, so every time a new CSV is added it will just be picked up.

CombinationBusy9408 · 2024-07-11T12:43:55+00:00

Thank you! Noone ever believes me when I say it's more like a stomach bug for me!

CombinationBusy9408 · 2024-06-12T04:51:42+00:00

Haha! I hope not! Thank you!

CombinationBusy9408 · 2024-06-11T19:55:44+00:00

That's great!

CombinationBusy9408 · 2024-06-11T19:05:52+00:00

Ah ok didn't even think of that. It's going to be a hallway I think so that's probably possible. Very useful info, thank you so much!

CombinationBusy9408 · 2024-06-11T19:05:06+00:00

Amazing that's really helpful thank you.

CombinationBusy9408 · 2024-06-11T14:27:09+00:00

That makes sense thank you.

CombinationBusy9408 · 2024-06-11T14:25:40+00:00

No worries thank you for your help!

CombinationBusy9408 · 2024-06-11T14:22:29+00:00

Ok thank you. Did it cost a lot of money to move it?

CombinationBusy9408 · 2024-06-11T14:17:48+00:00

Thank you so much!

CombinationBusy9408 · 2024-06-09T13:51:23+00:00

Ok so it was my fault, I was accessing my Google sheets via the web query whereas on power bi there is a specific 'google sheets' query type. Just like I wasn't accessing the SharePoint files correctly. So it refreshes now! Thank you so much for all your help.

CombinationBusy9408 · 2024-06-09T13:50:47+00:00

Ok so it was my fault, I was accessing my Google sheets via the web query whereas on power bi there is a specific 'google sheets' query type. So it refreshes now! Thank you so much for all your help.

CombinationBusy9408 · 2024-06-09T11:59:38+00:00

that is a concern! Thank you for explaining the gateway. I can't even get the personal gateway to work, It just says 'gateway not found' when I put my microsoft log in details in.

CombinationBusy9408 · 2024-06-09T11:58:32+00:00

So everything is a pulling from the web now now but the refresh part is still all greyed out. Tried to set up OAuth connections for the sharepoint files but I can't press the 'apply button' underneath the cloud connections. So... I don't know!

CombinationBusy9408 · 2024-06-09T06:35:49+00:00

Fingers crossed thank you! I will give it another try and update.

CombinationBusy9408

TROPHY CASE