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

Explain each of the above choices

using the information in the figure below, answer the following questions. (The sample data may not represent all future field values; use common knowledge and consider the domain for each field)
We record only the last sale for each car. For each sale, a car can be sold to only one customer; however, each customer can buy (own) more than one car.
Include the below numbers to organize the submission. DO NOT include the Questions or other content from the instructions.
1) Describe functional dependency only; NOT full functional dependency, or partial dependency, or transitive dependency. Hint – review the Functional Dependencies Topic in the Terms and Concepts discussion. While you may incorporate the formal definition, you must explain the concept in your own words, using fields names and values from this exercise. 15%
Using the functional dependency notation shown on pages 412, 413 Examples 14.4, 14.5, identify the functional dependencies that exist in the above figure. All attributes should be included at least once. There may be more than one row of functional notation needed. 15%
2) Identify a primary key for the table in the above figure. 10%
Indicate whether there are any alternate keys (for this table) 15%
explain each of the above choices
3) Is the table in 3NF? 10%
If not, explain why – (provide specific rationale, use field names and values in the table to demonstrate your understanding). 15%
Explain what normal form the table provided is in. 10%
APA guidelines, spelling, grammar, file name 10%
Connolly, T., & Begg, C. (2014). Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). Pearson Learning Solutions. https://online.vitalsource.com/books/9781269875356

Categories
Databases

Download

Your data has a story. Share it with the world. Visualize and publish at least three data visualizations on any topics you care about.
Download https://public.tableau.com/s/
Resources
https://public.tableau.com/en-us/s/resources Examples: Stunning data visualization examples from across the web created with Tableau Public.
https://public.tableau.com/en-us/gallery/
Deliverables:
1. URL (your profile page) Example: https://public.tableau.com/profile/utalibraries#!/ (3points)
2. Explanation of work (2 points)
 Analyze the vizzes (data collection and resulted visuals)  Screenshots of all tableau vizzes (Visuals)

Categories
Databases

Give example of this query using sql instruction and explain about it.

The final project may covers, as much as possible, the following:
1. Basic overview of the data processing of your DBMS systems
2. dbase model: metadata, dbase structure, E-R diagram
3. few data in the DBase,
4. please use MS-Access at least with 3 tables and relationship link
5. Output Information to be generated by your dbase
6. Example of data processing and information search/query on your dbase
7. include input form to be used to enter, edit and delete record.
8. create Query to show certain data processing / filtering
9. give example of this query using SQL instruction and explain about it.
10. also create (output) report, and VBA programs if possible in your database.
11. add YOUR-NAME in the 1st RECORD in the dbase
(e.g. in customer table & show it in your Query). (my name: PENG Tzu Ting)
12. The report is around 500 words.

Categories
Databases

Describe the role information plays in enterprise resource planning systems?

Describe the role information plays in enterprise resource planning systems?
.Compare customer relationship management, supplier relationship management, partner relationship management, and employee relationship management.?

Categories
Databases

Provide and interpret the results of your regression analysis as you did in part 1.

