Tableau
Tableau is a data visualization tool created by Tableau Software. Data visualization is the process of visually showing information. People have a tendency to gain insights from data quicker using visuals vs. poring through huge amounts of data.
Obectives:
- What is Tableau? What are the Tableau versions?
- What are the Tableau products and what is use of each product?
- Installing the Tableau desktop 9.2and explore the new features of Tableau 9.2
- Exploredifferent data sources in Tableau
- Connecting to sample store excel file and verify the different options
- Switching Live connection to Extract and Extract to Live
- Know about Tableau shelves
- Tableau workbook (Twb)Vs. Tableau packaged workbook(Twbx)
Connecting to MS SQL Server&Data blending
Tableau 9.2 (Desktop, Server / Online, Public, Reader, Vizable & Mobile)
Job
Data Management
Topic
Introduction& Basics
- 1. What is Tableau? What are the Tableau versions?
- 2. What are the Tableau products and what is use of each product?
- 3. Installing the Tableau desktop 9.2and explore the new features of Tableau 9.2
- 1. DatSource screen additional features (Table/Field sorting, Calculated Field)
- 2. Frame finder for multiple tables in same excel sheet
- 3.Map Box Integration
- 4. Row/Column grand total position change
- 5.Match label colors to graph colors
- 6.Tableau server project permissions lock
- 7.IPhone App released
- 4. Exploredifferent data sources in Tableau
- 5. Connecting to sample store excel file and verify the different options
- 1.Joins
- 2.filters
- 3. Live vs. Extract –file save as .TDE
- 4.Table / Field sorting
- 5.Rename, hide, Aliases
- 6. Metadata
- 7. Color symbols
- 8.Data typechange
- 9. Describe
- 10. Data Interpreter (Sheet Cleanse& Frame Finder Applies to Excel)
- 11. Pivot/Un-Pivot
- 12. Split/Custom Split
- 13. Creating Calculated field)
- 6. Switching Live connection to Extract and Extract to Live
- 7. Know about Tableau shelves
- 1.Start page button
- 2.Data Dimensions& Measures
- 3.Analytics
- 4.Rows/Columns
- 5.Show Me Control
- 6.Filters
- 7.MarksColor, Size, Text/Label, Tooltip, Detail and Shape shelves
- 8.Pages
- 8. Tableau workbook (Twb)Vs. Tableau packaged workbook(Twbx)
Connecting to MS SQL Server&Data blending - 9. Connect to SQL server database and write the custom SQL query to prepare data
- 10. What is data blending and what are the basic requirements to do data blending
Visualization
Topic
- 11. Creating Hierarchies, add members to hierarchies and removing hierarchies
- 12. What is grouping? How to create a group in the report. How to consume it?
- 13. Creating Sets with different options and how to use sets in the report.
- 14. What is bin/ histogram and create a report with bin/ histogram
- 15. Create Cross Tab report and apply the swapping option. How to display the row/column grand totalsand how to
change the positions How to show the numerical result into percentage format in cross tab report - 16. Formatting the report by changing the colour, style, size.
- 17. Adding annotations to the report to define the measure at particular point
- 18. How to create folder and add the members to the folder, ex: Sales, finance and HR
- 19. How to create trend line, forecast,bar, pie, tree map,Bubble & word cloud& Scatter-plot with custom
images including drop lines options. - 20. How to create Dual axis, Blended axis and Dual map reports
- 21. What is Geocoding? How to work with Geocoding in Tableau.
- 22. How to create Map box map style and how to integrateit intoTableau map report
- 23. How to create KPI report including parameters
- 24. How to create a reference line with Analytics panel
- 25. What is dashboard and how to create dashboard in Tableau.
- 26. What is story point and how to create story point sheets
- 27. How to publish the Data source, tableau workbooks to Tableau Server?
- 28. What is action and how many types of actions in Tableau. How to create actions.
- 29. What is user filter and how to apply user/group row level security to the data.
Calculations
Topic
- 30. String level functions: Left, right, lower, upper, ltrim, rtrim, trim, len, replace
- 31. Date functions: Date, date time, isdate
- 32. Numeric functions: int, float
- 33. Programing functions: iif, case
- 34. Aggregate functions: sum, min, max, avg, count, countd
- 35. User functions: fullname, isfullname, username, isusername, ismemberof
Tableau Server/Tableau Online
Topic
- 36. Installing the Tableau server and configuring Tableau server
- 37. Log-on to Tableau Server 9.2 and Understand the user interface
- 38. What is data refresh and how to make the data refresh in schedule manner
- 39. What is bookmark and how to apply? How to verify the bookmark in the next visit.
- 40. What is web-authoring and how to edit the reports/dashboard in on-line
- 41. How to assign the permissions at different levels by users/groups
- 42. What is subscription and how to create new subscription and edit the subscriptions
- 43. How to share the report and how to embed the report in other applications code.
- 44. What is Tag and how to create tags? How to search the reports based on tags
Tableau PublicTableau ReaderTableau Mobile Tableau Vizable
Tableau 10 (Upcoming) Features
Topic
- 45. How to save the worksheets and Dashboards to Tableau public server from Public
- 46. What is Tableau Reader and what are the benefits and limitations.
- 47. Verifying the Tableau dashboards through Android Tablet / I Pad
- 48. What is Vizable& use of Vizable?Diff. between normal mobile app Vs. Vizable
- 49. Tableau 10 (Next expected versionfeatures)
- 1. Union files (merge data)
- 2.Charts in Tooltip
- 3. Locate Meoption in Map
- 4. Version control on server (versioning)
- 5.Tableau server Manager site
- 6. Dashboards creating in Web Authoring
- 7.Mobile Editing
Help
- 50. Help Links
- i. Tableau books in PDFhttp://www.tableau.com/support/help
- ii. Tableau software (latest & Old)https://www.tableau.com/esdalt
- iii. 1-year student License for Desktop http://www.tableau.com/academic/students
- iv. Tableau drivershttp://www.tableau.com/support/drivers
- v. Tableau Mobile apps
- vi. Ipad https://itunes.apple.com/us/app/tableau-mobile/id434633927?mt=8
Andoid https://play.google.com/store/apps/details?id=com.Tableau.TableauApp
Vizable http://vizable.tableau.com/ - vii. Tableau 9.1 Vs Tableau 9.2 features
- viii. Tableau 10 Expected Features http://tableauanalytics.blogspot.in/
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Tableau Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.
-
What is Tableau Training?
Tableau online and classroom courses talk about the Tableau fundamentals through theoretical instructions and extensive hands-on exercises to help students attain practical knowledge and experience in Tableau skills. It is designed for the beginners and intermediate Tableau users. Anyone with technical or analytical background and working with data can attend the classes by the best training institutes. You’ll not only understand the basic parameters and various options for connecting data but also learn how to build interactive dashboards as well as publish and share workbooks. By the end of this excellent Tableau training & placement course you will know how to build and format visualizations. The tableau training course comes with 100% placement and visa assistance. All the classes are designed by the expert faculty with excellent hands-on experience of working on live Tableau projects. Intensive online and classroom courses are available to prepare students for Tableau Desktop Certification. You don’t have to look beyond these best-in-class Tableau training institutes which have robust infrastructure, round the clock technical support and industry relevant Tableau course curriculum. What are you waiting for enroll now for the best Tableau training.
-
Course outline
• Introduction to Tableau
• Filters/Parameters
• Graphs/Map
• Table Calculation
• Aggregating data
• Dashboards
• Data Blending
• Building Tableau Project – Complex Dashboard
• Tableau Assignment
• Tableau Desktop Certification Preparation -
Pre-requisites
Students should have basic knowledge of data to help them grasp the instructions quickly.