Bringing you into the world of data
In this post we will take a look at changing axis text on graphs between English and French (or in fact any other languages you want). You should use the pbix we created in the previous posts to work from…. Read moreGOC Power BI tips #5 – Dynamically changing axis text between English and French
R has become one of the world’s leading languages for statistical and data analysis. While the base R installation does support simple visualizations, its plots are rarely of high-enough quality for publication. Enter Hadley Wickam’s ggplot2, an aesthetically and logical… Read moreA ggplot2 Primer
In this post we will look at taking a regular date column and turning it into a French Translated date. You should have worked through the previous posts as we will be using the pbix file that was created in GOC… Read moreGOC Power BI tips #4 – Automatic translation from a date column to a French date
So this is a “stepping stone” post that will take us to the next blog in which will create a French Date column that is automatically translated from a regular date column. Even though this is an interim step, having… Read moreGOC Power BI tips #3 – Automatic translation from an English to a French Month
R has become one of the world’s leading languages for statistical and data analysis. In this report, we provide a short description of its core functionality. Data Science Report Series #1: Basics of R for Data Analysis, by Ehssan Ghashim and… Read moreBasics of R for Data Analysis
So following on from our last post where we took a regular date column and converted it into a GOC fiscal year, in this post we are going to automatically create GOC quarters (Qtr 1 = Apr-Jun, Qtr 2 =… Read moreGOC Power BI tips #2 – Automatic creation of Fiscal Month and Period Calculated Columns
In this first COG Power BI Tips series we are going to be looking to convert a regular date column to a GOC fiscal year. Typically this might be done with a lookup table but I am going to show… Read moreGOC Power BI tips #1 – automatically converting a date to GOC fiscal Year
So this is an introductory post outlining a series that will focus on Microsoft Power BI tips and resources for people that work in the Canadian Federal Government. I am going to assume for this series that readers have a… Read morePower BI resources for Canadian Federal Government