Gaelim Holland
Author Archives: Gaelim Holland

Power BI Interview Questions

Here is a list of commont Power BI interview questions that are open ended and use to demonstrate the overall knowlege of the applicant. These questions are real and allow you to find intermediate level Power BI practioners. Answering 6 out of the 10 question would demonstrate a confident familiarity with Power BI.  1. Where […]

Calculate Totals Month to Date & More in Power BI

How to Calcuate MTD, QTD and YTD in Power BI Calculating the month to date, year to date, or quarter to date is not as daunting as you think in DAX. However, there are few stepst that are needed before you can get these function to provide the information that you are looking for.  These […]

Format all the Font in Power BI

You can quickly get uniform text accross your visuals by using the Power BI themes customization. In just a few steps you will be able to quickly alter the text family. Step 1: Go to Theme OptionsThe first step you will need to take is to navigate to the top ribbon in Power BI and click […]

Forecasting with Python and Power BI

We are using an airline passenger dataset​ that you can get from Kaggle, which shows us the data from 1949 to 1960 for airline passengers.  Load in my dependencies, which are pandas and numpy and Mapplotlib. I’m just going to import those in. And then once I have that, I’m going to read in the CSV […]

Rolling Averages In Power BI

Getting a rolling average should be an native function in Power BI. However maybe at the time you read this, there will already be a a feature added. However, in the meantime lets dive into dynamic rolling average using Power BI.Here are the list of functions will be using the to create our calculation:SUMCALCULATELASTDATEDATESINPERIODDISTINCTCOUNTThere are […]

Python Moving Average

Creating a moving average is a fundamental part of data analysis. You can easily create moving averages with Python data manipulation package. Pandas has a great function that will allow you to quickly produce a moving average based on the window you define. This window can be defined by the periods or the rows of […]

Sales Prediction Model in Power PI

Leveraging the Python Scripting option in Power BI is a powerful way to build complex machine learning models with the interactive of a dashboard. For the Python model, the SciKit Learn library to create a Linear Regression model that will have a training and testing set for the model to learn on. Then we will run […]

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

1 2 3 8