dwh interview
5 posters
Page 1 of 1
dwh interview
hello there,i am very new to this forum....i have got an interview offer related to datawarehouse jobs... they asked me to give 10 minutes presentation on how would i establish the operational(i.e service) requirements for the data warehouse? any idea guys ..operational requirements ..please ...Thank you very much
sqlwarehouse- Posts : 6
Join date : 2011-09-13
Re: dwh interview
please share some ideas guys abt the above requirements
sqlwarehouse- Posts : 6
Join date : 2011-09-13
Re: dwh interview
If you're qualified for the job (in other words, you've done the work before) - then you'll know the answer.
LAndrews- Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada
Re: dwh interview
i dont know the answer.. could you please give us some ideas ?
confused between operational and functional ....
confused between operational and functional ....
sqlwarehouse- Posts : 6
Join date : 2011-09-13
Re: dwh interview
There are typically three types of reporting that can be done off of data warehouses (if they are properly designed using the kimball dimensional modeling methodology etc.)
Strategic Reporting
Analytical Reporting
Operational Reporting
Operational Reporting is the simplest in some sense - it refers to the day to day activities of a company and how to keep track of things happening at the very basic / low level.
For example - a customer phones a call centre agent, call centre agent supports the customer telephonically with something for 15 minutes.
This is an operation business evenint that could be stored in a data warehouse - with dimensions like Customer, Agent, Branch, Date and measures in a centralized fact table like TimeofCallInMinutes linking to the various dimensions and twice to the date dimension (role-playing) like call start date and call end date.
Then one can neatly create a report by grouping the measure (timeOfCall) by branch / agent / state date - and ordering by total time spent per customer to see which call centres - or event agents - on average are more effecient - IF it is measured by the time they spend with customers - and maybe another flag / measure which indicates whether the customer was happy or not. - which could also be summed etc.
Strategic Reporting
Analytical Reporting
Operational Reporting
Operational Reporting is the simplest in some sense - it refers to the day to day activities of a company and how to keep track of things happening at the very basic / low level.
For example - a customer phones a call centre agent, call centre agent supports the customer telephonically with something for 15 minutes.
This is an operation business evenint that could be stored in a data warehouse - with dimensions like Customer, Agent, Branch, Date and measures in a centralized fact table like TimeofCallInMinutes linking to the various dimensions and twice to the date dimension (role-playing) like call start date and call end date.
Then one can neatly create a report by grouping the measure (timeOfCall) by branch / agent / state date - and ordering by total time spent per customer to see which call centres - or event agents - on average are more effecient - IF it is measured by the time they spend with customers - and maybe another flag / measure which indicates whether the customer was happy or not. - which could also be summed etc.
ian.coetzer- Posts : 57
Join date : 2010-05-31
Age : 43
Location : South Africa
Re: dwh interview
Hi Ian, thanks for ur reply. Iam sorry, the question is about operational requirements for data warehouse. you may have read as operational reporting.
...any idea about operational requirements????. Thanks for ur help.
...any idea about operational requirements????. Thanks for ur help.
sqlwarehouse- Posts : 6
Join date : 2011-09-13
Re: dwh interview
Not sure what that would refer to.
Perhaps that should be reworded to technical requirements? which technology to use? ETL process - loading into a staging database - then moving data to a conforming database where the data is cleaned up a bit? nulls etc. removed - then loading only changes and new records into the data warehouse using clever techniques such has hashing etc.
also operationally the ETL process should write audit trails every time an SSIS package etc. runs? to log when it started / stopped datetime stamp + # records inserted # records updated etc.
Perhaps that should be reworded to technical requirements? which technology to use? ETL process - loading into a staging database - then moving data to a conforming database where the data is cleaned up a bit? nulls etc. removed - then loading only changes and new records into the data warehouse using clever techniques such has hashing etc.
also operationally the ETL process should write audit trails every time an SSIS package etc. runs? to log when it started / stopped datetime stamp + # records inserted # records updated etc.
ian.coetzer- Posts : 57
Join date : 2010-05-31
Age : 43
Location : South Africa
Re: dwh interview
anyone ....about operational requirements for the dataware house....
how about these.. can i say these following are operational requirements ....
-Requirement Gathering
-Physical Environment Setup
-Data Modeling
-ETL
-OLAP Cube Design
-Front End Development
-Report Development
-Performance Tuning
-Query Optimization
-Quality Assurance
-Rolling out to Production
-Production Maintenance
-Incremental Enhancements
how about these.. can i say these following are operational requirements ....
-Requirement Gathering
-Physical Environment Setup
-Data Modeling
-ETL
-OLAP Cube Design
-Front End Development
-Report Development
-Performance Tuning
-Query Optimization
-Quality Assurance
-Rolling out to Production
-Production Maintenance
-Incremental Enhancements
sqlwarehouse- Posts : 6
Join date : 2011-09-13
Re: dwh interview
Sorry, I don't know what operational requirements are either.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: dwh interview
My guess is they are referring to one of two things:
1. What needs to occur within the operations team (i.e. the people who keep the machines running) (backups, preventive maintenance, database reorgs, etc)
or
2. Establishing service level metrics for the environment (response times, availibility, etc...)
Most likely the latter. Why don't you simply ask them?
1. What needs to occur within the operations team (i.e. the people who keep the machines running) (backups, preventive maintenance, database reorgs, etc)
or
2. Establishing service level metrics for the environment (response times, availibility, etc...)
Most likely the latter. Why don't you simply ask them?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|