<?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 kratika jain on Medium]]></title>
        <description><![CDATA[Stories by kratika jain on Medium]]></description>
        <link>https://medium.com/@kratikajain729?source=rss-955241b8afcb------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*2ZyNi8CnGI7RG0wv9XCmGw.jpeg</url>
            <title>Stories by kratika jain on Medium</title>
            <link>https://medium.com/@kratikajain729?source=rss-955241b8afcb------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Sat, 21 Nov 2026 16:28:48 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@kratikajain729/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 to create sales and inventory dashboard in PowerBI]]></title>
            <link>https://kratikajain729.medium.com/how-to-create-sales-and-inventory-dashboard-in-powerbi-0d910b127b9f?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/0d910b127b9f</guid>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[sales]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Wed, 01 Nov 2023 19:01:13 GMT</pubDate>
            <atom:updated>2023-11-02T14:30:43.476Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/918/1*TB3urSYnnsstjLwpC5SOeA.png" /></figure><p>Power BI is a business intelligence tool that helps visualize data in the form of charts and other visuals.</p><p><strong>Step 1: Connect and load data.</strong></p><blockquote>To connect and load data into Power BI, use the Get data feature. Power BI supports a wide range of data sources, including Excel, CSV files, SQL databases, and cloud-based sources.</blockquote><p><strong>Step 2: Transform data.</strong></p><blockquote>Once your data is loaded into Power BI, you can transform it to clean it up and make it easier to visualize. You can use the Power Query Editor to perform various transformations, such as:</blockquote><ul><li>Deleting unnecessary rows</li><li>Renaming column names</li><li>Replacing null values</li><li>Merging tables</li></ul><p><em>for example, in the sales and inventory dataset we have gender column, and the values are F and M and to replace it with “Male” and “Female” we can use replace values function in Power Query Editor.</em></p><p><strong>Step 3: Visualize data.</strong></p><blockquote>Once your data is transformed, you can visualize it in the form of charts, graphs, and other visuals. Power BI offers a wide range of visuals to choose from, including bar charts, line charts, area charts, pie charts, donut charts, and maps.</blockquote><p>For example, you might want to create a bar chart to show sales by product category, or a line chart to show sales over time.</p><p>Once you have created your visualizations, you can share them with others in your organization or publish them to the web.</p><p>check my project here at @<a href="https://medium.com/u/e0ad8aee92c2">novyPro.</a></p><p><a href="https://www.novypro.com/project/sales-and-inventory-dashboard">https://www.novypro.com/project/sales-and-inventory-dashboard</a></p><p>I hope this is helpful!</p><p>Thanks for reading.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0d910b127b9f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[What does Data Modeling in Power BI entail, and what are the recommended best practices for data…]]></title>
            <link>https://kratikajain729.medium.com/what-is-data-modelling-in-powerbi-and-its-best-practices-to-follow-while-doing-the-data-modelling-c2c43d68e40e?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/c2c43d68e40e</guid>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[power-bi-data-analyst]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sun, 29 Oct 2023 14:53:40 GMT</pubDate>
            <atom:updated>2023-10-29T14:55:41.618Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/512/1*xris27B_HUWPlCYNWqhIuw.png" /></figure><h3><strong>What does Data Modeling in Power BI entail, and what are the recommended best practices for data modeling in this context?</strong></h3><p>Data modeling entails establishing relationships between tables based on shared attributes. For instance, consider connecting a fact table with a lookup table, such as linking the sales and product tables in a dataset.</p><p>When constructing a data model, it’s important to adhere to best practices:</p><ol><li>Opt for a well-designed model, ideally following a star schema.</li><li>Ensure one-to-many relationships are present.</li><li>Include both the data (fact) and dimension (lookup) tables in the data model creation process.</li><li>Strive to minimize the data model’s size by including only the essential data required for analysis.</li><li>Separate the individual date and time components from datetime fields.</li></ol><p>I hope you’ll incorporate these guidelines when constructing the data model.</p><p>Thanks a lot for reading</p><p>keep learning</p><p>keep growing</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c2c43d68e40e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[10 Basic Excel Formulas Every Data Analytics Fresher Should Learn]]></title>
            <link>https://kratikajain729.medium.com/10-excel-formulas-for-beginners-320bc8e0d3d4?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/320bc8e0d3d4</guid>
            <category><![CDATA[data-analysis-excel]]></category>
            <category><![CDATA[learn]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[beginner]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sat, 28 Oct 2023 19:12:17 GMT</pubDate>
            <atom:updated>2023-10-29T06:31:54.693Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>10 Basic Excel Formulas Every Data Analytics Fresher Should Learn</strong></p><p>Excel is a powerful tool and it&#39;s the most used tool for analysis at every organization.</p><p>1. <em>Max and Min:</em> Max helps find the highest value in a dataset, while Min uncovers the lowest value.</p><p>2. <em>Sum, Sumif, and Sumifs:</em> Sum is handy for totaling values, like calculating the total salary of all employees. Sumif is used with logical tests, like =sumif(range, criteria), and Sumifs is for multiple conditions.</p><p>3. <em>Count and Countif:</em> Count gives the total count of employees, while =countif(range, criteria) is used with specific conditions. Countifs is employed for multiple conditions.</p><p>4. <em>Len (Length):</em> Len returns the number of characters in a text, helpful, for instance, in finding the length of customer names.</p><p>5. <em>Substring:</em> Used to extract specific parts of a text, like retrieving the year from the date 05/11/2000, which can be done with =left(b2,2).</p><p>6. <em>Date to Text:</em> This formula converts a date into text using =text(value, format text). Format text specifies how we want the text formatted, like in the case of a date as dd/mm/yy.</p><p>7. <em>Trim:</em> Trim removes any extra spaces from the text using =Trim(value).</p><p>8. <em>Concatenate:</em> This formula combines text. For example, if we need to create a full name from first and last names, this formula is perfect.</p><p>9. <em>Substitute:</em> Used to add text within a string, such as adding a hyphen. This can be done using 1 and 2 instances.</p><p>10. <em>If and Ifs:</em> If is used when there’s one logical test. For example, if salary is greater than 50000, then the designation is “Senior Data Analyst.” Ifs, on the other hand, handles multiple logical tests, like if salary is “50000” and gender is “female,” resulting in “Senior Data Analyst.”</p><p>Thanks a lot for reading.</p><p><em>“Have you tried using any of these functions before? Which is your favorite let me know in the comments? “</em></p><p>Keep learning.</p><p>Keep growing.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=320bc8e0d3d4" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The most important topic in SQL.]]></title>
            <link>https://kratikajain729.medium.com/order-of-execution-is-really-important-to-understand-in-terms-of-practicing-as-well-as-interview-32e39fec2b95?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/32e39fec2b95</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[writing]]></category>
            <category><![CDATA[programming]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Mon, 11 Sep 2023 12:16:11 GMT</pubDate>
            <atom:updated>2023-09-11T12:49:22.983Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WBDuPalGpTXDEg763lWw3Q.jpeg" /></figure><p>Order of execution is really important to understand in terms of practicing as well as interview purpose so we will learn that today as how it processes in the query.</p><p>From which table we need the data.<br> <br>Joins are used to combine two tables based on the common column<br>be at any join inner left right and outer join.</p><p>Where filtering the data and then getting the full table</p><p>Group by is for aggregating the data<br>Having is to apply the filter on that aggregate column</p><p>Select is used to get the data which we want in our table.</p><p>Order by is used to sort the data in descending or ascending order nothing is happening in the table it&#39;s just showcasing in the output</p><p>The limit is to get the number of rows.</p><p>Kratika Jain</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=32e39fec2b95" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Entering into the data analytics field is not impossible it requires a lot of effort…]]></title>
            <link>https://kratikajain729.medium.com/entering-into-the-data-analytics-field-is-not-impossible-it-requires-a-lot-of-effort-4fb5c9fc9d39?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/4fb5c9fc9d39</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[datanalysis]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sun, 27 Aug 2023 17:19:40 GMT</pubDate>
            <atom:updated>2023-08-27T17:19:40.488Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QLLopFQhPyWW0VDeNDlK5A.jpeg" /></figure><p>Entering into the data analytics field is not impossible it requires a lot of effort, dedication,countless sleepless nights,patience with lots of hard work.</p><p>Do not think of it as cake walk or some fancy factors such as most high paying jobs and all.</p><p>Do your learnings with great honesty and patience then enjoy the growth and results of my learnings into a fruitful manner.</p><p>Do let me know what are your factors to enter into this field and what challenges you faced?</p><p>Keep learning!</p><p>Keep growing!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4fb5c9fc9d39" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[SQL]]></title>
            <link>https://kratikajain729.medium.com/sql-c25b2d6235bc?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/c25b2d6235bc</guid>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[dataanalyticscourse]]></category>
            <category><![CDATA[easy]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sun, 27 Aug 2023 17:10:50 GMT</pubDate>
            <atom:updated>2023-08-27T17:10:50.360Z</atom:updated>
            <content:encoded><![CDATA[<p>SQL (structured query language) is an extremely important tool if you aspire to be a Data Analyst, Data scientist.</p><p>It holds a lot of advantages of learning SQL as</p><p>1) It’s easy to learn<br>2)Open source<br>3)Requirements in every tech industry<br>4)Developed 50 years ago but still in so much demand<br>5) Its usage is not limited to one industry it’s used in every industry.</p><p>So why wait just start learning it today and do let me know in the comment section why you think it’s the most important to start your career in the data industry.</p><p>Keep learning!<br>Keep growing!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c25b2d6235bc" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to optimize your LinkedIn Profile?]]></title>
            <link>https://kratikajain729.medium.com/how-to-optimize-your-linkedin-profile-5243e28f5376?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/5243e28f5376</guid>
            <category><![CDATA[connect]]></category>
            <category><![CDATA[linkedin]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[fellows]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Wed, 02 Aug 2023 12:52:07 GMT</pubDate>
            <atom:updated>2023-08-02T14:44:53.996Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/360/1*G7mgl-e95RJy7wKX72-NMA.jpeg" /></figure><p>A lot of times I got a lot of DMs as to how to improve my LinkedIn profile as it is the most important platform to show your professional background.</p><p>Here are the ways that one can follow to stand out in front of recruiters and networks.</p><ol><li>Your profile picture should be professional such as with a perfect plain background.</li><li>The summary section is the most important after the profile picture as it shows your qualities yourself as a third person there to talk about you.</li><li>Try to make a box of your best skills through your project and education.</li><li>Link your different project links and check yourself also as these links are accessible or not so that it will be easy for the recruiters also.</li><li>The featured section will really help the person to immediately see your certificates.</li><li>A LinkedIn banner is also highly recommended to showcase your information so that one can easily connect with you. For instance, do not overwrite that by putting everything on it.</li><li>Update your experience, education, and internship column with appropriate dates and media.</li><li>Modify your license and certificate column according to the dates one received the most recent comes first and so on.</li><li>The project column is the place where you can easily catch the eye of anyone by updating that frequently.</li><li>Sharing thoughts regarding your learnings and showing your opinion towards different topics which come under your learning.</li></ol><p>Being a fresher these steps are really important if not updated go and update as soon as possible and optimise your LinkedIn soon.</p><p>Thanks for reading</p><p>Stay tuned and follow for more</p><p>Kratika Jain</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5243e28f5376" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to deal with Procrastination?]]></title>
            <link>https://kratikajain729.medium.com/how-to-deal-with-procrastination-e6c1fb0388b8?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/e6c1fb0388b8</guid>
            <category><![CDATA[overcome]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[deal]]></category>
            <category><![CDATA[procastination]]></category>
            <category><![CDATA[life]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sat, 29 Jul 2023 09:19:34 GMT</pubDate>
            <atom:updated>2023-07-29T09:19:34.512Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uES3wML1LooAxYNl-lgt6A.jpeg" /></figure><p>A number of times as an individual we deal with this unknowingly and which results in nothing but a waste of our precious time and our positive energy.</p><p>Procrastination is a thought of voluntary lagging in our day-to-day work and willingness not to do it on time so one can do plenty of things to avoid this.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/176/1*1eydpa4twCg_Q5bVSUjYGQ.jpeg" /></figure><p>Firstly, do the most boring work first and set a timer for that and try to push yourself to do that in that targeted time period only.</p><p>Secondly, try to make small goals rather than going for completing a huge number of targets and after accomplishing them reward yourself with your favourite things which as an individual you love the most that can be going for a walk, listening to songs and talking to a friend and many more.</p><p>Third comes, do not let your surroundings make noise in your brain and affect make yourself busy doing some task during the day find why as an individual you are doing that and make a motive out of that that will give a sense of achievement and a feeling of moving forward to your next task.</p><p>Fourth, make a to-do list which will really help you handle the task in a systematic way of doing the task and sees the magic of doing and see the changes in your productivity.</p><p>last but not least rather than finishing the task in one go break your task into different stages so that your mind can be relaxed and more concentrated on doing that work productivity will also increase and less stress of completing a huge task in one go.</p><p>These are the steps as an individual I am following because of procrastination only my blogs were late so thought of writing about what I am facing to deal with and how to overcome this.</p><p>keep learning</p><p>keep growing</p><p>stay tuned for more and no procrastination and follow for more</p><p>Kratika Jain.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e6c1fb0388b8" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[MOST ASKED QUESTIONS IN DATA ANALYST INTERVIEWS?]]></title>
            <link>https://kratikajain729.medium.com/most-asked-questions-in-data-analyst-interviews-745af3211a99?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/745af3211a99</guid>
            <category><![CDATA[interview]]></category>
            <category><![CDATA[tuned]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[journey]]></category>
            <category><![CDATA[questions]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Sun, 23 Jul 2023 17:36:04 GMT</pubDate>
            <atom:updated>2023-07-23T17:36:04.895Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/950/1*kqFkXMGi-UDX3vudVtWWoA.jpeg" /></figure><p>List of questions which are asked in the interview for the data analyst role:</p><ol><li>What s the difference between Data Mining and Data Profiling?</li><li>What is Data Wrangling in data analytics?</li><li>What are the common problems that data analysts encounter during analysis?</li><li>What are the various steps involved in any analytics project?</li><li>Which technical tools have you used for analysis and for data visualization?</li><li>What are the best practices for data cleaning?</li><li>How can you handle missing values in your dataset?</li><li>What do you understand by the term normal distribution curve?</li><li>What is time series analysis?</li><li>How is joining different from blending in tableau?</li></ol><p>THESE are 10 questions which consist of all the topics such as Python, Tableau and EDA</p><p>FOLLOW for more and stay tuned</p><p>I will share more questions soon till then read these and try to frame your answers.</p><p>KRATIKA JAIN(Who is preparing for upcoming interviews and helping her fellow mates as well)</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=745af3211a99" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Making plans to study this whole day but ends up doing nothing why?]]></title>
            <link>https://kratikajain729.medium.com/making-plans-to-study-this-whole-day-but-ends-up-doing-nothing-why-6c94869b89eb?source=rss-955241b8afcb------2</link>
            <guid isPermaLink="false">https://medium.com/p/6c94869b89eb</guid>
            <category><![CDATA[life]]></category>
            <category><![CDATA[doing]]></category>
            <category><![CDATA[motivation]]></category>
            <dc:creator><![CDATA[kratika jain]]></dc:creator>
            <pubDate>Tue, 18 Jul 2023 18:41:09 GMT</pubDate>
            <atom:updated>2023-07-19T05:23:17.205Z</atom:updated>
            <content:encoded><![CDATA[<p>In your learning phase or if an individual is preparing for any competitive exams time management is the key and spending that time in positive energies is extremely important as it will really help students in studying more and the student will feel accomplished at the end of their day.</p><p>However, so many times this is not the case so one can follow these aspects:</p><p>Concentration: According to so many studies it is not the easiest task to concentrate on things for long because of external as well as internal factors but one can improve it by doing simple basic steps such as taking breaks in between, making plans for the day, doing little stretching in between, rewarding yourself.</p><p>Yoga and meditation: This will really help the peers to make the mind more energetic and flexible during the entire day. for example, in our body blood is circulating and makes sure that flow properly flows in our body every individual should at least 30 mins do workout go for walks.</p><p>Connect to nature: Revision is the key to any learning so start revising with nature this is highly recommended by our parents as to sit with nature and study and results will blow your mind for sure.</p><p>Time management: Most neglected yet important factor on which everything is depended make notes prior to the day and follow them be strict with yourself and make 21 days of the habit of following the same routine starting with preparing sticky notes, prioritising things and doing the most uninteresting work first and see the growth of time management and spend less time on social media.</p><p>keep following these steps and after 21 days see the change within.</p><p>thanks for reading</p><p>follow for more and stay tuned for more</p><p>Kratika Jain ( who took 21 days habit challenge)</p><p>keep motivated in life and keep working for others and yourself.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6c94869b89eb" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>