07479 744442
Power BI
SSIS
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
Northwind Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
File System Task
Sequence Container
Execute SQL Task
For Loop Container
Foreach Loop Container
Project Deployment Model
Slowly Changing Dimensions
Lookup Transformation
Derived Column
Union All vs Merge Transformation
Merge Join
SSRS
DAX functions
Index
Data Source , Data Set in SSRS
Tabular Report with Wizard
Grouped Report with Subtotals
Grouped Report with Drilldown
List: Group on Page
List: writing a letter
Headers on Each Page
Table rows on a single page
Running Total
Parameter: Get values from query
Parameter : Boolean
Parameter: Cascade
Drill Through Report
Create a Bookmark
Stored Proc with IN operator
Create a Sub Report
IIF
Grouping and summarizing
SELECTCOLUMNS, ROW
Joins with DAX
Unrelated tables, TREATAS
Filter Functions, part one
Filter Functions, part two
Information functions, part one
Information functions, part two
Creating a Date dimension table
Time intelligence functions, part 01
Time intelligence functions, part 02
Time intelligence functions, part 03
Time intelligence functions, part 04
Customers Analysis
Mixed Scenarios
Excel topics
How to Import Data from a Website to Excel
Append tables using M code
Append with different culture formats
Append tables using a function
Rolling average / total using power query
Custom function: NetWorkingDays
LAG and LEAD using power query
Statistics
Binomial Distribution
Poisson Distribution
Normal DIstribution
Hypothesis testing, z-score
Hypothesis testing, T-Distribution
Hypothesis testing, F-Ratio
One-way ANOVA. Post hoc test.
Two-Way ANOVA
Simple linear regression
Multiple linear regression
Seasonal Indices