Explore KSACs by Pathway

Explore Knowledge, Skills, Abilities, and Credentials (KSACs) by IT Pathway.

5. Data Warehousing and Business Intelligence

Label KSAC Description Bloom's Taxonomy Level Cross-Cutting
a Explain business intelligence and identify the underlying technologies needed to support it. knowledge 3
b Explain data warehousing and identify the various schemas (Star, Snow Flake, Galaxy, etc.). knowledge 3
c Describe and differentiate operational data store (ODS) vs data warehouse. knowledge 2
d Describe and differentiate data mart vs data lake. knowledge 2
e Demonstrate understanding and ability to apply basic statistics. ability 3
f Understand the use of estimation statistics to determine what can (and cannot) be answered by the available data. knowledge 2
g Demonstrate ability to create appropriate (SQL) queries to support DW and BI activities. ability 4
h Describe data visualization and the role it plays in BI. knowledge 2
i Demonstrate ability to use Excel as a basic data analysis and visualization tool (including pivot tables). skill 3
j Explain decision analysis type framework (empirical data analysis). knowledge 2
k Describe data analytics and differentiate descriptive, prescriptive, predictive and cognitive. knowledge 2
l Describe source to target mapping (in terms extraction, transformation and loading). knowledge 2
m Explain prototyping and its role in BI and DW. knowledge 2

Credentials

Vendor Certifications - DBMS

  1. Oracle Associate
  2. Microsoft
  3. IBM

Vendor Certifications - Cloud

  1. AWS
  2. Oracle
  3. Microsoft

Vendor Certifications - Tools

  1. Tableau
  2. SAS

Others

  1. DAMA CDMP
  2. DataCamp Certificate