<?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: Dennis Wachira</title>
    <description>The latest articles on DEV Community by Dennis Wachira (@denoh).</description>
    <link>https://dev.to/denoh</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%2F4094640%2F7617b046-8017-4c35-bcab-bffb19fa2094.jpg</url>
      <title>DEV Community: Dennis Wachira</title>
      <link>https://dev.to/denoh</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://dev.to/feed/denoh"/>
    <language>en</language>
    <item>
      <title>Building Excel Dashboard</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Tue, 17 Nov 2026 15:08:29 +0000</pubDate>
      <link>https://dev.to/denoh/building-excel-dashboard-5hn5</link>
      <guid>https://dev.to/denoh/building-excel-dashboard-5hn5</guid>
      <description>&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%2Fookn5pg8t0lb54zf1u40.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%2Fookn5pg8t0lb54zf1u40.png" alt=" " width="800" height="500"&gt;&lt;/a&gt;With the analysis complete, I designed an interactive dashboard to present the findings. It includes:&lt;br&gt;
The dashboard includes:&lt;/p&gt;

&lt;p&gt;KPI cards for:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Total Patients&lt;/li&gt;
&lt;li&gt;Average Patient Age&lt;/li&gt;
&lt;li&gt;Total Bill Amount&lt;/li&gt;
&lt;li&gt;Highest Bill Amount&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Visualisations  showing:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Patients by Department&lt;/li&gt;
&lt;li&gt;Gender Distribution&lt;/li&gt;
&lt;li&gt;Payment Status Distribution&lt;/li&gt;
&lt;li&gt;Diagnosis Analysis&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;One of my favourite parts was using slicers. These allow the entire dashboard to update instantly based on the selected filters, making it much easier to explore the data from different perspectives. Building this feature helped me appreciate how interactive reports improve the user experience and support faster decision-making. I added slicers for:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Hospital Department&lt;/li&gt;
&lt;li&gt;Gender&lt;/li&gt;
&lt;li&gt;Payment Status&lt;/li&gt;
&lt;li&gt;Diagnosis&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Beyond creating charts, I wanted the dashboard to have a clean and professional appearance.To achieve this, I:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Removed Excel gridlines to create a cleaner layout.&lt;/li&gt;
&lt;li&gt;Hid the row and column headings so the dashboard looked more like a business report than a spreadsheet.&lt;/li&gt;
&lt;li&gt;Used consistent fonts and spacing to improve readability.&lt;/li&gt;
&lt;li&gt;Organized the KPIs and charts into a structured layout that is easy to understand at a glance.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;These small design improvements made a significant difference in the overall presentation of the dashboard.&lt;br&gt;
The Excel phase of my project is now complete.&lt;/p&gt;

</description>
      <category>beginners</category>
      <category>database</category>
      <category>sql</category>
      <category>writing</category>
    </item>
    <item>
      <title>EDA (Exploratory Data Analysis)</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Mon, 16 Nov 2026 09:44:52 +0000</pubDate>
      <link>https://dev.to/denoh/eda-exploratory-data-analysis-1n8b</link>
      <guid>https://dev.to/denoh/eda-exploratory-data-analysis-1n8b</guid>
      <description>&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%2Fo1kbzdd7l5h0wchh3o6t.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%2Fo1kbzdd7l5h0wchh3o6t.png" alt=" " width="800" height="500"&gt;&lt;/a&gt;&lt;br&gt;
In this phase of my Hospital Records Analysis project, I moved from data cleaning to Exploratory Data Analysis (EDA) using Microsoft Excel.I created a separate worksheet named EDA. It contains the following:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Key Performance Indicators (KPI)&lt;/li&gt;
&lt;li&gt;Pivot tables&lt;/li&gt;
&lt;li&gt;Findings from the analysis&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Separating these analysis from the raw and cleaned data makes the workbook much easier to manage and reflects a structured workflow. &lt;/p&gt;

&lt;h3&gt;
  
  
  KPIs
&lt;/h3&gt;

&lt;p&gt;I started by calculating some important metrics that provide a quick overview of the dataset.&lt;/p&gt;

&lt;p&gt;These included:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Total number of patients&lt;/li&gt;
&lt;li&gt;Average patient age&lt;/li&gt;
&lt;li&gt;Youngest patient&lt;/li&gt;
&lt;li&gt;Oldest patient&lt;/li&gt;
&lt;li&gt;Total bill amount&lt;/li&gt;
&lt;li&gt;Average bill amount&lt;/li&gt;
&lt;li&gt;Highest bill amount&lt;/li&gt;
&lt;li&gt;Lowest bill amount&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Creating these Key Performance Indicators gave me a high-level understanding of the data before exploring it further.&lt;/p&gt;

