<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>DEV Community: Stephen Githinji</title>
    <description>The latest articles on DEV Community by Stephen Githinji (@stephen_githinji_).</description>
    <link>https://dev.to/stephen_githinji_</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3708622%2F17a4bd78-0eba-42ca-8593-bdc5d7298f2c.png</url>
      <title>DEV Community: Stephen Githinji</title>
      <link>https://dev.to/stephen_githinji_</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/stephen_githinji_"/>
    <language>en</language>
    <item>
      <title>Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Tue, 10 Nov 2026 14:19:53 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/building-an-interactive-excel-dashboard-for-e-commerce-product-analysis-a-case-study-of-jumia-22fm</link>
      <guid>https://dev.to/stephen_githinji_/building-an-interactive-excel-dashboard-for-e-commerce-product-analysis-a-case-study-of-jumia-22fm</guid>
      <description>&lt;h2&gt;
  
  
  List of Contents
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Introduction&lt;/li&gt;
&lt;li&gt;Prerequisites&lt;/li&gt;
&lt;li&gt;Data Cleaning and Transformation&lt;/li&gt;
&lt;li&gt;Data Analysis&lt;/li&gt;
&lt;li&gt;Data presentation and dashboard development&lt;/li&gt;
&lt;li&gt;Findings and recommendations&lt;/li&gt;
&lt;li&gt;Conclusion&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;Excel is widely known for its ability to organize data and perform numerous calculations using its extensive range of formulas and functions. However, it can also be used to extract meaningful analytical insights from data, helping drive informed decisions within an organization. This article provides a step-by-step guide on carrying out product analysis using Excel. By the end of this article, you will have developed an interactive dashboard and extracted meaningful findings from the provided dataset.&lt;/p&gt;

&lt;h2&gt;
  
  
  prerequisites
&lt;/h2&gt;

&lt;ol&gt;
&lt;li&gt;Install Excel&lt;/li&gt;
&lt;li&gt;Basic Excel knowledge&lt;/li&gt;
&lt;li&gt;Download the raw CSV file from GitHub: &lt;a href="https://github.com/stephen-githinji/Jumia_Products_Performance_Dashboard/blob/main/raw_excel_jumia_dataset.csv" rel="noopener noreferrer"&gt;raw_excel_jumia_dataset.csv&lt;/a&gt;
&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Data Cleaning and Transformation
&lt;/h2&gt;

&lt;p&gt;Before analysis, the data must be cleaned and transformed to align with the format and business requirements. The most commonly used tool for cleaning and transformation is &lt;a href="https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query" rel="noopener noreferrer"&gt;&lt;strong&gt;Power Query&lt;/strong&gt;&lt;/a&gt;. The following are the steps that we will carry out to ensure that our dataset is clean and ready for analysis:&lt;br&gt;
1. Creating an Excel table&lt;br&gt;
2. Removing duplicate and missing values&lt;br&gt;
3. Handling numerical value formats&lt;br&gt;
4. Enriching the dataset&lt;/p&gt;
&lt;h3&gt;
  
  
  1. Creating an Excel table
&lt;/h3&gt;

&lt;p&gt;Excel tables are easier to work with when it comes to data management and filtering. To create an Excel table, navigate to &lt;code&gt;Data &amp;gt; Get &amp;amp; Transform Data&amp;gt; From Table/Range&lt;/code&gt; This consequently opens a &lt;strong&gt;power query window&lt;/strong&gt;.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fbtvbf8u5fv44h3uq9kt3.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fbtvbf8u5fv44h3uq9kt3.png" alt="excel table" width="797" height="120"&gt;&lt;/a&gt;&lt;/p&gt;
Creating an Excel Table



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft9oojgcvfllx7idqawp6.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft9oojgcvfllx7idqawp6.png" alt="power query window" width="800" height="368"&gt;&lt;/a&gt;&lt;/p&gt;
Power Query Window


&lt;h3&gt;
  
  
  2. Removing duplicate and missing values
&lt;/h3&gt;

&lt;p&gt;Inside the Power Query window, navigate to &lt;code&gt;Home &amp;gt; Remove Rows &amp;gt; Remove Duplicates&lt;/code&gt; to delete repeating rows. Initially, our data contained 115 rows, but after deleting the duplicates, we are left with 109 rows. Therefore, 6 duplicate rows have automatically been identified and deleted. This change is then recorded, as with all other changes that we will perform later on, in the &lt;code&gt;Applied Steps&lt;/code&gt; panel on the right-hand side of the window.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fr8cepe2fnruhv5liisab.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fr8cepe2fnruhv5liisab.png" alt="table with duplicates" width="800" height="379"&gt;&lt;/a&gt;&lt;/p&gt;
Table with duplicates



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F0r6w3u2t3d59qjwzg23n.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F0r6w3u2t3d59qjwzg23n.png" alt="table without duplicates" width="800" height="380"&gt;&lt;/a&gt;&lt;/p&gt;
Table without duplicates



&lt;p&gt;For our data, we are going to replace blanks with 0 for the reviews column only. To do so, select the reviews column, then navigate to &lt;code&gt;Home &amp;gt; Transform &amp;gt; Replace values&lt;/code&gt;. A pop-up window will appear where you will provide the value to be replaced and the one replacing it. In our case, null(which indicates blanks in Power Query) and 0, respectively.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fylk1c3ykbehkfpz1stmt.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fylk1c3ykbehkfpz1stmt.png" alt="Replace values" width="797" height="116"&gt;&lt;/a&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F87z17ur0dwxemhe7g3pi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F87z17ur0dwxemhe7g3pi.png" alt="replacing blanks" width="799" height="341"&gt;&lt;/a&gt;&lt;/p&gt;
Replacing blanks in reviews column


&lt;h3&gt;
  
  
  3. Handling numerical value formats
&lt;/h3&gt;

&lt;p&gt;The next step is cleaning the numerical values in our dataset.  This includes removing currency prefixes in our price columns, handling ranges, removing the 'out of 5' statement in the ratings column, and removing negative values in the reviews column.&lt;br&gt;&lt;br&gt;
To remove currency prefixes, we will use the Replace Values feature. After selecting the price columns and clicking on the Replace Values feature, fill the "value to find" field with 'KSh ', and the "Replace field" should be left blank.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fdaq8wnk9ox0ct1bjzxcv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fdaq8wnk9ox0ct1bjzxcv.png" alt="removing currency prefixes" width="800" height="423"&gt;&lt;/a&gt;&lt;/p&gt;
Removing currency prefixes



&lt;p&gt;&lt;br&gt;&lt;br&gt;
Similarly, we can remove the "out of 5" statement in the ratings column to remain with the numeric ratings. Change the data type of the column to decimal after modifying.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fzrbtedb1zxm3vjeus23f.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fzrbtedb1zxm3vjeus23f.png" alt="Remove suffix" width="800" height="498"&gt;&lt;/a&gt;&lt;/p&gt;
Removing the "out of 5" statement



&lt;p&gt;&lt;br&gt;&lt;br&gt;
The number of reviews should be absolute values (0 and above). Given that our reviews column contains some negative values, we will need to make some modifications. This can be done by selecting the column and then clicking &lt;code&gt;Transform &amp;gt; Number Column &amp;gt; Scientific &amp;gt; Absolute Value&lt;/code&gt;. This will convert all the negative values to positive.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft33h8c1ckc2vtqakxsa7.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ft33h8c1ckc2vtqakxsa7.png" alt="absolute value" width="800" height="148"&gt;&lt;/a&gt;&lt;/p&gt;
Absolute Value



&lt;p&gt;&lt;br&gt;&lt;br&gt;
Range can be handled in different ways depending on your analytical needs and their effect on your analysis. In our case, we will split the price columns into separate maximum and minimum price columns, then create an average column that will serve as the representative price for our analysis. Since the range appears in only a few columns, averaging the prices will have a limited impact on our analysis.&lt;br&gt;&lt;br&gt;
To create a minimum current price column, we will use the &lt;code&gt;Add Column &amp;gt; Column from examples &amp;gt; From Selection&lt;/code&gt; feature. Once the "Add Column From Examples" window opens, select the current price column and navigate to the row containing the range. In the new column, insert the first value from the range (before the delimiter), then press Enter. The corresponding values for the other rows will be auto-filled. Click OK and rename the column accordingly (Minimum current price).&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fvgzyaajqgxmftwrvujse.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fvgzyaajqgxmftwrvujse.png" alt="Add column" width="800" height="255"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fahgpv3gzsr8loka6yibp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fahgpv3gzsr8loka6yibp.png" alt="Minimum price column" width="800" height="258"&gt;&lt;/a&gt;&lt;/p&gt;
Adding the minimum price column



&lt;p&gt;For the maximum current price column, repeat the same steps as above. However, since the values extracted are after the delimiter, values in the new column that correspond to rows without ranges will be blank. To ensure that the column retains the values in current price for rows that do not have price ranges, we will create a conditional column to capture this logic. We will use the &lt;code&gt;Add Column &amp;gt; Conditional column&lt;/code&gt; feature. After creating the conditional column, delete the column with the blank maximum prices.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fvg7ws72myg5etxbdkgzg.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fvg7ws72myg5etxbdkgzg.png" alt="Conditional column" width="800" height="81"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fi3c64lrecmsqmkockf39.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fi3c64lrecmsqmkockf39.png" alt="conditional column definition" width="800" height="337"&gt;&lt;/a&gt;&lt;/p&gt;
Conditional column



&lt;p&gt;To create the average current price column, navigate to &lt;code&gt;Add Column &amp;gt; Custom Column&lt;/code&gt; and insert the following formula:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;([Minimum current price] + [Maximum current price]) / 2
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftypf9sb0336etotqce6j.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftypf9sb0336etotqce6j.png" alt="custom column" width="800" height="82"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F3vns80883icdnoy2e957.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F3vns80883icdnoy2e957.png" alt="average price formula" width="800" height="506"&gt;&lt;/a&gt;&lt;/p&gt;
Average current price formula



&lt;p&gt;Repeat the above steps to handle range values in the old price column.&lt;br&gt;
The following represents how the columns should look:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ffm81ayrwmhehpwrjv0ad.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ffm81ayrwmhehpwrjv0ad.png" alt="handling range" width="800" height="294"&gt;&lt;/a&gt;&lt;/p&gt;
Handling Range



&lt;h3&gt;
  
  
  4. Enriching the dataset
&lt;/h3&gt;

&lt;p&gt;For our analysis, we are going to add 4 categorical columns: &lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Rating (Poor below 3, Average from 3 to 4, Good from 4 to 4.5, Excellent above 4.5)&lt;/li&gt;
&lt;li&gt;Discount (Low below 20%, Medium 20% to 40%, High above 40%)&lt;/li&gt;
&lt;li&gt;Price (Affordable 1000 to 3000, mid range above 3000, budget below 1000)&lt;/li&gt;
&lt;li&gt;Engagement (low below 10, moderate 10 to 30, high above 30).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;To create these columns, we will use the &lt;code&gt;Add column &amp;gt; General &amp;gt; conditional column&lt;/code&gt; feature. For each column, we will be able to provide the relevant conditions and the expected values.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5uvyojxdp2b8qb3zv0x1.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F5uvyojxdp2b8qb3zv0x1.png" alt="rating category" width="800" height="421"&gt;&lt;/a&gt;&lt;/p&gt;
Creating the rating category column



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fo0m19m3kyyf78ffhl8r2.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fo0m19m3kyyf78ffhl8r2.png" alt="discount category" width="800" height="366"&gt;&lt;/a&gt;&lt;/p&gt;
Creating the discount category column



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fq0o1hkq5lvbflxnosukc.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fq0o1hkq5lvbflxnosukc.png" alt="price category" width="799" height="362"&gt;&lt;/a&gt;&lt;/p&gt;
Creating the price category column



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fy1tp7x1xmj5gaphc9x8x.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fy1tp7x1xmj5gaphc9x8x.png" alt="engagement column" width="800" height="366"&gt;&lt;/a&gt;&lt;/p&gt;
Creating the Engagement column



&lt;p&gt;&lt;br&gt;&lt;br&gt;
After completing all the transformations, click the &lt;code&gt;Home &amp;gt; Close and load&lt;/code&gt; icon to apply the changes to the table.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxc6vzaddt0i8368f9afb.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxc6vzaddt0i8368f9afb.png" alt="Close and Load" width="795" height="82"&gt;&lt;/a&gt;&lt;/p&gt;
close power query and apply changes to the table



&lt;h2&gt;
  
  
  Data Analysis
&lt;/h2&gt;

&lt;p&gt;Our table is now clean and ready for analysis. For our analysis, we will carry out the following tasks:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Obtain some general descriptive statistics like averages, maximums, minimums, and totals.&lt;/li&gt;
&lt;li&gt;Find the top 10 products based on discount, ratings, and reviews.&lt;/li&gt;
&lt;li&gt;Find the bottom 5 products based on discount, ratings, and reviews.&lt;/li&gt;
&lt;li&gt;Correlation analysis investigating the relationships between reviews and discount, reviews and ratings, and ratings and reviews.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Excel's &lt;a href="https://www.w3schools.com/excel/excel_table_pivot_intro.php" rel="noopener noreferrer"&gt;&lt;strong&gt;pivot tables&lt;/strong&gt;&lt;/a&gt; make it easy for analysts to obtain various statistics from a dataset. To create a pivot table from the transformed table, navigate to &lt;code&gt;Insert &amp;gt; Pivot table&lt;/code&gt;, choose the table range, select a new worksheet to create the table on a new worksheet, then click OK. A new worksheet will open containing a pivot table.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fz179sc9csmux4dhstw4n.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fz179sc9csmux4dhstw4n.png" alt="pivot table icon" width="798" height="86"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F2jg8mqyhndrhq82pl87i.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F2jg8mqyhndrhq82pl87i.png" alt="pivot table pop-up" width="799" height="234"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fq50ge714jud1rrujzfmj.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fq50ge714jud1rrujzfmj.png" alt="pivot table" width="799" height="235"&gt;&lt;/a&gt;&lt;/p&gt;
creating a pivot table



&lt;h3&gt;
  
  
  Descriptive statistics
&lt;/h3&gt;

&lt;p&gt;Here we will extract some general statistics from our dataset: Total products, Average prices, average ratings, average discount, and max and min prices.&lt;br&gt;
To be able to obtain these statistics from the pivot table, drag and drop the relevant columns to the Values field in the pivot table fields list (located on the right-hand side of the worksheet). You can also change to use rows rather than columns to present your data, or change the automatically generated names for your values.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F75fumegtp8bc7sx79rky.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F75fumegtp8bc7sx79rky.png" alt="pivot table fields" width="525" height="664"&gt;&lt;/a&gt;&lt;/p&gt;
 Pivot table fields list



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fujeo0mznm9vn4yrdvacn.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fujeo0mznm9vn4yrdvacn.png" alt="General statistics" width="799" height="287"&gt;&lt;/a&gt;&lt;/p&gt;
 General statistics generated by the pivot table



&lt;p&gt;&lt;br&gt;&lt;br&gt;
To filter the top-10 products, create another pivot table from the clean table and insert it into a different part of the same worksheet as the previous pivot table. Drag and drop the filtering column (discount, ratings, or reviews) into the Values field, place the products column in the Rows field, and then filter the products using the top-10 option. Use different pivot tables for each filtering column.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fcq17n0wtkxul5hfging4.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fcq17n0wtkxul5hfging4.png" alt="products by discount" width="798" height="175"&gt;&lt;/a&gt;&lt;/p&gt;
products by discount



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxf4jrn83fs2snh958lfo.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fxf4jrn83fs2snh958lfo.png" alt="top-10 products" width="800" height="302"&gt;&lt;/a&gt;&lt;/p&gt;
filtering top-10 products



&lt;p&gt;The same approach can be used to filter the bottom 5 products.&lt;/p&gt;

&lt;h4&gt;
  
  
  Correlation Analysis
&lt;/h4&gt;

&lt;p&gt;This involves creating scatter plots in order to determine the relationship between variables within the dataset. Since pivot tables do not support the creation of scatter plots, a helper table referencing a pivot table will be required. &lt;br&gt;
For our analysis, we will check the correlation between reviews and discount, reviews and ratings, and ratings and reviews.&lt;br&gt;
The first step is creating a pivot table that contains the columns that will be used in the analysis. By using the XLOOKUP function or directly referencing the pivot table cells, create a helper table that will be used for analysis.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fn9h23l2nz3inzfdltziw.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fn9h23l2nz3inzfdltziw.png" alt="pivot table and helper table" width="800" height="380"&gt;&lt;/a&gt;&lt;/p&gt;
Pivot table and helper table



&lt;p&gt;To create the scatter plots, select the data range (from the helper table) that you want to include in the chart, e.g., (reviews and discount), then navigate to &lt;code&gt;insert &amp;gt; charts &amp;gt; scatter charts&lt;/code&gt;. Modify the scatter chart accordingly to indicate the axis labels and trendline.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F6b6ajl7xg1zjlrbg9lyv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F6b6ajl7xg1zjlrbg9lyv.png" alt="scatter plot" width="800" height="375"&gt;&lt;/a&gt;&lt;/p&gt;
selecting a scatter plot



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F7bcl5ep0ny2ct3dkcj20.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F7bcl5ep0ny2ct3dkcj20.png" alt="reviews vs discount" width="799" height="390"&gt;&lt;/a&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9aqdkddw2be7emlo65rj.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F9aqdkddw2be7emlo65rj.png" alt="reviews vs ratings" width="800" height="402"&gt;&lt;/a&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fi8y2v73jjmlttu4s9x0s.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fi8y2v73jjmlttu4s9x0s.png" alt="ratings vs price" width="799" height="386"&gt;&lt;/a&gt;&lt;/p&gt;
 scatter plots 



&lt;p&gt;In addition to the scatter plots, we can calculate the correlation between the variables using Excel's &lt;code&gt;CORREL()&lt;/code&gt; function. &lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fdh8s9bsgkl70ekaa9brz.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fdh8s9bsgkl70ekaa9brz.png" alt="correl function" width="800" height="722"&gt;&lt;/a&gt;&lt;/p&gt;
using the CORREL function



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fw4im4vxwnhhodu6de2ab.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fw4im4vxwnhhodu6de2ab.png" alt="correlation results" width="800" height="119"&gt;&lt;/a&gt;&lt;/p&gt;
correlation results



&lt;h2&gt;
  
  
  Data Presentation and Dashboard Development
&lt;/h2&gt;

&lt;p&gt;After carrying out the analysis, the next step is creating a dashboard. The dashboard will include KPIs, a product performance section, trends, and slicers.&lt;br&gt;
To create a KPI, we will use a combination of the rounded rectangular shape and text box, which can be found in &lt;code&gt;Insert&amp;gt; Illustrations&amp;gt; Shapes&lt;/code&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgzlkhhlv6nb9jwn478au.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgzlkhhlv6nb9jwn478au.png" alt="KPI tools" width="800" height="769"&gt;&lt;/a&gt;&lt;/p&gt;
A rounded rectangle and text box for KPIs



&lt;p&gt;For our dashboard, we will include the following KPIs: Total products, average price, average discount, average rating, and average reviews.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fqqf62g89ejnhc6nozrde.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fqqf62g89ejnhc6nozrde.png" alt="KPIs" width="800" height="79"&gt;&lt;/a&gt;&lt;/p&gt;
KPIs



&lt;p&gt;The Product performance section will include the top 10 products by discount, ratings, and reviews. Rather than just providing a list we will use the clustered bar chart. Select the data to represent and then navigate to &lt;code&gt;insert &amp;gt; charts &amp;gt; bar&lt;/code&gt;.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fz9x1fy8enaf9qg4vc2oi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fz9x1fy8enaf9qg4vc2oi.png" alt="clustered bar chart" width="800" height="478"&gt;&lt;/a&gt;&lt;/p&gt;
Clustered bar chart



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F48n9oivam913tsa9xdbp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2F48n9oivam913tsa9xdbp.png" alt="product performance section" width="799" height="199"&gt;&lt;/a&gt;&lt;/p&gt;
Product performance section



&lt;p&gt;The trends section includes the scatter plots we created during analysis.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Facmvv1gb5tznurwx2rt0.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Facmvv1gb5tznurwx2rt0.png" alt="Trends section" width="798" height="154"&gt;&lt;/a&gt;&lt;/p&gt;
Trends section



&lt;p&gt;Slicers are interactive filter buttons that filter data from your pivot tables. To create a slicer, navigate to your worksheet containing pivot tables, select one of the tables, then go to &lt;code&gt;Insert&amp;gt; Filter &amp;gt; Slicer&lt;/code&gt; and a slicer configuration window will pop up. Select the columns that you would want to use to filter your dashboard(in our case, ratings category, reviews category, price category, and engagements) and click OK.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fpf8p2820w29ie51iltpi.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fpf8p2820w29ie51iltpi.png" alt="Creating a slicer" width="800" height="528"&gt;&lt;/a&gt;&lt;/p&gt;
creating a slicer



&lt;p&gt;To make sure that the slicers can be used on all the pivot tables, right-click the slicer created and click on &lt;code&gt;Report connections&lt;/code&gt;, which will open up a list of pivot tables. Select all the pivot tables that are associated with your analysis, then click OK.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgr40abe4ggqblqkg4p7r.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fgr40abe4ggqblqkg4p7r.png" alt="Report connections" width="672" height="738"&gt;&lt;/a&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftyw1v9049ys2u6cpr0am.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Ftyw1v9049ys2u6cpr0am.png" alt="Pivot Table list" width="661" height="430"&gt;&lt;/a&gt;&lt;/p&gt;
Enabling a slicer to filter out all pivot tables



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fp19rd0connqj0yxft90r.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Fp19rd0connqj0yxft90r.png" alt="slicers" width="228" height="834"&gt;&lt;/a&gt;&lt;/p&gt;
Dashboard slicers



&lt;p&gt;All these sections put together form a comprehensive interactive dashboard&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Frnqjx0qphlv3zun9vyul.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.us-east-2.amazonaws.com%2Fuploads%2Farticles%2Frnqjx0qphlv3zun9vyul.png" alt="Final dashboard" width="799" height="372"&gt;&lt;/a&gt;&lt;/p&gt;
 Final dashboad



&lt;h2&gt;
  
  
  Findings and Recommendations
&lt;/h2&gt;

&lt;p&gt;After cleaning, analyzing, and developing the dashboard, the following are some findings and recommendations that can be derived:&lt;/p&gt;

&lt;h3&gt;
  
  
  Findings
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Reviews have a very weak positive relationship with discount (r=0.03). Consequently, a very tiny fraction of discounts affects reviews (R² = 0.00069).&lt;/li&gt;
&lt;li&gt;Ratings have a weak positive relationship with pricing (r=0.06). A small fraction of pricing affects reviews (R²= 0.0032).&lt;/li&gt;
&lt;li&gt;Some of the highly discounted products have poor ratings.&lt;/li&gt;
&lt;li&gt;Most of the highly discounted products have very low engagement.&lt;/li&gt;
&lt;li&gt;Products have both high engagement and excellent ratings.&lt;/li&gt;
&lt;/ol&gt;

&lt;h3&gt;
  
  
  Recommendations
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;Discounts should not be used as the primary engagement strategy.&lt;/li&gt;
&lt;li&gt;Pricing should be slightly considered alongside other factors to improve customer satisfaction.&lt;/li&gt;
&lt;li&gt;The pricing strategies for products with high discounts but poor ratings should be reviewed, and other factors, such as product quality, should be taken into consideration when trying to improve customer satisfaction.&lt;/li&gt;
&lt;li&gt;Avoid further discount increases and consider other strategies to improve the popularity of products with high discounts and low engagement.&lt;/li&gt;
&lt;li&gt;Investigate what makes products with high engagement and excellent ratings popular with customers and apply the findings to other related products&lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;In addition to Excel being a remarkable tool when it comes to working with spreadsheets and data organization in general, it can be leveraged to carry out end-to-end analytical projects on large datasets. By using Power Query in Excel, analysts can clean and transform data to suit their needs; pivot tables serve as useful tools when it comes to analyzing table data, and the myriad of charts offered in Excel, plus the different shapes and slicers, are used to create comprehensive interactive dashboards without the need to adopt third-party analytical tools.&lt;/p&gt;

</description>
      <category>excel</category>
      <category>dashboards</category>
      <category>analysis</category>
      <category>ecommerce</category>
    </item>
    <item>
      <title>Containerization With Docker</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Wed, 13 May 2026 19:34:36 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/containerization-with-docker-4ama</link>
      <guid>https://dev.to/stephen_githinji_/containerization-with-docker-4ama</guid>
      <description>&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;In the world of software development, it is all too common to come across the phrase: "&lt;em&gt;But it works on my machine!&lt;/em&gt;💻" This phrase is mainly associated with when developers are deploying their application for their users or a client, but the software fails to work as expected in production, yet it still works perfectly in development. &lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F31891ooohynzzip0hu3j.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F31891ooohynzzip0hu3j.png" alt="&amp;quot;But it works on my computer!&amp;quot; meme" width="800" height="400"&gt;&lt;/a&gt;&lt;br&gt;
This problem is mostly as a result of differences in the environment (The OS, runtime environment, and configurations) and dependency issues.&lt;br&gt;
Over the years, there have been various developments towards resolving this problem. For example, the development of &lt;a href="https://freebsdfoundation.org/freebsd-project/resources/introduction-to-freebsd-jails/" rel="noopener noreferrer"&gt;FreeBSD jails&lt;/a&gt;, &lt;a href="https://openvz.org" rel="noopener noreferrer"&gt;Open vz&lt;/a&gt;, and &lt;a href="https://linuxcontainers.org" rel="noopener noreferrer"&gt;Linux containers (LXC)&lt;/a&gt;. Although these advances embodied the idea of containerization, they were mostly designed for system administrators and not convenient for developers. It is not until the advent of &lt;a href="https://www.docker.com" rel="noopener noreferrer"&gt;&lt;b&gt;Docker&lt;/b&gt;&lt;/a&gt; that developers started employing containerization for their applications, bridging the development and production disconnect.&lt;/p&gt;
&lt;h2&gt;
  
  
  What is Containerization?
&lt;/h2&gt;

&lt;p&gt;This is a method for deploying software where the code, environment, and dependencies are packaged into a single, lightweight isolated &lt;code&gt;container&lt;/code&gt;. &lt;br&gt;
A &lt;code&gt;container&lt;/code&gt; is therefore a package that encapsulate all that is required to make an application to run.&lt;/p&gt;
&lt;h4&gt;
  
  
  Importance of Containerization
&lt;/h4&gt;

&lt;ul&gt;
&lt;li&gt;Applications can run on any machine&lt;/li&gt;
&lt;li&gt;It is easier to build, run, and deploy applications&lt;/li&gt;
&lt;li&gt;Allows for isolation of services&lt;/li&gt;
&lt;li&gt;It is Easy to scale applications&lt;/li&gt;
&lt;/ul&gt;
&lt;h2&gt;
  
  
  Docker
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.docker.com" rel="noopener noreferrer"&gt;&lt;strong&gt;Docker&lt;/strong&gt;&lt;/a&gt; is a popular open source containerization tool that allows developers to build, deploy, and manage their applications. From its inception in 2013, Docker has grown to be among the most sought after containerization tools.&lt;/p&gt;
&lt;h4&gt;
  
  
  Main Components of Docker
&lt;/h4&gt;

&lt;p&gt;&lt;strong&gt;1. Docker daemon:&lt;/strong&gt; Also referred to as &lt;code&gt;dockerd&lt;/code&gt;, manages Docker objects such as images, containers, networks, and volumes.&lt;br&gt;
&lt;strong&gt;2. Docker image:&lt;/strong&gt; A read-only template/snapshot with instructions for creating a Docker container.&lt;br&gt;
&lt;strong&gt;3. Docker container:&lt;/strong&gt; It is a runnable instance of an image which can be created, started, stopped, moved, or deleted.&lt;br&gt;
&lt;strong&gt;4. Docker Hub:&lt;/strong&gt; It is a public registry where one can store, share, and manage Docker images.&lt;br&gt;
&lt;strong&gt;4. Dockerfile:&lt;/strong&gt; A file containing the definition of how an image is to be build. It builds only &lt;strong&gt;one image&lt;/strong&gt;&lt;br&gt;
&lt;strong&gt;5. Docker compose:&lt;/strong&gt; It is a tool used to run &lt;strong&gt;multi-image&lt;/strong&gt; containers.&lt;/p&gt;
&lt;h2&gt;
  
  
  Installing Docker
&lt;/h2&gt;

&lt;p&gt;You can install the Docker engine on Ubuntu Linux by going to the &lt;a href="https://docs.docker.com/engine/install/ubuntu/" rel="noopener noreferrer"&gt;official Docker website&lt;/a&gt; or following the instructions below:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="c"&gt;# Add Docker's official GPG key:&lt;/span&gt;
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt update
&lt;span class="nb"&gt;sudo &lt;/span&gt;apt &lt;span class="nb"&gt;install &lt;/span&gt;ca-certificates curl
&lt;span class="nb"&gt;sudo install&lt;/span&gt; &lt;span class="nt"&gt;-m&lt;/span&gt; 0755 &lt;span class="nt"&gt;-d&lt;/span&gt; /etc/apt/keyrings
&lt;span class="nb"&gt;sudo &lt;/span&gt;curl &lt;span class="nt"&gt;-fsSL&lt;/span&gt; https://download.docker.com/linux/ubuntu/gpg &lt;span class="nt"&gt;-o&lt;/span&gt; /etc/apt/keyrings/docker.asc
&lt;span class="nb"&gt;sudo chmod &lt;/span&gt;a+r /etc/apt/keyrings/docker.asc

&lt;span class="c"&gt;# Add the repository to Apt sources:&lt;/span&gt;
&lt;span class="nb"&gt;sudo tee&lt;/span&gt; /etc/apt/sources.list.d/docker.sources &lt;span class="o"&gt;&amp;lt;&amp;lt;&lt;/span&gt;&lt;span class="no"&gt;EOF&lt;/span&gt;&lt;span class="sh"&gt;
Types: deb
URIs: https://download.docker.com/linux/ubuntu
Suites: &lt;/span&gt;&lt;span class="si"&gt;$(&lt;/span&gt;&lt;span class="nb"&gt;.&lt;/span&gt; /etc/os-release &lt;span class="o"&gt;&amp;amp;&amp;amp;&lt;/span&gt; &lt;span class="nb"&gt;echo&lt;/span&gt; &lt;span class="s2"&gt;"&lt;/span&gt;&lt;span class="k"&gt;${&lt;/span&gt;&lt;span class="nv"&gt;UBUNTU_CODENAME&lt;/span&gt;&lt;span class="k"&gt;:-&lt;/span&gt;&lt;span class="nv"&gt;$VERSION_CODENAME&lt;/span&gt;&lt;span class="k"&gt;}&lt;/span&gt;&lt;span class="s2"&gt;"&lt;/span&gt;&lt;span class="si"&gt;)&lt;/span&gt;&lt;span class="sh"&gt;
Components: stable
Architectures: &lt;/span&gt;&lt;span class="si"&gt;$(&lt;/span&gt;dpkg &lt;span class="nt"&gt;--print-architecture&lt;/span&gt;&lt;span class="si"&gt;)&lt;/span&gt;&lt;span class="sh"&gt;
Signed-By: /etc/apt/keyrings/docker.asc
&lt;/span&gt;&lt;span class="no"&gt;EOF

&lt;/span&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt update
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Install the Docker packages (including docker compose):&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;sudo &lt;/span&gt;apt &lt;span class="nb"&gt;install &lt;/span&gt;docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Creating a Docker Image using Dockerfile
&lt;/h2&gt;

&lt;p&gt;Creating a Dockerfile consists of the following steps:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Determine your base image&lt;/li&gt;
&lt;li&gt;Install application dependencies&lt;/li&gt;
&lt;li&gt;Copy in any relevant source code.&lt;/li&gt;
&lt;li&gt;Configure the final image.&lt;/li&gt;
&lt;/ul&gt;

&lt;h4&gt;
  
  
  Example of a Docker file
&lt;/h4&gt;

&lt;p&gt;Once inside the folder you want to create your Docker image, create a file with the name &lt;code&gt;Dockerfile&lt;/code&gt;&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;&lt;span class="nb"&gt;touch &lt;/span&gt;Dockerfile
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Insert the following instructions in the Dockerfile:&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flkz9g4nvs9t3khqrquhh.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flkz9g4nvs9t3khqrquhh.png" alt="Dockerfile image" width="799" height="145"&gt;&lt;/a&gt;&lt;/p&gt;
A Dockerfile



&lt;ul&gt;
&lt;li&gt;
&lt;code&gt;FROM python:3.10&lt;/code&gt; : Defines the &lt;strong&gt;base image/ parent image&lt;/strong&gt; (in this case a python base image)&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;WORKDIR /app&lt;/code&gt; : specifies the working directory in the image where files will be copied, and commands will be executed.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;COPY requirements.txt .&lt;/code&gt; : Copies files from the host into the container image.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;RUN pip install -r requirements.txt&lt;/code&gt; : Runs the command once the container runs.&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;COPY . .&lt;/code&gt; : Copies the source code into the image&lt;/li&gt;
&lt;li&gt;
&lt;code&gt;CMD ["python", "main.py"]&lt;/code&gt; : Sets the default command a container using this image will run.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;&lt;code&gt;Requirements.txt&lt;/code&gt;&lt;br&gt;
This file includes the package dependencies required by your application for it to work as expected. They can be inserted manually inside the file.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;To also include the versions for your packages, you can use the &lt;code&gt;pip freeze &amp;gt; requirements.txt&lt;/code&gt; command&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;The file will contain the packages and the corresponding versions required by the application. &lt;br&gt;
Below is an example of a simple file:&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fx63xcsdqe5ewcmdni69y.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fx63xcsdqe5ewcmdni69y.png" alt="requirements file" width="798" height="71"&gt;&lt;/a&gt;&lt;/p&gt;
A simple requirements.txt file



&lt;p&gt;&lt;code&gt;Main.py&lt;/code&gt;&lt;br&gt;
This is the file containing the program you want to run in your container. For example, you can create a simple Hello program for your image:&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjo1nbrjh5d4cdmtxgdgh.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjo1nbrjh5d4cdmtxgdgh.png" alt="main.py" width="800" height="114"&gt;&lt;/a&gt;&lt;/p&gt;
main.py


&lt;h4&gt;
  
  
  Building and Running your image
&lt;/h4&gt;

&lt;p&gt;To build your image, use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;docker build &lt;span class="nt"&gt;-t&lt;/span&gt; &lt;span class="s2"&gt;"tag for your image"&lt;/span&gt; &lt;span class="s2"&gt;"name/path of your folder containing the files"&lt;/span&gt; 
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This command is guided by the contents inside your Dockerfile.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;ℹ️ Running the build for the first time will take longer. Other successful builds will take a shorter time due to the concept of &lt;strong&gt;layered caching&lt;/strong&gt;, where Docker caches the results of each line of instruction in the Dockerfile.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fln3kilz3hx4an2j4ceap.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fln3kilz3hx4an2j4ceap.png" alt="First build" width="800" height="326"&gt;&lt;/a&gt;&lt;/p&gt;
Our first build



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fveax3i7v20o8xi1qsawc.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fveax3i7v20o8xi1qsawc.png" alt="Second Build" width="800" height="222"&gt;&lt;/a&gt;&lt;/p&gt;
Our second build using layered cache



&lt;p&gt;To run your container, use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;docker run &lt;span class="s2"&gt;"the tag you provided when building your image"&lt;/span&gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This will run the command specified in the &lt;code&gt;CMD&lt;/code&gt; line in the Dockerfile.&lt;/p&gt;

&lt;h2&gt;
  
  
  Creating Multiple Images Using Docker Compose
&lt;/h2&gt;

&lt;p&gt;Docker Compose is used to define and run multi-container applications. With Compose, one can manage services, networks, and volumes in a single &lt;a href="https://www.redhat.com/en/topics/automation/what-is-yaml" rel="noopener noreferrer"&gt;YAML&lt;/a&gt; configuration file. A YAML file is a human-readable data serialization language that is often used for writing configuration files. This file is commonly referred to as a &lt;strong&gt;compose file&lt;/strong&gt;. To start all the dependencies in a compose file(databases, message queues, APIs, caches, etc.), one only needs to run a single command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;docker compose up
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;To stop the services, you can use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;docker compose down
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h4&gt;
  
  
  Components of Docker Compose
