This week&#8217;s system design refresher: SQL Query Execution Order (Youtube video) Netflix Tech Stack - Databases The 10 Algorithms That Dominate Our World &#8220;Pull&#8221; and &#8220;Push&#8221; Payments ByteByteGo Talent Collective Retool is the fast way to build internal tools (Sponsored)

EP60: Netflix Tech Stack - Databases . The diagram below shows how the pull and push payments work.

ByteByteGo Newsletter

Sign upSign inSign upSign inSamir SaciFollowTowards Data Science--ListenShareSustainable sourcing is the process of integrating social, ethical and environmental performance factors when selecting suppliers.This includes assessing and evaluating suppliers based on sustainability criteria such as health and safety, environmental impacts or labour rights.The aim is to minimize the negative impacts on the environment and maximize the positive social impacts.As a Data Science Manager, can you develop tools to streamline the process of supplier selection?Supply Chain Network design tools automatically select the best suppliers that minimize costs and meet the market demand while respecting constraints defined by your sustainability team.In this article, we will explore how you can use data science in your organization to support the implementation of sustainable sourcing.Let us take the example used in the previous articles about Life Cycle Assessment.You are the Data Science Manager of an international clothing group that has stores all around the world.The company sources garments, bags, and accessories from suppliers located in Asia.Stores are delivered from local warehouses that are directly replenished by suppliers.Can you automatically select suppliers that minimize your costs while respecting environmental and social constraints?The sourcing team has decided to implement sustainable sourcing on the limited scope of T-shirt suppliers.They want to review their supplier selection process to support the company’s sustainability roadmap.However, they are facing several obstaclesTherefore, they request your help deploying a product to monitor suppliers’ KPIs and automate the selection.Let’s see how data analytics can answer this problem.I will use a simple example with a limited range of indicators for this article.We can quickly review them to understand their definition and how to measure them.Carbon emissionsThe primary indicator that will drive your sustainability roadmap is the carbon footprint of the supply chain.This can be measured by calculating the total emissions of greenhouse gases such as carbon dioxide, methane and nitrous oxide.💡 What should we consider?The first two metrics should be collected from the suppliers, but your team can calculate the third one.The formula is quite straightforwardThe data sources areIf you need more information, I have detailed the process in this articletowardsdatascience.comEnergy consumptionAnother indicator is the amount of energy consumed by the supplier to produce and deliver products.It can be expressed in Joules used per production unit (called functional units in the Life Cycle Assessment Methodology).💡 What should we consider?The sourcing team should collect this metric.Water usageAs it becomes a scarce resource, new regulations are pushing companies to redesign their processes for water consumption reduction.With this indicator, you can focus on suppliers that do not affect the local water supply.💡 What should we consider?Waste generationMeasuring the amount of waste generated during production can help identify areas for adopting more sustainable production methods.💡 What should we consider?Social indicatorsThese indicators assess suppliers’ performance in terms of social sustainability.You can conduct your own audits or use third-party assessments.💡 How to Measure it?Your sourcing team assigns a weight to each criterion in the scorecard below.The auditors calculate a score linked to each criterion to represent the supplier’s performance.The total score is a pondered average of the scores that provide a general supplier assessment.The first support you can provide to your sourcing team is to streamline the data collection and storage process using data analytics tools.A data lake can be a central source of unstructured and structured data (databases, excel files, …).You can implement automated pipelines to extract, process and analyze these data to build reports and provide insights.This can lead to the implementation of data products that can be used for reporting and the optimization models I will present in the next section.For more information on the best practices and methodologies to automate this exercise, look at this article about Life Cycle Assessment.towardsdatascience.comWe can use this data to drive decisions now that we have collected information about suppliers and performed audits with scoring.The sourcing team’s main obstacle was the problem’s complexity considering the number of different metrics and suppliers.They use Excel files with limited automation; this restrains their processing capacity.Therefore, the idea is to use advanced analytics to automatically design sourcing and logistics networks to deliver your stores.I will use an example with dummy data to understand how to implement a data-driven methodology to select suppliers considering environmental factors.You want to redefine the Supply Chain Network of your fast fashion retail company for the next five years.You have stores in 5 different markets worldwide (USA, Germany, Japan, India and Brazil).In each market, you can select a supplier to produce your t-shirts and choose to source from abroad.You would like to select the right set of suppliers to minimize the cost of production and delivery considering.Your overseas suppliers are cheaper, but you must pay high freight costs to deliver to your market with higher CO2 emissions for transportation.Moreover, the sustainability team has implemented constraints on maximum environmental impact per T-shirt produced including water usage, CO2 emissions, energy usage and waste generated.The sourcing team needs linear programming support to manage these complex tradeoffs and decide which suppliers to select.Let me illustrate my point with the example below, in which I will gradually add environmental constraints to see the impact on the footprint.If you define the objective function to minimize the costs without additional constraints, you can easily guess that it will maximize the volume produced in India and Brazil.💡 InsightsWhat if we want to add sustainability constraints?As your company implements a sustainability roadmap, you must add additional constraints limiting the environmental impact per T-shirt produced and delivered.Therefore, your procurement team has contacted local suppliers in your predominant markets (USA, Japan).What would be the impact on your sourcing network?We can start by adding constraints on the average energy and water consumption per unit produced.Your suppliers in Germany and Japan heavily invested in modern equipment to reduce the environmental impact of their operations.💡 InsightsWhat if we add CO2 emissions constraints?Transportation accounts for a considerable part of the CO2 footprint of your Supply Chain.Therefore, you would like to reduce the impact of upstream flows by limiting the CO2 emissions of💡 InsightsWith this simple exercise, you can get the potential of these solutions to accelerate the decision-making process by testing several scenarios.If you want to try it yourself, I have deployed this solution in a web application hosted on the VIKTOR platform.You can upload your dataset or use the sample available in the app to test different scenarios.For more details about this solution, have a look at this article published on Towards Data Science.towardsdatascience.comWhen implementing a green transformation, companies face many challenges related to change management and complex decision-making processes.As a data analytics professional, you can support this transformation by facilitating data collection and partially automating decision-making using optimization models.Sourcing teams can easily add constraints in their supplier selection process to follow the guidance of the sustainability team.By showing the financial impact of each scenario, you facilitate the decision-making process by highlighting the balance between sustainability and cost efficiency.These results can trigger strategic discussions to find the right balance between sustainable sourcing and cost reduction.Let’s connect on Linkedin and Twitter; I am a Supply Chain Engineer using data analytics to improve logistics operations and reduce costs.If interested in Data Analytics and Supply Chain, look at my website.samirsaci.com💡 Follow me on Medium for more articles related to 🏭 Supply Chain Analytics, 🌳 Sustainability and 🕜 Productivity.----Towards Data ScienceTop Supply Chain Analytics Writer — Follow my journey using Data Science for Supply Chain Sustainability 🌳 and Productivity ⌛HelpStatusAboutCareersBlogPrivacyTermsText to speechTeams

Data Science for Sustainable Sourcing. The first support you can provide to your sourcing team is to streamline the data collection and storage process using data analytics tools

Towards Data Science - Medium

Data Science for Sustainable Sourcing

Posted on Mar 7                  In today's data-driven world, being able to extract insights from data is a valuable skill. In this article, we'll explore how to perform basic data analysis using Python and SQL. We'll connect to a SQLite database, execute SQL queries, and visualize the results using Python libraries. 📊The database contains information about sales transactions made by a company. Here's what each field represents:The provided schema simulates a basic sales database, commonly used in retail or e-commerce settings. Each transaction (identified by TransactionID) involves the sale of one or more products. For each product sold, the database records the ProductID, ProductName, Quantity sold, PricePerUnit, and the date of the transaction (SalesDate).Purpose:This database schema and the accompanying data were created for the purpose of practicing database management and performing data analysis tasks,it is not real-world data.But it provides a simplified representation of sales transactions, making it suitable for learning SQL queries, data manipulation, and analysis.Note:It's important to note that in a real-world scenario, databases and data structures may be more complex, and additional considerations such as data integrity, normalization, and indexing would be taken into account. However, for learning and practice purposes, this schema serves as a good starting point.First, let's ensure we have the necessary tools installed. We'll need Python, SQLite, and the matplotlib library for data visualization. 💻We'll start by creating a SQLite database and populating it with some sample data. We'll then connect to this database using Python's sqlite3 library. 🔌We'll define a schema for our database containing information about sales transactions. The schema includes fields such as TransactionID, ProductID, ProductName, Quantity, PricePerUnit, and SalesDate. 💼Now that our database is set up, let's perform some basic data analysis tasks using SQL queries. 📊We'll calculate the total sales revenue for each product by multiplying the Quantity with PricePerUnit and summing it up. 💰We can visualize the results using Python libraries such as matplotlib. 📊We'll find the top 3 best-selling products based on the total quantity sold. 🏆outputWe'll calculate the average price per unit for all products. 📈outputIn this article, we've demonstrated how to connect to a SQLite database using Python, execute SQL queries, and perform basic data analysis tasks. By leveraging Python libraries such as sqlite3 and matplotlib, we can efficiently analyze data and gain valuable insights. 🚀  Templates let you quickly answer FAQs or store snippets for re-use.        Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.      Hide child comments as well                  Confirm              For further actions, you may consider blocking this person and/or reporting abuse              Namee - Mar 4                          Thiago da Silva Adriano - Mar 3                          Pranjal Sharma - Mar 2                          eaca89 - Mar 3                  DEV Community — A constructive and inclusive social network for software developers. With you every step of your journey.    Built on Forem — the open source software that powers DEV and other inclusive communities.Made with love and Ruby on Rails. DEV Community © 2016 - 2024.          We're a place where coders share, stay up-to-date and grow their careers.

