Data For Knowledge
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
How to custom sort in Power BI | Choose the sort order in Power BI
Use CHOOSECOLS function in Excel to extract columns from larger table
Power BI Power Query IF statements | Power BI IF THEN ELSE explained for beginners
Power BI DAX IF statements | Power BI IF, THEN, ELSE explained for beginners
Excel - How to fix dates not counting correctly | Text formatted dates causing calculation problems
How to change column name in Power BI | Rename column for all diagrams or only one diagram
How to append queries in Power BI to combine multiple tables | Power BI tutorial
Merge vs Append in Power BI: When to use each and why
How to split a column in Excel | Divide text into multiple columns
How to Count Unique Categories Using COUNTA UNIQUE Function : Excel Tutorial
Excel - Calculate Duration - number of days between two dates
How to Move Columns In Excel Desktop App (Quick Tutorial 2024)
Excel import to Power BI - Watch out for strikethroughs!
Understanding Layers in Data Reports: A Visual Guide | Why Layer Order Matters In Data Visualisation
How to Combine Diagrams in Power BI | Grouping and Layering Tips
Power BI Tutorial: How to Fix Missing Diagrams & Layer Order Issues (Quick Fix Guide)
Power BI Tutorial - Fix Disappearing Text in Power BI Reports - Quick Solution
Power BI: View pbix file from Sharepoint and Onedrive in a browser (new feature Oct23)
Power BI - Hide interactivity on chart
Providing data tutorials using Power BI, Excel & R Programming
How to add blank column to Power BI table | How to delete column header in Power BI table
Linking cells in excel - link within tab, to another tab, to another spreadsheet
Power BI - remove/alter default column header line or total lines on table or matrix
Power BI - in a table hide unwanted tooltips
How to Fix Incorrect Totals in Power BI: Data Type vs Format
Power BI Gantt chart - day month year format on tooltip/hover over - UK dd/mm/yyyy
Simplifying Complex Calculations in Power BI DAX Step-by-Step: Using Variables vs Calculated Columns
Power BI - Text filter visual (Search box) to help search for words appearing in a specified field
Power BI - How to insert a line break into a page title using DAX UNICHAR
R programming - ggplot2 legend- examples of how to add, remove, alter the legend