&lt;/h4&gt;

&lt;p&gt;&lt;strong&gt;1. Services&lt;/strong&gt;&lt;br&gt;
They are the individual containers running a particular instance of an image with certain configurations. A single service definition within a &lt;strong&gt;compose file&lt;/strong&gt; can contain various containers.&lt;br&gt;
&lt;strong&gt;2. Networking&lt;/strong&gt;&lt;br&gt;
In order for the different services in the compose file to communicate with each other, Compose automatically creates a shared network. The services communicate with hostnames derived from their defined service names.&lt;/p&gt;

&lt;blockquote&gt;
&lt;p&gt;&lt;code&gt;localhost&lt;/code&gt; when used inside a container refers to the container and not the machine being used.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;strong&gt;3. Volumes&lt;/strong&gt;&lt;br&gt;
Volumes in compose are used to store data outside the container to ensure that the data is persistent even after the container has been deleted or is recreated. They include: &lt;strong&gt;databases&lt;/strong&gt; and &lt;strong&gt;logs&lt;/strong&gt;.&lt;br&gt;
&lt;strong&gt;4. Configs and Secrets&lt;/strong&gt;&lt;br&gt;
Configs are used to store non-sensitive configuration details such as application settings, while secrets store sensitive information such as passwords, API keys, etc.&lt;/p&gt;
&lt;h4&gt;
  
  
  Example of a compose file (.yaml file)
&lt;/h4&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0jgcz1ap2a6o0iq1lzsj.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0jgcz1ap2a6o0iq1lzsj.png" alt="compose file" width="800" height="327"&gt;&lt;/a&gt;&lt;/p&gt;
A compose file



&lt;p&gt;The above compose file has 2 services: &lt;strong&gt;postgres&lt;/strong&gt; and &lt;strong&gt;my_app&lt;/strong&gt;&lt;br&gt;
&lt;code&gt;postgres&lt;/code&gt;:&lt;br&gt;
This service pulls the PostgreSQL image from Docker Hub to be used by the my_app service.&lt;br&gt;
&lt;code&gt;my_app&lt;/code&gt;:&lt;br&gt;
This service is for the image created for our main application (main.py) using the &lt;code&gt;Dockerfile&lt;/code&gt;.&lt;br&gt;
A simple structure for our docker folder when using compose is as follows:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;compose_folder/
├── Dockerfile
├── compose(.yaml) file
├── main.py
└── requirements.txt
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;In order to access the PostgreSQL pulled from the Docker hub in the compose file above from your shell, use the command:&lt;br&gt;
&lt;/p&gt;
&lt;/blockquote&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight shell"&gt;&lt;code&gt;docker &lt;span class="nb"&gt;exec&lt;/span&gt; &lt;span class="nt"&gt;-it&lt;/span&gt; postgres psql &lt;span class="nt"&gt;-U&lt;/span&gt; postgres
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;docker exec -it "container_name"&lt;/code&gt; runs a shell command (psql -U postgres) inside the specified container (postgres)&lt;/p&gt;

&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;Docker provides an easier and much cleaner way of creating, running, and deploying applications, APIs, or pipelines as containers. This is mainly made possible by the use of a Dockerfile to create an image for your application and Docker Compose for running and managing the various containers for your application. In addition, Docker Hub provides a list of various images for different applications that one can pull and use for their application, removing the hustle of creating those services/containers from scratch. Given its open source nature, Docker Hub, and it being developed with developers in mind, Docker is one of the most suitable tools for containerization.&lt;/p&gt;

</description>
      <category>beginners</category>
      <category>devops</category>
      <category>docker</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>Power BI: Turning messy data into actionable insights</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Tue, 10 Feb 2026 11:02:15 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/power-bi-turning-messy-data-into-actionable-insights-4776</link>
      <guid>https://dev.to/stephen_githinji_/power-bi-turning-messy-data-into-actionable-insights-4776</guid>
      <description>&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;Within organizations, data analysts have the crucial task of deriving meaning from various data sets. In its true form, data does not provide substantial insights that can be used to drive meaningful change within organizations. Here is where data analysts come in to clean and analyze the data and to visualize their findings. To carry out these tasks, analysts employ various analytics tools. One of the widely used tools in the industry is &lt;a href="https://www.microsoft.com/en-us/power-platform/products/power-bi" rel="noopener noreferrer"&gt;&lt;strong&gt;Power BI&lt;/strong&gt;&lt;/a&gt;. This article aims to demonstrate how data analysts and data professionals at large use Power BI to translate messy data into action, while touching on concepts such as data transformation with Power Query, analysis with DAX, and creating visuals and dashboards.&lt;/p&gt;

&lt;h2&gt;
  
  
  Power BI Overview
&lt;/h2&gt;

&lt;p&gt;Power BI is a business analytics and intelligence tool, which is part of Microsoft's &lt;a href="https://www.microsoft.com/en-us/power-platform/try-free" rel="noopener noreferrer"&gt;Power Platform&lt;/a&gt;, used to analyze data and create interactive visual reports and dashboards. Power BI can be downloaded directly from the Microsoft Store. &lt;br&gt;
Click the following link to download: &lt;a href="https://apps.microsoft.com/detail/9ntxr16hnw1t?hl=en-US&amp;amp;gl=US" rel="noopener noreferrer"&gt;Download Power BI.&lt;/a&gt; &lt;br&gt;
The Power BI window contains the following components:&lt;/p&gt;
&lt;h6&gt;
  
  
  Menu Bar
&lt;/h6&gt;

&lt;p&gt;Located at the top of the window and it is organized into tabs such as Home, Insert, Modeling, View, Optimize, and Help.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fzga2l1b8hnjf5aeylq41.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fzga2l1b8hnjf5aeylq41.png" alt="menu bar" width="800" height="385"&gt;&lt;/a&gt;&lt;/p&gt;
 menu bar 


&lt;h6&gt;
  
  
  View Selector / navigation pane
&lt;/h6&gt;

&lt;p&gt;Found on the left hand side and it contains the reports view, table view, model view, and the Dax query and TMDL view.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fkcj8vzsoi8b47drg0fly.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fkcj8vzsoi8b47drg0fly.png" alt="view selector" width="800" height="399"&gt;&lt;/a&gt;&lt;/p&gt;
 view selector 


&lt;h6&gt;
  
  
  Visualizations Pane
&lt;/h6&gt;

&lt;p&gt;Lets you choose different visual types (bar chart, line chart, map, table, etc.) and includes options to format visuals and manage visual-level filters&lt;/p&gt;
&lt;h6&gt;
  
  
  Data Pane
&lt;/h6&gt;

&lt;p&gt;Displays tables, columns, and measures from the loaded dataset&lt;/p&gt;
&lt;h6&gt;
  
  
  Filters Pane
&lt;/h6&gt;

&lt;p&gt;Used to apply filters at different levels(Visual-level filters, Page-level filters, Report-level filters)&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flnm19ew5wvjzt2t0qqam.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flnm19ew5wvjzt2t0qqam.png" alt="Visualization, Data, and Filter panes " width="800" height="399"&gt;&lt;/a&gt;&lt;/p&gt;
 Visualization, Data, and Filter panes 



&lt;p&gt;In addition to its intuitive navigation, one of the beauties of Power BI is that it allows analysts to load and work with files in various formats, for example: CSV, text, Excel, Dataflow, Dataverse, etc. To see all these formats, go to the &lt;em&gt;menu bar &amp;gt;Home&amp;gt;Data&amp;gt;Get data.&lt;/em&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqa7uet0cvsrphz38k8ah.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fqa7uet0cvsrphz38k8ah.png" alt="data formats" width="800" height="412"&gt;&lt;/a&gt;&lt;/p&gt;
Data formats acceptable in Power BI


&lt;h2&gt;
  
  
  Transforming Data Using Power Query
&lt;/h2&gt;

&lt;p&gt;Data obtained in an organization often contains inconsistencies, missing values, duplicates, or errors. Data transformation refers to the process of cleaning, reshaping, and preparing this data so that it is accurate, consistent, and suitable for analysis and reporting. Power BI provides access to another Power Platform tool referred to as &lt;a href="https://learn.microsoft.com/en-us/power-query/power-query-what-is-power-query" rel="noopener noreferrer"&gt;Power Query&lt;/a&gt;, whose sole purpose is to prepare and transform data before analysis. To access Power Query within Power BI go to &lt;em&gt;menu bar&amp;gt;Home&amp;gt;Queries&amp;gt;Transform Data.&lt;/em&gt; This will open up a separate window for the Power Query editor.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F87uzvftcoocik0lqsj0h.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F87uzvftcoocik0lqsj0h.png" alt="Accessing Power Query" width="800" height="193"&gt;&lt;/a&gt;&lt;/p&gt;
Accessing Power Query



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0uq1xx3arl4d2ctgl7py.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F0uq1xx3arl4d2ctgl7py.png" alt="power query" width="800" height="411"&gt;&lt;/a&gt;&lt;/p&gt;
Power Query window



