Data Analytics

Master Data Analytics Online Training course online with Golive Classes. We provide the best Data Analytics  course online in Hyderabad and other states in India.

Data Analytics

Why choose Golive Classes?

Golive classes we provide:

• Real-time concepts with case studies
• Project Explanation
• Interview Questions
• Resume preparation
• Technical Assistance even after Course Completion
• Career Guidance
• Life time access to video recordings.
• The assistance provides in consulting and placement
• Free other courses will be provided free of cost.

Data Analytics  Online Training Course Content

Introduction

• Introduction to Tableau
• Get Data from Excel Files
• Get Data from Text Files
• Connect to SQL Server Database
• Creating first Tabular Report
• Creating first Bar chart

Tableau Charts, formating  PART – 1

Creating Groups

• Groups
• Bins
• Sets
• Hierarchies

Filters in Tableau

• Filters on Dimensions
• Filters on Measures
• Filters on column names in Rows and Cols
• General filters
• Wild card filters
• Conditional filters
• Top and Bottom Filters

Data Preparation in Tableau

• Removing unnecessary fields
• Renaming fields
• Fixing data types
• Splitting fields
• Filtering fields
• Creating UNION
• Creating JOIN

Tableau Calculations, Functions

• Calculated fields
• The Number Functions
• The String Functions
• Searching for Text
• Type Conversions
• The Date Functions
• Logical Functions
• Calculations using Sets
• Aggregate Functions
• Table functions
• Create Table Calculations
• Calculate Rank

Tableau Charts, Dashboards, formatting PART – 2

• Vertical bar chart
• Horizontal bar chart
• Side by side bars
• Stacked Bar Chart
• Pie Chart
• Tree Map
• Text Table
• Line Chart
• Map
• Filled Map
• Heat map
• Highlight table
• Circle view
• Side by side circles
• Line graph
• Dual lines
• Area graph
• Scatter plot
• Bullet graph
• Packed bubbles
• Tableau Online / Tableau Server

Tableau Dashboards  

• Creating dashboards
• Formatting dashboards

Relationships

• Creating relations between tables

Data Warehousing, Dimensional modelling

• Data Warehousing
• Dimensional modelling
• Fact Tables
• Dimension Tables
• Hierarchies
• STAR Schema
• Snowflake schema
• Slowly changing dimensions (SCDs)

SQL Language

• Database basics
• Create Tables
• Truncate Table
• Drop Table
• Inserting data into Tables
• Retrieving data from Tables
• Select
• Select Distinct
• Where
• And, Or, Not
• Order By
• Select Top
• Like
• Wildcards
• In Between
• Aliases
• CASE
• Retrieving data from multiple Tables
• Joins
• Inner Join
• Left Join
• Right Join
• Full Join
• Aggregations
• Having
• Min and Max
• Count, Avg, Sum

Introduction to Power BI

• Introduction to Power BI
• Get Data from Excel Files
• Get Data from Text Files
• Connect to SQL Server Database
• Creating first Tabular Report
• Creating first Column char        

Power BI Charts

Bar Chart

Clustered Bar Chart

Stacked Bar Chart

100% Stacked Bar Chart

Column Chart

Clustered Column Chart

Stacked Column Chart

100% Stacked Column Chart

Line Chart

Clustered Column and Line Chart

Line and Stacked Column Chart

Area Chart

Pie Chart

Donut Chart

Types of Groups

• Bins
• Groups
• Hierarchies

Filters

• Basic Filters
• Advanced Filters
• Top N Filters
• Filters on Measures
• Page Level Filters
• Report Level Filters
• Slicer

Introduction to Microsoft Excel

• Home
• Entering Values
• Save Workbook
• Create Worksheet
• Copy Worksheet
• Hiding Worksheet
• Delete Worksheet
• Open Workbook
• Context Help

Inserting, Deleting, Copying Data

• Insert Data
• Select Data
• Delete Data
• Move Data
• Copy & Paste
• Find & Replace
• Spell Check
• Zoom In-Out
• Add Text Box
• Undo Changes

Working with Formula

• Creating Formulas
• Copying Formulas
• Formula Reference
• Using Functions
• Builtin Functions

Data Analytics Course Content Download Link

Want to book a Demo for this awesome Data Analytics Course? Click Register.