Data For Knowledge
Data For Knowledge
  • Видео 64
  • Просмотров 279 320
Excel - count the number of categories in a column
Excel - one method to count the number of categories in a column.
#excel #exceltips #excelcounta #ExcelCountCategories #spreadsheets #counta
Просмотров: 486

Видео

Excel - Calculate Duration - number of days between two dates
Просмотров 1 тыс.3 месяца назад
Excel - one method to find the number of days between two dates, ie the duration or date difference. #excel #exceltips #ExcelDuration #ExcelDateDifference#spreadsheets
Excel - Move the position of a column - reorder columns
Просмотров 5883 месяца назад
In Excel how to easily reorder the columns into new positions. #excel #exceltips #excel_columns #excel_moveacolumn #spreadsheets
Excel import to Power BI - Watch out for strikethroughs!
Просмотров 1277 месяцев назад
When importing excel into Power BI watch out for strikethroughs. Remember strikethroughs are formatting in excel and Power BI does not recognise formatting. #powerbi #powerbishorts #powerbitips #excel #excelpowerbi #strikethrough #crossout #data
Why layer order matters in data visualisations
Просмотров 5 тыс.7 месяцев назад
Layers allow more than one diagram to be placed in the same spot on a data report. Here, I look at how layers operate then look at layer order using an onscreen example of an image and text occupying the same spot on the screen. If layer order is ignored, the text can become obscured by the image. Timings: 00:00 Layers and layer order explained using physical items 02:09 Layer order for data di...
Power BI - Combining diagrams - Items to consider
Просмотров 1,6 тыс.7 месяцев назад
In Power BI combining diagrams can be straightforward, but there are additional points to consider such as grouping diagrams, layer order, the interactivity between the combined diagrams, and the interaction with other items on the page. Timings: 00:00 Introduction 00:40 Create the combined diagram 01:00 Group diagrams 01:58 Layer order and interactivity between diagrams 04:25 Alternative group...
Power BI - Misplaced diagrams - Layer order matters
Просмотров 1737 месяцев назад
In Power BI, has your diagram disappeared? It maybe that the diagrams is hidden behind another. Here, I discuss the order of layers and why layer order can result in the accidental hiding of diagrams. Videos referenced: ruclips.net/video/HAwc16JWg74/видео.html Power BI - Combining diagrams - Items to consider ruclips.net/video/V9yE-MLNRic/видео.html Layer order matters in data visualisations #p...
Power BI check background and font colours if words disappear
Просмотров 467 месяцев назад
Power BI: when making cosmetic changes, it can be easy to use colours which obscure other items. It's worth checking background and font colours if words appear to have magically disappeared. #powerbi #powerbitips #colours #powerbishorts #data #datavisualisation
Power BI: View pbix file from Sharepoint and Onedrive in a browser (new feature Oct23)
Просмотров 1,4 тыс.7 месяцев назад
Discover how to easily view Power BI reports without downloading the PBIX file! Learn how to view your Power BI pbix files directly in SharePoint and OneDrive using the new "Open in browser" feature. This new feature removes the hassle of downloading and opening reports in the Power BI Desktop to view the report pages. Please note that this feature's availability depends on your Power BI licens...
Power BI - Hide interactivity on chart
Просмотров 810Год назад
In Power BI there may be the rare occasion when you prefer the user not to be able to interact with a chart/diagram. Currently in Power BI it is not possible to turn off the interactivity. This video presents a work around solution. Timings: 00:00 - 00:32 Intro - the problem 00:32 - 00:40 Overview of a solution 00:41 - 02:05 Implementation of solution 02:02 - 04:23 Edit interactions - Other dia...
Welcome to Data For Knowledge
Просмотров 8 тыс.Год назад
Data, data, data, I love it. Hi, I’m Pauline. I analysis and visualise data and this is my channel Data For Knowledge. Here, I share data projects in Power BI and R Studio alongside technical insights to help you gain knowledge from your data. So what does this involve? Well, using Power BI or R Studio I create follow along projects using open data, which is data anyone is free to use. I explai...
Power BI insert blank column to table and remove wording in column header
Просмотров 12 тыс.Год назад
In a Power BI table to insert a blank column, you first create a column. Once created, formatting is required and any words/characters in the column header are removed. This video shows why a column header may not be visible on a Power BI report yet appears when the Print facility is selected. Timings: 00:00 Introduction 00:32 Create blank/empty column 02:00 Remove word/character from column he...
Linking cells in excel - link within tab, to another tab, to another spreadsheet
Просмотров 20 тыс.Год назад
In excel linking can be made from one cell to another on the same tab, from one cell to another on another tab, and even from a cell on one spreadsheet to a cell on another separate spreadsheet. More information can be found on Microsoft's website: support.microsoft.com/en-au/office/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e #excel #linkingcells #spreadsheets #data
Power BI - remove/alter default column header line or total lines on table or matrix
Просмотров 4,9 тыс.Год назад
Power BI - remove/alter default column header line or total lines on table or matrix
Power BI - in a table hide unwanted tooltips
Просмотров 2,7 тыс.Год назад
Power BI - in a table hide unwanted tooltips
Power BI format v datatype - when 2 + 2 shows 3 - incorrect totals
Просмотров 1,3 тыс.Год назад
Power BI format v datatype - when 2 2 shows 3 - incorrect totals
Power BI Gantt chart - day month year format on tooltip/hover over
Просмотров 4,4 тыс.Год назад
Power BI Gantt chart - day month year format on tooltip/hover over
Power BI - breakdown calculation using DAX variables and/or calculated columns
Просмотров 2 тыс.Год назад
Power BI - breakdown calculation using DAX variables and/or calculated columns
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Просмотров 18 тыс.Год назад
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Power BI - How to insert a line break into a page title using DAX UNICHAR
Просмотров 6 тыс.Год назад
Power BI - How to insert a line break into a page title using DAX UNICHAR
R programming - ggplot2 legend- examples of how to add, remove, alter the legend
Просмотров 3,1 тыс.Год назад
R programming - ggplot2 legend- examples of how to add, remove, alter the legend
R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
Просмотров 2,3 тыс.Год назад
R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
Sort order of categories in diagrams - have you used the order expected by the user?
Просмотров 185Год назад
Sort order of categories in diagrams - have you used the order expected by the user?
Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
Просмотров 6 тыс.Год назад
Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
How to create line chart with points using ggplot2 & plotly - includes data pivot - R Project
Просмотров 9 тыс.Год назад
How to create line chart with points using ggplot2 & plotly - includes data pivot - R Project
Why Chart Labels Matter: Making Your Data Understandable
Просмотров 136Год назад
Why Chart Labels Matter: Making Your Data Understandable
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
Просмотров 17 тыс.Год назад
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
When a left join of data tables goes wrong - accidentally omitting or creating data - oops!
Просмотров 187Год назад
When a left join of data tables goes wrong - accidentally omitting or creating data - oops!
CRUD - User requirements for data record in a database
Просмотров 271Год назад
CRUD - User requirements for data record in a database
Use colours in diagrams to help the user, not confuse!
Просмотров 161Год назад
Use colours in diagrams to help the user, not confuse!