&lt;p&gt;By simply selecting the rows and columns you want to modify and navigating to the editor's menu bar to find the action(s) you want to perform(for example: remove, split, merge, change data type, etc.), you can make all the necessary and desired transformations for your data. Once done with the transformations, you can click the &lt;em&gt;Close&amp;gt;click and apply changes&lt;/em&gt; button to ensure the changes in Power Query are updated in Power BI.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fm4b55bo9ikl6slp809cu.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fm4b55bo9ikl6slp809cu.png" alt="Applying changes to power BI" width="640" height="167"&gt;&lt;/a&gt;&lt;/p&gt;
Applying changes to power BI


&lt;h2&gt;
  
  
  Data Analysis
&lt;/h2&gt;

&lt;p&gt;After satisfactorily transforming or cleaning the dataset, the next step is analysis. It involves examining data to discover patterns, trends, and insights that will ultimately support decision-making. It involves the implementation of statistical techniques, logical reasoning, and analytical tools to convert raw data into meaningful information. It is through analysis that analysts are able to extract meaning from data. In Power BI, analysis is done mainly by using the Data Analysis Expressions (DAX) tool.&lt;/p&gt;
&lt;h5&gt;
  
  
  Data Analysis Expressions (DAX)
&lt;/h5&gt;

&lt;p&gt;&lt;a href="https://learn.microsoft.com/en-us/dax/dax-function-reference" rel="noopener noreferrer"&gt;DAX&lt;/a&gt; is a formula language for Power BI to perform calculations on data. There are 5 main DAX function categories:&lt;br&gt;
&lt;code&gt;Aggregate&lt;/code&gt;: Summarize data, similar (Sum, Average, AverageX, SumX)&lt;br&gt;
&lt;code&gt;Logical&lt;/code&gt;: Test conditions and return TRUE/FALSE&lt;br&gt;
&lt;code&gt;Calculate and Filter&lt;/code&gt;: Calculate dynamically based on filters or context.&lt;br&gt;
&lt;code&gt;Text&lt;/code&gt;: Manipulate text columns.&lt;br&gt;
&lt;code&gt;Date and Time&lt;/code&gt;: Handles dates and periods&lt;br&gt;
In Power BI, DAX expressions are written in the formula bar, which is just below the menu bar.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjkdc5r4n0swy6v9xtjaz.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjkdc5r4n0swy6v9xtjaz.png" alt="formula bar" width="799" height="176"&gt;&lt;/a&gt;&lt;/p&gt;
formular bar



&lt;p&gt;Once these calculations are carried out, they can either be recorded as a new measure or a new column. Therefore, before carrying out any DAX function, select whether the new values should be recorded as a measure or column, depending on the function you want to use. This can be done by going to &lt;em&gt;menu bar&amp;gt;calculations&amp;gt;new measure/new column.&lt;/em&gt;&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6uol0924xphb4awcbmks.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6uol0924xphb4awcbmks.png" alt="DAX calculations" width="682" height="153"&gt;&lt;/a&gt;&lt;/p&gt;
DAX calculations


&lt;h6&gt;
  
  
  Aggregate functions
&lt;/h6&gt;

&lt;p&gt;The most common include:&lt;br&gt;
&lt;code&gt;SUM&lt;/code&gt;: Adds all the numbers in a column.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;sum of column = sum(table_name[column_name](unit_of_measurement))
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;AVERAGE&lt;/code&gt;: Returns the average of a column&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;average of column = average(table_name[column_name](unit_of_measurement))
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;SUMX&lt;/code&gt;: Adds up an expression for each row in a table.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;sum of expression = sumx(table_name, expression)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;AVERAGEX&lt;/code&gt;: Calculates an average based on an expression per row.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;average of expression = averagex(table_name, expression)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;MAX&lt;/code&gt;: Retrieves the largest value in a column&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;max of column = max(table_name[column_name](unit_of_measurement))
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;MIN&lt;/code&gt;: Retrieves the smallest value in a column&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;min of column = sum(table_name[column_name](unit_of_measurement))
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;Expressions are calculations performed between 2 or more columns of a table.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h6&gt;
  
  
  Logical functions
&lt;/h6&gt;

&lt;p&gt;The most common include:&lt;br&gt;
&lt;code&gt;IF&lt;/code&gt;: Returns one value if a condition is true, and another if false.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Result = IF(condition, "value if true", "value if false")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;AND&lt;/code&gt;: Returns TRUE if all conditions are true.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Result = IF(AND(comma separated conditions) "value if true", "value if false")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;OR&lt;/code&gt;: Returns TRUE if at least one condition is true.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Result = IF(OR(comma separated conditions) "value if true", "value if false")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;NOT&lt;/code&gt;: Reverses a logical value.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;Result = IF(NOT(condition) "value if true", "value if false")
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;To use more than 2 conditions in &lt;code&gt;AND&lt;/code&gt; and &lt;code&gt;OR&lt;/code&gt; functions, use the &lt;code&gt;IF&lt;/code&gt; function together with &lt;code&gt;&amp;amp;&amp;amp;&lt;/code&gt; (ampersand operator) and &lt;code&gt;||&lt;/code&gt; (double pipe) respectively.&lt;/p&gt;

&lt;p&gt;A nested if statement (multiple if statements meshed together) can be provides more than 2 possible results (multiple results). However, it can only be used to evaluate only one column.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h6&gt;
  
  
  Calculate and Filter functions
&lt;/h6&gt;

&lt;p&gt;&lt;code&gt;calculate&lt;/code&gt; : changes the filter context of a calculation and then evaluates an expression under those new filters. Only done for one column at a time.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;result = Calculate(Expression, condition)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;Filter&lt;/code&gt; : Returns a table that contains only rows that meet a condition.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;new table = Filter(source_table, condition)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h6&gt;
  
  
  Text functions
&lt;/h6&gt;

&lt;p&gt;The common function include:&lt;br&gt;
&lt;code&gt;CONCATENATE&lt;/code&gt; : Joins two text values together.&lt;br&gt;
&lt;code&gt;CONCATENATEX&lt;/code&gt; : Concatenates text from a column or table with a delimiter.&lt;br&gt;
&lt;code&gt;LEN&lt;/code&gt; : Counts the number of characters in text.&lt;br&gt;
&lt;code&gt;UPPER&lt;/code&gt; and &lt;code&gt;LOWER&lt;/code&gt; : Converts text to uppercase and lowercase respectively&lt;br&gt;
&lt;code&gt;PROPER&lt;/code&gt; : Capitalizes the first letter of each word.&lt;br&gt;
&lt;code&gt;TRIM&lt;/code&gt; : Removes extra spaces from text (except single spaces between words).&lt;/p&gt;
&lt;h6&gt;
  
  
  Data and Time functions
&lt;/h6&gt;

&lt;p&gt;The most common functions include:&lt;br&gt;
&lt;code&gt;TODAY&lt;/code&gt; : Returns current date&lt;br&gt;
&lt;code&gt;NOW&lt;/code&gt; : Returns current date and time&lt;br&gt;
&lt;code&gt;DATE&lt;/code&gt; : Creates a date&lt;br&gt;
&lt;code&gt;DAY&lt;/code&gt; : Extracts day&lt;br&gt;
&lt;code&gt;MONTH&lt;/code&gt; : Extracts month number&lt;br&gt;
&lt;code&gt;DATEDIFF&lt;/code&gt; : Difference between dates&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;DATEDIFF(lower_date, higher_date, DAY)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;DATEADD&lt;/code&gt; : Shift date context by either a month, day, or year.&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;shifted_date = DATEADD(date_column, operation, DAY/MONTH/YEAR)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;blockquote&gt;
&lt;p&gt;&lt;code&gt;operation&lt;/code&gt; refers to the number of days/months/years you want to shift the date (e.g., +1, +3, -4, -5)&lt;/p&gt;
&lt;/blockquote&gt;

&lt;h2&gt;
  
  
  Data Visualization
&lt;/h2&gt;

&lt;p&gt;Visualization involves the graphical representation of data using visual elements such as charts, graphs, tables, maps, and dashboards to communicate information clearly and effectively. After generating the measures using DAX, it is possible to visualize your calculations thanks to the reports view tool in the view selector.&lt;br&gt;
&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Feqqnupjjjtjheriglcxm.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Feqqnupjjjtjheriglcxm.png" alt="view selection" width="800" height="383"&gt;&lt;/a&gt;&lt;/p&gt;
 report view 



&lt;p&gt;To visualize a measure, you first select the visual on the &lt;strong&gt;visualization pane&lt;/strong&gt; you want to use, then locate the measure you want to represent on the &lt;strong&gt;data pane&lt;/strong&gt;. You can apply some filters from the filters pane, depending on how you want your visual to appear and how to represent your data.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F1371wqohyfx42o2u162i.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F1371wqohyfx42o2u162i.png" alt="select the visual" width="800" height="247"&gt;&lt;/a&gt;&lt;/p&gt;
 select the visual 



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbw8ly77yfz40scixcb9w.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbw8ly77yfz40scixcb9w.png" alt="locate and select your measure" width="800" height="244"&gt;&lt;/a&gt;&lt;/p&gt;
 locate and select your measure 



&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4en4c5lsmvznfu7j8j41.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4en4c5lsmvznfu7j8j41.png" alt="visual of a card" width="800" height="435"&gt;&lt;/a&gt;&lt;/p&gt;
 visual of a card 



