BIDataLab
BIDataLab
  • Видео 35
  • Просмотров 77 368

Видео

[AL] 10. Versioni online dhe mobil in Power BI, freskimi i te dhenave
Просмотров 1693 года назад
Ne kete video te fundit te trajnimit, eshte treguar per versionet online dhe mobil te Power BI. Eshte publikuar ne llogarine tone puna e bere deri me tani ne trajnim, dhe eshte pare se si duken vizualizimet ne mobil. Po ashtu eshte treguar per Bookmarks, Nvigation buttons, data gateway, etj
[AL] 9. Dizajnimi i raporteve me elemente te ndryshme si Tooltip, Conditional Formatting, Shapes...
Просмотров 643 года назад
Ne kete video eshte treguar se si mund te shtojme forma te ndryshme ne raportin tone, si mund ta rregullojme Tooltip-in, si te bejne Conditional Formatting etj.
[AL] 8. Vizualizimet nga App Source (Custom Visuals)
Просмотров 1313 года назад
Ne kete mesim i kemi provuar disa vizualizime nga App source, pra disa Custom visuals. Kemi treguar se ne cfare raste mund te perdoren ato. Po ashtu i kemi shikuar edhe visualizimet e tjera prej mesimit te kaluar ne Power BI.
[AL] 7. Vizualizimet standarde ne Power BI
Просмотров 1043 года назад
Ne kete video kemi treguar per opcione te ndryshme te formatizimit te vizualizimeve ne Power BI.
[AL] 6. Date table dhe hyrje ne funksionet 'Time Intelligence'
Просмотров 1103 года назад
Ne kete video eshte vazhduar me modelimin e te dhenave, eshte treguar se si duket nje model standard Snowflake me nje tabele faktike dhe disa tabela dimansionale. Eshte treguar se si duhet te krijohet Date Table dhe si duhet te perdoret ajo ne kalkulimet Time Intelligence.
[AL] 5. Kalkulimet bazike ne DAX
Просмотров 1433 года назад
Ne kete video kemi filluar te shkruajme formula ne DAX. Kemi marr shembuj te krijimit te kalkulimeve (Measures) dhe kolonave (Calculated Columns), kemi diskutuar dallimin ne mes tyre me shembuj konkret. I kemi perdorur disa funksione te DAX si Calculate, IF, Max, Average, Sum, etj.
[AL] 4. Modelimi i te dhenave, lidhjet ne mes te tabelave
Просмотров 2413 года назад
Ne kete video nder te tjera eshte bere fjale edhe per: - Riemerimin e kolonave pavarsisht emrit te tyre - Tabelat Fact dhe Dimension, - Krijimin e lidhejeve ne mes te tabelave, - Llojet e ndryshme te lidhjeve ne mes te tabelave, - Modelimi dhe vizualizimi i te dhenave te anketave, etj.
[AL] 3. Transformime me te avancuara ne Power Query Editor
Просмотров 2283 года назад
Ne kete video jane trajtuar keto opcione: - Duplicate Query - Append Query - Load data from folder - Create and invoke custom functions
[AL] 2. Power Query Editor - Pivot dhe Unpivot
Просмотров 5853 года назад
Ne kete video jane marr disa shembuj me te dhena te strukturuara ne menyra te ndryshme, dhe eshte bere perpunimi i tyre ne Power Query Editor. Funksionet qe me se shumti jane permendur ne kete mesim jane funksionet Pivot dhe Unpivot, si nder funksionet me te rendesishme ne perpunimin e te dhenave.
[AL] 1. Hyrje ne Power BI, ngarkimi i te dhenave
Просмотров 1,1 тыс.3 года назад
Ky eshte sesioni i pare ne trajnimin e parapare te mbahet per 10 ore. Behet fjale per Power BI ne pergjithesi. Jane marr disa shembuj te leximit te te dhenave prej csv fajllit, si dhe drejtperdrejte prej web. Kerkojme falje per disa pengesa teknike te cilat po shpresojme nuk do ti kemi ne oret e tjera :)
How to create a Map Race Animation in Power BI Desktop using COVID19 Data for USA
Просмотров 9 тыс.3 года назад
In this video, we created an animation using Shape Map and Play Axis Custom visual. Data were taken from usafacts.org/visualizations/coronavirus-covid-19-spread-map/
How to create measure tables to compare TWO measures from a slicer
Просмотров 9013 года назад
In this video, we explain how to create a functionality to compare Actuals and Targets measures, using a single selection in the slicer.
How to compare Actuals vs. Targets in Power BI Desktop using 12-month data from multiple files
Просмотров 12 тыс.3 года назад
In this video, we use data from multiple files, located in the same folder. Some very interesting Power Query steps are used in order to prepare the data.
FREE conversion of your excel spreadsheet into an awesome Power BI Report/Dashboard!
Просмотров 3803 года назад
1. Subscribe to our channel 2. Send us your excel sheet 3. Receive the pbix file and the video explaining all the steps we made on the process. Thanks!
How to add dynamic arrows depending on the measure value in Power BI
Просмотров 8 тыс.3 года назад
How to add dynamic arrows depending on the measure value in Power BI
Transforming complex dataset, hiding values in a matrix & conditional formatting of percentages
Просмотров 5723 года назад
Transforming complex dataset, hiding values in a matrix & conditional formatting of percentages
How to automatically load data from multiple excel sheets into Power BI Desktop
Просмотров 9 тыс.3 года назад
How to automatically load data from multiple excel sheets into Power BI Desktop
Visualize complex survey data in Power BI
Просмотров 31 тыс.3 года назад
Visualize complex survey data in Power BI
Hard to read excel data into a cool Power BI Report
Просмотров 4693 года назад
Hard to read excel data into a cool Power BI Report
[AL] Power BI Course Part 12 Direct Query, What if Analysis, Row Level Security
Просмотров 1594 года назад
[AL] Power BI Course Part 12 Direct Query, What if Analysis, Row Level Security
[AL] Power BI Course Part 11 Custom visuals
Просмотров 634 года назад
[AL] Power BI Course Part 11 Custom visuals
[AL] Power BI Course Part 10 Tooltips, bookmarks and drill through
Просмотров 1224 года назад
[AL] Power BI Course Part 10 Tooltips, bookmarks and drill through
[AL] Power BI Course Part 9 Time intelligence functions
Просмотров 514 года назад
[AL] Power BI Course Part 9 Time intelligence functions
[AL] Power BI Course Part 8 Calculate function
Просмотров 404 года назад
[AL] Power BI Course Part 8 Calculate function
[AL] Power BI Course Part 7 Measures and calculated columns
Просмотров 644 года назад
[AL] Power BI Course Part 7 Measures and calculated columns
[AL] Power BI Course Part 6 Date table
Просмотров 374 года назад
[AL] Power BI Course Part 6 Date table
[AL] Power BI Course Part 5 Loading data from multiple excel sheets within same file
Просмотров 574 года назад
[AL] Power BI Course Part 5 Loading data from multiple excel sheets within same file
[AL] Power BI Course Part 4 2 Visualizing survey data
Просмотров 1454 года назад
[AL] Power BI Course Part 4 2 Visualizing survey data
[AL] Power BI Course Part 4 1 Visualizing survey data
Просмотров 3274 года назад
[AL] Power BI Course Part 4 1 Visualizing survey data

