https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
All conversation was verbal when they called in each area in india and while telling so managers have a tendency to lie/ sugercote to frame all is good and when they ask for numbers they’ll give you large excel files which are not readable
which doesn’t describe the actual problem where to put more effort on which is more easier to understand as a picture
Lets say all data is gathered by their application and stored in mysql database
and by using that data as a source to build a power bi dashboard
Transformation of data from main database is needed because it can affect main stream business
dumb.sql seen the database we can use that database just have to think that from where you got it
https://codebasics.io/resources/sales-insights-data-analysis-project
*Disclaimer while on downloading their dump.sql(the dataset)
By downloading this dataset, you are agreeing to use it for intended learning purposes only. Any unauthorised commercial use or sharing of the dataset is strictly prohibited and leads to a violation of the Codebasics terms of use. Third-party content within the files may be subject to separate license terms.
but about this.. so have to find new one i guess or can we use this because its for learning purpose if we choose to take this next We have to do data cleaning and start for PowerBi
We can use both database from kaggle (.csv’s) or this .sql from current database but then have to change problem statement accordingly
If we want to use SQL queries only we can as they said you can use any thing as your tech stack
And buy Continue building we can make this Data Analysis Project
*But the main Problem is still there that what dataset we are choosing so All concept note is according to it