&lt;p&gt;Power BI supports various visuals to represent data and they can all be located on the visualization pane. Some of the most popular visuals include:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Card - Displays a single key value, such as total sales or profit.&lt;/li&gt;
&lt;li&gt;Bar Chart - Uses horizontal bars to compare values across categories.&lt;/li&gt;
&lt;li&gt;Column Chart - Uses vertical bars to show data changes across categories or time.&lt;/li&gt;
&lt;li&gt;Line Chart-Shows trends over time using connected data points.&lt;/li&gt;
&lt;li&gt;Pie Chart - Displays proportions of a whole.&lt;/li&gt;
&lt;li&gt;Donut Chart - A variation of the pie chart with a hollow center.&lt;/li&gt;
&lt;li&gt;Map - Visualizes data based on geographic location.&lt;/li&gt;
&lt;li&gt;Treemap-Displays hierarchical data using nested rectangles.&lt;/li&gt;
&lt;li&gt;Scatter Chart - Plots values using two numeric axes to show relationships.&lt;/li&gt;
&lt;li&gt;Slicer-Acts as an interactive filter for reports.&lt;/li&gt;
&lt;/ol&gt;

&lt;blockquote&gt;
&lt;p&gt;Bars, lines, and scatter plots within the accompanying visuals can also serve as interactive slicers.&lt;/p&gt;
&lt;/blockquote&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnew09uacj1xk9kyddilz.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fnew09uacj1xk9kyddilz.png" alt="visual 1" width="800" height="449"&gt;&lt;/a&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F620knjptycba0q4karyv.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F620knjptycba0q4karyv.png" alt="visual 2" width="800" height="450"&gt;&lt;/a&gt;&lt;/p&gt;
Examples of visuals in Power BI



&lt;h4&gt;
  
  
  The Dashboard
&lt;/h4&gt;

&lt;p&gt;A dashboard is a single-page visual display that presents key information needed to monitor performance and support quick decision-making. It is formed by bringing together and arranging key visuals that are deemed crucial (depending on the goals of the analysis) on a single view. &lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgbuguuwmthrtarjhhr9j.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgbuguuwmthrtarjhhr9j.png" alt="Dashboard" width="799" height="447"&gt;&lt;/a&gt;&lt;/p&gt;
A simple Dashboard in PowerBI



&lt;h2&gt;
  
  
  Conclusion
&lt;/h2&gt;

&lt;p&gt;Regardless of the field and type of data, data analysts are capable of deriving meaning from the data presented by following several steps with the help of various tools. Power BI is one of the most sought-after tools by data analysts, given its intuitive interface, support for various data types, and its vast array of technical, analytical, and visualization capabilities. From carrying out transformations using Power Query to using DAX for calculations and analysis, and creating visualizations from the visualization pane, Power BI is definitely a powerful tool for any data analyst or professional seeking to derive meaning from their data.&lt;/p&gt;

</description>
      <category>analytics</category>
      <category>datascience</category>
      <category>microsoft</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>Schemas and Data Modelling in Power BI</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Mon, 02 Feb 2026 14:56:21 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/schemas-and-data-modelling-in-power-bi-5ho2</link>
      <guid>https://dev.to/stephen_githinji_/schemas-and-data-modelling-in-power-bi-5ho2</guid>
      <description>&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;In Power BI, &lt;strong&gt;Data modelling&lt;/strong&gt; is the process of creating visual representations of the relationships between data structures, including information about the individual attributes within those structures. These visual representations are referred to as &lt;strong&gt;schemas.&lt;/strong&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7hdnlzkgqo5oq77kmph1.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F7hdnlzkgqo5oq77kmph1.png" alt="Power BI schemas" width="601" height="520"&gt;&lt;/a&gt;&lt;/p&gt;
An example of a Power BI schema



&lt;p&gt;2 main schemas are employed in Power BI, and they are: &lt;strong&gt;Star&lt;/strong&gt; and &lt;strong&gt;Snowflake.&lt;/strong&gt;&lt;br&gt;
In Power BI, schemas can be found under the &lt;strong&gt;fields/data pane&lt;/strong&gt;, located on the right-hand side of the Power BI window, under &lt;strong&gt;model view.&lt;/strong&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  The star schema
&lt;/h2&gt;

&lt;p&gt;A star schema is one where a single fact table is surrounded by multiple-dimension tables. The &lt;a href="https://www.geeksforgeeks.org/computer-networks/difference-between-fact-table-and-dimension-table/" rel="noopener noreferrer"&gt;&lt;strong&gt;fact table&lt;/strong&gt;&lt;/a&gt; contains the numeric measures or facts of the data model, while the &lt;a href="//www.geeksforgeeks.org/computer-networks/difference-between-fact-table-and-dimension-table"&gt;&lt;strong&gt;dimension tables&lt;/strong&gt;&lt;/a&gt; contain descriptive attributes or dimensions of the data model. Just as the name suggests, the visual &lt;strong&gt;resembles a star&lt;/strong&gt;⭐&lt;/p&gt;

&lt;h2&gt;
  
  
  The Snowflake schema
&lt;/h2&gt;

&lt;p&gt;On the other hand, a snowflake schema is a type of schema that &lt;strong&gt;extends the star schema&lt;/strong&gt; by normalizing dimension tables. In other words, one central fact table connects to multiple dimension tables, but one or more of those dimension tables are further divided into multiple related sub-dimension tables. &lt;br&gt;
This ultimately results in a structure that &lt;strong&gt;resembles a snowflake&lt;/strong&gt;❄️&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjozgjx9vxtnzlt19lmqp.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fjozgjx9vxtnzlt19lmqp.png" alt=" " width="514" height="270"&gt;&lt;/a&gt;&lt;/p&gt;
A star vs a snowflake schema



&lt;h2&gt;
  
  
  Relationships in Star and Snowflake Schemas
&lt;/h2&gt;

&lt;p&gt;How fact tables and dimension tables connect is what is defined as a relationship. They are basically defined by the use of &lt;strong&gt;Primary Keys(PK)&lt;/strong&gt; and &lt;strong&gt;Foreign Keys(FK).&lt;/strong&gt; &lt;br&gt;
&lt;code&gt;PK&lt;/code&gt; : A unique identifier for every row in a table&lt;br&gt;
&lt;code&gt;FK&lt;/code&gt; : A column in one table that references the Primary Key           of another table, creating a link between them.&lt;/p&gt;

&lt;h2&gt;
  
  
  Importance of Good Data Modelling Practices for Performance and Accurate Reporting
&lt;/h2&gt;

&lt;div class="table-wrapper-paragraph"&gt;&lt;table&gt;
&lt;thead&gt;
&lt;tr&gt;
&lt;th&gt;Performance&lt;/th&gt;
&lt;th&gt;Reporting&lt;/th&gt;
&lt;/tr&gt;
&lt;/thead&gt;
&lt;tbody&gt;
&lt;tr&gt;
&lt;td&gt;Optimized query speed&lt;/td&gt;
&lt;td&gt;Single source of truth&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Reduced complexity and resource usage&lt;/td&gt;
&lt;td&gt;Data integrity&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;scalability&lt;/td&gt;
&lt;td&gt;contextual understanding&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;td&gt;Faster processing&lt;/td&gt;
&lt;td&gt;Fewer errors&lt;/td&gt;
&lt;/tr&gt;
&lt;/tbody&gt;
&lt;/table&gt;&lt;/div&gt;

</description>
      <category>analytics</category>
      <category>database</category>
      <category>dataengineering</category>
      <category>microsoft</category>
    </item>
    <item>
      <title>Introduction to Linux For Data Engineers, Including Practical use for Vi and Nano</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Mon, 26 Jan 2026 02:15:11 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/introduction-to-linux-for-data-engineers-including-practical-use-for-vi-and-nano-2moa</link>
      <guid>https://dev.to/stephen_githinji_/introduction-to-linux-for-data-engineers-including-practical-use-for-vi-and-nano-2moa</guid>
      <description>&lt;h1&gt;
  
  
  Overview
&lt;/h1&gt;

&lt;p&gt;Data Engineers (DEs) are involved in building and maintaining systems that collect, store, and prepare data for data scientists and analysts to use. To be able to achieve this, they employ various techniques and tools, and one of these tools is &lt;a href="https://www.linux.org" rel="noopener noreferrer"&gt;Linux&lt;/a&gt;.&lt;br&gt;
Linux is an operating system (OS) which is open-sourced and is based on the &lt;a href="https://unix.org" rel="noopener noreferrer"&gt;Unix system&lt;/a&gt;. It contains several &lt;a href="https://en.wikipedia.org/wiki/List_of_Linux_distributions" rel="noopener noreferrer"&gt;distributions &lt;/a&gt;such as &lt;a href="https://ubuntu.com" rel="noopener noreferrer"&gt;Ubuntu&lt;/a&gt;, &lt;a href="https://www.fedoraproject.org" rel="noopener noreferrer"&gt;Fedora&lt;/a&gt;, &lt;a href="https://www.debian.org" rel="noopener noreferrer"&gt;Debian&lt;/a&gt;, and many others, all of which use the &lt;a href="https://www.geeksforgeeks.org/operating-systems/what-is-command-line-interface-cli/" rel="noopener noreferrer"&gt;command line interface&lt;/a&gt;. Linux is especially known for its versatility and security, characteristics that make the OS more desirable to work with for technical professionals such as Data Engineers.&lt;/p&gt;

