Tableau 1
We will practice loading data into Tableau, inspecting and modifying data types, and creating tabular views with metrics based on the information contained in the data set. We will be working with the given dataset. liquor_store_sales.xlsxDownload liquor_store_sales.xlsx
If you get stuck on any of the tasks in this lab, you can reference the excellent training video resources provided on the Tableau websiteLinks to an external site..
To complete this task, follow each of the steps below.
- Open the data setLinks to an external site. in a browser.
- Add the data set to your Google Drive.
- Launch the Tableau Public application.
- Import the data set from Google Sheets into Tableau.
- Create a new calculated field called Year_Month as a date based on Year, Month and 1st of the month.
- Use MAKEDATE functions for that
- Move to your first sheet
- Drag your newly created Year_Month calculated field to rows and click the [+] on the pill in rows so you see both the year and quarter.
- Create a new worksheet for each of the following tabular views:
- Total Retail Sales by Year/Quarter (rows).
- Average Retail Sales by Year/Quarter (rows).
- Total Retail Sales by Year/Month (rows) and Item Type (columns).
- Average Retail Sales by Year/Month (rows) and Item Type (columns).
- Total Retail Transfers by Year/Quarter (rows).
- Average Retail Transfers by Year/Quarter (rows).
- Total Retail Transfers by Year/Month (rows) and Item Type (columns).
- Average Retail Transfers by Year/Month (rows) and Item Type (columns).
- Total Warehouse Sales by Year/Quarter (rows).
- Average Warehouse Sales by Year/Quarter (rows).
- Total Warehouse Sales by Year/Month (rows) and Item Type (columns).
- Average Warehouse Sales by Year/Month (rows) and Item Type (columns).
- Create a dashboard and bring all the sheets into the dashboard.
- Save your work to Tableau Public
-
2 days23 USD
244 2 days23 USD
Good day! I have experience working with Tableau (I can send examples of my work) and I will gladly take on your task.
-
3 days27 USD
278 2 0 3 days27 USD
Good day!
I will be happy to help you with this project. The task is clear, I can perform it with quality: I have experience working with SQL, I am well familiar with Tableau.
I work carefully and responsibly, always in touch.
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 ∙ 17 hours 50 seconds 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 ∙ 18 hours 52 minutes back ∙ 32 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 ∙ 19 hours 58 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 11 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 16 hours back ∙ 35 proposals |
Ukraine