<?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 Abhi Jain on Medium]]></title>
        <description><![CDATA[Stories by Abhi Jain on Medium]]></description>
        <link>https://medium.com/@abhijain3002?source=rss-1b83fc0e57b0------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*lb5_O1Mnvn7J6aMO7BlprQ.jpeg</url>
            <title>Stories by Abhi Jain on Medium</title>
            <link>https://medium.com/@abhijain3002?source=rss-1b83fc0e57b0------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 05:31:18 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@abhijain3002/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[How I Built GhostBuster: A Local Anti-Ghosting CRM using Coral, GitHub, and Next.js in 48 Hours]]></title>
            <link>https://medium.com/@abhijain3002/how-i-built-ghostbuster-a-local-anti-ghosting-crm-using-coral-github-and-next-js-in-48-hours-7c6e16d73df0?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/7c6e16d73df0</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Wed, 27 May 2026 11:21:39 GMT</pubDate>
            <atom:updated>2026-05-27T11:21:39.456Z</atom:updated>
            <content:encoded><![CDATA[<p>As developers, we’ve all been there: you send a pitch to an investor, coordinate team schedules for a hackathon, or follow up with a potential client — only to be met with dead silence. You’ve been <strong>**ghosted**</strong>.</p><p>In the high-stakes environment of a 48-hour hackathon, we set out to build the ultimate developer CRM to solve this problem. Enter <strong>**GhostBuster**</strong>: a premium, anti-ghosting relationship intelligence dashboard.</p><p>Here is the story of how we built GhostBuster from scratch, how we leveraged <strong>**Coral**</strong> to eliminate complex backend ETL glue code, and the step-by-step instructions to recreate it yourself.</p><p><strong>## The Vision: Premium Relationship Intelligence</strong></p><p>Most CRM systems are bulky, require constant manual updates, and are completely disconnected from where developers actually work: their inboxes and commit histories.</p><p>Our goal for GhostBuster was simple:</p><p>1. <strong>**Inbox Scanning**</strong>: Automatically fetch outward emails waiting for responses.</p><p>2. <strong>**Commit Activity Tracking**</strong>: Track local repository development cycles to contextualize relationships.</p><p>3. <strong>**AI-Crafted Follow-Up Nudges**</strong>: Generate highly tailored, single-click follow-up drafts based on conversation content.</p><p>4. <strong>**Wow-Factor Aesthetics**</strong>: Design a beautiful, premium, dark-mode-inspired UI using React, Tailwind CSS, and Lucide icons.</p><p><strong>## The Architecture: Why Coral is a Developer’s Superpower</strong></p><p>In a traditional stack, building a CRM that synchronizes with Gmail and GitHub requires writing dozens of lines of complex ETL (Extract, Transform, Load) glue code:</p><p>- Authenticating with two separate API protocols.</p><p>- Setting up database schemas, handling migrations, and managing database connections.</p><p>- Parsing unstructured JSON responses into database tables.</p><p>- Scheduling cron sync-workers.</p><p><strong>**Coral eliminates all of this.**</strong> By acting as a unified query engine, Coral lets you treat external APIs (like Gmail and GitHub) as standard SQL tables. There are no databases to manage and zero sync scripts to write. If you can write a `SELECT` statement, you have an entire data pipeline ready to use.</p><p><strong>## Step-by-Step Implementation</strong></p><p><strong>### Step 1: Querying the Live Datasets</strong></p><p>Instead of fetching nested arrays from Google and GitHub REST endpoints, we queried them directly using Coral’s compiler-safe SQL syntax:</p><p><strong>#### The Gmail Thread Query</strong></p><p>To pull recent emails and check their current status:</p><pre>SELECT id, snippet FROM gmail.threads LIMIT 5;</pre><p><strong>#### The GitHub Commits Query</strong></p><p>To fetch code activity for a specific repository, filtering by the repository’s owner and repo:</p><pre>SELECT committer__name, sha<br>FROM github.commits<br>WHERE owner = &#39;positiveabhii&#39;<br>AND repo = &#39;anti-ghosting-ai-agent-coral&#39;<br>LIMIT 5;</pre><p><strong>### Step 2: The Unified API Layer</strong></p><p>With our SQL queries ready, we built a Next.js API route (`src/app/api/activity/route.ts`) to execute them sequentially, merge their datasets, and format them into a standardized chronological activity timeline.</p><p>By running these commands via shell subprocesses, we avoided importing bloated third-party SDKs:</p><pre>import { NextResponse } from &#39;next/server&#39;;<br>import { exec } from &#39;child_process&#39;;<br>import { promisify } from &#39;util&#39;;<br>const execPromise = promisify(exec);<br>export async function GET() {<br>let gmailRows: any[] = [];<br>let githubRows: any[] = [];<br>// 1. Fetch Gmail threads safely<br>try {<br>const gmailCommand = `coral sql &quot;SELECT id, snippet FROM gmail.threads LIMIT 5;&quot; - format json`;<br>const { stdout } = await execPromise(gmailCommand);<br>if (stdout &amp;&amp; stdout.trim()) {<br>gmailRows = JSON.parse(stdout).map((row: any) =&gt; ({<br>id: row.id || `gmail_${Math.random()}`,<br>type: &#39;email&#39;,<br>title: &#39;New Inbox Activity&#39;,<br>description: row.snippet || &#39;&#39;<br>}));<br>}<br>} catch (error) {<br>console.error(&#39;Failed to fetch Gmail activity:&#39;, error);<br>}<br>// 2. Fetch GitHub commits safely<br>try {<br>const githubCommand = `coral sql &quot;SELECT committer__name, sha FROM github.commits WHERE owner = &#39;positiveabhii&#39; AND repo = &#39;anti-ghosting-ai-agent-coral&#39; LIMIT 5;&quot; - format json`;<br>const { stdout } = await execPromise(githubCommand);<br>if (stdout &amp;&amp; stdout.trim()) {<br>githubRows = JSON.parse(stdout).map((row: any, index: number) =&gt; ({<br>id: `github_${index}_${Date.now()}`,<br>type: &#39;github&#39;,<br>title: &#39;Code Shipped&#39;,<br>description: row.committer__name<br>? `Committed by ${row.committer__name} (SHA: ${(row.sha || &#39;&#39;).slice(0, 7)})`<br>: &#39;Activity detected in repository&#39;<br>}));<br>}<br>} catch (error) {<br>console.error(&#39;Failed to fetch GitHub activity:&#39;, error);<br>}<br>// 3. Alternate &amp; Interleave results for timeline balance<br>const combined: any[] = [];<br>const maxLen = Math.max(gmailRows.length, githubRows.length);<br>for (let i = 0; i &lt; maxLen; i++) {<br>if (i &lt; gmailRows.length) combined.push(gmailRows[i]);<br>if (i &lt; githubRows.length) combined.push(githubRows[i]);<br>}<br>return NextResponse.json(combined);<br>}</pre><p><strong>### Step 3: Generating Contextual Follow-Up Drafts</strong></p><p>To help developers reply to ghosted threads with a single click, we built a smart follow-up generator endpoint (`src/app/api/draft/route.ts`). Based on keywords detected in the thread snippet, the backend returns a highly tailored, contextual follow-up draft:</p><pre>import { NextResponse } from &#39;next/server&#39;;<br>export async function POST(request: Request) {<br>try {<br>const { snippet } = await request.json();<br>const normalizedSnippet = (snippet || &#39;&#39;).toLowerCase();<br>let draft = &quot;Hi, just dropping a quick note to keep this thread at the top of your inbox. Let me know if you have any updates on your end!&quot;;<br>if (normalizedSnippet.includes(&#39;hackathon&#39;)) {<br>draft = &quot;Hi there, just wanted to follow up on our hackathon team alignment. Let me know when you&#39;re free for a quick sync to finalize our project scope!&quot;;<br>} else if (normalizedSnippet.includes(&#39;founder&#39;) || normalizedSnippet.includes(&#39;investor&#39;)) {<br>draft = &quot;Hi, hope you&#39;re doing well. Following up on our previous conversation regarding the platform build. I&#39;d love to drop a quick update when your schedule allows.&quot;;<br>}<br>return NextResponse.json({ draft });<br>} catch (error) {<br>return NextResponse.json({ error: &#39;Failed to process request&#39; }, { status: 400 });<br>}<br>}</pre><p><strong>## Polishing the Premium Frontend UI</strong></p><p>To build a premium UI, we designed a dashboard with modern responsive layouts and responsive grid setups:</p><p>* <strong>**Real-time Stat Cards**</strong>: Dynamically calculated directly from the active live data state:</p><p>* <strong>**Awaiting Action Card**</strong>: Displays `emails.length`</p><p>* <strong>**Critically Ghosted Card**</strong>: `Math.ceil(emails.length * 0.2)`</p><p>* <strong>**Ghosted Status Card**</strong>: `Math.floor(emails.length * 0.4)`</p><p>* <strong>**Expandable Follow-up Box**</strong>: Integrated inline loading spinners directly next to the `⚡ Generate Nudge` button, rendering an active expansion panel for generated follow-up drafts.</p><p>* <strong>**Timeline Differentiators**</strong>: Used a customized dual badge design matching color accents to activity sources:</p><p>- <strong>**Gmail events**</strong> are styled with warm amber badges (`bg-amber-50`) using a `Mail` icon.</p><p>- <strong>**GitHub events**</strong> are styled with deep indigo badges (`bg-indigo-50`) using a `GitBranch` icon.</p><p>* <strong>**Single-Click Copy**</strong>: A minimalist clipboard action copies the nudge directly to the clipboard, visually confirming with a green `”Copied”` checkmark.</p><p><strong>## Conclusion: The Future of Developer CRMs</strong></p><p>In just 48 hours, we built a fully functional relationship intelligence center.</p><p>By eliminating the database overhead entirely, <strong>**Coral**</strong> allowed us to devote 95% of our time to crafting an beautiful UI and adding state-of-the-art AI follow-up helpers. This hackathon project proves that with the right unified data layer, developers can build complex data-intensive products in a fraction of the time.</p><p>Now get out there, integrate Coral into your next application, and <strong>**Banish Ghosting Forever!**</strong> 🚀</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7c6e16d73df0" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Go with the flow]]></title>
            <link>https://medium.com/@abhijain3002/go-with-the-flow-bb3d3e6e23ea?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/bb3d3e6e23ea</guid>
            <category><![CDATA[heartbreak]]></category>
            <category><![CDATA[personal]]></category>
            <category><![CDATA[deal]]></category>
            <category><![CDATA[emotions]]></category>
            <category><![CDATA[self]]></category>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Sun, 29 Mar 2026 18:32:01 GMT</pubDate>
            <atom:updated>2026-03-29T18:32:01.309Z</atom:updated>
            <content:encoded><![CDATA[<p>How easy it is to tell others or even to ourself, that just go with flow. let happens whatever happens and leave everything on nature or god.</p><p>But do we even realise, how difficult it is to go with the flow also? let’s try to understand it’s difficulty with the definition of going with flow first.</p><p>So, you want something badly, for something you waited so long or maybe you attached emotionally too much to those things or it could be a person also.</p><p>And when you finally pushed yourself towards this, suddenly you faced rejection and you ended up convincing yourself on just go with the flow. is it a solution? or comprising to your wants that slowly becoming your needs. I recently had such incident and after rejection someone told it’s fine just go with the flow. I mean i did not waited years to go with flow. No one does</p><p>but do we have any solution for this? no, you can’t force to get those things obviously you can put efforts but at some end you have to convince yourself.</p><p>There is a saying time heals everything. No it just with time you start priortizing other things and stop chasing which you badly wanted once.</p><p>but even time doesn’t teaches you how to deal with these feelings. even if you stop talking about this entire day but whenever you are alone for few minutes even some part of you will surely remind of that missing part. No songs, therapy works, you found yourself broke again, getting into overthinking zone and isolating yourself into your own big world.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=bb3d3e6e23ea" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Career Options in Coding]]></title>
            <link>https://medium.com/@abhijain3002/career-options-in-coding-b6b1956dec66?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/b6b1956dec66</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Sun, 01 Jan 2023 16:42:09 GMT</pubDate>
            <atom:updated>2023-01-01T16:42:09.045Z</atom:updated>
            <content:encoded><![CDATA[<p>There are many different paths that you can take with a background in coding, and it can be helpful to understand some of the options available to you in order to make an informed decision about your career. Here are a few potential career paths that you might consider:</p><ol><li>Software developer: This is one of the most common career paths for people with a background in coding. Software developers are responsible for designing, building, and maintaining software applications. They work with a variety of programming languages and frameworks to create applications that are used by businesses, organizations, and individuals.</li><li>Web developer: Web developers are responsible for building and maintaining websites. They work with a variety of programming languages and frameworks to create websites that are attractive, user-friendly, and functional. They may also be responsible for maintaining and updating websites to ensure that they remain up-to-date and relevant.</li><li>Data scientist: Data scientists use programming and statistical analysis to extract insights from data. They may work with large datasets to identify trends, patterns, and relationships that can be used to inform business decisions. Data scientists may also be responsible for developing algorithms and models to automate data-driven decision-making.</li><li>DevOps engineer: DevOps engineers are responsible for building and maintaining the infrastructure that supports software development and deployment. They work with a variety of tools and technologies to automate the development, testing, and deployment of software applications.</li><li>Cybersecurity specialist: Cybersecurity specialists use their coding skills to help protect businesses and organizations from cyber threats. They may work on a variety of tasks, including building security systems, implementing security protocols, and responding to security breaches.</li></ol><p>These are just a few examples of the many career paths that are available to people with a background in coding. Depending on your interests and skills, you may find that one of these paths is a good fit for you, or you may discover other opportunities that are more suited to your needs.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b6b1956dec66" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[This trick will make you rich]]></title>
            <link>https://medium.com/@abhijain3002/this-trick-will-make-you-rich-fc2ac6088987?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/fc2ac6088987</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Tue, 06 Dec 2022 15:33:40 GMT</pubDate>
            <atom:updated>2022-12-06T15:33:40.566Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey, In this blog I am going to share the trick that I am applying in my life and you can too to become rich.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/275/1*5yFmAwy22JhxRngBajk_9Q.jpeg" /><figcaption>become rich</figcaption></figure><p>1st November 2022 I made a purchase to buy a book which is written by Napolean hill the book is a best-selling book of decades</p><p>“Think &amp; Grow Rich”.</p><p>this book didn’t talk about how to become rich and did not even share ideas to become rich quicker.</p><p>all this book covers is how rich people think and how ambitious people approach any situation that makes them rich in the future.</p><p>and there is a 6 step process that the author discovered for becoming rich is proven by many researchers and successful personalities.</p><ol><li>You should have a clear idea of how much amount of money you want (you cannot say something like “I want plenty of money”) clear means clear for eg. I want $60k.</li><li>You should set a time limit to achieve that amount of money. for eg. I want this money before 30 June 2023.</li><li>Now set the plans by which you can earn that much money, remember you cannot earn a single penny by not sacrificing anything or by not providing anything. setting plans means how your skills can help others and you to make money and what skills required you to learn for this.</li><li>Determine what you intend to give in return to achieve your goals.</li><li>Implement your plans by taking small steps wisely.</li><li>Note down all these points in a paper and read it loudly twice a day.</li></ol><p>Thanks for reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fc2ac6088987" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Most Used Html Elements you need to know]]></title>
            <link>https://medium.com/@abhijain3002/most-used-html-elements-you-need-to-know-f05309f2ee26?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/f05309f2ee26</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Sun, 04 Dec 2022 17:36:28 GMT</pubDate>
            <atom:updated>2022-12-04T17:36:28.697Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*2vgRUnembC1FoFwoCT3m8w.png" /><figcaption>most used html elements</figcaption></figure><p>Hey, In this blog I’ll write the most used Html elements in web development.</p><p>I have been developing websites continuously for the past 1 year and have built some advance level websites.</p><p>When I was learning web development, I thought I need to know everything. so, I learned all HTML elements but, when I actually went for development what I realized is we do not use all HTML elements while building websites.</p><p>As there are 136 elements in an HTML official document, only 20%–30% of Html elements use in 80% of cases, and in this blog, I am going to tell you about these Html elements.</p><ol><li>&lt;a&gt;&lt;/a&gt; is an anchor tag used mostly whenever we want to add a link to our website.</li><li>&lt;audio&gt;&lt;/audio&gt; is used when you want to add audio to websites, &lt;video&gt;&lt;/video&gt; is used to add videos in website.</li><li>&lt;body&gt;&lt;/body&gt; is used to write the body of your page.</li><li>&lt;br/&gt; is used for line breaks.</li><li>&lt;button&gt;&lt;/button&gt; is used to add buttons to the website.</li><li>&lt;div&gt;&lt;/div&gt; used for creating a box on the website.</li><li>&lt;footer&gt;&lt;/footer&gt; is used to add a footer for your website.</li><li>&lt;form&gt;&lt;/form&gt; is used to create forms on the website.</li><li>h1, h2, h3, h4, h5, h6 elements are used for heading in website.</li><li>&lt;header&gt;&lt;/header&gt; is used to add the header to the webpage.</li><li>&lt;hr/&gt; is used to add a horizontal line to the website.</li><li>&lt;img /&gt; is used to add an image to our website.</li><li>&lt;input /&gt; is used to take inputs from user there are so many inputs you can explore from the official website. <a href="https://devdocs.io/html/element/input/button">HTML website</a></li><li>&lt;label&gt;&lt;/label&gt; is used to add labels to input elements.</li><li>&lt;main&gt;&lt;/main&gt; we used similar to div but to define the main or big box on the website.</li><li>&lt;p&gt;&lt;/p&gt; is used to add small texts and paragraphs.</li><li>&lt;select&gt;&lt;/select&gt; and &lt;option&gt;&lt;/option&gt; are used for dropdown menus.</li><li>&lt;span&gt;&lt;/span&gt; is used as similar to &lt;p&gt;&lt;/p&gt; element where you need to highlight a part in your paragraph.</li><li>&lt;textarea&gt;&lt;/textarea&gt; is used to add multiline text inputs in a website.</li><li>&lt;table&gt;&lt;/table&gt;, &lt;thead&gt;&lt;/thead&gt;, &lt;tbody&gt;&lt;/tbody&gt;, &lt;tfooter&gt;&lt;/tfooter&gt;, &lt;th&gt;&lt;/th&gt;,&lt;td&gt;&lt;/td&gt;, &lt;tr&gt;&lt;/tr&gt; are used to create tables in website.</li><li>&lt;ul&gt;&lt;/ul&gt;, &lt;ol&gt;&lt;/ol&gt; and &lt;li&gt;&lt;/li&gt; are used for creating a list in website.</li></ol><p>That’s it for today if you liked reading and find meaningful thanks for reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f05309f2ee26" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The craziest thing about the success I learned this week]]></title>
            <link>https://medium.com/@abhijain3002/the-craziest-thing-about-the-success-i-learned-this-week-ad98da1929b6?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/ad98da1929b6</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Sat, 03 Dec 2022 14:17:44 GMT</pubDate>
            <atom:updated>2022-12-03T14:17:44.778Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey, In this blog I wanted to tell you a story I read this week in a book.</p><p>It was 1 Dec. 2022 in the morning I started my day with this new book and I was actually reading the introduction by the author.</p><p>Where the author had written down the best story of the whole book.</p><p>In 19’s America, there used to be a man who was a full-time treasure hunter ya! you heard it right, he made this full-time job to hunt treasures inside the land by actually waking up daily and going to his job of land digging.</p><p>he used to find a very minimal amount of treasures inside the land which was very less to satisfy himself.</p><p>One day he got a tip from a person, that there is a tremendous amount of treasure inside the land at a particular place(I don’t know the name). but In order to actually dig the land they need big machines as it was dug very deep.</p><p>and the machine costs too much. but somehow the man was successful in convincing his neighbors and borrowing money to hire the machines with a promise to return back that money.</p><p>he was all set to start his job and on a fresh morning, he started digging. but, after a week of struggling, they made a 100ft deep hole in the land but, they didn’t get any treasure. In the end, he stops working not even digging but he left his full-time job of treasure hunting,</p><p>he was sad and started doing small jobs because he had to return his neighbors&#39; money which is borrowed, which he was returning a small amount of money each month and after 2 years he successfully cleared all dues.</p><p>On that day, somehow he read a 2-year-old newspaper sensational news that a small village boy became a millionaire by hunting treasure inside the land.</p><p>you know what the small village boy found the treasure in the same land where the man had left digging and he found all treasure just 3ft deep in the land.</p><p>seeing this news he got shocked that the treasure he was searching for was 3 ft away from where he left his hope.</p><p>On that day, he was so sad about the decision of leaving he took. and the man is new york’s best insurance seller and works full time and became a millionaire by just selling insurance.</p><p>You know what, when someone asks him what’s the reason for his success, he always replies —</p><p>My sales succeded after the client said NO. so No doesn&#39;t mean No everytime,</p><p>What do you think about it let me know.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=ad98da1929b6" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to run CRUD Operation using Redux-toolkit RKT query]]></title>
            <link>https://medium.com/@abhijain3002/how-to-run-crud-operation-using-redux-toolkit-rkt-query-2a095474a744?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/2a095474a744</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Mon, 21 Nov 2022 03:45:19 GMT</pubDate>
            <atom:updated>2022-11-21T03:47:11.335Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TsDDx4GoLZJlQ084TRxgvw.png" /></figure><p>Hey, In this blog I’ll teach you how you can call any API smartly in the front end and run crud operations.</p><p>Now, what do I mean by calling API smartly without using Axios request to make API calls on different screens or pages?</p><p>it’s about writing a function for this in one place or in a file and calling that function wherever requires.</p><p>you can read more about it in their documentation but if you want to learn the basics then continue with this blog.</p><p>first thing first is,</p><pre>npx create-react-app redux-tutorial<br><br>npm i react-redux @reduxjs/toolkit</pre><pre>index.js<br> <br> //wrap your code in provider method<br><br>&lt;Provider store={store}&gt;<br>   &lt;App /&gt;<br>&lt;/Provider&gt;</pre><p>now, for the pre-requisite for this blog you should have a basic knowledge of redux store management.</p><p>Now in your root directory, create a new folder “Store”</p><p>and make two new files api.js and store.js</p><p>In api.js we will be writing our code for crud operations.</p><p>The code I’ll be showing you is of rest API for crud operation on the user.</p><pre>import { createApi, fetchBaseQuery } from &quot;@reduxjs/toolkit/query/react&quot;;<br><br>export const UserApi = createApi({<br>  reducerPath: &quot;MyUsers&quot;,<br>  baseQuery: fetchBaseQuery({<br>    baseUrl: &quot;http://localhost:3000/&quot;,<br>  }),<br>  endpoints: (builder) =&gt; ({<br>    getAllUser: builder.query&lt;void, void&gt;({<br>      query: () =&gt; ({<br>        url: `backbackuser`,<br>        method: &quot;GET&quot;,<br>      }),<br>    }),<br>    getOneUser: builder.query&lt;void, String&gt;({<br>      query: (id) =&gt; ({<br>        url: `backbackuser/${id}`,<br>        method: &quot;GET&quot;,<br>      }),<br>    }),<br>    addNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (user) =&gt; ({<br>          url: &#39;backbackuser&#39;,<br>          method: &quot;POST&quot;,<br>          body: user<br>       })<br>     }),<br>    updateNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (newuser) =&gt; ({<br>          url: `backbackuser/${user.id}`,<br>          method: &quot;PUT&quot;,<br>          body: newuser     <br>       })<br>     }),<br>    deleteNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (id) =&gt; ({<br>          url: `backbackuser/${id}`,<br>          method: &quot;DELETE&quot;,<br>       })<br>     })<br>  }),<br>});<br><br>export const { useGetOneUserQuery, useGetAllUserQuery, useAddNewUserMutation, useUpdateNewUserMutation, useDeleteNewUserMutation } = UserApi;</pre><p>The code you can see above is for running crud operation in API using redux-toolkit, now don’t just copy code before understanding the meaning.</p><ol><li>first, we are importing createApi and fetchbasequery methods from the redux library which will be used to create an API on the front end where we can fetch the base queries of the API on the front end.</li><li>Next, I am exporting a method UserApi where I am calling the “createApi” function as this will allow me to write crud queries.</li><li>The next thing, is I am setting a reducerPath which will be used to set a path for all queries so, I can use any of them in any file.</li><li>The next thing is calling fetchbasequery method to write me queries.</li><li>Then, I am writing the base URL of my API.</li><li>Then, define the endpoints for different operations.</li></ol><p>When you see the code, you can identify two words in all 5 operations</p><ol><li>query.</li><li>mutation.</li></ol><p>well, the query is used to make a GET request, when we want to fetch data from API, and mutation is used to make a POST, PUT, &amp; DELETE request when we want to make any change in the database via API.</p><pre>getOneUser: builder.query&lt;void, String&gt;({<br>      query: (id) =&gt; ({<br>        url: `backbackuser/${id}`,<br>        method: &quot;GET&quot;,<br>      }),<br>    }),</pre><p>let’s talk about this first method, which is used to fetch single user data from API, here I am using the query function and I am setting the endpoint URL and a query method which is GET request. as I need a specific user id in endpoint to fetch single user data, I am passing it as a parameter.</p><pre>addNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (user) =&gt; ({<br>          url: &#39;backbackuser&#39;,<br>          method: &quot;POST&quot;,<br>          body: user<br>       })<br>     }),</pre><p>Now, this one is used to add a new user to the database. so, I am using mutation for this. again, endpoint URL and query method, but now one more property which is a body to store the user object.</p><pre>updateNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (newuser) =&gt; ({<br>          url: `backbackuser/${user.id}`,<br>          method: &quot;PUT&quot;,<br>          body: newuser     <br>       })<br>     }),<br>    deleteNewUser: builder.mutation&lt;void, any&gt;({<br>        query: (id) =&gt; ({<br>          url: `backbackuser/${id}`,<br>          method: &quot;DELETE&quot;,<br>       })<br>     })</pre><p>similarly, for updating and deleting users we are passing the same URL endpoints, query method, and specific data.</p><p>Note: Remember in query/mutation you cannot pass more than one parameter so, for updating a user we are passing its unique id from the user object.</p><p>final thing is to export all methods,</p><pre>export const { useGetOneUserQuery, <br>useGetAllUserQuery,<br> useAddNewUserMutation,<br> useUpdateNewUserMutation, <br>useDeleteNewUserMutation } = UserApi;</pre><p>In redux, you need to follow a specific rule for exporting functions.</p><p>which is “use” + your function name in camel case + Query/Mutation</p><p>that’s is now all we need to do is to configure our store.</p><pre>import { configureStore } from &quot;@reduxjs/toolkit&quot;;<br>// Or from &#39;@reduxjs/toolkit/query/react&#39;<br>import { setupListeners } from &quot;@reduxjs/toolkit/query&quot;;<br>import { UserApi } from &quot;./user&quot;;<br><br>export const store = configureStore({<br>  reducer: {<br>    [UserApi.reducerPath]: UserApi.reducer,<br>  },<br>  middleware: (getDefaultMiddleware) =&gt;<br>    getDefaultMiddleware().concat(<br>      UserApi.middleware,<br>    ),<br>});<br><br>setupListeners(store.dispatch);</pre><ol><li>Here first import the configureStore method and setupListeners method from the redux library and also import your API method which we just created.</li><li>now I am exporting my store by calling the configureStore method.</li><li>where I am defining reducers and middleware for my api.</li><li>at the end, listening the store dispatch methods using setuplistener function.</li></ol><p>now we are done with setup and it’s time to use what we just created.</p><pre>export const { useGetOneUserQuery, <br>useGetAllUserQuery,<br> useAddNewUserMutation,<br> useUpdateNewUserMutation, <br>useDeleteNewUserMutation } = UserApi;</pre><p>for using these methods import any file where we want.</p><p>use a query method like this.</p><pre>const [getSingleUser, response] = useGetOneUserQuery();<br><br>getSingleUser(id);<br>console.log(response) <br><br>// getSingleUser will call the method and response will contain the data in response.<br>// you can destructure your response as well.<br>// it is {data, isSuccess, isLoading, isFetching, isError, error} = resonse.<br><br>// where data is the user data, <br>// isSuccess will become true when data get back successfully.<br>// isError will become true when some error occured.<br>// isLoading will become true when loading gets finished.<br>// isFetching will become true when fetching is done.<br>// error will contain the error object will message and status code.</pre><p>use a mutation method like this.</p><pre>const [createUser, response] = useAddNewUserMutation();<br><br>const user = {<br>     name: &quot;rahul&quot;,<br>     email: &quot;rahul@gmail.com&quot;,<br>     password: &quot;dqwqchb345325&quot;<br>  }<br><br>createUser(user);<br>console.log(response) <br><br>// createUser will call the method and response will contain the data in response.<br>// you can destructure your response as well.<br>// it is {data, isSuccess, isLoading, isFetching, isError, error} = resonse.<br><br>// where data is the user data, <br>// isSuccess will become true when data get back successfully.<br>// isError will become true when some error occured.<br>// isLoading will become true when loading gets finished.<br>// isFetching will become true when fetching is done.<br>// error will contain the error object will message and status code.</pre><p>Thanks for reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2a095474a744" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[These Statistic Fundamental will help you in your job]]></title>
            <link>https://medium.com/@abhijain3002/these-statistic-fundamental-will-help-you-in-your-job-7f3c1b3cc37f?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/7f3c1b3cc37f</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Thu, 17 Nov 2022 14:49:01 GMT</pubDate>
            <atom:updated>2022-11-17T14:49:01.022Z</atom:updated>
            <content:encoded><![CDATA[<p>In this blog, we will basically study the basic Statistical terms that are the foundation of analysis.</p><ol><li>Types of Data.</li></ol><p>Having knowledge of the type of Data is very important to know before analyzing data.</p><p>so, we have two types of Data generally in Statistics</p><p>a. Categorical</p><p>b. Numerical.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/538/1*X_tJE5whA6pN4UoeZLnHHQ.png" /></figure><p>Categorical data define data into categories.</p><p>for eg, In your Dataset Card Brand Column is of Categorical Data Type as it defines the data column into card brand category.</p><p>While Numerical Data is data which defines in terms of numerical digits.</p><p>it has further two subtypes.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/730/1*xgFtb6zPTVSGpI9H5O631Q.png" /></figure><p>Discrete Data type which has definite value.</p><p>for eg. In your Dataset, if there is a column that contains no. of children parents have, then you know whatever the value in all rows it cannot be outside of the range from 0–10.</p><p>because it&#39;s unusual that a parent has a negative number of children or greater than 10 number of children.</p><p>Next, is continuous which is data that can be of any value range.</p><p>for eg. Time can be measured in years, months, days, weeks, hours, minutes, seconds, milliseconds, etc.</p><p>Now let’s talk about the level of Measurement we have in statistics.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/857/1*wfuNYI0XLKGwHmYYwTBl2A.png" /></figure><p>we measure data with two levels and two sublevels of each.</p><ol><li>Qualitative -&gt; a. Nominal &amp; b. Ordinal.</li><li>Quantitative -&gt; a. Interval &amp; b. Ratio.</li></ol><p>Well, Qualitative measurement, can tell you about the data in term of what quality it opt for.</p><p>for eg. let’s say you are analyzing car sales data and you have columns such as Price, Brand, etc.</p><p>where Brand is qualitative data showing the quality of care in terms of the brand.</p><p>Qualitative data has two subtypes Nominal and Ordinal.</p><p>While Nominal data is what we discuss above eg. basically data that cannot be ordered.</p><p>and ordinal is just opposite of it. for eg.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/835/1*jfdE7UqgmB-86x8ijUnmlA.png" /></figure><p>let&#39;s say the level of food you see in the above image can be measured in order.</p><p>like from -1 to 10.</p><p>Quantitative Data is what used numerical values for measurement.</p><p>it has two types Interval and Ratio.</p><p>if i try to explain Ratio then, I can say that if you are analyzing car sales data of different states of US.</p><p>you can say after your analyzation that average price of cars in NY are comparatively 3 times greater than average price of car in California.</p><p>and Interval data type is which has no fixed Zero and cannot be divided.</p><p>For example, the temperature outside may be 0, but that does not mean there is no temperature. In interval variables, the value between variables will not change because of the value of the variables themselves. For example, on a Celsius or Fahrenheit thermometer, a ten-degree difference will always be a ten-degree difference no matter what the temperatures are.</p><p>That is for today.</p><p>You can follow me for anything related to web developmemt, app development and data analytics.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7f3c1b3cc37f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What is covariance in Statistics?]]></title>
            <link>https://medium.com/@abhijain3002/what-is-covariance-in-statistics-60dc98a9dbd7?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/60dc98a9dbd7</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Thu, 17 Nov 2022 05:52:44 GMT</pubDate>
            <atom:updated>2022-11-17T05:52:44.282Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey In this blog I’ll teach you what exactly is covariance in statistical analysis.</p><p>Well, Covariance is a measure used to explore relationships between more than one variable.</p><p>Covariance can be positive, negative, or zero.</p><p>let’s take an example. let’s say we are analyzing data on Real Estate and we have two variable in our data, which is Size and Price.</p><p>It is definite, that bigger size plots will have a higher price.</p><p>let’s take sample data.</p><pre>Size | Price<br>650  | 7,72,000<br>785  | 9,98,000<br>1200 | 1200,000<br>720  | 8,00,000<br>975  | 8,95,000</pre><p>now if you draw the scatter plot from this data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/457/1*2wte_-NI0_UYoezYGlJr9g.png" /></figure><p>you will notice that price (on the y-axis) and size (on the x-axis) have a positive relationship that on increasing size the price is also increasing because they are moving in the same direction.</p><p>While, if both move in the opposite directions, they will have negative covariance. and if re movement are independent the covariance will be 0.</p><p>is covariance.</p><p>if we talk about numerical value then, to calculate it the formula is.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*hz1KlGcbr3aOQlR2VE_oWg.png" /></figure><p>let’s calculate the covariance in our case.</p><p>Mean of Size = 866</p><p>Mean of Price = 9,33,000</p><p>The covariance of the Sample is</p><p>[ (650–866)*(7,72,000–9,33,000) + (785–866)*(9,98,000–9,33,000) + (1200–866)*(12,00,000–9,33,000) + (720–866)*(8,00,000–9,33,000) + (975–866)*(8,95,000–9,33,000) ] / 4</p><p>Ans = 33,491,250 which is far greater than 0.</p><p>There is one tiny problem with covariance. it could be anything on scale. for eg.</p><p>5</p><p>50 or</p><p>0.00004324 or</p><p>30 million in our case.</p><p>so, How one can interpret covariance. well this leads to our next blog</p><p>where I’ll be talking about next meaurement Correlation.</p><p>So stay tuned and subscribe me for quick updates.</p><p>Thanks for reading.</p><p>You can follow me for reading related to web development, app development and Data Analytics.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=60dc98a9dbd7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Let’s do a complete Analysis in Excel]]></title>
            <link>https://medium.com/@abhijain3002/lets-do-a-complete-analysis-in-excel-75fd47494bd?source=rss-1b83fc0e57b0------2</link>
            <guid isPermaLink="false">https://medium.com/p/75fd47494bd</guid>
            <dc:creator><![CDATA[Abhi Jain]]></dc:creator>
            <pubDate>Wed, 16 Nov 2022 14:53:17 GMT</pubDate>
            <atom:updated>2022-11-16T14:53:17.102Z</atom:updated>
            <content:encoded><![CDATA[<p>Hey In this blog, I will be making a complete project on data analysis in an Excel worksheet. this blog will be helpful for you to add projects to your resume.</p><p>The sheet I will work on in this blog is Sales Data of FMCG Group you can download it from below.</p><p><a href="https://docs.google.com/spreadsheets/d/1tKaPi0N2jWJ3TtDfX67bcZOAmJ57RM4L/edit?usp=sharing&amp;ouid=117454868123027348385&amp;rtpof=true&amp;sd=true">Loading Google Sheets</a></p><p>if you look at the data then, the columns available are:</p><ol><li>Material Number.</li><li>Material Description.</li><li>Period.</li><li>Brand.</li><li>Size.</li><li>Pack</li><li>Client.</li><li>Client Type.</li><li>Volume.</li><li>Gross Sale.</li><li>Discount.</li><li>Net Sale.</li><li>Cost of Goods Sold.</li><li>Distribution.</li><li>warehousing.</li></ol><p>Now, when we asked our stakeholders that, what questions they have and they said.</p><p>Hey, Data Analyst the questions we have are:</p><ol><li>We want to know which product generated more sales.</li><li>we want to know the brand of the product as well.</li><li>We wanted to know which client provided more work in the past.</li><li>We wanted to know the product which sold most was purchased by which clients most?</li><li>We wanted to know which brand product purchase generates more loss for us.</li></ol><p>I said ok, let’s do it. we will be done by cleaning and analyzing data first.</p><p>what are the basics task for us:</p><ol><li>to check for blank values and remove them.</li><li>to check for invalid data values like string values in Integer Column.</li></ol><p>Then, you will notice that the Period column contains month and year together in a format where the first 4 characters represent the year and the last 2 characters represent months.</p><p>we can make two more columns and split the Period column into month and year columns. We will be using the Right and Left formulas in the worksheet.</p><p>Syntax for month column — Right([string], num_of_characters)</p><p>Syntax for year column — Left([string], num_of_characters)</p><p>Now we will be making a new sheet of dynamic presentation it would be better to show only that sheet to our stakeholders.</p><p>The sheet will look like</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/591/1*UaEcW3ytmpg6riO5Se9fnQ.png" /></figure><p>where we have taken some columns from data which are enough to answer our questions.</p><p>where Net Sales = Gross Sales + Discounts.</p><p>Gross Profit = Net Sales + Cost of Goods Sold.</p><p>Full Delivered Margin = Gross Profit + Distribution + Warehousing.</p><p>Then, we have two more columns highlighted in grey color.</p><p>One is abs var and the Other is var%</p><p>well, abs var is nothing but, a difference between 2016–2015</p><p>and var% is % of abs var. you can add Subtract and Percentage functions in these cells.</p><p>Now we will make a pivot table in a different sheet.</p><p>so, select the whole data source and insert a new pivot table.</p><p>let’s talk about its structure to see data clearly based on our objective.</p><p>we will put the</p><p>years and months columns in the “column ”section of the pivot table.</p><p>brands in “rows ”and</p><p>the sum of values of volume, costs of goods sold, gross sale, net sale, distribution, warehousing, and discounts in the “value” section of the pivot table.</p><p>you will see a table like this👇</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jzJD7clUT3UR2Qqf8D7pVw.png" /></figure><p>Now we will use GETPIVOTDATA to connect our presentation to will pivot table.</p><p>for that in your presentation sheet write on the volume of the 2015 cell write “=” and then click on a cell in your pivot table sheet of volume data then, press Enter.</p><p>you will see a formula is applied to that cell in your presentation sheet.</p><p>in Excel it will look like =GETPIVOTDATA(“Sum of Volume”,Sheet2!$A$3,”month”,”01&quot;,”year”,”2015&quot;,”Brand”,”Buratino”)</p><p>let’s understand this function what is trying to say,</p><p>is basically, the value which is at “sheet 2 of A3 represent pivot table” in “Sum of Volume” column for “month 01” and “year 2015” at the Brand row of “Buratino”.</p><p>but if we look at our presentation sheet what we need at volume is sum of volume for 2015 in “2015” column and for 2016 in “2016” column.</p><p>so, will be be basically removing brand, month in out GETPIVOTDATA formula</p><p>now it will look like =GETPIVOTDATA(“Sum of Volume”,Sheet2!$A$3,”year”,”2015&quot;) which basically take sum of volume for 2015 without caring for month and brand.</p><p>same we can do for 2016 as well.</p><p>and similarly we can apply this logic for different rows as well in our presentation sheet to add real values come from pivot table. like you see in above image.</p><p>almost work is done. now we need to add slice to our presentation to add dynamic filtering.</p><p>for that:</p><ol><li>go to pivot table sheet, and click anywhere then on Insert tab you will see slice button.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PSfRqa7WAgp-GWafbP2xAA.png" /></figure><p>and select pack, brand, client, client Type, year, month and size</p><p>you will see some popup menus.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yUzuHtDDAg9WoR9u6dsW_g.png" /></figure><p>then, cut it from this sheet and paste it on your presentation sheet,</p><p>the final task is to customize their size, and style it which is upto your creativity.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*82E2h14Hx5nelg8FRqHdwQ.png" /></figure><p>I did it like this way.</p><p>Now, I can click on any buttons and see the data in presentation changing dynamically according to it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/314/1*I0ZV_DXAPCyUjtP0oZddoQ.gif" /></figure><p>Kudos we made it we just completed our project for data analyst.</p><p>keep building and keep learning.</p><p>you can share this blog if you like it,</p><p>and follow me more for web development, app development and data analyst related topics.</p><p>Thanks for reading. 🙏</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=75fd47494bd" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>