<?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 Abhilash Marichi on Medium]]></title>
        <description><![CDATA[Stories by Abhilash Marichi on Medium]]></description>
        <link>https://medium.com/@abhimarichi?source=rss-5b2ae02cb491------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*Ui3DIRcF4gXXh8AnOq3wgA@2x.jpeg</url>
            <title>Stories by Abhilash Marichi on Medium</title>
            <link>https://medium.com/@abhimarichi?source=rss-5b2ae02cb491------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 15:10:58 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@abhimarichi/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[What is Data Profiling?]]></title>
            <link>https://abhimarichi.medium.com/what-is-data-profiling-34bb1cda64c7?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/34bb1cda64c7</guid>
            <category><![CDATA[data-profiling]]></category>
            <category><![CDATA[data-integration]]></category>
            <category><![CDATA[data-warehouse]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[profiling]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 27 Feb 2022 04:02:27 GMT</pubDate>
            <atom:updated>2022-02-27T04:02:27.075Z</atom:updated>
            <content:encoded><![CDATA[<p>In this post, I am going to explain what is data profiling? with simple examples. I hope it would be of some help to you.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*eH-QVXz-tc_6e9OvM0yeSg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@ihasdslr?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Vitaly Vlasov</a> from <a href="https://www.pexels.com/photo/person-pointing-numeric-print-1342460/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><h4><strong>Definition</strong></h4><p>Data Profiling is the process of understanding the data, its characteristics and quality.</p><h4><strong>How to do it?</strong></h4><p>First and foremost before starting the data profiling process we need to finalize the sources that are going to be used in the project. Usually, this would be based on requirements at the target/data warehouse or in the Business Intelligence Report.</p><p>Now each of the tables in the source must be profiled. Prioritize your tables in each source based on the criticality or usage and start profiling each one of them.</p><p>Data Profiling Reports usually captures the following —</p><p><strong><em>At Column Level,</em></strong></p><p><strong>Statistics</strong></p><ul><li>Minimum</li><li>Maximum</li><li>Mean</li><li>Mode</li><li>Percentile</li><li>Standard Deviation</li><li>Frequency — How many times a value repeats</li><li>Variation</li><li>Sum</li></ul><p><strong>Metadata</strong></p><ul><li>Data Type</li><li>Length</li><li>Uniqueness / Duplicates</li><li>Occurrence of Null values</li><li>Typical String Patterns</li></ul><p><strong><em>At Table Level,</em></strong></p><ul><li>Primary key Analysis</li><li>Foreign Key Analysis</li><li>Referential Integrity Analysis</li></ul><p><strong>Let’s look into a sample Data Profiling Report from IBM Infosphere Information Analyzer.</strong></p><p>The below report shows columns (address, au_firstname) length analysis in the table (authors)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*jY9RDCN39LVzDAFngr6u5g.png" /><figcaption>Sample Column Inferences Analysis Report</figcaption></figure><p>The below report shows the columns (CarrId, CarrName) Nullability Analysis in the table (Carrier).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*hOLCeV6jQgFjcGiK8AMocg.png" /><figcaption>Sample Nullability Difference Report</figcaption></figure><p>There are many tools that could be used to perform the Data Profiling or you can simply write SQLs and perform the analysis if the source is a database. If you have heterogeneous sources including Excel Files, Text Files, etc. then I recommend using a tool that is efficient and it could help you to speed up the process of Data Profiling.</p><p><strong>When to do Data Profiling?</strong></p><p>Always perform one round of data profiling before designing the data model for the Data Warehouse because it could change your understanding of the data.</p><p>Also, data profiling is not one time process but a continuous process, the developers must profile the data and understand the nature of it before starting to code the ETLs, by understanding data a developer can figure out the anomalies and resolve it early and also could find the inconsistencies in data and perform required transformations to standardize them.</p><p><strong>Conclusion</strong></p><p>Data Profiling is the first and critical piece of any Data Integration, Data Warehousing, or Data Migration project. Ensure to always understand your data with various Data Profiling methods before using it. It would save you a lot of time, effort, and money. It increases the trust in data among the business decision-makers and helps them to make the right and effective decisions.</p><p>— — — — — — — — — — — — — — — — — — — — — — — — — — — — — —</p><p><em>I hope in this short blog post you got a little bit of understanding and got to know the importance of Data Profiling.</em></p><p><em>Let me know if this helped you by clapping or by dropping a comment below.</em></p><p><em>Take care, stay safe and meet you in the next one. Bye!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=34bb1cda64c7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Lineage — Simple explanation]]></title>
            <link>https://abhimarichi.medium.com/data-lineage-simple-explanation-b263543d34c9?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/b263543d34c9</guid>
            <category><![CDATA[data-warehouse]]></category>
            <category><![CDATA[data-pipeline]]></category>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-lineage]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 20 Feb 2022 04:02:46 GMT</pubDate>
            <atom:updated>2022-02-20T04:02:46.535Z</atom:updated>
            <content:encoded><![CDATA[<h3>Data Lineage — Simple explanation</h3><p>If you are new to the data world and heard people talking about Data Lineage and wondering what it is then in this blog post, I am trying to explain what is Data Lineage and where it is used and how it helps.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Xhv-D5_aEG9PbbB6P8X__A.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@alljos?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">the happiest face</a> from <a href="https://www.pexels.com/photo/telescope-in-front-of-body-of-water-1136815/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p><strong>Definition</strong></p><p>Data Lineage is</p><ul><li>where data begins,</li><li>what happens to it over time,</li><li>where it moves over time,</li><li>and where it ends up.</li></ul><p>Let me explain it to you with an example —</p><p>Assume that there is a chain of 10 stores and there is a Business Intelligence report that shows the total number of sales across all the stores in a day.</p><p>Now we total sales in the sum of sales across all the stores.</p><p><em>total sales = Total Sales in store 1 + Total Sales in-store 2+ …. + Total sales in-store 10.</em></p><p>In the real world, there could be a data warehouse that captures all the sales information for each day in a Fact table called Sales_Fact.</p><p>So Sales_Fact will have data stored in the below format</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/518/1*d5da0unGboVkRRhbVbFv_g.png" /><figcaption>Sales Fact Example</figcaption></figure><p>The sum of all total_sale_price would be <strong>1,840</strong> which will be shown in the BI report.</p><p>So from where do these data land in Sales_fact? It could be from 10 different staging tables assuming one stage table per store.</p><p>And how these stage tables are loaded? It is from the OLTP Database that is used by each of these stores.</p><p>Well, we just found the lineage of total_sales data.</p><p>It would be depicted by the below picture. It can go much deeper and it would include all the transformation that has happened on the data etc. But for simplicity&#39;s sake, I am showing only the flow.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*kZgXVjCfbe1xYMvrrEuo4w.png" /><figcaption>Data Lineage</figcaption></figure><p><strong>Why is it needed?</strong></p><p>Commonly data lineage would be needed whenever there is a change in the source system or if there are any changes required at any stage of data we will be able to track where exactly it is going to affect.</p><p>Using data lineage, testers and QAs can actually find where exactly the data needs to be tested and where only regression testing is required.</p><p>It helps in auditing and compliance analysis of the system to ensure that the data has not been tampered with.</p><p><strong>Conclusion</strong></p><p>Some projects tend to ignore the tools that are necessary for capturing the data lineage while building a data warehouse and usually rely on the ETL developers heavily and usually, this is an overhead for the developers. Using a tool that could provide the data lineage for the business needs will save time and effort. It will also increase the speed of debugging process.</p><p><em>I hope in this short blog post, I have tried to explain in simple terms what data lineage is and how it helps.</em></p><p><em>If you are using any tool for the Data Lineage process in your project do let me know in the comment.</em></p><p><em>Take care, stay safe and meet you in the next one.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b263543d34c9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Integration Explained]]></title>
            <link>https://abhimarichi.medium.com/data-integration-explained-c1b14bdeeb42?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/c1b14bdeeb42</guid>
            <category><![CDATA[data]]></category>
            <category><![CDATA[integration-explained]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-integration]]></category>
            <category><![CDATA[etl]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 13 Feb 2022 07:03:02 GMT</pubDate>
            <atom:updated>2022-02-13T07:03:02.527Z</atom:updated>
            <content:encoded><![CDATA[<p>You may have heard the term Data Integration being thrown around by your Engineers and if you are wondering what exactly it is? then let me try to explain it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IEO9A3P9De7vqWZltQctsw.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@oleg-magni?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Oleg Magni</a> from <a href="https://www.pexels.com/photo/gray-metal-cubes-decorative-1005644/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p><strong>Definition</strong></p><p>In simple terms, combining data from different sources into a single unified place is called Data Integration.</p><p><strong>What does it actually mean?</strong></p><p>In today’s world, an organization may store data in multiple ways. There may be one system storing data in Oracle Database and there might be another team of sales guys using Salesforce CRM to manage clients and there may be one department that only uses Excel Sheets to manage their data.</p><p>If this is the situation of an organization then if there is a need to integrate data from all the departments, it’s a troublesome task because each of them is using different software and their structures may be different.</p><p>Now you bring in the <strong>Data Integration Process </strong>to combine the data from Oracle Database, Salesforce Application, and Excel Sheets to one unified MySQL Database.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*XKAFjlf4mPty0TNYqbr5Ig.png" /><figcaption>Example of Data Integration</figcaption></figure><p>Usually, an ETL tool is used to perform the process of Data Integration. If you are wondering <a href="https://abhimarichi.medium.com/what-is-etl-a-quick-easy-example-33a7a434b8e7">what is ETL? A quick and easy explanation is here</a>.</p><p><strong>Source to Target Mapping</strong></p><p>In any Data Integration project, the backbone is Source to Target Mapping Document. To create this document one should understand the different sources functionally and technically and should design the target columns and tables as per the business needs.</p><p>It has to capture the data cleansing and transformation requirements clearly. The usual structure of the document is shown in the below example —</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*T_yT5jtvmeoMYqcSztk99A.png" /><figcaption>Simple Example of a mapping document</figcaption></figure><p>You should add any relevant fields required in the document that might help the developers. You can also decide whether to split the document based on the Sources or based on the Targets. Make the decisions based on how you want to break down the development process and help maximize the productivity of the developers.</p><p><strong>Who are the important people involved in a Data Integration Project?</strong></p><ol><li><strong>Business Analyst — </strong>The guy who understands the business, understands the Source systems, understands the requirement of Target systems, and is able to talk both in business terms and technical terms.</li><li><strong>Data Mapper &amp; Modeller — </strong>The guy who<strong> c</strong>losely interacts with Business Analyst. Creates the Source to Target Mapping Document. He understands database technologies and design. Clearly defines the transformation logic that can be understood by the developer.</li><li><strong>Developer — </strong>The guy who uses the mapping document and writes code to integrate the data.</li></ol><p>Apart from the above-mentioned people, you also need to have anyone who would help the project run smoothly and help to keep the quality high. Typically they are DevOps, Database Admin, ETL Admin, Testers, Project Manager, and Business Stakeholders.</p><p><strong>Conclusion</strong></p><p>Data Integration can solve enormous data problems for your organization. Once the data is unified it can be used to find insights through Business Intelligence Reports, Data Mining, etc and that could help your business grow leaps and bounds.</p><p><em>If this post has helped you in some way then do let me know with a clap or a comment.</em></p><p><em>I hope to see you in my next post! Stay Safe, Bye!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c1b14bdeeb42" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What is Reverse ETL?]]></title>
            <link>https://abhimarichi.medium.com/what-is-reverse-etl-796c29a0931?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/796c29a0931</guid>
            <category><![CDATA[data-engineering]]></category>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[reverse-etl]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 06 Feb 2022 07:02:31 GMT</pubDate>
            <atom:updated>2022-02-06T07:02:31.718Z</atom:updated>
            <content:encoded><![CDATA[<p>If you already know <a href="https://abhimarichi.medium.com/what-is-etl-a-quick-easy-example-33a7a434b8e7">what is ETL?</a> but wondering what is <strong>Reverse ETL</strong>? then let me try to explain it here.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*nAT8xAwI2VQ6bVQPlEGDkg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@divinetechygirl?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Christina Morillo</a> from <a href="https://www.pexels.com/photo/close-up-photo-of-person-typing-on-laptop-1181675/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>In the Reverse ETL process, a Data Warehouse is used as the source and the data is moved into other OLTP systems like CRMs or any Saas applications, etc.</p><p><strong>Why is this called Reverse ETL?</strong></p><p>Traditionally, an ETL process refers to extracting data from multiple OLTP Systems and transforming them, and loading them into a Data Warehouse. Once the data is in the Datawarehouse it was used only by the BI Tools to create various reports and dashboards. But the Reverse ETL is doing the opposite of it and is using Datawarehouse as the source and other OLTP systems as the target. Hence the name!</p><p><strong>Why do we need Reverse ETL?</strong></p><p>One common scenario that I can think of this — Assuming that your organization has already spent millions to build a decent stable data warehouse (DWH) that caters to the data needs of different departments. Now if you want to introduce a new application in the workflow like Salesforce CRM then it would be much easier to sync the application with the data which is already present in the DWH instead of pulling data from the actual OLTP source systems that may not have the point in time information.</p><p><strong>What problems we may face when we use the Reverse ETL approach?</strong></p><p>One of the common problems is the data refresh rate of the endpoint applications (target OLTP system in reverse ETL). You must always consider that not all Data warehouse tables are refreshed on a daily basis. There could be facts and dimensions that run weekly, monthly, quarterly, half-yearly and yearly, etc. There may be some ETL processes that run only once. Apart from all of these, there could be some bad design and a few tables might have been maintained manually. All of these dependencies could affect the data availability in the end systems.</p><p>It is very critical to analyze each dimension and fact table before using it in the Reverse ETL process.</p><p>Clearly analyze and visualize how the data would look like in the end system over the period of time.</p><p>Sometimes Reverse ETL approach may require changing the loading strategies of the Data warehouse tables and these changes must be done with caution and one must ensure that the change won’t affect existing BI Reports.</p><p><strong>Final Thought</strong></p><p>This approach and the hybrids of this has been implemented by many engineers in the past but only recently this has got a formal name to it. There are many tools that are being built with a focus on the Reverse ETL approach.</p><p>This approach when implemented correctly could potentially save time, effort, and money for the organizations.</p><p><em>I hope this post helped you a bit.</em></p><p><em>Let me know in the comment section below if you feel that this approach is something you are considering in your project and what are the pros and cons you think of?</em></p><p><em>Have a great day. Meet you in the next one. Bye!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=796c29a0931" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What is ETL? A Quick & Easy Example!]]></title>
            <link>https://abhimarichi.medium.com/what-is-etl-a-quick-easy-example-33a7a434b8e7?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/33a7a434b8e7</guid>
            <category><![CDATA[etl]]></category>
            <category><![CDATA[load]]></category>
            <category><![CDATA[extract]]></category>
            <category><![CDATA[data-integration]]></category>
            <category><![CDATA[transform]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 23 Jan 2022 06:53:10 GMT</pubDate>
            <atom:updated>2022-01-23T06:53:10.176Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pOyzJ7yr3TAVc-vbB-4L6w.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@kevin-ku-92347?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Kevin Ku</a> from <a href="https://www.pexels.com/photo/data-codes-through-eyeglasses-577585/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>If you have heard the acronym ETL and wondered what it is? then you are in the right place!</p><p>ETL is an acronym for <strong>E</strong>xtract, <strong>T</strong>ransform &amp; <strong>L</strong>oad, but this won’t explain anything.</p><p>Instead of giving you the textbook definition, let me explain it to you with an example.</p><p>Assume that you are the owner of 10 different retail stores and you would like to see key metrics from all of the stores every day like stocks, profits, no of sales, etc. in one report. To make it more interesting let us assume that each store manages data in its own separate database that may use different technologies.</p><p>So now, how to get the data you want from all of these different stores? So one way to do it is by creating another database that has data from all the different store’s databases. Here, in this case, you use the ETL approach to integrate the data.</p><p><strong>Extract</strong></p><p>Now either your programmers can write a piece of code or use some ETL tool to connect all the different databases and pull the required information from all of them, this is the process of extraction.</p><p><strong>Transform</strong></p><p>After extracting the data, we have to ensure that all the data is in the same format. For example, if one store is using dd/mm/yyyy date format and another store is using mm/dd/yyyy format then you have to standardize them to be in one format in the final combined database and this is simply the process of transformation.</p><p>There are many data anomalies you might come across while transforming the data and I have <a href="https://abhimarichi.medium.com/basics-of-data-cleansing-daffb5cad310">another blog</a> discussing some of them. You can check that out if you are interested.</p><p><strong>Load</strong></p><p>Once the data is standardized, it has to be loaded efficiently to the final database without much delay and this is the final part of it.</p><p>It is very important that this process runs efficiently otherwise you may not see the data on time or you may see the wrong numbers in your report.</p><p>I hope this short post gave you a little bit of understanding about ETL. If you want me to go deeper into the technical aspects of it then please let me know in the comments!</p><p>Take care and meet you in the next one.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=33a7a434b8e7" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Did Product School's— Product Management Certificate help me land a job?]]></title>
            <link>https://abhimarichi.medium.com/did-product-schools-product-management-certificate-help-me-land-a-job-a8209c1ee93?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/a8209c1ee93</guid>
            <category><![CDATA[product-school]]></category>
            <category><![CDATA[certificate]]></category>
            <category><![CDATA[product]]></category>
            <category><![CDATA[product-management-course]]></category>
            <category><![CDATA[product-management]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sat, 08 Jan 2022 17:13:27 GMT</pubDate>
            <atom:updated>2022-01-08T17:13:27.016Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*74c2qD-hRD8lVC-ZHQ0VOQ.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@fauxels?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">fauxels</a> from <a href="https://www.pexels.com/photo/man-and-woman-near-table-3184465/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>One of the common questions people have asked me about the Product Management Certificate Course is “Do you get a high-paying job after completing the course?”</p><p>I cannot answer this with a simple Yes or No. But let me try to answer it.</p><p>When I spoke to Product School before joining the course with the same question they said that Product School does not guarantee a job but about 70% to 80% of the candidates who take the course would either find a new job or get promoted in their current company. I am not really sure about these numbers though.</p><p>In my batch, I saw roughly about 40% getting a new job and another 30% getting a promotion within 6–8 months of completing the course. Please note this is a rough estimate on top of my mind.</p><p>With full confidence, I can only share what happened with me!</p><p>First, when I did the course I was working towards a promotion but after taking the course and applying product management strategy to my career plan 😊 I changed my path. I felt I do not want to become a Product Manager right away but I wanted to spend some more time in the technical role that I really enjoy doing.</p><p>Close to about 11 months after the course, I changed my job and joined Amazon as a Data Engineer.</p><p>So you might be wondering if the course helped me to change the job or not?</p><p>The answer is Yes, it helped me. I redefined my career goal because I applied what I learned.</p><p>It also helped me to crack product-related interview questions. I was able to talk more structurally and with confidence.</p><p>Would the course help ‘you’ in getting a job or getting a promotion?</p><p>This is a question that I cannot answer at all because I do not know you and your skills and your aspirations. This is something that you have to do yourself.</p><p>I hope this short post has answered your question or at least prompted you to look deeper for the answer!</p><p>Bye! Meet you in the next one.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a8209c1ee93" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why do I create content on the web?]]></title>
            <link>https://abhimarichi.medium.com/why-do-i-create-content-on-the-web-effed0621920?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/effed0621920</guid>
            <category><![CDATA[internet]]></category>
            <category><![CDATA[the-social-dilemma]]></category>
            <category><![CDATA[web]]></category>
            <category><![CDATA[content-strategy]]></category>
            <category><![CDATA[content-creation]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 02 Jan 2022 08:03:09 GMT</pubDate>
            <atom:updated>2022-01-02T08:03:09.579Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*soMYRFEY3NPjIRD0HrDs3A.jpeg" /><figcaption>Abhilash Marichi</figcaption></figure><p>Sometime in 2019, I noticed deeply that there is too much toxic content on the web, and out of all the content, I felt the most powerful ones are photos and videos and I spent enough time thinking about the ways to stop the toxic content on the web.</p><p>The first approach was to fight it head-on and to clean it from the root, but as I spent more and more time thinking about it, I realized that the better approach to overcome the negative and toxic content is to contribute to the positive content pool.</p><p>The web could become the biggest democracy, though it’s skewed as of now, every tiny bit of positive content contributes to make it better.</p><p>So I started doing whatever possible from my end to put out positive and helpful content in the form of blog posts and videos.</p><ul><li>For me, positive content is something that can help the viewer in some way, even if I am helping the viewer just 1% is still progress, but going forward, I am trying to build content that can help the viewer to the maximum extent possible. It’s going to be tough and requires a lot of effort but I believe it’s worth it.</li><li>I spend a good amount of time regularly learning about data and products and a lot of my friends say that I can explain the concepts well in simple terms, so I thought, if I make videos, it can help more people. So I make videos talking about what I have learned and experienced.</li></ul><p>This is my simple content strategy!</p><p>I would also want more and more people to spend time creating positive and helpful content on the web in any form possible and that would help even more people who consume.</p><p>Think of it, if you make positive content, and let’s say you spend 1 hour creating a 5 mins content every week then you would have spent 52 hours of your time in the year creating content and even if 15 people spend about 5 mins on each of your content then it’s around 65 hours of the positive impact that you have created in somebody’s life. A simple effort from you can create about 100+ hours (52 yours + 65 others = 117 hours) of positive impact in a year without much of a hassle. Imagine if 15 of my friends who are reading this, who have never created content, started creating! then it could be 1500+ hours of impact and the positive impact can snowball over time.</p><p>Imagine the world with positive and supportive people around. That would be a much better place to live in!</p><p>I believe that human energy and time must be spent on stuff that is good for the head, heart, and environment!</p><p>The goal of my content creation journey is to produce some positive stuff for the internet. Even if I make a tiny bit of contribution that’s a win.</p><p>If you are watching this, I urge you to create some form of positive content this year — like — writing a blog, making a video, posting something positive on social media, or just contributing in any form possible. Share your life experience and learnings with the world.</p><p>I wish you a happy very new year and let’s step into a more positive and supportive world together!</p><p>Thank You!</p><p>Bye, meet you in the next one!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=effed0621920" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 most common ways of using count() function in Oracle]]></title>
            <link>https://abhimarichi.medium.com/5-most-common-ways-of-using-count-function-in-oracle-f060d27d76a9?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/f060d27d76a9</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[beginner-coding]]></category>
            <category><![CDATA[count]]></category>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sat, 27 Nov 2021 07:01:12 GMT</pubDate>
            <atom:updated>2021-11-27T07:01:12.451Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CaKo1S2p0wLLMrxJ4gEumg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@olia-danilevich?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels"><strong>olia danilevich</strong></a> from <a href="https://www.pexels.com/photo/man-sitting-in-front-of-three-computers-4974915/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels"><strong>Pexels</strong></a></figcaption></figure><p>For the examples provided below, I am considering this simple table</p><p><em>CREATE TABLE TEMP_EMPLOYEE (<br> ID INT<br> ,NAME VARCHAR(255)<br> ,LOCATION VARCHAR(255)<br> );</em></p><p>With values as shown below —</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/273/1*boNFF-CIPQa95n4wuIp86A.png" /></figure><h4>Count(*)</h4><p>This gives the count of records in the table.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/301/1*WgsMByjt8wUnAhypPzJ6-w.png" /></figure><h4><strong>Count(1)</strong></h4><p>This also gives the count of records in the table</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/270/1*L0gag8SZhFyzl8fKy7l8qQ.png" /></figure><h4><strong>Count(column_name)</strong></h4><p>This gives the count of NOT NULL records.</p><p>Let’s use count(ID), if you see the records, ID is populated for all the records so the count would be 4</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/261/1*nQLH-3Te_QWf9WKCXIZv2Q.png" /></figure><p>But, if we use count(LOCATION), the count would be 3 because there is one record with value NULL in this column</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/304/1*j2vnhTmdpTQ_9zSD3uTz8w.png" /></figure><p><strong><em>Let’s add 3 more records into our table now, just to play around more!</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/276/1*OiTF7Mq05-4emGhLKeu8GA.png" /></figure><h4>Count(distinct column_name)</h4><p>This will count the number of distinct values in the specified column</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/368/1*DG8iQm804HNGiEtaJGn0JQ.png" /></figure><h4>Count() with a group by</h4><p>We can always use count() examples provided above with a group by clause.</p><p>The example provides the number of people live in each location.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/323/1*x63JPYMYs_NTcmOxC6Fb6g.png" /></figure><p><em>These are the basic usages, I hope you enjoyed learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f060d27d76a9" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Common Questions about Product School’s Product Management Certificate Course]]></title>
            <link>https://abhimarichi.medium.com/5-common-questions-about-product-schools-product-management-certificate-course-14721fd3e15b?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/14721fd3e15b</guid>
            <category><![CDATA[product-management-course]]></category>
            <category><![CDATA[product-management-career]]></category>
            <category><![CDATA[product-school]]></category>
            <category><![CDATA[certificate]]></category>
            <category><![CDATA[questions]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sun, 14 Nov 2021 04:03:32 GMT</pubDate>
            <atom:updated>2021-11-14T04:03:32.426Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*N2jUW6rRAc2_8x4wH6KBfg.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@olyakobruseva?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Olya Kobruseva</a> from <a href="https://www.pexels.com/photo/question-marks-on-paper-crafts-5428836/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>In Jan 2021, I published a video about my <a href="https://www.youtube.com/watch?v=mxzXereWLxk">review of the Product Management Certificate Course by Product School</a> and from then people have reached out to me asking various questions about the course and I have tried to answer as much as possible.</p><p>I saw a common pattern across all the questions and thought that it could be helpful to many if I consolidate the questions together and answer them in one place and here it is —</p><h4>1. Would this course help someone who has no product management experience or any sort of experience in the tech world?</h4><p>Yes, this course is designed for beginners and you do not need any prior product management experience.</p><p>Product Managers need not be fully experienced in the tech world and not all product management jobs need in-depth technical understanding. But having experience in the field you are looking for a job always adds value to your resume.</p><h4>2. Is the course worth spending $4500 (~INR 3.2 Lakhs)</h4><p>It depends on every individual and what they are looking for. In my case, I valued learning from a real mentor who has had experience working as a Product Manager, and also the network I got through the course is amazing and with these, I felt my money was worth it.</p><p>But if you are just starting out and if this is not in your budget, then there are a lot of free resources. Product School does free live streams almost every day and you can follow them on <a href="https://www.linkedin.com/school/product-school/">LinkedIn</a>, <a href="https://www.youtube.com/c/ProductSchoolSanFrancisco">YouTube</a>, etc and you get to learn a lot from these sessions and there are a lot of other free materials you can get if you just google it. Also, reading as many <a href="https://productschool.com/blog/product-management-2/top-most-read-books-by-product-managers/">books</a> as possible on product management helps a lot.</p><h4>3. Do you get a high-paying product manager job after you do this course?</h4><p>The course does not promise to get you a job but they would prepare you for getting a job or if you trying to get promoted to a product manager position in your current company.</p><p>Product School has its <a href="https://productschool.com/job-portal/">job portal</a> where it lists multiple open positions that you could apply for and also they do <a href="https://productschool.com/product-career-fair/">job fair</a>s where you get to talk to recruiters directly and apply for the open positions and entry is free for students and alumni.</p><p>In my class of 18, about 5 got a new job, and most of the others were trying to get promoted as Product Managers in their current company.</p><p>Getting a job has many factors to it and it all depends on the individual and the available opportunity.</p><h4>4. Does the certificate add value to your resume?</h4><p>Do not expect to be called for an interview just by adding this certificate to your resume. The certificate will only support all the other product management-related experience you have and also shows the recruiters that you are serious about Product Management and you have invested time and effort towards it.</p><p>Also remember, the first round of short-listing is usually done by bots and not by real humans if you apply directly and it factors in everything.</p><h4>5. Can a student or working professional or fresh out of college apply for this course?</h4><p>Yes. You can apply for this course and there is no entrance exam. If you are looking to become a product manager or want to learn about product management. It’s a great place for it.</p><p><em>These were the top 5 questions I have been asked and I hope this post has helped you with some answers to your questions. I wish you all the best in your next step.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=14721fd3e15b" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Why you must not tell your plans too early!]]></title>
            <link>https://abhimarichi.medium.com/why-you-must-not-tell-your-plans-too-early-2d9c561c1f86?source=rss-5b2ae02cb491------2</link>
            <guid isPermaLink="false">https://medium.com/p/2d9c561c1f86</guid>
            <category><![CDATA[secret-plans]]></category>
            <category><![CDATA[plans]]></category>
            <category><![CDATA[motivation]]></category>
            <category><![CDATA[success]]></category>
            <category><![CDATA[goals]]></category>
            <dc:creator><![CDATA[Abhilash Marichi]]></dc:creator>
            <pubDate>Sat, 17 Jul 2021 05:02:43 GMT</pubDate>
            <atom:updated>2021-07-18T05:30:34.410Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5yS74JVmKXurrrGwrepQUA.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@divinetechygirl?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels"><strong>Christina Morillo</strong></a> from <a href="https://www.pexels.com/photo/grayscale-photo-of-man-1181366/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels"><strong>Pexels</strong></a></figcaption></figure><p>Have you ever made plans and told all of your friends but ended up not doing anything about it. Do you know why that happens?</p><p>If you ask my friends from School [from 8th to 12th Grade], they would tell that I am one talkative person who just talks everything out and everyone knows all of my plans but if you ask my friends from my bachelor (undergrad) days or at work they would say this guy won’t talk or even socialize much!</p><p>I totally changed who I was because I stumbled upon few experiences that changed the outlook of my life and unlocked some knowledge! and I would want to share that with you and I hope that would make you talk less and achieve more!</p><p>There was interesting research done on this topic and you can read it <a href="https://s18798.pcdn.co/motivationlab/wp-content/uploads/sites/6235/2019/02/gollwitzer-et-al-2009-when-intentions-go-public.pdf">here</a> and some of the things that I share here are backed by it.</p><h4>Early Gratification —</h4><p>The moment you announce your grand plans to people, the act of telling already gratifies you and you will have a sense of accomplishment, which is a big hindrance for you to actually go ahead and do the work necessary to achieve your goals or execute your plans.</p><p>Ensure that you must feel gratified only at the end of execution or if you have larger plans, you must ensure to have little rewards on the way, but there is absolutely no need to announce your entire plan to anyone.</p><p>I try to follow this as much as possible and I have personally seen results. The more I talk about a plan, I can sense that it creates a mental block, and makes it difficult to actually work on the task.</p><h4>Seeking Approvals</h4><p>Another reason why most of us announce our plans to others is to get approval. Deep down, we think that if many people agree or approve our plan then we would be successful, but we often forget that a plan is successful only by working at it and not by getting approvals.</p><p>Approvals are just a ‘feel-good’ factor, it does not help. As I mentioned, this also contributes to your early gratification and that is absolutely unnecessary.</p><h4>Energy Usage</h4><p>Have you observed how you feel after announcing your plans and goals? I always feel that my energy or spark is gone as soon as I speak about it. I either start feeling too proud or too empty.</p><p>It takes a lot of energy to explain to others your point of view and why you have made this plan and how that would impact your life etc. Instead, use that energy to start doing your tasks little by little and soon you will see that there would be a snowball effect and you would be well on your way to executing your plans successfully.</p><h4>Negative Feedback</h4><p>One important thing, the more you tell your plans you may get more opinions and if you hear too many bad opinions then you may drop your plan even without taking the first step.</p><p>So keeping your plans to yourself will save you from all the negativity. Always track your plans, let the data guide you instead of people’s opinions.</p><h4>If you need to announce your plan then only do it to the following people</h4><p><strong><em>a. Your Mentor </em></strong>— This is some one who is a pro in what you are trying to do and is willing to help you achieve the goal and the inputs from Mentor would be very much valuable. They help you to set realistic plans and achieve them based on their experience.</p><p><strong><em>b. Your Accountability Partner</em></strong> — This is someone who is on the same boat and has similar goals. You both check on each other’s progress and also motivate each other to get there faster and share your knowledge. You both must look each others as equals. (There can be accountability partners who are not trying to achieve the same goal but at least they must have the same level of hunger as you have to achieve something.)</p><p><strong><em>c. Your Closest People</em></strong><em> </em>— These people are the ones who gives you emotional support when you fall and cheer for you when you win. It could be your spouse, your best friend or your sibling or any one! Usually they are just one or two people.</p><p>If they do not fall in any of these categories they don’t need to know what you are up to. Learn, Create, Fail and Succeed by yourself.</p><p><em>remember…</em></p><blockquote>“ your action speaks louder than words</blockquote><blockquote>and the world will hear it! ”</blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2d9c561c1f86" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>