Category: Internet technology (IT)

This tutorial will familiarize you with the features and capabilities of Tableau

This tutorial will familiarize you with the features and capabilities of Tableau.
Download the file: Music Sales-Template(10.3).twbxDownload Music Sales-Template(10.3).twbx
Open it in Tableau Desktop.  Click on the tab labeled “Terminology and Interface.”  You should see a diagram that explains the various components on the screen.
Tableau Guided Tutorial using Music Sales
Visualizing Music Store Sales
This data set was adapted from the Chinook database offered at codeplex (http://chinookdatabase.codeplex.com/). This data set was adjusted for purposes of visualizing using Tableau. When you go through the exercises in this workbook, you will acquire skills and familiarity that you can use when visualizing other data sets.
Directions
Before you proceed, check out the “Terminology and Interface” dashboard. This will help you with some of the common Tableau terminology and Tableau Desktop interface components. You can always come back to this dashboard for reference at any time during your exercise.
Terminology
As you go through the exercises, you will encounter terminology that may not be familiar to you. Below is a typical Tableau interface with some of the components labeled. You can use this image as reference as you complete the tutorial. Check out the Tableau Product Help for additional topics at this URL: http://onlinehelp.tableausoftware.com/current/pro/onlie/en-us/help.htm
Please practice how to use Tableau for data visualization using the following five exercises. 
A. Most Popular Genre in Europe and Asia (Which music genre generates the most sales?)
To help determine next year’s budget, you are asked to create a visualization to determine which genre sells the most to our customers in Europe and Asia.
Drag the Genre dimension to Rows.
Drag the Quantity measure to Columns. Notice this will automatically aggregate quantity using SUM.
Drag a new instance of the Genre dimension to Color (Note: do not remove Genre “pill” in Rows at the top of the page). Keep in mind that we have to use color with caution, but in our case, we will use color to relate to another worksheet we’ll build in the next exercises.
Click on the Descending bars icon on the toolbar (it is to the left of the “Highlight” button that looks like a pencil).
Click on Show Mark Labels in the toolbar (the [T] icon) to turn on labels so the quantity is showing as a number for each row (it is to the left of the Fix Axes icon that looks like a pushpin).
Drag the Region dimension to the Filters shelf. Choose Europe and Asia.
Right click the Region pill in the Filters shelf to show the dropdown. Choose Apply to Worksheets > All Using This Data Source.
Right click the Region pill in the Filters shelf to show the dropdown.
Select “Show Filter”.
Notice this will display another card that has all the Region values with checkboxes right beside them. Your users can use this to interact with this worksheet.
Right click on the bar of the top selling genre, and choose Annotate > Mark. Type the following in the Annotation editor. For anything in angled bracket, use the “Insert” dropdown menu to select the actual fields.
Top Selling Genre:
Quantity Sold:
Click OK when you are done
Adjust the location of the mark annotation by selecting and dragging its border so it’s visible in the view.
B. Top 20 Artists in Europe and Asia (Which artists sell the most?)
Now that you know the most popular genres in Europe and Asia, you are asked to determine which artists sell the most. You are also asked to show if the artists produced tracks only on one genre, or if they have music across multiple genres.
Drag the Artist dimension to Rows.
Drag the Quantity measure to Columns. Notice this will automatically aggregate quantity using SUM.
Drag the Genre dimension to the Color shelf. You will be presented with a warning message. Choose “Add all members.” Also, notice this places a Genre pill in the Marks shelf with a color icon right beside it.
Drag a new instance of the Quantity measure to the Label shelf. Do not remove the Sum(Quantity) pill from the Columns shelf. Notice this places a Quantity pill in the Marks shelf with an “[T]” icon right beside it.
Right-click on the SUM(Quantity) pill in the Marks shelf to show the dropdown and choose Format.
In the Default section, click on the Numbers dropdown. Choose Number (Standard). Click OK when done.
Right-click the Artist pill in the Rows shelf to show the dropdown menu. Choose Filter…
In the Filters dialog box, choose the Top tab (4th tab). Choose By Field: Top 20 by Quantity Sum. Click OK or apply changes.
Sort your worksheet in descending order by clicking Sort Descending in the toolbar.
C. Sales Distribution by Region (How do our region sales compare to each other?)
We are then asked to assess which regions in Europe and Asia sell the most records, but we quickly find that we aren’t able to answer this information given the fields already defined in our data set.
Click on the dropdown icon beside the magnifying lens in the Dimensions window and select “Create Calculated Field”.
Name your calculated field Sales.  In the Formula, use the following. Note you can also drag the field names from the Fields pane.
[Quantity] * [UnitPrice]
Click OK when done. This new Sales field will show up under Measures, and will have an icon that starts with an equal (=) sign.
Drag the Sales calculated field from Measures to the Size shelf. Notice this places a Sales pill in the Marks shelf with circle icon right beside it.
Drag Region dimension to the Color shelf. Notice this places a Region pill in the Marks shelf with color icon right beside it.
Drag Country dimension to the Detail shelf. Notice this places a Country pill in the Marks shelf with no icon right beside it.
Click on the space beside the Country dimension you just added to the Detail shelf and select the color icon.
Right click the Country dimension you added to the Detail shelf and select Sort.
In Sort order, choose Descending. In Sort by, choose Field: Quantity and Aggregation: Sum. Click OK when done.
Drag the Country dimension to the Label shelf (beside the Size shelf in the Marks card).
Drag the Sales calculated field from Measures to the Label shelf.
Click on the Sales pill in the Marks shelf to show the dropdown, and choose Quick Table Calculation > Percent of Total.
D. What does our geographic sales distribution look like? 
You want to expand sales to more countries. To do this, you need to know first how our sales look like in the countries we are currently catering.
Double click the Country dimension pill. This creates a geospatial map in the view. You should also notice that latitude and longitude are automatically placed in the rows and columns shelves respectively.
In the Marks shelf, change the type from Automatic to Filled Map.
Drag the Sales measure to Color. This adds a SUM(Sales) pill in the Marks card with a color icon beside it.
Drag the Sales measure again to Label. This adds a SUM(Sales) pill in the Marks card with an “[T]” icon beside it.
Click the SUM(Sales) pill in the Marks card to show the dropdown. Choose Format.
Under the Default group, choose Currency (Custom), with zero (0) decimal places. Keep the thousands separator checked.
Drag the Country dimension to Label.
Click on the Label shelf to open the Label editor. Format the label so that Country is
placed above Sales
a slightly bigger font than Sales
is Bold
Edit the color legend by clicking on the top right side of the legend border (or click the color card and choose Edit colors). Choose the Red Green Diverging color palette. Click OK when done.
E. Rock vs Alternative vs Heavy Metal…How does the sales trend of Rock tracks compare against Alternative and Heavy Metal tracks?
One of your market researchers needs to find out the sales trend of Rock, Alternative and Heavy Metal tracks. You offered to help her out.
Right click drag InvoiceDate dimension to the Columns shelf. A right click drag opens a menu as soon as the field is placed on the shelf.
Choose the continuous (green) MONTH(InvoiceDate) from the dropdown. This has a green calendar icon beside it.
Continuous (green) fields produce axes, which is what we want. Discrete (blue) fields produce headers.
Drag the Sales measure to the Rows shelf. This produces a line graph for you.
Drag the Genre dimension to Color to keep the color theme consistent with other worksheets.
We have too much information on our view to be able to answer our original question. Drag the Genre dimension to Filters, and choose Rock, Alternative and Punk, and Heavy Metal.
Go to the Analysis menu and select Trend Lines > Show Trend Lines.
Dashboarding Instructions 
Now it’s time to put all your worksheets together into a single dashboard. You have the freedom to design the dashboard and add components as you see fit. Below is an example dashboard that you can use as a starting point. The “Music Sales Dashboard” is set up as a blank dashboard for you to be able to work with. Before creating the dashboard, please watch the following tutorial video for creating a Tableau dashboard.

1,050- to 1,400-word report, analyzing the SDLC methodologies and phases of the

1,050- to 1,400-word report, analyzing the SDLC methodologies and phases of the WeLoveVideo project. Include the following: 
Compare the phases of waterfall and Agile SDLCs. 
Explain the steps of the WeLoveVideo CRM project in the waterfall SDLC.
Explain the steps of the WeLoveVideo CRM project in the Agile SDLC. Include a minimum of 2 cycles to show the iterative nature of Agile methodology.
Create a list of 15 business requirements written as user stories for the WeLoveVideo CRM project.

Title Page
Title of the
Paper
Your Name
Institutional
Affiliation
Abstract
Summa

Title Page
Title of the
Paper
Your Name
Institutional
Affiliation
Abstract
Summary of the
paper (around 150-250 words)
Keywords
(relevant terms for indexing)
1. Introduction
Importance of
network security in the digital age
Definition of
network security
Objectives of
the paper
2. Threats to Network Security
Types of
threats (e.g., malware, phishing, DDoS attacks)
Case
studies/examples of significant network security breaches
Impact of
security breaches on organizations
3. Vulnerabilities in Network Systems
Common
vulnerabilities in network infrastructure (e.g., weak passwords, outdated
software)
Human factors
contributing to vulnerabilities (e.g., social engineering)
Examples of
vulnerabilities exploited in past attacks
4. Network Security Technologies
Overview of key
technologies (e.g., firewalls, intrusion detection systems)
How each
technology contributes to network security
Case
studies/examples of successful implementation
5. Network Security Policies and
Procedures
Importance of
policies and procedures in maintaining security
Elements of a
robust network security policy
Case
studies/examples of effective policy implementation
6. Best Practices in Network Security
Practical steps
for improving network security (e.g., regular updates, encryption)
Importance of
employee training and awareness programs
Case
studies/examples of organizations implementing best practices
7. Legal and Ethical Issues in Network
Security
Overview of
legal requirements (e.g., GDPR, HIPAA)
Ethical
considerations in handling network security incidents
Case
studies/examples of legal and ethical dilemmas in network security
8. Future Trends in Network Security
Emerging
technologies impacting network security (e.g., AI, IoT)
Predictions for
future challenges and opportunities
Case
studies/examples of innovative approaches
9. Conclusion
Summary of key
findings
Recommendations
for improving network security
Importance of
ongoing research and development in the field
References

Overview
For this assignment, you will create a response to the following memo f

Overview
For this assignment, you will create a response to the following memo from your Project Manager:
Memo
From: The PM
To: Members of the project team
Attached is the Gantt chart for the project. As you can see, we have a tight schedule. Please review it and comment on your area, as we know the coming project will be challenging. With everyone’s help, though, I’m sure we can pull this off with a minimum of scope creep. I look forward to hearing from you before the meeting on Tuesday.
This project involves moving our current in-house system to a cloud solution. We are not sure yet if we’re going to partner with an outside company to manage the cloud services or if we’re going to just rent space on Google, Amazon, Microsoft, or other cloud services. I’ll expect a recommendation from each of you based on your area of expertise. Do your research and provide me the pros and cons of the option you are recommending. Be sure to share where you got that information, so I can take a look at your reasoning if I have questions. DO NOT just cut and paste what you find, but rather explain the pros and cons in your own words.
Gantt Chart File [PDF]Download Gantt Chart File [PDF]
Instructions
Respond in a memo using the Word document template Download Word document templateprovided. There should be two parts to your response.
Part 1
The first part of your response is based on the research you completed when determining whether to go with a company to manage cloud services or rent space with one of the well-established cloud services. Include the following:
A list of the pros and cons of both options. You should have at least two pros and cons for each option.
Your recommendation is supported by your research.
A list of the sources that informed your recommendation. Be sure that these sources are varied and from a variety of relevant perspectives. They should also be credible sources. For example, what Google claims their cloud service will do may not be the experience of a business using their service. In the same way, a small business may have a different experience with the same service a large business uses.
Part 2
The second part is the additions needed to the Gantt chart in your area of expertise. Consider what steps will need to occur in your area in order to make this project possible. Consider also the time it will take to complete each of the subtasks, keeping in mind the overall timeline of the project. Include the following:
A list of subtasks that need to be added to your area of the Gantt chart. (For example, if you’re a networking specialist, you’ll need to decide what you’re going to do with the network to support the project. Are you going to hire an outside company to expand your network? Do you have the bandwidth you’ll need now that the system is going to be located in the cloud? How much time do you need to purchase equipment like an additional router or a better firewall?)
A breakdown of any equipment that will be needed for each subtask and when it will need to be installed.
Here are some questions to consider for each role as you write your response memo:
If you’re the IT Project manager, you’ll need to get recommendations from others on the team and then make your recommendation to the PM. What are the main considerations? You’ll need to research and come up with some options.
If you’re the data analyst, do your research and find out what this transition will look like to the users in the company and your company’s clients/customers.
If you’re the cybersecurity expert, what concerns do you have, and which methods will you use to secure the network and the cloud solution? What does the partner service provide, and what will we need to do/know in the company, and what training will be needed for users?
If you’re a software designer, what interface will you need to create/adopt? How will the software you’re using now change if we relocate to the cloud?
If you’re a data manager, how will the database platform change/adapt to the relocation? How will the data be packaged, secured, stored, transported, backed up, etc.?
Note: please use the GANTT chart file and the word document file attached to complete this assignment

Objective
The purpose of this final project is to explore legal and policy chall

Objective
The purpose of this final project is to explore legal and policy challenges arising from technology advancements. Students will critically analyze relevant issues, propose solutions, and consider the societal impact of technology-related regulations.
Project Components
Research and Background:
Begin by researching recent technological developments (e.g., AI, blockchain, cybersecurity, biotechnology).
Understand existing legal frameworks, international treaties, and industry standards related to these technologies.
Identify key stakeholders (government agencies, industry, civil society) involved in shaping technology policy.
Select a Technology Domain:
Choose a specific technology domain (e.g., AI, blockchain, cybersecurity, biotechnology, data privacy, intellectual property, digital rights).
Consider its legal implications, ethical dilemmas, and potential conflicts.
Case Studies and Comparative Analysis:
Analyze real-world case studies related to your chosen domain.
Compare how different countries or regions handle similar issues (e.g., GDPR vs. CCPA).
Evaluate the effectiveness of existing policies and their impact on innovation, privacy, and security.
Policy Proposals:
Develop policy proposals to address gaps or shortcomings in current regulations.
Consider balancing innovation with public interest, protecting individual rights, and fostering fair competition.
Propose practical solutions that account for technological advancements and societal needs.
Ethical Considerations:
Reflect on the ethical dimensions of technology policy.
Discuss potential unintended consequences, biases, and social justice implications.
Explore ways to promote transparency, accountability, and inclusivity.
Presentation and Recommendations:
Create a comprehensive presentation summarizing your findings. This presentation could be created using PowerPoint and should include audio recordings over slides with the total presentation being a minimum of 10 minutes long. The final submission should include a copy of the PowerPoint slides and a YouTube link to the presentation recording.
This may require researching how to add audio recordings with export to YouTube. 
Clearly articulate your recommendations for policymakers, industry leaders, and the public.
Highlight the importance of adaptive policies that evolve alongside technological advancements.
Grading Criteria
This final project will be assessed based on research depth, critical analysis, creativity, and the clarity of policy recommendations. Students should demonstrate a holistic understanding of technology law and its impact on society.

Week 4 Discussion – Dealing with Conflict in Teams
The ability to deal with prof

Week 4 Discussion – Dealing with Conflict in Teams
The ability to deal with professional conflict is one of those soft skills that is very useful when working in teams. In 3-4 paragraphs, discuss the following:
Imagine you are on a team at work, and the Project Manager has asked each of the team members for their input on how the team is working together. Thinking about your concentration and likely role with a company, what do you hope the other team members will say about you?
Suppose one of the team members isn’t contributing very much or providing you with something you need in order to proceed with your part of the project. How might you address the situation? Include a rationale for why you would take that approach.
What might you do if you approached the Project Manager about the issue with a teammate and the Project Manager ignored your concerns?
Please respond substantively to at least one other post (1-2 paragraphs each post). Choose to respond to those who have few or no responses, as well as interesting conversations you want to join. Remember to get in early in the week for your initial post and then come back a few other times during the week for the best experience.

Complete instructions and data files are attached. Be sure to read the Additiona

Complete instructions and data files are attached. Be sure to read the Additional Clarification document as well.
You will need to provide 3 files that correct in order to receive full credit for this assignment: 
SQL script that I may paste directly into SQLiteonline.com and obtain the results. Any code that should not be used must be commented or else the code will not run without modification.
csv file with the results from the staging table after you perform the ETL
Memo using the attached template stating what was done along with the checksum value you received
ETL SQL File Clarification and Tips on Selecting All Table
In the past you have pasted your code within the Word document for this assignment I want just the SQL code in a separate file.  Please see an example .txt or .sql file below. Notice it only contains the SQL code. If you have comments you want to make sure that you make them comments in your code or else the code will not work correctly with modification causing a 50% reduction in the assignment grade.
Tips on Selecting Data from Final Table for Export
After you create your table and insert the data from all the tables that you imported, you can right click on the final table and then select SELECT (Show table).  This will display all of the data in the table like you see on the right.
Once all the data is showing, you are now ready to export your table data. You may do so by click on Export on the top and selecting CSV like you see below. 
Checking your work
When you complete this assignment you want to review your output from your csv file to ensure that you have actual data, because if there is an typo in your code you will have text from the code versus the actual data from the table. Your csv file should have the results from your script running not the checksum number. Check the csv file to ensure that you have actual data from the tables versus a text value based on the SELECT statement. The INSERT and SELECT statement field names must match or else either the table will not be created or the data in the table will be text versus the values found in the yearly tables. If you have questions please ask and do not wait until the last minute, because things happen (e.g., technology outages, etc.) and you will not have enough time to ask questions.

Overview
For this assignment, you will create a response to the following memo f

Overview
For this assignment, you will create a response to the following memo from your Project Manager:
Memo
From: The PM
To: Members of the project team
Attached is the Gantt chart for the project. As you can see, we have a tight schedule. Please review it and comment on your area, as we know the coming project will be challenging. With everyone’s help, though, I’m sure we can pull this off with a minimum of scope creep. I look forward to hearing from you before the meeting on Tuesday.
This project involves moving our current in-house system to a cloud solution. We are not sure yet if we’re going to partner with an outside company to manage the cloud services or if we’re going to just rent space on Google, Amazon, Microsoft, or other cloud services. I’ll expect a recommendation from each of you based on your area of expertise. Do your research and provide me the pros and cons of the option you are recommending. Be sure to share where you got that information, so I can take a look at your reasoning if I have questions. DO NOT just cut and paste what you find, but rather explain the pros and cons in your own words.
Gantt Chart File [PDF]Download Gantt Chart File [PDF]
Instructions
Respond in a memo using the Word document template Download Word document templateprovided. There should be two parts to your response.
Part 1
The first part of your response is based on the research you completed when determining whether to go with a company to manage cloud services or rent space with one of the well-established cloud services. Include the following:
A list of the pros and cons of both options. You should have at least two pros and cons for each option.
Your recommendation is supported by your research.
A list of the sources that informed your recommendation. Be sure that these sources are varied and from a variety of relevant perspectives. They should also be credible sources. For example, what Google claims their cloud service will do may not be the experience of a business using their service. In the same way, a small business may have a different experience with the same service a large business uses.
Part 2
The second part is the additions needed to the Gantt chart in your area of expertise. Consider what steps will need to occur in your area in order to make this project possible. Consider also the time it will take to complete each of the subtasks, keeping in mind the overall timeline of the project. Include the following:
A list of subtasks that need to be added to your area of the Gantt chart. (For example, if you’re a networking specialist, you’ll need to decide what you’re going to do with the network to support the project. Are you going to hire an outside company to expand your network? Do you have the bandwidth you’ll need now that the system is going to be located in the cloud? How much time do you need to purchase equipment like an additional router or a better firewall?)
A breakdown of any equipment that will be needed for each subtask and when it will need to be installed.
Here are some questions to consider for each role as you write your response memo:
If you’re the IT Project manager, you’ll need to get recommendations from others on the team and then make your recommendation to the PM. What are the main considerations? You’ll need to research and come up with some options.
If you’re the data analyst, do your research and find out what this transition will look like to the users in the company and your company’s clients/customers.
If you’re the cybersecurity expert, what concerns do you have, and which methods will you use to secure the network and the cloud solution? What does the partner service provide, and what will we need to do/know in the company, and what training will be needed for users?
If you’re a software designer, what interface will you need to create/adopt? How will the software you’re using now change if we relocate to the cloud?
If you’re a data manager, how will the database platform change/adapt to the relocation? How will the data be packaged, secured, stored, transported, backed up, etc.?
Note: please use the GANTT chart file and the word document file attached to complete this assignment

Week 3 Discussion – Developing Soft Skills
Employers want their employees to hav

Week 3 Discussion – Developing Soft Skills
Employers want their employees to have certain soft skills like communication skills, critical thinking, time management, etc. Please respond to the following in a substantive post (2-3 paragraphs):
In one paragraph, describe some soft skills you possess. How did you gain these skills? How might you recommend to others to improve these skills?
In another paragraph, describe a soft skill you need to work on developing. What are some tips you’ve picked up that you plan to put into practice? How will this skill help you in your career?
One assumed soft skill is downloading software. This is something you’ll be expected to do regularly in an IT role. What sort of things might you need to know in order to download software on the job?
Please respond substantively to at least one other post (1-2 paragraphs each post). Choose to respond to those who have few or no responses, as well as interesting conversations you want to join. Remember to get in early in the week for your initial post and then come back a few other times during the week for the best experience.

/ 
Directions
As part of your project, you will describe a social, cultural, or

/ 
Directions
As part of your project, you will describe a social, cultural, or global event where a technology plays a significant role. For this activity, you will write a short paper on the specific technology of your choice. Choose a specific technology that influenced a social, cultural, or global event that you are interested in. Your selection could be something that you have personally experienced or that you are interested in knowing more about. Review the module resources and visit the IDS 403 Library Guide for guidance on how to select and narrow a topic. After selecting your topic, do some preliminary research to make sure you can address the required elements of your project.
In your paper, you must apply each lens to your event by using its language and perspectives. You are not required to answer each question below the rubric criteria, but you may use them to better understand the criteria and guide your thinking and writing.  
Specifically, you must address the following rubric criteria:
Describe your existing knowledge about the specific technology that influenced a social, cultural, and global event.
You might describe your personal experience with the technology, what you learned in school, or what your assumptions are about the technology. Ask, what do I know (or think I know)?
Apply the history lens to your technology.
Using the language of history as it is defined in your resources, and as it is used in academic journals, how would you write about your technology? What events and dates have occurred that are important to your technology? Has the significance of the technology diminished or shifted with time? Who are the authors of the historical record(s) related to your technology?
Apply the humanities lens to your technology.
Using the language of the humanities as it is defined in your resources, and as it is used in academic journals, how would you write about your technology? What meaning does your technology have within cultures? How do people express themselves regarding your technology? What are people’s lived experiences with your technology?
Apply the natural and applied sciences lens to your technology.
Using the language of the natural and applied sciences as it is defined in your resources, and as it is used in academic journals, how would you write about your technology? How might the scientific method be used to examine some aspect of your technology? How might your technology relate to the physical or material world? Are there any challenges to viewing your technology objectively?
Apply the social science lens to your technology.
Using the language of the social sciences as it is defined in your resources, and as it is used in academic journals, how would you write about your technology? Who is affected by your technology? How might your technology affect interpersonal relationships? What social structures and systems relate to your technology?
What to Submit
Submit your activity as a 1- to 2-page Microsoft Word document with double spacing, 12-point Times New Roman font, and one-inch margins. If sources are used, they should be cited according to APA style.