BIDataLab
BIDataLab
  • Видео 35
  • Просмотров 72 423

Видео

[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...
Просмотров 633 года назад
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)
Просмотров 1223 года назад
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
Просмотров 973 года назад
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'
Просмотров 1053 года назад
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
Просмотров 1363 года назад
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
Просмотров 2203 года назад
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
Просмотров 2213 года назад
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
Просмотров 5243 года назад
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
Просмотров 9953 года назад
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
Просмотров 8213 года назад
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!
Просмотров 3573 года назад
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
Просмотров 5193 года назад
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
Просмотров 29 тыс.3 года назад
Visualize complex survey data in Power BI
Hard to read excel data into a cool Power BI Report
Просмотров 4503 года назад
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
Просмотров 1593 года назад
[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

Комментарии

  • @jelenatatomir9129
    @jelenatatomir9129 8 дней назад

    Thank you for this. Great video.

  • @jagenones6513
    @jagenones6513 10 дней назад

    Great tutorial! Thank you

  • @byo0o1999
    @byo0o1999 24 дня назад

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

  • @yaksh82
    @yaksh82 Месяц назад

    Simply resolved the issue of multiple response analysis. Thanks you

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

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

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

      No problem in 1:N relationship

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

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

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

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

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

    Thank you so much! so helpful

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

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

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

    Thank you!

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

    Thank you!

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

    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 6 месяцев назад

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

  • @user-cu5mm9hd7g
    @user-cu5mm9hd7g 6 месяцев назад

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

  • @user-cu5mm9hd7g
    @user-cu5mm9hd7g 6 месяцев назад

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

  • @user-ye3qb4ou3m
    @user-ye3qb4ou3m 7 месяцев назад

    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 7 месяцев назад

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

  • @piajavier8168
    @piajavier8168 8 месяцев назад

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

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

    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 Год назад

    Great

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

    excellent Job

  • @user-xq8kt8mm1o
    @user-xq8kt8mm1o Год назад

    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 5 месяцев назад

      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 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

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

    where is dataset files please