Tableau 3
29 USD
We will practice more in Business Intelligence in Tableau
- Download the dataset (sample superstore): https://docs.google.com/spreadsheets/u/2/d/1kZSK4C3DtEoGgET5CvC1vPV4_6ZvL-Us/edit?usp=drive_web&ouid=112062879437723105570&rtpof=trueLinks to an external site.
- Connect the data in Tableau
- Answer the following questions using only Tableau.
- Save each answer as a widget.
Questions:
- What is the percent of total Sales for the ‘Home Office’ Customer Segment in July of 2012?
a. 23.50%
b. 23.97%
c. 20.14%
d. 32.56%
2. Find the top 10 Product Names by Sales within each region. Which product is ranked #2 in both the Central & West regions in 2011?
a. Riverside Palais Royal Lawyers Bookcase
b. Bush Mission Pointe Library
c. Sharp AL-1530CS Digital Copier
d. Global Troy Executive Leather Low Back Tilter
3. In the Technology Product Category, which unprofitable state is surrounded by only profitable states?
a. Colorado
b. Missouri
c. Wyoming
d. Utah
4. If 2013 Sales numbers were expected to increase by 50% in the following year, what would be the total estimated sales for the Consumer Segment in 2014?
a. $4,278,540
b. $816,999
c. $2,752,823
d. $802,365
5. In which Region do all Product Categories fall beneath the overall average profit?
a. All Regions
b. Central
c. East
d. South
e. West
6. Which Product Sub-Category has a Shipping Cost to Sales ratio of above 3%?
a. Tables
b. Chairs & Chairmats
c. Paper
d. Binders and Binder Accessories
https://youtu.be/3jBAWc2v8X4Links to an external site.
7. Find the customer with the lowest overall profit. What is his/her profit ratio?
a. 2.35%
b. 1%
c. -17.54%
d. -771.39%
https://youtu.be/2VSI0TLeWnILinks to an external site.
8. Determine which State in the Central Region has the highest distribution of profits using interquartile ranges.
a. South Dakota
b. North Dakota
c. Minnesota
d. Iowa
https://youtu.be/HmyMCwsac7ALinks to an external site.
9. Look at the sum of profits for each Product Sub-Category. Which sub-category is $31,069 below the average profit across all categories?
a. Appliances
b. Bookcases
c. Envelopes
d. Paper
https://www.youtube.com/watch?v=yfPW_3fq5D0Links to an external site.
10. What percent of total profits do the top 10 customer by Sales represent?
a. 3.50%
b. 5.03%
c. 17.54%
d. None of the Above
https://youtu.be/sFmJ-fARnXILinks to an external site.
- What was the Moving Average of Sales in June of 2012, including six months prior and six months after?
a. $101,752
b. $180,036
c. $188,552
d. $286,170
https://youtu.be/9csIsqkQqKsLinks to an external site.
- Create a histogram showing the number of Sales using Sales Bins of $1,000. Which bins have profit ratios (profit as a percentage of sales) of more than 25%? (Select all that apply)
a. 1,000
b. 3,000
c. 7,000
d. 8,000
e. 10,000
f. 11,000
g. 18,000
https://youtu.be/7XBTN2AR9kkLinks to an external site.
Client's review of cooperation with Nazar Zadniprianyi
Tableau 3Thank you very much, very good and quick work done
Freelancer's review of cooperation with Sofiia Bogdan
Tableau 3Maximum comfortable cooperation. I recommend
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 11 hours 29 minutes back ∙ 3 proposals |
Excel Specialist / Process Automation (Excel + preferably programming)We are looking for a specialist with ADVANCED knowledge of Excel to optimize the existing file and automate processes. It will be a great advantage if you also have programming skills / VBA / Power Query / Power Automate or experience in creating complex logic in Excel. Project… Python, Databases & SQL ∙ 13 hours 20 minutes back ∙ 31 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 14 hours 26 minutes back ∙ 16 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 2 days 5 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 3 days 10 hours back ∙ 35 proposals |
Ukraine