Data with Decision
Data with Decision
  • 284
  • 3 976 280
Excel Sales Dashboard: Analyze and Visualize Data Like a Pro | Part 02
Welcome to our latest tutorial on creating a powerful Excel Sales Dashboard! In this video, we'll guide you through the process of analyzing and visualizing your sales data with professional-level dashboards using Microsoft Excel. Whether you're a beginner or an experienced user, this step-by-step guide will help you unlock the full potential of Excel to track sales performance, identify key trends, and make data-driven decisions.
Part-1 here: ua-cam.com/video/4Y-RWtM2ejw/v-deo.html
Download the Resources here: drive.google.com/file/d/1jZRqbO51D5iUtxkFsKjnyXV-LCBKRv3K/view?usp=sharing
Subscribe to my new channel here: www.youtube.com/@UCbUZNE4Yde0QUqoov50O1_Q
Need help with your data? Send WhatsApp message to +234 810 6090 365
You'll learn how to:
- Import and clean your sales data for accurate analysis.
- Create dynamic charts and graphs that update automatically.
- Use Excel formulas and functions to calculate essential metrics.
- Design a user-friendly dashboard layout that showcases your data effectively.
- Customize your dashboard with interactive features like slicers and drop-downs.
By the end of this video, you'll have the skills to build an Excel Sales Dashboard that not only looks great but also provides valuable insights into your business performance.
Don't forget to like, share, and subscribe for more Excel tips and tutorials!
00:00 - Intro
02:18 - Data Transformation
28: 47 - Formatting the Dashboard Background
38:50 - Creating our first Pivot Table
52:17 - Getting some Icons for our KPIs
55:07 - Profitability Analysis
1:00:57 - Revenue by Age-Group chart with special highlights
Переглядів: 1 318

Відео

