-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
-
Munir Mandviwalla posted an update in the group MIS4596 Mandviwalla Fall 2014 9 years, 8 months ago
The showcase on 12/8 will start promptly at 4pm in Alter 232. See the schedule at: http://wp.me/P4YjHS-8. Your team should load all its materials in advance on the podium (you can do this during your presentation if you prefer but that will count toward your time).
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
-
Munir Mandviwalla posted an update in the group MIS4596 Mandviwalla Fall 2014 9 years, 8 months ago
If you are going for the 50 professional points option on the team project, then you will need to have it completed by 12/8 if you are trying to graduate or need the points to avoid getting an incomplete. See: http://wp.me/P4YjHS-z
-
Munir Mandviwalla wrote a new post on the site Temple MIS 9 years, 8 months ago
When is it a good idea for state governments to spend more tax dollars? When that money goes to information technologies, it turns out.
Min-Seok Pang, Ph.D., Assistant Professor of Information Systems, Fox School of Business, is a self-proclaimed “news and political junkie.” That interest lead to a question: what is the value of IT in the public sector? While there has been extensive research on the fiscal value of information technologies in the business sector for the last couple of decades, little has been done about evaluating the way in which government spending on IT affects or improves services or efficiencies.
In the business world, the research has demonstrated that more investment in IT leads to improvement in firm performance in terms of productivity, profitability, or market value. But, in the public sector there was only anecdotal evidence illustrating that the correct use and implementation of information systems in public organizations could save taxpayers’ money, for instance, by digitizing business processes, which can save time, or improving transparency of an administration.
Pang and co-authors Dr. M.S. Krishnan, University of Michigan, and Dr. Ali Tafti, University of Illinois, Chicago, first compared all 50 states to see which was most efficient, measuring efficiency by looking at how much money various states spend to produce the same level of government services. They then looked at the level of IT spending to calculate the cost savings. Finally, they compared spending data, from 2001-2004, from 44 U.S. state governments.If one state spends more money to produce the same amount of government services than other states, that state is less efficient than others. I found that the more tax revenues a state government spends in information technologies, the more efficient it is.
How efficient? An additional $1 investment in IT made by a state’s chief information officer (CIO) leads to a savings of $1.13 in the state’s administrative costs, in terms of operational expenses and capital deprecation. Somewhat surprisingly, the savings was highest in rural areas. “Cost savings from $1 IT investments are larger when a state is more rural. But it does make sense – if a state is more rural, it has to maintain more state government offices and operations in remote locations (a DMV office for example). Providing government services via the Internet can save costs for both rural residents and state governments.” Pang said.
Pang’s research is one of the first rigorous scientific studies with a large-scale dataset that measure returns on IT investments in governments. With declining tax revenues and mounting budget deficits, some public-sector organizations have scaled back their investments in IT in recent years. Pang’s study shows that it is not a wise move. He believes that government IT officials can use the study to convince taxpayers and their representatives that IT investments generate sufficient returns to the public to justify needed, strategic, spending on IT.
Pang, M.-S., Tafti, A., and Krishnan, M.S. (2014) “Information Technology and Administrative Efficiency in U.S. State Governments – A Stochastic Frontier Approach,” MIS Quarterly (38:4) pp. 1079-1101.
Learn more about Min-Seok at: http://community.mis.temple.edu/minspang/ -
Munir Mandviwalla posted an update in the group MIS4596 Mandviwalla Fall 2014 9 years, 8 months ago
For the ‘dress rehearsal’ next week on 11/18, please be ready to present your complete project – use the team project deliverables as guideline, see: http://community.mis.temple.edu/mis4596sec001fall2014/team-project/. This is a face to face class. We will meet in our regular classroom.
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Leave your response as a comment on this post by the beginning of class next week (Nov 18th). Remember, it only needs to be a few sentences. For these weekly questions, I’m mainly interested in your opinions, not […]
-
The most important takeaway from the speakers was to allow the graphic to stand on its own and tell a story. The message you want to deliver should be immediately and clearly understood by the picture. Those that need to be explained have not done the job. Also, different types of graphics do better than others to tell specific stories – how do things compare versus what are the trends, etcetera. It is not just about drawing a picture to show the data, but to make it clearly show an actionable solution. My concern now is that I need to learn Tableau much better than I currently know it!
-
I think that the most important takeaway from the guest speakers’ presentation was that a good data visualization should be easy to understand for the general audience (with no special background, like statistics or economics), the color scheme should be consistent in all of the graphs used to make it easier for the audience to compare different sets of data, and most importantly the data visualization should be able to communicate a clear message and answer a particular question being addressed.
-
The guest speakers helped a lot in understanding how the visualizations are actually used in making business decisions. It was good to know the practical usage of what we learn in class. It was interesting to see different types of visualizations for a question and learn from the speakers which visualization is more effective for the question at hand. Even though it might seem obvious, it was good to see examples where a combination of visualizations are used to communicate a message.
-
I thought that the presentation was great! It was awesome to know just how many different applications visualization has. I think one of the most important take-aways were the ground rules for good visualizations (keeping the audience in mind, using the right type of graphic, use actionable data, etc.) It surprised me that certain data and information can be seen so much more clearly when viewed in the correct way, and that the best graphics are the ones that elicit even more questions about a data set.
-
The biggest takeaway from the presentation was the need to tailor presentations and graphs to your audience. Graphics should be made to highlight information your audience is most concerned with. To make that information standout is necessary to keep their attention and help them see data in a way that answers their questions quickly. The goal should be to make a graph reveal critical information which your audience can understand in about five seconds.
-
At the outset the presentation was great. high quality talk and visuals. I particularly liked the focus on the design of the visualization rather than just focus on the tools.
-
I also thought the presentation was very enlightening. As some of our other classmates have touched on, I felt that one of the most important takeaways was the idea of an infographic telling a clear narrative, that is easy to understand without need for explanation. If you have to explain the infographic, then chances are that there will be several people who do not understand, or do not understand in the time that the slide or graphic should take to cover.
-
Last week the Wall Street Journal published an article how the next big thing is a Masters in Data Analytics. The presentation definitely proved this through the discussions of how it could be used in different areas within an organization. Visualization and uses of big data help not only analyze the information from the past but also possibly predict or have somewhat of an idea of what the future holds as well.
-
The most important takeaway from the speakers’ presentation was that data analytics and visualizations should try to simplify information, not complicate it. Often times when we are trying to prove how much work we have done or when we are unable to discern the most important information, we often end up with a far more complex story than our clients want. Presenting a simple visualization that proves you have synthesized all the relevant information into an easily accessible format is often what is most desired by the client.
-
I completely agree with a lot of the above comments. The most important takeaway for me was the importance of simple visualizations. Data can be complex and complicated. Figuring out the right method for the story you are trying to tell is critical. The visualization should not add to the level of complication, but rather simplify it so that the most important key takeaway can be absorbed by the audience. Overall though I really enjoyed listening to both Rich and Todd talk about data visualization and how it is so applicable across industries today to be able to deliver insight, action, and impact.
-
I think that the most important takeaway from last weeks presentation was clearly the importance of being sure to allow the data to tell a story. While the presenter makes clear that it is important to use your data to back up your claims, it is even more important to create a coherent narrative that helps put your claims and the data in context. It is a two fold takeaway that reinforces itself. While it is clearly important to ensure that you are able to create a narrative that helps support the correct pathway and solve the problem for the client you are working with, it is also important to ensure that your conclusions are derived from the information that you are showing.
-
1. I believe the most important takeaway from the guest lecture presentation is how the same data can be presented in different ways to draw different inferences. Sometimes, we stick with one style of representing the data, without realizing other styles might be able to deliver the message more meaningfully.
-
I thought the presentations were extremely insightful and could be directly applied to the field in which we are interested in. I thought the biggest takeaway from my end was the ability for them to translate data in an easy to understand manner. They told us about the data set that they were using and the ways they could graphically depict the information to present it in a clear manner. They showed us multiple graphs and charts and explained each one thoroughly and showed the key differences each graph was highlighting. I kind of wish the presenters could have stayed longer and taken a little extra time on each graph and broken down one of the graphs to show exactly how the graph was thought up and then created. Overall, I thought the guest speakers and presentation was a great way to show an applicable use of infographics and data visualization.
-
‘If you’ve never seen what a Chief Data Scientist looks like.. Well now you do.’
–> The guest speakers provided me with a standard to strive for. The two Deloitte representatives were smart, interesting, captivating, and down to earth. I cared about their presentation and the content they provided, but I was more focused on what words they used, how they played with the data, why they used analytics. My goal was to be able to take away details that I could somehow use to advance myself in the analytic industry. -
1) I learnt how to present complex data into simple forms of graphs and charts. No matter how huge is the data, the skill lies in presenting it! Few of the example graphs and charts shown by Todd were tremendously interesting.
-
The most important takeaway that I had from the presentation last week which I think is counterintuitive in other exercises is to know what answer you are looking for before you decide which data you need. Often I see more benefit in the exploration of data but when it comes to visualization this seems more appropriate.
-
I think, more than anything, I just enjoyed the speakers excitement about data. I could tell that the two gentleman really enjoy what they do and it’s given me a slightly different perspective about a topic that can, at times, seem dry.
-
Last week’s speakers were incredibly engaging. The visuals were especially powerful and their personalities brought the concepts to life in a very engaging manner. Overall, the most critical takeaway for me was that companies should avoid waiting for the perfect candidate (i.e. the MIT post-doc). At this stage, even moving the needle from 50% on point to 60% in your analysis will crush competition that have not yet begun to incorporate data visualization and analysis into their offering. My own company is incredibly guilty of this practice, so I was able to immediately leverage some of their lessons in my own day-to-day to continue advancing the need for better data management internally.
-
My take away from our speakers were that if you have a good infographic it will convey important information that management will be able to use to make important decision about their business. All the data that you need will be available in one medium readily available.
-
The digital information good that I could think of from my experience is a beacon (that’s what the company calls, not sure if its widely popular).
So the basic job of this good is to send text messages to people as soon as they enter certain area or a property. They might be greeting messages or coupons or any texts that the company wants to tell its customers. -
My take away from last week’s speakers’ presentation was that how different infographic can infer different information. So, it is very important to choose the right infographic to present the information
-
Q1: I am not really surprised by any of the comments of the speakers. Instead my understanding about visualization and the importance of story telling was further strengthened. I realized the importance of various tools and the need to be able to see the holistic picture as well as the granular information.
-
1.The most important take-away from the speaker’s presentation during last class was: as important as what you are saying is how you are saying it. Good insights will only become obvious if appropriate visualizations are employed. The keyword in that sentence is “appropriate”, given that different visualization tools will yield different insights, and it is extremely important to make sure tools are selected with that in mind.
-
The most important take away for me was that you might have a sexy visual to show off but unless it tells a story your audience can understand then it’s useless. I run a small music production company and therefore the information good is the “album” or final product of the artistic ideas and inspiration. The most expensive part: times and creativity. One, is invaluable and the other you can’t buy.
-
The most important takeaway in my opinion was that the power of visualizations really lies in how your audience takes and interprets them. Careful consideration should be made not only in how the audience will be able to understand the visualization but also what implications it will have. This includes whatever biases the viewer brings to the table. Having multiple versions of the visualization configured in different layouts is a good exercise in case they can visually digest it in only certain forms.
-
At the company I interned with this past summer, I helped create several use cases for their previous projects. These documents are similar to case studies which we read at school. This might not be sold as an information good but is a good which is circulated across platforms to add value to the work done by the company, which is what an information good does.
-
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Speakers : Rich Cohen and Todd Shock, Deloitte Consulting
Topic : Data Visualization – tools and trends
Time : 6-7 pm
The talk will be for 1 hour, with 30-40 minutes for the talk and the rest for Q&A. The Q&A can be on any topic related to data analytics, including trends, career options, and Deloitte’s plans for analytics.
Here are the bios of the speakers:
Richard I. Cohen
Managing Director , Philadelphia
Lead Technology Principle – Philips
Serves FDA/NIH/AZRich is a Senior Principal in Deloitte Technology Practice. He is responsible globally for the strategy, development and implementation of Information Based technologies, specifically, Data Warehousing, Decision Support, Enterprise Data Management, Data Quality, Master Data Management, Portal and Data Mining engagements to support the emergence of world class Analytic Applications. He has over 30 years of experience in the design, development, implementation, and support of information technology in a variety of industries with a heavy concentration in Life Sciences.
Todd Shock
Senior Manager, Deloitte TaxTodd Shock is a Senior Manager in Deloitte’s Tax practice developing technology, visualization and analytics solutions with the Partnership Solutions Group. Todd has over 20 years of experience in software development, data center management and operations, ASP/SaaS strategy and operation, and high performance computing. He is a graduate and former research faculty of the University of Maryland where he developed massively parallel distributed systems for the analysis of satellite data. He has served clients developing analytics solutions and strategies with Deloitte Analytics and formerly served as the Chief Data Scientist for Deloitte’s Center for Innovation and HIVE.
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
-
Munir Mandviwalla posted an update in the group MIS4596 Mandviwalla Fall 2014 9 years, 8 months ago
The financial analysis template for the team project is now available at: http://wp.me/P4YjHS-l. The spreadsheet has two worksheets. The main sheet provides a framework of the costs and revenue you should consider, and the second sheet provides a framework for thinking about one of the most common costs.
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Book Chapter : A Manager’s Guide to Data Warehousing. John Wiley & Sons Chapter 10 (Implementation: Building the Database)
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Please note the following change to the instructions for the final project.
There is no individual component now. All the deliverables under the individual component should be performed and submitted as a group (one per group). In other words, a group will create a two-page written brief to answer the following questions.
Provide the context for the issue. Describe key business issue that must be addressed.
What are the possible solutions? Explore two or three alternatives.
What do you think is the best solution given those alternatives? Explain why.The group deliverable is now due on Nov 11
Hope that clarifies.
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
interesting video on why gilt groupe uses nosql (click here) – the relevant portions are from minute 4 to minute 13.
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Netflix knew that the show House of Cards would be a hit even before a single scene was shot – click here. What do you think? Also list and explain other ways in which Netflix uses data analytics.
-
The Venn diagram strategy seems to big at Netflix, as it has used the same scheme while deciding the price for Favela Rising as it chose the common customers for both City of God and Born into Brothels which was estimated to be 250000 and made the decision on price. Cinematch was the biggest data analytic application for Netflix. The way it used data from its employees to see how they react if the DVD doesn’t reach on time was interesting.
-
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Interesting article on how data analytics is changing the music industry (click here). Can you come up with examples of how other industries are changing with data analytics.
-
This might align with today’s class.
-
Very creative use of big data. This makes you think of other possibilities and using different data sources and merging them together to make a very meaningful dataset. I think a lot of other industries change along with data analytics, healthcare being a common one. Another one is the finance industry. They use data analytics in different ways to reevaluate positions in the markets, whether in mutual funds or ETFs, hedge funds, or options.
-
We have seen how sports and entertainment are changing (Chip Kelly article and Netflix discussion and the above link). All industries are changing with the new era. Most easily seen is the sales and marketing departments who now have better information on to whom to market new and existing product lines – and who is buying or making purchasing decisions. Companies are shifting from guesswork when it comes to strategic competitive maneuvers. Data will show precisely how a competitor is aligning in the market. Accounting is even influenced as better data will allow internal accounting departments to gain a better understanding of industry benchmarks (other companies will not give their information up easily). According to Forbes, data analytics is changing the competitive landscape and has become the top priority in aviation, wind, and manufacturing industries.
-
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Leave your response as a comment on this post by the beginning of class (Nov 4). Remember, it only needs to be a few sentences. For these weekly questions, I’m mainly interested in your opinions, not so much […]
-
What was the total cost in the years 2009 and 2010?
In 2009, the sum of cost is 10338384.53 and in 2010 it is 23696862.69. -
What is the most likely time of day for someone to arrive at the emergency room complaining about chest pain?
4:00pm -
Total number of people admitted at the hospital for allergic reaction–187 (female-151 and male-36)
-
Question: During what month do these least number of patients visit the ER? What is the most common visit reason during this month?
Answer: November- difficultly breathing -
What is the most common visit reason for patients aged 70 and over?
Answer: Difficulty breathing -
Question: Which month had the least amount of patients arriving to the ER by walking? Which month had the highest amount of patients arriving by walking to the ER? How many patients for each month?
Answer: September, 1 patient arrived by walking to the ER; May, 96 patients arrived by walking to the ER. -
How many patients visited Emergency Room? Ans: 17580
How many of them were male and how many female? Male : 6867 , Female: 10713
How many of them had Headache? Male : 217 , Female : 521 -
Q: What reason has the average longest duration of stay for women? How much?
A: Chest Pain, 0.51 days -
What is the ratio of 30 year old men to that of women ? Answer: 79:54 (158 men and 108 women who are 30 years old)
-
Which visit reason has the highest number of high urgency visits?
Chest pain -
Q: What are the top three most common reasons for visiting the ER?
A: Chest Pain (2,285), Difficulty Breathing (1,508), and Pain, Abd General (1,352) -
What was the average hospital duration of males and females at the age of 53?
Males = 17 minutes
Females = 22 minutes -
Q: What is the average stay duration for people aged 29 years old?
Answer: 29 year old stay on average 16.08 minutes, where male patients spend on average 14.4 minutes and female patients spend 17.01 minutes.
-
Q.How many visits are made by people 20 and younger. What is the most common reason.
A. 651 in total. Flu Symptoms is highest at 85. -
Question: What is the average age of the males and females who go to the ER?
Answer: Female: 52.72 years old Male: 52.21 years old. -
1) Dart mart example: information regarding no. of employees completed a particular certification.
Parameters: Department, Job titles, and number of attempts -
Data mart example: Information on media insertions placed through the agency
Facts: Estimate ID, Property/Station ID, Weeks Active
Measures: Quantity Ordered, Spend
Dimensions: Client, Media Type (Product), Time
-
Data mart example: Information on student’s contact information and interests
Facts: Address, Phone #, Email, Social media use
Measures: How many students are interested in what topics and where they are located
Dimensions: Group students together by region and interests -
For the Data Mart Exercise, the project that I was working on for my internship was looking to set up several data marts for the governmental organization we were consulting for. In terms of facts we were looking at dollar amounts for contracts that were awarded, how much had been set aside for research topics, researcher names, contact information and research subject. Measures were variables such as awards or research citations for research that had award money tied to it, or how much money had been spent. Finally the dimensions were primarily measured in financial terms.
-
Q: What is the most expensive month on average to go to the emergency room?
A: August 2010 = $1,978.49
-
What is the total number of males admitted for allergic reaction?
-
How many teens went to the ER with the highest urgency in 2010?
2
-
What was the average ER length of stay for 65 year old + male or female? Male, .576 days
-
While working at Merck this past summer, I dealt extensively with several Merck data marts, including a data mart of the sales of pharmaceutical representatives. Measures included sales in particular regions, number of calls, and doctor visits. Dimensions were primarily financial. This data mart served to evaluate sales representatives, and helped to make sure different reps didn’t cross over each other’s territory.
-
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
Here is the Pivot Table Tutorial and spreadsheet prepared by Prof David Schuff. You need Microsoft Excel 2007 or 2010.
And here are the answers to the “try it” exercises.
If you’re already very familiar with […]
-
Sunil Wattal wrote a new post on the site Business Intelligence 9 years, 8 months ago
- Load More