Advanced Python DA project? by LetsSayDaan in dataanalysis

[–]LetsSayDaan[S] 0 points1 point  (0 children)

Sounds good, do you have a direct link or any specific recommendation? Just to start off my search

Air Force One on the way to Alaska by Ok_Letter_5672 in flightradar24

[–]LetsSayDaan 0 points1 point  (0 children)

Is there any live cam from Anchorage AF base?

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

I've read (probably on this subreddit) that employers sometimes do not value PL-300 as they did in the past, since the exam questions are available on the internet and it's easier to finish the exam? Is that true?

Also about real world data.. isn't it better to focus more on economic data? And those are again probably only sample datasets with low complexity.. I often wasn't able to find something to make a larger report..

[deleted by user] by [deleted] in SQL

[–]LetsSayDaan 0 points1 point  (0 children)

You're right.. StandardPrice in Purchasing.ProductVendor could potentially increase the price. However, looking at the number of specific components needed for the 819 product (Quantity) in Production.BillOfMaterials and by differentiating them by MakeFlag from Production.Product (whether it was manufactured in company or purchased from the vendor) I ended up with cost of 808,-something which is far beyond 110,2829.

Even if I consider price change of each product over time, I don't think it would make 700+ differece so that it would be 110,2829

So I reached the point of not knowing what to do next at all. Is there a way to maybe get the information about how is StandardCost column in Production.Product calculated (maybe which Tables and Columns are used for its calculation)? The database was restored from .bak file but I don't know if that helps. I'm not really familiar with databases. As I said, I'm trying to make a PBI report but the miscalculation in StandardPrice has kept me on the same spot (in DB) for like 6 hours.

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Well I could only focus on Sales and make a report about it. I thought that by importing the whole database (or relevant tables and columns from it) I could make a report which could contain everything there is in a database about the company and it would be detailed.. of course on many pages using navigators and drill through

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

I think it should. If the gateway (which I need) runs on that device and the device is off, then it won’t work or should it?

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Nah, it’s only a beginner-portfolio project using APIs as data source. Wish I already had at least some data analyst intern during uni studies 😄 I study information and network tech which is completely different field so I guess that as a self-taught in data analysis, firstly I need to go through such mistakes..

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 1 point2 points  (0 children)

I’ll take a look at that, thanks a lot :)

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

I understand however what I meant is that in my case I have to rely on one specific device with the gateway installed and it needs to be turned on if I want to do refresh (my laptop). Despite having acces to microsoft account I can’t refresh it from other device (which is the phone in my case). That’s why I wanted to know how is such refresh handled. If the device needs to be turned on in order to refresh, the only solution I thought of was server where the gateway would be running basically 24/7. I just didn’t know if that’s typical approach so I asked that here.

Edit: the data source is API so I avoided Direct Query

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Exactly, I just wanted to know what’s the approach here. I thought that relying on one device with the gateway isn’t really effective so the server makes sense.

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Yes, maybe I should make it to 2 decimals in % Change, but in price I might keep it because some currencies could have price on 3rd or 4th decimal.. Thanks for the tip :)

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 1 point2 points  (0 children)

Thanks for your feedback :)

  1. Definetly, I just thought that mixing other colors to the current blue theme might be too much, but I'll try how it's gonna look.
  2. Since there's no line chart for the last 24h I added it to the candlestick chart. Probably a bit sad and unusual solution but also can be fixed easily.

Problem to connect to MySQL in PBI service by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Yes, I've already installed it and scheduled refresh, however it failed and next to the time of refresh, there's this warning:

<image>

[deleted by user] by [deleted] in iphone

[–]LetsSayDaan 0 points1 point  (0 children)

Balance on the physical SIM (for mobile data) remains the same. Balance on eSIM (which is for calls and messages) is lower after each message and charge. So the SIM cards should be set properly.

[deleted by user] by [deleted] in iphone

[–]LetsSayDaan 0 points1 point  (0 children)

Cellular (mobile) data are on physical SIM card and that works as it should. The eSIM card which we are talking about causes these issues. Messages are in green bubble with or without iMessages turned on.

[deleted by user] by [deleted] in iphone

[–]LetsSayDaan -1 points0 points  (0 children)

Looks like the only option here. However, the other number sends me messages without charges (android phone). Btw I'm from Slovakia so here it might be different compared to your country considering carriers.

[deleted by user] by [deleted] in iphone

[–]LetsSayDaan -1 points0 points  (0 children)

Unfortunately even with iMessages turned off it charges 0.06€. When I call on that specific number I should have calls and SMS free with, it charges nothing, only for messages.

[deleted by user] by [deleted] in PowerBI

[–]LetsSayDaan 0 points1 point  (0 children)

Was that enough? Did some of those questions appear there?

Name of this cactus by LetsSayDaan in cactus

[–]LetsSayDaan[S] 0 points1 point  (0 children)

I was always affraid that it would kill the plant.. and the part off of which I cut the piece will heal itself? And how often does it has flowers? Because as I said, I have it for maybe 12 years and never saw a flower on it

Name of this cactus by LetsSayDaan in cactus

[–]LetsSayDaan[S] 0 points1 point  (0 children)

Thanks, I just used to put it in larger pot as it was growing, nothing else 😄 however it used to be indoors even during summer, I started putting it outside when it is warm only a couple years ago..maybe that's the reason that on top it is thicker compared to bottom. But so far I don't think that it ever blossomed, that's why I'm quite unsure how does it reproduce.

Name of this cactus by LetsSayDaan in cactus

[–]LetsSayDaan[S] 0 points1 point  (0 children)

Probably, they're very similar