Hi Laotulaoshi and experienced BI classmates,
I have started work for 4 weeks. I like my coworkers and I like my work. I have been familiarizing my company's database for the past 4 weeks. Now, they want me to build OTAP for them. I need to come up with a timeline next week. The problem is that their OLTP data are really dirty, there are a lot of bad data (e.g., duplicate records, lots of typos, missing values, some attributes have inconsistent reference integrity) and I am not sure how much time is needed to clean the OTLP. Also, I am not sure how long it will take to obtain all the business requirements for different users. Whether data cleaning and meeting with business users should be conducted parallelly or sequentially? The company also have a lot of server problems, there has been a lot of disruptions in accessing to programs and files at work, which makes it more difficult to predict how long it will take to complete the first cube.
I would appreciate if any of you can share your experience.
Thanks in advance,
Jing