Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,195,381 members, 7,958,048 topics. Date: Wednesday, 25 September 2024 at 08:07 AM |
Nairaland Forum / Science/Technology / Programming / Data Analysis With Mysql (668 Views)
Python With MYSQL: Registration Form In Python Using Tkinter And MYSQL Database / I Want To Learn How To Connect Html Form With Mysql Database For A Fee / Good With Mysql? (2) (3) (4)
Data Analysis With Mysql by jamerflepz(m): 10:12pm On Feb 10, 2022 |
As a data analyst, SQL happens to be my favourite programming language or query language like I love to call it. It's quite easy to learn but gets complicated when you get deep into it. I will be sharing with you a simple project I worked on this week. Nothing fancy. Just messing around with this dataset. 1) This is a productsData dataset and as you can see from the picture below: a) i created a database b) imported the dataset for Excel to mySQL c) highlighting number 7 alone and running it will give the result below d) this is the raw dataset
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:18pm On Feb 10, 2022 |
2) I decided to clean and analyse the data by: a) adding row numbers to the data b) using the CASE function to create a new product_ranking column c) using the WHERE clause to remove product_name that has ? on it. d) highlighting from 9 - 17 and running it, gives you the result below. e) this is my new dataset 1 Like
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:21pm On Feb 10, 2022 |
3) Writing a query to find the top 3 products and their prices. a) highlighting 21 - 25 and running it gives you the result below.
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:30pm On Feb 10, 2022 |
4) Instead of executing the same query multiple times, I created a VIEW showing only values with pro from the professional_publication column. a) writing the query from 28 - 39 b) highlighting 41 only and executing it, gives you the result below. 1 Share
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:36pm On Feb 10, 2022 |
5) Just like the VIEW above, another VIEW was created to show 'private' values only from the professional_publication column a) writing query from 44 - 55 b) highlighting 57 only and executing it, gives you the result below.
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:46pm On Feb 10, 2022 |
6) Instead of sending multiple sql statements, I created a procedure to store the products with price lesser than the total average price a) writing query from 61 - 70 b) calling the stored procedure by highlighting 72 only and executing it, which then gives you the result below.
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:51pm On Feb 10, 2022 |
7) Finally Just like the STORED PROCEDURE above, I created another to store products with price greater than the total average price. a) writing query from 75 - 84 b) calling the stored procedure by highlighting 86 only and executing it, which then gives you the result below.
|
Re: Data Analysis With Mysql by jamerflepz(m): 10:57pm On Feb 10, 2022 |
jamerflepz:This new dataset is exported to Excel or Power BI or tableau or python for data visualization. Creating a dashboard is important. Very important. |
Re: Data Analysis With Mysql by gbengaoyeladun(m): 11:55pm On Feb 11, 2022 |
Well done |
Re: Data Analysis With Mysql by airsaylongcome: 2:38pm On Feb 12, 2022 |
5.7 or v8? |
Re: Data Analysis With Mysql by jamerflepz(m): 6:40pm On Feb 12, 2022 |
gbengaoyeladun:Thank you. |
Re: Data Analysis With Mysql by jamerflepz(m): 6:40pm On Feb 12, 2022 |
airsaylongcome:v8 |
Re: Data Analysis With Mysql by airsaylongcome: 7:03pm On Feb 12, 2022 |
jamerflepz: Let me go and dust up my SQL skills. Reading this was very nostalgic. With v8 I'm assuming you don't touch Maria. Postgres? |
Re: Data Analysis With Mysql by jamerflepz(m): 7:59pm On Feb 12, 2022 |
airsaylongcome:Nah I don't. I do work on postgreSQL sometimes but not as much as MySQL. |
(1) (Reply)
My React App Works On PC But Not On Mobile / Remita Integration / Why Do Java And C# Developer Always Look Down On Nodejs Developers
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 15 |