Forem: muriithilydia46-wq

Introduction to SQL: DDL, DML, and Querying Data

muriithilydia46-wq — Sun, 12 Apr 2026 12:49:25 +0000

As a beginner database administrator, my first assignment was to build a school database for Nairobi Academy from scratch. At first this seemed impossible, especially since I had repeated cases of errors in my queries the whole week. But I soldiered on, ready to research and debug any cases of errors and finish the project. So here is what I learned about SQL this week and some tips;

"SQL stands for Structured Query Language". We use several languages in SQL, main ones being; DDL (Data Definition Language) & DML (Data Manipulation Language)

DDL defines database structure using the following commands; CREATE, ALTER, and DROP.
DML simply entails changing data inside the tables. The main commands used are INSERT, UPDATE, SELECT and DELETE

Think of it this way; DDL builds the house, DML fills it with furniture.

In my current project, the main commands I used were CREATE, INSERT, UPDATE, and DELETE and I will take you through the 'how' shortly.

I used CREATE to create a schema called nairobi_academy, then CREATE TABLE to build three tables: students, subjects, and exam_results;

I also used ALTER TABLE to modify tables after creation, that is; adding a phone_number column, renaming credits to credit_hours, and dropping phone_number when it was no longer needed. This taught me that SQL is flexible and you can always adjust a table's structure even after it has been created.

Next, I used INSERT command, where I added 10 students, 10 subjects, and 10 exam results into the database -see example below;

I then used UPDATE command and corrected data that had changed. For instance; updating Esther's city from Nakuru to Nairobi, and fixing incorrect marks from 49 to 59.

In addition, I used DELETE command to remove a cancelled exam result from the table.

NB: The most important lesson with UPDATE and DELETE is that, always use a WHERE clause, else every single row in the table gets affected and will be deleted.

Another key lesson has been how to use SQL filtering functions e.g., WHERE, SEARCH, IN, NOT IN, COUNT & CASE WHEN.

The WHERE clause filters rows based on conditions while CASE WHEN works like an if-else statement. It creates new labels based on conditions without changing the original data.

examples;

The biggest challenge this week was managing errors when running scripts multiple times. Some errors I encountered today was "relation already exists" and it kept appearing till it got frustrating. I learned that using IF NOT EXISTS and DROP SCHEMA CASCADE solves this cleanly.

I also learned the hard way that column names matter. For instance; renaming credits to credit_hours after inserting data caused errors because the INSERT still referenced the old name. Order really matters in SQL! Do not give up when creating and querying data in SQL, remain calm, research on how to debug and you've got it!

How to publish a Power BI report and embed it in a website.

muriithilydia46-wq — Sun, 05 Apr 2026 10:26:57 +0000

Power BI is a tool created by Microsoft to turn raw data into interactive insights.

The publishing process entails the below key steps;

Creating a workspace
Publishing power BI report
Creating an embedded code
Embedding the report on a Website

Here is a detailed process of the step by step process flow for a successful publishing.

1.Creating a workspace.
Open a browser and sign in with Microsoft account. Use below link,
https://app.powerbi.com

Select “Workspaces” on the left navigation pane, then click “New workspace”

Fill in the details populated, then click “apply”. This auto-populates your new workspace.

2. Publishing Power BI reports
Having created your own workspace, you can now upload your report using the below steps;

Open your finished report in Power BI desktop
Click “publish” on the Home tab;

Select a destination (the workspace you had created earlier), then click select;

The report is automatically uploaded in your workspace. Check your workspace to verify the uploaded data.

To open the report, click on it and it will automatically open.

3. Create an Embedded Code.
There are three different ways to embed a report;

Publish to web (Public)
Power BI gives you an iframe code you can drop into any website. It makes your report publicly accessible to anyone with the link. It is therefore not suitable for confidential reports. Here is how you go about it;

Open your published report in Power BI service, then under the report menu, click file >Embed report>Publish to web;

*Secure Embed (internal use). *

Viewers need to log in with their Microsoft account to see it. Great for internal company pages like a SharePoint site or Teams tab. It keeps the data protected without much technical setup.

Build it into your app (Developer route).

