Data For Knowledge
Data For Knowledge
  • 64
  • 272 225
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
zhlédnutí: 330

Video

Excel - Calculate Duration - number of days between two dates0:52Excel - Calculate Duration - number of days between two dates
Excel - Calculate Duration - number of days between two dates
zhlédnutí 499Před 2 měsíci
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 columns0:50Excel - Move the position of a column - reorder columns
Excel - Move the position of a column - reorder columns
zhlédnutí 568Před 2 měsíci
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!1:10Excel import to Power BI - Watch out for strikethroughs!
Excel import to Power BI - Watch out for strikethroughs!
zhlédnutí 124Před 6 měsíci
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 visualisations3:35Why layer order matters in data visualisations
Why layer order matters in data visualisations
zhlédnutí 5KPřed 6 měsíci
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 consider7:31Power BI - Combining diagrams - Items to consider
Power BI - Combining diagrams - Items to consider
zhlédnutí 1,6KPřed 6 měsíci
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 matters1:27Power BI - Misplaced diagrams - Layer order matters
Power BI - Misplaced diagrams - Layer order matters
zhlédnutí 150Před 6 měsíci
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: czcams.com/video/HAwc16JWg74/video.html Power BI - Combining diagrams - Items to consider czcams.com/video/V9yE-MLNRic/video.html Layer order matters in data visualisations #pow...
Power BI check background and font colours if words disappear0:43Power BI check background and font colours if words disappear
Power BI check background and font colours if words disappear
zhlédnutí 45Před 6 měsíci
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:20Power BI: View pbix file from Sharepoint and Onedrive in a browser (new feature Oct23)
Power BI: View pbix file from Sharepoint and Onedrive in a browser (new feature Oct23)
zhlédnutí 1,2KPřed 6 měsíci
Power BI: video features recent improvements by Microsoft to allow pbix files saved in SharePoint or OneDrive to be viewed in a browser. The Power BI file used in this video can be viewed on Microsoft's Data Stories Gallery at community.fabric.microsoft.com/t5/Data-Stories-Gallery/Analysing-Domestic-Housing-Energy-Performance-Certificates-EPCs/m-p/3350823 #powerbitips #powerbi #sharepoint #oned...
Power BI - Hide interactivity on chart4:23Power BI - Hide interactivity on chart
Power BI - Hide interactivity on chart
zhlédnutí 775Před 11 měsíci
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 Knowledge0:29Welcome to Data For Knowledge
Welcome to Data For Knowledge
zhlédnutí 8KPřed rokem
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 header5:33Power BI insert blank column to table and remove wording in column header
Power BI insert blank column to table and remove wording in column header
zhlédnutí 12KPřed rokem
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 spreadsheet1:59Linking cells in excel - link within tab, to another tab, to another spreadsheet
Linking cells in excel - link within tab, to another tab, to another spreadsheet
zhlédnutí 18KPřed rokem
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 matrix3:43Power BI - remove/alter default column header line or total lines on table or matrix
Power BI - remove/alter default column header line or total lines on table or matrix
zhlédnutí 4,7KPřed rokem
Power BI - remove/alter default column header line or total lines on table or matrix
Power BI - in a table hide unwanted tooltips1:09Power BI - in a table hide unwanted tooltips
Power BI - in a table hide unwanted tooltips
zhlédnutí 2,6KPřed rokem
Power BI - in a table hide unwanted tooltips
Power BI format v datatype - when 2 + 2 shows 3 - incorrect totals6:46Power BI format v datatype - when 2 + 2 shows 3 - incorrect totals
Power BI format v datatype - when 2 + 2 shows 3 - incorrect totals
zhlédnutí 1,3KPřed rokem
Power BI format v datatype - when 2 2 shows 3 - incorrect totals
Power BI Gantt chart - day month year format on tooltip/hover over2:28Power BI Gantt chart - day month year format on tooltip/hover over
Power BI Gantt chart - day month year format on tooltip/hover over
zhlédnutí 4,3KPřed rokem
Power BI Gantt chart - day month year format on tooltip/hover over
Power BI - breakdown calculation using DAX variables and/or calculated columns14:38Power BI - breakdown calculation using DAX variables and/or calculated columns
Power BI - breakdown calculation using DAX variables and/or calculated columns
zhlédnutí 2KPřed rokem
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 field5:49Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
zhlédnutí 17KPřed rokem
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 UNICHAR3:37Power BI - How to insert a line break into a page title using DAX UNICHAR
Power BI - How to insert a line break into a page title using DAX UNICHAR
zhlédnutí 6KPřed rokem
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 legend9:24R programming - ggplot2 legend- examples of how to add, remove, alter the legend
R programming - ggplot2 legend- examples of how to add, remove, alter the legend
zhlédnutí 3KPřed rokem
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 ggplot211:11R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
R programming - how to create small multiples diagram using facet_wrap and facet_grid from ggplot2
zhlédnutí 2,3KPřed rokem
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?5:27Sort order of categories in diagrams - have you used the order expected by the user?
Sort order of categories in diagrams - have you used the order expected by the user?
zhlédnutí 185Před rokem
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.28:44Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
Power BI - Gantt chart showing asset hire periods. How to create off-hire periods in gantt chart.
zhlédnutí 5KPřed rokem
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 Project20:08How to create line chart with points using ggplot2 & plotly - includes data pivot - R Project
How to create line chart with points using ggplot2 & plotly - includes data pivot - R Project
zhlédnutí 9KPřed rokem
How to create line chart with points using ggplot2 & plotly - includes data pivot - R Project
Why add labels to charts? What labels can be helpful?3:32Why add labels to charts? What labels can be helpful?
Why add labels to charts? What labels can be helpful?
zhlédnutí 134Před rokem
Why add labels to charts? What labels can be helpful?
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column21:24R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
R Project - how to create bar chart (ggplot2) from spreadsheet-includes data pivot & remove a column
zhlédnutí 16KPřed rokem
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!11:07When a left join of data tables goes wrong - accidentally omitting or creating data - oops!
When a left join of data tables goes wrong - accidentally omitting or creating data - oops!
zhlédnutí 186Před rokem
When a left join of data tables goes wrong - accidentally omitting or creating data - oops!
CRUD - User requirements for data record in a database1:40CRUD - User requirements for data record in a database
CRUD - User requirements for data record in a database
zhlédnutí 260Před rokem
CRUD - User requirements for data record in a database
Use colours in diagrams to help the user, not confuse!2:54Use colours in diagrams to help the user, not confuse!
Use colours in diagrams to help the user, not confuse!
zhlédnutí 160Před rokem
Use colours in diagrams to help the user, not confuse!

