More About This Blog.

Mark John Merana
Mark John Merana
Junior Data Analyst
1+
Yr Learning
About Me

Analyst in Progress.
Learning Out Loud.

I'm a junior data analyst currently specializing in Power BI and SQL Server. I'm at the beginning of my data career — building real projects, documenting what I learn, and sharing the process honestly.

ENGR INSIGHT is where I publish my project write-ups. It's not a course or tutorial blog — it's a record of actual things I've built, the decisions I made, what worked, and what I'd do differently.

My current focus is on becoming genuinely good at the fundamentals: writing clean SQL, understanding data modeling, and building Power BI reports that actually answer business questions.

Read My Blog Get In Touch ⬇ Resume
// Current Skill Levels
Power BI (Reports, Visuals, Slicers)80%
SQL Server (Queries, JOINs, Aggregations)75%
DAX (Measures, Calculated Columns)45%
Excel (Pivot Tables, Power Query, XLOOKUP)85%
Data Modeling (Star Schema basics)60%
Python Programming (Numpy, Pandas)50%
What I Can Do

Current Capabilities

📊
Power BI Reports
Interactive dashboards with KPI cards, bar/line charts, slicers, drill-through pages, and conditional formatting.
🗄️
SQL Queries & Data Prep
SELECT, JOINs, GROUP BY, subqueries, CTEs, and basic stored procedures in SQL Server.
📐
DAX Measures
Writing measures for totals, averages, % calculations, and basic time intelligence functions.
🔗
Data Modeling
Building simple star schemas — fact and dimension tables — for clean Power BI relationships.
What I'm Learning Next

On the Roadmap

Advanced DAX
CALCULATE, context transition, FILTER, iterator functions
Power Query (M Language)
Data transformation and cleaning inside Power BI Desktop
SQL Server Stored Procedures
Automating data prep logic for repeatable reporting
PL-300 Certification
Microsoft Power BI Data Analyst certification — in progress
Python for Data Analysis
Pandas and data cleaning — a future goal, not yet a skill
0
Days of Learning
0
On-Going Dashboard
0
Dashboard Published
Still Learning