![BIDataLab](/img/default-banner.jpg)
- Видео 35
- Просмотров 72 423
BIDataLab
Добавлен 17 ноя 2020
We are a group of professional engineers that offer data analysis and visualization services. We use Power BI Desktop to create visuals and reports, and then deliver dashboards as per client requirements.
Our team consists of professionals with proven experience in delivering top-quality services for our clients from all over the world.
Our team consists of professionals with proven experience in delivering top-quality services for our clients from all over the world.
[AL] BIDataLab ne Upwork!
Ne kete video kemi treguar per mundesite e bashkepunimit me BIDataLab ne Upwork!
Просмотров: 408
Видео
[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
Thank you for this. Great video.
Great tutorial! Thank you
Hi, what if i have wight in my data is there a way to use the weighted data in the visuals?
Simply resolved the issue of multiple response analysis. Thanks you
I am surprised that you did not get Error codes due to duplicates in the index column
No problem in 1:N relationship
Thank you soo much, the way you explain the proccess makes it really easy to follow. :)
Very detailed explanation on how to solve a tricky problem with clear reasoning why. Thanks for putting together such helpful video.
Thank you so much! so helpful
Are you able to use the same method in Power Query? And, if so can you create a video?
Thank you!
Thank you!
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.
Excellent explanation. can we get the sample data for excercise.
How did u add the gray and blue dotted arrows, please? Are they icons, shapes, images...?
How did u create the gray and blue dotted arrows, please? Is it a shape, an icon...?
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?
Thanks! This is the best one out there. Two thumbs up for this!
can you do a crosstab table wherein the gender is separated into 2 columns pls. thanks
Thanks, for the video! Very helpful. But what if I want to display the data as a percentage (but no the grand total percentage)?
Great
excellent Job
This is exactly what I needed to learn! Thank you!
Thank you for this very helpfull tutorial.
Hello. I need some help with a similar task. Please how can you help. I can pay some money too
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!
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
how to send you our sheet ?
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?
You just select both in the slicer
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.
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!
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?
can you post the resources?
The amount of precision and detail in your videos is very helpful. Thank you!
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
If you know the ranges, you can simply add static shapes/textboxes
fantastic
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?
Hello Dude!! Really a nice video which clearly explains the use of queries in Power BI. thanks for that
trajnimi cenka per cdo lavdate :)
many many thanks!
Excellent Job Brother
Thanks brother :)
Excellent Work Brother
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!
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)
Trend goes to zero if there is no data in next month, how can avoid it goes to zero ?
Super helpful, thank you!!!
Very nice! Exactly what I needed!
This helpt me very much, keep ut the good work!
Fantastic :)
where is dataset files please
where is dataset files please