Hands-On-Data
Hands-On-Data
  • Видео 54
  • Просмотров 360 457
How to Convince Businesses to Go Data-Driven: A Guide for Consultants
Are you a consultant looking to help businesses embrace the power of data? Many non-data-driven companies struggle to see the value of analytics, but with the right approach, you can lead them to transformative insights and growth.
In this video, we share actionable strategies to help consultants guide businesses toward adopting data-driven solutions:
Demonstrating the value of data-driven decision-making using real-world comparisons.
Framing analytics around cost-associated decisions to resonate with business leaders.
Progressively introducing data technologies to ensure seamless adoption without overwhelming stakeholders.
These insights are designed to help you position your services as a tr...
Просмотров: 34

Видео

How to Stand Out as a Data Analyst: Leverage YouTube for Job Success
Просмотров 2621 день назад
Are you a data analyst looking to stand out in the competitive job market? This video reveals actionable strategies to showcase your skills, including using RUclips to demonstrate your problem-solving abilities. Learn how creating content can: 1️⃣ Show hiring managers what you can do. 2️⃣ Get you hired for temporary jobs or freelance gigs. 3️⃣ Boost your chances of internal referrals. Start bui...
Do I need to study SQL up to the advanced level given the presence of AI support tools?
Просмотров 2128 дней назад
In this video I answer the question on learning SQL in the presence of AI support tools. #sql #dataanalysis #ai SQL question and answer video ruclips.net/video/43hZz4-XtVo/видео.html
How to Perform Cohort Analysis Using Excel and Power Query
Просмотров 691Месяц назад
Learn how to perform Cohort Analysis using Microsoft Excel and Power Query in this step-by-step tutorial! Whether you're analyzing customer behavior, tracking retention, or uncovering business insights, this video makes it easy to master cohort analysis. Perfect for beginners and advanced Excel users alike. Watch now to enhance your data analysis skills! Link to file docs.google.com/spreadsheet...
Parents, Don’t Miss This! ChatGPT Can Transform Your Child’s Learning
Просмотров 47Месяц назад
This is a video on chat-gpt for children
SQL Questions & Answers - Basic to Intermediate
Просмотров 2673 месяца назад
#sql #sqltutorials #postgresql This video take 10 questions, each question helping to prepare you for the next question from basic SQL to intermediate SQL. Select, from, where, group by, order by, subquery, CTE, value conversion, date conversion and much more are considered in this video. The video is a good SQL for Beginners and SQL for refreshers.
Building Dashboards with Microsoft Excel - Video Game Sales Dashboard
Просмотров 3514 месяца назад
This video teaches how to use Microsoft Excel in building data dashboards. Pivot tables, shapes and excel functions and formulas have been used coupled with best practice principles in building dashboards. #dashboard #exceltutorial #exceldashboard
10 Questions & Answers - Using Microsoft Excel Pivot Tables
Просмотров 6496 месяцев назад
This video exploits Microsoft Excel's Pivot Tables in doing the following: 1. Analyze data 2. Lookup data presented in pivot tables 3. Use the Show value as feature to manipulate presentations a) Show values as percentage of row and column totals b) Show values as difference and percentage difference c) Rank values in a pivot table 4. chart data from pivot table 5. Use Slicers to drip down in e...
Microsoft Excel Test Questions and Solved Answers - Excel Interviews Part 2
Просмотров 2 тыс.9 месяцев назад
This video presents likely Microsoft excel test questions and solve them all. The aim of this video is to teach Microsoft Excel functions and formulas through hands-on problem solving. Part 1 ruclips.net/video/n2JqJwDpvrM/видео.html #excelinterview #excelinterviewquestionsandanswers #excelquickandeasy 📈 Get Personalized Training and Financial Modelling Expertise! 📊 Are you looking to enhance yo...
Microsoft Excel Test Questions and Solved Answers - Excel Interview Questions Part 1
Просмотров 6 тыс.9 месяцев назад
This video presents likely Microsoft excel test questions and solve them all. The aim of this video is to teach Microsoft Excel functions and formulas through hands-on problem solving. Part 2 ruclips.net/video/m7Z-GYKdDqc/видео.html #excelinterview #excelinterviewquestionsandanswers #excelquickandeasy 📈 Get Personalized Training and Financial Modelling Expertise! 📊 Are you looking to enhance yo...
Building Dynamic Monthly Operational (OPEX) Budget Template in Microsoft Excel
Просмотров 1,2 тыс.9 месяцев назад
Learn how to revolutionize your budgeting process using Microsoft Excel with this comprehensive tutorial. In this video, we dive into the intricacies of departmental budgeting, guiding you through the creation of individualized budget sheets for each department. Discover expert formatting techniques to ensure consistency and clarity across multiple sheets. Delve into the realm of automation as ...
Calculating & Modelling Depreciation - Comparing Depreciation Models: Straight-Line Method Showdown
Просмотров 25210 месяцев назад
In this video, we delve into the world of depreciation modeling, focusing on the straight-line method. 📉 We'll explore two different approaches to modeling depreciation, highlighting their key differences and effectiveness. 💡 Whether you're a finance enthusiast, accounting student, or business owner, understanding depreciation is crucial, and we've got you covered! Join us as we break down comp...
Screen Annotation with Zoomit Verson 8 2024
Просмотров 34310 месяцев назад
Learn how to enhance your presentations and tutorials with ZoomIt version 8! In this tutorial, we'll walk you through the features and functionalities of ZoomIt's screen annotation tool, enabling you to effortlessly highlight key points, draw attention to specific areas, and engage your audience like never before. Whether you're a teacher, trainer, or content creator, mastering ZoomIt's latest ...
Accounting Equation Demystified
Просмотров 5110 месяцев назад
Unlock the mysteries of accounting and financial statements with our comprehensive guide! Dive deep into the core concepts of the balance sheet equation and discover how it intertwines with the income statement and cash flow statement. Through clear explanations and detailed diagrams, this video breaks down complex financial jargon into digestible bits, making it easier for beginners and season...
Creating Depreciation Schedule - Long and Short Option
Просмотров 11711 месяцев назад
Creating Depreciation Schedule - Long and Short Option
Introduction to HR Dashboards #hr #hrmetrics #hrdashboards
Просмотров 4903 года назад
Introduction to HR Dashboards #hr #hrmetrics #hrdashboards
Analyzing Nigeria's Historic Foreign Exchange Rates data with Python Pandas #python #pandas #nigeria
Просмотров 1073 года назад
Analyzing Nigeria's Historic Foreign Exchange Rates data with Python Pandas #python #pandas #nigeria
Dax SELECTCOLUMNS Function #daxstudio #dax #daxfunctions #powerbi
Просмотров 2933 года назад
Dax SELECTCOLUMNS Function #daxstudio #dax #daxfunctions #powerbi
Stem and Leaf Plot using Microsoft Excel #charts #statistics #excel
Просмотров 6 тыс.3 года назад
Stem and Leaf Plot using Microsoft Excel #charts #statistics #excel
Relative and Absolute Referencing
Просмотров 793 года назад
Relative and Absolute Referencing
Excel Referencing Cell Range
Просмотров 3563 года назад
Excel Referencing Cell Range
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Просмотров 1154 года назад
Deep Dive: Excel Functions & Formulas - Mental Blocks that Hinder Mastery of Excel Functions
Introduction - Deep Dive Learning in Excel Functions and Formulas
Просмотров 844 года назад
Introduction - Deep Dive Learning in Excel Functions and Formulas
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Просмотров 1,2 тыс.4 года назад
Creating Organizational Charts with Microsoft Excel #excel #organizationalchart #charting
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Просмотров 8694 года назад
Working with DAX Studio | Splitting Tables | Relationships in Data Model
Number Format| Formatting Values in Cells in Microsoft Excel.
Просмотров 1274 года назад
Number Format| Formatting Values in Cells in Microsoft Excel.
Creating Fixed Assets Registers
Просмотров 50 тыс.4 года назад
Creating Fixed Assets Registers
Working with Dax Studio | Introduction to Using Dax Studio for Dax
Просмотров 3,4 тыс.4 года назад
Working with Dax Studio | Introduction to Using Dax Studio for Dax
Aligning text in Microsoft Excel | Working with Microsoft Excel Tools
Просмотров 3114 года назад
Aligning text in Microsoft Excel | Working with Microsoft Excel Tools
Advance Copy and Paste | Working with Microsoft Excel Tools
Просмотров 1214 года назад
Advance Copy and Paste | Working with Microsoft Excel Tools

Комментарии

  • @juliaf3044
    @juliaf3044 День назад

    I started watching your presentation last night and just finished it. I really enjoyed your approach. The step-by-step guide, with the use of the case study, was very helpful. I am going to share with my colleagues. I've never felt confident using Pivot tables; your walk-through has been a tremendous help. Thank you again!😃

    • @hands-on-data
      @hands-on-data День назад

      Wao! Thank you. Your complements made my day🙏🙏🙌

  • @juliaf3044
    @juliaf3044 2 дня назад

    This presentation is extremely helpful - thank you!

    • @hands-on-data
      @hands-on-data 2 дня назад

      So happy you found it helpful. Let me know if there is any way I can be of further help.

  • @Jayhari2025
    @Jayhari2025 3 дня назад

    👍🏻

  • @pushpayancharla9859
    @pushpayancharla9859 12 дней назад

    Me one doubt sir

  • @WouterOudshoorn-ic5ql
    @WouterOudshoorn-ic5ql 21 день назад

    Excellent video! Thank you for taking the time to prepare and share😃

    • @hands-on-data
      @hands-on-data 21 день назад

      I am happy to know you found it useful. Thank you.

  • @raphaelokoye4310
    @raphaelokoye4310 22 дня назад

    Great work sir

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

    Great work!!

  • @SabtechOnline
    @SabtechOnline 29 дней назад

    Thanks for sharing @high5 Tutorials

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

    I’m always pleased to follow your insights 👏

    • @hands-on-data
      @hands-on-data Месяц назад

      Thank you very much for your kind words.

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

    Thank you ! Excellent video

    • @hands-on-data
      @hands-on-data Месяц назад

      Thank you. Happy to know you liked it

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

    Sir why don't you solve those business questions btw video is very helpful for learning basics and one more thing i genuinely request you to improve your video quality i need one more help like can you please provide me this excel sheet

  • @Mark-sf4kh
    @Mark-sf4kh 3 месяца назад

    Nice job bossss

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

    Thanks!

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

    Thanks for recording and sharing your knowledge. Bringing in the combo box is a top-notch idea 🔥🔥🔥🔥🔥🔥🔥🔥

    • @hands-on-data
      @hands-on-data 4 месяца назад

      Thank you very much. I very well appreciate you compliments.

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

      You are the real MVP🙌. Thanks Charles

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

    This is the best tutorial ever! I had never done a process chart before and did a picture perfect one with your tutorial! You also saved me a lot of stress. Thanks again!

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

    Great explanations. Perhaps you can provide the workbook for practice.

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

    thank you for this video. 🙂🤝

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      Thank very much for your kind appreciation.

    • @hands-on-data
      @hands-on-data 5 месяцев назад

      Thank you for your kind appreciation

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

    To get the end date I can't get the answer,is showing #Value

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      Check your cell that have the start and end date. Make sure the date reads month number/day number/year number. Or dd-mmm-yyyy format. Hopefully, this will help

  • @dennisappiah-kubi5269
    @dennisappiah-kubi5269 6 месяцев назад

    Thank you for this video. It was very helpful!

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      So happy you enjoyed it.Thank you

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

    please text sumif formula apply in gross block

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      Check the condition within your sumif function. If you have multiple conditions, use sumifs.

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      Check the condition in your sumif formula. Make sure it matches. Also make sure that the sum and criteria range is completely referenced. If you are using multiple conditions, use sumifs function.

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

    Thank you for helping me understand index match. Your explanation were simple and clear

  • @MuhammadIrfan-ml5gb
    @MuhammadIrfan-ml5gb 7 месяцев назад

    Lovely

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

    Very good content

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

    Great stuff

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

    VERY HELPFUL AND easy to apply

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

    This is the best explanation of index and match I have seen in a long time time🎉

    • @hands-on-data
      @hands-on-data 9 месяцев назад

      So happy you found it understandable

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

    great content sir!!

    • @hands-on-data
      @hands-on-data 9 месяцев назад

      Thank you for watching. Glad you found it a great content

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

    At the end of video you mentioned something about being unable to reduce the width of the line in the drawing mode. I found out that this could be possible by holding down the shift key and scrolling down with your mouse wheel.

    • @hands-on-data
      @hands-on-data 9 месяцев назад

      Thank you for watching and for adding value to this video. Happy to learn from you.

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

    Hi Charles! This is a great video. I would love to connect and discuss this template with you. I sent you a LinkedIn invite to connect. Thank you.

    • @hands-on-data
      @hands-on-data 9 месяцев назад

      I am happy you live it. Connected. Thank you.

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

    I appreciate the informative video. Currently, I'm experiencing problems with the index formula as it doesn't capture the total amount for a specific asset class, eg for furniture and fittings. The index formulae seems to be missing some asset values when calculating the gross black for the same asset asset class on different rows

    • @hands-on-data
      @hands-on-data 10 месяцев назад

      I am very sorry for late response. I may need to look the spreadsheet with you using not sensitive data. otogca@gmail.com. However, the index function returns a value and not the sum of values. The sumifs function should do the job if I understood what you have stated. Thank you for the compliments

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

      @@hands-on-data Thank you for reaching out. It has been sorted already

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

    OMG this was so helpful. Thankyou Sir !

    • @hands-on-data
      @hands-on-data 10 месяцев назад

      Welcome. Happy to know it helped

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

    What a fantastic video and tutorial, thanks for all your help.

    • @hands-on-data
      @hands-on-data 8 месяцев назад

      Welcome and thank you for watching.

  • @sindhujamilkuri-k2c
    @sindhujamilkuri-k2c Год назад

    What is the Report Date and how do I know about the Report Date

    • @hands-on-data
      @hands-on-data 10 месяцев назад

      Just like in monthly reports, the report date is the last day of a report month. However, the report date can be any date from which the report need to be evaluated

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

    What is the Report Date and how do I know about the Report Date

  • @christyo.9125
    @christyo.9125 Год назад

    This video is very helpful, thank you for your time.

  • @christyo.9125
    @christyo.9125 Год назад

    Very impactful. highly simplified

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

    Thank you a lot!

    • @hands-on-data
      @hands-on-data 6 месяцев назад

      Thanks for the appreciation. You inspire me.

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

    Thanks i enjoyed the lecture.

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

    Thank you so much

  • @H-do8tr
    @H-do8tr Год назад

    Great tutorial! Speaking about the disposal, what about if I want to dispose a part of an asset amount not an entire asset?

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

    Thank you very much. Very helpful

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

    Thanx

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

    Great presentation

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

    Hi - Trying to do the Gross Block - the formula only calculates the first row of figures and not the 10 ( I have 11 rows of assets) any ideas ??

    • @hands-on-data
      @hands-on-data 10 месяцев назад

      Use Sumifs to calculate the gross block

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

    Golden, thanks!

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

    I should probably learn to use Visio but with limited time I am attempting to use Excel.

    • @hands-on-data
      @hands-on-data 14 дней назад

      That is the advantage of Excel - A rapid flowchart development tool

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

    You are a genius! Thanks so much xx😍

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

    Is a good practical PPE register. I tried it but released that the depreciation per day is not zero when the asset reached its useful life. Therefore push the lapse days more than the uesful life days abd the net effect is in negative

    • @hands-on-data
      @hands-on-data 10 месяцев назад

      Could it be because of the salvage value?

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

    Was helpful. Thanks.

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

    Very good, thanks