MICRORISC s.r.o.’s Post

Would you like to have a service that would warn you well in advance before the health crisis hits? Medication is a powerful tool, but should we be relying just on it, or add more arrows to the quiver? REVital makes sure the data from your smart wearables benefits you. Our doctors analyse it and you get a report and a recommendation if they see a potential for a problem. #digitalhealthimage #smartprevention #wearables

🔍 Which Branch data export solution should you use? Whether you're looking to export log-level data or aggregate insights, we've got you covered. From Custom Export API to Cross-Events Export API, each option is tailored to meet specific needs and preferences. Not sure where to start? Ask these seven questions and use our flowchart to determine which approach best suits your needs ➡️ https://lnkd.in/eGPr8TGZ

Data is crucial for business success, but is open-source data the best option? dataplor's latest blog post compares open-source data with paid data providers, highlighting the benefits and drawbacks of each. Find out why investing in high-quality data can lead to better decision-making and cost savings. Read more: https://lnkd.in/ePzM9Vmc

✨ 𝗠𝗮𝘀𝘁𝗲𝗿𝗶𝗻𝗴 𝗦𝗤𝗟 𝘄𝗶𝘁𝗵 𝗗𝗔𝗧𝗘𝗧𝗜𝗠𝗘 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀: 𝗬𝗼𝘂𝗿 𝗦𝗲𝗰𝗿𝗲𝘁 𝗪𝗲𝗮𝗽𝗼𝗻 𝗳𝗼𝗿 𝗧𝗶𝗺𝗲-𝗕𝗮𝘀𝗲𝗱 𝗜𝗻𝘀𝗶𝗴𝗵𝘁𝘀! ⏰ Hey data enthusiasts! 🚀 Ever found yourself tangled in a web of dates and times while working on SQL? Trust me, you're not alone. But here's the game-changer – mastering 𝗦𝗤𝗟 𝗗𝗔𝗧𝗘𝗧𝗜𝗠𝗘 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀 can seriously up your game! 🎯 Follow Brainalyst How they can help you create reports, track performance over time, and even impress your boss with those insights no one else saw coming! 😉 🌟 𝗪𝗵𝘆 𝗦𝗵𝗼𝘂𝗹𝗱 𝗬𝗼𝘂 𝗖𝗮𝗿𝗲 𝗔𝗯𝗼𝘂𝘁 𝗗𝗔𝗧𝗘𝗧𝗜𝗠𝗘 𝗙𝘂𝗻𝗰𝘁𝗶𝗼𝗻𝘀? Imagine being able to instantly know the exact age of a customer's order or quickly break down date values into handy parts like hours, minutes, and seconds. These aren’t just random numbers – they can tell a story. When you can extract meaningful insights from dates, you’re not just crunching data; you’re creating opportunities for better decision-making. 🧠💡 Here are some of my favorite functions that literally save me hours every week: 𝟭. 𝗖𝗨𝗥𝗥𝗘𝗡𝗧_𝗗𝗔𝗧𝗘 & 𝗖𝗨𝗥𝗥𝗘𝗡𝗧_𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣 🕒 These are your best friends when you need the latest date and time. Whether it’s tracking the moment an action happens or creating time-sensitive logs, they’ll give you what you need, right now. 𝘚𝘌𝘓𝘌𝘊𝘛 𝘊𝘜𝘙𝘙𝘌𝘕𝘛_𝘋𝘈𝘛𝘌; 𝘚𝘌𝘓𝘌𝘊𝘛 𝘊𝘜𝘙𝘙𝘌𝘕𝘛_𝘛𝘐𝘔𝘌𝘚𝘛𝘈𝘔𝘗; ➡️ 𝗥𝗲𝗮𝗹-𝘄𝗼𝗿𝗹𝗱 𝘄𝗶𝗻: Imagine automatically tracking every customer's login timestamp for personalized service! 𝟮. 𝗔𝗚𝗘 – 𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝗰𝗲𝘀 𝗟𝗶𝗸𝗲 𝗮 𝗣𝗿𝗼 🗓️ Want to find out exactly how many days have passed since your last project started or how long an order has been pending? The 𝗔𝗚𝗘 𝗳𝘂𝗻𝗰𝘁𝗶𝗼𝗻 has got your back. 𝘚𝘌𝘓𝘌𝘊𝘛 𝘢𝘨𝘦('2024-10-01', '2024-01-01'); ➡️ 𝗥𝗲𝗮𝗹-𝘄𝗼𝗿𝗹𝗱 𝘄𝗶𝗻: For anyone managing deliveries, understanding the time between an order date and shipment is pure gold. 𝟯. 𝗘𝗫𝗧𝗥𝗔𝗖𝗧 – 𝗣𝗿𝗲𝗰𝗶𝘀𝗶𝗼𝗻 𝗮𝘁 𝗬𝗼𝘂𝗿 𝗙𝗶𝗻𝗴𝗲𝗿𝘁𝗶𝗽𝘀 🎯 Need to pull out the year from a date or just focus on the hour from a timestamp? The 𝗘𝗫𝗧𝗥𝗔𝗖𝗧 function is perfect for slicing and dicing time values into exactly what you need. 𝘚𝘌𝘓𝘌𝘊𝘛 𝘌𝘟𝘛𝘙𝘈𝘊𝘛(𝘺𝘦𝘢𝘳 𝘍𝘙𝘖𝘔 '2024-04-15'); ➡️ 𝗥𝗲𝗮𝗹-𝘄𝗼𝗿𝗹𝗱 𝘄𝗶𝗻: Want to analyze peak sales hours or traffic times on your website? EXTRACT those insights and watch your analytics soar! 🚀 Enroll Now: https://dsa.brainalyst.in 🌟 𝗪𝗿𝗮𝗽𝗽𝗶𝗻𝗴 𝗨𝗽: 𝗢𝘄𝗻 𝗬𝗼𝘂𝗿 𝗧𝗶𝗺𝗲! Learning these SQL DATETIME functions feels like unlocking a hidden superpower 🦸. You’ll be amazed at how much time (pun intended!) you’ll save and how much deeper your data analysis can go. Imagine being the go-to person in your team for all things time-related – sounds cool, right? 😎 #SQL #DataScience #TechTips #SQLFunctions #TimeManagement #dataanalytics