Excel Sales Dashboard: Analyze and Visualize Data Like a Pro | Part 01
Переглядів 3,6 тис.16 годин тому
Welcome to our latest tutorial on creating a powerful Excel Sales Dashboard! In this video, we'll guide you through the process of analyzing and visualizing your sales data with professional-level dashboards using Microsoft Excel. Whether you're a beginner or an experienced user, this step-by-step guide will help you unlock the full potential of Excel to track sales performance, identify key tr...
Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop
Переглядів 3,8 тис.14 днів тому
Part-3 Transforming Healthcare Data into Insights | Power BI Dashboard Tutorial In this video, I demonstrate how to create an insightful and detailed healthcare dashboard using Power BI. We’ll explore the financial performance and provider insights of a healthcare center with advanced data analytics techniques. Watch as I utilize Power Query, Power BI Desktop, DAX, and PowerPoint to craft custo...
Focus on Those Areas in Microsoft Excel if you want to become a Data Analyst | Microsoft Excel
Переглядів 86114 днів тому
If you want to learn and Master Microsoft Excel please focus on those areas listed in this video. Do not be in a rush, take your time to learn every segment of Microsoft Excel before you move to other tools.
To all Data Analyst | This is how to Host and generate free Image Link for Your Dynamic Dashboards
Переглядів 87821 день тому
Change your boring Dashboards to something very dynamic with interactive images Get the images and dataset used here: drive.google.com/file/d/1bfSUntwPCjuaKzqqLImP-MPj-s40EOwM/view?usp=sharing Follow all the steps to understand how you can generate an image link Watch my other videos here: ua-cam.com/users/datawithdecision
Data Analyst | List of the Projects you Need to add to you Portfolio
Переглядів 1,4 тис.21 день тому
If you want to succeed as a Data Analyst, you need to watch this video to learn about the types of projects, dashboards, and reports you should add to your portfolio to achieve success in this field. Learn how to create a Portfolio here: ua-cam.com/video/0n2Ax6Cjvo8/v-deo.html
Create Power BI Dashboard from YouTube Comment | Beginner Power BI Dashboard
Переглядів 2,1 тис.Місяць тому
Create Power BI Dashboard from UA-cam Comment | Beginner Power BI Dashboard
Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop
Переглядів 5 тис.Місяць тому
Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop
Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop
Переглядів 34 тис.2 місяці тому
Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop
Power BI Dashboard Insights | Chris Brown ft Davido 'Hmmm' Comment Analysis
Переглядів 3,9 тис.2 місяці тому
Power BI Dashboard Insights | Chris Brown ft Davido 'Hmmm' Comment Analysis
Power BI Dashboard Makeover | How to create a Clean and Interactive Power BI Dashboard / Report
Переглядів 1,5 тис.2 місяці тому
Power BI Dashboard Makeover | How to create a Clean and Interactive Power BI Dashboard / Report
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Переглядів 3,8 тис.2 місяці тому
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Power BI Dashboard Makeover | How to create a Clean and Interactive Power BI Dashboard / Report
Переглядів 3,3 тис.2 місяці тому
Power BI Dashboard Makeover | How to create a Clean and Interactive Power BI Dashboard / Report
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Переглядів 4,6 тис.3 місяці тому
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Переглядів 4,6 тис.3 місяці тому
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop:
Переглядів 13 тис.3 місяці тому
Be Creative with Power BI Dashboard | Creating a Drug Sales Dashboard Using Power BI Desktop:
Interactive Insights: Excel Dashboard Techniques. How to Create Excel Dashboard YouTube Video
Переглядів 26 тис.4 місяці тому
Interactive Insights: Excel Dashboard Techniques. How to Create Excel Dashboard UA-cam Video
Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard.
Переглядів 15 тис.4 місяці тому
Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard.
Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard
Переглядів 149 тис.4 місяці тому
Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard
Advanced Microsoft Excel Dashboards with ChartGPT: Leveraging AI for Data Analytics (part-2)
Переглядів 4,8 тис.5 місяців тому
Advanced Microsoft Excel Dashboards with ChartGPT: Leveraging AI for Data Analytics (part-2)
Advanced Microsoft Excel Dashboards with ChartGPT: Leveraging AI for Data Analytics
Переглядів 8 тис.5 місяців тому
Advanced Microsoft Excel Dashboards with ChartGPT: Leveraging AI for Data Analytics
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
Переглядів 6 тис.6 місяців тому
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
Переглядів 6 тис.7 місяців тому
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
Переглядів 4,7 тис.7 місяців тому
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
Переглядів 10 тис.7 місяців тому
2024 Power BI Essentials: Crafting Cutting-Edge Transportation Reports
Power BI Tutorial for you. Learn How to Analyze Crime Datasets Using Power Desktop | Understand DAX
Переглядів 7 тис.7 місяців тому
Power BI Tutorial for you. Learn How to Analyze Crime Datasets Using Power Desktop | Understand DAX
Power BI Tutorial for you. Learn How to Analyze Crime Datasets Using Power Desktop | Understand DAX
Переглядів 16 тис.8 місяців тому
Power BI Tutorial for you. Learn How to Analyze Crime Datasets Using Power Desktop | Understand DAX
Power BI Healthcare Analytic Dashboard | Hospital - Clinics Report. Create a Report in Power BI.
Переглядів 85 тис.8 місяців тому
Power BI Healthcare Analytic Dashboard | Hospital - Clinics Report. Create a Report in Power BI.
Power BI | Build Dynamic Report/Dashboard in Power BI Desktop
Переглядів 12 тис.9 місяців тому
Power BI | Build Dynamic Report/Dashboard in Power BI Desktop
Power BI | Build Dynamic Report/Dashboard in Power BI Desktop
Переглядів 11 тис.9 місяців тому
Power BI | Build Dynamic Report/Dashboard in Power BI Desktop

