Subcribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Sept 16th @8:00AM

Faculty: Mr. Ravi Kishore

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

DATA Analytics with Tableau

• Introduction to Data Analysis

• Who is Data Analyst
• What are the roles of Database Analyst
• Difference between Business Analyst and Database Analyst

• Data Warehouse Introduction

• What Is a Data Warehouse?
• DataMart
• Operational DataStores
• Characteristics of a Data Warehouse
• Differences between Databaseand Datawarehouse and Data Martand ODS
• OLTP Vs OLAP Vs Data Mart Vs ODS
• Uses and benefits of an ODS
• ODS and Data Warehouse Design
• OLTP v/s OLAP
• Data Warehouse Architecture

• Data Modelling Introduction

• Conceptual
• Logical
• Physical

• ETL

• Normalized, De-Normalized
• Anamolies
• 1st Normal Form
• 2nd Normal Form
• 3rd Normal Form

• Data profiling, Datacleansing

• Introduction SQL Queries

DDL Statements

• Create Table
• Truncate
• Drop Table

DML Statements

• Insert
• Update
• Delete

DQL Statement

• Select Query

Clauses

• Where
• Like
• Order by
• Groupby
• Having
• Distinct
• Functions

Aggregate Functions

• Count
• Max
• Min
• Sum
• Avg

String Functions

• Length
• Lower
• Upper
• Ltrim
• Rtrim
• Reverse
• Replace

Constraints

• Notnull
• Default
• Unique
• Primary Key
• Foreign Key
• Check

SQL Joins

• Innerjoin
• Left Outer join
• Right Outerjoin
• Full Outer join
• Selfjoin
• Union
• UnionAll

Tableau Desktop

Tableau Desktop for Data Analysis:

• What is Data Visualization?
• Introducing Tableau Desktop

• Installing Tableau
• Communitytools
• Interface & workflow
• Helpful resources etc.

• Connecting to Data

• Connection types
• Data interpreter
• Unions & joins
• Live connections vs. extracts etc.

• Sorting, Filtering & Grouping

• Dimensions vs. measures
• Context filters
• Sets & Hierarchies
• Groups
• Action filters etc.

• Visualizing Data with the Marks Card

• Mark types
• Visual Properties
• Stacking Marks
• The pagesshelf
• Analytics toolsetc.

• Analysing Data with Calcs & Parameters

• Aggregations
• Table calculations
• LOD expressions
• Parameters, addressing & partitioning etc.
• Dynamic Sets

• Building Interactive Dashboards

• Dashboard objects & Sizing
• Dashboard Best Practices
• Tiled vs.floating
• Device designer
• Stories etc.

Advanced Tableau for Data Analysis:

• Tableau Relationships

• Logical & Physicallayers
• Contextual joins
• Smart aggregation etc.

• Dynamic Design

• Custom templates
• KPI shapes
• Dynamic for matting
• Filter menus etc.

• Parameter & Set Actions

• Interactivity
• Relative dimensional analysis
• Animation
• Colour scaling etc.

• Geospatial Mapping

• Spatial functions
• Custom territories
• Hierarchies
• Background maps etc.

• Advanced Calculations

• Advanced tablecalcs
• LOD functions
• Cohort analysis etc.

• Predictive Analytics

• Regression models
• Forecasting
• Clustering
• R & Python integration etc.

• Solving Real-World Problems

• 1,000 Startups
• Coal Terminal Utilization Analysis
• City Parks Safety
• State Salary Analysis
• Retail Sector Forecasts
• World Health Trends
• Regional Profit Analysis

• Tableau Server/Tableau Online

• Publishing
• Security
• Add User
• Create Groups
• Scheduling

• Final Projects & Interview Preparation

• Resume Building
• Interview Questions
• Mock Interviews
• Tableau Certification Activities