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
Power BI: сделайте визуальные элементы ОДИНАКОВОГО РАЗМЕРА! Задайте точные высоту и ширину для ид...
Как быстро скопировать формулу в столбец Excel (приём с двойным щелчком)
Фон холста Power BI против обоев: поймите разницу и избегайте ловушки прозрачности
Excel: как удалить ТЫСЯЧИ строк за секунды (перейти к ярлыку)
Навигация в Excel: мгновенный переход к последней строке или столбцу (хватит прокручивать!)
Скрытые символы Power BI: остановите фильтрацию дубликатов и сбои слияния с помощью Power Query T...
Как предотвратить взаимную фильтрацию визуальных элементов в Power BI | Объяснение взаимодействий...
Capitalize first letter of each word in Excel | PROPER Function & Flash Fill
Power BI: Easy ways to Remove or Keep Columns in Power Query
Power BI - Difference between distinct vs unique vs rows | Column distribution explained Power Query
Why your Power BI visuals are not clicking or header icons can't be clicked (and the Fix!)
Power BI - Jump to any column quickly (No more endless scrolling) - Power Query Tip
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
Как разделить столбец в Excel | Разделить текст на несколько столбцов
Как подсчитать уникальные категории с помощью функции COUNTA UNIQUE: Учебное пособие по Excel
Excel - Calculate Duration - number of days between two dates
Как перемещать столбцы в настольном приложении Excel (краткое руководство 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)