I am going to attempt to help you in grasping Loc and iLoc in Pandas. I set out to describe these two concepts because I and others have struggled with them. When I received my Aha! moment, I knew then it was time to write about. So let's get you over the hump of learning these two constructs! I am assuming that since you are reading this, you are a beginner (or close to it) in Python/Pandas. You probably have been struggling with learning about loc and iloc. Based on this assumption, I am going to deviate from my usual format - that is, I am not going to include the code on GitHub or the ..read more

You need sophisticated software packages that you pay thousands of dollars a month to create stock charts, right? Perhaps that is the way it used to be. But these days, with the right Python libraries, you can create stock charts in two lines of code. That is what you will learn how to do here. What's the Catch? There really isn't a catch. Of course, if you are expecting these charts to have all the bells and whistles of sophisticated software using two lines of code, you're likely to be disappointed. However, these same Python packages can certainly measure up to the big tools when using mo ..read more

We know that data has permeated our lives. Every action you take these days seems to generate data. Whether that is good or bad is up for debate. But what is true is that data is being collected and more people will need to learn how to process and analyze that data. If you are one of those people, you can expect to have more favorable job outlooks. However, you first need to understand what skills you need for data analysis. Want to skip this article and start your learning for your data analyst career? You can try it out to see if it's right for you. Learn more about why learning the pro ..read more

The DAX language is deceptively complex. The dynamics of the language itself, are actually easy. It's the nuances that trip people up, even experienced DAX programmers. If you are just getting started, though, you'll likely struggle on where to start. This article will help you with many projects. We'll discuss the four core DAX measure that you should always create from the start. Many DAX projects work with sales data. Most of the tutorials or articles you search for on Power BI or DAX will use sales data as the samples to illustrate the techniques. This is likely due to sales data is wha ..read more

I am going to attempt to help you in grasping Loc and iLoc in Pandas. I set out to describe these two concepts because I and others have struggled with them. When I received my Aha! moment, I knew then it was time to write about. So let's get you over the hump of learning these two constructs! I am going to assume that since you are reading this, you are a beginner (or close to it) in Python/Pandas. You probably have been struggling with learning about loc and iloc. Based on this assumption, I am going to deviate from my usual format - that is, I am not going to include the code on GitHub ..read more

You need sophisticated software packages that you pay thousands of dollars a month to create stock charts, right? Perhaps that is the way it used to be. But these days, with the right Python libraries, you can create stock charts in two lines of code. That is what you will learn how to do here. What's the Catch? There really isn't a catch. Of course, if you are expecting these charts to have all the bells and whistles of sophisticated software using two lines of code, you're likely to be disappointed. However, these same Python packages can certainly measure up to the big tools when using mo ..read more

We know that data has permeated our lives. Every action you take these days seems to generate data. Whether that is good or bad is up for debate. But what is true is that data is being collected and more people will need to learn how to process and analyze that data. If you are one of those people, you can expect to have more favorable job outlooks. However, you first need to understand what skills you need for data analysis. Want to skip this article and start your learning for your data analyst career? You can try it out to see if it's right for you. Learn more about why learning the pro ..read more

The DAX language is deceptively complex. The dynamics of the language itself, are actually easy. It's the nuances that trip people up, even experienced DAX programmers. If you are just getting started, though, you'll likely struggle on where to start. This article will help you with many projects. We'll discuss the four core DAX measure that you should always create from the start. Many DAX projects work with sales data. Most of the tutorials or articles you search for on Power BI or DAX will use sales data as the samples to illustrate the techniques. This is likely due to sales data is wha ..read more

When analyzing data, analysts should adhere to best practices. Once such best practice is to use a star schema for the data. At its basic level, a star schema contains one or more fact tables, and several lookup tables. But data often doesn't come to the analyst as a star schema, which means the analyst must transform it. That often requires extracting lookup table information from the fact tables. This article will give you steps on how to do this. Specifically, it will show you how to create lookup tables from fact tables using merge in Power BI. Insert Image What Is Needed for this Tutori ..read more

Let's face it. Looking at data sometimes can be a nightmare. It never seems to conform to the neatly laid out samples from training modules. Often, the data you obtain is a scattered mess. How do you make sense of it all? This article will help learn how to get familiar with your data. The variety of data formats makes analyzing it a challenge. However, these formats often take on patterns that you can use to your advantage. When you start to recognize these patterns, you data cleansing efforts become easier. Why is Data "Dirty"? You'll probably hear data being described as dirty. It's easy ..read more