Category: Data Analytics

Your ability to connect data sources, transform data, and create data models in Power BI

Please finish it in 10 hours. your ability to connect data sources, transform data, and create data models in Power BI. You will be given a set of datasets with descriptions in the following. You need to transform the individual datasets first (e.g., removing rows, changing data types, fill in missing values) and then establish relationships among them to create a reasonable data model (e.g., identify the primary keys andforeign keys to establish appropriate and meaningful relationships among tables). Be sure to use power BI! Be sure to use power BI! Be sure to use power BI!

Case Study #1 is intended to test your knowledge of how to summarize data using

Case Study #1 is intended to test your knowledge of how to summarize data using pivot tables in Excel using the data file, including using filters and interpreting the results Week 1 Case Study #1 Pivot Table Data.xlsm Download Week 1 Case Study #1 Pivot Table Data.xlsm.
The data file contains US sales and profits from orders for 2021 and 2022 for an office supply store. The data fields included are as follows:
Year – year of sale
Segment – corporate, consumer or home office
State/Province – state name
Region –distinct geographic region recorded
Category – product family of items sold
Sub-category – product line of items sold
Sales – in thousands of dollars of product shipped and invoiced per order
Qty – number of items shipped on the order
Profit – in thousands of dollars profit of order
After watching the video How to Create Pivot Tables in ExcelLinks to an external site., and How to Change Value Field SettingsLinks to an external site. create the following 5 pivot tables:
One pivot table – Total sales and count of orders by Year, by Region
One pivot table – Total sales and count of orders by Category within each Region, filtered by year. Table should allow you to filter data based on a select Year.
One pivot table – Total Sales by Category within each Region for 2021 and 2022 (year in columns) as a percent of Grand Total sales.
One pivot table – Total Profits by Category within Region for 2021 and 2022 (year in columns)
One pivot table – Total Profits by Sub-category by Region (columns), sorted by highest to lowest Sub-category Grand Total profits. (To sort values in pivot tables, select any number in the Grand Total row or column, and then click Sort > Largest to smallest)
Provide a brief summary noting the largest and smallest region/category/subcategory of sales and profits per year from the above. Summaries can be included in Excel in same worksheet(s) as each pivot table or in a separate worksheet.
Submit a single workbook showing the 5 fully functional pivot tables and the requested summary information.
Copy of instructions and USCB information about the data file:

Financial Analysis Project
On your first job assignment as an equity analyst, yo

Financial Analysis Project
On your first job assignment as an equity analyst, you need to analyze one of four companies: Chipotle Mexican Grill (CMG), Nvidia (NVDA), Tesla (TSLA) or Meta (FB). You may do this analysis in Microsoft Excel (preferred), Google Sheets (not recommended). You must show your company data with web citation, and clearly show all ratio inputs and output values. (Note: If using Microsoft excel, please use cell references for computation of ratios.)
Please complete the following tasks:
Source the past 4 years financial statements for your company.
Download (or copy/paste) the annual income statements, balance sheets, and cash flow statements for the last 4 fiscal years (2018, 2019, 2020, 2021) from your company from either: SEC Website, Annual reports, Google Finance or other site. Enter the company’s stock symbol and then go to “financials”. Copy and paste the financial statements into Excel or Word. It is best to put the individual financial statements on separate sheets (tabs) within the workbook or google sheet.
For each of the 4 years, compute the following ratios for each firm:
Current ratio
Inventory turnover
Operating margin
Net profit margin
Obtain industry averages for your respective firm from Zack’s, y-charts, google finance, or other site. Cite your source by copying the URL to your document. Compare the firm’s 2021 ratio to the available industry ratios for the most recent year (2021 or 2022 is ok).
Analyze the performance of your firm (ratios) versus its industry (Peer analysis – against benchmark) and comment on any trends (Trend analysis – over time) in each individual firm’s performance. Comment on both the peer analysis and the trend analysis. A couple sentence is adequate.
Identify any/all strengths or weakness, including qualitative factors, which you find in your firm. Answer the question: “Would you invest in this firm?” A couple sentences is adequate.
Points breakdown (15 points)
#1: 4
#2: 4
#3: 1
#4: 3
#5: 3

Research a particular industry academic or corporate and explain how they converted to telecommuting from an IT perspective.