&lt;h3&gt;
  
  
  Pivot Tables
&lt;/h3&gt;

&lt;p&gt;I used PivotTables to answer questions such as:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Which department treated the most patients?&lt;/li&gt;
&lt;li&gt;Which gender visited the hospital most frequently?&lt;/li&gt;
&lt;li&gt;Which payment status occurred the most?&lt;/li&gt;
&lt;li&gt;Which diagnosis appeared most often?
What I learnt during this process was choosing the correct calculation.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Initially, I summarised the Patient ID field using Sum, which produced incorrect results because Patient IDs are identifiers—not values that should be added together. After changing the Value Field Settings to Count, the PivotTables correctly showed the number of patients in each category. It was a small change, but an important reminder that understanding the data is just as important as knowing how to use the software.&lt;br&gt;
The next step will be to create charts from these findings before importing the dataset into SQL for more advanced analysis.&lt;/p&gt;

</description>
      <category>data</category>
      <category>beginners</category>
      <category>analyst</category>
      <category>sql</category>
    </item>
    <item>
      <title># Cleaning My Hospital Records Dataset: Preparing Data for Analysis</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Wed, 28 Oct 2026 19:03:52 +0000</pubDate>
      <link>https://dev.to/denoh/-cleaning-my-hospital-records-dataset-preparing-data-for-analysis-45cp</link>
      <guid>https://dev.to/denoh/-cleaning-my-hospital-records-dataset-preparing-data-for-analysis-45cp</guid>
      <description>&lt;p&gt;&lt;a href="https://github.com/KratosOCS/Hospital-Records-Analysis/commit/66ac2b16c06bfc801c1b2d56a6591575d0de2c46#diff-364521ec92b837857ba418bdd3e1db77e32da41e5fceb36e38c92ed9b0183549" rel="noopener noreferrer"&gt;&lt;/a&gt;After receiving my hospital records dataset and understanding its structure, the next step was &lt;strong&gt;data cleaning&lt;/strong&gt;.&lt;/p&gt;

&lt;p&gt;Before performing any analysis, it is important to ensure that the data is accurate, consistent and ready to produce reliable insights.&lt;/p&gt;

&lt;p&gt;For this phase of the project, I worked on preparing the dataset using Microsoft Excel.&lt;/p&gt;

&lt;h2&gt;
  
  
  Preserving the Original Data
&lt;/h2&gt;

&lt;p&gt;One important practice I learned is to always keep the original dataset untouched.&lt;/p&gt;

&lt;p&gt;I created a new worksheet named &lt;strong&gt;Cleaned Data&lt;/strong&gt; by copying the original records. All cleaning activities were performed on this new worksheet while keeping the raw data available for reference.&lt;/p&gt;

&lt;h2&gt;
  
  
  Data Cleaning Activities
&lt;/h2&gt;

&lt;p&gt;The following steps were performed:&lt;/p&gt;

&lt;p&gt;✅ &lt;strong&gt;Checked for duplicate records&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Reviewed the dataset for duplicate entries.&lt;/li&gt;
&lt;li&gt;No duplicate records were found.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;✅ &lt;strong&gt;Checked for missing values&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Examined all columns for blank cells.&lt;/li&gt;
&lt;li&gt;No missing values were identified.&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;✅ &lt;strong&gt;Improved data formatting&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Converted the Phone Number column into a numerical format.&lt;/li&gt;
&lt;li&gt;Formatted the Bill Amount column into Kenyan Shillings (KSh).&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;✅ &lt;strong&gt;Created a Full Name column&lt;/strong&gt;&lt;br&gt;
To improve readability, I combined the First Name and Last Name columns using Excel's CONCAT function:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;=CONCAT(B2," ",C2)
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;p&gt;After verifying the results, the original First Name and Last Name columns were hidden since the information was now represented in the Full Name column.&lt;/p&gt;

&lt;p&gt;✅ &lt;strong&gt;Improved worksheet readability&lt;/strong&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Adjusted column widths to ensure all data was displayed clearly.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  What I Learned
&lt;/h2&gt;

&lt;p&gt;This phase reminded me that data analysis is not only about creating charts or writing queries. The quality of insights depends heavily on the quality of the data being analyzed. Taking time to clean and document data creates a strong foundation for the next stages of the project.&lt;/p&gt;

&lt;h2&gt;
  
  
  What's Next?
&lt;/h2&gt;

&lt;p&gt;The next phase will be &lt;strong&gt;Exploratory Data Analysis (EDA)&lt;/strong&gt;, where I will start using Excel formulas, PivotTables, and charts to uncover patterns and insights from the hospital records.&lt;/p&gt;

