Welcoem to posts!!
in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
When you tell people you're a data analyst what is their usual response?
0 - 0
Turns out it's not to complicated to create a script in Google App Script to track historical currency rates in a Google Sheet. Trigger in App Script set up to refresh daily so each day a new line is added to the spreadsheet with the latest conversion rate. I'm converting USD to GBP (US to UK).
function saveHistoricalRate() {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
var mainSheet = sheet.getSheetByName("Sheet1");
var historySheet = sheet.getSheetByName("Historical_Rates");
// Get today's date and rate
var date = Utilities.formatDate(new Date(), "GMT", "yyyy-MM-dd");
var rate = mainSheet.getRange("B2").getValue();
// Add new row to historical data
historySheet.appendRow([date, rate]);
}
2 - 0
Just watched the Power BI January 2025 update on @MicrosoftPowerBI . The update is spread across 5 videos, rather than the traditional 1 video release. Not sure what to make of this 🤔. What is strange is that the second video in the playlist order is the end video to the update - would have expected this video to play last.😕
1 - 0
When you create a visualisation from real-world data and realise just how cold it's been outside. Brrr..... 🥶🧊
d3 custom timeseries visualisation mentioned last week now complete ✅
1 - 0
I've been working all week on a custom timeseries visual using d3.js. Have you used d3 before?
0 - 2
Just discovered that @HowtoPowerBI has created a video on the new path layer on the Azure Map visual. Great stuff! Thank you!
0 - 0
The new path layer for the Azure Map visual was announcing in the November 2024 Power BI update. Looking forward to exploring the path layer whilst accepting the visual has limitiations- https://www.youtube.com/watch?v=4MmIZ....
Which recently released Power BI feature are you excited to explore?
0 - 0
Lots of enhancements to Power BI announced at #MSBuild event earlier this week. From Microsoft Fabric, to using Copilot within Power BI for more insights, to changes to the view of DAX measures to allow the code of one measure to be seen inside another, are but a few upcoming additions I am looking forward to exploring more.
Please feel free to share anything you discovered a #MSBuild that you looking forward to exploring.
#powerbi #msbuild
0 - 0
Data, data, data, I love it.
From data analysis using the R programming language to DAX to M code, to displaying the data in charts using Power BI or R Shiny or a simple R script, I would like to show you how easy some data projects are to create if you know where to start.
For this reason I share data and coding projects alongside technical knowledge to help you gain knowledge from your data by:
- creating follow along projects using open data in Power BI and RStudio
- discussing data visualisations
- explaining coding terms mainly related to DAX or R programming
- explaining some technical aspects and provide guidance on best practices with working with data and visualisations
The step by step projects provide you with experience of collating and bringing real-life data into Power BI or RStudio, manipulating the data, and then visualising it in diagrams.
If you have suggestions for future videos, please let me know.
Hope you enjoy the videos!
Pauline