Are you looking for important work to do? If so, here’s a list of companies you might want to check out.

Check out our mid-year report about the Czech labor market.🏋️♀️

📢 Exemplar Awards 2024 - Nominations Now Open ! https://bit.ly/48ulsUf The closing date for entries is Monday 22nd April 2024 at 17.00 hrs. We are pleased to announce the call for nominations for the Exemplar Awards 2024, hosted by GeoPlace. These prestigious awards aim to acknowledge exceptional contributions to the management and utilisation of street and addressing data within the United Kingdom. The presentation of the awards will constitutes an important feature of the GeoPlace Annual Conference on 21 Mat 2024. High-quality address and street data play a foundational role in various facets of local government activities. This ranges from substantial transformation projects, where gazetteers serve as the central element, resulting in significant cost savings for authorities, to more modest initiatives that demonstrate innovative approaches to integrating additional information or utilising gazetteers in unconventional ways. The significance of accurate, current, and well-maintained data cannot be overstated. Without these attributes, addressing the myriad challenges faced in these endeavours becomes an insurmountable task. The Exemplar Awards are presented in the following categories: 🏆 Exemplar Award - https://lnkd.in/e96Hx3KF 🏆 Data Linking Award - https://lnkd.in/esfMfgJC 🏆 Peer Award - https://lnkd.in/eCNKC5GP 🏆 Data Quality and Improvement Awards, including: https://lnkd.in/eVGnuNB4 - The Improvement Award for Addresses - The Improvement Award for Streets - Gold Award for Address Data - Gold Award for Street Data - Platinum Award for Address Data - Platinum Award for Street Data Find more details and enter here: https://bit.ly/48ulsUf View the winners, case studies and write-ups of the Exemplar Awards as far back as 2007 in the 'Exemplar Award Archive' https://bit.ly/3OWAUl4

𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐐&𝐀(𝐃𝐚𝐲𝟐𝟔-𝟓𝟎) 𝐃𝐚𝐲𝟑𝟓# 𝐐: 𝐖𝐡𝐚𝐭 𝐢𝐬 𝐭𝐡𝐞 𝐃𝐢𝐟𝐟𝐞𝐫𝐞𝐧𝐜𝐞 𝐁𝐞𝐭𝐰𝐞𝐞𝐧 𝐒𝐐𝐋 𝐔𝐍𝐈𝐎𝐍 𝐚𝐧𝐝 𝐔𝐍𝐈𝐎𝐍 𝐀𝐋𝐋? 𝟏. 𝐖𝐡𝐚𝐭 𝐢𝐬 𝐔𝐍𝐈𝐎𝐍? 🔹UNION is used to combine the results of two or more SELECT statements into a single result set. 🔹It removes duplicates from the combined result, ensuring all values are unique. 🔹Ideal when you need a distinct result set without any repeated rows. 𝟐. 𝐖𝐡𝐚𝐭 𝐢𝐬 𝐔𝐍𝐈𝐎𝐍 𝐀𝐋𝐋? 🔹UNION ALL also combines the results of multiple SELECT queries. 🔹However, it does not remove duplicates, which means all rows from both queries will be included, even if they are identical. 🔹This makes UNION ALL faster, especially with large datasets, as it skips the overhead of duplicate removal. 𝟑. 𝐖𝐡𝐞𝐧 𝐭𝐨 𝐔𝐬𝐞 𝐔𝐍𝐈𝐎𝐍? 🔹Use UNION when duplicate data needs to be eliminated, and only distinct rows are required in the result set. 🔹Ideal for clean data outputs where precision is critical. 𝟒. 𝐖𝐡𝐞𝐧 𝐭𝐨 𝐔𝐬𝐞 𝐔𝐍𝐈𝐎𝐍 𝐀𝐋𝐋? 🔹Use UNION ALL when you’re working with large datasets and don't need to worry about duplicates. 🔹It's perfect for query performance optimization where speed is more important than removing repeated rows. 𝟓. 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐂𝐨𝐧𝐬𝐢𝐝𝐞𝐫𝐚𝐭𝐢𝐨𝐧 🔹How UNION can be slower due to the deduplication process. 🔹UNION ALL is faster as it simply merges the datasets without checking for duplicates. Connect with me Racharla Naveen Kumar for more updates Tags 📑: Avinash Achar Adapala Naveen Kumar Rajeswari Kotha Ayan Khan Aryan Pokhriyal AMAN KUMAR Shashank Sharma Bigyandutt P. Vishnukanth k Vannur Vali Dudekula Lakshmi T S Santosh Pothnak 💎 Adilfaizan Razvi Pankaj Namekar