hello i am working in two question the professional assignment and reply two student 300 words with reference I attached file related to answer of two student to reply to them about the professional assignment i attached the question here with the instruction for two questions
Note this assignment should be important submit report from Turnitin no any AI or ChatGPT or plagiarism the report included for no AI or plagiarism website just articles or book for each to question
Hello I am working in professional assignment you should do it as instruction below I attached book related to question
Instruction 1 ( reference)
You should use reference APA 7 edition all of reference( new 2023-2022 articles) you should have 7 reference with link of reference
Instruction grading related to (Depth- Resources- Organization- Mechanics- Formatting)
30% of overall grade
1-Content indicates synthesis of ideas, in depth analysis, and evidence of original thought and support for the topic.
2- Resources
25% of overall grade
All evidence supports arguments and is relevant to the topic. The student uses the required number and type of resources identified in the syllabus to support his/her argument.
3- Organization
15% of overall grade
Paper has a high degree of attention to logic and reasoning of points. Paper clearly leads the reader to the conclusion and stirs thought regarding the topic.
4- Mechanics
15% of overall grade
Few errors in spelling, punctuation, capitalization, sentence structure, and grammar.
5- Formatting
15% of overall grade
Paper meets all formatting guidelines and assignment requirements, including page-length and APA formatting requirements. Paper is correctly assembled with a professional look.
instruction 3 ( no plagiarism )
no any answer should be from any answer from website like ( study pool or course hero)or any other website or artificial intelligence should be from articles this home work submit to check Turnitin and AI contact detector ( AI Text Classifier) found any thing get zero grade

instruction 4 ( reference with link)
provide me in the file included the reference for all articles the use it answer the question and put behind each link the number of pages of this article the used in answer this question

The question

Organizations use computers and information systems to reduce costs and gain a competitive advantage in the marketplace. While workers have telecommuted for many years, this practice exploded during the COVID19 pandemic as academic institutions and organizations went 100% online. This drastic shift forced learners from kindergarten to graduate school to shift to an entirely different pedagogy. This was also the same for the workforce as many workers shifted from their cubicles/offices to their living rooms and dens.

Research a particular industry (academic or corporate) and explain how they converted to telecommuting from an IT perspective.
What are some of the issues they encountered in regard to remote access, security, database access, and other daily IT functions that traditionally took place in an office setting?

Develop your response in a 2 to 4 page APA-formatted paper with at least 3 references.

What is the significance of establishing credibility in business communication?

The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
Use APA reference style.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Submissions without this cover page will NOT be accepted.
Learning Outcomes:
1.1: Recognize and memorize concepts of communication theory as they affect business organizations and the individuals in them.
1.2: Communicate better, knowing that good communicators make better managers, and that communication is a dynamic process basic to individuals and organizational life.
.
Assignment Structure:

Type
Marks
Assignment-1
Part-1
5
Part-2
5
Total
10

Part -I (5 Marks)
Case Study: Credibility for an Entry-Level Professional

Sara, Ali, and Asif were recently hired as audit assistants. This is the first full-time professional position for each of them. During the first few months of work, each of them experienced successes and failures.
Sara gained a reputation for finding out exactly what clients wanted. She asked the right questions and respectfully explained points of disagreement with them, and showed them she was genuinely interested in them. Several of his colleagues commented that clients trusted her to act appropriately on their behalf. Her supervisor was pleased that Sara always followed through on commitments and was positive .However, her performance was far from perfect. Her supervisor noticed that Sara sometimes made fairly basic mistakes in her audits and her colleagues would have to redo some of her work.
Ali has gained a reputation for completing audits more accurately than all other new audit assistants. His supervisor is worried, however, about his long-term success at the firm.
Ali tends to overpromise. Last week, he told his supervisor he’d finish an important project but instead worked on other tasks. Last month, he called in sick for a few days. On one of his sick days, his supervisor saw pictures of his at a party that he had posted to Instagram.
Asif is the top performer on audits among the new group of employees at the firm. He is precise and efficient. He can typically accomplish many tasks in about half the time of most other audit assistants. His supervisor is concerned, however, about his interpersonal skills. He tends to often criticize his colleagues for their mistakes and rarely offers appreciation for their help. He also seems to rub clients the wrong way and comes across as “antisocial” according to one valued client.
Read the case above and answer the following questions:
1.Which element of credibility does Sara lack? What would you recommend to her to improve her credibility? (1 Mark)
2.Which element of credibility does Ali lack? What would you recommend to him to improve his credibility? (1 Mark)
3.Which element of credibility does Asif lack? What would you recommend to him to improve her credibility? (1 Mark)
4.What is the significance of establishing credibility in business communication?
(2 Marks)

