Vipinvipinmp.hashnode.dev·11 hours agoSQL Concept : 𝗨𝗡𝗣𝗜𝗩𝗢𝗧𝗦𝗤𝗟 𝗢𝗽𝗲𝗿𝗮𝘁𝗼𝗿: 𝗨𝗡𝗣𝗜𝗩𝗢𝗧 When working with relational databases, data often needs to be transformed to meet specific requirements. One such transformation involves converting columns into rows, making the data easier to analyze and vis...SQLSQL
Vipinvipinmp.hashnode.dev·12 hours agoUtility for Data Reconciliation: Comparing Table Extracts and FilesIn data reconciliation projects, it's crucial to ensure the integrity and consistency of data between various sources. To address this need, I have developed a Python utility that compares extracts from tables and files. This utility simplifies the p...E2E ProjectsPython
pallavi chauhaninnovateitworld.hashnode.dev·Dec 20, 2024How Data Analytics Fuels the AI RevolutionThe rise of Artificial Intelligence (AI) is transforming industries, reshaping societies, and redefining how we interact with the world. At the core of this transformation lies data analytics—the driving force behind AI systems. Without data analytic...data
Hitesh Sahnihitech88.hashnode.dev·Dec 19, 2024New Tech Blog: Cloud, Data, and AII’m thrilled to announce the launch of my new blog dedicated to the transformative world of cloud computing, data, analytics, and artificial intelligence (AI). As the pace of technological advancement accelerates, these three pillars are shaping the ...Cloud
Muskantrendingflow.hashnode.dev·Dec 19, 2024How to Build an Impressive Data Analyst PortfolioHaving an impressive portfolio is crucial for aspiring data analysts. A strong portfolio showcases your technical skills, highlights your ability to solve real-world problems, and demonstrates your expertise in deriving insights from data. Here’s a s...Data Science
Limesh Mahialdigitndreams.hashnode.dev·Dec 16, 2024How to Identify and Remove Duplicate Records in SQLDuplicate records in a database can cause inefficiencies and inaccuracies in data processing. Let’s walk through how to identify and handle duplicates in SQL with practical examples using a hypothetical artists table. The Setup: Creating Our artists...SQL
Nalaka Wanniarachchibidiaries.com·Dec 14, 2024🌟 Integrating Managed Identity(MI) and Service Principal for Secure Data Movement: From Azure SQL to Microsoft Fabric via Key Vault 🔒In the world of Azure, managing secure connections between services is critical for building scalable and secure cloud solutions. 🚀 One key tool to achieve this is Managed Identity (MI). But what is it, and how does it work in the context of Azure D...32 readsFabricAzure
Junaid Bin Jamanjunaidbinjaman.help·Dec 12, 2024Beginner-Friendly Guide to XML: Understanding the BasicsIn today's data-driven world, the ability to structure and exchange data efficiently is crucial. One of the most widely used formats for this purpose is XML (eXtensible Markup Language). If you're new to XML, don’t worry! This beginner-friendly guide...xml
Tanupriya Singhtanupriya.com·Dec 9, 2024A Beginner's Guide to Spark: Insights from an MLEIntroduction to Spark Spark is a distributed computing system designed for large-scale data processing. Here are key reasons why Spark is suitable for ML pipelines: High Volume of Data: Many ML problems require processing large datasets, which mig...122 readsspark
esProc Desktopesproc-desktop.hashnode.dev·Dec 9, 2024#113 — Ranking of Row-Based DataProblem description & analysis: Here below is a data table: Task: Calculate the ranking of students by TotalScore (in descending order) and fill the results in corresponding cells of column D. Solution: Use SPL XLL and enter the following formula in...10 likesexcel
