<?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 Monalisha Kumari on Medium]]></title>
        <description><![CDATA[Stories by Monalisha Kumari on Medium]]></description>
        <link>https://medium.com/@monalishakumari?source=rss-8de67a66d72d------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*xXSIFpQKBTk_6UhSrGggBw.jpeg</url>
            <title>Stories by Monalisha Kumari on Medium</title>
            <link>https://medium.com/@monalishakumari?source=rss-8de67a66d72d------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Fri, 20 Nov 2026 08:57:28 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@monalishakumari/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[Navigating the Rollercoaster of My Data Analyst Journey in Startup]]></title>
            <link>https://monalishakumari.medium.com/navigating-the-rollercoaster-of-my-data-analyst-journey-in-startup-feec0e1debc3?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/feec0e1debc3</guid>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[journey]]></category>
            <category><![CDATA[startup]]></category>
            <category><![CDATA[journalism]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Wed, 06 Mar 2024 18:18:07 GMT</pubDate>
            <atom:updated>2024-03-06T18:18:07.438Z</atom:updated>
            <content:encoded><![CDATA[<p>It’s been almost a year since I embarked on my journey into the data field, and I’m excited to share with you the highs and lows I’ve encountered along the way. Transitioning into a new role as a data analyst in a startup has been quite the rollercoaster ride, filled with challenges and valuable lessons.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9PTk4b5D9hN87NfTLG5kmw.jpeg" /></figure><p><strong>Joining as data analyst in startup:</strong><br>From the moment I stepped foot into the company on <strong>May 8, 2023.</strong>I knew I was in for an adventure. Everything was new — the work culture, the tasks at hand, and even the industry itself. Coming from a background in healthcare, diving into the world of data in the startup ecosystem was both exhilarating and daunting.<br> <br>The initial two months were dedicated to acquainting myself with the company, colleagues, and, most importantly, the data I was to work with. Each day was a learning curve, understanding terms like ACOST, Revenue, SKU, and grasping concepts such as vertical and sub-vertical.<br> <br><strong>Probation period to Full-Time Offer-</strong><br>Underneath it all, I couldn’t shake the feeling of uncertainty. I kept wondering if I’d land a full-time job after the probation period. This uncertainty hit even harder because everything was brand new — transitioning from healthcare to e-commerce felt like stepping into a whole new world.</p><p>But despite these uncertainties, my dedication towards work and by God grace I was fortunate to receive a full-time offer after just one month. With each passing day, my love for data analysis grew as I delved into new formulas and learned how to craft DAX measures and many more.</p><p><strong>My first project:</strong> working for marketing and sales teams. They were struggling to gauge the performance of their verticals and sub-verticals, relying on manual data downloads. With the help of my team, we automated data extraction from Amazon Pi, storing it in SQL, and created my inaugural Power BI dashboard. This not only solved their performance tracking issue but also saved them 1–1:30 hours of manual work every day.<br> <br><strong>August brought a greater challenge:</strong> automating the sales process using Amazon SP-API. My team and I were daunted by our lack of experience in working with APIs and coding. However, as a startup, we had to tackle every aspect of the project, including those beyond our typical data analyst duties.<br>However we decided to have discussions with our manager, to talk about things which we are gonna facing regarding this project. Ultimately, he proposed seeking assistance from third-party experts as a solution. However, this decision presented its own challenges, particularly in finding a suitable party within our budget.</p><p><strong>Unexpected Challenges: </strong>Then came the unexpected blow on September 1, 2023, when my team and I received a termination letter due to the lack of progress on the project. This setback was demoralizing, especially considering the effort and sacrifices made to transition into the data field against family advice. It was a shock for me to face such a situation just 4–5 months after joining the company.</p><p><strong>Overcome Challenges:</strong> Despite the setback, our team came together, determined to face the challenge head-on. We split tasks, asked for outside help, and worked hard to automate sales and inventory tasks.</p><p>Our commitment not only helped us complete the project but also gave us the confidence that with the right approach and team, we can make anything work. And we didn’t stop there; we’re still working on automating tasks for other departments in the company.<br> <br><strong>Personal Challenges Amidst Professional Growth:<br></strong>My health took a hit amidst the challenges we were facing. From family health concerns to issues with housing, I found myself overwhelmed with stress. It got to the point where I would cry over the smallest things, feeling completely alone. To cope up, I turned to stress-eating, indulging in chocolates and fried foods.</p><p>Deep down, I knew this wasn’t good for my physical or mental well-being. So, I made a conscious decision to prioritize my health and resilience. I started engaging in activities that kept me occupied and distracted from the overwhelming thoughts.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*okHHk_r1ChLZotke1PNeqQ.jpeg" /></figure><p>I began journaling to process my emotions and started taking daily walks, aiming to reach 7–8k steps a day, with a goal of eventually hitting 10k steps. Additionally, I enrolled in a SQL course by <a href="https://www.namastesql.com/">Ankit Bansal</a> to continue honing my skills and stay focused on personal growth. These efforts were my way of regaining control and strengthening myself amidst the chaos.<br> <br><strong>In conclusion, my journey into the data field has been a mix of challenges and growth. Despite facing tough times at work and in my personal life, I’ve learned a lot about resilience and taking care of myself. With determination and support, I’ve managed to overcome obstacles and keep moving forward. Looking ahead, I’m excited for what’s to come and confident that I can handle whatever comes my way.</strong></p><p><strong><em>Keep learning and keep growing…</em></strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=feec0e1debc3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Explained Central Limit Theorem in Statistics using Python]]></title>
            <link>https://monalishakumari.medium.com/explained-central-limit-theorem-in-statistics-using-python-1a2a85a03303?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/1a2a85a03303</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[python-programming]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[central-limit-theorem]]></category>
            <category><![CDATA[statistics]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Sun, 19 Mar 2023 17:10:44 GMT</pubDate>
            <atom:updated>2023-03-19T18:21:37.866Z</atom:updated>
            <content:encoded><![CDATA[<p>In this article you will get to know the understanding of Central Limit theorem in simple language with python code.</p><h3>What is Central Limit Theorem ?</h3><p><strong>The Central Limit Theorem states that the sampling distribution of the mean will always be normally distributed as long as the sample size is large enough. Regardless of whether the population has a normal, poisson, binomial or any other distribution , the sampling distribution of the mean will be normal.</strong></p><p>It relies on the concept of sampling distribution, which is the probability distribution of a statistics for a large number of samples taken from a population.</p><h4>In simple language -</h4><p>→ If you have random variable X which is equal to or not equal to normal /Gaussian distribution have population mean (μ )and population standard deviation(σ).</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*onRBUn39N0KIB1wtnp3Brw.jpeg" /></figure><p>→ And when you take multiple sample where sample size(n) is greater or equal to 30 and computing sample mean of it</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ymn6ppGh9G4EGBM9SEc9xg.jpeg" /></figure><p>→ And when u plot a graph with help of histogram or probability density function , it shows bell-curve i.e normal distribution</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/787/1*Rb5JqZFFQUg0LMAu2SwAwg.jpeg" /></figure><p>And sample mean is equal to population mean and standard deviation is σ/√n</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*J_kTDWh-Ho5GjYPBOZUjFA.jpeg" /></figure><h3>Central Limit Theorem with Python</h3><p>Before starting first import all the libraries which will be used here-</p><pre>import numpy as np<br>import seaborn as sns</pre><p>→ Generate a random variable</p><pre># genrate random binomial distribution<br>np.random.binomial(10,0.5,10000)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/288/1*aniGecNMoeao-72ufZT2XQ.jpeg" /></figure><pre># now save it into variable named- population<br>population = np.random.binomial(10,0.5,10000)</pre><pre># we will plot graph of population using seaborn library<br>sns.displot(population)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/515/1*HSG8jwHrI3GrZzOOJRcQKw.jpeg" /><figcaption>Binomial distribution</figcaption></figure><h4>Lets consider with help of example</h4><p>→ Now we will take 30% of sample from population of 10000 where sampling size is 3000 — means each sample have 3000 data(n≥30)</p><pre>len(population)*0.30</pre><pre># convert it into integer<br>int(len(population)*0.30)</pre><pre># Sample Size <br>size=int(len(population)*0.30)</pre><pre># We will take 30 sample <br>sample_mean=[]<br>for i in range(1,31):<br>    print(np.random.choice(population,size=size))</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/318/1*f360yKGNHFDml0Rvs6VsJA.jpeg" /></figure><pre>#calculate mean of all sample<br>sample_mean=[]<br>for i in range(1,31):<br>    sample = np.random.choice(population,size=size)<br>    sample_mean.append(np.mean(sample))<br>    <br>sample_mean</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/191/1*6NaToT8Jm5T_0HBiWXdgXw.jpeg" /></figure><pre># Plot the graph of sample mean<br>sns.distplot(sample_mean)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/501/1*X-S_QHO2MhJwxfVzzv6uRQ.jpeg" /><figcaption>Almostly like bell-curve</figcaption></figure><p>→ Now if increase the sample size , more accurate gaussian distribution we will get.</p><pre># When sample is 500<br>sample_mean=[]<br>for i in range(1,501):<br>    sample = np.random.choice(population,size=size)<br>    sample_mean.append(np.mean(sample))</pre><pre>sns.displot(sample_mean,kde=True,color=&quot;red&quot;)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/467/1*wdQGUn4uGWq0EUDom-hGKQ.jpeg" /></figure><h4>Important point-</h4><blockquote>It relies on sampling distribution.</blockquote><blockquote>Sampling distribution of the mean will always be normally distributed as long as the sample size is large enough(n≥30).</blockquote><p>I hope you like this article and made easy for you to understand this important concept of Statistics in simple language.</p><p>And in upcoming article I will be posting some important interview question related to statistics. Till then <strong>Keep Learning and Keep Growing…</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1a2a85a03303" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Perform Exploratory Data Analysis -Generic Steps for Beginners]]></title>
            <link>https://monalishakumari.medium.com/how-to-perform-exploratory-data-analysis-generic-steps-for-beginners-5811555234e5?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/5811555234e5</guid>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[eda]]></category>
            <category><![CDATA[feature-engineering]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[statistics]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Fri, 17 Mar 2023 14:21:38 GMT</pubDate>
            <atom:updated>2023-03-17T14:21:38.598Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vzwHvn-UjV2aDX-KoUgaqg.jpeg" /><figcaption>Life Cycle of Data Science Project</figcaption></figure><h3>Before going in detail of EDA , lets understand What is EDA and Where it is used -</h3><p><strong>·</strong> <em>First and basics steps of data science workflow.</em></p><p><em>· An approach to analyse the dataset to summarize their main characteristics in form of visual methods.</em></p><p><em>· Technique to understand various aspects of data.</em></p><p><strong>The main aim is to obtain confidence in a data to an extent where we are ready to engage in machine learning model.</strong></p><h3>Steps involved in EDA -</h3><p><strong>1. Profiling of the data</strong></p><p><strong>2. Stats based analysis</strong></p><p><strong>3. Graph based analysis</strong></p><h3>Profiling of the data-</h3><p><strong>Here we go through data in detail like-</strong></p><p>→ Total Rows and Columns</p><p>→ Missing data</p><p>→ Outlier</p><p>→ Size</p><p>→ Duplicate value</p><p>→Datatype</p><p>→Numerical or Categorical</p><p>→RAM</p><blockquote><strong>At this stage if we found data — messy or it is not correct in terms of content , we do Data cleaning for further analysis</strong></blockquote><h3>Stats based analysis-</h3><p><strong>Interpretation of data in order to uncover patterns and trends.</strong></p><p>→ Variance</p><p>→ Standard Deviation</p><p>→ Covariance</p><p>→ Correlation</p><p>→ Chi-Square Test</p><p>→ Z-test, T-test, F-test</p><p>→ Measure of Central Tendency(Mean, Mode and Median)</p><p>→ Range</p><p>→ Percentile</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fvideoseries%3Flist%3DPLZoTAELRMXVMgtxAboeAx-D9qbnY94Yay&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLZoTAELRMXVMgtxAboeAx-D9qbnY94Yay&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2F11unm2hmvOQ%2Fhqdefault.jpg%3Fsqp%3D-oaymwEWCKgBEF5IWvKriqkDCQgBFQAAiEIYAQ%3D%3D%26rs%3DAOn4CLAGLd_2TpGCSucZGIeIpR_z4Z8s9g%26days_since_epoch%3D19433&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="853" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/7740234eda78d8c91ded3022b7af69a8/href">https://medium.com/media/7740234eda78d8c91ded3022b7af69a8/href</a></iframe><h3>Graph Based analysis</h3><p><strong>Here we can make statistical conclusion using graph .</strong></p><p>→ Box Plot</p><p>→ Scatter Plot</p><p>→ KDE(Kernel Density Estimation)</p><p>→ Count Plot</p><p>→ Histogram</p><p>→ Heatmap</p><p><strong>Reference-</strong></p><p><a href="https://thecleverprogrammer.com/2022/01/05/all-data-visualizations-in-data-science-using-python/">All Data Visualizations in Data Science using Python | Aman Kharwal</a></p><blockquote><strong>Note-</strong> Data analysis can be done any stage of EDA according to the requirements .</blockquote><p>Here I am attaching a video link to understand EDA in detail with using lot of dataset . In this playlist he explains each and every steps of EDA .</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fvideoseries%3Flist%3DPLZoTAELRMXVPzj1D0i_6ajJ6gyD22b3jh&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLZoTAELRMXVPzj1D0i_6ajJ6gyD22b3jh&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FbTN-6VPe8c0%2Fhqdefault.jpg%3Fsqp%3D-oaymwEWCKgBEF5IWvKriqkDCQgBFQAAiEIYAQ%3D%3D%26rs%3DAOn4CLBNDgTGNeUgcAsTbXm-v1jXlu0vqg%26days_since_epoch%3D19433&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="853" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/251bebaf32e6c72a2d7b8ba51b16f336/href">https://medium.com/media/251bebaf32e6c72a2d7b8ba51b16f336/href</a></iframe><blockquote><strong>I hope you like this article and will be helpful in your data journey .</strong></blockquote><blockquote><strong><em>Keep Learning and Keep Growing…</em></strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5811555234e5" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[My One-Year Journey on Medium]]></title>
            <link>https://monalishakumari.medium.com/my-one-year-journey-on-medium-8102da7f7ade?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/8102da7f7ade</guid>
            <category><![CDATA[medium]]></category>
            <category><![CDATA[data-scientist]]></category>
            <category><![CDATA[journey]]></category>
            <category><![CDATA[publication]]></category>
            <category><![CDATA[data-analyst]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Mon, 27 Feb 2023 15:54:52 GMT</pubDate>
            <atom:updated>2023-02-27T15:56:36.761Z</atom:updated>
            <content:encoded><![CDATA[<p>I never thought that I will be writing blogs for this long on medium. Yesss , its been a year and I am really happy to share my thoughts on it.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*N-KY-P14lM4dosUt8xVKww.jpeg" /></figure><h3>Lets Dive into My Journey with me-</h3><h4>How and Why I started writing blogs on medium ?</h4><p>Belonging to healthcare sector, its been really difficult for me to think about transition in tech-industry. But today I am happy to tell you that I really came a long way in this one year. Sharing my learnings on medium really boost my confidence to go ahead with my decision which I taken a year back for myself.</p><p>If you want to know about <strong>my journey</strong> (<em>my first article</em>) —<strong> you can read here</strong>.</p><p><a href="https://monalishakumari.medium.com/journey-from-frontline-worker-to-becoming-data-analyst-2a1e20e4f418">Journey from Frontline-Worker to becoming Data Analyst</a></p><blockquote><em>Now I would like to thank my friend</em><strong><em> </em></strong><a href="https://tauseef-feraz.medium.com/"><strong><em>Tauseef Feraz</em></strong></a><strong><em> </em></strong><em>who has not only pushed me to share my knowledge on medium but also encouraged me to do transition into tech. And I really feel proud of myself that I listen him and started this journey.</em></blockquote><h4>My Feelings about writing on Medium ?</h4><p>I still remember that day when first time I started receiving the notification like — <em>your story is live on this publication, added your story to their reading list, clapped for article, subscribed to get your stories via email</em> . It was really great feeling which I can’t describe specially for a person like me who always felt underconfident regarding sharing thoughts on public platform.<strong> </strong>But thankfully that I kept my fear behind and started writing on medium.</p><p>Currently I am contributing my article to<strong> two publications </strong>— <a href="https://blog.devgenius.io/"><strong>Dev Genius</strong></a><strong> and </strong><a href="https://blog.devops.dev/"><strong>DevOps.dev</strong></a> , who has given me platform to post my article for higher reach and for which I am really grateful.</p><p><strong>I would also like to thank <em>Medium</em> that I am able to write whatever I want on this platform without thinking about<em> plagiarism, spelling-mistake, grammar error etc</em>.</strong></p><p><strong>And I am also grateful to all my <em>subscribers</em> who has given time to read my articles .</strong></p><p><em>Lastly, I want to say that if you are also a person who are thinking of writing your thoughts on any public platform or you are beginner as content writer , you can start writing on medium and trust me you will love it but also on the other side , be ready for phase where you will feel stuck what to write and how to write your thoughts but all you need to do is keep going and start loving the process of your journey as content writer.</em></p><blockquote><em>See ya soon till my next post and till then</em></blockquote><blockquote><strong><em>Keep Learning and Keep growing …</em></strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8102da7f7ade" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Interview Question- Row_Number() vs Rank() vs Dense_Rank() in SQL]]></title>
            <link>https://blog.devops.dev/interview-question-row-number-vs-rank-vs-dense-rank-in-sql-b162d056e6ef?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/b162d056e6ef</guid>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[interview]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Thu, 23 Feb 2023 07:40:04 GMT</pubDate>
            <atom:updated>2023-03-01T19:06:20.032Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>In Interview- </strong>the most common and important question asked by interviewer is- <strong><em>What is the similarities and difference between row_number(),rank() and dense_rank() ? Explain with example.</em></strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/560/1*_FovjWy968F_3-brPpmldA.jpeg" /></figure><p>It seems easy to most of the people but when asked in interview, they get confused. So here I am to give a better understanding and clear concept for this above question in very simple language.</p><h3>What you will learn?</h3><p>→ Row_Number with example</p><p>→ Rank with example</p><p>→ Dense_Rank with example</p><p>→ Difference between row_number(),rank() and dense_rank()</p><p>→ Similarity between row_number(),rank() and dense_rank()</p><p><strong>Before going into topics for understanding </strong>- firstly, we have to<em> </em><strong><em>create database, table and insertion of data .</em></strong></p><pre>create database practice;</pre><pre>create table employee(<br>firstname varchar(20),<br>lastname varchar(20),<br>age int,<br>salary int,<br>location varchar(20)<br>);</pre><pre>INSERT INTO employee VALUES (&#39;sachin&#39;,&#39;sharma&#39;,28,10000,&#39;bangalore&#39;);<br>INSERT INTO employee VALUES (&#39;shane&#39;,&#39;warne&#39;,30,20000,&#39;bangalore&#39;);<br>INSERT INTO employee VALUES (&#39;rohit&#39;,&#39;sharma&#39;,32,30000,&#39;hyderabad&#39;);<br>INSERT INTO employee VALUES (&#39;shikhar&#39;,&#39;dhawan&#39;,32,25000,&#39;hyderabad&#39;);<br>INSERT INTO employee VALUES (&#39;rahul&#39;,&#39;dravid&#39;,31,20000,&#39;bangalore&#39;);<br>INSERT INTO employee VALUES (&#39;saurabh&#39;,&#39;ganguly&#39;,32,15000,&#39;pune&#39;);<br>INSERT INTO employee VALUES (&#39;kapil&#39;,&#39;dev&#39;,34,10000,&#39;pune&#39;);</pre><p><strong>Table-</strong></p><pre>select * from employee;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/530/1*SQKOrKfmlboqrsARIAovpA.jpeg" /><figcaption>Employee table</figcaption></figure><h3>Row_Number</h3><p>→ It is not recommended to use when there are duplicates present</p><h4>1. Find the employee’s salary rank from highest to lowest?</h4><pre>select firstname ,lastname ,salary ,<br>row_number() over (order by salary desc) as highest_lowest from employee;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/551/1*arMw6o8_t0asheKvweHIgw.jpeg" /></figure><blockquote><strong>Note-</strong> <em>It’s mandatory to use Order by clause ,whenever row_number, rank or dense_rank is used in queries .</em></blockquote><h4>2. Find 5th highest salary ?</h4><p><strong>→Using Nested Queries</strong></p><pre>select * from (select firstname ,lastname ,salary ,<br>row_number() over (order by salary desc) as rownum from employee) temptable where rownum=5;<br><br># Temptable- temporary table name </pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/498/1*JmgdEkY56AK3Mf36PPyEVw.jpeg" /></figure><h4>3. Find employee’s salary from highest to lowest for each location?</h4><pre>select firstname ,lastname ,salary ,location,<br>row_number() over (partition by location order by salary desc) as rownum from employee;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/538/1*M0bbIBnc34QE7SyRZJii1A.jpeg" /></figure><blockquote>→ <strong>For every partition ,row number starts with 1</strong></blockquote><blockquote>→Row_number doesn’t consider duplicates, and assign row number in sequential number (we can see in above snippets that 20,000 is ranked as 1 and 2 )<br> →So ideally we should not use row number in duplicates because it doesn’t make any sense .</blockquote><h4>4. Find highest salary from each location?</h4><pre>select * from (select firstname ,lastname ,salary ,location,<br>row_number() over (partition by location order by salary desc) as rownum from employee) temptable where rownum=1;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/570/1*tQGvmw0aazsT37fN5jhfyQ.jpeg" /></figure><h3>Rank</h3><h4>1. Find the employee’s salary rank from highest to lowest?</h4><pre>select firstname ,lastname ,salary ,location,<br>RANK() over (order by salary desc) as ranknum from employee;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/536/1*JeApLQiNJIojNFSbnlZAIA.jpeg" /></figure><blockquote>We can observe that same rank is assigned for duplicates and it skips the next ranking for next.</blockquote><h3>Dense_Rank</h3><h4>1. Find the employee’s salary rank from highest to lowest?</h4><pre>select firstname ,lastname ,salary ,location,<br>DENSE_RANK() over (order by salary desc) as denserank_num from employee;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/638/1*GKc2wJ0Vzw7zDXtMdwQUpw.jpeg" /></figure><blockquote>Here, we can observe that same rank is assigned for duplicates and it doesn’t skips the next ranking for next.</blockquote><h4>Difference between row_number(),rank() and dense_rank()</h4><p><strong>When there is duplicates-</strong></p><p>→Different row_number is assigned for each row and therefore, it doesn’t add any value when there is duplicates</p><p>→Same rank is assigned and for next record, it <strong><em>skip</em></strong> next ranking in between.</p><p>→Same dense_rank is assigned and for next record, it <strong><em>doesn’t skip</em></strong> next ranking in between.</p><h4>Similarity between row_number(),rank() and dense_rank()</h4><p>When there is no duplicates, all row number() ,rank() and dense_rank() leads to same result.</p><blockquote>I hope you like this article and will be helpful for your interview journey .</blockquote><blockquote><strong>Keep Learning and Keep Growing…</strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b162d056e6ef" width="1" height="1" alt=""><hr><p><a href="https://blog.devops.dev/interview-question-row-number-vs-rank-vs-dense-rank-in-sql-b162d056e6ef">Interview Question- Row_Number() vs Rank() vs Dense_Rank() in SQL</a> was originally published in <a href="https://blog.devops.dev/">DevOps.dev</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Excel Project- Bike Sales Dashboard]]></title>
            <link>https://blog.devgenius.io/excel-project-bike-sales-dashboard-6fc29bef75dd?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/6fc29bef75dd</guid>
            <category><![CDATA[dashboard]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[data-cleaning]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Tue, 14 Feb 2023 11:26:26 GMT</pubDate>
            <atom:updated>2023-03-22T14:08:54.747Z</atom:updated>
            <content:encoded><![CDATA[<h3>Excel Project- Bike Purchase Analysis</h3><p>Here is another Project for Data Analyst Aspirants which covers analyzing,cleaning and visualizing data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/768/1*5k5-UrxFn33ZpP1ND7eKhg.jpeg" /><figcaption>Bike Sales Dashboard</figcaption></figure><h4>Overview of Data</h4><p>Data Source- <a href="https://github.com/monalishakumari/Bike-Sales-Dashboard"><strong>Excel file</strong></a><strong> </strong>covers four sheet includes —</p><ol><li><strong>Bike_buyers-</strong> which consist of<strong><em> raw data or unclean data</em></strong></li><li><strong>Worksheet- </strong>copy of original data where we will perform<strong><em> data cleaning and data formatting</em></strong>(so that our original data did not get hampered because of any mistake)</li><li><strong>Pivot table-</strong> where we created <strong><em>pivot table and recommended charts</em></strong> respectively</li><li><strong>Dashboard</strong>- where we <strong><em>created slicer and did designing to create interactive dashboard </em></strong>.</li></ol><h4>Steps involved in this project-</h4><p>→Data Cleaning and Data Formatting</p><p>→Created Pivot table</p><p>→Built Recommended Chart based on pivot table</p><p>→Created Slicers</p><p>→Finally built interactive dashboard</p><h3>Data Cleaning and Data Formatting-</h3><h4>1. Looking for duplicates</h4><p><strong>Select whole data →Data →Remove duplicates</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*x5iskVEUnv3E24ltA1zdwQ.jpeg" /><figcaption>Selected full data(CTRL+A)</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/728/1*ZRfyY-aGbkBwAmbsi5geoA.jpeg" /><figcaption>Select All</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/769/1*kpwf3uSlLo4z1B8JsGFHIQ.jpeg" /><figcaption>Removed Duplicates</figcaption></figure><blockquote><strong>26 duplicates</strong> found and removed</blockquote><blockquote><strong>1000 unique values</strong> remain</blockquote><h4>2. Look each column one by one</h4><p><strong>Marital Status column-</strong> where <em>Married is denoted by M</em> and <em>Single is by S</em> , so we need to replace it with right name because in later stage it may confuse viewers with Gender Column.</p><p><strong>Select column →CTRL+H(Find and Replace)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/939/1*Lv-IdGGYh_rBEBFjpzFtkw.jpeg" /><figcaption>M →Married</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/902/1*gI21LydLEX-tTFSxsNOTeA.jpeg" /><figcaption>S →Single</figcaption></figure><p><strong>Gender column- </strong>Similarly like above do Ctrl+H and<strong> </strong>name it as <em>Male instead of M</em> and <em>Female instead of F </em>for better understanding of viewers.</p><p><strong>Income column- </strong>change the format(removing the decimal point)</p><h4>3.Create a new column- Age bracket(for better visualization)</h4><p>Here we will use <strong><em>Nested If statement</em></strong></p><blockquote><strong>=IF(L3&gt;54,”Old”,IF(L3&gt;=31,”Middle Age”, IF(L3&lt;31,”Adolescent”,”Invalid”)))</strong></blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*KOli_iVR0S9eiYM0MmU1pw.jpeg" /><figcaption>Age Bracket</figcaption></figure><h3>Create Pivot table and Recommended Charts-</h3><p><strong>Insert →PivotTable →From Table/Range</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/641/1*jLEWGDTnRdqoQmOA5sRrbQ.jpeg" /></figure><p><strong>Select Table/Range →whole cleaned data(</strong><em>Worksheet</em><strong>)</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/621/1*vb7THuvY10z2wXgTSjZdLA.jpeg" /></figure><h4>1st Pivot table-</h4><p>Average income of Male and female who purchased bike or not-</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/881/1*H3Qv4nO_Y8XZ7NsxXMo1WQ.jpeg" /></figure><h4>2nd Pivot table-</h4><p>Purchase of Bike on basis of distance</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*BV0rn8yRTmeQVPdkcqH-3g.jpeg" /></figure><h4>3rd Pivot table -</h4><p>Purchase of bike on basis of age</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0ketW8P3owkdFhzkrOEJ0g.jpeg" /></figure><h3>Create Slicer-</h3><p>Slicer- are visualization that allow viewers to refine the data for themselves</p><p><strong>Steps to create Slicer:</strong></p><ol><li>Click anywhere in the table or PivotTable.</li><li>On the Insert tab, select Slicer.</li><li>In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK.</li><li>A slicer will be created for every field that you selected.</li></ol><blockquote>With following above steps ,created 3 slicers <strong>i.e Marital Status, Region and Education.</strong></blockquote><h3>Build Interactive Dashboard</h3><p>Charts which we prepared during pivot table brought at one place and also put slicer and choose design to give it a look -which gives overall very decent interactive dashboard.</p><h4>Key Information-</h4><blockquote>Female who didn’t bought bike have average income of 53,000 whereas male have 56,000.</blockquote><blockquote>Middle Age group- bought more bike than Adolescents and Old Age group.</blockquote><p><strong>→You can give a look to dashboard and can have other insights too from it.</strong></p><p>I hope you like this project for your data analyst journey and also helped you to know actual use of excel in data analysis .</p><p><strong>Keep Learning and Keep Growing…</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6fc29bef75dd" width="1" height="1" alt=""><hr><p><a href="https://blog.devgenius.io/excel-project-bike-sales-dashboard-6fc29bef75dd">Excel Project- Bike Sales Dashboard</a> was originally published in <a href="https://blog.devgenius.io/">Dev Genius</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Project- Sales Insights of AtliQ Hardware]]></title>
            <link>https://blog.devgenius.io/project-sales-insights-of-atliq-hardware-fcdba22baf85?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/fcdba22baf85</guid>
            <category><![CDATA[data-cleaning]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Mon, 13 Feb 2023 15:31:02 GMT</pubDate>
            <atom:updated>2023-02-23T11:50:49.139Z</atom:updated>
            <content:encoded><![CDATA[<p>Woohoo-the another Data Analyst Project is here with fully detailed explaination.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/766/1*LOQH2fukQdzHPjDn3byFmg.png" /></figure><h4>What you will attain from this project?</h4><p>This project will help you to know- how to deal with data in real scenarios and how data can be helpful for company in terms of business growth (data driven-decision).</p><p>You will learn about Data Exploration using MySQL , Data Cleaning and ETL(Extract Transform and Load) and will built a final dashboard on Power BI to see all insights at one place .</p><h3>Lets Proceed with the Project-</h3><h4>1. Problem Statement</h4><p>AtliQ Hardware is a company which supplies computer hardware and peripherals to many of clients such as Excel stores, Surge stories across India. AtliQ Hardware head office is situated in Delhi, India and they have many regional office throughout the India.</p><p><strong>Challenges</strong>- Market is growing dynamically and Sales Director is facing issue in terms of tracking the Sales in this dynamically growth market and he is having issues with growth of his business, as overall sales was declining. He has regional managers for North India, South and Central India. Whenever he wants to get insight of these region he would call these people and on the phone regional manager give some insights to him.</p><p><em>Now Problem was that all these thing happening is verbal and there was no proof with facts that how his business is affected and which made him frustrated as he can see that overall sales is declining but when he ask regional manager, he is not getting complete picture of his business. And when he ask to give detail, they give lot of excel file and this AtliQ hardware is big business so to see insight clearly , he needs a dashboard to look at real data . And he will get proper insight and can take data driven decision to increase sales of his company.</em></p><h4><strong>2. </strong>Project planning with AIMS Grid and <strong>Data Discovery</strong></h4><p><strong>AIMS Grid -</strong>is a project management tool and it has four component-</p><p><strong>Purpose-</strong> to unlock sales insights that are not visible before for the sales team for decision support and automate them to reduced manual time spent in data gathering.</p><p><strong>Stakeholders-</strong> are people who will involve in this project like sales director, marketing team, customer service team, data analytics team and IT.</p><p><strong>End Result- </strong>An automated dashboard providing quick and latest sales insights in order to support data driven decision making.</p><p><strong>Success Criteria-</strong></p><p>→ Dashboard uncovering sales order insights with latest data available</p><p>→ Sales team able to take better decision and prove 10% cost savings of total spend.</p><p>→ Sales analyst stops data gathering manually in order to save 20% of their business time and reinvest it value added activity.</p><h4>3. Data Exploration Using MySQL</h4><p>You can access the data from here-<a href="https://github.com/monalishakumari/SalesInsight-AtilQ/blob/master/db_dump_version_2.sql"> <strong>Data</strong></a></p><p>After downloading data into your local system, now import data into MySQL-</p><p>Visit MySQL →Servers →Data Import</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/843/1*5SnFzQc6k1M72fA3r_3G8Q.jpeg" /><figcaption>Importing Data</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/569/1*W0BwjreFms60O2pD3ROeqA.jpeg" /><figcaption>Data is imported into MySQL</figcaption></figure><p>Lets explore the Data using query-</p><pre># All Customer records<br>SELECT * FROM sales.customers;</pre><pre>#All Transaction <br>SELECT * FROM sales.transactions; /*we can see that sales amount is negative */ </pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/942/1*1IN2uFMN1VWRmPwhBNCS8Q.jpeg" /></figure><p><strong>Observation-</strong> Sales Qty is in negative which is invalid and also currency is in USD ,so we need to convert it into INR as in finding insight it will be problematics(total sum of revenue)</p><pre><br># Markets in regions<br>SELECT * FROM sales.markets;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/676/1*IWE59Ni7zjBmndC6VYzmTA.jpeg" /></figure><p><strong>Observation-</strong> Company is doing Sales in India and also might have done in New York and Paris for 1–2 time , so here we will remove it because right now company is doing business only in India so these data are not useful.</p><p><strong>To see Few more query which can be helpful to understand your data- </strong><a href="https://github.com/monalishakumari/SalesInsight-AtilQ/blob/master/companysales.sql"><strong>SQL File.</strong></a></p><h4>4. Data Cleaning and ETL</h4><p>Now we will pull data into Power BI and also do <strong>Data Cleaning known as ETL</strong>(<em>Extract Transform and Load</em>).</p><p>We need to transform data as it is messy and need to convert into different format so that we can perform Data Analysis in Power BI.</p><p><strong>Get data →More Option →Databases →MySQL database</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/580/1*JU3K8bDQdaNMY_3pMbVk_A.jpeg" /></figure><p><strong>→Now Enter your server and database name and connect it with your database.</strong></p><p><strong>→Load all the data</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/845/1*H8YzEz0RvUcxrIawPZ1MbQ.jpeg" /></figure><p><strong>→Now, Transform Data which will launch into Power Query Editor where we will do Data Cleaning .</strong></p><p>In <strong>sales.market table</strong>, we need to remove New York and Paris, and for that we will remove the blank from zone column and that will filter out .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*DgGsdpqBvhYiFoFgw-KxLg.jpeg" /></figure><p>In <strong>transaction table</strong> , we will remove 0 and -1 from sales_amount as we can see that in below picture that-</p><p>5 sales qty done but sales_amount = 0 which is illogic and there are only 2 product which sales qty is -1</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/913/1*1Eg6Pz4FSHL01vKkmxJUnw.jpeg" /></figure><p>Filtering everything which has -1 and 0</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1010/1*8XK-U_t4nRQsfwkCRZqheg.jpeg" /></figure><p><strong>Convert USD into INR</strong>-</p><p>Add new column →Conditional column →normalized currency where sales amount will be in INR</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/827/1*zpCEgkT3O6TAfgqnQrPp9g.jpeg" /></figure><p>Also in sales.date table, convert date format into mmm-yy for better visualisation</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/828/1*QSWPXgMbUrvwdc5LPNxtQA.jpeg" /></figure><p>If you explore the data , you fill find that there are duplicates of USD and INR</p><pre>SELECT count(*) from sales.transactions where sales.transactions.currency=&quot;INR\r&quot;; <br>#150000 - cant removed as it is large amount<br><br>SELECT count(*) from sales.transactions where sales.transactions.currency=&quot;INR&quot;; <br>#279 -we can remove it as it is small record and can be considered as bad data<br><br>SELECT count(*) from sales.transactions where sales.transactions.currency=&quot;USD\r&quot;; <br># 2 <br><br>SELECT count(*) from sales.transactions where sales.transactions.currency=&quot;USD&quot;; <br># 2 </pre><pre>#LET SEE USD AND USD/r RECORDS <br><br>SELECT * from sales.transactions where sales.transactions.currency=&#39;USD\r&#39; or sales.transactions.currency=&#39;USD&#39;;</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/669/1*nZzG3hv8QAzJ7MO1zeI7zg.jpeg" /><figcaption>Duplicates</figcaption></figure><p>So we can see that it is duplicate and for analysis its better to delete anyone of them so lets delete USD and keep USD/r .</p><p><strong>Finally we will keep data with INR/r and USD/r-</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qG8BihPwklYAlrJqeiAhTg.jpeg" /></figure><h4>5. Build Dashboard</h4><p>Create Measure table →where we will use DAX Formula</p><pre>Profit Margin % = DIVIDE([Total Profit Margin],[Revenue],0)<br><br>Profit Margin Contribution % = DIVIDE([Total Profit Margin],CALCULATE([Total Profit Margin],ALL(&#39;sales products&#39;),ALL(&#39;sales customers&#39;),ALL(&#39;sales markets&#39;)))<br><br>Revenue = SUM(&#39;Sales transactions&#39;[norm_sales_amount])<br><br>Revenue Contribution % = DIVIDE([Revenue],CALCULATE([Revenue],ALL(&#39;sales products&#39;),ALL(&#39;sales customers&#39;),ALL(&#39;sales markets&#39;)))<br><br>Sales Qty = SUM(&#39;sales transactions&#39;[sales_qty])<br><br>Total Profit Margin = SUM(&#39;Sales transactions&#39;[Profit_Margin])</pre><p><strong>Visualization -</strong></p><p><em>Total Revenue</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vRSKeENK_lJi7raz4ODb9g.jpeg" /></figure><p><em>Total Sales Qty</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CD2W8pNsvJinxFlRPrEweg.jpeg" /></figure><p><em>Total Profit Margin</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*-Xt5AzjOLC_uuY9gb17a4A.jpeg" /></figure><p><em>Revenue by Market</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*bA2WERnJ6FugzYmtHkZ-QQ.jpeg" /></figure><p><em>Sales Qty by Market</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*8t3AIsdzRnQYTE3yI09qwA.jpeg" /></figure><p><em>Top Five Customer</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JZKFsoYV5VrCaJ9n6_C1RA.jpeg" /></figure><p><em>Top Five Product</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*A95pvx1jfjpaBETK1-C9pQ.jpeg" /></figure><p><em>Revenue Trend</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*j7gpUoAIGHoDu4zOKCdpQw.jpeg" /></figure><p><em>Finally ,You can access to </em><a href="https://github.com/monalishakumari/SalesInsight-AtilQ/blob/master/salesinsight.pbix"><strong><em>Dashboard</em></strong></a><strong><em> </em></strong><em>and to check other files click on -</em><strong><em> </em></strong><a href="https://github.com/monalishakumari/SalesInsight-AtilQ/tree/master"><strong><em>Git hub Link</em></strong></a><strong><em> .</em></strong></p><h3>Conclusion-</h3><blockquote>If you check the dashboard, you will come to know that Sales are declining and now sales director will come to know in which region sales are high and sales are low so that they can work on the product and enhance their business in this dynamically growth market.</blockquote><p>I hope you like this project and will be helpful for your better understanding of Data Analysis .</p><p><strong>Keep Learning and Keep Growing…</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fcdba22baf85" width="1" height="1" alt=""><hr><p><a href="https://blog.devgenius.io/project-sales-insights-of-atliq-hardware-fcdba22baf85">Project- Sales Insights of AtliQ Hardware</a> was originally published in <a href="https://blog.devgenius.io/">Dev Genius</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Project : YouTube Channel Insights using API]]></title>
            <link>https://blog.devgenius.io/project-youtube-channel-insights-using-api-5523f4158ed6?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/5523f4158ed6</guid>
            <category><![CDATA[projects]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[youtube]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[data-analyst]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Tue, 07 Feb 2023 18:02:53 GMT</pubDate>
            <atom:updated>2023-02-08T13:28:39.883Z</atom:updated>
            <content:encoded><![CDATA[<h3>Project : YouTube Channel Insights using API</h3><p>Built a <strong>Data Analyst Project </strong>using Python programming to <strong>scrape, analyze and visualize</strong> youtube channel data .</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/700/1*X5eJe_lPH_MnKKOlLrGZDQ.jpeg" /></figure><h3>Lets understand in step-wise:</h3><h4><em>1. Create Youtube API Key to access data</em></h4><p>→Visit <a href="https://console.developers.google.com/">https://console.developers.google.com/</a></p><p>→Select a project or create a project and give name to it — <strong><em>YT Analysis</em></strong></p><p>→Then go to library — search youtube data api</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9z82yqiM3fcZNoUZj5sJ2A.jpeg" /></figure><p>→And enabled the API</p><p>→Then Go to Credential and create credential-API Key</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/674/1*zbtapaNP5V7v_yJX8id79Q.jpeg" /></figure><h4><em>2. Used Youtube Data API Documentation to use — API Key for accessing different youtube data</em></h4><p>→Link-<a href="https://developers.google.com/youtube/v3">https://developers.google.com/youtube/v3</a></p><p>→Click Reference</p><p>→Example- if want to see the channel statistics then click channel –&gt;list</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*E1SFkZJvahZW_WbRYwuWnw.jpeg" /></figure><p>→We can access this list by providing channel id , username etc</p><p>→If we click on <strong>list(by channel id)</strong>- we can see in detail on how to use this method using different language.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*9izTL5OYoPaUmwNjnKajAA.jpeg" /></figure><p>→Similarly if want to access video detail — we will follow same steps</p><h4><em>3. Install python packages –</em></h4><p><em>· </em>google-api-python-client<em>(google python packages: to access youtube API data)</em></p><p><em>· </em>pandas<em>(to load data into structured format)</em></p><p><em>· </em>seaborn(<em>for visualization</em>)</p><h4><em>4. Scrape channel statistics from youtube</em></h4><p>To scrape channel statistics — we need to gathered channel id of youtubers . Here I have collected id of my favourite youtuber .</p><p><strong>How to get channel Id-</strong></p><p>→Just click on channel of your favourite youtuber- check search bar</p><p>→In the link , you will see the channel id at the end</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*NeOLixsOiMABIxbR3yyK7Q.jpeg" /></figure><p>→Gathered all the id of youtube channel</p><pre>channel_ids = [&#39;UCNU_lfiiWBdtULKOw6X0Dig&#39;, #KrishNaik<br>              &#39;UC7cs8q-gJRlGwj4A8OmCmXg&#39;, #Alex the analyst<br>              &#39;UC8uU_wruBMHeeRma49dtZKA&#39;, #chandoo<br>              &#39;UCeVMnSShP_Iviwkknt83cww&#39;, #CodeWithHarry<br>              &#39;UCmXZxX_qexEZxhb5_vQKPCw&#39; #Aman dhattarwal<br>             ] </pre><p>→Now, extracted details -<strong><em>youtube channel name, total no of subscribers, total views and total number of videos</em></strong> for each youtube channel.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*P1mNojGmLwuDf6iIjq-Ecg.jpeg" /></figure><p>→Then did comparision between all these youtuber channel <strong><em>on basis of views, subscriber, number of videos</em></strong> posted by them.</p><p><strong>Highest number of subscriber-</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/830/1*3QVoeyceRqG_1ZtY7mGv4g.jpeg" /><figcaption>Aman Dhattarwal has highest subscriber</figcaption></figure><p><strong>Highest number of views -</strong></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/854/1*_ue40OflG9SjkHlQsmZUug.jpeg" /><figcaption>CodeWithHarry has highest number of views</figcaption></figure><blockquote><strong>Observation-</strong> CodeWithHarry has highest number of views and we can also observe that aman dhattarwal was having higher subscriber but in views his channel is below CodeWithHarry. Therefore, no. of subscriber doesnt matter to get highest views on channel.</blockquote><h4><em>5. Scarpe video details for a particular youtube channel</em></h4><p>→As CodeWithHarry has highest number of views , so we will analyze the video detail of this channel.</p><p>→Here ,Extracted top videos with titles -likes, views and comments.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/803/1*0bXeq7wts0rmVHCcfXKP0g.jpeg" /></figure><p>→Created visualization using seaborn library</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1016/1*k1zWid0gfFZI8K-ev36zFg.jpeg" /></figure><blockquote><strong>Obervation-</strong> Python Tutorial for beginners in Hindi has performed really well as compared to other video</blockquote><h4><em>6. Exported video details data into CSV format</em></h4><p>→Finally,</p><pre># To export this video data into csv format<br>video_data.to_csv(&#39;Video_Detail{CodeWithHarry}.csv&#39;)</pre><p>To access the code for this project and know in detail- Visit <a href="https://github.com/monalishakumari/Youtube-channel-Insights"><strong>My Github Profile</strong></a></p><blockquote><strong>Hopefully, this article will be helpful in your data analyst journey and to build great portfolio <em>.</em></strong></blockquote><blockquote><strong><em>Keep Learning and Keep Growing…</em></strong></blockquote><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5523f4158ed6" width="1" height="1" alt=""><hr><p><a href="https://blog.devgenius.io/project-youtube-channel-insights-using-api-5523f4158ed6">Project : YouTube Channel Insights using API</a> was originally published in <a href="https://blog.devgenius.io/">Dev Genius</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Connecting MySQL Using Python]]></title>
            <link>https://blog.devgenius.io/connecting-mysql-using-python-45d4462128c5?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/45d4462128c5</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[data-science]]></category>
            <category><![CDATA[database]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Wed, 01 Feb 2023 17:37:33 GMT</pubDate>
            <atom:updated>2023-02-01T19:05:59.407Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/668/1*i0ejdKYdPuhZx6zwmiiGEQ.jpeg" /></figure><h3>Introduction-</h3><p>In this article you will be able to know:</p><ul><li>How to connect SQL and Python together</li><li>Able to Perform different queries of SQL using Python</li></ul><h3>What you will learn ?</h3><p><strong>How to establish communication between MySQL and Python in few steps-</strong></p><p><em>-Importing MySQL connector module</em></p><p><em>-Create connection</em></p><p><em>-Create a cursor or pointer</em></p><p><em>-Execute the query</em></p><p><em>-Fetch the data</em></p><ul><li><strong>Create new database</strong></li><li><strong>Create new table</strong></li><li><strong>Insert Record or Row</strong></li><li><strong>Insert Bulk data</strong></li><li><strong>Extract Particular Column from data</strong></li><li><strong>Delete Record or Row</strong></li><li><strong>Update Record or Row</strong></li><li><strong>Group by</strong></li><li><strong>Order by</strong></li><li><strong>Drop a table</strong></li><li><strong>Or Operators</strong></li><li><strong>Like Operator</strong></li><li><strong>Having Clause</strong></li><li><strong>Nested queries</strong></li><li><strong>Read data using Pandas</strong></li></ul><h3>Prerequisite-</h3><p>Before we start , we need to download MySQL and Jupyter Notebook in your local system of computer :</p><ul><li>Download MySQL from this link(<a href="https://www.mysql.com/downloads/"><em>https://www.mysql.com/downloads/</em></a>).</li><li>And to download Jupyter Notebbok — you can install anaconda using link(<a href="https://www.anaconda.com/"><em>https://www.anaconda.com/</em></a>) and then you can launch Jupyter Notebook.</li></ul><h3>Now Let’s Start-</h3><p><strong><em>Establish communication between MySQL and Python</em></strong></p><p>As we know that our python program will not understand anything except python language; so we need to install driver (python packages) which will connect MySQL and Python.</p><pre>!pip install mysql-connector-python</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*Vv-9vntiZcHPoLfgv09WZA.png" /></figure><p><strong><em>Now import MySQL connector</em></strong></p><pre>import mysql.connector as connec</pre><ul><li>After importing it, we need to now call host- to reach out your local system.</li><li>User and Password is used same; which we have used in our MySQL after installing.</li><li>Then, we will store into a variable called as my_db.</li></ul><pre>my_db=connec.connect(host=&#39;localhost&#39;,user=&#39;root&#39;,password=&#39;12345&#39;)</pre><p><strong><em>Create a cursor or pointer</em></strong></p><p><em>Pointer or location from where our system will start reading ,writing.</em></p><pre>cursor=my_db.cursor()</pre><p>If we want to see all the databases available on MySQL Workbench, then execute the query and fetch it.</p><pre>cursor.execute(&quot;show databases&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/650/1*jWZyI00iNMK2KBxdV7SM0w.png" /></figure><blockquote>Note -MySQL will only be able to store structured data(tabular format), not semi nor unstructured data. To know more in detail about MySQL , you can learn from the <a href="https://www.w3schools.com/MySQL/default.asp">website</a>.</blockquote><h3>1. Create new Database</h3><p>Here we will create a new database called<strong><em> testmona</em></strong> in three steps :</p><ul><li>Create cursor</li><li>Execute query</li><li>Fetch data</li></ul><pre>cursor=my_db.cursor()<br>cursor.execute(&quot;create database testmona&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/498/1*k81L2xT040y8XDa9GVaZQQ.png" /></figure><p><em>Our new </em><strong><em>database testmona </em></strong><em>has been created.</em></p><h3>2. Create new Table</h3><p>Here we will:</p><ul><li>Create a table inside our database testmona.</li><li>And to create a table, we need column name and its datatype with length.</li></ul><pre>cursor.execute(&quot;create table testmona.university(StudentId INT(10) , FirstName VARCHAR(30), LastName  VARCHAR(30), RegNo INT(10) , ClassName  VARCHAR(30))&quot;)</pre><p>To see whether our table is created or not , we can follow below steps-</p><pre>cursor.execute(&#39;use testmona&#39;)<br>cursor.execute(&#39;show tables&#39;)<br>cursor.fetchall()</pre><h3>3. Insert Record or Row</h3><p>To insert a record or row we will execute -</p><pre>cursor.execute(&#39;insert into testmona.university values(1001, &quot;Monalisha&quot;,&quot;Kumari&quot;,11809300,&quot;Python&quot;)&#39;)</pre><p>We need to commit our queries to get the output in your SQL Workbench.</p><pre>my_db.commit()</pre><blockquote>Note- <em>Commit operation is applied for </em><strong><em>insertion, deletion and updation</em></strong><em>.</em></blockquote><pre>cursor.execute(&quot;select * from testmona.university&quot;)<br>cursor.fetchall()</pre><p>We can add similarly more records of data into our table by following above steps.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/861/1*Jr1CqR_82u_lZ38nWlj4xg.png" /></figure><h3>4. Insert bulk data</h3><p>In this section we will-</p><ul><li>We will download dataset (glass.data) from link-<a href="https://archive.ics.uci.edu/ml/machine-learning-databases/glass/"><em>https://archive.ics.uci.edu/ml/machine-learning-databases/glass/</em></a></li><li>Import csv</li><li>Create a table glassdata with column name and datatype</li><li>We will use for loop to insert many data in single code.</li></ul><pre>import csv<br>with open(&#39;glass.data&#39;,&#39;r&#39;) as f:<br>    g_data=csv.reader(f,delimiter=&#39;\n&#39;) #we store into variable g_data<br>    for i in g_data:<br>        print(i)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/889/1*KoPkLtzT5pYP1SQFSM_UDg.png" /></figure><pre>cursor.execute(&#39;create table testmona.glassdata(col1 INT(10),col2 float(10,5),col3 float(10,5),col4 float(10,5),col5 float(10,5),col6 float(10,5),col7 float(10,5),col8 float(10,5),col9 float(10,5),col10 float(10,5),col11 INT(10))&#39;)</pre><p>Now to insert data(glass.data) into table glassdata, we will use for loop :</p><pre>with open(&#39;glass.data&#39;,&#39;r&#39;) as f:<br><br>    g_data=csv.reader(f,delimiter=&#39;\n&#39;) #we store into variable g_data<br><br>    for i in g_data:<br><br>        print(i)<br><br>        print(f&#39;insert data into glassdata values ({str(i[0])})&#39;)<br><br>        cursor.execute(f&#39;insert into testmona.glassdata values ({str(i[0])})&#39;)<br><br>my_db.commit()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*qgRaXKaOpz5A-Zb09Kl0Rg.png" /></figure><h3>5. Extract Particular Column from data</h3><p>Here we will select the column which we want to fetch it from table:</p><pre>cursor.execute(&quot;select col1,col5,col10 from testmona.glassdata&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/630/1*kbxe3phfcZclr-cPnYk8RQ.png" /></figure><p>If you want to extract particular column where value is 4:</p><pre>cursor.execute(&quot;select * from testmona.glassdata where col1 =4 &quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/852/1*GpwVpgjfB_ipItAaMuqASQ.png" /></figure><h3>6. Delete Record or Row</h3><p>To delete a record where column 1 is 4:</p><pre>cursor.execute(&quot;delete from testmona.glassdata where col1 =4 &quot;)</pre><p>Now we need to commit -</p><pre>my_db.commit()</pre><h3>7. Update Record or Row</h3><p>Here we will update a row — column1 value is 6 , column2 value is 8 where column1 =1</p><pre>cursor.execute(&quot;UPDATE testmona.glassdata SET col1=6,col2=8 where col1=1&quot;)<br>my_db.commit()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*w89Cs5RwzVUX-B2KKWAS3Q.png" /></figure><h3>8. Group by</h3><p>If we want to know how many times col1 value is appeared same-</p><pre>cursor.execute(&quot;select col1, count(col1),col11 from testmona.glassdata group by col1&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/691/1*EFufYMtcfOn87VkNOesHlg.png" /></figure><p>We can see that col1=6 has appeared 3 times in a table. Similarly you can check for others.</p><h3>9. Order by</h3><p>Here we will see required output in order wise-</p><pre>cursor.execute(&quot;select col1, count(col1),col11 from testmona.glassdata group by col1 order by col1&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/458/1*33Z01jdO9frzi8bDxwktmQ.png" /></figure><h3>10. Drop a table</h3><p>To delete a table or drop it -</p><pre>cursor.execute(&quot;drop table testmona.university&quot;)<br>my_db.commit()</pre><h3>11. Or Operators</h3><p>To fetch all the data where column1=11 or column11=2</p><pre>cursor.execute(&quot;select col1, col2, col11 from testmona.glassdata where col1=11 or col11=2 &quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/614/1*yKw2t2io-u0Z0evEVJwSHw.png" /></figure><p><em>These are the data where col1=11 or col11=2</em></p><h3>12. Like Opeartor</h3><p>If we want to fetch a data of column2 where value starts with 1.515 and ends with any number, then like operator is used.</p><pre>cursor.execute(&quot;select * from testmona.glassdata where col2 LIKE &#39;1.515%&#39;&quot;)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*lpHTCJf7oxtZ2pNVcCnJmw.png" /></figure><p>To know more about Like clause , you can visit this <a href="https://www.w3schools.com/sql/sql_like.asp">link</a>.</p><h3>13. Having Clause</h3><p>To extract data where col1 value occurs more than 2:</p><pre>cursor.execute(&quot;select *from testmona.glassdata group by col1 having count(col1)&gt;2&quot;)<br><br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*wrdaeFRL84toSNP5OZxZnQ.png" /></figure><p><em>There is only one column whose count is more than two times.</em></p><h3>14. Nested queries</h3><p>This is example where we have write a query inside query.</p><pre>cursor.execute(“select * from (select * from testmona.glassdata where col1&gt;112)as abc where col11=3”)<br>cursor.fetchall()</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*FdKT5cbTb-OAdDncP7yglA.png" /></figure><h3>15. Read data using Pandas</h3><p>There is library of Python called Pandas which is useful tool for data analyst or data scientist to read data .</p><p>To read data using pandas into structured format-</p><pre>import pandas as pd</pre><pre>pd.read_sql(&quot;select * from testmona.glassdata&quot;,my_db)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/853/1*sddI4l3GzvEHEtLRw4VF7Q.png" /></figure><p>We can also read database using panda:</p><pre>pd.read_sql(&quot;show databases&quot;,my_db)</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/339/1*0BKrpl9A2XKqEvHhLaJ71g.png" /></figure><blockquote><strong>Conclusion-</strong></blockquote><blockquote>In this article we learnt about SQL connecting using connector python. Created database , table and also inserted single/many record at a time. Performed different query using clauses, group by and order by statements. Also used nested queries and read data using python library i.e Pandas.</blockquote><p><strong>I hope you like this article.</strong></p><p><strong>Keep Learning and Keep Growing..</strong></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=45d4462128c5" width="1" height="1" alt=""><hr><p><a href="https://blog.devgenius.io/connecting-mysql-using-python-45d4462128c5">Connecting MySQL Using Python</a> was originally published in <a href="https://blog.devgenius.io/">Dev Genius</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Project-Linkedin Insight with Power BI Visualisation]]></title>
            <link>https://blog.devgenius.io/project-linkedin-insight-with-power-bi-visualisation-c25410acbb13?source=rss-8de67a66d72d------2</link>
            <guid isPermaLink="false">https://medium.com/p/c25410acbb13</guid>
            <category><![CDATA[power-bi-project]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[power-bi]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[linkedin]]></category>
            <dc:creator><![CDATA[Monalisha Kumari]]></dc:creator>
            <pubDate>Thu, 26 Jan 2023 08:05:42 GMT</pubDate>
            <atom:updated>2023-01-26T15:11:13.029Z</atom:updated>
            <content:encoded><![CDATA[<h3>Project-Linkedin Insight with Power BI Visualization</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/520/1*yDk9oxu_eUio6bcOpgUlrw.jpeg" /><figcaption><strong>Linkedin Insight Of My Profile</strong></figcaption></figure><p>Before starting , I would like to know you that since a week I am learning power bi visualization tool and was trying to do different kind of projects with Power BI . So randomly I was searching videos on youtube for projects in power bi.</p><p>And I came to know about a video with <strong><em>Title- </em></strong><em>Linkedin Resume with Power BI.</em> After watching a full video of 7–8 mins , I thought to give it a try as it sounds so interesting.</p><p>If you also want to know which video I have seen — then refer this<strong> </strong><a href="https://www.youtube.com/watch?v=ufGN2AMkyj0"><strong>link</strong></a><strong>.</strong></p><h4>Now lets start with the steps to make this fun project-</h4><h4>1. Collection of data from your linkedin profile</h4><p>· <em>Go to me-Settings and Privacy</em></p><p><em>· Click Data privacy</em></p><p><em>· Then Click to -get a copy of your data</em></p><p><em>· And request for data</em></p><p><em>· Data will be available in few hours(you will receive the email notification).</em></p><p><em>· After receiving the mail, you visit to same place where you requested to get a data.</em></p><p><em>· You will see download option.</em></p><h4>2. After collection , now get the data into power bi desktop</h4><p><strong>Note-</strong> I made this linkedin insight using two csv file only (<strong><em>i.e Connection.csv and messages.csv</em></strong>). You can use more table to get more insights of your profile.</p><h4>3. After getting data into power bi, I choose transform data- which take me to power bi query editor page- where I did few cleaning of data , analyse data and then finally load into it by clicking — Close and Apply.</h4><h4>4. Before moving into visualisation part:</h4><p>· I created one table named- <strong>Date</strong> to make relation with my table named- Connections</p><blockquote>Steps to create date table</blockquote><blockquote>Click on data tab</blockquote><blockquote>Write DAX Formula and do enter</blockquote><blockquote>And also marked as date table to get best time intelligence result.</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_Ave5x5cxMECt9qDr9xSuQ.jpeg" /><figcaption><strong>DAX Formula</strong> to create <strong>Date</strong> table</figcaption></figure><p>· Another table which I created is <strong>Measures </strong>— where I will write all DAX formula separately for better visualization<em>.</em></p><h4>5. DAX Formula which I used here-</h4><blockquote>Total Connections = COUNT(Connections[First Name])</blockquote><blockquote>Total Companies = DISTINCTCOUNT(Connections[Company])</blockquote><blockquote>Message Sent =CALCULATE(COUNTA(messages[FROM]),FILTER(messages,messages[FROM]=”Monalisha Kumari”))</blockquote><blockquote>Message Received = CALCULATE(COUNT(messages[FROM]),NOT(messages[FROM]=”Monalisha Kumari”))</blockquote><h4>6. After getting all our data finalised , now lets start with visualization part-</h4><p><em>You can refer images which I took screenshort to let you know which visualization I choose for which parameter with values required .</em></p><h4>Year</h4><p>(to go through all year from the date we started our linkedin account to till now)</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1015/1*JAFLFfAyqsjTZnYt1Sa-0Q.jpeg" /><figcaption>Visualization used- Slicer</figcaption></figure><h4>Total Connection and Total Company</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/655/1*8yX0ZjHxCN-y83iRIpkdiw.jpeg" /><figcaption>Visualization used- Card</figcaption></figure><h4>Connection made in per month</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5NFRreeb-cnZ3eSWP7C5fw.jpeg" /><figcaption>Visualization used-Area Chart</figcaption></figure><h4>Connection per company</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PCLvdyMnMXXyYp2lBIybLQ.jpeg" /><figcaption>Visualization used- Stacked bar chart</figcaption></figure><h4>Position of Connection</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*6R6O72lM4Col9c3ixtEvRA.jpeg" /><figcaption>Visualization used-Stacked bar chart</figcaption></figure><h4>Message received and sent</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OaLZgDk0JdVCTnCsY5q6MQ.jpeg" /><figcaption>Visualization used-Donut Chart</figcaption></figure><p><strong><em>Additional- </em></strong>You can also create visualization showing —<strong><em> total invitation sent and received</em></strong> used invitation.csv file which you downloaded from linkedin.</p><p>7. Lastly, I will suggest you to play with your creativity -to make it attractive and meaningful dashboard for yourself .</p><p>I hope you enjoyed making this project which is not only exciting and interesting but also good for resume.</p><p><strong><em>Keep Learning and Keep Growing…</em></strong></p><p>Linkedin profile- <a href="https://www.linkedin.com/in/monalishakumari/">Monalisha Kumari</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=c25410acbb13" width="1" height="1" alt=""><hr><p><a href="https://blog.devgenius.io/project-linkedin-insight-with-power-bi-visualisation-c25410acbb13">Project-Linkedin Insight with Power BI Visualisation</a> was originally published in <a href="https://blog.devgenius.io/">Dev Genius</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>