Track Room Location: Heritage Hall, room 131

This track is now closed, but you may join the wait list and be notified if space opens up. Until that time, you will be enrolled in your alternate choice.

Description
Big Data Analytics and Data Visualization Dashboards are becoming a norm in business and educational institutions today. Data visualization allows the organization to interact with data to identify trends and insights. As we generate more data, understanding and presenting data in a meaningful way is becoming a skill set in much demand.

This workshop is an introductory session to the world of Data Visualization Dashboards and Big Data Analytics. Tableau is a leading data visualization and analytics tools in the market today. In this workshop we will understand the basics of Big Data and how businesses and educational institutions are creating a culture of data-driven decision-making. Participants will be introduced to the core features of Tableau software including Data Preparation with Tableau Prep. Hands-on labs using these two tools will allow the participants to have a first-hand knowledge of how to utilize the software to gain business insights and trends. Participants will be able to demonstrate how to take different data sets and convert into a meaningful visual format for better understanding and decision making. Hand-outs outlining the labs and data sets will be distributed so that participants can incorporate as a lab activity in their curriculum. We will explore educational data sets to understand how your students are doing in classes. Does your department know how many courses/sections are being canceled every semester? Why? How long does it take for our students to graduate? Also participants are free to bring their own data sets to create meaningful insights for their institutions.

Topics:

• Introduction to Big Data and Analytics
• Introduction to Data Visualization
• Installing and Setup – Tableau Prep and Tableau Desktop
• Data Cleansing and Preparing Data Sets Using Both Excel and Tableau Prep
• Understand Tableau Tool Sets
• Creating Basic Visualization from Data Sets
• Create Dashboards Tableau
• Analyze Trends from Dashboards
• Create Dashboards from Participants Data Sets

Textbook
There is no textbook requirement.

Things to Bring:

• Open Mind…..to Learn New Things
• USB Drive to save your work – (Campus lab may refresh the computers at night and we may lose the saved file on the lab computer). Some data files might be large – so have some back-up drives or cloud-based storage.
• Headphones – during the lab sessions there are online videos that you may access to reinforce learning. Headphones/ear plugs will not disturb your fellow participant – if you are watching it.

Prerequisites
Basic Excel knowledge is helpful. Open mind and eagerness to learn

Instructors

Rajiv Malkan, Ph.D. is a Professor in the Computer and Information Technology Department of

Lone Star College - Montgomery where he teaches a variety of courses including Business Computer Applications, Programming Languages and Business/Management.

Dr. Rajiv Malkan has over 30 years of leadership contributions in higher education within multiple settings. He has engaged in leadership roles including Founding Dean, Division Chair in transforming education. His involvement in driving key initiatives spans in education delivery, thought leadership, grant writing, global partnerships and engagements on emerging trends. He holds proven expertise in college accreditation & state compliance including Dual Credit/Pathways initiatives for academic & workforce programs.

His academic credentials include two Master’s degrees, a Doctorate in Higher Education

Leadership, and he has been the recipient of the prestigious Kellogg Fellowship in Leadership Development.

Dr. Malkan is active with various professional organizations and is continuing his drive in cyber security and incorporating data driven decision making in higher education organization by presenting at various conferences on data analytics, while executing on awarded grants and serving in community colleges and corporate education.

Track Objectives
At the completion of this track, the participants will be able to…
1. Install Tableau Prep and Tableau Desktop versions
2. Describe why data cleansing is important and critical for analytics
3. Apply using colors and visual aspects in creating dashboards
4. Prepare data sets and create dashboards for Analytics using Tableau
5. Analyze the trends to gain insights of the data sets

Tentative Daily Agenda:
Day 1 – Monday, July 8, 2019
Module 1: Course Introduction
Module 2: Software Installation
Module 3: Big Data and Analytics Concepts
Module 4: Data Cleansing (Tableau Prep)
Module 5: Data Quality
Labs 1, 2, 3

Day 2 - Tuesday, July 9, 2019
Module 6: Visualization Basics
Module 7: Tableau – Basic Concepts
Module 8: Tableau User Interface
Module 9: Tableau: Connecting to Data
Labs 4,5,6,7
Open Labs to explore your own data sets

Day 3 - Wednesday, July 10, 2019
Module 10: Tableau - Discrete and Continuous Concepts
Module 11: Tableau – Basic Charts
Module 12: Tableau – Using Maps
Labs 8,9,10,11
Open Labs to explore your own data sets

Day 4 – Thursday, July 11, 2019
Module 13: Tableau – Calculations to Enhance Data
Module 14: Tableau – Creating Dashboards
Module 15: Tableau – Creating Stories
Labs 12,13,14,15
Open Labs to explore your own data sets

Day 5 – Friday, July 12, 2019
Module 16: Tableau – Designing for Mobile
Labs 16
Open Labs to explore your own data sets
Note: Above is tentative agenda and subject to change a little.

Please note the schedule is subject to change or be modified based on the needs of the boot camp participants.