Part-II (5 Marks)
Assess a Recent Difficult Conversation
Select a difficult conversation that you have encountered in the workplace or at school. Based on this conversation, do the following:
1.Summarize the conversation in one paragraph. (1 Mark)
2.Evaluate your and others’ performance in terms of assuming the best in one another, staying calm, finding common ground, disagreeing diplomatically, avoiding exaggeration and either/or approaches, and sharing all stories (including a shared story). (2 Marks)
3.Describe three ways you would approach the conversation differently if you did it over again. (2 Marks)

Think of a topic about fintech and then follow this topic to complete the Abstract, Introduction, Literature Review, Method, and Results

You need to think of a topic about fintech and then follow this topic to complete the Abstract, Introduction, Literature Review, Method, and Results
Provided some literature and data I collected previous
The methods and results section can be summarized using the data I collected
paper will follow the framework below:
Abstract: up to 250 words
Introduction: background information, purpose of your study, and claims for significance
Literature Review: summary of relevant literature and your hypotheses
Method: data, analytic framework, and statistical analysis
Results: analysis output and interpretation
Discussion: findings in relation to previous literature and business/policy implications
Conclusion: brief summary, study limitations, and direction for the future study
References: in APA style
Submit the draft in a Word file.

Overview
You are a business analyst for an organization that distributes pizza i

Overview
You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which U.S. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers’ restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes.
You must analyze this data to help inform marketing decisions. To begin, you must analyze and visualize the given data. You will use Power BI to complete these tasks and understand the relationships and patterns within the data set.
In Module One, you identified some stakeholder requirements and performed data wrangling to clean, transform, and merge the two data sets. In this assignment, you will begin your data analysis by employing visualization techniques on the given data. The resulting visual representations of the data will illustrate the trends and patterns within the data and help organizations forecast and plan better.
Prompt
Create a report that presents the data using visualization techniques best suited for the types of data included in your data set. Include the relevant screenshots of your data visualizations in the report.
Specifically, you must address the following rubric criteria:
Visualize and Identify Outliers: Visualize and identify any outliers in the data set using an appropriate graph.If appropriate, identify the twenty-fifth and seventy-fifth percentiles and the median.
Investigate any cases that show up as outliers and validate that the outliers are not mistakes in the data; make a note of them and describe what influence they may have on the analysis.
Data Visualization: Use appropriate visualization techniques to generate graphs for using various variables (column attributes). Describe the trends and patterns these graphs depict about the data.Generate a graph to visualize the trend in the number of orders placed in a day.
Generate a graph to visualize the trend in the number of orders placed according to the order time.
Generate graphs to show the number of orders placed according to times of day, restaurant categories, cities, zip codes, and states.
Generate graphs that show the times during which there are more and fewer orders.
Generate graphs that show the amount spent on pizza.
Rationale: Justify your choice of visualization technique for each of the above graphs.Are there any additional variables that you think will help uncover more patterns and trends in the data set? Explain.Which visualization techniques will you choose for these variables?
What to Submit
Submit a 4- to 5-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins.

Overview
You are a business analyst for an organization that distributes pizza i

Overview
You are a business analyst for an organization that distributes pizza ingredients to various restaurants. These ingredients include dough, sauces, and toppings. Your organization wants to expand its customer base but does not know what kind of restaurant or which U.S. region to target. You have been given a Clean Customer Sales Data Set that is a representative sample of the sales at your customers’ restaurants for 2015 and 2016. This also contains household income data for the restaurant zip codes.
You must analyze this data to help inform marketing decisions. To begin your analysis, you must be able to answer your stakeholders’ questions through your analysis and visualizations of the given data. You will use MS Excel to complete these tasks.
In Module One, you identified some stakeholder requirements and performed data wrangling to clean, transform, and merge the two data sets. In this assignment, you will use the cleaned customer sales data to begin your analysis by performing statistical tests to further identify the trends and patterns in the given data. These tests will produce accurate results that will help organizations forecast and plan better and test theories and strategies.
Prompt
Analyze the given data and create a report summarizing the trends and patterns in the data set. You may refer to the Trends and Patterns Report Process Document for this activity. You must include the relevant screenshots in your report.
Specifically, you must address the following rubric criteria:
Statistical Techniques and Tests: Conduct exploratory data analysis, generate histograms, perform requisite diagnostics, and apply statistical tests.Generate frequency tables and histograms for the variables (column attributes).
Calculate the chi-square statistic (x2).
Determine the correlations between the variables.
Perform t-tests.
Trends and Patterns: Select and apply appropriate statistical tests to answer the following questions about the trends and patterns in the data:Which categories of restaurants represent the largest and smallest share of the overall total? Are they concentrated in any U.S. state?
Does the data indicate a particular day of the week or month of the year that sees more (or fewer) orders?
Which zip codes appear to be more or less likely to be profitable?
Rationale: Justify your choice of statistical tests for each of the above analyses.How are the different statistical techniques appropriate for the different types of data contained in this data set?
What to Submit
Submit a 3- to 4-page Word document using double spacing, 12-point Times New Roman font, and one-inch margins.

