Dag 1 Architecture and Data Bekijk inhoud Introduction Power BI Architecture Data warehousing: fact and dimension tables (star schemas) Importing data with Power Query Importing data from CSV and Excel Creating calculated columns Cleaning and transforming data Automatically loading multiple Excel sheets from a folder
Dag 2 Analysing and Visualising Bekijk inhoud Analysing and modelling data Creating a data model: establishing relationships between fact and dimension tables (star schemas) DAX formulas Calculated Columns Creating a date table Summing values and calculating averages using Measures: SUM, AVERAGE, COUNT, and DISTINCTCOUNT Simple logic with IF formula Visualising data Creating tables, matrices, and charts Displaying geographical information in a map or on a floor plan Adding filters: visual, page, or report filters