End to End Project in Power BI Part 2 | India's Best IT Training | KSR Datavizon | Power BI
Vložit
- čas přidán 8. 02. 2022
- #IndiaBestITtrainingCenter #KSRDatavizon #endtoend#Preparations #Projects #realtimeProjects #
Datasets for practice
drive.google.com/drive/folder...
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.com/drive/folder...
github.com/ksrpowerbi/Project...
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: • Exclusive: EY 2021 Pow...
Live Powerbi Interview with EY -Round 1: • Live Recorded Intervie...
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.
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 CZcams channel 👉Please ping on WhatsApp wa.me/9916961234
Elegantly teaches everything about endtoend project transformation by Santhosh sir by ksr team and great effort of our team mahesh sir
Thank you 😊
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
This is very simple and powerful practice to create End to End project, Thank you for very good Explanation
Glad it was helpful!
Thank you so much sir ❤ for this amazing playlist. You have taught us the industry standards which nobody does
It's my pleasure
Thank you so much for making these videos, it helps us in a fantastic way 👍
Our pleasure!
Hi i m doing the project with you, more to see real time project in future
really simply understand this session ..... your slang is clearly understand my level of english...thank you sir
You are most welcome
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.
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
Good to see this video...how real-world challenge occurs
You're welcome, please subscribe our channel for regular updates
Very helpful video and waiting for more videos.
More to come! Keep Watching
thankyou so much its great video
Sir, Very Very Knowledgeable Video. Thanks Allah Aap ko Dunya ma Khoos Rakhay.
Thank You so much
Fantastic… perfectly explained…great work 👍🏻👍🏻👍🏻
Glad you liked it
@@KSRDatavizon Part 3 ???
i am very impressed with your project sir . Thnaku
You are most welcome
Nice to see this video!!
Glad you like it!
Amazing explained each and every
Thanks
your explanation is good👌👌 , Thank u for sharing ... 👍
Welcome 😊
THANK YOU.EASILY UNDERSTANDABLE.
Thank you Srinivas for the feedback, please do share in your network. Next Video:
czcams.com/video/ye2_fk1H2kQ/video.html
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.
What a wonderful video sir,♥️
Thank you so much
Thank you Sir
Excellent...Excellent.....
Many thanks
Excellent explanation. Thankyou !
You are welcome!
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
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
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
super thanx so much sir you explation is so good
Thanks and welcome
The way you explained was superb
Thanks a lot 😊
Good explanation . Thank you sir.
You are welcome
Sir it's Very Helpful Thankyou
Most welcome
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.
Thanks for complete lifecycle of power bi.
Most welcome
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
Awesome explanation
Glad you liked it
Amazing, Thank you
you are welcome
Amazing explanation Sir❤️❤️
Hates off 🤲
Thank you so much, Please subscribe our channel for regular updates.
Useful videos 👏👏👏
Thank you 🙂
Thank you very much sir.
Most welcome
LUV YOU BRO , THANK YOU ,
You're welcome!, Please subscribe our channel, it will motivates us
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.
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
Well Explained 🙌
Glad you liked it!
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
finished watching
Thanks for watching
I stucked at a related function for calculating Total Revenue please any hint you can give me really appreciated
In previous video there was product table now there is productdetails table and also when I am calculating total revenue it is not runing
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 thank you for the tutorial but I have errors when loading the sales data , kindly assist -please
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
Thanks
Welcome, please subscribe Our channel
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.
Sir Waiting for next part 3
Very soon
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?
❤TQ ❤🎉
Thank you for your support!
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
Awesome, super sir. Pls share the source file, it could be more helpful for practice.
Check description :)
DESERVES A SUBSCRIBE
thank you so much
@@KSRDatavizon ,
Really it was very helpfulll
Dears DateMaster come from where?
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
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
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
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.
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
I CREATED DATEMASTER TABLE BUT I AM TRY TO APPLY DATE FROM DATEMASTER ITS NOT WORKING
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?
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 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.
Could you please also upload SQL DBrelated videos which helps for Power bi
Thanks for suggestions. We will upload asap
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.
In total revenu colum can we sumx() function ?
Yes you can. U can write in many ways
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
In this video what type of modelling did you create?
snowflake
nicely explained, can u share the same data for practice
Yes, sure, please subscribe our channel
Sir, please make a video on how to make transition from Power BI Developer to Data analyst and differences
Sure. We will upload ASAP
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
Here the type of schema we have used is Snowflake... right?
Can someone please confirm this.
Yes Snowflake Schema
Sir, am from civil engineering background. Let me know that power bi software can i learn & can i choose as my career option?
Yes absolutely I'm also civil background but I'm software engg
Power BI will be the right choice
@@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
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
Wr we can take Data set for practice
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please get data from this path
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
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
Please add BRD/FRD also in that GitHub repository
All files is attached in GitHub and shared in description. Please refer and download
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
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
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
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
My Date column has 62% error, please tell me how do I fix this
Whats the error?
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
What is work of power bi tester?
Will validate all fonts, filter checks, requirement fulfillment check, smoke testing, data validation
Hi can u attach the FRD docs..
All files are uploaded to GitHub provided in description. Please refer and download.
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
Hi santhosh sir
could you please add requirement documents & pbix file in github link
All files is attached in GitHub and shared in description. Please refer and download
how do we identify fact and dimension table?
U will have one id per row (easiest way to identity Dim table)
@@KSRDatavizon In this video what type of modelling did you create?
how to download data from GITHUB...
Its directly download. There is download option if u click the link
We cnt download CSV files
Please try downloading here
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
pls upload the data for practice
Hi Mam, its available in description