𝗤𝘂𝗶𝗰𝗸𝗲𝗿, 𝗙𝗮𝘀𝘁𝗲𝗿, 𝗦𝗺𝗮𝗿𝘁𝗲𝗿: 𝗛𝗼𝘄 𝗖𝗹𝗶𝗰𝗸𝗛𝗼𝘂𝘀𝗲’𝘀 𝗥𝗲𝗽𝗹𝗮𝗰𝗶𝗻𝗴𝗠𝗲𝗿𝗴𝗲𝗧𝗿𝗲𝗲 𝗥𝗲𝘃𝗮𝗺𝗽𝗲𝗱 𝗢𝘂𝗿 𝗗𝗮𝘁𝗮 𝗛𝗮𝗻𝗱𝗹𝗶𝗻𝗴! 🌟 Today, I want to dive into how we leveraged the 𝗥𝗲𝗽𝗹𝗮𝗰𝗶𝗻𝗴𝗠𝗲𝗿𝗴𝗲𝗧𝗿𝗲𝗲 𝗲𝗻𝗴𝗶𝗻𝗲 at ClickHouse to streamline a critical process in our bank statement parser. 𝗧𝗵𝗲 𝗖𝗵𝗮𝗹𝗹𝗲𝗻𝗴𝗲: When users upload their bank statements, often spread across multiple PDF files, we encounter a common issue: repetitive identity-related data like account numbers remains consistent across different uploads. We have to now stream this data clickhouse for every statement. Our traditional method involved checking if an entry already existed and then updating or inserting accordingly. But imagine doing this with a database handling billions of rows! 🤯 The cost in performance for full table scans was immense. Even with the use of index. 𝗢𝘂𝗿 𝗦𝗼𝗹𝘂𝘁𝗶𝗼𝗻: We turned to 𝗥𝗲𝗽𝗹𝗮𝗰𝗶𝗻𝗴𝗠𝗲𝗿𝗴𝗲𝗧𝗿𝗲𝗲! By setting the account number as the 𝘃𝗲𝗿𝘀𝗶𝗼𝗻𝗶𝗻𝗴 𝗰𝗼𝗹𝘂𝗺𝗻, ClickHouse now smartly handles deduplication for us. Each time a statement is uploaded, instead of us manually checking for duplicates, ClickHouse automatically replaces any older data associated with the same account number with the latest information. This approach not only saved us from costly full table scans but also significantly sped up our data processing, allowing for real-time updates without sacrificing performance. 🚀 𝗪𝗵𝘆 𝗜𝘁 𝗠𝗮𝘁𝘁𝗲𝗿𝘀: This isn’t just about efficiency; it’s about making our services more reliable and faster for our users, enhancing their experience without them ever seeing what goes on behind the scenes. And that’s the beauty of a  𝗿𝗼𝗯𝘂𝘀𝘁 𝗯𝗮𝗰𝗸𝗲𝗻𝗱—𝘀𝗶𝗹𝗲𝗻𝘁 𝘆𝗲𝘁 𝗶𝗺𝗽𝗮𝗰𝘁𝗳𝘂𝗹. Stay tuned for more insights as we explore the dynamic world of database engines. 🌐 #ClickHouse #DataManagement #BigData #TechInnovation

Data sharing.... its not easy.... ...having worked in government for 17 years, I saw first hand just how difficult it could be. The ability to know what data is available in other departments, especially the more niche or obscure data, was hard. Knowing if a Data Sharing Agreement or Memorandum of Understanding had been shared was also hard. Seeing this in action makes me realise just how needed this resource is, and how it make data sharing that much easier. Even better is seeing how metadata is being used - takes me back to my Knowledge and Information Management days! If you want to know more, let me know #DataSharing #DataMarketplace #Government https://lnkd.in/eFJQSRUX