can any body explain clearly how to explain any (sales)
project in interview.actually feom where report developer
work starts?pls reply as soon as possible.
Answer Posted / bharani
IF I were u wll expalin my proj like this
I working for ....(name of the proj) proj,client is ....
(name of the client), which is saless and distribution
domain, technology in my proj is .......(like Informatica
as ETL TOOL, BI TOOL AS COGNOS, Backend database is ORacle)
describe a bit about ur client business a bit.
( suppose for a mall inventory level, itemsold per week and
pregressive businessd timings like festivals)
as a report author i developed ..... these kind of
reports , which are very useful for enduser to take
business decisions.
Generally DWH group contains
1.database team( like oracle)
2.ETL team
3.BI team
4Testing Team
5.Support Team
team 1: perople generally load the data into database and
architect will prepare ER model for that and constraints
ofthe table.
Team2: once data entered into the dbase, Etl architect
prepares star schema for Dwh and Etl developers extract
data from dbase and made some transformations (depend on
business requirements like scrubbing) and load that data
into Datawarehouse in the form of datamarts.
Team3. Bi architect extract the data from Dwh and prepares
a model (universe)and work wll be assigned to Report author
to populate the data in the form of the reports asd per end
user requirement.
Team 4: testing team generally test the report and if any
bugs found dt will be forwarded to support team.
Team 5. this team people try to resolve those issues if it
is not possible for them again it wll transformed to Etl
team.
completely this is a cyclic process.
As of my knowledge.
Bharani working for IBM
Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
----------------Describe DWH Architecture?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Name the types of gateway?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
write a query to display the departments with no employee?
Define the slice and dice?
what is the difference between filter and condition?
what are slowly changing dimensions? Why we are used scd?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
which type of project we r going to snowflake schema
What are query items?
Can you define cognos powerplay?
What is the function of model design accelerator?
what is power prompt in cognos ep7series?what is the use of this?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice