NW_SolidRose retweeted
Fantastic turnout for #doa6lr for #vsfightingxiv. Shoutouts to all the players & congrats to @ULTIMa_Ivanov for winning!! @NW_SolidRose & seldom sad Sam round up the top 3! Thanks to @HurricaneRev for organising. @koeitecmoeurope @TeamNINJAStudio
NW_SolidRose retweeted
yea we don't have time to be dealing with all that..
Leroy's d+1+2 has better tracking depending on what side he starts on. If he starts on P1, you can SSR d+1+2 but if he starts on P2, it becomes homing in this situation regardless of what side he ends up on #t8_report
NW_SolidRose retweeted
Apache Kafka 3.8.0 was just released! 🔥
What comes with this new release?
Here are the top features you should know about:
1/9 🧵 (2-minute read)
NW_SolidRose retweeted
Provisioning #Kubernetes Clusters On #AWS Using #Terraform & #EKS
Setting up clusters from scratch is laborious. AWS offers a robust solution for orchestrating K8s clusters with EKS. Terraform simplifies the infrastructure provisioning process
axelerant.com/blog/provision… #DevOps
NW_SolidRose retweeted
3 Case Study Style SQL Interview Questions:
1) Imagine you work for an e-commerce company, and they want to segment their customers based on their purchase history.
How would you group customers into three segments: "High Value" (top 20% of spenders), "Medium Value" (next 30% of spenders), and "Low Value" (bottom 50% of spenders).
Example Answer: To segment customers, I would start by calculating the total spend for each customer.
Then, I'd rank customers by their spending and divide them into three segments: "High Value," "Medium Value," and "Low Value" based on their spending percentiles.
I'd use SQL's window functions like SUM() OVER (ORDER BY spending DESC).
2) You are analysing sales data for a retail store chain.
How would you find the year-over-year (YoY) growth in sales revenue for each store location for the last three years.
The result should show the store location, year, and the YoY growth percentage.
Example Answer: I would begin by extracting sales data for each store location for the last three years.
Then, I'd calculate the YoY growth by subtracting the previous year's sales from the current year's sales and dividing by the previous year's sales.
Finally, I'd present the results with the relevant store locations, years, and YoY growth percentages in an SQL query.
3) You work for a large grocery store chain and they want to optimise their inventory management.
How would you identify the top 10 products that have the highest sales-to-inventory ratio.
The ratio is calculated as (Total Sales / Average Inventory Value) for each product.
Example Answer: To do this, I'd first calculate the total sales and average inventory value for each product.
Then, I'd compute the sales-to-inventory ratio for each product.
To rank the products, I would use the RANK() or DENSE_RANK() window function based on the sales-to-inventory ratio, ordering the products in descending order of their ratio (depending on how I want to handle duplicate rankings).
Finally, I'd limit the query to the top 10 products.
How would you get on if these came up in your interview?
Let me know in the comments 👇
NW_SolidRose retweeted
👉 Awesome Python
A curated list of awesome Python frameworks, libraries, software and resources.
🔗 github.com/vinta/awesome-pyt…
NW_SolidRose retweeted
Azure Data Factory Cookbook - Second Edition: A data engineer's guide to building and managing ETL and ELT pipelines with data integration amzn.to/43e0NCN
NW_SolidRose retweeted
ANNOUNCEMENT
Iron Pride is proud to present Iron Pride May Day Tournament, a 1 day Tekken Event at Gravity Wandsworth ( London ).
We will have a Tekken 8 Tournament and our friends @DQRetro will be running a Tekken Ball Tournament too.























