html, css, javascript websites
Quiz Summer-2022 To do list - using Local Storage Portfolio Tea Station Tour Company
top of page
07479 744442
Power BI
SSIS
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
Covid 19 Dashboard (OWID)
Huffner Textile Dashboard
Northwind dashboard
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
Incremental Load
SSIS Access is denied
Expressions, Parameterized con.
SCD using Lookup and Conditional Split
Append tables
Power BI
SSRS
DAX
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
T-SQL Stored Procedure
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
Disconnected table
Cohort Analysis
COGR by DAX
SSRS
BI Solution
ExcelTopic
Excel - Power Query
Statistics
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
Power Query - Extracting web data
Cohort Analysis
Power Query: Normalizing a table
Power Query : Accessing Records, Rows
Binomial Distribution
Poisson Distribution
Normal DIstribution
Hypothesis testing, z-score