Python Database Connectivity and SQL Basics for EDA 🐍📊. We'll connect to a SQLite database, execute SQL queries, and visualize the results using Python libraries.

DEV Community

Python Database Connectivity and SQL Basics for EDA 🐍📊

While many entrepreneurs are currently facing the harsh reality of a VC funding crunch, Qonto isn’t one of them. The Paris-based business banking startup still has hundreds of millions of cash on hand. And it is using an undisclosed portion of its cash reserve to acquire Regate, an accounting and financial automation platform.Qonto originally started with online business accounts with debit cards specifically tailored for small and medium businesses. Over time, the company expanded its product offering to include invoicing tools, features to manage expenses and plenty of integrations with the fintech ecosystem to facilitate bookkeeping, payment reconciliation, etc.And that modern take on business banking has worked surprisingly well as more than 450,000 companies now have a Qonto account. While France remains Qonto’s main market, the company also acquired its German competitor Penta — and moved Penta’s customers to its own platform — and is also available in Italy and Spain.In 2022, near the peak of the funding frenzy of 2021 and 2022, the company raised a massive €486 million Series D funding round (that’s $529 million at today’s exchange rate). Now, Qonto wants to deliver on its original vision of building an all-in-one finance solution for small and medium businesses.As part of this vision, Qonto is acquiring Regate, a French startup we covered after it raised a €20 million Series A round ($22 million at today’s exchange rate). Regate is an accounting automation software-as-a-service startup.It integrates directly with existing accounting software platforms like Sage, Cegid and ACD so that Regate can focus on financial automation. Regate customers can easily track incoming payments, schedule payments to suppliers, sort through invoices and receipts, and even access their bank accounts from Regate’s interface.Since 2020, Regate managed to attract 10,000 clients — 6,000 of them are already Qonto customers. The company also sells its product to accounting firms directly with 500 firms using Regate.It’s a different go-to-market strategy and product philosophy compared to Pennylane, a newly minted French unicorn that wants to replace legacy accounting software entirely. Pennylane itself now also provides business bank accounts and moving into Qonto’s main product territory.“We have grown our revenue by 3x in 2023,” Regate co-founder Laura Pallier told TechCrunch. But when Qonto approached Regate, they decided to sell the company to reach the next level. “We had a rather intense discussion on the subject . . . We’re convinced that the cockpit approach — with a tool that works for both SMEs and their accountants — makes a lot more sense than multiple products.”With today’s acquisition, Regate’s team of 100 employees will all join Qonto’s current 1,400-people staff under a new business unit focused on financial tools for accountants. At first, there will be new integrations between both platforms.After a while, Regate will be integrated in Qonto directly to improve several accounting automation features of Qonto, such as invoicing, accounts payables, accounts receivables, etc. As for accounting firms, they’ll also act as a new sales channel for Qonto.“The idea is that these two platforms will gradually become one. But it’s going to be a gradual process, and we’ll always be very careful to maintain the customer experience for both corporate clients and accounting firms,” Pallier said.While Regate’s acquisition is only the second acquisition in Qonto’s history, it’s most likely not the last one. In part because its executives are happy with how Penta’s integration went, but also because of its current opportunity window.“We happen to have a planetary alignment. It would be a professional mistake not to look [at potential acquisitions]. We’re not the best at everything. So we should also stay humble and work with experts in their respective fields,” Qonto co-founder and president Steve Anavi told TechCrunch at Mobile World Congress in Barcelona last week.“We have an in-house team that looks at opportunities. In the best-case scenario, we sign a deal. But even in the worst-case scenario, we can become partners because we’ve learned to know each other a little bit better over a very short process,” he added.Qonto finds itself in a different position from Payfit, another French unicorn (or former unicorn) that provides a software-as-a-service tool focused on payroll. Yesterday, Les Échos reported that Payfit plans to lay off 14% of the company, or 110 employees.Why are things looking better for Qonto? “We have a healthy business model. It means that when we acquire a customer, after a few months it’s a profitable customer. This is mainly because they pay — we don’t have any free offering. So, compared to a lot of fintech companies or startups in general that have a free offering and then try to upsell customers, we haven’t made that choice,” Qonto co-founder and CEO Alexandre Prot told TechCrunch.“The second element is that we raised a very large amount of money two years ago. And we were a bit lucky because the timing was right,” he added. Finally, rising interest rates have also created a new revenue stream for the company. And given Qonto’s scale, the company is handling very large sums of money on behalf of its customers.For these reasons, Qonto has plenty of cash to spend on acquisitions. As many fintech startups are struggling to raise a new funding round, Qonto could become a consolidator in the space. And we might be at the beginning of this consolidation phase.

