BI & ETL SOLUTIONS – Hospitality industry
BI SOLUTION – OVERVIEW
Business users generally come from a non-technical background and it becomes increasingly difficult when you have to monitors your applications not only from functional but also with a technical perspective. Our client also faced a similar scenario
BUSINESS NEED
The business uses wanted to cross-check whether the viewable data in BI report as well as EP planning is up-to-date. To confirm that one has to check ETL application for Schema data as well as BI Application for Cube data. There was a technical hurdle as the users were not aware of the technologies. One has to have respective tool knowledge in order get status run of these tools.
THE SOLUTION
A special status run record was created which enabled the Business user to know the last run status, Date and time of last run for BI cubes, ETL Jobs as well as some user tables.
THE BENEFITS
The business now can check data consistency which out raising help of technical team for monitoring the system
ETL – BUSINESS NEED
SOB-Share of Business, a KPI which the company enters in EP planning Cube directly, As SOB KPI was manual and not from the ERP system or Operational Data source, whenever there was data refresh in the cube .Other fields would change their respective position while SOB would never change respectively.
For Instance:
Supplier I was ranked as Position_1, Product Rate: 10SOB: 50% (Manual Input)
BI and ETL solutions – Hospitality Industry
Supplier II at Position_2 Product Rate: 12SOB: 30% (Manual Input )
Supplier III at Position_3 Product Rate: 14SOB :20 % (Manual Input )
Let’s say data changes and now Ranking logic gives different ranking
Supplier II was ranked as Position_1, Product Rate: 8SOB: 50% (Manual Input )
Supplier I at Position_2 Product Rate : 13 SOB :30 % (Manual Input )
Supplier III at Position_3 Product Rate :14 SOB :20 % (Manual Input )
Thus the data for SOB would be irrelevant because it didn’t change with respective position of
its supplier.
THE SOLUTION
A Package was created in SSIS where the exported data from Cube is exported to Database and every time entire data would be refreshed including SOB at appropriate position giving relevant and consistent information to the Business user.
Supplier II was ranked as Position_1, Product Rate: 8SOB:30 % (Manual Input )
Supplier I at Position_2 Product Rate:13 SOB:50 % (Manual Input )
Supplier III at Position_3 Product Rate:14 SOB:20 % (Manual Input )
THE BENEFITS
Now Business can do better analysis even though product rate of Supplier II is less still it has been given only 30 % of tenders whereas the supplier two which charging more is given the higher number of tenders or business, thus leading to right decision making.
66 thoughts on “BI & ETL SOLUTIONS – Hospitality industry”
Hi there, i read your blog from time to time and i
own a similar one and i was just wondering if you get a lot
of spam remarks? If so how do you prevent it, any plugin or anything you can advise?
I get so much lately it’s driving me insane so any support is very much appreciated.
Piece of writing writing is also a excitement, if you be acquainted with then you can write or else it
is complicated to write.
Here is my web blog free download game 3win8
I all the time emailed this weblog post page to all my friends, since if like to read it afterward my friends will too.
Also visit my web site … sky1388 game list
Thank you for another wonderful post. Where else could anybody get that type of information in such an ideal method of writing?
I’ve a presentation subsequent week, and I’m at the look for
such info.
Also visit my blog: wukong333 pc download, 918kiss-m.com,
Hello, everything is going fine here and ofcourse every one is sharing data, that’s
genuinely fine, keep up writing.
Feel free to surf to my web site … demo sky777 (Jeanna)
I was curious if you ever thought of changing the page layout of your blog?
Its very well written; I love what youve got to say.
But maybe you could a little more in the way of content so people could connect with it better.
Youve got an awful lot of text for only
having 1 or two pictures. Maybe you could space it out better?
Here is my page; joker123 slot game (918kiss-m.com)
I know this web page offers quality depending content and extra data, is there any other web site which gives these
kinds of things in quality?
Also visit my web site; 918kaya android
I’m not that much of a internet reader to be honest but your sites really nice, keep it up!
I’ll go ahead and bookmark your site to come back later on. Cheers
My web blog; kis918 download
It’s wonderful that you are getting thoughts from this post as well as from our argument made at
this time.
Feel free to surf to my web site; id test pussy888 [Reinaldo]
Very shortly this web page will be famous
among all blog people, due to it’s pleasant articles
my web-site :: www love138apk
Great information. Lucky me I ran across your site by accident (stumbleupon).
I have saved it for later!
Here is my blog – rantsforchange.ca
I think this is one of the most important info for me.
And i’m glad reading your article. But should remark on some general things, The site style is wonderful,
the articles is really nice : D. Good job, cheers
Very good post! We are linking to this particularly great
content on our website. Keep up the good writing.
Hmm is anyone else experiencing problems with the images on this
blog loading? I’m trying to determine if its a problem on my end or if it’s
the blog. Any feed-back would be greatly appreciated.
Hello There. I found your blog using msn. This is an extremely well written article.
I’ll make sure to bookmark it and come back to
read more of your useful information. Thanks for the post.
I will certainly comeback.
my blog: calibet slot game
Appreciation to my father who stated to me concerning this
webpage, this website is really awesome.
My web site playboy2 kiosk download
If you desire to increase your knowledge simply keep visiting this website and
be updated with the hottest information posted here.
Look at my homepage 918kiss plus free download
What i do not realize is in fact how you are now
not really a lot more smartly-liked than you might be right
now. You are so intelligent. You already know thus considerably in the case of
this matter, made me personally consider it from numerous numerous angles.
Its like women and men don’t seem to be involved unless it’s one thing to accomplish with
Woman gaga! Your own stuffs excellent. All the time handle it up!
Check out my web site :: live22 slot Online
I’m gone to convey my little brother, that he should also visit this
webpage on regular basis to get updated from
hottest gossip.
My web-site … epicwin malaysia
When someone writes an post he/she keeps the thought of a user
in his/her mind that how a user can be aware of it. Thus that’s why this paragraph is amazing.
Thanks!
Also visit my blog greatwall99 pc download
Wonderful blog! Do you have any recommendations for aspiring writers?
I’m planning to start my own blog soon but
I’m a little lost on everything. Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m completely confused ..
Any suggestions? Thanks a lot!
My blog post: kiosk greatwall99
Hello, i believe that i noticed you visited my weblog so i got here
to return the choose?.I’m attempting to find things to improve my site!I assume its ok to make use of a few of your concepts!!
Feel free to visit my page; club suncity jackpot; 918kiss-m.com,
Hello. magnificent job. I did not imagine this. This is a
excellent story. Thanks!
Here is my webpage khoquet.com
Hey There. I found your weblog the use of msn. This is a very neatly
written article. I’ll make sure to bookmark it and come back
to read extra of your useful info. Thank you
for the post. I will certainly comeback.
My web-site :: wm casino original
I in addition to my buddies came checking the good recommendations located on your site and then quickly I got a horrible suspicion I
had not thanked the blog owner for those techniques.
The ladies appeared to be absolutely glad to read all of them and already have really been making the most of them.
Appreciate your really being very thoughtful and for deciding on varieties of outstanding information millions of individuals are really desirous to learn about.
Our own sincere apologies for not saying thanks to you sooner.
Look at my blog post http://www.diablo.moe
Hello colleagues, fastidious article and pleasant arguments commented here,
I am truly enjoying by these.
Also visit my blog ok388 kiosk download
Regards for this wondrous post, I am glad I noticed this internet site on yahoo.
my page: Shantae
Having read this I thought it was really informative.
I appreciate you spending some time and effort to put this content together.
I once again find myself spending way too
much time both reading and posting comments.
But so what, it was still worth it!
Here is my blog post; discuz.e70w.com
I simply desired to thank you so much all over again. I do not know the things
that I would’ve taken care of in the absence of the
entire pointers revealed by you about that area of interest.
It had been a frightening concern in my view, however
, seeing a specialised approach you processed that took me to weep with fulfillment.
I’m thankful for this help and even sincerely hope you find
out what an amazing job that you are doing training the others with the aid of your web page.
I am certain you have never come across all of us.
My site :: 19wujian.com
Useful information. Lucky me I discovered your website accidentally, and I’m shocked
why this accident didn’t happened in advance! I bookmarked it.
Also visit my website; Tamela
I think this is among the most important information for me.
And i am glad reading your article. But should remark on few general things, The website
style is ideal, the articles is really nice : D. Good job, cheers
my blog post … alisteqama.net
You could certainly see your expertise within the
work you write. The world hopes for more passionate writers such as you who are not afraid to
mention how they believe. Always go after your heart.
I read this post completely about the resemblance of latest
and previous technologies, it’s remarkable article.
Pretty great post. I simply stumbled upon your weblog and wished
to say that I’ve really loved surfing around your blog posts.
In any case I will be subscribing to your feed and I’m
hoping you write once more soon!
my blog post – 39.104.22.11
I haven’t checked in here for a while since I thought it was getting boring, but the
last few posts are good quality so I guess I’ll add you back to
my daily bloglist. You deserve it my friend 🙂
Look at my website – qiurom.com
I believe this is among the such a lot vital information for me.
And i’m happy studying your article. But want to statement on some basic issues, The
web site taste is great, the articles is actually excellent :
D. Good process, cheers.
my blog post – 2xueche.com
I truly appreciate this post. I have been looking everywhere for this!
Thank goodness I found it on Bing. You have made my day!
Thank you again!
Feel free to visit my web-site – http://www.ptfang.com
I wanted to write a simple note to be able to thank you for the magnificent techniques you are sharing on this site.
My long internet look up has finally been rewarded with useful suggestions to write about with my co-workers.
I ‘d declare that many of us visitors are really
blessed to be in a great website with many awesome individuals with very beneficial methods.
I feel really grateful to have come across your entire weblog and look
forward to so many more entertaining moments reading here.
Thank you once again for a lot of things.
My blog post: kebe.top
Thank you for your website post. Jones and I are already
saving for just a new e-book on this subject and your article has made all of us to save money.
Your thinking really responded all our questions.
In fact, more than what we had thought of ahead of the time we found your superb blog.
My spouse and i no longer have doubts and also a troubled mind because you have truly attended to the needs here.
Thanks
My blog post … 154.8.233.237
This design is incredible! You definitely know how to
keep a reader amused. Between your wit and your videos,
I was almost moved to start my own blog (well, almost…HaHa!) Great
job. I really enjoyed what you had to say, and more than that,
how you presented it. Too cool!
Feel free to surf to my site … 39.104.22.11
Pretty great post. I simply stumbled upon your blog and wanted to say that I have truly loved browsing your weblog posts.
In any case I’ll be subscribing to your rss feed and I am hoping you write once more very
soon!
Here is my blog :: tsc-saarlorlux.de
With havin so much content do you ever run into any problems of plagorism or copyright infringement?
My website has a lot of completely unique content I’ve either authored myself or outsourced but
it looks like a lot of it is popping it up all over the web without my authorization. Do you know any ways to help reduce content from being
stolen? I’d truly appreciate it.
Thanks for every other magnificent post. Where else could anybody get that
kind of info in such an ideal method of writing?
I’ve a presentation subsequent week, and I am at the look for such info.
Greetings, I think your website could be having browser
compatibility problems. When I look at your website in Safari,
it looks fine however when opening in IE, it has some overlapping
issues. I simply wanted to give you a quick heads up!
Other than that, wonderful website!
Here is my homepage … khoquet.com
Today, while I was at work, my sister stole my
apple ipad and tested to see if it can survive a 25 foot
drop, just so she can be a youtube sensation. My apple ipad is now destroyed
and she has 83 views. I know this is totally
off topic but I had to share it with someone!
Feel free to surf to my site discuz.e70w.com
Lovely just what I was looking for. Thanks to the author for taking his time
on this one.
Here is my blog post :: 2xueche.com
I think this is among the so much vital info for me. And i’m glad reading
your article. But should commentary on some normal things, The website style is ideal, the articles is
truly nice :D. Excellent activity, cheers.
my web site … Margene
F*ckin’ tremendous issues here. I am very glad to peer your post.
Thank you so much and i am having a look forward to touch you.
Will you please drop me a mail?
Feel free to visit my web site atomy123.cn
Great site you have here but I was wondering if you knew of any message boards
that cover the same topics talked about in this article?
I’d really love to be a part of community where I can get responses from other
knowledgeable individuals that share the same interest.
If you have any recommendations, please let me know.
Bless you!
Feel free to surf to my web page – http://www.qiurom.com
Thank you for some other fantastic article. The place else
could anyone get that type of information in such an ideal manner of writing?
I have a presentation next week, and I’m at the look for such info.
Feel free to surf to my page … kebe.top
If you want to get much from this piece of writing
then you have to apply such strategies to your won weblog.
my page: tanglewood.sh
Have you ever considered creating an e-book or guest authoring on other sites?
I have a blog based upon on the same subjects you discuss and would really like to have you share some stories/information.
I know my visitors would appreciate your work. If you’re even remotely interested, feel free to shoot me an email.
My blog … discuz.e70w.com
Right here is the right webpage for everyone who really
wants to find out about this topic. You realize a whole lot its almost
hard to argue with you (not that I really would want to?HaHa).
You definitely put a fresh spin on a subject that has
been written about for a long time. Excellent stuff, just excellent!
Here is my blog :: 19wujian.com
Oh my goodness! Amazing article dude! Thanks, However I am
going through problems with your RSS. I don?t understand the reason why I am unable to subscribe to it.
Is there anybody having similar RSS issues? Anybody who knows the answer can you kindly respond?
Thanks!!
My web page – http://www.ptfang.com
Персонал дружелюбный и услужливый, в целом, это приятное место для посещения.
Actually when someone doesn’t be aware of afterward
its up to other visitors that they will assist, so here it takes place.
Also visit my blog post :: kebe.top
I used to be able to find good info from your blog articles.
my web blog; tsc-saarlorlux.de
Excellent post. I was checking continuously this blog and
I am impressed! Extremely useful information particularly the last part 🙂
I care for such information much. I was looking for
this particular information for a very long time. Thank you and best of luck.
my web-site … lovegamematch.com
My family every time say that I am killing my
time here at web, except I know I am getting familiarity daily by reading thes pleasant articles or reviews.
Here is my webpage :: bbs.shishiedu.com
Howdy very nice blog!! Guy .. Beautiful .. Amazing .. I will
bookmark your web site and take the feeds also? I’m satisfied to seek out numerous useful info
here within the post, we’d like develop extra techniques in this regard, thank you for sharing.
. . . . .
Also visit my web blog … http://www.atomy123.com
Its like you read my mind! You seem to know so much about this, like you wrote the book in it or something.
I think that you could do with a few pics to drive
the message home a bit, but other than that, this is wonderful
blog. An excellent read. I will definitely be back.
Also visit my site: kebe.top
If some one needs to be updated with most up-to-date technologies then he must be pay a visit this website and
be up to date daily.
I simply could not leave your website prior to suggesting that I extremely enjoyed the standard info a person supply to your guests?
Is going to be again continuously in order to inspect new posts
Also visit my blog post … myweddinglight.us
Exactly what I was looking for, appreciate it for posting.
Check out my blog post: Mora
I will right away seize your rss feed as I can’t find your email subscription hyperlink or newsletter service.
Do you’ve any? Kindly let me realize so that I could subscribe.
Thanks.
But wanna remark that you have a very decent web site, I love the design and style it
really stands out.
my homepage; Blast Portable AC Review