End to End Project in Power BI Part 2 | India's Best IT Training | KSR Datavizon | Power BI

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ต.ค. 2024
  • #IndiaBestITtrainingCenter #KSRDatavizon #endtoend#Preparations #Projects #realtimeProjects #
    Datasets for practice
    drive.google.c...
    End to End Power BI Project - Part 2
    We will be implementing complete Power BI Projects end to end. Right from requirement gathering to publishing the report. We will be following all the real time scenario based requirements. We will be having all follow up videos. Please do watch all videos sequentially. These videos will get to complete end to end knowledge on projects.
    In Part 2 - Once the data is gathered, next step is to clean the data, transform the data and proceed with data modelling. data cleansing becomes very important step in project. because it deals majority of issues. wat u give in, will come out. if we give clean data, we will get the best insights of business.
    drive.google.c...
    github.com/ksr...
    Here is the link you can download the data for project implementation
    #PowerBI #Demand #BestSalary #HighDemand #BusinessIntelligence #BestBITool #Highest #HighestSalary #BestNegotiation #Package #HighPackage #Visualizations #Reports #Dashboard #HighSalary #BI #HotSkill #MarketDemand #interviewQuestions #interview #preparations #Study #realtimeproject #project #endtoend #endtoend #realtime #reports #dashboard #RLS #DAX #modelling #completeeEnd2End #fullproject #fulllpowerbiproject
    *************************
    Live Powerbi Interview with Capgemini : • Capgemini Interview 20...
    Live Powerbi Interview with EY -Round 1: • First Round Live Inter...
    Live Powerbi Interview with EY -Round 1: • Power BI Developer Int...
    Interview tips and Tricks: • Power BI Tips and Tric...
    Self introduction: • Self Introduction in I...
    Salary Negotiation: • How to Negotiate Best ...
    ***************************
    How are we different from others
    1. 24*7 Life time Access & Support
    2. Flexible Class Schedule
    3. 100 % Job Guarantee
    4. Mentors with +14 yrs
    5. Industry Oriented Course ware
    6. Life time free Course Upgrade
    ------------------------------
    Call us on IND: 9916961234/8527506810 to talk to our Course Advisors.
    This is the 3rd video in this playlist. We will demonstrate the usage of all charts in power bi. An expert in power bi knows when to use right chart for right data. This will be very useful to build story.