TASK
IN THIS ASSIGNMENT, YOU WILL WORK ON A PROJECT WHICH INCLUDES THE FOLLOWING:
Running a regression of stock returns against changes in exchange rates
Interpret the findings of the regression analysis
Estimate the degree of economic exposure based on the results from the regression analysis
You will do all of the above twice, first using some made-up data provided below; and a second time using an actual MNC you will select.
INSTRUCTIONSTIONS
Download the spreadsheet “Economic Exposure”. The file contains the following data over a 61month interval (these are data I made up for Part 1): Economic_Exposure.xls
Download Economic_Exposure.xls
the stock price of a multinational company,
the value of the European Currency Unit (ECU), quoted $/ECU.
PART 1
Step 1: Use the price series for the company to calculate monthly returns. Note that 61 months of price data will generate 60 months of returns. Similarly, use the ECU series to calculate the monthly percentage changes in the dollar value of the ECU. Show the two series of changes in two separate columns next to the original prices and exchange rates.
Step 2: Regress the return on the company against the percentage changes in the ECU. Stated differently, the return on the company is the dependent (y-axis) variable and the change in the value of the ECU is the independent (x-axis) variable. Report the slope coefficient and its p-value, and the R-squared of the regression. The regression output should be shown in the Excel file.
Step 3: In one Word page, interpret the results as follows:
Provide an interpretation for each of the i) p-value of the estimated slope coefficient, ii) slope coefficient and iii) R-squared
How does the value of the company change when the dollar depreciates?
How much economic exposure does the company have? Here you reach a conclusion based on your answers to 1 and 2 above.
You will submit one Excel file with the regression data and results and one Word file with the interpretation. However, you may choose to provide your interpretation in the Excel file and submit just one Excel file and no Word file if you prefer. This is Part 1 of the assignment.
PART 2
Now select a Multinational Company that has a least 60 monthly return observations available at finance.yahoo.com and estimate the firm’s level of economic exposure using regression analysis, as in Part 1. Exchange rate information is available at, for example Historical rates
Links to an external site.
As part of your answer, provide the following information:
Identify the Multinational Company
Assess qualitatively the firm’s exposure to exchange rate risk after examination of the firm’s revenue information by geographical segment (for example, from SEC 10-K filings at U.S. SECURITIES AND EXCHANGE COMMISSION Links to an external site. and then “Filings”). Use this to briefly explain your choice of currencies to use in the regression analysis.
Provide and interpret the results of your regression analysis as you did in Part 1. Assess quantitatively the level of economic exposure of the firm relative to movements in the currency or currencies you selected. In your interpretation, follow the structure of Part 1.
Important: Make sure the dates for exchange rates and stock prices match when you put them both in the same Excel file as in Part 1. Use “adjusted prices” if you get your monthly stock prices from Yahoo FinanceLinks to an external site. (i.e., stock prices adjusted for stock splits)
You will submit one Excel file with the regression data and results and one Word file with the interpretation. However, you may choose to provide your interpretation in the Excel file and submit just one Excel file and no Word file.
The most difficult but also the most important aspect of the assignment is the interpretation. To help you get started, I have some basic ideas here: Regression Analysis get started answe

Categories
Databases

Four questions need to be solved based on ‘ heart failure cleaning data’

Four questions need to be solved based on ‘ Heart Failure Cleaning Data’ Screen shorts must needed using weka software process

Categories
Databases

Do your own work.

Hello,
Please answer the following database tasks in separate word documents Exercise 2
Submit your answers to the exercise questions at the end of chapter 2 in the free text book in a single Word document. Do not include the questions. Use your own words.
( textbook attached below ) ( https://opentextbc.ca/dbdesign01/ ) SQLZoo 2
Submit screenshots of your successful completion of SELECT from World and SELECT from Nobel and quizzes.
( https://sqlzoo.net/wiki/SQL_Tutorial ) Banas, revisited ( code attached below ) Now that you have succeeded in replicating the infamous Banas database example, I need you to refactor your work into three scripts so that:
1.) There is one script that only creates the database and inserts the tables. (Pick a good name for this, e.g., “buildBanasDatabas.sql”.
2.) There is a second script that loads data into the tables. (Pick a good name, e.g.,, “loadDataIntoBanasDatabase.sql”.)
3.) There is a third and final script that reads the data. (Pick a good name e.g., “readDataFromBanasDatase.sql”.)
You will submit three SQL scripts.
Each one must start with a meaningful comment block that indicates who you are, when you did your work, the CRN number of your course, etc.
Be sure that your scripts actually run.
Designing a database – Songbook
Using what you have learned from the Banas database create a songbook database. Each book has 10 songs. It has a publication date and a name. Each song has a name, a publication date, a genre and an author. Each author may have multiple songs but each song has a single author. Each genre will have multiple songs but each song has only one genre. Create and use foreign keys to connect the books and songs, the songs and their author, and the songs and their genre. Submit two scripts – one to create the database and one to populate the database. Do your own work. type it out yourself so that you contineu to learn the syntax. Week 2 Self Study Lab – John’s T-shirts
Create a retail database for John’s T-Shirts
Tables: product, customer, Sales Person, Transaction
Reverse engineer and ER diagram using Workbench
Submit a Word document with the database code in screenshots. each screenshot should have a timestamp from your computer.

Categories
Databases

Pratice e–x-a-m time: 17/11

Pratice E–x-a-m Time: 17/11
Duration : 2 hrs
Question structure:
The examination will consist of short answer conceptual questions and practical exercises/problem questions. The questions will be comparable to those covered in class; therefore, the best form of revision will be to work through lecture and tutorial questions, exercises and problems.
Topic covered: Similar to that screenshot attached