You are given a dataset named “Social_Network_Ads.csv” containing information about individuals’ ages, estimated salaries, and whether they made a purchase (0: No, 1: Yes).Your task is to perform a classification analysis using one of the following algorithms

You are given a dataset named “Social_Network_Ads.csv” containing information about individuals’ ages, estimated salaries, and whether they made a purchase (0: No, 1: Yes). Your task is to perform a classification analysis using one of the following algorithms: K-Nearest Neighbors (KNN), Logistic Regression, or Support Vector Machine (SVM). Submit a report that includes the following information:
1. A brief description of the problem and the dataset.
2. Describe your selected classification method (KNN, Logistic Regression, or SVM) and its underlying concepts.
3. Data preparation steps.
4. Explain your training approach and parameter selections.
5. Present your model evaluation results using relevant metrics (e.g., accuracy, precision, recall, F1-score).
6. Discuss the findings of the study and any results regarding the model’s performance.
7. Create visualizations to illustrate your chosen algorithm’s performance.
8. Conclude by summarising your finding and the general lesson from the assignment.
Submission guidelines:
The main submission document, containing your analysis, figures, interpretations, and conclusions, must be in Microsoft Word format( .docx).
Please use a clear and concise naming convention for your files, including your name and the assignment number (e.g., “YourName_Assignment2.docx”).
Ensure that key results are presented clearly in the Word document.
If calculations were performed using Excel, Tableau, or Python, submit the respective files as supplementary materials alongside the Word document.

The topic is:
Single Table Queries and Search Conditions:
Use the Northwoods DB;

The topic is:
Single Table Queries and Search Conditions:
Use the Northwoods DB; do NOT change the database in any way. Only provide the queries for this HW (do NOT include the Northwoods script!). Provide a single .sql file for the HW (queries only).
The instructions on the HW assignment is attached in a Word document calls “SingleTableHW”
in order to do the homework you need the Northwoods data, so attached is the SQL code for it calls “script to create NORTHWOODS database.”. and also there is for you to make it easier the file “NorthwoodsERD (in Word).docx”
Some basic Information about how the professor wants the Queries in general
We start with simple queries using only one table (so no joins). We also introduce one of the key proficiencies required for queries, which are search conditions. We rarely want to do a query that returns ALL rows. Instead, we only want to see certain rows returned. We might want to see not all customers, just the ones that live in Conway. We might want to see employees who make over $50,000 a year, not all employees. To restrict the rows that are returned in a query, we use search conditions. These provide the limitations for our query. Search conditions require operators, and there are only a few of them (but we must know and learn them all!):
Comparison operators–there are six: = > >= < <= <>
BETWEEN ____ AND ____ (or NOT BETWEEN ____ AND ____)
IN (xx, yy) (or NOT IN (xx, yy))
IS NULL (or IS NOT NULL)
LIKE
We use these operators to limit which rows we wish to include in a query. We introduce them in this first class, but will use them for all queries. Most are fairly simple–but pay attention to the hardest one–using LIKE. Read it carefully, because it is easy to misuse.
In this class we cover the following:
Single-table queries
Search conditions (detailed above)
Sorting output
Formatting output (alternate column headings)
TO_CHAR function
Northwoods DB:
You will need to run the script (Northwoods.sql) in Oracle. It will work, so long as you do not already have tables with the same name as these (such as student, faculty, course, etc.). If you do, DROP YOUR OLD TABLES!! You should do that anyway, to declutter your schema. You may NOT change this script in any way. All query HWs will be done using this DB.
When we get to joins (which comprise almost all our queries), you will need the ERD to see how tables are joined. The ERD is a little different–I took out the relationship names (thinking they were obvious) and instead put in the field that relates the the two tables (the PK and FK–which have the same name in this DB). You will need the ERD throughout, so keep it handy.