Internship Experience at DeltaX

Akshay Surve
Jul 30, 2017 · 2 min read

Today happens to be my last day of the internship — and so, is a good time to pause and ponder of the weeks that flew by. As part of this blog post, I plan to share what I worked on, learnings and my overall experience.

In the past seven weeks, I created a dashboard using Microsoft’s Business Intelligence(BI) and data visualization tool — Power BI. I had a chance to appreciate the visual platform provided by the tool. I also learned that it is very important to choose the right visual to represent your data. A careless choice can leave the client confused. The task is easy when your goal is to just put visuals together using the various options available by the Tool. It becomes more challenging when you look at the dashboard as a product for your client. Every dashboard should tell a story. BI tools help polish data into effortlessly understandable visuals to the viewer.

PowerBI Dashboard
PowerBI Dashboard

Power BI allows you to create computed measures, tables and columns using DAX — Data Analytics Expressions. DAX is a simple query and formula language. Their functions on tables range from statistical calculations like “SUM” and “AVERAGE” to FILTER operations and grouping. I found their Time Intelligence functions like “DATEADD” and “PARALLELPERIOD” particularly interesting. These functions are extremely powerful when you want to compare data for a certain attribute over different periods of time. DAX fails when you want to store your visual data in a temporary and operate on that data. Here’s where R scripts come to the rescue. I worked on an algorithm in R which selectively produced different visuals based on certain conditions met. However, R visuals are still not supported by Power BI’s web URLs. Another shortcoming of Power BI is that it offers very limited help for alignment of visuals in a report. It makes this process manually tedious.

Data has always interested me. Looking into the future, I intend to work for a couple of years and then pursue a Masters in Data Science or an MBA.

The environment at DeltaX is very relaxed yet conducive to immense learning. Everyone here is so passionate about their work and strive for perfection. I am really impressed by how problems are solved at DeltaX, especially the brainstorming sessions around the whiteboard. I would like to thank everyone at DeltaX for making it such a fun and fruitful place to work at. I sincerely thank Priyank and Krishna for being such amazing and patient mentors who were always ready to help. Not to miss Amrith and Akshay for giving me this opportunity.

All in all, this was a sprint that was worth it!

deltax-recursion

{recursion} because culture is recursive - by DeltaX Engineering Team

    Akshay Surve

    Written by

    deltax-recursion

    {recursion} because culture is recursive - by DeltaX Engineering Team

    Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
    Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
    Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade