<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Spaakjobrigh on Medium]]></title>
        <description><![CDATA[Stories by Spaakjobrigh on Medium]]></description>
        <link>https://medium.com/@spaakjobrighngoma?source=rss-6101e09627d7------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*HenxZZfunnIZ9yODcu-8DQ.jpeg</url>
            <title>Stories by Spaakjobrigh on Medium</title>
            <link>https://medium.com/@spaakjobrighngoma?source=rss-6101e09627d7------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 07:50:23 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@spaakjobrighngoma/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[  Demystifying AI: How data is shaping our future]]></title>
            <link>https://medium.com/@spaakjobrighngoma/demystifying-ai-how-data-is-shaping-our-future-2fd99d412c55?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/2fd99d412c55</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[technology]]></category>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Sun, 27 Aug 2023 22:18:54 GMT</pubDate>
            <atom:updated>2023-08-27T22:18:54.654Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AMmsayvKFBScEkfguqMzSQ.jpeg" /></figure><h4><strong>Introduction</strong></h4><p>🔍 The artificial intelligence revolution is underway, and its driving force is data. In this post, we’ll explore how data plays a crucial role in the development of AI and how it’s transforming our world.</p><h4><strong>The role of data:</strong></h4><p>📊 Data is the fuel that powers AI systems. Every click, every online interaction, every connected sensor generates valuable data. This data is then used to train machine learning models, enabling machines to make intelligent decisions.</p><h4><strong>A concrete example:</strong></h4><p>🚗 Let’s take the example of autonomous cars. Using data collected by on-board sensors and cameras, these cars learn to recognise road signs, detect pedestrians and navigate complex environments. The richer and more varied the data, the safer and more reliable autonomous cars become.</p><h4><strong>The challenges ahead:</strong></h4><p>🔑 However, there are major challenges related to data and AI, such as data privacy and algorithmic biases. It is essential to ensure that the data used is representative of human diversity and that the decisions made by AI systems are fair.</p><h4>The call to action:</h4><p>🤝 As we continue to shape the future of AI, let’s wake up to the importance of data. Let’s engage in discussions about how to ensure the responsible and ethical use of data for the good of all.</p><h4><strong>Conclusion:</strong></h4><p>💡 Data is the foundation of modern AI. By understanding how they influence our lives, we can contribute to a wiser and more ethical use of AI. Share your thoughts in the comments: how do you see the role of data in the future of AI?</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2fd99d412c55" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Analyze data about accounts to identify key trends and opportunities for sales growth and…]]></title>
            <link>https://medium.com/@spaakjobrighngoma/analyze-data-about-accounts-to-identify-key-trends-and-opportunities-for-sales-growth-and-ebf6105910b6?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/ebf6105910b6</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[sales]]></category>
            <category><![CDATA[on-premise-sales]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Wed, 19 Jul 2023 12:32:59 GMT</pubDate>
            <atom:updated>2023-07-19T12:32:59.547Z</atom:updated>
            <content:encoded><![CDATA[<h3>Analyze data about accounts to identify key trends and opportunities for sales growth and communicate your insights.</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*m_z5ECtjVFxvpsuc51L6zQ.jpeg" /></figure><h4><strong>What On-premise Specialist must know (Important keys)</strong></h4><p>Working as a On-premise specialist requires being an entrepreneurial partner with sales accounts, developing strategies to grows those accounts and your sales together.</p><p>You have to be a proactive problem solver and effictive negotiator and an innovative salesperson.</p><h4><strong>There are two skills you have to demonstrate as a On-Premise-Specialist :</strong></h4><ol><li>Analyzing account data for insights you candrive sales.</li><li>Overcoming objections raised during sales calls.</li><li>Preparing a short PowerPoint to communicate your findings and your insights.</li></ol><h4><strong>On-Premise Sales Process.</strong></h4><p>In companies, you know you’re a field salesperson, you’re a sales specialist, and you help manage a number of key accounts for your team. This is the context! It can vary depending on the type of business.</p><h4><strong>Daily Job for On-Premise-Sales.</strong></h4><p>You will be asked to do some analysis on how your accounts are performing, to identify performing and underperforming accounts. You will also try to contact customers to find out what didn’t work with your products in their company. Why they don’t make sales. They will want you to help them with some sales objections from tricky customers.</p><h4><strong>Somes skills you must have as a On-Premise-Sales Specialist.</strong></h4><ul><li>Data Analysis.</li><li>Data Presentation.</li><li>Communication.</li><li>Strategy.</li><li>Sales.</li><li>Overcoming Objections.</li><li>Account Management.</li></ul><h4><strong>Key Terms using in field.</strong></h4><ul><li><strong><em>An account </em></strong>is a business theu are currently or trying to sell their products (services).</li><li><strong><em>On-Premise </em></strong>sales includes accounts where their products are purchased and consumed on-site.</li><li><strong><em>Off-Premise</em></strong> sales includes accounts where their products are purchased and consumed off-site<strong>.</strong></li></ul><h4><strong>Two essential skills as a On-Premise Sales Specialist.</strong></h4><ol><li>Tracking how your accounts are performing using sales and operational data;</li><li>Communicationg the key insights concisely and clearly to your team members.</li></ol><p>Usually, they could asked you to analyze and present the progress of your accounts to the team. This will involve key steps :</p><ul><li>Prepare your account data.</li><li>Cnduct data analysis and create visual charts.</li><li>Communicate your findings or insights.</li></ul><h4><strong>Conclusion.</strong></h4><p>As an On-Premise Sales Specialist, you will use the above skills and steps to perform most of the tasks in your business. But it will vary depending on our company and the problem you’re trying to solve.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ebf6105910b6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[LIMIT and BETWEEN Clause]]></title>
            <link>https://medium.com/@spaakjobrighngoma/limit-and-between-clause-6ff8bf711a88?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/6ff8bf711a88</guid>
            <category><![CDATA[limits]]></category>
            <category><![CDATA[between-sql]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Mon, 17 Jul 2023 02:25:15 GMT</pubDate>
            <atom:updated>2023-07-17T02:25:15.895Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Adq1T298Ab0dPjz5oHTExQ.jpeg" /></figure><p>The LIMIT clause can restrict the result set of the query to some maximum number of rows. If this clause specifies a value smaller than the number of qualifying rows, the query returns only a subset of the rows that satisfy the selection criteria.</p><h4><strong>Query:</strong></h4><pre>SELECT *<br>FROM Customers<br>ORDER BY CustomerID<br>LIMIT 3;</pre><h4><strong>Result:</strong></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/780/1*QOcTCdO_F2eh3KTDIXfQjQ.png" /></figure><p><strong>Best Practice :</strong> Always use ORDER BY when using LIMIT; otherwise the rows you will get will be unpredictable.</p><h4>Query:</h4><pre>SELECT *<br>FROM Customers<br>ORDER BY CustomerID<br>LIMIT 2,1;</pre><h4><strong>Explanation:</strong></h4><p>When a LIMIT clause contains two numbers, it is interpreted as LIMIT offset,count. So, in this example the query skips two records and returns one.</p><p>Result:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/722/1*GtVncMTxjY2JLQTvLuSnvg.png" /></figure><h3>Section 3.8: SELECT with BETWEEN</h3><p>You can use BETWEEN clause to replace a combination of “greater than equal AND less than equal” conditions.</p><h4><strong>Data :</strong></h4><pre>+----+-----------+<br>| id | username  |<br>+----+-----------+<br>| 1 | admin      |<br>| 2 | root       |<br>| 3 | toor       |<br>| 4 | mysql      |<br>| 5 | thanks     |<br>| 6 | java       |<br>+----+-----------+</pre><h4><strong>Query with operators :</strong></h4><pre>SELECT * FROM stack WHERE id &gt;= 2 and id &lt;= 5;</pre><h4><strong>Similar query with BETWEEN :</strong></h4><pre>SELECT * FROM stack WHERE id BETWEEN 2 and 5;</pre><h4><strong>Result :</strong></h4><pre>+----+-----------+<br>| id | username  |<br>+----+-----------+<br>| 2 | root       |<br>| 3 | toor       |<br>| 4 | mysql      |<br>| 5 | thanks     |<br>+----+-----------+<br>4 rows in set (0.00 sec)</pre><p>Note</p><blockquote>BETWEEN uses &gt;= and &lt;=, not &gt; and &lt;.</blockquote><h4><strong>Using NOT BETWEEN</strong></h4><p>If you want to use the negative you can use <strong>NOT</strong>. For example :</p><pre>SELECT * FROM stack WHERE id NOT BETWEEN 2 and 5;</pre><h4><strong>Result :</strong></h4><pre>+----+-----------+<br>| id | username  |<br>+----+-----------+<br>| 1 | admin      |<br>| 6 | java       |<br>+----+-----------+<br>2 rows in set (0.00 sec)</pre><p>Note</p><blockquote><strong>NOT BETWEEN</strong> uses &gt; and &lt; and not &gt;= and &lt;= That is, WHERE id NOT BETWEEN 2 and 5 is the same asWHERE (id &lt; 2 OR id &gt; 5).</blockquote><p>If you have an index on a column you use in a <strong>BETWEEN</strong> search, MySQL can use that index for a range scan.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6ff8bf711a88" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Exploratory Data Analysis with Medical Charges Dataset]]></title>
            <link>https://medium.com/@spaakjobrighngoma/exploratory-data-analysis-with-medical-charges-dataset-903904235174?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/903904235174</guid>
            <category><![CDATA[exploratory-data-analysis]]></category>
            <category><![CDATA[analysis]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Thu, 06 Jul 2023 18:57:47 GMT</pubDate>
            <atom:updated>2023-07-06T18:57:47.944Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Udo3RUVSm9SiBKhZpZNuqQ.jpeg" /></figure><p>In this dataset, we’re going to explore some of our features to understand the data we have at hand! It’ll just be a quick exploration using some libraries like matplotlib, seaborn, plotly.express to find insights for better understanding before applying ML models to our data.</p><h3>Import librairies</h3><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/3b77e5bf9e234d8c5bae02b96d9d352d/href">https://medium.com/media/3b77e5bf9e234d8c5bae02b96d9d352d/href</a></iframe><h3>Download our dataset.</h3><p>The link of the dataset is here : <a href="https://raw.githubusercontent.com/JovianML/opendatasets/master/data/medical-charges.csv"><em>MedicalCharge</em></a></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b735deffe287e906306d6273ef671745/href">https://medium.com/media/b735deffe287e906306d6273ef671745/href</a></iframe><p># <strong>To display the top 5 rows</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/68d7c3af1c44ea97ff0d8f7a3f61e091/href">https://medium.com/media/68d7c3af1c44ea97ff0d8f7a3f61e091/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/505/1*W9MvA6z4yEkorM6k5Lupeg.png" /></figure><p><strong># To get information about our dataset</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/5282e0b96c27a67efcdc49ff69f08dbc/href">https://medium.com/media/5282e0b96c27a67efcdc49ff69f08dbc/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/355/1*EncDFZe_FM1udYEmJmbLhg.png" /></figure><p><strong># To get the statistical summary of the data</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/3907f1fbc78db88b24e5868d6837454c/href">https://medium.com/media/3907f1fbc78db88b24e5868d6837454c/href</a></iframe><figure><img alt="" src="https://cdn-images-1.medium.com/max/462/1*rAdhB_LJ4c7s0I2w29QayA.png" /></figure><h3>Exploratory Analysis and Visualization.</h3><p>Lets explore the data by visualizing the distribution of each columns of the dataset, and the relationships between “charges” and other columns.</p><p><strong># Import added librairies and fix configuration for our visuals</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/8e98f7cd26ae30991a8e79a08a0d1624/href">https://medium.com/media/8e98f7cd26ae30991a8e79a08a0d1624/href</a></iframe><p><strong># Let’s plot the distribution of Age and Make some interpretations</strong></p><pre>fig = px.histogram(<br>    medical_df,<br>    x=&#39;age&#39;,<br>    marginal=&#39;box&#39;,<br>    nbins=47,<br>    width=800, <br>    height=500,<br>    title = &#39;Distribution of Age&#39;)<br><br>fig.update_layout(bargap=0.1)<br>fig.show()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*WCHGfCraTL_9lNbQY7hoIg.png" /></figure><p>The distribution of Ages is almost uniform in our dataset, with customers between 20–30 (age) at every age, excepts for 18 and 19 which seem to have over twice as many customers as others age.</p><p><strong># Let’s plot the distribution of bmi (body Mass Index) and Make some interpretations.</strong></p><pre>fig = px.histogram(<br>    medical_df,<br>    x=&#39;bmi&#39;,<br>    marginal=&#39;box&#39;,<br>    width=800,<br>    height=500,<br>    color_discrete_sequence=[&#39;red&#39;],<br>    title=&#39;Distribution of BMI (Body Mass Index)&#39;)<br><br>fig.update_layout(bargap=0.1)<br>fig.show()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*zLiCNfDlcgn8O8d4TR45lA.png" /></figure><p>The measurements of body mass index seem to form a normal distribution centererd around the value 30, with a few outliers towards the rights.</p><p><strong># Let’s plot the distribution of charge characteristics with a clear distinction between smokers and non-smokers and make some interpretations.</strong></p><pre>fig = px.histogram(<br>    medical_df,<br>    x=&#39;charges&#39;,<br>    marginal=&#39;box&#39;,<br>    color=&#39;smoker&#39;,<br>    width=800,<br>    height=500,<br>    color_discrete_sequence=px.colors.sequential.Blackbody,<br>    title=&#39;Annuel Medical Charges with smoker&#39;)<br><br>fig.update_layout(bargap=0.1)<br>fig.show()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*58VMoYKJz7pJX0LOKyFYUQ.png" /></figure><p>Most of the customers who have big charges are smokers. Under 10k there are just the non smoker customers that have this king of charge. The note is that non smokers have few annuel medical charge that smokers one due to some accidents and so on.</p><p><strong># Let’s plot the distribution of charge characteristics with a clear distinction between the sexes of the customers and make some interpretations.</strong></p><pre>fig = px.histogram(<br>    medical_df,<br>    x=&#39;charges&#39;,<br>    marginal=&#39;box&#39;,<br>    color=&#39;sex&#39;,<br>    color_discrete_sequence=px.colors.sequential.Agsunset,<br>    width=800,<br>    height=500,<br>    title=&#39;Annuel Medical charges with sex&#39;<br>)<br><br>fig.update_layout(bargap=0.1)<br>fig.show()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*rIN-nG8K96RnhbMY8SPnKQ.png" /></figure><p>The repartition of male and female is almost equals concerning Annuel Medical Charges. Most of them pay between 0–10k.</p><p><strong># Let’s plot the distribution of charge characteristics with a clear distinction between the region of the customers and make some interpretations.</strong></p><pre>fig = px.histogram(<br>    medical_df,<br>    x=&#39;charges&#39;,<br>    marginal=&#39;box&#39;,<br>    color=&#39;region&#39;,<br>    color_discrete_sequence=px.colors.sequential.Turbo_r,<br>    width=800,<br>    height=500,<br>    title=&#39;Annual Medical Charge with regions&#39;<br>)<br><br>fig.update_layout(bargap=0.1)<br>fig.show()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*ycHeT478mBXgkritJ-_Pdw.png" /></figure><p><strong># Let’s plot the distribution of smoker characteristics with a clear distinction between sex of the customers and make some interpretations.</strong></p><pre>px.histogram(<br>    medical_df,<br>    x=&#39;smoker&#39;,<br>    color=&#39;sex&#39;,<br>    width=800,<br>    height=500,<br>    title=&quot;Smoker&quot;<br>)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*7NUL0TSmwrbbiAdbyP_e0g.png" /></figure><p>To sum up, this work has been done to help you get up to speed with exploratory data analysis. Take your own dataset and try to extract some insights and interpretations to help managers make decisions.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=903904235174" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Could Europe’s AI rules harm competition?]]></title>
            <link>https://medium.com/@spaakjobrighngoma/could-europes-ai-rules-harm-competition-493e4a69fbc3?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/493e4a69fbc3</guid>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[ai-risk]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Sat, 01 Jul 2023 21:41:38 GMT</pubDate>
            <atom:updated>2023-07-01T21:41:38.281Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kLGIlsqHy7acSNwa5Tnxyw.jpeg" /></figure><p><a href="https://datanews.levif.be/actualite/innovation/ai-robotique/les-regles-europeennes-en-matiere-dia-pourraient-nuire-a-la-concurrence/">A letter signed by several major business leaders warns that overly strict regulation of AI could harm Europe. It remains to be seen whether this is a legitimate concern or an attempt to avoid regulations that are seen as too restrictive.</a></p><p>In a so-called “open letter” reported by Reuters but not available online, 160 business leaders, including Renault, Meta, Cellnex, Miraki and Berenberg, oppose planned rules for artificial intelligence in Europe. They believe the rules would impose high compliance costs and excessive liability for what their AI produces. They also fear that this would lead to a relocation of activities outside Europe and a decline in investment. It should be noted, however, that only Reuters has had access to the letter and has not yet received comments from the signatories. It is important to step back and remember that technology companies have often used similar threats to influence regulation in the past. There is also a balance to be struck between corporate responsibility and the fight against AI-related abuse.</p><h3>A few thoughts</h3><p>One of the ways in which different companies behave when they are subjected to such mechanisms is to find a counter-offensive to fight back! And guess what? These companies want to move their business outside the European zone!</p><p>Well, I think it’s a pretty clever counter-offensive, following the example of Sam Altman, CEO of OpenAI (ChatGPT), who recently declared that his service would have to leave Europe because of the temporary exclusion of ChatGPT in Italy, justified by the lack of transparency of its algorithms. However, he has now gone back on his word. I think this is a strategy used by companies to put pressure on the public.</p><p>It’s reminiscent of Meta, which threatens once or twice a year to stop offering Facebook, Whatsapp, Instagram or other services in Europe (or in the region where it is challenging the regulations). These are often attempts to scare the public in the hope of getting more lenient legislation. But Meta has never followed through on these threats.</p><p>But I also think that the companies may be right, because if the rules turn out to be too strict, the cost of complying with them will be too high. But also, if the majority of AI activities move out of Europe, it will lead to a drop in investment! This will certainly damage Europe’s competitiveness.</p><h3><strong>What do you think about this situation?</strong></h3><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=493e4a69fbc3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What Is Big Data? Definition, How It Works, and Uses]]></title>
            <link>https://medium.com/@spaakjobrighngoma/what-is-big-data-definition-how-it-works-and-uses-f36ddd8d1bd7?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/f36ddd8d1bd7</guid>
            <category><![CDATA[big-data-analytics]]></category>
            <category><![CDATA[big-data]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Fri, 30 Jun 2023 01:27:45 GMT</pubDate>
            <atom:updated>2023-06-30T01:27:45.419Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*05w7z_jSCnf7CybW2Qe8jw.jpeg" /></figure><h4><strong>What Is Big Data ?</strong></h4><p>Big Data refers to the large, diverse sets of information that grow at ever-increasing rates. It’s is characterized by the 3Vs : <strong>Volume</strong> (huge amount of data), <strong>Variety</strong>(diverse types and formats of data), and <strong>Velocity</strong> (high speed at which data is generated and processed).</p><p>Big Data is often charaterized by its size, but it is also about the challenges of storing, processing, and analyzing such large and diverse datasets to extracts valuable insights and make informed decisions.</p><h4><strong>How Big Data Works ?</strong></h4><p>Big Data works through a series of processes that involve collecting, storing, processing, analyzing, and deriving insights from large and diverse datasets. Let view a simplified overview of how Big Data works.</p><ol><li><strong>Data collection </strong>: Various sources generate massive amount of Data, such as : sensors, social media platforms, websites, mobile devices, and more. This data can include text, images, videos. It’s can be structured data, and unstructured data.</li><li><strong>Data Storage</strong> : Big Data requires specialized storage systems capable of handling large volumes of data. Technologies like distributed files systems (hdfs) or NoSQL databases are commonly used to store and manage the data.</li><li><strong>Data Processing</strong> : Once the data is stored, it needs to be processed. This involves transforming the raw data into a format suitable for analysis. Data processing techniques may include data cleaning, filtering, aggregation, and integration.</li><li><strong>Data Analysis</strong> : Analytical techniques and algorithms are applied to the processed data to identify patterns, trends, and correlations. This stage often involves using tools like machine learning, statistical analysis, and data visualization to gain insights from the data.</li><li><strong>Deriving Insights</strong> : The analyzed data is used to derive actionable insights and make informed decisions. These insights can help businesses optimize operations, improve customer experiences, identify market trends, and develop new products or services.</li><li><strong>Data Security and Privacy</strong> : As Big Data often contains sensitive information, ensuring data security and privacy is crucial. Measures are taken to protect data from unauthorized access and comply with relevant regulations. With the amount of personal data available on individuals today, it is crucial that companies take steps to protect this data;</li></ol><p>It’s important to note that Big Data is a complex field, and there are various technologies and techniques involved in each step of the process. The specific tools and processes used can vary based on the organization’s needs and goals.</p><h4><strong>Uses</strong></h4><p>The analysis of Big Data can provides valuable insights, patterns, and correlations that can help businesses, organizations, and researchers in various fields to make data-driven decisions, improves oprations, understand customers behavior, and develop new products or services.</p><p>Big Data has a wide range of applications across various industries and sectors. Here are some common uses of Big Data:</p><p><strong>Business Analytics</strong>: Big Data is used to analyze customer behavior, market trends, and operational patterns to make data-driven decisions. It helps businesses optimize processes, improve customer experiences, and identify new revenue opportunities.</p><p><strong>Healthcare</strong>: Big Data is employed to analyze large volumes of patient data, electronic health records, and medical research to improve diagnostics, treatment, and disease prevention. It can help in predicting outbreaks, identifying patterns, and developing personalized medicine.</p><p><strong>Finance</strong>: Big Data is utilized for fraud detection, risk analysis, algorithmic trading, and customer analytics in the finance industry. It helps in detecting anomalies, managing risks, and making informed investment decisions.</p><p><strong>Manufacturing</strong>: Big Data is used to optimize production processes, enhance supply chain management, and improve product quality. It can help in predictive maintenance, reducing downtime, and optimizing inventory management.</p><p><strong>Transportation and Logistics</strong>: Big Data is employed for route optimization, demand forecasting, fleet management, and real-time tracking. It helps in improving efficiency, reducing costs, and enhancing customer satisfaction.</p><p><strong>Social Media Analysis</strong>: Big Data is used to analyze social media platforms to understand customer sentiment, preferences, and behavior. It enables businesses to personalize marketing campaigns, improve brand reputation, and enhance customer engagement.</p><p><strong>Scientific Research</strong>: Big Data is employed in various scientific disciplines to analyze large datasets, simulate scenarios, and discover new insights. It helps in fields like genomics, climate research, particle physics, and astronomy.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f36ddd8d1bd7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Chapter 3: SELECT]]></title>
            <link>https://medium.com/@spaakjobrighngoma/chapter-3-select-e9e5ccfe92cd?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/e9e5ccfe92cd</guid>
            <category><![CDATA[select]]></category>
            <category><![CDATA[case]]></category>
            <category><![CDATA[if]]></category>
            <category><![CDATA[alias]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Fri, 23 Jun 2023 23:23:44 GMT</pubDate>
            <atom:updated>2023-06-23T23:23:44.356Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WKXCKlNvNU70aGFIjwxZ_A.jpeg" /></figure><h3>Section 3.5: SELECT with CASE or IF</h3><h4>Introduction</h4><p>In the world of relational databases, SQL (Structured Query Language) plays a crucial role in managing and retrieving data efficiently. One of the fundamental operations in SQL is the SELECT statement, which allows us to fetch data from one or more tables. While SELECT statements are often used for straightforward data retrieval, there are times when we need to introduce conditional logic to our queries. In this article, we will explore how to incorporate conditional expressions using CASE and IF statements within the SELECT statement, enabling us to perform more complex and flexible queries.</p><h4><strong>Syntax and Usage of the CASE Statement</strong></h4><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/35ec53b53ae69cc9173aaf4920d762bf/href">https://medium.com/media/35ec53b53ae69cc9173aaf4920d762bf/href</a></iframe><h4><strong><em>Result</em></strong></h4><pre>+--------------------------------+<br>| name | percentage | Remark     |<br>+--------------------------------+<br>| Isha |          67|       Pass |<br>| Rucha|          28|       Fail |<br>| Het  |          35|       Pass |<br>| Ansh |          92|       Pass |<br>+--------------------------------+</pre><h4><strong>Or with IF</strong></h4><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/970db65d93bb7f00857f1758bf3a247d/href">https://medium.com/media/970db65d93bb7f00857f1758bf3a247d/href</a></iframe><p><strong>N.B :</strong></p><pre>IF(st.percentage &gt;= 35, &#39;Pass&#39;, &#39;Fail&#39;)</pre><blockquote><em>This means : IF st.percentage &gt;= 35 is </em><strong><em>TRUE</em></strong><em> then return ‘Pass’ ELSE return ‘Fail’</em></blockquote><h4><strong>Conclusion</strong></h4><p>In this section, we have explored the power of incorporating conditional logic into SQL queries using the CASE and IF statements within the SELECT statement. Understanding these techniques will empower you to handle complex data scenarios and make your queries more versatile. By utilizing the syntax, examples, and best practices discussed, you can elevate your SQL skills and become more proficient in writing efficient and flexible conditional queries.</p><h3><strong>Section 3.6: SELECT with Alias (AS)</strong></h3><p>SQL SELECT AS is used to assign temporary names to table or column names, or both. This is known in SQL as creating an alias. In this guide we will learn what an alias is and why it is used in SQL.</p><h4><strong>Why use aliases in SQL?</strong></h4><p>1. To reduce query time by temporarily replacing complex &amp; long table and column names with simple &amp; short names.<br>2. This method is also used to protect the column names of databases by not displaying the real column names on the screen.<br>3. Aliases are useful when we are working with JOIN operations or aggregate functions like COUNT, SUM etc.</p><h4><strong>Alias Facts</strong></h4><p>1. An alias only temporarily renames the column or table name, it lasts for the duration of the select query. The name changes are not permanent.<br>2. This technique of creating aliases is generally used by DBAs (database administrators) or database users.<br>3. The temporary table name is also called correlation name.</p><p><strong><em>Query</em></strong></p><pre>SELECT username AS val FROM stack;<br>SELECT username val FROM stack;</pre><p><strong><em>Result</em></strong></p><pre>+-------+<br>| val   |<br>+-------+<br>| admin |<br>| stack |<br>+-------+<br>2 rows in set (0.00 sec)</pre><h4>SQL Alias Example</h4><pre>STUDENT_ID    STUDENT_NAME   STUDENT_AGE     STUDENT_ADDRESS<br>----------    ------------   -----------     ---------------<br>1001           Negan           29             Noida<br>1002           Sirius          28             Delhi<br>1003           Ron             28             Delhi<br>1004           Luna            30             Agra</pre><p>The following SQL statement creates three aliases, the alias ID for the STUDENT_ID column, the alias NAME for the STUDENT_NAME column and the alias ADDRESS for the STUDENT_ADDRESS column.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/0f71c82fb72e7de0587cd7b620bbcf2f/href">https://medium.com/media/0f71c82fb72e7de0587cd7b620bbcf2f/href</a></iframe><p><strong>Result:</strong></p><pre>ID             NAME          ADDRESS<br>-----          ------        -------<br>1001           Negan         Noida<br>1002           Sirius        Delhi<br>1003           Ron           Delhi<br>1004           Luna          Agra</pre><p><strong>Conclusion</strong>: In this article, we have explored the power of aliases in SQL and how they can simplify and enhance the SELECT statement. By utilizing aliases with the “AS” keyword, you can improve the readability of your queries, simplify column selection, and perform advanced operations efficiently. Understanding the syntax, usage, and bes practices of aliases will empower you to write more concise and effective SQL queries.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e9e5ccfe92cd" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Chapter 3: SELECT]]></title>
            <link>https://medium.com/@spaakjobrighngoma/chapter-3-select-79ab9818effe?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/79ab9818effe</guid>
            <category><![CDATA[like]]></category>
            <category><![CDATA[select]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Thu, 22 Jun 2023 10:07:50 GMT</pubDate>
            <atom:updated>2023-06-22T10:07:50.887Z</atom:updated>
            <content:encoded><![CDATA[<h3><strong>Section 3.4: SELECT with LIKE (%)</strong></h3><p>SELECT is used to retrieve rows selected from one or more tables. The examples in this section are implemented for the MySQL database management system.</p><p><strong>Section 3.4: SELECT with LIKE (%)</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/374edafb521773e5514f7887f835106d/href">https://medium.com/media/374edafb521773e5514f7887f835106d/href</a></iframe><p>“adm” anywhere:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/1256f6ef5b941dd882b5cda567037f6d/href">https://medium.com/media/1256f6ef5b941dd882b5cda567037f6d/href</a></iframe><p>Begins with “adm”:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/e73976227d0658a12ea5d43ef5703106/href">https://medium.com/media/e73976227d0658a12ea5d43ef5703106/href</a></iframe><p>Ends with “adm”:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/1a6ddb8bf845097d9f37d8b154441a97/href">https://medium.com/media/1a6ddb8bf845097d9f37d8b154441a97/href</a></iframe><p>Just as the <em>%</em> character in a LIKE clause matches any number of characters, the <em>_</em> character matches just one character. For example,</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/868268da0198069f08851f75feed5720/href">https://medium.com/media/868268da0198069f08851f75feed5720/href</a></iframe><p><strong>Performance Notes</strong> If there is an index on username, then</p><ul><li><strong>LIKE ‘adm’</strong> performs the same as `= ‘adm’</li><li><strong>LIKE ‘adm%</strong> is a “range”, similar to <strong>BETWEEN</strong>..<strong>AND</strong>.. It can make good use of an index on the column.</li><li><strong>LIKE ‘%adm’</strong> (or any variant with a leading wildcard) cannot use any index. Therefore it will be slow. On tables with many rows, it is likely to be so slow it is useless.</li><li><strong>RLIKE (REGEXP)</strong> tends to be slower than <strong>LIKE</strong>, but has more capabilities.While MySQL offers <strong>FULLTEXT</strong> indexing on many types of table and column, those <strong>FULLTEXT</strong> indexes are not used to fulfill queries using <strong>LIKE</strong>.</li></ul><h4><strong>Example for better understing</strong></h4><p>Certainly! Here’s an example of how you can use the LIKE operator with the % wildcard character in a SELECT statement. Let&#39;s say you have a table called customers with a column named name, and you want to retrieve all customers whose names start with the letter &quot;J&quot;.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/d57a4417698fdac024ba0888e37561ff/href">https://medium.com/media/d57a4417698fdac024ba0888e37561ff/href</a></iframe><p>In this example, the LIKE &#39;J%&#39; condition is used to match any name that starts with the letter &quot;J&quot;. The % wildcard character represents any sequence of characters. So, in this case, it will match names like &quot;John&quot;, &quot;Jane&quot;, &quot;Jack&quot;, and so on.</p><p>Here’s another example where you want to retrieve all customers whose names end with the letter “s”:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/a675a963c7f9f2e92992506d931bca58/href">https://medium.com/media/a675a963c7f9f2e92992506d931bca58/href</a></iframe><p>In this case, the LIKE &#39;%s&#39; condition matches any name that ends with the letter &quot;s&quot;. The % wildcard character placed before the letter &quot;s&quot; allows for any characters to occur before it.</p><p>You can also use % at the beginning and end of the pattern to match names that contain a particular substring anywhere within them. For example, to find all customers whose names contain the substring &quot;son&quot;:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/de0e2aa75d76611da3485a65b3267ec0/href">https://medium.com/media/de0e2aa75d76611da3485a65b3267ec0/href</a></iframe><p>In this case, the LIKE &#39;%son%&#39; condition matches any name that contains the substring &quot;son&quot; regardless of its position within the name.</p><p>The LIKE operator with the % wildcard provides a powerful way to perform pattern matching in SQL queries, allowing you to search for data based on flexible criteria.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=79ab9818effe" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Chapter 3: SELECT]]></title>
            <link>https://medium.com/@spaakjobrighngoma/chapter-3-select-243147059dfe?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/243147059dfe</guid>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Tue, 20 Jun 2023 10:54:42 GMT</pubDate>
            <atom:updated>2023-06-20T10:54:42.884Z</atom:updated>
            <content:encoded><![CDATA[<h4>Section 3.3: SELECT by column name</h4><h3>Section 3.3: SELECT by column name</h3><ol><li>We create a stack table with three columns (id, username, password) using CREATE TABLE.</li><li>We then insert the data into our table using INSERT INTO, so that we can query it using the SELECT command.</li><li>We can now query our table by asking it to return one column (id).</li></ol><h4><strong>Example :</strong></h4><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/0ed2f7bee0beb765a325297ad4c0af67/href">https://medium.com/media/0ed2f7bee0beb765a325297ad4c0af67/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=243147059dfe" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Chapter 3: SELECT]]></title>
            <link>https://medium.com/@spaakjobrighngoma/chapter-3-select-6c8abe68fa5a?source=rss-6101e09627d7------2</link>
            <guid isPermaLink="false">https://medium.com/p/6c8abe68fa5a</guid>
            <category><![CDATA[select]]></category>
            <dc:creator><![CDATA[Spaakjobrigh]]></dc:creator>
            <pubDate>Tue, 20 Jun 2023 10:11:53 GMT</pubDate>
            <atom:updated>2023-06-20T10:11:53.245Z</atom:updated>
            <content:encoded><![CDATA[<h4><strong>Section 3.2: SELECT all columns (*)</strong></h4><p>SELECT all columns (*) is used to retrieve all columns from one or more tables.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b9d83d6ce014114bc0be6f6eb9565912/href">https://medium.com/media/b9d83d6ce014114bc0be6f6eb9565912/href</a></iframe><p>You can select all columns from one table in a join by doing :</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/cf243249d6ec7266deb9185300a62fd1/href">https://medium.com/media/cf243249d6ec7266deb9185300a62fd1/href</a></iframe><h4><strong>Pros:</strong></h4><ol><li>When you add/remove columns, you don’t have to make changes where you did use SELECT *</li><li>It’s shorter to write.</li><li>You also see the answers, so can SELECT *-usage ever be justified?</li></ol><h4><strong>Cons:</strong></h4><ol><li>You are returning more data than you need. Say you add a VARBINARY column that contains 200k per row.You only need this data in one place for a single record — using SELECT * you can end up returning 2MB per10 rows that you don’t need.</li><li>Explicit about what data is used.</li><li>Specifying columns means you get an error when a column is removed.</li></ol><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6c8abe68fa5a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>