From working on Power BI for 4 years and providing training to freshers in my current organization. Here is what I have understood what one needs to learn Power BI. Download Power BI from this link. We will learn here right now. Hack: Imagine you have some data(Preferably 2–3 Tables)…

“Nail the basics first, detail the details later — Chris Anderson” This will be the 4th and last “Explained Like you are 5” series for Must have skills for Data Analytics that I am writing about. (Please watch the other ones — Power BI, Python, and SQL from). …

I have been learning and researching a lot about Python. I wanted to learn how to code. I will be honest, the sole purpose of learning coding was FOMO. My friends were great at coding and they always used to talk about code and I was working on NO code tools…

“Nail the basics first, detail the details later — Chris Anderson” This will be the 2nd “Explained Like you are 5" series for Must have skills for Data Analytics that I am writing about. (Please watch the first one(Power BI) from here). Next ones are Python and Excel. …

If you want to take only 1 takeaway from this article that would be this: Data Modeling is designing and relating different tables so that the data is more optimized, more understandable, and clean.You do not need to be do it in every scenario. I have a very contrarian view of data modeling. All the things that I mentioned above are separate from finding insights from the data. Say for example in one my previous article, I was trying to find out my internet usage behavior using data, it was a flat file. I didn’t need to do data modeling to come up with any insights.

If you start to learn any language. It takes a lot of time to learn and internalize all the things associated with it. I have been working with DAX for over 4 years now. Recently Someone asked me if I had to learn DAX from scratch, how would I go…

I was fed up with the habit of my internet addiction. So I started exploring my web history to find where I am spending the most time and If it is not productive I can curb it or block it. — That is the thing I love about being an analyst, converting a problem into data and then using that data to find out the findings(As our mind is not suitable to handle that many variables. …

If you are an aspiring data analyst, you must learn SQL. If you are currently learning SQL now, YOU NEED TO LEARN WINDOWS FUNCTIONS IN SQL. …

I have created a list of websites where beginner-level data analyst can start their journey and directly learn whats required. SQL: SqlZoo - You can learn SQL only by doing it. Get going by doing it. Go to: https://sqlzoo.net/wiki/SQL_Tutorial…