Комментарии

  • @mohammedaltaf4877
    @mohammedaltaf4877 4 месяца назад

    excellent

  • @jelenatatomir9129
    @jelenatatomir9129 5 месяцев назад

    Thank you for this. Great video.

  • @jagenones6513
    @jagenones6513 5 месяцев назад

    Great tutorial! Thank you

  • @byo0o1999
    @byo0o1999 6 месяцев назад

    Hi, what if i have wight in my data is there a way to use the weighted data in the visuals?

  • @yaksh82
    @yaksh82 6 месяцев назад

    Simply resolved the issue of multiple response analysis. Thanks you

  • @Kidhypo12
    @Kidhypo12 7 месяцев назад

    I am surprised that you did not get Error codes due to duplicates in the index column

    • @BIDataLab
      @BIDataLab 7 месяцев назад

      No problem in 1:N relationship

  • @Angel-kr4qo
    @Angel-kr4qo 7 месяцев назад

    Thank you soo much, the way you explain the proccess makes it really easy to follow. :)

  • @JavierBerrios-wk6vt
    @JavierBerrios-wk6vt 9 месяцев назад

    Very detailed explanation on how to solve a tricky problem with clear reasoning why. Thanks for putting together such helpful video.

  • @SuperRach97
    @SuperRach97 10 месяцев назад

    Thank you so much! so helpful

  • @cablegurl328
    @cablegurl328 10 месяцев назад

    Are you able to use the same method in Power Query? And, if so can you create a video?

  • @matthayward4411
    @matthayward4411 10 месяцев назад

    Thank you!

  • @gmea1234
    @gmea1234 11 месяцев назад

    Thank you!

  • @arthurclifford8290
    @arthurclifford8290 11 месяцев назад

    Thanks, this was good insight into using UNICHAR to include unicode characters. It should also be noted that you can have a measure that includes the unicode character and other information like having the arrow + the dollar amount as the text so that the arrow doesn't have to be in a standalone card. The only caveat with that is that building a string in DAX means you have to use the FORMAT function to explicitly format the dollar amount the way you want it to which my make the DAX formula a bit complex but it would still be possible.

  • @oneway5093
    @oneway5093 Год назад

    Excellent explanation. can we get the sample data for excercise.

  • @LucasSousa-b1d
    @LucasSousa-b1d Год назад

    How did u add the gray and blue dotted arrows, please? Are they icons, shapes, images...?

  • @LucasSousa-b1d
    @LucasSousa-b1d Год назад

    How did u create the gray and blue dotted arrows, please? Is it a shape, an icon...?

  • @AyodejiShobande
    @AyodejiShobande Год назад

    Great video. I am trying to merge different power bi visuals saved separately onto 1 sheet on different tabs. How do I do that please?

  • @AaronTadeo-e1s
    @AaronTadeo-e1s Год назад

    Thanks! This is the best one out there. Two thumbs up for this!

  • @piajavier8168
    @piajavier8168 Год назад

    can you do a crosstab table wherein the gender is separated into 2 columns pls. thanks

  • @igorrichwinferreira2801
    @igorrichwinferreira2801 Год назад

    Thanks, for the video! Very helpful. But what if I want to display the data as a percentage (but no the grand total percentage)?

  • @SoroushSohrabian
    @SoroushSohrabian Год назад

    Great

  • @mohammedaltaf4877
    @mohammedaltaf4877 Год назад

    excellent Job

  • @ZohraYaqub-c8w
    @ZohraYaqub-c8w Год назад

    This is exactly what I needed to learn! Thank you!

  • @js2570
    @js2570 Год назад

    Thank you for this very helpfull tutorial.

  • @AfeezRaheem-mr4tu
    @AfeezRaheem-mr4tu Год назад

    Hello. I need some help with a similar task. Please how can you help. I can pay some money too

  • @me_youtube2318
    @me_youtube2318 Год назад

    Thank you so much for making this. I was really stuck on how to get this type of survey data to work in Power BI. This is great!

  • @stefanodegemmis2518
    @stefanodegemmis2518 Год назад

    That transformation of the data was amazing! Even tho, it's mostly irrilevant for many people who are looking for this solution: Data is most of the time already organized properl to work, so after the 10 min the video is relevant for the issue addressed of Actuals vs target

  • @ErcoGardiner
    @ErcoGardiner Год назад

    how to send you our sheet ?

  • @ItsTheBlingBling
    @ItsTheBlingBling Год назад

    Thanks for a great video! May I know how do I go about if I wanna see how many respondents have BOTH Outlook and Excel in their answers?

    • @BIDataLab
      @BIDataLab 10 месяцев назад

      You just select both in the slicer

  • @wesleyharper3253
    @wesleyharper3253 Год назад

    This is really cool stuff! Question, if I want to create measures that show the % of individuals who use each program what is the best way to go about doing that? Additionally, if I want to add slicers, for example a slicer for each department they work in what is the best way to go about doing that while still showing the aforementioned percentage measures correctly? Thank you for posting this, really helpful stuff.

  • @Slayonus
    @Slayonus Год назад

    Amazing video, it took me super long to find a video that covers this topic well; super happy that I found this. Thank you so much!

  • @ominous_8991
    @ominous_8991 Год назад

    The video is excellent. Help me start breaking apart my survey, but I hit a snag. I am hoping someone can give me advice. The survey has 62 questions and 5 possible responses. I did separate columns, like gender, to another table using the index option shown in the video. However, with the questions, I would like to group them by category and perform calculations. For example, questions 1-8 are about Job Satisfaction and questions 9-14 are about Compensation. So I might want a break down of Female Hispanics. Any advice?

  • @MAbdullah47
    @MAbdullah47 Год назад

    can you post the resources?

  • @islamicknowledge4027
    @islamicknowledge4027 Год назад

    The amount of precision and detail in your videos is very helpful. Thank you!

  • @dianemartinez4110
    @dianemartinez4110 2 года назад

    How would I add a visual (small table) to the map to show what the saturation means in a numerical range. For example: dark red means +1000 cases in the state, medium red 500-1000 cases in the state ..etc etc

    • @BIDataLab
      @BIDataLab 2 года назад

      If you know the ranges, you can simply add static shapes/textboxes

  • @mohammedaltaf4877
    @mohammedaltaf4877 2 года назад

    fantastic

  • @nael4555
    @nael4555 2 года назад

    Very good and useful video, thank you so much, I would like to practice what I learned in this video, could u please share the dataset?

  • @kalaiselvan2212
    @kalaiselvan2212 2 года назад

    Hello Dude!! Really a nice video which clearly explains the use of queries in Power BI. thanks for that

  • @teutakacandolli4887
    @teutakacandolli4887 2 года назад

    trajnimi cenka per cdo lavdate :)

  • @DSShinZoku
    @DSShinZoku 2 года назад

    many many thanks!

  • @mohammedaltaf4877
    @mohammedaltaf4877 2 года назад

    Excellent Job Brother

    • @BIDataLab
      @BIDataLab 2 года назад

      Thanks brother :)

  • @mohammedaltaf4877
    @mohammedaltaf4877 2 года назад

    Excellent Work Brother

  • @lindabond9307
    @lindabond9307 2 года назад

    Thank you - it was doing my head in how to create the data model, which is the key to this problem. Great simple steps. You're very kind - thanks so much!

  • @Marhan93
    @Marhan93 2 года назад

    Hi! Great video. My forms is addign a semi-colon to the final word, so PowerBI creates an additional empty "value" next to the indexes. I see that you have no special characters at the end of your multiple choice answers. Wondering if anyone had a solution so I could strip it out automatically/prevent the emptry row being made? (yours says "Word, Excel" whilemine says "Word;Excel;" for instance)

  • @nilrukfernando8045
    @nilrukfernando8045 2 года назад

    Trend goes to zero if there is no data in next month, how can avoid it goes to zero ?

  • @brendas6461
    @brendas6461 2 года назад

    Super helpful, thank you!!!

  • @TheJPhotos
    @TheJPhotos 2 года назад

    Very nice! Exactly what I needed!

  • @eirikemhjellen2736
    @eirikemhjellen2736 2 года назад

    This helpt me very much, keep ut the good work!

  • @mariomartos8650
    @mariomartos8650 2 года назад

    Fantastic :)

  • @MrFarooq1123
    @MrFarooq1123 2 года назад

    where is dataset files please