From Messy Vehicle Records to a Power BI View of JCars Logistics
Introduction A dashboard can make information easier to explore, but it cannot make unreliable information reliable by itself. For our JCars Logisti…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
backend
beginners
career
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
My First PowerBI project
My first project that did without guidance on PowerBI was quite interesting.Jcars dataset. I remember it opening PowerBI and loading the data and st…
JCars Logistics Analysis: Data Preparation, Modelling, and Business Insights
Introduction A Power BI dashboard is only as reliable as the data behind it. For the JCars Logistics project, the starting point was not a clean ana…
From Raw Data to Business Decisions: Building a Power BI Solution for JCars Logistics
Introduction JCars Logistics imports, sells and delivers vehicles across Kenya. Management wanted a report that could answer simple questions like:…
Building the SafariConnect Dashboard
Wednesday's job was simple to state and hard to do: turn a PostgreSQL schema full of correct answers into something a CEO could read in ten seconds.…
Power Bi: Data Modelling, Relationships and Joins
Introduction Picture this measures that return the wrong totals, slicers that don't filter what you expect, and reports that slow down as data grows…
Bridging Local and Cloud Databases for Centralized Data Management
Introduction Structured data (typically in rows and columns) resides in databases such as PostgreSQL or MySQL . These databases can be hosted locall…
From a Messy Spreadsheet to Business Insights: Analyzing a Hotel's Booking Data
How I cleaned 285 rows of real-world-style hotel data in PostgreSQL and turned it into revenue, occupancy, and guest-satisfaction insights in Power…
Relationships, Schemas and Joins in Power BI: A Practical Guide to Data Modelling
Flat tables, star schemas, snowflakes, cardinality, filter direction, and Power Query joins, in plain language. My first Power BI report was a 12 co…
Power BI Data Modelling, Relationships and Joins.
Introduction When I first started working with Power BI, I thought that importing data and creating charts was the main part of building a report. H…
Understanding Schemas, Relationships, and Data Modeling in Power BI.
Introduction Importing data into Power BI is only the beginning of the analytics process. A dashboard is only as reliable as the data model behind i…
SUM vs SUMX in DAX: Why a Row-by-Row Calculation Needs an Iterator
By Michael Nocito , data analyst · Published August 10, 2026 By the end of this page you can look at any DAX aggregation and say which of the two it…
"Power Query Error: Formula.Firewall and Privacy Level Errors"
This isn't a syntax error or a bug in the query — it's Power Query's Formula Firewall refusing to combine data from more than one source until it kn…
Power BI Relationships & Joins: Why Your Tables Need to Be On Speaking Terms
Power BI Relationships & Joins: Why Your Tables Need to Be On Speaking Terms Picture this: you walk into a wedding. The seating chart says Table…
Stop Guessing, Start Modeling: Relationships, Schemas & Joins in Power BI
A database without relationships is just a spreadsheet with delusions of grandeur. If you've ever stared at a Power BI report showing wrong numbers.…
Connecting Data the Right Way: Modeling, Relationships, and Schema Design in Power BI
As a data professional, one norm that I have had to accept is that raw data rarely comes in one neat package. Most of the times, it'll be scattered,…
Power BI Finally Started Clicking(Schemas, Relationships & Joins)
You've loaded your data into Power BI. You've got the tables. Now what are you expected to do? Here's the thing most beginners skip: how your tables…
Power BI
What is Power BI? Power BI is a business intelligence tool made by Microsoft. It lets you: Connect to data (Excel, CSV, databases, websites, etc.) C…
Дашборд для SSRS и Power BI Report Server, которого нет ни у кого: собираем сами и забираем готовым
Готового мониторинга для SSRS и Power BI Report Server в сети нет - одни обзоры «SQL Server» с CPU и памятью. Собрал свой на Grafana: трейс упавших…
Build Power BI Columns That Adapt to Each User
Originally published at https://shai-kr.github.io/data-ninja-ai-lab/blog/2026-05-28-user-aware-calculated-columns-power-bi.html . Power BI calculate…
How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI
Losing great employees is incredibly expensive for businesses. To show potential employers how I tackle real-world business problems using data engi…
Mastering Power Query in Power BI: A Complete Data Transformation Guide
Power Query is the backbone of data preparation in Power BI. Before you can build stunning dashboards or write complex DAX, your data needs to be cl…