Course Objective: This course aim to enable student to Course Outcomes (COs): Course Course outcome (at course level) Learning and teaching strategies Assessment Strategies Paper Code Paper Title CLO 168. Select the data visualization methods to provide analysis of business problems like HR management and market trend. CLO 169.Create static charts, interactive dashboards and data stories and will analyze datasets visually using Tableau CLO 170.Detect and frame the stories within business datasets. CLO 171.Extract insights from that data using Tableau CLO 172.Apply best practices in data visualization methods and will identify the right chart type for the particular situation in Tableau. CLO 173.Demonstrate data-driven visual stories using Tableau. Approach in teaching: Interactive Lectures, Group Discussion, Tutorials, Case Study Learning activities for the students: Self-learning assignments, Tableau exercises ,presentations Class test, Semester end examinations, Quiz, Practical Assignments, Presentation MBB 424 Business Problem Solving, Tableau and story telling
Introduction to Data and Business Intelligence Why we visualize data, how to ask questions of data, communication and S.M.A.R.T., known your stakeholders, Listening to stakeholders during elicitation, Business Intelligence(BI) – Introduction, Significance & Tools, Analysis and type of analysis: descriptive, diagnostic, predictive and prescriptive. Structure pyramid analysis plan (SPAP), what makes a good, rich dataset for analysis and visualization, how to find datasets on Open Data portals.
Tableau and Basic Data Analysis in Tableau
Introduction to Tableau, Evaluation of Tableau, Tableau Architecture and Installation of Tableau. Data analysis and data communication with Tableau. Tableau public and desktop. Knowing Your Data, importing data, the “Data Visualization Process”, table view, Dashboard, Tableau Basics: Dimensions, Measures, Tableau Workspace, cards and shelves, marks card, formatting how to analyze structured data using Tableau, exporting data
Creating Static Charts in Tableau How to create simple static charts in Tableau , selecting appropriate chart, bar charts, line charts, bubble charts, scatter charts ,tree maps, stacked bar charts, bulleted charts and histogram Visualizing locations and time ,How to save and publish your data in Tableau ,How to export charts from Tableau for use in PowerPoint and Word, reshape data using Tableau. Preparing elevator pitch.
Creating Dynamic Charts in Tableau : “Measure Names” and “Measure Values” in Tableau, Measures :sum, average, median, minimum ,maximum, standard deviation and variance, removing outliers, Filters and groups, data hierarchies, trend lines, box plot and regression. Calculations in Tableau, blending and aggregation level calculations, enabling flexibility in KPI. Creating Maps: point maps, shape maps and customize boundary maps.
Story Telling using Tableau: Exploratory vs. explanatory, who, what and how, big idea and storyboarding, storyboarding hourglass, cluttering, gestalt principles of visual perception, and lack of visual order, Magic of story, constructing the story, narrative structure, tactics to ensure the clarity in story, story creation using tableau, story points and tools for data story, stress-testing the story.