Many data scientists have heard the line – “People spend 80% of their time prepping data and only 20% of their time analyzing it.” And now, as an overload of data becomes available, dealing with untidy data becomes excessively difficult. Cleaning data is known as one of the most tedious jobs in a data scientist’s […]
Welcome back to the articles on Tableau Prep. Today we’ll be discussing the interface of Tableau, how to use it, and the Input step In Tableau. The Start Screen and Connecting to Data When we open Tableau, we begin on the start screen. At the far right, we have the discover pane, which shows education […]
Power BI’s user-base is growing daily. In just a few years, the adoption of Power BI into data productivity suites has exponentially grown. The team at Microsoft provides monthly updates that increase Power BI’s functionality and customization. If you are familiar with the field of data visualization, you would have heard of Power BI as […]
Line graphs don’t have to be boring. Seaborn line charts add a whole new opportunity to make your line charts stand out and communicate new insights. Follow these easy to follow tutorial on how to to create line chart in Seaborn. There specifics that will be covered are colors, style and error bars. The fist […]
Data is from the Center for Disease Control which has health and disease penetration by state, county and city. This dashboard was created in Microsoft Power BI with two CSV export from the CDC that listed percentage of residents with diabetes by year and state. No calculated measures were created due to the data having percentages. […]
What is Pandas? Pandas is a Python library that used to read, clean, visualize, and process a dataset. Pandas uses a high-performance data analysis functions to manipulate data a structures which called data frame. You can compare this to a table in tools like Excel. Learn Python with Codecademy. Master the skill that your future […]
The importance of data analytics and visualization has grown tremendously over the last 5 years. The terms Data transformations, Big Data, AI, and Blockchain are discussed in every sphere of business including operational staff and c-suite executives. It is of paramount importance that huge data sets are visualized efficiently to give managers better insights and […]
This data was sourced from Kaggle which had both McDonalds and Starbucks items datasets. The data was broken up by items and nutritional elements. I put this data into a Power BI dashboards. There were several functions to get this to work. The exercise data set was sourced from Nutri Strategy I based all […]
How to use natural language sentiment analysis in your text data with Power BI. I am really starting to fall in love with Power BI now that I have the ability to use Python scripts to transform my data and bring my visuals to a whole new level. We will use the NLTK Sentiment Intensity […]
There are multiple ways to join, concatenated and merge data using Pandas. However, it all depends on your use case. For the examples below, we are going to use the example of a pickle shop merging their data with an ice cream shop to create a single data frame. Let’s take a look at the […]