Flush with cash, French fintech unicorn Qonto acquires Regate | TechCrunch. While France remains Qonto’s main market, the company also acquired its German competitor Penta — and moved Penta’s customers to its own platform — and is also available in Italy and Spain

TechCrunch

Flush with cash, French fintech unicorn Qonto acquires Regate

Posted on Mar 7                  In the fast-paced realm of technology, where innovation reigns supreme and proficiency is paramount, cloud certifications have emerged as indispensable assets for professionals seeking to navigate and excel within the digital landscape. These certifications, offered by leading providers such as Amazon Web Services (AWS), not only validate expertise but also serve as catalysts for empowerment, career advancement, and community building within the tech industry.Empowering Individuals:Cloud certifications stand as formidable symbols of empowerment, bestowing upon individuals the validation and recognition of their proficiency in cloud technologies. By earning these certifications, professionals fortify their confidence, assert their authority, and unlock new avenues for personal and professional growth.Career Advancement:In the competitive arena of technology, where opportunities abound and talent is revered, cloud certifications serve as beacons guiding professionals toward career advancement and prosperity. With each certification attained, individuals elevate their credentials, expand their skill sets, and position themselves as sought-after assets in an ever-evolving job market.Industry Recognition:The attainment of cloud certifications signifies more than just personal achievement—it signals a commitment to excellence and a dedication to staying abreast of industry trends and best practices. As such, these certifications command respect and admiration within the tech community, affirming the holder's credibility and expertise in cloud computing.Driving Continuous Learning:Cloud certifications instill a culture of perpetual learning and growth, compelling professionals to remain vigilant in their pursuit of knowledge and proficiency. Through ongoing education and recertification requirements, individuals are propelled on an unending journey of discovery, ensuring their relevance and adaptability in an ever-changing technological landscape.Stay Relevant in a Dynamic Industry:In an era characterized by rapid technological innovation and disruption, cloud certifications serve as vital tools for professionals seeking to stay relevant and influential in their respective fields. By equipping individuals with the latest skills and industry knowledge, these certifications enable them to navigate the complexities of a dynamic industry with confidence and agility.Promoting Diversity and Inclusion:Cloud certifications transcend barriers of race, gender, and socioeconomic status, serving as catalysts for promoting diversity and inclusion within the tech community. By providing equitable access to certification programs, individuals from all backgrounds are allowed to showcase their talents and contribute to the vibrant tapestry of the industry.Elevating Standards of Excellence:Cloud certifications uphold the highest standards of excellence, setting a precedent for professionalism and proficiency within the tech sphere. By adhering to rigorous certification requirements, professionals not only distinguish themselves as paragons of excellence but also inspire others to strive for greatness in their endeavors.Enhanced Credibility and Trust:Cloud certifications imbue professionals with a sense of credibility and trust, endowing them with the integrity and authority necessary to garner trust from employers, clients, and colleagues alike. This trust forms the bedrock of professional relationships, fostering collaboration, innovation, and mutual respect within the tech community.Access to Exclusive Resources and Communities:Cloud certifications grant individuals access to a wealth of exclusive resources and communities, fostering collaboration, camaraderie, and mutual support within the tech sphere. From specialized training materials to vibrant online communities, certified professionals benefit from a supportive ecosystem that nurtures their growth, fosters collaboration, and propels them toward success.In conclusion, cloud certifications have become indispensable tools for professionals seeking to thrive in the ever-evolving landscape of technology. By empowering individuals, advancing careers, fostering excellence, and promoting diversity and inclusion, these certifications play a vital role in shaping the future of the tech industry and empowering a new generation of skilled professionals. As we continue to embrace the transformative power of cloud certifications, let us strive to build a community that celebrates excellence, fosters collaboration, and drives innovation to new heights.Templates let you quickly answer FAQs or store snippets for re-use.        Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.      Hide child comments as well                  Confirm              For further actions, you may consider blocking this person and/or reporting abuse              Lucas Maltempi Monfardine - Jan 16                          Julia Furst Morgado - Feb 5                          Mohammad Faisal - Feb 5                          Mohan Majhi - Jan 26                  DEV Community — A constructive and inclusive social network for software developers. With you every step of your journey.    Built on Forem — the open source software that powers DEV and other inclusive communities.Made with love and Ruby on Rails. DEV Community © 2016 - 2024.          We're a place where coders share, stay up-to-date and grow their careers.

