Data Analysis End to End | Project Analytics | Beginner Friendly

Поділитися
Вставка
  • Опубліковано 30 січ 2025

КОМЕНТАРІ • 117

  • @MEGALLICA6
    @MEGALLICA6 2 місяці тому +4

    I've learned more in this video, than I have elsewhere on the web. Thank you so much for this!

    • @absentdata
      @absentdata  2 місяці тому

      I'm so glad you learned so much from the vidro. Share it to help others.

  • @darllabulagner8585
    @darllabulagner8585 27 днів тому

    Big thanks for this! Keep doing this kind of video :)

    • @absentdata
      @absentdata  27 днів тому

      Much love!

    • @rendezyt
      @rendezyt 25 днів тому

      @@absentdata Hello, thanks for the video; how did you create the 2023 and 2022 button visualizations at 59:56 as just before the report did not have these; I made buttons through the insert tab (not selecting the visualizations pane as I did not see those visualizations in the available ones) and shaped them into a trapezoid but when I select the filters pane (with my buttons selected) it does not say Filters on this visualization, it only says filters on this page. You kinda skipped that step and I am confused. I am having trouble trying to filter the the Units Yoy and Profit Yoy for 2022/2023 as a result; as you did not explain the edit relationships thing or the visualization I explained above. Could you please respond back?

  • @aiwaheed3902
    @aiwaheed3902 Місяць тому

    nice tutorial. well done

  • @TheMatchReview
    @TheMatchReview 2 місяці тому

    You're a legend for doing this!

  • @jelenadj7289
    @jelenadj7289 2 місяці тому

    Thank you so much, i'm at the beginning of the data analyst career and this is so helpful and useful! I hope there will be more videos like this.

    • @absentdata
      @absentdata  2 місяці тому

      Glad you enjoyed it. There are more videos like this on the channel playlist..

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

      How did you prepare . can u help me ?

  • @thebesttechnical3608
    @thebesttechnical3608 2 місяці тому

    Very interesting and easy to understand, looking forward to next contents.

    • @absentdata
      @absentdata  Місяць тому

      Thanks, there will be more to come!

  • @lucskyost
    @lucskyost 24 дні тому +2

    Solution to handle incorrect date format after data import:
    By default, SQL Server uses system regional settings to interpret date formats (e.g., DMY for Vietnam, MDY for US),
    then converts them to YMD format when storing.
    -To handle DMY format, run SET DATEFORMAT DMY before importing.
    -If you prefer not to change the default, update the table with:
    UPDATE product_sales.dbo.product_sales
    SET Date = CONVERT(DATETIME, FORMAT(Date, 'yyyy-dd-MM HH:mm:ss'), 120);
    -Alternatively, change system regional settings:
    +Go to Region settings.
    +Set Date format to dd/MM/yyyy.
    +Restart SQL Server if necessary.
    -You can also edit the CSV file before importing to ensure correct date formatting.

    • @absentdata
      @absentdata  24 дні тому

      You're a hero! Thanks for posting this

    • @edekicharles3505
      @edekicharles3505 19 днів тому

      Thank you for this

    • @xavierberge524
      @xavierberge524 11 днів тому

      @@absentdata It would be a good idea to pin this post at the top of the comment section for it to be the first one seen by the viewers as I am pretty confident a lot of the viewers following the video as a tutorial will have to face this issue.

  • @betageric3217
    @betageric3217 2 місяці тому +1

    Thanks for providing Dataset, helped me for practice.❤ you

  • @zakariahamido3636
    @zakariahamido3636 2 місяці тому +1

    Awesome video as always, we need a video to analyse data and work with python

    • @absentdata
      @absentdata  2 місяці тому +1

      I definitely will add new ones. However, there quite few on the channel. Here is the playlist ua-cam.com/play/PLi5spBcf0UMXc_qCX8FSwKxOlOmODtcUP.html&si=7aKmXWjjqsPy3ykx

  • @rendezyt
    @rendezyt 25 днів тому

    Thanks for the video; how did you create the 2023 and 2022 button visualizations at 59:56 as just before the report did not have these; I made buttons through the insert tab (not selecting the visualizations pane as I did not see those visualizations in the available ones) and shaped them into a trapezoid but when I select the filters pane (with my buttons selected) it does not say Filters on this visualization, it only says filters on this page. You kinda skipped that step and I am confused. I am having trouble trying to filter the the Units Yoy and Profit Yoy for 2022/2023 as a result; as you did not explain the edit relationships thing or the visualization I explained above. Could you please respond back?

    • @absentdata
      @absentdata  24 дні тому

      There are only filters and no buttons used. If you want to know how to build a date table, read the description.

    • @rendezyt
      @rendezyt 24 дні тому

      @@absentdata Thanks for replying I don't mean the Dates table, I have that already. What did you do exactly to make the 2022/2023 black and white colored filters that trapezoid shape at 59:56 in the video next to the ASCES logo; like what steps did you take? I have tried to recreate it in but because you did not actually show them I have not made progress.

    • @rendezyt
      @rendezyt 24 дні тому

      @@absentdata I know you are busy sir, but could you please respond to my follow-up query just above. Thanks.

    • @rendezyt
      @rendezyt 22 дні тому

      @@absentdata No worries, through some digging I found out it is a tile slicer (2022/2023) visualization not a button

    • @jegbefumweneddie-ehis8300
      @jegbefumweneddie-ehis8300 20 днів тому

      @rendezyt were you able to edit the image slicer in 36:00-40:00, i am genuinely having hard time with this as I do not get the options to edit the image slicer

  • @IisAisah-n6w
    @IisAisah-n6w Місяць тому

    Thank a lot, but I encountered an issue at minute 40:06. After adding the Product, when I tried to click on the paintbrush visual, I couldn’t find the Images menu.

    • @abdulvajeth9740
      @abdulvajeth9740 Місяць тому

      I have faced same problem its very simple bro when we add card we drag the product data eventually it's stored in small multiples data field ...thats why we can't get the image .we have to drag that product to Data field just above the small multiples....

  • @bankimdas9517
    @bankimdas9517 2 місяці тому

    Awesome video👍Thanks for making this video

  • @vitoroliveira2203
    @vitoroliveira2203 2 місяці тому +1

    First of all, I would like to thank you for your work! It is helping my data analytics studies A LOT! At 39:34 I'm encountering an error when I try to filter by clicking the images. "Error while retrieving data for this visual"
    "Query (4,3) The column 'Image_url' in table 'Consulta1' cannot be found or cannot be used in this expression."
    What can I do about it? I don't know if it matters, however, my OS and PowerBI language are pt-br.

    • @absentdata
      @absentdata  2 місяці тому +1

      Remember the errors are not decoration. Please read them. You need to follow the video, its addressed. The error says you dont have the image url in your code. So, please add the image url to your SQL code to bring so that you can avoid this error.

  • @sandeepkhawas3367
    @sandeepkhawas3367 2 місяці тому

    Thanks a million sir..😊😊

    • @absentdata
      @absentdata  2 місяці тому

      Thank you for watching

  • @HalkawtMawlood
    @HalkawtMawlood Місяць тому

    One question I have installed the MS SQL server but when I try to create a new database it gives me an error which is 262 and says you can't create it. Could you please help me in this how to solve this issue?

  • @growmorelearningcafe3093
    @growmorelearningcafe3093 2 місяці тому

    Great

  • @saktibiswal6445
    @saktibiswal6445 Місяць тому

    28:28 Connecting MS SQL Server to Power BI

  • @Trembelwick
    @Trembelwick 2 місяці тому

    Skimmed through this a bit to see value of coming back later.
    I think I am going to show this to my interns as it shows way more than our corproate training!
    *Full disclosure question (didn't watch it all yet)
    The images you have as image_url @42:44 that you selected. Can is that all local data or actual URL images from web? Never seen something like that used dynamically, always still photos.

    • @absentdata
      @absentdata  2 місяці тому

      Glad you enjoyed the content. In the video there are local and image URL used. For the slicer and main image, I used image URLs. Its easier that way and you can share the dashboard. It is possible to use just local images, it requires a bit more work to transform them with the invoke function.

  • @santikaia
    @santikaia 2 місяці тому

    Thanks for great tutorial. But, I ran into problem at 1:01:25, I can't find 'Data Table'. Where did you get it from?

    • @absentdata
      @absentdata  2 місяці тому +1

      You can create a date table by following the instructions
      1. Click Modeling in the top ribbon
      2. Choose New Table
      3. Add this to you DAX formula: Calendar = CALENDAR("1/1/2022","12/31/2023")

    • @santikaia
      @santikaia 2 місяці тому

      Thanks for quick reply. I created a date table ad you suggested tho I don't know why the percentage is 648K%

    • @absentdata
      @absentdata  2 місяці тому

      Check your calculation and also that the discount column is a decimal and not a whole number. For example 14 should be .14

    • @santikaia
      @santikaia 2 місяці тому

      @@absentdata I fixed it by draw relationship line between Calendar and date column in the main table with many to one as the cardinality. It gives the same result (34% growth) but I dont know if it's the right way to do it. Is it right?

    • @orangiruth5158
      @orangiruth5158 24 дні тому

      Alternatively you can write this expression
      CalenderTable=
      CALENDER(
      DATE(2022,1,1),
      DATE(2023,12,31)
      )

  • @markshrigley4064
    @markshrigley4064 Місяць тому

    bravo on this video. I pretty much consider myself an intermediate SQL guy - but I picked up a thing or two watching you do some SQL.
    One question i have. Curious why you didn't clean any data before importing it to SQL Server.
    thx again!

    • @TheLaxmanAcharya
      @TheLaxmanAcharya Місяць тому

      same question , when we can clean it in python easily , who do we have to do it in sql

    • @absentdata
      @absentdata  Місяць тому

      It was just to keep this video short and simple. Cleaning up data is an important step but for a beginner video, I was just going for the core concepts.

    • @absentdata
      @absentdata  Місяць тому

      You can do data cleaning at the source level which is SQL or in that BI tool or in Python. Doesn't matter where as longs it gets cleaned

  • @martindiavolo1635
    @martindiavolo1635 2 місяці тому +3

    not clear enough you havent show how the image url is working and how did you connect the every image that when you click its showing data???

    • @absentdata
      @absentdata  2 місяці тому +1

      I don't understand your question fully. An image url is an image that exists on a wepage. So many images have a web address or url.

    • @rafaelaboaretto
      @rafaelaboaretto Місяць тому

      @@absentdata I could not show the images as well, its showing only the url on my visualization, how can I show the images? Thank you

    • @abdulazeezabdullateef5022
      @abdulazeezabdullateef5022 Місяць тому

      ⁠@@absentdata it’s displaying url and not image …any idea how I can solve this

    • @absentdata
      @absentdata  Місяць тому +1

      Change it to image url. Follow the video

    • @getinettafesetucho7999
      @getinettafesetucho7999 Місяць тому

      I think we need to upload them to webserver, just like github repository, and then calling them through the github link or url.

  • @adewumiogunniyi6841
    @adewumiogunniyi6841 Місяць тому

    Thank you so much for this video, Its indeed end-to-end. Please at 40:32 my image did not display despite following the steps outlined. Please how can I fix this?

    • @absentdata
      @absentdata  Місяць тому

      The instructs start at 36:00 not 40:32.

    • @adewumiogunniyi6841
      @adewumiogunniyi6841 Місяць тому

      @absentdata thanks so much for responding. I followed it step by step but still not displaying. The first set of 6 images is displayed,but actually referring to displaying single images by going this steps:
      1. I selected card
      2. Select product
      3. Select image url option from visual
      4. Click on FX, dropped down to select image url and ok
      Still my pop up did not show the image

    • @michaelsolomon6033
      @michaelsolomon6033 Місяць тому

      @@adewumiogunniyi6841 I had same challenge. Try selecting product first then choose "card(New)" and see if it can solve your problem

    • @abdulvajeth9740
      @abdulvajeth9740 Місяць тому +2

      ​@@adewumiogunniyi6841 I have faced same problem its very simple bro when we add card we drag the product data eventually it's stored in small multiples data field ...thats why we can't get the image ..we have to drag that product to Data field just above the small multiples .....

    • @adewumiogunniyi6841
      @adewumiogunniyi6841 Місяць тому +1

      @abdulvajeth9740 thank you so much, brother. I just did, and it worked!

  • @sandeepkhawas3367
    @sandeepkhawas3367 Місяць тому

    Sir, just a question while importing data on power bi from SQL Sever getting an error while loading pls help on below error!
    Microsoft SQL: Incorrect syntax near ';'. Incorrect syntax near ')'.

    • @absentdata
      @absentdata  Місяць тому +1

      There is a syntax error, so you have an error in the sql code you wrote. The error is telling you that error is near the comma in your code. Make sure read the errors. They tell you the problem

  • @kanaksinha8422
    @kanaksinha8422 Місяць тому

    the dax formula is not working in my case. How did you create 'Data Table' [Date] in the Dax?

    • @absentdata
      @absentdata  Місяць тому

      Read the description Add this to you DAX formula: Calendar = CALENDAR("1/1/2022","12/31/2023")

    • @kanaksinha8422
      @kanaksinha8422 Місяць тому

      @@absentdata and then for YoY create formula as "Profit YoY =
      VAR last_year = CALCULATE(SUM('query1'[profit]),DATEADD('Calendar'[Date],-1, YEAR))
      return
      (SUM('query1'[profit])-last_year)/last_year"?

  • @juroolubalakrishna7399
    @juroolubalakrishna7399 22 дні тому

    @absentdata i wrote this Dax formula After connecting the tables "Profit YoY =
    var last_year = CALCULATE(SUM(Query1[Profit]),DATEADD(CalenderTable[Date],-1,YEAR))
    return
    (SUM(Query1[Profit])-last_year)/last_year" then after creating the card it is showing "infinity" can please guide me what to do ?

    • @absentdata
      @absentdata  21 день тому

      Read the description

    • @juroolubalakrishna7399
      @juroolubalakrishna7399 20 днів тому

      @@absentdata I have created the date table according to the description and tried the formula byt instead of 34%, I am getting the answer as infinity.

  • @noursoula8951
    @noursoula8951 Місяць тому

    Hey, thank you for the amazing content! I’m facing an issue where, when I load data using the query into Power BI, the table appears empty. It seems like the query is not returning any results. I believe there might be an issue with the join conditions or the data transformation steps in the query. Could you please help me identify what might be causing this?

    • @absentdata
      @absentdata  Місяць тому

      You need to paste the actual error for someone to help you.

  • @infoscript8555
    @infoscript8555 Місяць тому

    how can i change the date format . I end up having a only month January. I am not able to figure out how to fix this issue. I hope its not only me .. i tried delete and reinstall the product_sales and uncheck the option use Rich Data Type Detection like you did. But i still end up having just the only January in format(date,'MMMM')as month .. ..Any idea what am i missing here . Thanks

    • @absentdata
      @absentdata  Місяць тому

      It's your computer's regional settings. You can change it to fix the date format.

    • @infoscript8555
      @infoscript8555 27 днів тому

      @@absentdata sorry to bother you again, i have the date format same as yours, when importing from csv but once imported in mssql it has changed to 2023-01-12 ie yyyy-mm-dd instead its 2023-01-01 (yyyy-mm-dd). i tried changin my system date format still remain same. Any idea what causes the change. Thanks

    • @lucskyost
      @lucskyost 24 дні тому

      Solution to handle incorrect date format after data import:
      By default, SQL Server uses system regional settings to interpret date formats (e.g., DMY for Vietnam, MDY for US).
      -To handle DMY format, run SET DATEFORMAT DMY before importing.
      -If you prefer not to change the default, update the table with:
      UPDATE product_sales.dbo.product_sales
      SET Date = CONVERT(DATETIME, FORMAT(Date, 'yyyy-dd-MM HH:mm:ss'), 120);
      -Alternatively, change system regional settings:
      +Go to Region settings.
      +Set Date format to dd/MM/yyyy.
      +Restart SQL Server if necessary.
      -You can also edit the CSV file before importing to ensure correct date formatting.

  • @montegukh7907
    @montegukh7907 20 днів тому

    amazing video, i've learned alot
    But just one issue, at around 1:05 instead of 34%, I am getting the answer as 0, for all the products.

    • @absentdata
      @absentdata  20 днів тому

      Check out the description it will show you how to create a date table. There was an issue when I uploaded it and this short section was skipped.

  • @ShopEXtravagant
    @ShopEXtravagant Місяць тому

    Is your TCP/IP Enabled? I cannot connect to your SQL Server

    • @absentdata
      @absentdata  Місяць тому

      Make sure you follow the instructions. You shouldn't have that issue

  • @aniketbhateja9638
    @aniketbhateja9638 2 місяці тому

    Thanks sir

  • @alicemtopcu743
    @alicemtopcu743 Місяць тому +1

    I encountered an issue where my results were different from the video tutorial because the date format was not recognized correctly by SQL Server. After some investigation, I realized that the problem was related to my computer’s regional settings. The default regional settings were causing SQL Server to interpret the date format incorrectly.
    To resolve the issue, I changed my computer's regional settings to Turkey, which aligns the date format to dd/MM/yyyy. Once I did this, the date format in SQL Server was recognized correctly, and everything worked as expected.
    If you're facing similar issues with date format discrepancies, try adjusting your regional settings to match the format of your data.

    • @absentdata
      @absentdata  Місяць тому +1

      Awesome tip!!

    • @allankamau6299
      @allankamau6299 Місяць тому +1

      Thanks, been stuck in this for days

    • @allankamau6299
      @allankamau6299 Місяць тому

      I am still encountering this same problem. Where the month that's being returned is January only. I have tried so many things but no change still🥲😭

    • @ajibadeoyeyiola6724
      @ajibadeoyeyiola6724 Місяць тому

      @alicemtopcu743
      how did you fix this? I am unable to alter the date setting in my computer

  • @TheLaxmanAcharya
    @TheLaxmanAcharya Місяць тому

    can i put this as my portfolio?

  • @CB-yc6wz
    @CB-yc6wz 2 місяці тому +1

    I keep getting an error message after adding cte .... error message is Msg 156, Level 15, State 1, Line 22
    Incorrect syntax near the keyword 'select'.

    • @absentdata
      @absentdata  2 місяці тому

      Better to post your whole query if you so people can help. The error is saying you having written something incorrectly near line 22 of code before or after the select statement. The errors are there to help you.

    • @adityasharma9625
      @adityasharma9625 2 місяці тому

      Bro use comma
      First cte end with , then you start another query using select... So most probably it's the , i have experienced this too

    • @afdaylmedia5088
      @afdaylmedia5088 2 місяці тому

      I'm so interesting but I'm having difficulty how to access if you can provide me further details you will be appreciated

    • @adityasharma9625
      @adityasharma9625 2 місяці тому

      @@afdaylmedia5088 if you are using cte
      Google it's syntax if you are having a error near select ... Comma is missing from the query

    • @CB-yc6wz
      @CB-yc6wz 2 місяці тому

      @@absentdata with cte as(
      select
      a.Product,
      a.Category,
      a.Brand,
      a.Description,
      a.Sale_Price,
      a.Cost_Price,
      a.Image_url,
      b.Date,
      b.Customer_Type,
      b.Discount_Band,
      b.Units_Sold,
      (Sale_Price*Units_Sold) as revenue,
      (Cost_Price*Units_Sold) as total_cost,
      format(date, 'MMMM') as month,
      format(date, 'yyyy') as year
      from Product_data a
      join product_sales b
      on a.Product_ID = b.Product

  • @6r31v1nZ
    @6r31v1nZ Місяць тому

    Thanks for the content. Seems like there is a missing part around the 1hr mark when the Data Table was created, the 2022 / 2023 slicers vs the Profit YoY / Units Sold YoY I can't make the percentages match yours. Also, the data table[date] I guess has a relationship from the Date column of the Query1 table to the Date column of the Data Table...sorry noob here

    • @absentdata
      @absentdata  Місяць тому

      Read the description. You are right! Not sure why it got cut. However, you can get the instruction in the description. There is the DAX to create the date table.

  • @jazzireal
    @jazzireal Місяць тому

    Hey bro, thanks for the awsome visuals. however, i am not able to get the profit yoy(34%) you got for 2023 . please can you assist with an explanation

  • @RajanSowri
    @RajanSowri 2 місяці тому

    I get this error while executing the query - 13:15:28 with cte as ( select a.Product, a.Category, a.Brand, a.Description, a.Sale_Price, a.Cost_Price, a.Image_url, b.Date, b.Customer_Type, b.Discount_Band, b.Units_Sold, (sale_price*Units_Sold) as revenue, (cost_price*Units_Sold) as total_cost, format(date, 'MMMM') as month, format(date, 'yyyy') as year From product_data as a join product_sales as b on a.Product_ID = b.Product) select *, (1-discount*1.0/100) * revenue as discount_revenue from cte a join discount_data b on a.Discount_Band = b.Discount_Band and a.month = b.Month Error Code: 1054. Unknown column 'a.Sale_Price' in 'field list' 0.000 sec
    Can you help me out on this?

    • @absentdata
      @absentdata  2 місяці тому

      Take a look at what the error is saying. This will always give you on indecation of what needs to be addressed. The is issue is the sales_price column. Make sure you have not altered the naming. Also just remove the alias a from sale price to see if it solves your issue.

  • @smb_insights
    @smb_insights Місяць тому

    Everything you have done can be done exclusively on Power BI. So why did you use SQL?

    • @absentdata
      @absentdata  Місяць тому +3

      90% of company data is on a database that you need to access via SQL. No company will proper data governance will have any Dashboard running of individual Excel documents

  • @aniketbhateja9638
    @aniketbhateja9638 28 днів тому

    Sir i calculated profit yoy using pivot table in excel and manually verified it, it's coming out to be 6.686%, kindly verify because It differs vastly from your 34%. Thank You.

    • @absentdata
      @absentdata  28 днів тому

      Read the description

    • @aniketbhateja9638
      @aniketbhateja9638 27 днів тому

      @@absentdata I did create the date table and connected it manually.

  • @jeevankatloju9952
    @jeevankatloju9952 2 місяці тому

    Can i add this in my resume...? & Portfolio

  • @nirjharacharjee1088
    @nirjharacharjee1088 21 день тому +2

    You are just doing sneaky edits. Following you means wasting time.

    • @absentdata
      @absentdata  21 день тому +1

      Unsubscribe and watch something else

    • @nirjharacharjee1088
      @nirjharacharjee1088 21 день тому

      @absentdata Definitely will do that. Don't worry. Thanks for your suggestion though.

    • @VonexCS
      @VonexCS 18 днів тому

      @@nirjharacharjee1088 wdym?

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

    *not so beginner friendly

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

      Glad you enjoyed it. Share it within anyone who wants to learn