Description
POWER BI COURSE CONTENT
ETL Changes
Package/Query changes to extract the new columns from oracle to ADW(staging)
Modifying the Queries for fact tables(factsurveysent/factsentimentconsolidated)
Moving the columns from staging production
Altering the tables with new columns (All fact tables need to add new columns along sf_sfg_surveysent)
Testing
Modeling changes
Creating a mapping table for Rating(for grouping on tap of Ratings)
Modeling-based on business needs(SSAS cube changes)
Testing
Report creation
Designing a report
a)Attribute based filtering for Average rating,
b)Number of responses to be represented based on Rating(we are grouping as(1,2),(3,4),5)and need to be filtered based on Attribute,
C)Represent average rating based on attributes through a bar chart