استخدمت Googlemaps API عشان احصل على احداثيات كل مكتب استشارات بيئية كذلك اضفت عمود للـregion يحدد ان المكتب تابع لأي منطقة ادارية و قدرت احددها بشكل صحيح باستخدام حساب المسافة الجوية و الارضية و اختيار الادق بينهم
الان البيانات نظيفة و قابلة للتحليل و بناء Dashboard بالـPower BI
عينة من الشغل و المخرج النهائي نقلته للباور بي اي استعداداً لبناء الداشبورد الليلة 🥸👇🏼
🔥 How I broke the internet today and what lessons can we learn from it? #Crowdstrike 🧐
Several things that make it a good fake that worked: 👇
1. No culprit named yet, I bring it on a platter, people like to have a culprit.
2- The culprit seems completely stupid, he is proud of his stupidity, he... takes his afternoon off on... the first day of work...
3- This falls right into a huge buzz in which people absolutely need to have new information, and a fake is by nature new, you won't read it anywhere else
4- In English = very easy to share internationally, with the vast majority of people who have no idea who I am.
5- Baby fingers are stupid, but they distract people from other things (like the fact that I have a horn on my head because of bad clipping)
6- Confirmation bias: People want to believe it, it's so funny. “I like the information, so it is true.”
7- The information is pushed ironically by people who know that it is a joke, and then it arrives in the litteral zone which amplifies it even stronger.
What is faster in MySQL: search by ENUM or by integer with indexed foreign key?
where status='new'
VS
where status_id = 1
What do you think?
I've experimented with 1M records on default Filament demo.
Surprisingly to me, foreign key is 2x SLOWER.
At least in my case.