BIDataLab
BIDataLab
  • 35
  • 70 951

Відео

[AL] 10. Versioni online dhe mobil in Power BI, freskimi i te dhenave
Переглядів 1662 роки тому
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...
Переглядів 632 роки тому
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)
Переглядів 1212 роки тому
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
Переглядів 962 роки тому
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'
Переглядів 1042 роки тому
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
Переглядів 1352 роки тому
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
Переглядів 2193 роки тому
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
Переглядів 2203 роки тому
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
Переглядів 5203 роки тому
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
Переглядів 9883 роки тому
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
Переглядів 8 тис.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
Переглядів 7913 роки тому
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
Переглядів 11 тис.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!
Переглядів 3483 роки тому
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
Переглядів 5003 роки тому
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
Переглядів 8 тис.3 роки тому
How to automatically load data from multiple excel sheets into Power BI Desktop
Visualize complex survey data in Power BI
Переглядів 28 тис.3 роки тому
Visualize complex survey data in Power BI
Hard to read excel data into a cool Power BI Report
Переглядів 4423 роки тому
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
Переглядів 1573 роки тому
[AL] Power BI Course Part 12 Direct Query, What if Analysis, Row Level Security
[AL] Power BI Course Part 11 Custom visuals
Переглядів 613 роки тому
[AL] Power BI Course Part 11 Custom visuals
[AL] Power BI Course Part 10 Tooltips, bookmarks and drill through
Переглядів 1193 роки тому
[AL] Power BI Course Part 10 Tooltips, bookmarks and drill through
[AL] Power BI Course Part 9 Time intelligence functions
Переглядів 503 роки тому
[AL] Power BI Course Part 9 Time intelligence functions
[AL] Power BI Course Part 8 Calculate function
Переглядів 403 роки тому
[AL] Power BI Course Part 8 Calculate function
[AL] Power BI Course Part 7 Measures and calculated columns
Переглядів 633 роки тому
[AL] Power BI Course Part 7 Measures and calculated columns
[AL] Power BI Course Part 6 Date table
Переглядів 363 роки тому
[AL] Power BI Course Part 6 Date table
[AL] Power BI Course Part 5 Loading data from multiple excel sheets within same file
Переглядів 573 роки тому
[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
Переглядів 1433 роки тому
[AL] Power BI Course Part 4 2 Visualizing survey data
[AL] Power BI Course Part 4 1 Visualizing survey data
Переглядів 3223 роки тому
[AL] Power BI Course Part 4 1 Visualizing survey data

КОМЕНТАРІ

  • @yaksh82
    @yaksh82 8 днів тому

    Simply resolved the issue of multiple response analysis. Thanks you

  • @Kidhypo12
    @Kidhypo12 Місяць тому

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

    • @BIDataLab
      @BIDataLab Місяць тому

      No problem in 1:N relationship

  • @Angel-kr4qo
    @Angel-kr4qo Місяць тому

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

  • @JavierBerrios-wk6vt
    @JavierBerrios-wk6vt 3 місяці тому

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

  • @SuperRach97
    @SuperRach97 3 місяці тому

    Thank you so much! so helpful

  • @cablegurl328
    @cablegurl328 3 місяці тому

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

  • @matthayward4411
    @matthayward4411 4 місяці тому

    Thank you!

  • @gmea1234
    @gmea1234 4 місяці тому

    Thank you!

  • @arthurclifford8290
    @arthurclifford8290 4 місяці тому

    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 5 місяців тому

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

  • @user-cu5mm9hd7g
    @user-cu5mm9hd7g 5 місяців тому

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

  • @user-cu5mm9hd7g
    @user-cu5mm9hd7g 5 місяців тому

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

  • @user-ye3qb4ou3m
    @user-ye3qb4ou3m 6 місяців тому

    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?

  • @user-sb5dm4zq4v
    @user-sb5dm4zq4v 6 місяців тому

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

  • @piajavier8168
    @piajavier8168 7 місяців тому

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

  • @igorrichwinferreira2801
    @igorrichwinferreira2801 8 місяців тому

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

  • @user-jy2en3og9i
    @user-jy2en3og9i 11 місяців тому

    Great

  • @mohammedaltaf4877
    @mohammedaltaf4877 11 місяців тому

    excellent Job

  • @user-xq8kt8mm1o
    @user-xq8kt8mm1o 11 місяців тому

    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 4 місяці тому

      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 Рік тому

    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 Рік тому

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

  • @mohammedaltaf4877
    @mohammedaltaf4877 Рік тому

    fantastic

  • @nael4555
    @nael4555 Рік тому

    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 Рік тому

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

  • @teutakacandolli4887
    @teutakacandolli4887 Рік тому

    trajnimi cenka per cdo lavdate :)

  • @DSShinZoku
    @DSShinZoku Рік тому

    many many thanks!

  • @mohammedaltaf4877
    @mohammedaltaf4877 Рік тому

    Excellent Job Brother

  • @mohammedaltaf4877
    @mohammedaltaf4877 Рік тому

    Excellent Work Brother

  • @lindabond9307
    @lindabond9307 Рік тому

    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 Рік тому

    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 Рік тому

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

  • @brendas6461
    @brendas6461 Рік тому

    Super helpful, thank you!!!

  • @TheJPhotos
    @TheJPhotos Рік тому

    Very nice! Exactly what I needed!

  • @eirikemhjellen2736
    @eirikemhjellen2736 Рік тому

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

  • @mariomartos8650
    @mariomartos8650 2 роки тому

    Fantastic :)

  • @MrFarooq1123
    @MrFarooq1123 2 роки тому

    where is dataset files please

  • @MrFarooq1123
    @MrFarooq1123 2 роки тому

    where is dataset files please

  • @MrFarooq1123
    @MrFarooq1123 2 роки тому

    where is dataset files please

  • @anastasiadushina4217
    @anastasiadushina4217 2 роки тому

    Hi, thank you for your video, it's really useful. I just have one more question, is it possible to create the same visualizations of programs and motivators for percentage of employees, not number? Thank you!

    • @BIDataLab
      @BIDataLab 2 роки тому

      Yes, absolutely, the simpliest way is to choose the value to show as % of total

  • @joekakone
    @joekakone 2 роки тому

    Thank you for the tutorial. It helps me a lot.