Data Analysis For Decision Making
Week 1 DQ 1
What are the stages of the report life cycle, and why is it a good business practice to follow one? Discuss the importance of effective report deployment in our strategy.
Week 1 DQ 2
One of the advantages of using SQL is the ability to drill down into the data using functions to generate useful information for our users. What are some of the more common SQL functions, and how would you use them to generate useful information for your organization?
Week 2 DQ 1
Read the case study 5.3 Project Management at Dotcom.com in the text on pages 166–167.
Dotcom.com is a software engineering and systems development consulting firm that needs some organizational improvements in the area of project management processes that will cut cost and potentially increase the profit margin for the company. Answer the following questions:
Discuss how you would begin redesigning dotcom.com’s project management processes to minimize the problems it is experiencing with poor scope management.
Week 2 DQ 2
Download the Week 2 Discussion Problems, which focus on subqueries and grouping data. Do Problems 11-20 in this thread.
For each problem, list
what the result set will look like based on the problem statement (list the specific column headings and data that will be extracted from the query) and
the SQL that will solve the problem.
Week 3 DQ 1
To develop a schedule for a project, we will use the concept of a project network, which shows work activities taken from the work breakdown structure and organized according to the logical flow in time and relationships governing when the work will be performed. By combining this network of work activities with estimates of the time duration for performing each of the activities, we can create a schedule for the project work. What types of information can we learn about the project by reviewing the project schedule and all the information used to generate it?
Week 3 DQ 2
The relational set operators UNION, INTERSECT, and EXCEPT work properly when the relations are union-compatible. What does union-compatible mean, and should we be focusing our database design to ensure we are creating tables that are union–compatible? What is a subquery, and what are its basic characteristics?
Week 4 DQ 1
Read the case study 12.1, The Problems of Multitasking in the text on pages 405–406. Answer the following questions:
How does multitasking confuse the resource availability of project team personnel?
In modern organizations, it is impossible to eliminate multitasking for the average employee? Do you agree or disagree with this statement? Why?
How would resource loading and/or resource leveling help this situation?
Week 4 DQ 2
When designing reports, what are the most important factors to consider? What impact does the layout of the report have on its ability to influence decision makers? How might you define reporting requirements correctly for stakeholders in a report?
Week 5 DQ 1
Discuss the importance of communication and information exchange to project success. What are the crucial features and elements of effective communication and information exchange in successful projects?
Week 5 DQ 2
What are the potential consequences for a company that has data that is not secure? Do some research and describe some significant database security breaches that have occurred in the last 10 years. How can a company organize itself to ensure its data is secure? What technical measures can be taken to promote the security of sensitive data in a database? What managerial measures can be taken to support this objective?
Week 6 DQ 1
Read the case study 4.2 Finding the Emotional Intelligence in the text on pages 130.
What are the differences between leaders and managers? Can anyone be a leader? Which would you prefer to work for and why?
Share an example from your work or school experience with working through the five stages of team development.
Select one of the characteristics of an effective project manager and tell why it is important.
Take the Future Time Perspective scale on page 129. Share your results and comments with the class.
Week 6 DQ 2
SQL Server Reporting Services provides many different ways of deploying reports. Let’s compare these to other ways, such as SharePoint or Google Apps. How do these technologies differ from SSRS? Can you find tools that not only allow for the dissemination of information but also allow feedback from interested stakeholders without cluttering up your e-mail inbox?
Week 7 DQ 1
Review case study 11.1 on page 375. Answer the three questions at the end of the case. Your answers must be supported by the facts of the case. You will be graded on the content of your answers as well as your feedback to other responses.
Week 7 DQ 2
Compare and contrast the differences between pivot table reports in Excel and matrix reports in SQL Server. Are there any limitations in using matrix reports over Excel’s pivot table? What are the advantages of using these reports, compared to standard table reports?