</description>
      <category>productivity</category>
      <category>database</category>
      <category>learning</category>
      <category>datascience</category>
    </item>
    <item>
      <title>Dataset</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Tue, 27 Oct 2026 09:31:20 +0000</pubDate>
      <link>https://dev.to/denoh/dataset-3mm7</link>
      <guid>https://dev.to/denoh/dataset-3mm7</guid>
      <description>&lt;p&gt;Today I officially started working with my Hospital Records Analysis dataset.&lt;/p&gt;

&lt;p&gt;Receiving the dataset marked the beginning of a project that I’ll be using to strengthen my skills in Excel, SQL, and Power BI. Instead of jumping straight into analysis, I’m taking the time to understand the data and build good habits from the start.&lt;/p&gt;

&lt;p&gt;My plan for this project is to:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Explore and understand the dataset&lt;/li&gt;
&lt;li&gt;Clean and prepare the data in Excel&lt;/li&gt;
&lt;li&gt;Write SQL queries to answer business questions&lt;/li&gt;
&lt;li&gt;Build an interactive Power BI dashboard&lt;/li&gt;
&lt;li&gt;Document every step on GitHub&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;I’m treating this like a real-world analytics project, focusing not only on finding insights but also on following a structured workflow and documenting my progress.&lt;/p&gt;

&lt;p&gt;Looking forward to sharing what I learn as I continue building this project.&lt;/p&gt;

</description>
      <category>datascience</category>
      <category>productivity</category>
      <category>career</category>
      <category>database</category>
    </item>
    <item>
      <title>Git &amp; GitHub</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Wed, 09 Sep 2026 20:34:42 +0000</pubDate>
      <link>https://dev.to/denoh/git-github-3pld</link>
      <guid>https://dev.to/denoh/git-github-3pld</guid>
      <description>&lt;h2&gt;
  
  
  Recent Milestones
&lt;/h2&gt;

&lt;p&gt;One of my biggest achievements so far has been learning Git and GitHub. After setting up Git on my Mac, I successfully connected it to my GitHub account and pushed my very first project to a remote repository. Along the way, I  have learnt how to navigate the terminal, create project folders, initialize Git repositories, create and edit &lt;code&gt;README.md&lt;/code&gt; files, stage changes, commit my work with meaningful messages, and push my code to GitHub.&lt;/p&gt;

&lt;p&gt;These may seem like small steps, they have given me a solid foundation in version control—an essential skill for every data analyst and developer. Every command I learn brings me one step closer to becoming more confident in managing projects and collaborating with others.&lt;/p&gt;

</description>
      <category>github</category>
      <category>git</category>
      <category>datascience</category>
      <category>beginners</category>
    </item>
    <item>
      <title>My Roadmap to Becoming a Data Analyst</title>
      <dc:creator>Dennis Wachira</dc:creator>
      <pubDate>Tue, 08 Sep 2026 19:42:36 +0000</pubDate>
      <link>https://dev.to/denoh/my-roadmap-to-becoming-a-data-analyst-4md3</link>
      <guid>https://dev.to/denoh/my-roadmap-to-becoming-a-data-analyst-4md3</guid>
      <description>&lt;h2&gt;
  
  
  Introduction
&lt;/h2&gt;

&lt;p&gt;My name is Dennis, and I'm excited to share my very first article on DEV. Through this blog, I'll be sharing what I learn, the challenges I encounter, the projects I build, and the lessons I pick up throughout the journey. My hope is that my experiences will encourage and help others who are also taking their first steps into the world of data.&lt;/p&gt;

&lt;h2&gt;
  
  
  My Data Analytics Toolkit
&lt;/h2&gt;

&lt;p&gt;As I begin my journey into data analytics, I've chosen to focus on a set of tools that are widely used across the industry. Each one plays a unique role in the data analysis process, and together they form the foundation of my learning roadmap. They are the following;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Excel&lt;/strong&gt; - Data cleaning, organization, and analysis.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;SQL&lt;/strong&gt; - Querying and managing data from databases.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Python&lt;/strong&gt; - Data manipulation, automation, and analysis.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Git and GitHub&lt;/strong&gt; - Version control and project collaboration.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Power BI&lt;/strong&gt; - Transforming raw data into meaningful dashboards and reports.&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;&lt;strong&gt;Microsoft Fabric&lt;/strong&gt; - Brings together data engineering, data science, data warehousing, and business intelligence.&lt;/p&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;These tools represent more than just software—they're the building blocks of my journey toward becoming a skilled data analyst. I'm looking forward to learning each one step by step, applying them to real projects, and sharing what I discover along the way.&lt;/p&gt;

</description>
      <category>beginners</category>
      <category>career</category>
      <category>database</category>
      <category>coding</category>
    </item>
  </channel>
</rss>
