POWER BI

$ 13

Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations withself-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.

Description

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

Contact Us