Best Power BI Courses

​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 […]

Easy Forecasting in Excel

Forecasting with the Trend line Click on your line graph.Click the [ + ] button on the chart to open the chart elements menu.​Choose the trend line (Linear or Exponential).Right Click the Trend line, Choose Format Trend line.Under Forecast choose the number of the period into the future you want to forecast.Use Array Functions (Growth […]

Data Analyst Toolkit

As a data analyst there is a wild range of tools you need for exploration, analysis, visualization and prediction. I thought this was good opportunity to explore the most popular and go to tools for data analyst.Stage 0: Identify Business Questions.These tools are critical for collection thoughts and ideas from stakeholders. This is the most […]

Create Data Bars and Star Rating KPIs in Excel

​You can easily get data bars and star ratings added to your report with a few steps. Often a way to save real estate and indicate differences, people use the spark line visuals. However, this can only be effective if you are dealing with time series data. So, this tutorial is going to show a […]

Top E Sports Earners

E-sports has been become a multi-million dollar industry with over 160 million dollars in prize money in 2019 alone.  I wanted to explore the earnings of the top tournaments, players and games below. There is an awesome sight with all this data compiled and tracked. You can go to esportsearnings.com . If want you learn […]

Tableau Prep – The Cleaning Step, Group and Replace

Introduction Data is like blood flowing through an organization and, just like blood quality is directly linked with the health of the body, organizations only function effectively when the quality of their data meets the minimum quality standards. In real life, data that is used for visualization is typically sourced from a variety of different […]

Excel Users Intro into Python

Data Science can be an incredibly daunting venture to undertake. As time continues, what constitutes data science morphs and changes. However, in a scientist is someone who uses a proven logical method to understanding and ascribe meaning to unknown phenomena. A data science doesn’t have a physical library, pipets, test tubes. They have a collection […]

Tableau Prep Tutorial

Use the tutorials below to help you gain a deeper understanding on what Tableau Prep can do for your data, business and overall visuals. Follow each step in the tutorial of jump around to the tutorial that fits your needs.  Getting Started with Tableau Prep Go to the Tutorial Tableau Prep is a great tool. […]

Tableau Prep – The Profile Pane and Pivot Step

Introduction and Significance Exploring data is probably one of the first things a data analyst would do when dealing with a new data set. It is important to understand the profile or the characteristics of the data before you start analyzing and visualizing it. Case Study For this article, let’s use a hypothetical case study […]

Getting Started with Tableau Prep

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 […]

The Tableau Prep Interface and the Input Step

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 […]

1 2 3 9