A data analyst can extract insights and information from data sets. As a data analyst, you can do many different specialized tasks, including analyzing data and
reporting on the findings. Those reported findings can help a business make data-informed decisions.
In this assignment, you will demonstrate your mastery of the following course outcomes:
● Utilize appropriate tools and techniques for creating business intelligence reports.
● Apply business intelligence techniques and practices for making data-centered decisions within a business setting.
● Recommend appropriate solutions to business problems that address business needs and requirements.
● Create data visualizations utilizing appropriate tools and techniques for producing business reports.
ABC Company is in competition with many companies that provide the same products and services. A personal touch and strong customer service are standards
being set by ABC Company, and this is shaking up the market. To keep up with consumer expectations and initiate new customers from different areas,
expansion must take place. For this expansion, the company needs to answer several business questions. Utilizing business intelligence techniques, a business
can utilize data to create reports and provide insight into those business questions.
For this project, you will play the role of a data analyst at a consulting company that you own. You will be working directly for the CEO in your investigation of
the expansion of this business. You will be asked to evaluate one of seven data sets related to what the company has done up to this point, and you will provide
those insights back to the company. For each of these data-set areas, you will be asked to use Microsoft Power Business Intelligence (BI) tools to build a stunning
visualization of the data and a written report of the insights that were found in the analysis.
Using the IBM Watson Analytics data, choose ONE of the seven data sets and explore the data for interesting insights, and create dashboards using the Microsoft
Power BI tool.
Create only the deliverables associated with your chosen data set. Click on the title of the data set to view the data in Excel:
Data and Deliverables
1 IT Help Desk
The ABC Company’s CEO is interested in examining how quickly issues are resolved and improving customer satisfaction. Analyze the help-desk tickets,
including number of tickets, number of high priority tickets, and average response time. Understand the causes of high-priority tickets, and improve
resolution times with better understanding of ticket details.
The following information in this cell is from the IBM Watson Analytics website:
Background: This data is from an Information Technology (IT) department interested in examining how quickly issues are resolved and improving
satisfaction of customers. To start their analysis, they have this data set of 100,000 closed tickets that were filed at their help desk.
About the data: A total of 100,000 rows. Each row in the data includes:
employee who submitted the ticket
employee’s seniority within the company
IT employee who serviced the ticket
functional area against which the ticket was filed (systems, software, hardware, access)
whether the ticket was a request for new services or an issue with existing services
submitter-assigned severity of the ticket
IT-assigned priority of the ticket
number of days the ticket was open
satisfaction with the resolution of the ticket (reported by the submitter)
2 Employee Attrition
ABC Company’s CEO is curious to find the factors that lead to employee attrition. This will be very important as the CEO moves forward with the
expansion of the company. The stakeholders are interested in this analysis, which will provide some insights into leadership effectiveness. The analysis
should take some key point indicators (Distance, Education, Job Role, Income) and provide an analysis.
3 Telco Customer Churn
ABC Company’s CEO is concerned that, during this expansion, customers may leave the company for its competitors. Predict the behavior of customers
and how to retain them. Analyze all relevant customer data and develop focused customer retention programs.
The data set includes information about:
Customers who left within the last month—this column is called Churn.
Services that each customer has signed up for—phone, multiple lines, internet, online security, online backup, device protection, tech support,
and streaming for TV and movies.
Customer account information—how long they have been a customer, contract, payment method, paperless billing, monthly charges, and total
Demographic info about customers—gender, age range, and whether they have partners or dependents.
4 Accounts Receivable
In the past, ABC Company’s CEO had set up business accounts where the business could carry a balance with purchases (goods or services) that were
made. Due to the expansion, the stakeholders are concerned that the balances will not be paid. The CEO would like to understand the factors of
successful collection efforts. Predict which customers will pay fastest, recover more money, and improve collection efficiency.
5 Operations Dem Planning Bike Share
During this expansion investigation, ABC Company’s CEO would still like to manage the process of matching supply and demand. Explore information
based on usage and external factors to understand the effects of a bike-share program in a major U.S. city to analyze patterns such as the relationship
between humidity and ridership by month, or how temperature and holidays drive usage demand.
6 Retail Sales and Marketing, Profit and Cost
During the expansion process, ABC Company’s CEO realizes that there will need to be a review of the product-related information, such as Cost, Revenue,
and Price, across Years and Ordering Method. This will be especially important to the stakeholders, as they will see what has worked and what has not.
This data set could be used to create a multiple-tab dashboard in Microsoft Power BI. For this data set, you will be an analyst for one of the stakeholders
and find insights in Sales and Marketing, and Profit and Cost. The data is clean and manageable.
7 Marketing Campaign
ABC Company’s CEO is looking to add new items to the menu in the fast food department. The CEO needs help determining the promotion campaign for
the new products. Quickly analyze test market campaigns based on responses, revenue, and other key metrics. Predict who will respond to which
campaign by which channel, and why. Increase the likelihood of responses and the quality of leads in future campaigns. A different promotion is used at
each location, and the weekly sales of the new item are recorded for the first four weeks.
Unique identifier for market (1–10).
Size of market area by sales (Small, Medium, Large).
Unique identifier for store location.
Age Of Store
Age of store in years (1–28).
One of three promotions that was tested (1, 2, 3).
One of four weeks when the promotions were run (1–4).
Sales In Thousands
Sales amount for a specific LocationID, Promotion, and week.
Specifically, the following critical elements must be addressed:
I. Report for Stakeholders: You will write an enterprise-level report about your project. While this critical element is listed first, you will complete it last.
A. Generate an enterprise-level report that will be submitted along with your executive summary. This report should address all the critical
B. Compose an executive summary that explains what your process was to create the report, as well as why you performed the actions you did.
Within your summary, provide a detailed description of the report that explains the visualizations used in audience-appropriate language. You
will also need to anticipate questions stakeholders may ask, so be sure that your explanation is as detailed as possible but also uses audienceappropriate language.
II. Identify the Business Question: Select a data set and scenario from the provided list and explain how you would solve the business question. Identify
what sort of data you would require in order to solve the question.
III. Making Sense of Data: In this section, you will analyze the data within the spreadsheet in order to understand what information it will provide and its
relation to the business question.
A. Analyze the provided data set and explain what the data is and how the data correlates back to the business question you intend to answer.
B. Identify which areas of data from the spreadsheet you will utilize and why. For example, which columns would you use?
IV. Business Intelligence: In this section, you will explain how Power BI can be used to address business problems.
A. Explain how you plan to address the organization’s business problem using the Power BI analysis tool.
B. Explain how the Power BI analysis tool can influence and affect the audience, such as the stakeholders and coworkers in different areas of the
company. For example, how can the tool be used to convey information?
V. Software Integration: For this section, you will upload your data into Power BI and ensure it has appropriate formatting.
A. Upload into Power BI the selected data set, using the correct data type and fields.
B. Ensure your columns have appropriate formatting by editing your data. For example, ensure that you have formatted your columns with
monetary values as currency.
VI. Guiding Questions: Data relationships are necessary for linking common data or records in tables together to analyze the data and generate meaningful
reports. In this section, you will look at your initial analysis from section III and develop business questions (and answers) that will serve as the focus of
A. Develop business questions based on your initial analysis that will effectively guide your visualizations.
B. Explain how you will use the compiled and cleaned data to effectively answer the business questions posed based on your initial analysis.
VII. Visualizations: In this section, you will choose appropriate visualizations to display your data.
A. Describe how you chose which particular visualization is best suited for displaying the data.
B. Describe how you know the visualization used is best suited for conveying information to the targeted user audience and their interaction needs
across multifunctional teams.
C. Generate visualizations to accurately display your data.
D. Create visual data correlations by integrating additional data into your visualizations.
E. Insert data visualizations into your report and explain what the visualizations represent. Confirm that all of the data that you want displayed is
VIII. Actionable Insights: Identify actionable insights based on your analysis.
Compelling correspondence is essential to the achievement all things considered but since of the changing idea of the present working environments, successful correspondence turns out to be more troublesome, and because of the numerous impediments that will permit beneficiaries to acknowledge the plan of the sender It is restricted. Misguided judgments.In spite of the fact that correspondence inside the association is rarely completely open, numerous straightforward arrangements can be executed to advance the effect of these hindrances.
Concerning specific contextual analysis, two significant correspondence standards, correspondence channel determination and commotion are self-evident. This course presents the standards of correspondence, the act of general correspondence, and different speculations to all the more likely comprehend the correspondence exchanges experienced in regular daily existence. The standards and practices that you learn in this course give the premise to additionally learning and correspondence.
This course starts with an outline of the correspondence cycle, the method of reasoning and hypothesis. In resulting modules of the course, we will look at explicit use of relational connections in close to home and expert life. These incorporate relational correspondence, bunch correspondence and dynamic, authoritative correspondence in the work environment or relational correspondence. Rule of Business Communication In request to make correspondence viable, it is important to follow a few rules and standards. Seven of them are fundamental and applicable, and these are clear, finished, brief, obliging, right, thought to be, concrete. These standards are frequently called 7C for business correspondence. The subtleties of these correspondence standards are examined underneath: Politeness Principle: When conveying, we should build up a cordial relationship with every individual who sends data to us.
To be inviting and polite is indistinguishable, and politeness requires an insightful and amicable activity against others. Axioms are notable that gracious “pay of graciousness is the main thing to win everything”. Correspondence staff ought to consistently remember this. The accompanying standards may assist with improving courtesy:Preliminary considering correspondence with family All glad families have the mystery of progress. This achievement originates from a strong establishment of closeness and closeness. Indeed, through private correspondence these cozy family connections become all the more intently. Correspondence is the foundation of different affiliations, building solid partners of obedient devotion, improving family way of life, and assisting with accomplishing satisfaction (Gosche, p. 1). In any case, so as to keep up an amicable relationship, a few families experienced tumultuous encounters. Correspondence in the family is an intricate and alluring marvel. Correspondence between families isn’t restricted to single messages between families or verbal correspondence.
It is a unique cycle that oversees force, closeness and limits, cohesiveness and flexibility of route frameworks, and makes pictures, topics, stories, ceremonies, rules, jobs, making implications, making a feeling of family life An intelligent cycle that makes a model. This model has passed ages. Notwithstanding the view as a family and family automatic framework, one of the greatest exploration establishments in between family correspondence centers around a family correspondence model. Family correspondence model (FCP) hypothesis clarifies why families impart in their own specific manner dependent on one another ‘s psychological direction. Early FCP research established in media research is keen on how families handle broad communications data. Family correspondence was perceived as an exceptional scholastic exploration field by the National Communications Association in 1989. Family correspondence researchers were at first impacted by family research, social brain science, and relational hypothesis, before long built up the hypothesis and began research in a family framework zeroed in on a significant job. Until 2001, the primary issue of the Family Communication Research Journal, Family Communication Magazine, was given. Family correspondence is more than the field of correspondence analysts in the family. Examination on family correspondence is normally done by individuals in brain science, humanism, and family research, to give some examples models. However, as the popular family correspondence researcher Leslie Baxter stated, it is the focal point of this intelligent semantic creation measure making the grant of family correspondence special. In the field of in-home correspondence, correspondence is normally not founded on autonomous messages from one sender to one beneficiary, yet dependent on the dynamic interdependency of data shared among families It is conceptualized. The focal point of this methodology is on the shared trait of semantic development inside family frameworks. As such, producing doesn’t happen in vacuum, however it happens in a wide scope of ages and social exchange.
Standards are rules end up being followed when performing work to agree to a given objective. Hierarchical achievement relies significantly upon compelling correspondence. So as to successfully impart, it is important to follow a few standards and rules. Coming up next are rules to guarantee powerful correspondence: clearness: lucidity of data is a significant guideline of correspondence. For beneficiaries to know the message plainly, the messages ought to be sorted out in a basic language. To guarantee that beneficiaries can without much of a stretch comprehend the importance of the message, the sender needs to impart unmistakably and unhesitatingly so the beneficiary can plainly and unquestionably comprehend the data.>