&lt;p&gt;DEs prefer to use Linux due to the following:&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;Most servers and &lt;a href="https://www.vmware.com/topics/virtual-machine" rel="noopener noreferrer"&gt;Virtual Machines&lt;/a&gt; (VMs) run Linux.&lt;/li&gt;
&lt;li&gt;Easier &lt;a href="https://datascientest.com/en/all-about-script-automation" rel="noopener noreferrer"&gt;automation and scripting&lt;/a&gt;
&lt;/li&gt;
&lt;li&gt;High compatibility with &lt;a href="https://dev.to/ezinne_anne/containers-what-is-containerization-and-container-orchestration-38pe"&gt;Containerization and orchestration&lt;/a&gt; tools.&lt;/li&gt;
&lt;li&gt;Resource control&lt;/li&gt;
&lt;li&gt;Troubleshooting and monitoring&lt;/li&gt;
&lt;li&gt;High compatibility with &lt;a href="https://www.geeksforgeeks.org/data-engineering/10-best-data-engineering-tools-for-big-data-processing/" rel="noopener noreferrer"&gt;big-data tooling&lt;/a&gt; &lt;/li&gt;
&lt;/ol&gt;
&lt;h1&gt;
  
  
  Basic Linux Commands for Data Engineers
&lt;/h1&gt;

&lt;p&gt;For a DE to be able to use the command-line interface in the Linux OS seamlessly, it is essential to understand some of the basic commands in Linux.&lt;br&gt;
Some of the commands that are deemed basic for a DE are:&lt;br&gt;
&lt;code&gt;ls&lt;/code&gt; : To list files and directories.&lt;br&gt;
&lt;code&gt;pwd&lt;/code&gt;: To print the current working directory.&lt;br&gt;
&lt;code&gt;cd&lt;/code&gt; : To change to a different directory.&lt;br&gt;
&lt;code&gt;cp&lt;/code&gt; : To copy a file to a different directory while still maintaining the original copy.&lt;br&gt;
&lt;code&gt;mv&lt;/code&gt; : To move a file to a different directory and delete the original copy.&lt;br&gt;
&lt;code&gt;rm&lt;/code&gt; : To delete a file.&lt;br&gt;
&lt;code&gt;ssh&lt;/code&gt;: To connect to a remote server.&lt;br&gt;
&lt;code&gt;tar&lt;/code&gt;, &lt;code&gt;zip&lt;/code&gt;: For Creating archives and compressions&lt;br&gt;
&lt;code&gt;chmod&lt;/code&gt;: For changing access permissions of files and directories.&lt;/p&gt;
&lt;h1&gt;
  
  
  Practical Usage of Vi and Nano
&lt;/h1&gt;
&lt;h3&gt;
  
  
  Introduction
&lt;/h3&gt;

&lt;p&gt;Vi and Nano are the most common text editors (tools that are used in creating, viewing, and manipulating texts in files) found in Linux.&lt;br&gt;
DEs use text editors for writing and editing code, editing configuration files, creating scripts and automations, and writing documentation.&lt;/p&gt;
&lt;h3&gt;
  
  
  Vi
&lt;/h3&gt;

&lt;p&gt;It is a modal, keyboard-driven editor found on almost all Linux systems. Modal implies that the editor operates in different modes, where the same key does different things depending on the current mode. One mode is used for typing (insert mode) while the other is used for commands to navigate, delete, copy, and search (Normal mode). To change what your keystrokes can do, one is obligated to switch modes.&lt;br&gt;
Vi is found in many servers and it is adopted by DEs to edit files on remote servers over SSH.&lt;br&gt;
To open a Vi text editor, use the Linux command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;$vi &amp;lt;file_name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Some Key commands that are used in the Vi text editor:&lt;br&gt;
&lt;code&gt;:w&lt;/code&gt; - To write (save) the contents of the buffer to the file without exiting the editor.&lt;br&gt;
&lt;code&gt;:q&lt;/code&gt; - Quit Vi.&lt;br&gt;
&lt;code&gt;:wq&lt;/code&gt; - Save and quit.&lt;br&gt;
&lt;code&gt;:q!&lt;/code&gt; - Force quit without saving.&lt;br&gt;
&lt;code&gt;i&lt;/code&gt;- To write on the document&lt;br&gt;
&lt;code&gt;Esc&lt;/code&gt;- To transition between modes.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgoerbgtj0wwvn7uyu4fm.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgoerbgtj0wwvn7uyu4fm.png" alt="A Vi interface" width="799" height="423"&gt;&lt;/a&gt; &lt;em&gt;Example of a vi text editor&lt;/em&gt;&lt;/p&gt;
&lt;h3&gt;
  
  
  Nano
&lt;/h3&gt;

&lt;p&gt;Nano, on the other hand, is modeless, as it uses one mode for commands and typing. Keys are used to insert texts, while commands employ shortcuts like Ctrl and Alt. DEs prefer nano when carrying out minute text edits on documents.&lt;br&gt;
To open the nano text editor, use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;$nano &amp;lt;file_name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;Once within the text editor, the following commands can be used to manipulate the file:&lt;br&gt;
&lt;code&gt;Ctr+O&lt;/code&gt; - save the file&lt;br&gt;
&lt;code&gt;Ctr+X&lt;/code&gt; - exit&lt;br&gt;
&lt;code&gt;Ctr+K&lt;/code&gt; - Cut the current line&lt;br&gt;
&lt;code&gt;Ctr+U&lt;/code&gt; - Paste&lt;br&gt;
&lt;code&gt;Ctr+W&lt;/code&gt; - search&lt;br&gt;
&lt;code&gt;Ctr+\&lt;/code&gt; - replace&lt;br&gt;
&lt;code&gt;Ctr+G&lt;/code&gt; - help&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fv78xo5aq9tck26nc2k6p.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fv78xo5aq9tck26nc2k6p.png" alt="A nano text editor" width="800" height="429"&gt;&lt;/a&gt; &lt;em&gt;Example of a nano text editor&lt;/em&gt;&lt;/p&gt;

</description>
      <category>beginners</category>
      <category>dataengineering</category>
      <category>linux</category>
      <category>tutorial</category>
    </item>
    <item>
      <title>Pushing and Pulling Code From GitHub</title>
      <dc:creator>Stephen Githinji</dc:creator>
      <pubDate>Sun, 18 Jan 2026 10:12:44 +0000</pubDate>
      <link>https://dev.to/stephen_githinji_/pushing-and-pulling-code-from-github-409</link>
      <guid>https://dev.to/stephen_githinji_/pushing-and-pulling-code-from-github-409</guid>
      <description>&lt;h1&gt;
  
  
  Overview on GitHub
&lt;/h1&gt;

&lt;p&gt;&lt;a href="http://github.com" rel="noopener noreferrer"&gt;GitHub&lt;/a&gt; is among the most popular websites that provides teams the ability to carry out version control (VC). It is built on git, a popular decentralized version control system. &lt;/p&gt;

&lt;p&gt;In software development, &lt;a href="https://git-scm.com" rel="noopener noreferrer"&gt;Git&lt;/a&gt; tracks changes made to the source code, hence enabling developers to collaborate and manage different versions of their product. GitHub provides an interface for hosting git repositories.&lt;/p&gt;

&lt;h1&gt;
  
  
  GitHUb Operations
&lt;/h1&gt;

&lt;p&gt;Various operations in GitHub allow developers to host their git repositories and track their changes. The most common operations are commit, push, and pull.&lt;/p&gt;

&lt;h2&gt;
  
  
  Commit
&lt;/h2&gt;

&lt;p&gt;Committing your code entails recording a snapshot of the changes to one or more files in your project.&lt;br&gt;
First, one needs to add the file(s) they need to make changes to by invoking the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git add &amp;lt;file_name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;This places them to the staging area.&lt;br&gt;
To commit your changes use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git commit -m "Message describing your changes."
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  Push
&lt;/h2&gt;

&lt;p&gt;The other operation is push. It used to upload your local repository content to a remote repository (such as GitHub).&lt;br&gt;
To do so, use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git push
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;In case you have a branch, use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git push &amp;lt;remote-name&amp;gt; &amp;lt;branch-name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h3&gt;
  
  
  prerequisites before pushing
&lt;/h3&gt;

&lt;ol&gt;
&lt;li&gt;You must have a local Git repository with committed changes on your computer.&lt;/li&gt;
&lt;li&gt;A remote repository (like GitHub) linked to your local one. You can check your configured remote repos using the command:
&lt;/li&gt;
&lt;/ol&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt; git remote -v
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;ol&gt;
&lt;li&gt;The necessary permissions to write to the remote repository. &lt;/li&gt;
&lt;/ol&gt;

&lt;h2&gt;
  
  
  Pull
&lt;/h2&gt;

&lt;p&gt;Pulling is aimed at updating your current local working branch with the latest changes from a remote repository.&lt;br&gt;
Use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git pull
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;In case your are pulling from a specific remote branch, use:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git pull &amp;lt;remote_name&amp;gt; &amp;lt;branch_name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;&lt;code&gt;Hint:&lt;/code&gt; Always ensure that you are always on the correct branch. You can use the command:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;git checkout &amp;lt;branch_name&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



</description>
      <category>beginners</category>
      <category>git</category>
      <category>github</category>
      <category>tutorial</category>
    </item>
  </channel>
</rss>
