Blog
How to split data in Excel: Choosing the right method
Excel offers several solutions to help split various data items which have been placed into one cell. The methods discussed all involve splitting text by a delimiter.
R Project – create line chart
Follow along practical example – In an R script upload a spreadsheet, manipulate the data by pivoting columns, and then producing a line chart with data points.
R Project – create bar chart using gglot2
Follow along practical example – In an R script upload a spreadsheet, manipulate the data by removing column/variable, change variable name, and pivot columns, and then producing a bar chart.
Which colours make sense for expense movements?
This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.
RShiny – add catchment areas to a map using geoJSON
This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.
Boolean Logic: A Guide to AND/OR Conditions
TRUE or FALSE outputs from AND/OR conditions in software code can be confusing. The TRUE FALSE table provides a helpful summary.
Data needs context – Context drives information
Data may be everywhere but if you look at data without considering its context, then it becomes meaningless. Context is an essential companion to data. It is required to convert data into information.
Please explain how an API could help me
Don’t let others bamboozle you with technical phrases such as ‘API’. An API is a means of connecting the data source which is hidden from your view in the background to the software application you interact with and view on your screen.
Which type of search might you perform?
You are creating a digital product. What type of searches might you or your user be looking to perform?
Have you checked your work?
Sense check your work before handing over the data product to the user. This can make for better user adoption and more trust in the contents of the product.
Tracking ships using AIS data
Did you know that you can track the location of vessels? All you need is the AIS data transmitted by the vessel.
How to Read Power BI Tables & Charts
Are you new to using Power BI? Here are a few tips on how to navigate bar charts and tables.