КОМЕНТАРІ

  • @Ashu23200
    @Ashu23200 5 годин тому

    CAN'T SEE SETTINGS OTHER THAN CAPACITY SETTINGS

    • @datalab365
      @datalab365 4 години тому

      @@Ashu23200 you need the admin to give you access.

  • @vivekvhurtel6848
    @vivekvhurtel6848 16 годин тому

    Your content are amazing

    • @datalab365
      @datalab365 16 годин тому

      @@vivekvhurtel6848 You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @njabulosidwell1586
    @njabulosidwell1586 16 годин тому

    THANK YOU 😎😎😎😎 YOU ARE THE BEST ...

    • @datalab365
      @datalab365 4 години тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @vivekvhurtel6848
    @vivekvhurtel6848 18 годин тому

    BottomNDrugs = VAR NumBottomDrugs = 'TopBottom Slides'[TopBottom Slides Value] VAR AllDrugs = FILTER( ADDCOLUMNS( ALLSELECTED(DrugLookup), "TotalProfit", [Total Profit] ), NOT(ISBLANK([TotalProfit])) ) VAR BottomDrugs = TOPN( NumBottomDrugs, AllDrugs, [TotalProfit], ASC ) VAR ActiveDrug = SELECTEDVALUE(DrugLookup[DrugName]) RETURN IF( CONTAINS(BottomDrugs, DrugLookup[DrugName], ActiveDrug), [Total Profit], BLANK() ) This solves an issue ,but yours was working fine

    • @datalab365
      @datalab365 4 години тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @mahrozhayat-fw4iu
    @mahrozhayat-fw4iu 18 годин тому

    I 've been thoroughly impressed with your exceptional work on data analysis! I've watched each and every video, and I must say, your channel is one of the greatest resources for learning data-driven decision making. I'm eager to learn more about Excel and Power BI, particularly how to create interactive dashboards. Your channel is the perfect place to start!

    • @datalab365
      @datalab365 18 годин тому

      @@mahrozhayat-fw4iu You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

    • @mahrozhayat-fw4iu
      @mahrozhayat-fw4iu 7 годин тому

      @@datalab365 Already Subscribed

  • @vivekvhurtel6848
    @vivekvhurtel6848 19 годин тому

    brother ,suck on top and bottom,both are working fine without month slicer however with month slicer only top is working and bottom aint working ,i have pasted that in card it returns Blank()

    • @datalab365
      @datalab365 18 годин тому

      @@vivekvhurtel6848 watch carefully. You might be missing a step.

  • @FrancianiTalani
    @FrancianiTalani 20 годин тому

    Hi, Does anyone know if there's a video of the relationships in this database?

    • @datalab365
      @datalab365 19 годин тому

      @@FrancianiTalani for relationship go-to my new channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @thequintessentialintrovert1510
    @thequintessentialintrovert1510 23 години тому

    Afternoon Data with Decision Team. After several days of recreating this tutorial step by step, I can confidently say that it was worth it. I am in full appreciation of your work. I have been searching for a comprehensive tutorial on Excel for Data Analytics particularly around constructing pivot tables, creating lookup tables and creating links in the dashboard. I am so grateful that I somehow landed on your page. Thank you very much for adding to my data analytics learning. I will be recreating more. From: South Africa

    • @datalab365
      @datalab365 21 годину тому

      @@thequintessentialintrovert1510 Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @obas0weibo820
    @obas0weibo820 День тому

    Asuu strike nko?

    • @datalab365
      @datalab365 День тому

      Abi oo 😭

    • @datalab365
      @datalab365 День тому

      You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @kayodeanjorin8914
    @kayodeanjorin8914 День тому

    How to to start earning after learning Show me way my boss

    • @datalab365
      @datalab365 День тому

      Learn and master the tools first then start creating content. You sell more when you teach others how to make the same thing you to sell to them. Post snippet of your creative works on social media. The money will fall in. Remember, you will have to be good not just average. Spend some time on learning.

    • @datalab365
      @datalab365 День тому

      You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @ImSurajSingh-9571
    @ImSurajSingh-9571 День тому

    Hi , Can you share the 2nd part of that video "Hr dashboard"

    • @datalab365
      @datalab365 День тому

      Will check and send it. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @abdoolyakubu8022
    @abdoolyakubu8022 День тому

    amazing work. You teaching is the best of the best

    • @datalab365
      @datalab365 День тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @vivekvhurtel6848
    @vivekvhurtel6848 День тому

    Top button is working fine with month slicer,however buttom one aint working when month slicer is applied,what might be the problem?

    • @datalab365
      @datalab365 День тому

      Will explain again on my new channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @user-xk7li8mg4b
    @user-xk7li8mg4b 2 дні тому

    very nice i love it ❤

  • @eduardomunoz2764
    @eduardomunoz2764 2 дні тому

    Great, thanks for sharing. Greetings from Mexico.

    • @datalab365
      @datalab365 2 дні тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @royarahmatian4541
    @royarahmatian4541 2 дні тому

    Thank you so much

    • @datalab365
      @datalab365 2 дні тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @kumargupta7149
    @kumargupta7149 2 дні тому

    Thank you love your contents

    • @datalab365
      @datalab365 2 дні тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @ehismatthias3335
    @ehismatthias3335 3 дні тому

    please how do get to understand all these DAX functions and how do you know when to apply them. It's so confusing... do you have a tutorial for that?

    • @datalab365
      @datalab365 3 дні тому

      @@ehismatthias3335 on my new channel I will be teaching DAX Basic. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdw

  • @vivekvhurtel6848
    @vivekvhurtel6848 3 дні тому

    whats the point on calcualting MoM change on aggregated data(month) ,it should reflect single year

  • @davidbassey8562
    @davidbassey8562 3 дні тому

    I love you lessons i have learnt enough and well too…thanks so much I would always recommend your channel Please can you take masterclass tutorial,power pivot. Thanks

    • @datalab365
      @datalab365 3 дні тому

      @@davidbassey8562 Noted. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @saloriasaxon7323
    @saloriasaxon7323 4 дні тому

    Great work again. Time Stamps please? Pretty please?

    • @datalab365
      @datalab365 3 дні тому

      Done! You can check out our new channel here: ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @mosesntsieni9607
    @mosesntsieni9607 4 дні тому

    Man, u have no idea how much your Power BI trainings have propelled my career. Thank you soo much for your offering and dedication!!

    • @datalab365
      @datalab365 4 дні тому

      Good to hear this. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @abdealikapadiya
    @abdealikapadiya 4 дні тому

    hello brother, what is alternative of xlookup? as i have excel 2019

    • @datalab365
      @datalab365 4 дні тому

      Lookup or index and match. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @Statcraft.consulting
    @Statcraft.consulting 4 дні тому

    imagine i dont follow this page. what would be my gain? grateful

    • @datalab365
      @datalab365 4 дні тому

      @@Statcraft.consulting thank you for being here. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

    • @Statcraft.consulting
      @Statcraft.consulting 4 дні тому

      Sure boss man

  • @LameesMarzouk
    @LameesMarzouk 4 дні тому

    there is a problems with the employees that are due for promotion and will be retrenched , Abram Q Keffer Alanna L Tyrell Akiko S Godby Agnes Blow those employees are neither due for promotions nor will be retrenched can anyone explain ??

    • @datalab365
      @datalab365 День тому

      Will do something similar to this on our new channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @user-qo5tr5vo6r
    @user-qo5tr5vo6r 4 дні тому

    Thanks in advance for this helpful video, Could you explain how you resolve the tie problem in the TopAgeGroup Dax formula in more detail.

    • @datalab365
      @datalab365 4 дні тому

      @@user-qo5tr5vo6r I will explain more on my second channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdw

  • @QuangNguyen-zm5dn
    @QuangNguyen-zm5dn 6 днів тому

    my hero

    • @datalab365
      @datalab365 5 днів тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @alistairspence8351
    @alistairspence8351 6 днів тому

    Great work!

    • @datalab365
      @datalab365 5 днів тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @Halocron
    @Halocron 6 днів тому

    How did you do the Navigation section, no highlight. The video is great

    • @datalab365
      @datalab365 5 днів тому

      My other videos have it. Explore the channel page for more resources. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @pawaniredde5574
    @pawaniredde5574 6 днів тому

    Brother please make a video how to create aging and last 7 days, 15, 30, 60 & 90 days values..

    • @datalab365
      @datalab365 5 днів тому

      Noted. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

    • @pawaniredde5574
      @pawaniredde5574 5 днів тому

      @@datalab365 Already subscribed thanks for respond

  • @hilariocarlos05
    @hilariocarlos05 6 днів тому

    Good job my brother

  • @mdshamiul358
    @mdshamiul358 6 днів тому

    You are the best master among masters

    • @datalab365
      @datalab365 6 днів тому

      @@mdshamiul358 Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @775shahrukh
    @775shahrukh 6 днів тому

    What is the decision here

  • @Aminesci007
    @Aminesci007 6 днів тому

    🛑 Hi, why the icon animation dont work, when it embedded in excel

    • @datalab365
      @datalab365 6 днів тому

      Maybe the version of your Excel do not support it. It should have worked. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

    • @Aminesci007
      @Aminesci007 6 днів тому

      @@datalab365 tank you for your Great content ,

    • @Aminesci007
      @Aminesci007 6 днів тому

      @@datalab365 i have Excel 2016

  • @JuleeChan
    @JuleeChan 6 днів тому

    Hi, Do you have personal class for Power Bi and Excel?

    • @datalab365
      @datalab365 6 днів тому

      Yes, but currently busy at some projects. Will resume personal classes by next year. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @vishalmane3139
    @vishalmane3139 7 днів тому

    dude breathes in PBI

    • @datalab365
      @datalab365 7 днів тому

      @@vishalmane3139 Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @tariqhussain1497
    @tariqhussain1497 7 днів тому

    Good morning , how are you bro, and i m learning al lot from your Excel and Power BI resources, and i used them in my routine work and its helps me lot to being different from others and hope you will make more on this and Power bi too, too bring unique things , thank a lot bro

    • @datalab365
      @datalab365 7 днів тому

      @@tariqhussain1497 Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @femmylyn2004
    @femmylyn2004 7 днів тому

    Morning Sir, Are you based in Lagos? Are you doing training on data analysis/Excel???

    • @datalab365
      @datalab365 7 днів тому

      No, I am currently in Abuja. You can join my new channel for classes. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @EduardoSilva-mt4su
    @EduardoSilva-mt4su 7 днів тому

    Amazing my friend! This video about analysis data is amazing!

  • @user-gp9rv1el5y
    @user-gp9rv1el5y 7 днів тому

    Sale date is taken by power query editor as text instead of date. When we convert it - It shows error in 41%. Since we were just learning so I removed the error dates. But I have two suggestion - 1st is kindly do analysis for multiple year at least 2 because we are learning and the year variable will confuse us in real life projects later. 2nd is kindly update the csv format for date. Just love your this work. Just pressed Subscribe buttom.

    • @datalab365
      @datalab365 7 днів тому

      @@user-gp9rv1el5y the problem is your region. The date on the file has a different date format, all you need is to change it in either Power Query or power BI. I will teach that on my other channel. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @DognimaniSoro
    @DognimaniSoro 8 днів тому

    You did it great oga. Thank you very much, i loved it !!!!!

    • @datalab365
      @datalab365 7 днів тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @ayeboomolade1265
    @ayeboomolade1265 8 днів тому

    Hello sir! Kindly explain the function of "All" which was used as an alternative for SELECTEDVALUE in % Top Drugs & % Bottom Drugs. I tried creating my Dax without it but its giving me BLANK result. I didn't get that part, i would appreciate it if you can explain for more understanding. Thank you!

    • @datalab365
      @datalab365 7 днів тому

      I will teach it in my new channel, kind subscribe to the channel for DAX classes. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @wowens662
    @wowens662 8 днів тому

    Hello, Data with Decision Team. Thanks for making this extensive data analysis project tutorial. I have been able to follow the instruction for the first 3 installments, without any issues. Until that point, my results where identical to yours. But, upon attempting to follow the 4th installment, I ran into problems. Somehow my Product Name and Total Profit figures are vastly larger than the ones shown at the beginning of the 4th installment. What should I do? Can you offer me any suggestions?

    • @datalab365
      @datalab365 8 днів тому

      @@wowens662 the issue might be from your calculations or relationship issues. Just rewatch again. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

    • @wowens662
      @wowens662 5 днів тому

      Thanks for the tutorial and I've followed your advice. I'm still confused about the Total Profit. Once the filters are removed from the TimeSeriesDashboard, Total Profit is shown as 126.29M. When the P&C Analysis sheet is created, just after MonthName is removed, why is the TotalProfit shown as 10M?

  • @akramtester5249
    @akramtester5249 8 днів тому

    Nice ,thnaks

    • @datalab365
      @datalab365 7 днів тому

      Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @ArvindGuptaDiary
    @ArvindGuptaDiary 8 днів тому

    please give me template

    • @datalab365
      @datalab365 7 днів тому

      Will check if available and send. Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @fathoninugrahirkha7837
    @fathoninugrahirkha7837 8 днів тому

    I really like your work. I have been learning a lot from you. Can you please share the datasheet? Unable to download it.

    • @datalab365
      @datalab365 8 днів тому

      @@fathoninugrahirkha7837 Will check and send if found. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj

  • @brentonstewart3317
    @brentonstewart3317 8 днів тому

    Your microphone quality sucks dogs balls