Forum Discussion
Maintenance services analysis
So I Have Some Data Of A Company And It's As Follows, I Hava 6 Tables :
gestion_services (igserv, idserv, type_service)
`gestion_maintenance` (
`id_maintenance` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`prix_maintenance` float NOT NULL,
`taxe_maintenance` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_v` varchar(50) NOT NULL,
)
`gestion_vidange` (
`id_vidange` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`km_s_vid` float NOT NULL,
`km_e_vid` float NOT NULL,
`prix_vidange` float NOT NULL,
`taxe_vidange` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_v` varchar(50) NOT NULL,
)
`gestion_vignette` (
`id_vignette` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_f` datetime NOT NULL,
`prix_vignette` float NOT NULL,
`taxe_vignette` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
)
`gestion_visite` (
`id_visite` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_F` datetime NOT NULL,
`prix_visite` float NOT NULL,
`taxe_visite` float NOT NULL,
`imei_v` varchar(16) NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
)
`gestion_assurance` (
`id_assurance` int(11) NOT NULL AUTO_INCREMENT,
`date_d` datetime NOT NULL,
`date_f` datetime NOT NULL,
`prix_assurance` float NOT NULL,
`taxe_assurance` float NOT NULL,
`user_id` int(11) NOT NULL,
`nom_V` varchar(50) NOT NULL,
`imei_v` varchar(16) NOT NULL,
)
This Is How The Tables are Shaped, What I Want Is To Do SOme Visuals So I Can Get Some organized infos on the services done on a vehicle. I don't know what to do because i'm still a beginner on this. i asked chatGPT but it always miss understands the data and says some general stuff.
1 Reply
- AnonymousNot applicable
Hi hamzaallali ,
This is a question that contains quite a lot of detail and I can't answer it directly. I would first suggest that you take a little time to read this blog and consider breaking the problem down into a number of specific questions, which will increase the probability of the problem being solved. (For example, if I want a graph that reflects how the number of users/activity changes over the month, what data do I have (minus the privacy simulation data))
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
Try learning from here, from building your own models to visualization.
Browse all learning paths and modulesBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum