JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

ATA VISUALIZATION - R PROGRAMMING/ POWER BI

B.Tech II Year I Semester (R22)

Course Objectives:

  • Effective use of Business Intelligence (BI) technology (Tableau) to apply data visualization
  • To discern patterns and relationships in the data.
  • To build Dashboard applications.
  • To communicate the results clearly and concisely.
  • To be able to work with different formats of data sets.

Course Outcomes

At the end of the course a student should be able to

  • Understand How to import data into Tableau.
  • Understand Tableau concepts of Dimensions and Measures.
  • Develop Programs and understand how to map Visual Layouts and Graphical Properties.
  • Create a Dashboard that links multiple visualizations.
  • Use graphical user interfaces to create Frames for providing solutions to real world
  • problems. Lab Problems:
  • 1. Understanding Data, What is data, where to find data, Foundations for building Data Visualizations, Creating Your First visualization?
  • 2. Getting started with Tableau Software using Data file formats, connecting your Data to Tableau, creating basic charts(line, bar charts, Tree maps),Using the Show me panel.
  • 3. Tableau Calculations, Overview of SUM, AVR, and Aggregate features, Creating custom calculations and fields.
  • 4. Applying new data calculations to your visualizations, Formatting Visualizations, Formatting Tools and Menus, Formatting specific parts of the view.
  • 5. Editing and Formatting Axes, Manipulating Data in Tableau data, Pivoting Tableau data.
  • 6. Structuring your data, Sorting and filtering Tableau data, Pivoting Tableau data.
  • 7. Advanced Visualization Tools: Using Filters, Using the Detail panel, using the Size panels, customizing filters, Using and Customizing tooltips, Formatting your data with colors.
  • 8. Creating Dashboards & Storytelling, creating your first dashboard and Story, Design for different displays, adding interactivity to your Dashboard, Distributing & Publishing your Visualization.
  • 9. Tableau file types, publishing to Tableau Online, Sharing your visualizations, printing, and Exporting.
  • 10. Creating custom charts, cyclical data and circular area charts, Dual Axis charts.

REFERENCE BOOKS:

  • 1. Microsoft Power BI cookbook, Brett Powell, 2nd edition.
  • 2. R Programming for Data Science by Roger D. Peng (References)
  • 3. The Art of R Programming by Norman Matloff Cengage Learning India.

Loading Question Papers

Fetching data from database...