Комментарии

  • @alondraespinal5115
    @alondraespinal5115 6 дней назад

    Great video, what about if the field is multi select? And in some cases the user picks two choices how can I write the measure so it shows both emojis in the same cell.

  • @terungwaemmanuel-i8h
    @terungwaemmanuel-i8h 24 дня назад

    The video is interesting

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

      Thank you! Thanks for watching the video

  • @alboy1233
    @alboy1233 25 дней назад

    Does anyone know how to show a Power Automate visual in this view?

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

    Amazing!

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

    Thank you! Even ChatGPT 4 was not able to help with solution

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

    it helped a lot merci

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

      Thanks! Glad you found the video helpful

  • @APerson-ky2gh
    @APerson-ky2gh 3 месяца назад

    Thanks so much, I'm a second year biology student who just started learning r for ecology data stuff and this video was so helpful

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Glad the video helped. Good luck with your studies!

  • @benysmart1643
    @benysmart1643 3 месяца назад

    Thanks for sharing.. welcome to Algeria

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Thanks for watching the video.

  • @jhaneman1231
    @jhaneman1231 3 месяца назад

    Hello, this helped me at this exact moment with a Dashboard that had this "issue". Thanks a lot.

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Glad the video helped.

  • @ThrillsofAwe
    @ThrillsofAwe 3 месяца назад

    OMG this helped alot!!!!!!!! thanks !!!!!!!!!!!!!!!

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you!

  • @sureshthongati1532
    @sureshthongati1532 3 месяца назад

    Thank You Ma'am need starting classes video if possible

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you for your kind words and suggestion

  • @leanne-se2sp
    @leanne-se2sp 3 месяца назад

    Hi, I'm in my 2nd year at university and have never been able to grasp R in any of the workshops but your video made it so easy! Thank you so much, I have been panicking about this assignment for weeks, and with your video, I can finally get it done, thank you again :) 10/10!

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Glad the video helped. Good luck with your studies!

  • @baxbanni2226
    @baxbanni2226 3 месяца назад

    Nice explanation. I am wondering what wiki makes possible and will defenitly try it out. 👍👍

    • @DFK_data
      @DFK_data 3 месяца назад

      Thanks! Yes, there is quite a lot of data in Wikidata. Hope you enjoy exploring!

  • @smg1928
    @smg1928 3 месяца назад

    This is awesome! Thank you! My excel crashed and now I'm trying to use R studio. This is exactly what I needed.

    • @DFK_data
      @DFK_data 3 месяца назад

      Thank you! Glad you found the video helpful.

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

    Hello, Thankyou for an eye opening video. Very well-researched and fine-made video this is.

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

      Thank you! Glad you enjoyed the video

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

    Nyz explanation.. tq mam❤

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

      Thank you!

  • @user-ih2kw8pf9t
    @user-ih2kw8pf9t 5 месяцев назад

    Thank you for this video! Very helpful tutorial!

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

      Thank you! Glad you found the video helpful.

  • @ren.auguste2200
    @ren.auguste2200 5 месяцев назад

    Excellent video! If I may ask, do you have any for species accumulation curves? Or know where can point me in the right direction? Hoping you have one, as you explained so well!

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

      Thank you! No I haven't done a video on species accumulation curves but perhaps a good idea for a future video.

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

    Nice and well detailed video.

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

      Thank you!

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

    Thanks for such an informative video. It is greatly appreciated.

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

      Thank you!

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

    Thank you very much indeed - that was exactly what I was looking for. Worked a treat. 🙂

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

      Thanks! Glad you found the video helpful.

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

    OMG, this video helped me so much!!

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

      Thanks! Glad you found the video helpful.

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

    Thanks for sharing, I was looking for something similar and this concept helped me to solve the problem. Glad to find your channel and lovely explanation.

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

      Thank you! Glad you found the video helpful.

  • @KhushiGupta-tr2vp
    @KhushiGupta-tr2vp 6 месяцев назад

    No RUclips video that explains this as clear;y as you did. Thank you very much!

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

      You're welcome! Thank you!

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

    Very vivid explanation❤👍

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

      Thank you!

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

    excellent video. straight to the point and everything worked.

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

      Thank you! Thanks for watching the video

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

    ❤👍

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

      Thank you!

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

    Great video- never knew this existed until now. Helps with what was going to be a massive headache

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

      Thank you! Glad you found the video helpful

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

    Thank you very much, your video has helped me a lot!

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

      Thank you! Glad you found the video helpful.

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

    greatly explained, Hats off!

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

      Thank you! Glad the video was helpful.

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

    Thank YOU so much! Quite informative! Have a Blessed New Year!

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

      Thank you! Glad you found the video helpful

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

    very simple , thank you

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

      Thanks!

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

    I spent 12 hours trying to get this. I watched several RUclips videos and no one explained it as clearly as you did. This is wonderful. Thank you!

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

      Thank you! Glad you found the video helpful.

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

    nice...very simple 100% working

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

      Thanks!

  • @user-oy2eb5cx3n
    @user-oy2eb5cx3n 8 месяцев назад

    Super useful video. Thank you so much

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

      You're welcome. Thanks!

  • @ZarahDominguez-cf2uc
    @ZarahDominguez-cf2uc 9 месяцев назад

    Thank you so much for this video, it helped me a lot

    • @DFK_data
      @DFK_data 9 месяцев назад

      You're welcome!

  • @laviecest5811
    @laviecest5811 9 месяцев назад

    Amazing

    • @DFK_data
      @DFK_data 9 месяцев назад

      Thank you!

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

    Thanks, This was driving me insane

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

      You are welcome!

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

    Column names with spaces can sometimes cause issues because R treats spaces as a special character that indicates the end of a command. To solve this, 1. you can use backticks to specify column names with spaces (e.g., ggplot(data, aes(x = `Age group`, y = Value)), 2. you can rename the column (e.g., data$Age_group <- data$`Age group`), 3. use quote (e.g., ggplot(data, aes(x = "Age group", y = Value)). I hope this will help

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

      Thanks!

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

    Thanks for this Upload!

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

      You're welcome! Thanks

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

    Can you please provide link for how you created it

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

      Hi, link to video showing how to create this gantt chart now added to this video's description.

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

    Love this!

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

      Thanks! Glad you enjoyed the video.

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

    This worked perfectly for me and was excatly what I needed. Thank you very much.

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

      Thank you! Glad it helped!

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

    thank you!

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

      You're welcome!

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

    Thank you so much for the video! You actually showed perfectly how to transform the excel sheet into a barplot in "R"!

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

      You're very welcome!

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

    Thanks a lot, very easy to follow. great solution!!!

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

      Thank you!

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

    Nice

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

      Thank you!

  • @papito-qf2jj
    @papito-qf2jj Год назад

    thanks alot , it is so helpful

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

      Thanks for watching the video! Glad it was helpful.

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

    Brilliant. Short, to the point, and helpful. Thank you.

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

    thats great