Emediong Harrisondelcy.hashnode.dev·Sep 16, 2023Harness the Power of SQL CASE - Your Ultimate SQL CASE Statement GuideSQL is the language of databases, and it's not just about fetching data. It's also about transforming data intelligently. One of the most potent tools in SQL's arsenal is the CASE statement. In this article, we'll crack open the SQL CASE statement's ...Discuss·11 likesSQL ORDER BY CASE
Opere Peteropere.hashnode.dev·Jun 25, 2023Simplifying Data Transformations with dbt: A Comprehensive GuideIntroduction In the realm of data analytics and engineering, the process of transforming, testing, and managing data in data warehouses can be complex and time-consuming. However, with the emergence of dbt (data build tool), data analysts and enginee...Discussdbt
Adam Stonefoundinblank.hashnode.dev·Apr 18, 2023SQLMesh and virtual data martsI’ve been excited about SQLMesh since it was released to the public a few weeks ago. It’s fantastic to see innovation in the data transformation space and teams boldly testing out novel approaches to managing ever-ballooning data assets in cloud data...Discuss·90 readsSQL
Joey BelleroseforElixir For Data Scienceblog.elixir4datascience.com·Feb 28, 2023Whittling Down Your DataIt is easy to get distracted by the sheer volume of data you will need to wade through. Most datasets include far more columns than you will end up needing for your analysis. A perfect example of this would be an id column. You would rarely want to i...Discuss·86 readsElixir
Joey BelleroseforElixir For Data Scienceblog.elixir4datascience.com·Feb 27, 2023Organizing Your DataMany people live by the adage that "cleanliness is next to Godliness." They find this way of living to be much less stressful. The problem is that Data is similar to the stuff in our lives. It becomes messy once it's out of the box and played with fo...Discuss·122 readsElixir
Joey BelleroseforElixir For Data Scienceblog.elixir4datascience.com·Feb 7, 2023Digging For Golden NuggetsEveryone wants to rest easy knowing that they are making the right decision because their decisions are based on data and facts. The problem is, there is too much data for any one person to consume manually, and the problem is getting worse every day...Discuss·75 readsElixir
Bob Rapierdigitaltransformationcompanies.hashnode.dev·Nov 11, 2022Why digital transformation is important in retail and how to get startedWe cannot ignore the fact that every business has undergone a significant transition in the current business climate. Digital transformation solutions are among the most important aspects. Utilizing cutting-edge technologies and business models to sp...Discuss·94 readsDigital Transformation
Akshita Dixitplastic96.hashnode.dev·Oct 7, 2022Traceability: The Core of Data TransformationData warehousing systems consolidate information from operational data sources into a centralized repository, allowing for analysis and mining of the combined data. During the integration process, source data is often transformed through a series of ...Discuss·1 like·167 readstraceability
Bob Rapierdigitaltransformationcompanies.hashnode.dev·Sep 12, 2022Succeeding at Digital Transformation in today’s worldAlthough there has been much talk, it is still challenging to understand what digital transformation means for existing businesses. Leaders in charge of digital transformation services sometimes feel like they are being pulled in numerous ways due to...DiscussDigital Transformation