ความคิดเห็น • 236

  • @KSRDatavizon
    @KSRDatavizon  2 ปีที่แล้ว +2

    Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our TH-cam channel 👉Please ping on WhatsApp wa.me/9916961234

  • @shrinivas5857
    @shrinivas5857 ปีที่แล้ว

    i am very impressed with your project sir . Thnaku

  • @asma494
    @asma494 ปีที่แล้ว +2

    I have a query…how to check for duplicates in the dimension table when we have large number of records. Pls help me with this query

  • @adarshnaik2273
    @adarshnaik2273 2 ปีที่แล้ว +4

    This lecturer is simply amazing.. Bcz only by watching video on power Bi project I got a very good knowledge and these power Bi videos helped me a lot lot lot to crack an interview in one of the MNC's. Seriously these videos changed my life.. Thank you so much sir... I have seen many videos on power Bi but I usually never comment on it. Since these videos changed my life, I have to comment on this.. I really don't know what to say. Thank you so much Sir 😊

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      Glad to hear that Adarsh. Congratulations :) Thanks so much for the feedback. Can you please review us on Google. Please do refer us in your network.

    • @ashwinikhobragade7583
      @ashwinikhobragade7583 ปีที่แล้ว +1

      Adarsh Naik - Pls help me with power BI job.I have good knowledge but not getting job yet so far. Can you recommend

  • @spitzer666
    @spitzer666 2 ปีที่แล้ว +5

    Amazing, thank you so much. Can you please make a video on list of skills required for Power BI / Data analyst profile? It will be helpful for employees who are migrating from other domain.

    • @baharmalkar9115
      @baharmalkar9115 2 ปีที่แล้ว

      Yes I also would love to get this knowledge

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +2

      Sure will upload asap

  • @VamsiValli
    @VamsiValli ปีที่แล้ว +2

    i just saw the video and realised that i missed a opportunity to have classes with you, recently 2 days before i have paid to some other institution which is located in Hyderabad.....

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      No worries, we will make maximum videos to help you people.

  • @manjupreetham
    @manjupreetham 2 ปีที่แล้ว +3

    Elegantly teaches everything about endtoend project transformation by Santhosh sir by ksr team and great effort of our team mahesh sir
    Thank you 😊

  • @akshaypatil8155
    @akshaypatil8155 ปีที่แล้ว

    17:13 can we call this snowflake schema? Your foreign keys where having text data type. Foreign key data type should be whole number right?

  • @hemantsahu2825
    @hemantsahu2825 ปีที่แล้ว +2

    Thank you so much sir ❤ for this amazing playlist. You have taught us the industry standards which nobody does

  • @homejamsessions5464
    @homejamsessions5464 11 หลายเดือนก่อน +1

    How do i get the Product table?

    • @KSRDatavizon
      @KSRDatavizon  6 หลายเดือนก่อน

      Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot

  • @meenakshir7746
    @meenakshir7746 2 ปีที่แล้ว +2

    Awesome, super sir. Pls share the source file, it could be more helpful for practice.

  • @traderkartik43
    @traderkartik43 ปีที่แล้ว +1

    What data modelling we created
    Is it star schema or snow flake schema

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      its star schema

    • @traderkartik43
      @traderkartik43 ปีที่แล้ว

      @@KSRDatavizon but its connected two fact table...so i got confused?

    • @traderkartik43
      @traderkartik43 ปีที่แล้ว

      ​​@@KSRDatavizoncategory table subcategory tables are intervonnected
      17:21

  • @yasuke8209
    @yasuke8209 ปีที่แล้ว

    hi thank you for the tutorial but I have errors when loading the sales data , kindly assist -please

  • @mahadAli-gc7su
    @mahadAli-gc7su ปีที่แล้ว +1

    thanks for this valubale and informative video , this gentleman is not explaining only the project but he also giving us what is like to work with real time project is, again thank you very much...

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      So nice of you ! You are welcome! Please subscribe our channel, it motivates us

  • @karankumar-i9p2v
    @karankumar-i9p2v 20 วันที่ผ่านมา

    This video is incredibly helpful, and I greatly appreciate the thorough and clear explanation you provided. I truly enjoyed watching it, as it contains a wealth of valuable information. I highly recommend that every PowerBI developer who is currently job searching take the time to watch this video.

    • @KSRDatavizon
      @KSRDatavizon  18 วันที่ผ่านมา

      Gald you liked it.. this will motivate us to upload more.. thanks

  • @werapatmalikhao6016
    @werapatmalikhao6016 ปีที่แล้ว

    Hi This vdo helpful I have question , So I use function year for get the return to Column year but the result i got 1447 for duplicate field as whole columns how to solve it to get Correct Year result , Thank you

    • @KSRDatavizon
      @KSRDatavizon  18 ชั่วโมงที่ผ่านมา

      Hi Werapat Malikhao! I’m glad you found the video helpful! The issue of getting unexpected values like 1447 when using the YEAR function usually indicates that the data type of the column you are referencing may not be in the correct date format or that there are duplicate values causing confusion.
      Here’s how to troubleshoot:
      Check Data Type: Ensure that the column you are using with the YEAR function is formatted as a Date type. You can do this in the Power Query Editor or by selecting the column and checking the data type in the column tools.
      Remove Duplicates: If there are duplicate values, consider using a summarization or grouping technique to ensure you are not inadvertently pulling in multiple records. You can use functions like GROUPBY or SUMMARIZE to aggregate your data.
      Use DISTINCT: If you're looking to get unique years, you can modify your measure to use the DISTINCT function. For example:
      DAX
      Copy code
      UniqueYears = DISTINCT(YEAR(Table[YourDateColumn]))
      If you continue to have issues, feel free to share more details about your data structure, and I can help further!

  • @bhupeshpandey4461
    @bhupeshpandey4461 ปีที่แล้ว

    Hi
    why my sales information is not showing 100% 0% &0% rule but showing unexpected error ocuures for all coloumn

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      we dint get ur issue.. pls email your doubt with snapshots santosh_j@ksrconsultantservices.com

  • @endalekinfe3391
    @endalekinfe3391 3 หลายเดือนก่อน

    Thank you sir, I have question since the date format of united state different from Indian when I load sales table in to power query editor it gave some error. what should I do to handle this error.

    • @KSRDatavizon
      @KSRDatavizon  หลายเดือนก่อน

      Handling Different Date Formats in Power Query
      Understanding the Issue:
      When importing data from different regions, especially those with different date formats (like the US and India), Power Query might encounter errors if it's unable to correctly recognize the format.
      Solution:
      Identify the Format:
      Use the Text.Format function to inspect the first few rows and determine the US date format. For example, if the US format is "MM/DD/YYYY," you can use:
      Code snippet
      Table.TransformColumns(YourTable, {"DateColumn"}, each Text.Format(_, "MM/DD/YYYY"))
      Use code with caution.
      Convert to a Common Format:
      Once you've identified the US format, convert it to a common format that both regions can understand. This is often done using the ISO 8601 standard format, "YYYY-MM-DD".
      Code snippet
      Table.TransformColumns(YourTable, {"DateColumn"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US"))
      Use code with caution.
      Handle Errors:
      If there are other date formats present, consider using a try...otherwise expression to handle potential errors:
      Code snippet
      Table.TransformColumns(YourTable, {"DateColumn"}, each try DateTime.FromText(_, "MM/DD/YYYY", "en-US") otherwise null)
      Use code with caution.
      Example:
      Assuming your date column is named "Date" and contains US dates in the "MM/DD/YYYY" format, you could use the following code:
      Code snippet
      let
      Source = Csv.Document(File.Contents("YourFile.csv"), [Delimiter=","]),
      #"Changed Type" = Table.TransformColumns(Source, {"Date"}, each DateTime.FromText(_, "MM/DD/YYYY", "en-US")),
      #"Filtered Rows" = Table.SelectRows(#"Changed Type", each not IsError([Date]))
      in
      #"Filtered Rows"

  • @achraferraji3403
    @achraferraji3403 ปีที่แล้ว +1

    Amazing, Thank you

  • @janardhanayadala2368
    @janardhanayadala2368 2 ปีที่แล้ว +1

    really simply understand this session ..... your slang is clearly understand my level of english...thank you sir

  • @sudipsen3677
    @sudipsen3677 ปีที่แล้ว +1

    Amazing explanation Sir❤️❤️
    Hates off 🤲

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      Thank you so much, Please subscribe our channel for regular updates.

  • @gospelchristjesus3497
    @gospelchristjesus3497 ปีที่แล้ว

    Dears DateMaster come from where?

  • @sonalimisal8766
    @sonalimisal8766 9 หลายเดือนก่อน

    I stucked at a related function for calculating Total Revenue please any hint you can give me really appreciated

    • @KSRDatavizon
      @KSRDatavizon  4 วันที่ผ่านมา

      Before using related function.. make you have connected the tables.. there should be relationship between tables

  • @tarakvaakil8553
    @tarakvaakil8553 ปีที่แล้ว

    My Date column has 62% error, please tell me how do I fix this

  • @DHARMRASIK8451
    @DHARMRASIK8451 ปีที่แล้ว

    In previous video there was product table now there is productdetails table and also when I am calculating total revenue it is not runing

    • @KSRDatavizon
      @KSRDatavizon  18 ชั่วโมงที่ผ่านมา

      It looks like the change from Product table to ProductDetails might be affecting your calculation. Here's how to troubleshoot:
      Check Table Names: Ensure you’re referencing the correct table (ProductDetails) in your TOTAL REVENUE calculation.
      Adjust Columns: If column names changed too (like Product[Price] to ProductDetails[Price]), update your formula to match the new structure

  • @Sn46312
    @Sn46312 ปีที่แล้ว

    Thank you so much sir for such detail explanation . 👍
    Kudos to your efforts.
    Pls post more videos of such projects of multiple domain which is highly appreciable..🙏

  • @akshatlifts1446
    @akshatlifts1446 หลายเดือนก่อน

    facing a error while transforming dates

    • @KSRDatavizon
      @KSRDatavizon  หลายเดือนก่อน

      I'd be glad to assist you with the error you're encountering while transforming dates. To provide the most effective solution, please share the following details:
      1. Error Message:
      What is the exact error message you're receiving?
      If possible, include the complete error stack trace.
      2. Programming Language and Tools:
      Which programming language are you using (e.g., Python, JavaScript, Java)?
      What specific libraries or frameworks are you working with for date manipulation (e.g., datetime, moment.js, Joda-Time)?
      3. Code Snippet:
      Please provide a simplified code snippet that demonstrates the transformation process. This will help me understand the context and identify potential issues.
      4. Input and Expected Output:
      What is the format of the date you're starting with (e.g., "2023-01-01", "January 1, 2023")?
      What is the desired output format (e.g., "01/01/2023", "2023-01-01T00:00:00Z")?
      Once I have this information, I can provide tailored guidance and potential solutions. Here are some common causes of date transformation errors and possible remedies:
      Common Causes:
      Incorrect Format: Ensure that the input date format matches the expected format for the date manipulation library you're using.
      Invalid Date Values: Check for invalid date values (e.g., non-existent days, months, or years).
      Timezone Issues: If you're dealing with timezones, make sure you're handling them correctly to avoid discrepancies.
      Library-Specific Errors: Some libraries have specific rules or limitations for date manipulation. Refer to the library's documentation for details.
      Coding Errors: Double-check your code for syntax errors, typos, or logical inconsistencies.
      Possible Solutions:
      Format Conversion: Use the appropriate functions or methods provided by your date manipulation library to convert the input date to the desired format.
      Date Validation: Implement validation checks to ensure that the input date is valid before attempting to transform it.
      Timezone Handling: If necessary, specify the timezone when creating or manipulating dates to avoid timezone-related issues.
      Library-Specific Workarounds: If you encounter library-specific errors, consult the library's documentation or community forums for potential solutions.
      Debugging: Use debugging tools or techniques to step through your code and identify the exact point where the error occurs.
      Please provide the requested details so I can assist you more effectively.

  • @mallikarjunakondreddy6537
    @mallikarjunakondreddy6537 12 วันที่ผ่านมา

    Sir how can i get the requirement tables in part 1 do to it as partical

    • @KSRDatavizon
      @KSRDatavizon  9 วันที่ผ่านมา

      you cna check the dats set and other information availabile in description try once, if not able to find get back to us. if you’re enjoying the content, consider subscribing to the channel for more updates. It really helps motivate us to keep creating helpful videos for you!

  • @kommarasettirambabu
    @kommarasettirambabu ปีที่แล้ว

    I CREATED DATEMASTER TABLE BUT I AM TRY TO APPLY DATE FROM DATEMASTER ITS NOT WORKING

    • @KSRDatavizon
      @KSRDatavizon  หลายเดือนก่อน

      I'd be glad to assist you with integrating the DATEMASTER table into your application. To ensure a successful implementation, please provide the following information:
      1. Table Structure:
      Column names and data types: Please list the columns and their corresponding data types in the DATEMASTER table. This will help me understand how the date information is stored.
      Primary key: Indicate the column(s) that serve as the primary key for the table. This is crucial for uniquely identifying each date record.
      2. Application Context:
      Programming language and database: Specify the programming language (e.g., Python, Java, C#) and database system (e.g., MySQL, PostgreSQL, SQL Server) you are using. This will help me tailor my response to your specific environment.
      Purpose of the DATEMASTER table: Describe the intended use of the DATEMASTER table within your application. This will give me a better understanding of how you plan to utilize the date information.
      3. Specific Challenges:
      Error messages or unexpected behavior: If you're encountering any issues, please share any error messages or unexpected behavior you're observing. This will help me pinpoint the root cause of the problem.
      Code snippets (if applicable): If you have relevant code snippets that demonstrate how you're attempting to retrieve or use the date information from the DATEMASTER table, please provide them. This will allow me to analyze your approach and offer specific guidance.
      4. Desired Outcome:
      How do you want to use the date information? Clearly articulate your goals. Are you trying to:
      Filter data based on specific dates?
      Calculate date differences or intervals?
      Perform date-based calculations (e.g., age, business days)?
      Other?
      Once I have this information, I can provide more tailored guidance on:
      Querying the DATEMASTER table: I can help you construct SQL queries to retrieve the desired date information based on your application's requirements.
      Integrating the date information: I can assist you with integrating the retrieved date data into your application's logic, whether it's for display, calculations, or other purposes.
      Addressing specific issues: If you're encountering any errors or unexpected behavior, I can help you troubleshoot and resolve them.
      By providing these details, I'll be able to offer more effective and relevant solutions to your DATEMASTER table integration challenges.

  • @monikas1117
    @monikas1117 2 ปีที่แล้ว

    how to clear error in date coulmn in sales tables .it shows 62% error

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Hi Monika, 👉Please ping us on WhatsApp wa.me/919916961234 to have a word with our trainer

  • @jasleenkaur-cw2fw
    @jasleenkaur-cw2fw ปีที่แล้ว +1

    Excellent explanation. Thankyou !

  • @grreddy2811
    @grreddy2811 2 ปีที่แล้ว

    Can you please upload the same data set

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Hi Raghav, 👉Please ping us on WhatsApp wa.me/919916961234 for more details and clarification drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB

  • @federicoagomez
    @federicoagomez ปีที่แล้ว +1

    TO ALL WITH THE 'DATE ISSUE' I've founded the solution:
    Go to the 'Transform Sample File' table in the power query editor. Then, replace the dot (.) by a slash (/) in the date column. After that you will see the Sales table with the date column with the correct type.

    • @tarakvaakil8553
      @tarakvaakil8553 ปีที่แล้ว

      it has 62% error with - format

    • @tarakvaakil8553
      @tarakvaakil8553 ปีที่แล้ว

      Then, replace the dot (.) by a slash (/) in the date column
      how, how do we do this?

    • @ganeshnaidu2950
      @ganeshnaidu2950 ปีที่แล้ว

      Not working it with above process

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      Pls check your excel format.. This project was implemented live.. We dint get any issues

  • @manjusingh5338
    @manjusingh5338 2 ปีที่แล้ว +1

    nicely explained, can u share the same data for practice

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Yes, sure, please subscribe our channel

  • @mamidiadithya9265
    @mamidiadithya9265 ปีที่แล้ว

    Bro i've one doubt with-in DAX while using Month, Quarter these type of functions will get intellisense along with Query Field name, but why don't we select DateMaster[Date].Date i've observed that you are not using that (.Date). Any reason for this. Plz reply me.
    Thank You.

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      you can directly use .date functions. since we are creating date master we have used dax. we can use either way

  • @monishpilla4137
    @monishpilla4137 2 ปีที่แล้ว +1

    Thanks for complete lifecycle of power bi.

  • @utkarshrai9147
    @utkarshrai9147 2 ปีที่แล้ว

    I am getting error in date column in sales after 386 rows which says Date format error: We couldn't parse the input provided as a date value
    Details:
    13.1.2016

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      pls get data from here and try
      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing

  • @ManaviVideos
    @ManaviVideos 2 ปีที่แล้ว +2

    Nice to see this video!!

  • @sivajigade5053
    @sivajigade5053 2 ปีที่แล้ว

    Can you Provide dataset for - sales(2104,2015,2016,2017). Got issue when it gets loaded in to Power Bi Desktop."" We couldn't parse the input provided as a Date value.""

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      all files is tested and implemented using same files. Can you please check once excel version?

  • @miniworld-x6k
    @miniworld-x6k 2 หลายเดือนก่อน

    sir the sales data is corrupted could u please resolve it.

    • @KSRDatavizon
      @KSRDatavizon  หลายเดือนก่อน

      let me chekc with my team.

  • @ManaTelugodey
    @ManaTelugodey 3 หลายเดือนก่อน

    Thanks

    • @KSRDatavizon
      @KSRDatavizon  3 หลายเดือนก่อน

      Welcome, please subscribe Our channel

  • @akshukla283
    @akshukla283 2 ปีที่แล้ว +1

    Thank you so much for making these videos, it helps us in a fantastic way 👍

  • @mayur_146
    @mayur_146 ปีที่แล้ว

    Excellent explanation sir. Very crystal clear speaking as well as concepts. Very detailed and clear as well. I am completely a new user for Power BI desktop application, but by doing all the hands-on till now in this video i am feeling very much confident in BI domain with Power BI tool as well. You're really doing great work here by sharing your expertise so clearly with the world. Keep it up sir 🙏 Kudos. Thank you so much once again.

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      you are welcome, please subscribe our channel for regular updates

  • @Nina20157
    @Nina20157 2 ปีที่แล้ว

    who creates this BRD/FRD document? and how to download CSV files from the Github link as provided?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Data Architects, Clients, PMs will create doc.
      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      Please download the data from here

  • @livetradding...2894
    @livetradding...2894 2 ปีที่แล้ว +1

    Amazing explained each and every

  • @Anurita_1004
    @Anurita_1004 2 ปีที่แล้ว

    Here the type of schema we have used is Snowflake... right?
    Can someone please confirm this.

  • @pratikshayadav7765
    @pratikshayadav7765 ปีที่แล้ว

    Sir when i was bringing sales table in power bi the date column is showing blank wht should i do. I followed you as u said steps i did but date column is blank

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      consider these quick troubleshooting points:
      Data Format: Ensure that the date column in your source data has the correct date format. Power BI might not recognize dates if they're not in a recognizable format.
      Data Type: Check if the date column in Power BI is recognized as a date data type. You can change the data type by selecting the column and using the "Modeling" tab.
      Data Load: Verify if the data is properly loaded during the data refresh process. Check for any data loading errors in the Power Query Editor.
      Column Mapping: In Power Query Editor, make sure the date column is mapped correctly from your source data to the Power BI dataset.
      Locale Settings: Sometimes, date formatting issues occur due to different locale settings. Check if your report's locale settings align with your data's date format.
      Transformations: Ensure that there are no data transformations that inadvertently affect the date column's values.
      Null Values: Check if there are any null values in the date column of your data source. Power BI might show blank dates if it encounters null values.
      Time Zone: If your data involves time zones, ensure they are handled correctly during data transformation.
      Data Preview: In Power Query Editor, preview the data to confirm that the date column is being loaded correctly.
      Data Refresh: After making any changes, refresh the data in Power BI to see if the issue is resolved.
      If the date column is still showing as blank after checking these points, you might need to provide more specific details about your data and the steps you've taken so that a more targeted solution can be provided.

  • @meenakshir7746
    @meenakshir7746 2 ปีที่แล้ว

    Hi Sir, Good Morning. While loading a sales report date column is blank. Pls guide me how to fix it.

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      Please try from this datasets

  • @saravananchidambaram3569
    @saravananchidambaram3569 2 หลายเดือนก่อน

    your explanation is very good

    • @KSRDatavizon
      @KSRDatavizon  หลายเดือนก่อน

      Thank you! I'm glad you found my explanation helpful. If you have any other questions, please don't hesitate to ask.

  • @obulesh4618
    @obulesh4618 2 ปีที่แล้ว

    Hi , ur classes r good , but i'm enable to make the relationship between Sales & Product ( Total Revenue) can u please explain it how it works . In Edit Relationship , i'm getting Cross Filter Direction -Both Option & in Cardinality i'm getting Many to many , r else the ok Option is not visible for single - in Cross Filter Direction .

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Guess you are missing some part of cleaning process.
      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      please try again, u can take data from here

  • @saiteja8844
    @saiteja8844 2 ปีที่แล้ว

    Not able to download CSV files from your dataset
    Please give me some solution to this....

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      Please download from here

  • @VijayKumar-mp3bp
    @VijayKumar-mp3bp 2 ปีที่แล้ว

    iam not able to do total revenue getting blank column.
    copied data directly ,please provide proper file

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing

  • @razzkdno1207
    @razzkdno1207 2 ปีที่แล้ว

    We cnt download CSV files

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Please try downloading here
      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing

  • @manasapn8114
    @manasapn8114 2 ปีที่แล้ว

    Hi sir/madam I want know how to use existing template to power bi dashboard please make one video

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Thanks for suggestions. We will upload asap

  • @kirankavya132
    @kirankavya132 ปีที่แล้ว

    Hi sir, converting the month number to the month name is giving the wrong answer. for 1 it is showing December. what could be the problem.

    • @KSRDatavizon
      @KSRDatavizon  4 วันที่ผ่านมา

      The issue you're facing with month number 1 being converted to December instead of January is likely due to a mismatch in the date format settings or the specific function you're using. Here are some common causes and solutions:
      1. Incorrect Date Format:
      Check your regional settings: Ensure that your system's regional settings are configured to use the correct date format (e.g., Month, Day, Year). If the format is incorrect, it can lead to unexpected results when converting month numbers.
      Use the correct format code: When using functions like TEXT or DATEFORMAT, make sure you're using the correct format code for the desired month name (e.g., "MMMM" for full month names).
      2. Function Misuse:
      Incorrect argument: Double-check that you're providing the correct arguments to the function you're using. For example, if you're using TEXT, make sure you're passing the month number as the first argument and the desired format code as the second argument.
      Function limitations: Some functions may have limitations or specific requirements regarding the input values. Ensure that you're using the function correctly and within its intended scope.
      3. Data Type Issues:
      Ensure numeric input: The month number should be a numeric value. If it's stored as text or has leading zeros, it might not be recognized correctly.
      Convert to numeric: If necessary, use functions like VALUE or NUMBERVALUE to convert the month number to a numeric data type.
      Here are some examples of how to convert month numbers to month names in different programming languages and software:
      Excel:
      Excel
      =TEXT(A1, "MMMM")
      Use code with caution.
      Where A1 contains the month number.
      Python:
      Python
      import calendar
      month_number = 1
      month_name = calendar.month_name[month_number]
      print(month_name)
      Use code with caution.
      JavaScript:
      JavaScript
      const monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"];
      const monthNumber
      = 1;
      const monthName = monthNames[monthNumber - 1];
      console.log(monthName);
      Use code with caution.
      By addressing these potential causes and following the appropriate methods, you should be able to successfully convert month numbers to month names without encountering the December issue.
      Sources and related content

  • @rudrakshgandhar3381
    @rudrakshgandhar3381 2 ปีที่แล้ว

    Sir, please make a video on how to make transition from Power BI Developer to Data analyst and differences

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Sure. We will upload ASAP

  • @Super_HIT2
    @Super_HIT2 ปีที่แล้ว +1

    LUV YOU BRO , THANK YOU ,

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      You're welcome!, Please subscribe our channel, it will motivates us

  • @ourfantacies6908
    @ourfantacies6908 2 ปีที่แล้ว

    Wr we can take Data set for practice

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      Please get data from this path

  • @sureshsogalapalli5762
    @sureshsogalapalli5762 2 ปีที่แล้ว +1

    Awesome explanation

  • @vaishnavisagar7003
    @vaishnavisagar7003 2 ปีที่แล้ว

    This video really helpful for the beginners. Can you please how to down the CSV data???

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
      Please download here for all datasets

  • @rroy1283
    @rroy1283 2 ปีที่แล้ว

    Hi i m doing the project with you, more to see real time project in future

  • @vijaysagarb456
    @vijaysagarb456 2 ปีที่แล้ว

    Sir ene to end power bi 4videos are hidden... not showing.once update sir please

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      We have only 4 videos in End to End Playlist. We will create more Projects

  • @user-po2ze4mj4m
    @user-po2ze4mj4m 2 ปีที่แล้ว

    Thanks for sharing.. I have a query.. In Data Modelling we've here Snowflake Schema.. Is it good to merge Category, Subcategory into the products table and then build the relationship between product table and slaes fact table.. By doing this we can achieve Star schema..

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      Yes, good thought, we could have done that. thanks for your suggestions

  • @murugesanv6847
    @murugesanv6847 2 ปีที่แล้ว

    This is very simple and powerful practice to create End to End project, Thank you for very good Explanation

  • @venkatpolasa1058
    @venkatpolasa1058 2 ปีที่แล้ว

    could you please add requirement documents & pbix file in github link

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      All files is attached in GitHub and shared in description. Please refer and download

  • @shivamsaxena388
    @shivamsaxena388 2 ปีที่แล้ว

    Sir ji Your Work Quality and Effort are SOOOOO High , Excellent , and Unbeatable.
    Thank you Sir..!

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      So nice of you Shivam. Welcome :) Please do share in your network.

  • @dambarudhar8469
    @dambarudhar8469 ปีที่แล้ว

    Sir it was a awesome your teaching style and and better understanding easy way

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      Thank You so much , Please subscribe our channel for regular updates.

  • @mohitupadhayay1439
    @mohitupadhayay1439 2 ปีที่แล้ว

    Great Video KSR. I am recommending this channel to many now.
    Also, I expect a few more reports based on Procurement analysis, Humar resources Analysis too.
    Please support!

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Thank you so much.
      We will be uploading more videos

  • @9963398533
    @9963398533 2 ปีที่แล้ว

    In this video what type of modelling did you create?

  • @manojdesharajpally9868
    @manojdesharajpally9868 2 ปีที่แล้ว

    Sir how can I get this dataset and BRD to practice .. thanks ?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      We have added the dataset path in the description

  • @saravananc6477
    @saravananc6477 ปีที่แล้ว

    Very helpful video and waiting for more videos.

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      Very soon, keep watching, Please subscribe our channel, it will motives to do more videos

  • @Yaseen176
    @Yaseen176 ปีที่แล้ว

    Sir, Very Very Knowledgeable Video. Thanks Allah Aap ko Dunya ma Khoos Rakhay.

  • @Rk-mv8sz
    @Rk-mv8sz 2 ปีที่แล้ว

    Simply super video👌 on how the transformations done and how to create date table and add columns.
    Please make more videos on some complex data.

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Sure Thanks for the suggestions. We will upload more projects

  • @sandipansarkar9211
    @sandipansarkar9211 11 หลายเดือนก่อน

    finished watching

    • @KSRDatavizon
      @KSRDatavizon  6 หลายเดือนก่อน

      Thanks for watching

  • @anweshkp6231
    @anweshkp6231 2 ปีที่แล้ว

    In the date master table, will the last date be automatically readjusted after 2018 sales information added to the folder?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      yes thats the purpose of lastdate function

    • @anweshkp6231
      @anweshkp6231 2 ปีที่แล้ว

      @@KSRDatavizon I mean as the new data gets added and refreshed according to schedule, date also gets changed in the date master table? I hope it does, right?

  • @visakhpvinod9878
    @visakhpvinod9878 2 ปีที่แล้ว

    Hi, date column in Sales table shows error 62% in power query? how to solve it?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      drive.google.com/drive/folders/1pzx9OLvUJVF-Lcn07zSskY9GskX90hlc?usp=sharing
      please take data from here

    • @tejalpatil5315
      @tejalpatil5315 ปีที่แล้ว

      ​@@KSRDatavizonSir can you please approve the access request

  • @shirishadevi4614
    @shirishadevi4614 2 ปีที่แล้ว

    thankyou so much its great video

  • @1220ram
    @1220ram 2 ปีที่แล้ว

    In total revenu colum can we sumx() function ?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว +1

      Yes you can. U can write in many ways

  • @lakshmi9960
    @lakshmi9960 ปีที่แล้ว

    hi sir, Once I import the sales folder after combine and load, I am getting an error
    DataFormat.Error: We couldn't parse the input provided as a Date value.
    Details:
    13.1.2014
    I tried to resolve by change the datatype format , eventhough still getting the same error. Kindly let me know the solution

    • @lakshmi9960
      @lakshmi9960 ปีที่แล้ว

      solved ..thank you

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      Thanks.. happy learning !!!

    • @JonathanVelasquez-ve5sz
      @JonathanVelasquez-ve5sz ปีที่แล้ว

      @@lakshmi9960 how you resolved this problem? i have the same problem but i can't solve it

    • @abhilashpragada
      @abhilashpragada ปีที่แล้ว

      can you share the details how you solved

  • @harinadhbadham4544
    @harinadhbadham4544 2 ปีที่แล้ว

    Could you please also upload SQL DBrelated videos which helps for Power bi

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Thanks for suggestions. We will upload asap

  • @vkvlogs4
    @vkvlogs4 2 ปีที่แล้ว

    Hi sir is it possible to create star schema when I have only one table which contains dimension columns and fact columns

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Yes u can. U can create all dimension table for all categorical data

    • @vkvlogs4
      @vkvlogs4 2 ปีที่แล้ว

      @@KSRDatavizon if it's possible plz make a video on this scenario sir.

  • @parameshteja2890
    @parameshteja2890 2 ปีที่แล้ว

    Really Super, very clear explanation awesome sir, could you please share Business/function requirement document, that would really help full for us.

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Thanks. All documents is uploaded and provided link in the description

  • @leelach9608
    @leelach9608 2 ปีที่แล้ว

    super thanx so much sir you explation is so good

  • @shrikantc5556
    @shrikantc5556 2 ปีที่แล้ว

    your explanation is good👌👌 , Thank u for sharing ... 👍

  • @nakulbarot
    @nakulbarot ปีที่แล้ว

    Good to see this video...how real-world challenge occurs

    • @KSRDatavizon
      @KSRDatavizon  ปีที่แล้ว

      You're welcome, please subscribe our channel for regular updates

  • @sowjanyachevvu8677
    @sowjanyachevvu8677 2 ปีที่แล้ว

    Good explanation . Thank you sir.

  • @gkc6198
    @gkc6198 2 ปีที่แล้ว

    Very helpful video and waiting for more videos.

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      More to come! Keep Watching

  • @sayalisurve799
    @sayalisurve799 2 ปีที่แล้ว

    how to download data from GITHUB...

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Its directly download. There is download option if u click the link

  • @lakshitsharma5533
    @lakshitsharma5533 2 ปีที่แล้ว

    Please add BRD/FRD also in that GitHub repository

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      All files is attached in GitHub and shared in description. Please refer and download

  • @cskreddy9127
    @cskreddy9127 5 หลายเดือนก่อน

    ❤TQ ❤🎉

    • @KSRDatavizon
      @KSRDatavizon  5 หลายเดือนก่อน

      Thank you for your support!

  • @Arnavrohangaming
    @Arnavrohangaming 2 ปีที่แล้ว

    Sir it's Very Helpful Thankyou

  • @akhtaralamkhan6837
    @akhtaralamkhan6837 ปีที่แล้ว

    What a wonderful video sir,♥️

  • @lathareddy2976
    @lathareddy2976 2 ปีที่แล้ว

    Sir, am from civil engineering background. Let me know that power bi software can i learn & can i choose as my career option?

    • @shreevamsi2725
      @shreevamsi2725 2 ปีที่แล้ว

      Yes absolutely I'm also civil background but I'm software engg

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Power BI will be the right choice

    • @venkateshtelugu7582
      @venkateshtelugu7582 2 ปีที่แล้ว

      @@shreevamsi2725 i have completed training on power bi so i want to put 4 yeras exp as fake i f i joined in a some other company can i survey or not according to work im asking

  • @theicongamer2761
    @theicongamer2761 2 ปีที่แล้ว

    What is work of power bi tester?

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Will validate all fonts, filter checks, requirement fulfillment check, smoke testing, data validation

  • @hanamantyaragudri2538
    @hanamantyaragudri2538 2 ปีที่แล้ว

    Thank you very much sir.

  • @sujatha95
    @sujatha95 2 ปีที่แล้ว

    pls upload the data for practice

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Hi Mam, its available in description

  • @AKHILKumar-kh8rz
    @AKHILKumar-kh8rz 2 ปีที่แล้ว

    Hi santhosh sir

  • @vsiddu9651
    @vsiddu9651 2 ปีที่แล้ว

    The way you explained was superb

  • @mylapallisrinivas4114
    @mylapallisrinivas4114 2 ปีที่แล้ว

    THANK YOU.EASILY UNDERSTANDABLE.

    • @KSRDatavizon
      @KSRDatavizon  2 ปีที่แล้ว

      Thank you Srinivas for the feedback, please do share in your network. Next Video:
      th-cam.com/video/ye2_fk1H2kQ/w-d-xo.html

  • @mr.prasadyadav
    @mr.prasadyadav 2 ปีที่แล้ว

    Thank you Sir