If you’re working with weighted quantitative data, statistical software like SPSS (and its open source counterpart PSPP) have easy built-in functionality to handle the weights. But it’s less straightforward if you’re working in other programs, so this quick tutorial shows how to complete basic calculations with weighted survey data in Power BI. For this tutorial, […]
What this is for: Exploring correlations between multiple variables Requirements: Python Anaconda distribution, Google My Business or comparable data with multiple variables you want to test, Basic understanding of Pandas dataframe & statistics Concepts covered: Creating a correlation matrix, basic dataframe calculations, scatter plots, exporting charts as PNG Download the entire Python file I’ve always […]
Parameters are an incredibly powerful tool when constructing queries in Microsoft Excel. And if your source data changes frequently, parameters can come in extremely handy to change multiple file names/paths hurry. For example, I had queries set up to pull data from about 30 spreadsheets from our finance department. Every month, they ran new reports […]