Over the past couple of years, my career as a full-stack developer has naturally gravitated toward the true foundation of all modern applications: data. While building robust backend architectures and scalable APIs is incredibly rewarding, I realized that the true value of software lies not in the code itself, but in the insights we can extract from the data it generates. This realization sparked my deep, enduring interest in the Data Analytics sector.
Today, having accumulated over a year of dedicated experience in the data analytics space here in Nepal, I want to share my journey. From writing complex SQL queries to mastering DAX in Power BI, my goal has always been simple: turn raw numbers into actionable strategies that create a better future for businesses.
Visualizing Growth at Arctic Ice Nepal
My most impactful experience in this domain has been my ongoing work as a Data Analyst for Arctic Ice Nepal. Working closely with the founders and executive team, my core responsibility has been to transform disjointed operational data into clear, executive-ready KPIs.
In a rapidly growing market like Nepal, businesses often possess vast amounts of data but lack the analytical tools to see the bigger picture. At Arctic Ice, I focused on bridging that gap. This wasn't just about making pretty charts; it was about solving real operational bottlenecks:
- Conducting deep market research and competitor analysis to identify untapped growth opportunities in local markets.
- Designing interactive business intelligence dashboards that track sales trends, inventory health, and operational metrics in real-time.
- Automating weekly reporting workflows, which drastically cut down manual compilation time and improved data reliability across reporting cycles.
- Taking ownership of end-to-end data workflows—from collection and validation to sales tracking—ensuring the executive team always has decision-ready visibility.
Impact of Reporting Automation
Time spent manually compiling weekly executive reports (Illustrative Data).
Seeing how a well-designed visual report can pivot a company's strategic direction made me realize that a good data analyst doesn't just report the past—they help shape the future.
The Power of SQL: Queries and Optimization
You cannot be a strong data professional without a deep mastery of SQL. My background in software engineering gave me a massive head start here. Dealing with multi-tenant architectures and processing millions of records across 150+ countries (during my time at GenAILabs) taught me that writing a query that works is entirely different from writing a query that scales.
When dealing with large datasets, I prioritize three core pillars of database management:
- Schema Design & Normalization: Structuring relational databases (PostgreSQL, MySQL) to balance strict normalization with high-speed read performance. A well-thought-out schema prevents data anomalies and massive technical debt.
- Query Optimization: Utilizing proper indexing, avoiding N+1 querying problems, and leveraging complex window functions and CTEs (Common Table Expressions) to aggregate data efficiently on the server side.
- Data Integrity & ETL: Ensuring that the data ingestion pipelines feeding the analytics engine operate at 99.9% accuracy. An insight is only as good as the underlying data.
Database Query Optimization (GenAILabs)
Average query latency reduction for complex analytics workloads.
Expanding the Toolkit: Learning Power BI and DAX
While SQL is perfect for extracting, filtering, and transforming raw data, visualizing it effectively for non-technical stakeholders requires dedicated Business Intelligence tools. To complement my data engineering skills, I have been actively deepening my expertise in Power BI and DAX (Data Analysis Expressions).
DAX is fascinating because it blends the accessible, functional logic of Excel with the relational power of SQL databases. Learning how to write efficient DAX measures has completely upgraded how I build dashboards. Some of my focus areas in DAX include:
- Time-Intelligence Functions: Calculating Year-over-Year (YoY) growth, Month-to-Date (MTD) sales, and moving averages to provide context to static numbers.
- Dynamic Filtering: Using `CALCULATE` and filter context modifiers to allow stakeholders to slice and dice data across different dimensions (e.g., region, product category) seamlessly.
- Data Modeling: Establishing robust Star Schemas with fact and dimension tables within Power BI to ensure dashboards remain responsive even with large underlying datasets.
This toolkit empowers me to create dynamic, interactive reports where executives can find exactly the granular insights they need to optimize daily operations.
Why I Care About Data (and Why You Should Too)
Being a data analyst is about far more than just maintaining databases and building charts. It is about care and impact. I care deeply about the accuracy of the numbers because I know real people and real businesses rely on them to make critical decisions—from making payroll and optimizing supply chains, to finding new avenues for market expansion.
The tech sector in Nepal is evolving rapidly, and data maturity is becoming the key differentiator between companies that survive and those that thrive. As businesses scale locally and globally, the demand for professionals who understand both the engineering side of data ingestion and the business side of data visualization will only grow.
I am incredibly excited to continue pushing my boundaries in Data Analytics. By combining my software engineering rigor with my passion for business intelligence, I look forward to helping forward-thinking companies build a stronger, highly optimized, and data-driven future.