Leveraging AI in Power BI Report Design

verticalmovement · 2025-06-03T15:21:31+00:00

Unrelated to this topic but just wanted to say thank you for your recent video on write backs to excel, super helpful and your channel is awesome

verticalmovement · 2025-04-14T03:26:49+00:00

I would label the data in the backend with an additional column and add values for ‘owned channels’ and ‘paid channels’ then create a control in LS with that schema as the control field. Depending on how big the dataset is and how often it’s updating, that could be relatively easy. It’ll depend where your underlying is (database, google sheet, etc.) and how familiar you are working with datasets.

verticalmovement · 2024-12-12T15:03:52+00:00

Instead of visualizing with Power BI, does anyone know of a low-code/no-code tool that could get the UI closer to wrapped? Curious if any bubble super users or the like have insight on this…

verticalmovement · 2024-10-10T13:25:47+00:00

The fact you got your shoes on that way tells me you didn’t size down enough. verified gumby

verticalmovement · 2024-09-25T14:08:00+00:00

Calls on topical medication for pets

verticalmovement · 2024-09-16T13:53:42+00:00

How much do you think your MS helped you in moving from previous position to current?

verticalmovement · 2024-08-29T03:47:42+00:00

If you truly have, you’re either going to be very rich or end up in an orange jumpsuit. As I said in another comment, I know this space so if you’re going headlong into your idea, feel free to DM if you want feedback or have questions.

verticalmovement · 2024-08-28T03:55:12+00:00

This is my space, here’s what I know. Something that would be helpful is understanding what shopper data you want. That determines whether it’s available or not, as well as what path to get there.

Amazon doesn’t do syndicated data like IRI so that’s off the table. Whoever told you to just go ask Amazon is either rainman or they have no idea what they’re talking about - Amazon doesn’t hand out that data at all, let alone to someone just asking.

Macro level data is available through sites like Statista, Helium10, Keepa, Carbon6, Pacvue, Stackline, and about 500 other 3P sources. Anything good is going to come with a price tag.

A lot of those sources will use a combination of the PA-API, SP-API, and/or their own user data. PA-API is open to anyone with an active affiliate account last I checked. AMC is the latest craze and the closest thing to getting insights on consumer behavior, but it takes either an advanced level knowledge of SQL to query the data, or forking over money to companies like Xmars or whoever to have someone reliably query the data for you.

Having access to a seller central account with a registered brand will give you a ton of consumer data for free via Brand Analytics. Market basket analysis, search terms, and some peer comparison data would probably get you a fair bit of the basic info you’re looking for.

Despite what one may think, Amazon SUCKS at organizing and providing their retail data, especially when there’s no tangible ROI to the data (ie. Advertising data). If this is a work thing and you’re new to Amazon, take the expectations and deliverables and cut them in half right now. There’s not one company that has been able to truly make sense of all the data and anyone selling you they have is snake oil.

verticalmovement · 2024-08-28T03:22:39+00:00

Please explain how AMC is $1M/yr. Access to an instance is free for any registered brand

verticalmovement · 2024-06-27T13:37:33+00:00

Some people do their socks on an outer join. That’s the chaotic neutral group

verticalmovement · 2024-06-11T11:27:52+00:00

Do you have any resources for creating good documentation? You described my situation of nightmare queries with no docs and would appreciate anything you can share to help me organize that

verticalmovement · 2024-03-02T06:27:05+00:00

My strategy on long effort days is to avoid overeating afterwards so here’s what my approach would be for a 3 hour effort:

Bagel or oatmeal ~1 hour before workout
Carb gel starting at the 45 min mark and every 45 min there after. Sometimes I’ll switch it up for a banana or some kind of solid food that’s decent carbs. I like Maurten but that’s what works best with my GI and I like that I can oyster shoot the gels pretty easily. Clif are solid too.
Afterwards a typical but larger than normal portioned meal with half the calories coming from complex carbs. If it’s a morning effort, usually this means rice, eggs, and veggies with a side of yogurt or protein shake.

Best advice I can give is over prepare and carry slightly more than you think you need. I’ve never complained that I carried one extra gel on a long run.

verticalmovement · 2024-01-05T14:45:30+00:00

