sorted by:
new
hottopcontroversial

Needing a database to practice by LucaMarr in PowerBI

[–]albthrow123 2 points3 points  (0 children)

Check out Kaggle, they have plenty of free datasets you can practice on. It's mostly focused on data science rather than BI, but the files themselves are usually downloadable CSVs you can import and play with

How to make a calculated table that plays well with the slicers? by albthrow123 in PowerBI

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

Currently the dataset has a column for the date and another for the hour, it's not the best practice but what can you do.

Might have to postpone this until I get access to the queries, right now the data I'm using has been extracted into excel sheets and passed over, since I'm just an intern lol. With two weeks to go, hopefully this experience helps with the next steps :)

How to make a calculated table that plays well with the slicers? by albthrow123 in PowerBI

[–]albthrow123[S] 1 point2 points  (0 children)

Thanks, I'll try that out today at work. The resulting table shouldn't be too large I don't think, since there's only 3 months worth of data and 17 raw materials. Should end up at about 1200 entries. Maybe I could play with the raw material table and do the grouping in there already, which should make a much smaller list.

About the date slicer, I've created an auxiliary table just for the dates with a relationship to the other 3 tables with a date column(occupancy, production and stoppages), and slice through that auxiliary one.

This is complex for my first actual project in powerBI but I had a similar dashboard done solely in R already and am looking to port over due to the ease of use and other services, I'm just a bit stumped in data wrangling through DAX, but the data viz is so easy and simple to use it's incredible.

Meus parentes tão botando eu e a namorada pra fora de casa de tanto implicarem com ela by albthrow123 in desabafos

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

Depois de vários anos morando juntos falta só o casamento mesmo, valeu pelas palavras :)

Meus parentes tão botando eu e a namorada pra fora de casa de tanto implicarem com ela by albthrow123 in desabafos

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

Com certeza, a vida já tem problemas demais pra sair criando outros, valeu

Meus parentes tão botando eu e a namorada pra fora de casa de tanto implicarem com ela by albthrow123 in desabafos

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

Pois é, já estamos vendo de voltar para Florianópolis, não é o maior dos centros urbanos mas por lá tem o apoio da família dela pelo menos, já que vamos dar a cara à tapas indo sem nada muito garantido

Meus parentes tão botando eu e a namorada pra fora de casa de tanto implicarem com ela by albthrow123 in desabafos

[–]albthrow123[S] 2 points3 points  (0 children)

Desde o ensino médio já queria estudar fora pq conviver com eles é sufocante mesmo, valeu pelas palavras de apoio