BIPower
Hello there! My name is Lica and I teach Business Intelligence at The Hague University of Applied Sciences in The Hague.
I created this channel as an additional material for students to help them with understanding data analytics tools like MS Power BI and MS Excel.
Edge 4 Hacks to Simplify Your Life
5 Formatting updates for Power BI visuals
AI in Excel to analyze data
Power BI Desktop New Features 2023
How to Present Power BI Reports in PowerPoint (even with a Free Account)
How to create and update Excel Slicers
How to publish reports from Power BI Desktop to Power BI Service
Introduction to Excel
Group values with the DAX Function IF
Build Random Datasets with Spilled Array Formulas
Step-to-step guide to MS Excel Pivot Tables and Pivot Charts
Power BI Desktop / Visualising data / Preparing reports for dashboards
Power BI / DAX / Using CALCULATE and Time intelligence functions
Power BI / Evaluation context of DAX
Power BI / Modelling Data / Measures vs Calculated Columns
Power BI / Modelling Data / Create Calculated Columns and use function RELATED
Power BI / Modelling Data / Create a Date Table
Power BI / Modelling Data / Create a Data Model and Relationships / Remove Duplicates
Power BI / Query Editor / Create Custom Columns / Append Queries
Power BI / Query Editor / Connect to the Folder
Power BI / Query Editor / Load data from Excel / Change the source location
Excel CONCATENATE, CONCAT and TEXTJOIN
Excel COUNTIF and COUNTIFS
Excel Logical Functions IF, IFS, SWITCH
Excel SUMIF and SUMIFS
Excel VLOOKUP and XLOOKUP
Excel Tables
Excel Table Formatting
Excel Slicers
Excel Pivot Charts