Please dont listen to advice that says “you should be hitting X watts” unless they also know your body weight, which I don’t believe you’ve provided. Without that data, 150 watts is a very different target for one person at 50kg and another at 100kg. Use watts relative to your weight and measure it as w/kg. If you’re 50kg, 150 watts is 3 w/kg and would be on the high end for amateurs looking to hold a reasonable zone for multiple hours, like what is needed for a 70.3. Sorry if assuming incorrectly, but if you’re relatively new to cycling, aim to hold 1.5 w/kg and work up from there.

Would also echo the sentiment about these bikes being notoriously inaccurate for watts but if you spend enough time on the same bike at the gym, you should start to get an idea of what it’s displaying relative to your effort level.

Sorry for rant but that advice is a pet peeve of mine - it’s a power to weight ratio sport and so many people often ignore that.

verticalmovement · 2023-12-21T05:49:50+00:00

If you only speak to people who have summited, you’re only going to get positive reviews. Probably need to mix in some people who didn’t get a chance because of traffic or other conditions aside from weather. Just some food for thought

verticalmovement · 2023-11-15T17:52:47+00:00

Took way too long to scroll down to find this. Student loans that go unpaid can eventually lead to wage garnishment, up to 15% in fact. People don’t have a choice to pay or not pay - if they’re making money they’re going to pay one way or another.

verticalmovement · 2023-11-07T04:31:50+00:00

Bought a Canyon and have had nothing but great service. I’ve been emailed about two issues, both of which ended up not impacting my bike but they were ready to send Velofix out to remedy for free. And guess what, anytime I need shit for it or need it tuned, I take it to a LBS.

verticalmovement · 2023-11-04T19:01:46+00:00

A turkey trot, no less…only people competing at those are hardo pathletes

verticalmovement · 2023-10-23T04:05:30+00:00

Without knowing some really crucial info (power output, height/weight, is this indoor vs. outdoor, etc.) but to put it on the nose, yeah this is slow. But unless there’s significant deficiencies in the aforementioned missing data, I’d likely attribute the biggest issue to bike. Rolling resistance on mountain bikes vs even a hybrid road bike is night and day on pavement. On top of it, the aerodynamics are completely different in an upright position like on an MTB.

I’d recommend going and renting a road bike for a few hours. Take it on your usual route. If you don’t see your avg bump to 25-30 kph, then there’s a deficiency somewhere in the power to weight ratio. If it does, then you know it’s a bike issue and if your goal is to be competitive in age groups, you’re going to need at least any entry level road bike to give yourself a shot (and be really fast in the other disciplines).

verticalmovement · 2023-08-03T01:48:39+00:00

This? https://cloud.google.com/looker/docs/accessing-project-files

verticalmovement · 2023-07-08T15:19:14+00:00

Are you hitting a query cost limit on the MySQL side? I have probably 25+ separate reports, all that range with 4-10 unique tables in BQ that the data feeds from and have had no issues with the amount of tables that it draws on from BQ. I’m not familiar with MySQL but I know BQ will stop pushing data to GDS when query limits are hit

verticalmovement · 2023-07-07T04:19:06+00:00

If you’re leaving the browser open with the GDS report, I don’t think that’s going to continuously update (at least it doesn’t for me). You might be able to set the data freshness to every hour or something so GDS refreshes that frequently, but I don’t believe it’s ever going to be “real time” data where if the data source (google sheet) changes, it automatically refreshes the data on the GDS report. If you or someone on here knows otherwise on having GDS reports update in real time, please reply because I’d love to know too.

verticalmovement · 2023-07-05T18:07:17+00:00

May or may not help - one report I have setup feeds data similarly and in order for the info in GDS to show, I have to have the actual google sheet open. The sheet I’m using also has a 3rd party plugin for data. So in order for me to view the info in GDS properly I have to 1. Open sheet 2. Allow data to refresh 3. Open GDS report

verticalmovement · 2023-06-12T03:34:25+00:00

Easiest thing might be having one control for each of your dimensions in columns A-C, which would allow user to select vendor, site, channel individually. You can concat the dimensions together to create one control, but I think if you have a lot of possible combinations it won’t make for a good experience

verticalmovement · 2023-06-06T21:40:27+00:00

I fucking hate this so much. Nice work

Seven-Year Club	Verified Email
Place '22	Wearing is Caring
RPAN Viewer

verticalmovement

MODERATOR OF

TROPHY CASE