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
I saw many lectures but this is such which is actually i was looking forward. Thanks for this amazing video. Sir would request you please create more and more videos like this..
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 😊
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...
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.
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.
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..🙏
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.
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!
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.....
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.
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"
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
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
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.
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
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!
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!
@@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?
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.
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
Data Architects, Clients, PMs will create doc. drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing Please download the data from here
Hi Raghav, 👉Please ping us on WhatsApp wa.me/919916961234 for more details and clarification drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB
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.
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..
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
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.
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
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.""
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 .
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
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.
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
I saw many lectures but this is such which is actually i was looking forward. Thanks for this amazing video. Sir would request you please create more and more videos like this..
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 😊
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.
Adarsh Naik - Pls help me with power BI job.I have good knowledge but not getting job yet so far. Can you recommend
Elegantly teaches everything about endtoend project transformation by Santhosh sir by ksr team and great effort of our team mahesh sir
Thank you 😊
really simply understand this session ..... your slang is clearly understand my level of english...thank you sir
You are most welcome
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...
So nice of you ! You are welcome! Please subscribe our channel, it motivates us
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.
Gald you liked it.. this will motivate us to upload more.. thanks
This is very simple and powerful practice to create End to End project, Thank you for very good Explanation
Glad it was helpful!
Sir, Very Very Knowledgeable Video. Thanks Allah Aap ko Dunya ma Khoos Rakhay.
Thank You so much
Thank you so much sir ❤ for this amazing playlist. You have taught us the industry standards which nobody does
It's my pleasure
Sir ji Your Work Quality and Effort are SOOOOO High , Excellent , and Unbeatable.
Thank you Sir..!
So nice of you Shivam. Welcome :) Please do share in your network.
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.
you are welcome, please subscribe our channel for regular updates
Good to see this video...how real-world challenge occurs
You're welcome, please subscribe our channel for regular updates
Amazing explanation Sir❤️❤️
Hates off 🤲
Thank you so much, Please subscribe our channel for regular updates.
Sir it was a awesome your teaching style and and better understanding easy way
Thank You so much , Please subscribe our channel for regular updates.
Amazing explained each and every
Thanks
Nice to see this video!!
Glad you like it!
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..🙏
Keep watching
Thank you so much for making these videos, it helps us in a fantastic way 👍
Our pleasure!
i am very impressed with your project sir . Thnaku
You are most welcome
Excellent explanation. Thankyou !
You are welcome!
Awesome explanation
Glad you liked it
Amazing, Thank you
you are welcome
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.
Yes I also would love to get this knowledge
Sure will upload asap
Very helpful video and waiting for more videos.
More to come! Keep Watching
your explanation is good👌👌 , Thank u for sharing ... 👍
Welcome 😊
The way you explained was superb
Thanks a lot 😊
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?
Not necessarily that id should be number .. yes it's snowflake
What a wonderful video sir,♥️
Thank you so much
your explanation is very good
Thank you! I'm glad you found my explanation helpful. If you have any other questions, please don't hesitate to ask.
Hi i m doing the project with you, more to see real time project in future
Excellent explanation.... 👏👏👏
Thank you Deena, keep watching - do share in your network
👉Please ping on WhatsApp wa.me/919916961234 for more details regarding the course.
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!
Thank you so much.
We will be uploading more videos
Fantastic… perfectly explained…great work 👍🏻👍🏻👍🏻
Glad you liked it
@@KSRDatavizon Part 3 ???
Thanks for complete lifecycle of power bi.
Most welcome
Excellent...Excellent.....
Many thanks
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.....
No worries, we will make maximum videos to help you people.
LUV YOU BRO , THANK YOU ,
You're welcome!, Please subscribe our channel, it will motivates us
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.
Sure Thanks for the suggestions. We will upload more projects
Good explanation . Thank you sir.
You are welcome
hi thank you for the tutorial but I have errors when loading the sales data , kindly assist -please
super thanx so much sir you explation is so good
Thanks and welcome
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
in power query editor it is straight forward to remove duplicates
THANK YOU.EASILY UNDERSTANDABLE.
Thank you Srinivas for the feedback, please do share in your network. Next Video:
th-cam.com/video/ye2_fk1H2kQ/w-d-xo.html
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.
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"
finished watching
Thanks for watching
Awesome, super sir. Pls share the source file, it could be more helpful for practice.
Check description :)
Sir it's Very Helpful Thankyou
Most welcome
Useful videos 👏👏👏
Thank you 🙂
In previous video there was product table now there is productdetails table and also when I am calculating total revenue it is not runing
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
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
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.
thankyou so much its great video
What data modelling we created
Is it star schema or snow flake schema
its star schema
@@KSRDatavizon but its connected two fact table...so i got confused?
@@KSRDatavizoncategory table subcategory tables are intervonnected
17:21
Thank you very much sir.
Most welcome
I stucked at a related function for calculating Total Revenue please any hint you can give me really appreciated
Before using related function.. make you have connected the tables.. there should be relationship between tables
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
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!
nicely explained, can u share the same data for practice
Yes, sure, please subscribe our channel
Sir how can i get the requirement tables in part 1 do to it as partical
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!
Well Explained 🙌
Glad you liked it!
❤TQ ❤🎉
Thank you for your support!
Hi
why my sales information is not showing 100% 0% &0% rule but showing unexpected error ocuures for all coloumn
we dint get ur issue.. pls email your doubt with snapshots santosh_j@ksrconsultantservices.com
In the date master table, will the last date be automatically readjusted after 2018 sales information added to the folder?
yes thats the purpose of lastdate function
@@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?
Wr we can take Data set for practice
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please get data from this path
Sir, please make a video on how to make transition from Power BI Developer to Data analyst and differences
Sure. We will upload ASAP
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.
it has 62% error with - format
Then, replace the dot (.) by a slash (/) in the date column
how, how do we do this?
Not working it with above process
Pls check your excel format.. This project was implemented live.. We dint get any issues
This video really helpful for the beginners. Can you please how to down the CSV data???
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download here for all datasets
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.
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
Thanks
Welcome, please subscribe Our channel
Hi sir is it possible to create star schema when I have only one table which contains dimension columns and fact columns
Yes u can. U can create all dimension table for all categorical data
@@KSRDatavizon if it's possible plz make a video on this scenario sir.
who creates this BRD/FRD document? and how to download CSV files from the Github link as provided?
Data Architects, Clients, PMs will create doc.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download the data from here
Really Super, very clear explanation awesome sir, could you please share Business/function requirement document, that would really help full for us.
Thanks. All documents is uploaded and provided link in the description
Hi, date column in Sales table shows error 62% in power query? how to solve it?
drive.google.com/drive/folders/1pzx9OLvUJVF-Lcn07zSskY9GskX90hlc?usp=sharing
please take data from here
@@KSRDatavizonSir can you please approve the access request
In this video what type of modelling did you create?
snowflake
Hi Sir, Good Morning. While loading a sales report date column is blank. Pls guide me how to fix it.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please try from this datasets
iam not able to do total revenue getting blank column.
copied data directly ,please provide proper file
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
How do i get the Product table?
Thank you so much for your comment, Please like, share and subscribe our channel for regular updates. it motivates us a lot
Can you please upload the same data set
Hi Raghav, 👉Please ping us on WhatsApp wa.me/919916961234 for more details and clarification drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB
I CREATED DATEMASTER TABLE BUT I AM TRY TO APPLY DATE FROM DATEMASTER ITS NOT WORKING
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.
how to clear error in date coulmn in sales tables .it shows 62% error
Hi Monika, 👉Please ping us on WhatsApp wa.me/919916961234 to have a word with our trainer
Sir ene to end power bi 4videos are hidden... not showing.once update sir please
We have only 4 videos in End to End Playlist. We will create more Projects
Thank you Sir
Dears DateMaster come from where?
We need to create one.. by using calendar dax function
sir the sales data is corrupted could u please resolve it.
let me chekc with my team.
Not able to download CSV files from your dataset
Please give me some solution to this....
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download from here
Could you please also upload SQL DBrelated videos which helps for Power bi
Thanks for suggestions. We will upload asap
Pls tell me what's the product
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..
Yes, good thought, we could have done that. thanks for your suggestions
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
solved ..thank you
Thanks.. happy learning !!!
@@lakshmi9960 how you resolved this problem? i have the same problem but i can't solve it
can you share the details how you solved
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.
you can directly use .date functions. since we are creating date master we have used dax. we can use either way
Here the type of schema we have used is Snowflake... right?
Can someone please confirm this.
Yes Snowflake Schema
DESERVES A SUBSCRIBE
thank you so much
@@KSRDatavizon ,
Really it was very helpfulll
In total revenu colum can we sumx() function ?
Yes you can. U can write in many ways
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
pls get data from here and try
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Hi sir/madam I want know how to use existing template to power bi dashboard please make one video
Thanks for suggestions. We will upload asap
Sir how can I get this dataset and BRD to practice .. thanks ?
We have added the dataset path in the description
Sir Waiting for next part 3
Very soon
My Date column has 62% error, please tell me how do I fix this
Whats the error?
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.""
all files is tested and implemented using same files. Can you please check once excel version?
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 .
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
facing a error while transforming dates
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.