Vikas Kashyap
Data visualization engineer, Data Analyst, BI Expert
Behind the Scenes: DAX Logic for Gantt Chart Status
I recently built a DAX measure to automatically determine whether a project is Completed, Delayed, or Open inside a Gantt chart.
The logic checks the project’s start/end dates, identifies if today falls within that range, and...
Some problems in Power BI look simple… until you try to solve them.
Recently, I was working on a dashboard where I needed something very specific:
👉 Identify the 2nd highest Salesperson based on Total Finance.
Sounds easy, right?
Until you realize that DAX doesn’t have a direct...
Built a marketing and traffic source analytics dashboard using GA4 and Looker Studio. Transformed raw acquisition data into a clear, insight-driven overview highlighting top channels, user behavior, engagement, and conversion performance. Designed custom visualizations, applied...
Developed an executive-level ecommerce analytics dashboard for the Google Merchandise Store using GA4 and Looker Studio. Consolidated key metrics—traffic, engagement, product performance, and conversions—into a clear, high-impact overview. Integrated GA4 data, applied custom...
Developed a 5-page Ecommerce Analytics Report in Looker Studio using BigQuery public dataset "thelook_ecommerce." Combined multiple tables — Orders, Products, Order Items, and Users — through advanced SQL joins to create a unified view. The connected dataset enabled rich,...