Komentáře

  • @qb01-24
    @qb01-24 Před 5 hodinami

    15:25

  • @terungwaemmanuel-i8h
    @terungwaemmanuel-i8h Před 9 dny

    The video is interesting

    • @DFK_data
      @DFK_data Před 9 dny

      Thank you! Thanks for watching the video

  • @alboy1233
    @alboy1233 Před 10 dny

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

  • @claudiopereira5163
    @claudiopereira5163 Před měsícem

    Amazing!

  • @zhirayrbebutyan9046
    @zhirayrbebutyan9046 Před měsícem

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

  • @joserochefort7778
    @joserochefort7778 Před měsícem

    it helped a lot merci

    • @DFK_data
      @DFK_data Před měsícem

      Thanks! Glad you found the video helpful

  • @APerson-ky2gh
    @APerson-ky2gh Před 2 měsíci

    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 Před 2 měsíci

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

  • @benysmart1643
    @benysmart1643 Před 2 měsíci

    Thanks for sharing.. welcome to Algeria

    • @DFK_data
      @DFK_data Před 2 měsíci

      Thank you! Thanks for watching the video.

  • @jhaneman1231
    @jhaneman1231 Před 2 měsíci

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

    • @DFK_data
      @DFK_data Před 2 měsíci

      Thank you! Glad the video helped.

  • @ThrillsofAwe
    @ThrillsofAwe Před 2 měsíci

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

  • @sureshthongati1532
    @sureshthongati1532 Před 2 měsíci

    Thank You Ma'am need starting classes video if possible

    • @DFK_data
      @DFK_data Před 2 měsíci

      Thank you for your kind words and suggestion

  • @leanne-se2sp
    @leanne-se2sp Před 3 měsíci

    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 Před 3 měsíci

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

  • @baxbanni2226
    @baxbanni2226 Před 3 měsíci

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

    • @DFK_data
      @DFK_data Před 3 měsíci

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

  • @smg1928
    @smg1928 Před 3 měsíci

    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 Před 3 měsíci

      Thank you! Glad you found the video helpful.

  • @shubhamsanas5242
    @shubhamsanas5242 Před 4 měsíci

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

    • @DFK_data
      @DFK_data Před 4 měsíci

      Thank you! Glad you enjoyed the video

  • @viralcutz958
    @viralcutz958 Před 4 měsíci

    Nyz explanation.. tq mam❤

  • @user-ih2kw8pf9t
    @user-ih2kw8pf9t Před 4 měsíci

    Thank you for this video! Very helpful tutorial!

    • @DFK_data
      @DFK_data Před 4 měsíci

      Thank you! Glad you found the video helpful.

  • @ren.auguste2200
    @ren.auguste2200 Před 5 měsíci

    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 Před 5 měsíci

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

  • @TradeWithKola
    @TradeWithKola Před 5 měsíci

    Nice and well detailed video.

  • @lindalangford320
    @lindalangford320 Před 5 měsíci

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

  • @debbieking8688
    @debbieking8688 Před 5 měsíci

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

    • @DFK_data
      @DFK_data Před 5 měsíci

      Thanks! Glad you found the video helpful.

  • @cristianjesus255
    @cristianjesus255 Před 5 měsíci

    OMG, this video helped me so much!!

    • @DFK_data
      @DFK_data Před 5 měsíci

      Thanks! Glad you found the video helpful.

  • @user-dm8dl4ef3v
    @user-dm8dl4ef3v Před 5 měsíci

    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 Před 5 měsíci

      Thank you! Glad you found the video helpful.

  • @KhushiGupta-tr2vp
    @KhushiGupta-tr2vp Před 6 měsíci

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

    • @DFK_data
      @DFK_data Před 6 měsíci

      You're welcome! Thank you!

  • @kebincui
    @kebincui Před 6 měsíci

    Very vivid explanation❤👍

  • @richardpenman1936
    @richardpenman1936 Před 6 měsíci

    excellent video. straight to the point and everything worked.

    • @DFK_data
      @DFK_data Před 6 měsíci

      Thank you! Thanks for watching the video

  • @kebincui
    @kebincui Před 6 měsíci

    ❤👍

  • @MDTPBI
    @MDTPBI Před 6 měsíci

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

    • @DFK_data
      @DFK_data Před 6 měsíci

      Thank you! Glad you found the video helpful

  • @soujanyapisipati6260
    @soujanyapisipati6260 Před 6 měsíci

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

    • @DFK_data
      @DFK_data Před 6 měsíci

      Thank you! Glad you found the video helpful.

  • @naveediqbal8683
    @naveediqbal8683 Před 7 měsíci

    greatly explained, Hats off!

    • @DFK_data
      @DFK_data Před 7 měsíci

      Thank you! Glad the video was helpful.

  • @DingDongGrahamBell
    @DingDongGrahamBell Před 7 měsíci

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

    • @DFK_data
      @DFK_data Před 7 měsíci

      Thank you! Glad you found the video helpful

  • @seifeldinazzam
    @seifeldinazzam Před 7 měsíci

    very simple , thank you

  • @jenniferenekebe8475
    @jenniferenekebe8475 Před 8 měsíci

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

    • @DFK_data
      @DFK_data Před 8 měsíci

      Thank you! Glad you found the video helpful.

  • @zenboxs8128
    @zenboxs8128 Před 8 měsíci

    nice...very simple 100% working

  • @user-oy2eb5cx3n
    @user-oy2eb5cx3n Před 8 měsíci

    Super useful video. Thank you so much

    • @DFK_data
      @DFK_data Před 8 měsíci

      You're welcome. Thanks!

  • @ZarahDominguez-cf2uc
    @ZarahDominguez-cf2uc Před 8 měsíci

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

  • @laviecest5811
    @laviecest5811 Před 8 měsíci

    Amazing

  • @MrRedPortal30
    @MrRedPortal30 Před 9 měsíci

    Thanks, This was driving me insane

  • @ibrahimlawan9663
    @ibrahimlawan9663 Před 9 měsíci

    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

  • @heinkruger9481
    @heinkruger9481 Před 9 měsíci

    Thanks for this Upload!

    • @DFK_data
      @DFK_data Před 9 měsíci

      You're welcome! Thanks

  • @uwish7
    @uwish7 Před 9 měsíci

    Can you please provide link for how you created it

    • @DFK_data
      @DFK_data Před 9 měsíci

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

  • @pedropuente3761
    @pedropuente3761 Před 9 měsíci

    Love this!

    • @DFK_data
      @DFK_data Před 9 měsíci

      Thanks! Glad you enjoyed the video.

  • @hamdyamrizal3955
    @hamdyamrizal3955 Před 10 měsíci

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

    • @DFK_data
      @DFK_data Před 10 měsíci

      Thank you! Glad it helped!

  • @hellmutmatheus2626
    @hellmutmatheus2626 Před 10 měsíci

    thank you!

  • @lucacotan4492
    @lucacotan4492 Před 11 měsíci

    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 Před 11 měsíci

      You're very welcome!

  • @xyclos
    @xyclos Před 11 měsíci

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

  • @Sasaaa_Sema
    @Sasaaa_Sema Před 11 měsíci

    Nice

  • @papito-qf2jj
    @papito-qf2jj Před 11 měsíci

    thanks alot , it is so helpful

    • @DFK_data
      @DFK_data Před 11 měsíci

      Thanks for watching the video! Glad it was helpful.

  • @kamaur01
    @kamaur01 Před rokem

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

  • @justmejustme4444
    @justmejustme4444 Před rokem

    thats great