Advancing Careers and Fostering Excellence: The Impact of Cloud Certifications. Cloud certifications grant individuals access to a wealth of exclusive resources and communities, fostering collaboration, camaraderie, and mutual support within the tech sphere.

Advancing Careers and Fostering Excellence: The Impact of Cloud Certifications

Posted on Mar 7                  Understanding discrete mathematics is crucial to acquiring in-depth knowledge in various areas of Computer Science, such as algorithms, data structures, computing theory, and cryptography. Unlike Continuous Mathematics, which deals with infinite and continuous structures, discrete mathematics focuses on the study of finite and discrete processes.At the heart of discrete mathematics lies mathematical logic, which investigates the principles of valid reasoning. Using symbols and precise rules, mathematical logic allows the systematic and rigorous representation and manipulation of propositions (statements). This approach provides a precise and detailed analysis of systems, constituting a fundamental basis for several fields of Computer Science.In this article we will present basic concepts of mathematical logic, such as propositions, connectives and truth tables.A proposition is a statement that can be either true or false. For example:Note that not every sentence is a proposition:Simple propositions, which cannot be further decomposed, are known as atomic propositions, while compound propositions are constructed from these atomic elements linked by connectives. The truth value of a compound proposition is determined by the truth values assigned to its individual atomic propositions.A conjunction is a compound proposition in the form p ∧ q, where p and q are propositions. The truth value of this proposition is true only if both propositions are true.In programming, we use generally use the && symbol to control the program flow with conjuntions.The truth table of the connective ∧ is:A truth table is a representation that shows the different combinations of logical values for each component of a proposition. In a truth table, the columns represent the simple component propositions and a compound proposition, while the rows represent the various possible combinations of true and false for these propositions. We can use the truth table to summarize how a connective behaves.A disjunction is a compound proposition in the form p ∨ q, where p and q are propositions. The truth value of this proposition is true if at least one of the propositions is true.The truth table of the connective ∨ is:In programming, we use generally use the || symbol.This disjunction is called exclusive in the sense that it allows only one proposition to be true so that it results in the true logical value. We use the ⊕ operator to generate this disjunction. See the truth table:This is also called eXclusive OR (XOR).The negation of a proposition generates a new proposition with the opposite logical value to the original. In this way, if the proposition is true, the new one will be false and vice versa. We have the ¬ operator (we generally use ! in programming). See the truth table for this operator:In languages like JavaScript we use double negation to convert a truthy value into a boolean: !!p A proposition of the form p → q is called an implication or conditional, where p is a proposition called an antecedent and q is a proposition called a consequent. This proposition will be false only if the antecedent is true but the consequent is not. We can see this operator in the truth table:Programming languages have a conditional structure similar to this, called if.A proposition in the form p ↔ q is called biconditional or equivalence, also used as "if and only if". It is true only if both propositions have the same logical value. See the truth table:Through propositions, connectives, and truth tables, we have only scratched the surface of mathematical logic, which enables precise reasoning and system analysis. A solid understanding of mathematical logic not only enhances your analytical skills in programming but also helps in problem-solving and bug fixing effectively.Templates let you quickly answer FAQs or store snippets for re-use.        Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.      Hide child comments as well                  Confirm              For further actions, you may consider blocking this person and/or reporting abuse              Dwayne Crooks - Aug 7 '19                          Anna Buianova - Jul 30 '19                          Juneau Lim - Jul 13 '19                          Contra - Jul 12 '19                  DEV Community — A constructive and inclusive social network for software developers. With you every step of your journey.    Built on Forem — the open source software that powers DEV and other inclusive communities.Made with love and Ruby on Rails. DEV Community © 2016 - 2024.          We're a place where coders share, stay up-to-date and grow their careers.

Discrete Maths for Devs: An brief introduction to Mathematical Logic. A disjunction is a compound proposition in the form p ∨ q, where p and q are propositions.