This one is for when you're building a product for a client for instance, and where they do not have Power BI Licenses. e.g., a SaaS tool. It requires more setup (you'll need to work with Azure and the Power BI API), but it's the most powerful and flexible option.

4.Embedding the report on a Website;

Click File in the top menu
Select Embed report → Publish to web (public)
Click Create embed code
Copy the iframe code that appears to your text editor (Vs code)
Create a folder in your desktop and name it deploying/publishing.
Open the folder in VS code and click select.

under the folder, create a new file, i.e., index.html

Open this website in your browser https://www.w3schools.com/html/ and copy the html code and paste it in your text editor and save.

Go to the folder created in desktop (deploying/publishing) and select the folder, then click index;
Copy the url generated and copy it to your browser;
Go back to text editor (VC code) and delete “this is a paragraph)
History copy (windows + V) on the line you have deleted and it select iframe (the embedded code)
Copy the code above and go back to your browser and refresh.
You will get a sign in prompt, proceed to sign in;
After signing in, your report automatically load;

In conclusion, learning power BI has been an eye opening experience as a beginner data analyst. Going in, I expected it to be mostly about making charts look good, but I quickly realised that the real work happens long before you touch a single visual. Cleaning messy data and building a solid model is where most of your time and energy actually goes. Publishing felt like a milestone and is genuinely satisfying. Learning different ways of embedding reports as well felt more like a professional lesson, to ensure I do not publish publicly confidential information and face data breach suits.

How excel is used in Real-World Data Analysis

muriithilydia46-wq — Thu, 26 Mar 2026 18:48:50 +0000

Microsoft Excel is a spreadsheet software that allows you to collect, organize, analyze, calculate, and visualize data efficiently. It organizes data into a grid of rows and columns, where each intersection is called a cell. Each cell can hold text, numbers, dates, or formulas that perform calculations automatically.

In real world, excel has been widely used in data analysis. For instance, where large data sets are involved, excel becomes instrumental in organizing the data and creating a dashboard for visualization. In essence this makes the data easily consumable for insights by management and aids in decision making.

In my first week of study as a data analyst, I have come to appreciate the capabilities of excel. What has really intrigued me is data clean up, use of pivot tables, charts and creating an interactive excel dashboard.

Did you know you can remove extra spaces from your text using text functions? Just use the following formula;'=TRIM(text)'. Additionally, you can combine two columns using the function "Concatenate". Here is how; =Concatenate(text). You have to specify if you need a separator, such that you put the space in parenthesis e.g. '=CONCATENATE(A2, " ", B2)'

The most insightful lesson has been on using pivot tables to show case relationship analysis, and using the pivot tables as primary data source for creating charts and excel dashboard.

A PivotTable is a tool that automatically summarizes large amounts of data. Instead of writing formulas, you simply drag and drop fields to group and calculate your data.
Example use: You have 5,000 rows of sales data. A PivotTable can instantly show you total sales per region per month instantly.

Drag a field to rows - groups your data e.g., by product category
Drag a field to values -calculates totals, count, average, Mid etc.,
Drag a field to filters -narrows down the criteria of what to see.

NB: Slicers are also used in place of filters. To insert a slicer, click inside any pivot table, Go to insert tab, click "slicer" and then select the fields you want slicers for.

Charts visualize your data so patterns and trends are easier to understand. Excel offers many chart types, most commonly used being; bar chart, line chart, pie chart and column chart.

Lastly, creating an interactive dashboard on excel is the main output for visualization. You start by creating a title for your dashboard and KPIs by inserting a shape. You then copy the pivot tables previously mapped from your data source and insert slicers. Ideally, slicers should be on the left side, while KPIs should be on top. You then right click on the slicers then click "report connections". This was the dashboard is now interactive.

Lastly, you create an excel dashboard using pivot tables as the source data, but first you need to write the title of your dashboard and the KPIs.

The next step is to copy the pivot tables previously mapped into the dashboard, including slicers. You then create connections for the slicers such that any change is reflected in all charts.

Excel has been life changing to me and I am already utilizing some of the skills learnt so far in my day to day work activities.