Categories
Databases

I need a tableau project completed. i will upload an excel file and video which

I need a tableau project completed. i will upload an excel file and video which shows exactly what needs to be done. Tutor will need access to tableau. I am pretty sure there is a free trial to sign up for. All other documents will be provided once tutor is chosen. File will need to be .TWBX

Categories
Databases

E9.3 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as

E9.3 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as a starting point, give an example that illustrates a slice and dice operation.
E9.4 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as a starting point, give an example that illustrates a drill-down operation.
I attached the figures. and the material

Categories
Databases

E9.3 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as

E9.3 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as a starting point, give an example that illustrates a slice and dice operation.
E9.4 Using OLAP Query 1 shown in Figure 9.11 (based on data from Figure 9.7) as a starting point, give an example that illustrates a drill-down operation.
I attached the figures. and the material

Categories
Databases

What is meant by the closure of a set of functional dependencies?

book reference
Title: Fundamentals of Database Systems
ISBN: 10: 0-13-397077-9.
Authors: Ramez Elmasri and Shankant B. Navathe
Publisher: Pearson Company
Publication Date: (2016)
Edition: 7 Edition
question 1
Discuss insertion, deletion, and modification anomalies. Why are they considered bad? Illustrate with examples
question 2
What is meant by the closure of a set of functional dependencies? Illustrate with and example.
instructions for question1 and question 2
Your response to the each question should be 250-300 words.
There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed. Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.

Categories
Databases

Use the predictive analysis tool please the instructions are attached in the bot

use the predictive analysis tool please the instructions are attached in the bottom please make predictive analysis tool 10 questions plus SAP captures

Categories
Databases

What challenges are there?

Try to identify someone you can interview that currently works with databases. What kind of training do they receive? What challenges are there? (300 words). APA 7th edition. Please include references. Thank you.

Categories
Databases

What are the top 3 best performing landing pages for the month of march 2022 in terms of total event counts select from blow.

Scenario: You work in a consulting company, and your client is a human resource, payroll, and benefits outsourcing services company. They have shared the website data from Dec 2021 to May 2022 which is attached by folder name: “Assessment Data” (link below).
You are required to complete the below task and present the report to client POC who is senior marketing manager in the company.
1. Analyze the data shared by the client team and create a dynamic dashboard visualization showing the overall website performance from Dec’21 to May’22.
2. Compare the Dec’21 v/s Mar’22 month performance, and share key actionable Insights from the dashboard.
Note: Kindly use any one of the visualization tools like Power BI/Tableau/Google Data Studio/any other similar tool for the below assignment (Please don’t use excel sheets for the same).
Instructions for the Assignment
1. In Visualization create a Date filter, further ensure that all date columns in the data sets are made in MM/DD/YYYY format.
2. Create a suitable visualization based on “Landing Page” sheet and share key insights of Landing Page performance using the below metrics.
=> Bounce Rate
=> New users
=> Unique events
=> Total Events
=> Sessions
3. Using a “Demographic” sheet, create a visualization by using the New User metric and share insights on the basis of Geo Location (country).
4. Create a suitable composition chart from the “Demographic” sheet showcasing which age group is better in terms of session count and average session duration.
5. Use a suitable visualization from “Active User” sheet to showcase monthly average of 1 day Active user, 7 day Active user , 14 day Active User and 28 day Active User as a percentage of 28 day Active User
6. Create a suitable visualization from the “New User” sheet to showcasing target vs actual users (Kindly use visualization other than line chart visualization)
Answer these questions please based on this data.
1. Kindly share insights on the website performance form the period of Dec’21 and May’22.
2. What is the New Users count from the “New User” sheet for the Month of March 2022.
3. What are the Top 3 Best performing Landing Pages for the Month of March 2022 in terms of Total Event counts select from blow.
www.xyz.com/corporate/terms
www.xyz.com/index.aspx
www.xyz.com/retirement-services
4.What are the Top 3 Best performing Landing Pages for the Month of Jan 2022 in terms of new users count.
go.xyz.com/hcm-abc
www.xyz.com/corporate/terms
www.xyz.com/index.aspx
5. Which is the Top performing channel in the month of Jan Feb and Mar 2022 in terms of Sessions Count.
6. Which is the best performing month for 1 Day active Users in terms of user count

Categories
Databases

Which is the best performing month for 1 day active users in terms of user count

Scenario: You work in a consulting company, and your client is a human resource, payroll, and benefits outsourcing services company. They have shared the website data from Dec 2021 to May 2022 which is attached by folder name: “Assessment Data” (link below). You are required to complete the below task and present the report to client POC who is senior marketing manager in the company.
1. Analyze the data shared by the client team and create a dynamic dashboard visualization showing the overall website performance from Dec’21 to May’22.
2. Compare the Dec’21 v/s Mar’22 month performance, and share key actionable Insights from the dashboard.
Note: Kindly use any one of the visualization tools like Power BI/Tableau/Google Data Studio/any other similar tool for the below assignment (Please don’t use excel sheets for the same).
Instructions for the Assignment
1. In Visualization create a Date filter, further ensure that all date columns in the data sets are made in MM/DD/YYYY format.
2. Create a suitable visualization based on “Landing Page” sheet and share key insights of Landing Page performance using the below metrics.
=> Bounce Rate
=> New users
=> Unique events
=> Total Events
=> Sessions 3. Using a “Demographic” sheet, create a visualization by using the New User metric and share insights on the basis of Geo Location (country). 4. Create a suitable composition chart from the “Demographic” sheet showcasing which age group is better in terms of session count and average session duration.
5. Use a suitable visualization from “Active User” sheet to showcase monthly average of 1 day Active user, 7 day Active user , 14 day Active User and 28 day Active User as a percentage of 28 day Active User
6. Create a suitable visualization from the “New User” sheet to showcasing target vs actual users (Kindly use visualization other than line chart visualization)
Answer these questions please based on this data.
1. Kindly share insights on the website performance form the period of Dec’21 and May’22.
2. What is the New Users count from the “New User” sheet for the Month of March 2022.
3. What are the Top 3 Best performing Landing Pages for the Month of March 2022 in terms of Total Event counts select from blow.
www.xyz.com/corporate/terms
www.xyz.com/index.aspx
www.xyz.com/retirement-services
4.What are the Top 3 Best performing Landing Pages for the Month of Jan 2022 in terms of new users count.
go.xyz.com/hcm-abc
www.xyz.com/corporate/terms
www.xyz.com/index.aspx
5. Which is the Top performing channel in the month of Jan Feb and Mar 2022 in terms of Sessions Count.
6. Which is the best performing month for 1 Day active Users in terms of user count

Categories
Databases

The goal is to have two query’s measure the same events or disease.

This Unit examines the impact of data and information on clinical decisions; in particular, in a population health management program. This Unit underscores the importance of health care data by focusing on multiple sources of business information, business intelligence and analytics to support better clinical outcomes and useful decision-making.
Completed
INDIVIDUAL ASSIGNMENT: You need to complete the I2B2 training by Tuesday (D2) of the first week (W5) of the this unit. (2 points) (You got an email from Joanna Tess earlier in the coures)
https://training.ccts.uic.edu/Course/CourseDetails…==========================================================================================================================
Need help with:
Day 4 (November 17th) ( Need Topic)
I2b2 Research Topics: Select a disease or other challenge in the EHR that you want to further pursue for the second week. (Examine PhenoKB and discover and illness you want to review with I2b2) https://phekb.org/ (1 point) Day 1 week 6 (November 21st)
Methods of query: Submit two different methods to measure your disease or other challenge in the EHR and how to query the data in i2b2. Submit by Monday (D1) of the second week (W6) (10 points) (Do not compare ICD-9 to ICD-10, Do not compare males versus females). The goal is to have two query’s measure the same events or disease. Day 6 Week 6 (November 26th)
PRESENTATION ASSIGNMENT: Disease prevalence presentation to Senior Leadership, you are tasked with presenting the prevalence of a specific disease or other hard to measure challenge in your health system. Please prepare a 10 minute powerpoint about the disease prevelence in your health system based on your results from the i2b2 queries. All uncertainty in the disease must be explained in a concise way. (See presentation grading rubric) 105 points. Saturday of the second week (D6 W6) at 11:59 AM. Use speaker notes to include what you would say during the presentation.

Categories
Databases

The goal is to have two query’s measure the same events or disease.

This Unit examines the impact of data and information on clinical decisions; in particular, in a population health management program. This Unit underscores the importance of health care data by focusing on multiple sources of business information, business intelligence and analytics to support better clinical outcomes and useful decision-making.
Completed
INDIVIDUAL ASSIGNMENT: You need to complete the I2B2 training by Tuesday (D2) of the first week (W5) of the this unit. (2 points) (You got an email from Joanna Tess earlier in the coures)
https://training.ccts.uic.edu/Course/CourseDetails…==========================================================================================================================
Need help with:
Day 4 (November 17th) ( Need Topic)
I2b2 Research Topics: Select a disease or other challenge in the EHR that you want to further pursue for the second week. (Examine PhenoKB and discover and illness you want to review with I2b2) https://phekb.org/ (1 point) Day 1 week 6 (November 21st)
Methods of query: Submit two different methods to measure your disease or other challenge in the EHR and how to query the data in i2b2. Submit by Monday (D1) of the second week (W6) (10 points) (Do not compare ICD-9 to ICD-10, Do not compare males versus females). The goal is to have two query’s measure the same events or disease. Day 6 Week 6 (November 26th)
PRESENTATION ASSIGNMENT: Disease prevalence presentation to Senior Leadership, you are tasked with presenting the prevalence of a specific disease or other hard to measure challenge in your health system. Please prepare a 10 minute powerpoint about the disease prevelence in your health system based on your results from the i2b2 queries. All uncertainty in the disease must be explained in a concise way. (See presentation grading rubric) 105 points. Saturday of the second week (D6 W6) at 11:59 AM. Use speaker notes to include what you would say during the presentation.