MIS 587 comes to an end

MIS 587 comes to an end.... It was a busy semester starting with GOMC to various tools and softwares and then ending the semester on a high with Social Media project. Over all the entire course was very interesting, engaging and learning. We learnt the various strategies employed in the industry right from collecting data cleaning it, finding the business value hidden in that information. The course has prepared us not only for the current industry but even for the future by making us adept with online marketing and web analytics. Thanks to the various projects we did in the course I can talk a lot more about BI in the interviews than before. It has instilled a sense of confidence in me and has made me competent in facing any position and any profile. The final aim of someone wanting to gain experience in the world of BI is to become a data scientist. We have now the theoretical knowledge that we need to leverage with the industrial experience and prove our mettle. Thank you Professor and my awesome team mates.

Infographic Resume

HW-6 was one of the more fun projects we have dine in MIS 587. We have been asked to make an inforgraphic resume, basically use pie charts, bar graphs and timeline to represent how you have grown professionally over time and make this resume as an application for a job applications. So what I did was use a pie chart to represent my level of expertise and my past work experience. Use a network model to list out all the tools and programming languages I know of. Also make a tree structure to details the work I have done in the past. This was a fun project as it allowed us to use out imagination and still use concepts of BI such as data representation skills, data visualization techniques to showcase ourselves in the best way possible. Having a colorful, dynamic pictorial resume looks very attractive and maybe help us get a job that we could not have gotten otherwise. Link: https://docs.google.com/file/d/0B-Nt4sKnLiuGMUpDLWp1T0tVQ3c/edit?pli=1#

Ad Hoc OBIEE

As I went through the OBIEE tutorial there were various things I wanted to implement which I couldn't figure out from the processes explained in the tutorial so I did some self-research and found something interesting using which I could do Ad Hoc reporting!!!
There is an option of setting up a prompt in the dashboard. How the process work is that you predetermine the column or columns over which you expect the user of the dashboard would want to use his discretion. You can select the possible values of those columns he can choose and then after selecting multiple columns and multiple values in each column you can add this prompt to your dashboard.
The benefit comes when the user wants to select some or all columns to view the data of or plot in the graph. This benefit allows the user to compare a set of value against the other set of value. And use the selected view to extract business information.
The universal benefit of this approach will help a single dashboard answer company wide queries. The same dashboard can be sent to all managers whether in the same department or different, they can choose to see the various products of their department and also compare their department's performance against some other department.
The one stop ad hoc reports are the real benefit the OBIEE provides, ANd I am glad I used them to the best in my homework 5

OBIEE

The recent project was really helpful in understanding how BI works in a current enterprise whether be it healthcare or retail or forecasting based on historic data.
The tool OBIEE is a really helpful OLAP tool where you can create almost any report you want to create. The dimensional model of the data eases the complexity as the facts and dimensional tables really help one understand the details he/she is looking for and pull the necessary details to present the output as desired.
Whats improves the tool is the ease with which a person can plot various graphs and not only plot them but change the various components to get the exact data representation they are looking for. With the wide variety of details provided be it a pie chart, line graph or anything else, along with being able to swap the columns as X or Y axis is also a very convenient way by which one can present his manager easy decision making capability.
The best part is the mobility component of the whole process. You don't necessarily have to be tied down to a system and the connected server to procure the data you desire.
This is the future of BI reporting on the go!! And with the Oracle's latest service which allows users to pull reports from their iPads and other tablets makes the market more futuristic.
There is still more to come like Real time BI. Well we are still chasing our dreams and real time BI is not the end of it, as every distance you cover shows the path that lies ahead.