Business
Intelligence
Hard
Skills
FULL
SKILL
LIST
BY
DISCIPLINE
SQL
Joins
,
CTEs
,
window
functions
,
query
tuning
01
Power
BI
DAX
measures
,
Power
Query
,
row
-
level
security
02
Data
modeling
Star
schema
,
fact
and
dimension
design
03
Tableau
LOD
expressions
,
table
calculations
,
dashboard
actions
04
ETL
/
ELT
pipelines
dbt
,
Airflow
,
Azure
Data
Factory
05
Python
for
data
pandas
,
NumPy
,
notebook
-
based
analysis
06
Cloud
data
warehousing
Snowflake
,
BigQuery
,
Redshift
,
Databricks
07
Advanced
Excel
Power
Pivot
,
Power
Query
,
dynamic
arrays
08
Dashboard
design
Visual
hierarchy
,
chart
selection
,
accessibility
09
Statistics
&
experimentation
Hypothesis
testing
,
A
/
B
test
design
,
significance
10
1 / 5
G R OU P
01
Data
Querying
&
Manipulation
G R O U P
02
Data
Modeling
&
Warehousing
SQL
Multi
-
table
joins
,
subqueries
,
CTEs
,
window
functions
,
aggregate
and
set
operations
Query
performance
tuning
Indexing
strategy
,
execution
plans
,
partition
pruning
,
reducing
full
scans
T
-
SQL
/
PL
-
SQL
Stored
procedures
,
views
,
functions
,
transaction
handling
Python
for
data
pandas
,
NumPy
,
Polars
,
Jupyter
notebooks
,
scripted
transformations
R
dplyr
and
tidyverse
workflows
,
reproducible
statistical
analysis
Advanced
Excel
&
Power
Query
Power
Pivot
,
XLOOKUP
,
dynamic
arrays
,
M
code
,
pivot
modeling
Dimensional
modeling
Kimball
star
and
snowflake
schemas
,
fact
grain
selection
,
conformed
dimensions
Normalization
&
ER
modeling
3
NF
OLTP
design
versus
OLAP
denormalization
trade
-
offs
Slowly
changing
dimensions
Type
1, 2
and
3
history
tracking
,
effective
-
dating
,
current
-
row
flags
Semantic
layer
design
Certified
metric
definitions
,
reusable
measures
,
single
source
of
truth
Data
vault
Hubs
,
links
and
satellites
for
auditable
raw
and
integration
layers
Lakehouse
table
formats
Delta
Lake
,
Apache
Iceberg
,
Hudi
;
schema
evolution
and
time
travel
2 / 5
G R OU P
03
ETL
/
ELT
&
Pipelines
G R O U P
04
BI
Platforms
&
Visualization
Pipeline
orchestration
Airflow
,
Dagster
,
Azure
Data
Factory
,
scheduled
and
event
-
driven
runs
dbt
Models
,
sources
,
tests
,
macros
,
incremental
and
snapshot
materializations
Ingestion
patterns
REST
and
GraphQL
pulls
,
Parquet
and
CSV
loads
,
Kafka
streaming
Data
quality
testing
Freshness
,
uniqueness
,
referential
integrity
,
schema
contracts
,
alerting
Warehouse
CI
/
CD
Git
branching
,
code
review
,
environment
promotion
for
pipeline
code
Change
data
capture
Incremental
syncs
,
watermarking
,
idempotent
reloads
Power
BI
DAX
,
Power
Query
,
row
-
level
security
,
composite
models
,
paginated
reports
Tableau
LOD
expressions
,
table
calculations
,
parameters
,
dashboard
actions
Looker
LookML
modeling
,
Explores
,
persistent
derived
tables
Qlik
Sense
/
QlikView
Associative
engine
,
load
scripting
,
set
analysis
Lightweight
BI
tools
Looker
Studio
,
Metabase
,
Domo
,
Sigma
for
self
-
serve
reporting
Dashboard
design
Chart
selection
,
visual
hierarchy
,
color
accessibility
,
mobile
layout
3 / 5
G R OU P
05
Statistics
&
Advanced
Analytics
G R O U P
06
Cloud
&
Data
Platforms
Descriptive
&
inferential
statistics
Distributions
,
confidence
intervals
,
hypothesis
tests
,
sample
sizing
Experimentation
A
/
B
and
multivariate
test
design
,
power
analysis
,
guardrail
metrics
Regression
&
predictive
modeling
Linear
and
logistic
models
,
feature
engineering
,
model
evaluation
Time
-
series
forecasting
Seasonality
,
trend
decomposition
,
ARIMA
,
Prophet
,
driver
-
based
forecasts
Cohort
,
funnel
&
retention
analysis
Churn
curves
,
LTV
to
CAC
,
RFM
segmentation
,
conversion
drop
-
off
Anomaly
detection
Threshold
logic
,
control
charts
,
outlier
diagnostics
,
root
-
cause
drill
-
down
Snowflake
/
BigQuery
/
Redshift
Warehouse
provisioning
,
clustering
,
partitioning
,
cost
tuning
Databricks
Spark
notebooks
,
Unity
Catalog
,
medallion
architecture
Microsoft
Azure
Synapse
,
Microsoft
Fabric
,
Data
Factory
,
Entra
ID
security
AWS
S
3,
Glue
,
Athena
,
Redshift
Spectrum
,
IAM
policies
Google
Cloud
BigQuery
,
Dataflow
,
Cloud
Composer
Version
control
&
scripting
Git
,
Bash
,
PowerShell
,
environment
and
secrets
management
4 / 5
G R OU P
07
Governance
,
Quality
&
Delivery
Data
governance
Cataloging
,
lineage
,
ownership
,
retention
policy
,
business
glossary
Privacy
&
compliance
GDPR
,
CCPA
,
HIPAA
,
PII
masking
,
row
-
level
and
column
-
level
security
Master
&
reference
data
Deduplication
,
golden
records
,
hierarchy
management
Requirements
gathering
KPI
workshops
,
metric
trees
,
user
story
mapping
,
source
-
system
discovery
Agile
delivery
Scrum
and
Kanban
,
Jira
,
sprint
demos
,
backlog
grooming
with
stakeholders
Data
storytelling
Executive
summaries
,
annotated
charts
,
narrative
-
first
reporting
5 / 5
