Advance Excel with Tableau

Online Live | 10 Hours | FDP Certification
499.00 (Inc. GST)

The Faculty Development Program is exclusively for faculty members of colleges and universities; it is not available to students or professionals. Please note that payment is non-refundable once processed.

Note: E&ICT Academy offers a complete fee waiver for SC/ST faculty upon submission of a valid SC/ST certificate. Please go to the “Registration Form” tab to avail yourself of the fee waiver.

Categories: , Tag:

The data analytics course provides fundamental concepts of data analytics through real world case studies and examples and gives insights into how to apply data and analytics principles in your business. You’ll learn about project lifecycles, the difference between data analytics, data science, and machine learning; building an analytics framework, and using analytics tools to draw business insights.

Course Objective:
We see how we can work on complex data and make dashboards with it, we also work on Power BI which is a data analytics tool that makes map, charts and beautiful dashboard and story.

Prerequisites:

  • This Introduction to Data Analytics course has been designed for all levels, regardless of prior knowledge of analytics, statistics, or coding. Familiarity with mathematics is helpful for this course.

WIIFM (What’s in it for Me):

When you complete this Introduction to Data Analytics course, you will be able to accomplish the following:

  • Understand how to solve analytical problems in real-world scenarios
  • Define effective objectives for analytics projects
  • Work with different types of data
  • Understand the importance of data visualization to drive more effective business decisions and ROI
  • Understand charts, graphs, and tools used for analytics and use them to gain valuable insights
  • Create an analytics adoption framework Identify upcoming trends in data analytics

Delivery Mode: 100% Online Live Instructor-led learning

Batch Date: 14th Nov’2024  to 19th Nov’2024

Duration : 10 hours

Curriculum

Working with the Web and External Data

  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections

Working with PivotTables

  • Creating a PivotTable
  • Specifying PivotTable Data
  • Changing a PivotTable’s Calculation
  • Filtering and Sorting a PivotTable
  • Working with PivotTable Layout
  • Grouping PivotTable Items
  • Updating a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart
  • Using Slicers
  • Sharing Slicers Between PivotTables

It’s super easy to get Started

  • Welcome! What is Tableau & Course Overview
  • Installation

Tableau Basics Your First Bar chart

  • The Business Challenge – Who Gets the Annual Bonus
  • Connecting Tableau to a Data File – CSV File
  • Navigating Tableau
  • Creating Calculated Fields
  • Adding Colors
  • Adding Labels and Formatting
  • Exporting Your Worksheet
  • Get The Viz!

Time series, Aggregation, and Filters

  • Section Intro
  • Working with Data Extracts in Tableau
  • Working with Time Series
  • Understanding Aggregation, Granularity, and Level of Detail
  • Creating an Area Chart & Learning About Highlighting
  • Adding a Filter

Maps, Scatterplots, and Your First Dashboard

  • Section Intro
  • Joining Data in Tableau
  • Creating a Map, Working with Hierarchies
  • Creating a Scatter Plot, Applying Filters to Multiple Worksheets
  • Let’s Create our First Dashboard!
  • Adding an Interactive Action – Filter
  • Adding an Interactive Action – Highlighting

Joining and Blending Data, PLUS Dual Axis Charts

  • Section Intro
  • Understanding how LEFT, RIGHT, INNER, and OUTER Joins Work
  • Joins With Duplicate Values
  • Joining on Multiple Fields
  • Data Blending in Tableau
  • The Showdown Joining Data v
  • Dual Axis Chart
  • Creating Calculated Fields in a Blend (Advanced Topic)
  • Section Recap

Registration Form

Click or drag a file to this area to upload.