Data Analyst Program

You can get a full Data Analyst Program Certification & Training course from Fast Learning Technologies. You will learn Python, Tableau, Power BI, Excel, SQL and Shell Scripting in this course. The best online Data Analyst course will also enable you to gain practical experience on actual projects and get you ready for a wonderful career as a Data Analyst programmer.

Master's Program

From 269 Ratings

 4.4/5

Course Fees: Rs.49000 | Discount Fees: Rs.35000

Quick Enquiry

Overview of Data Analyst Online Training

The Data Analyst Master Program online course in Fast Learning Technologies is designed to provide students with an in-depth understanding of data analytics and the tools and techniques used to work with data. This program covers topics such as data mining, data visualization, as well as the fundamentals of database design and management. Students will learn how to use the latest tools and technologies to analyze, manipulate, and interpret data, as well as create meaningful insights and reports.

Students will also learn how to effectively communicate insights and results to stakeholders and decision makers. Upon completion of the program, students will be able to use their new skills to solve real-world data problems and make informed decisions.

Training Key Features

Syllabus - Data Analyst

Syllabus for Excel and Advanced Excel

Basic Excel

Text to Columns
Concatenate
The Concatenate Function
The Right Function with Concatenation
Absolute Cell References
Data Validation
Time and Date Calculations
Conditional Formatting
Exploring Styles and Clearing Formatting
Using Conditional Formatting to Hide Cells
Using the IF Function
Pivot Tables
Creating a Pivot Table
Specifying PivotTable Data
Changing a PivotTables Calculation
Filtering and Sorting a PivotTable
Creating a PivotChart
Grouping Items
Updating a PivotTable
Formatting a PivotTable
Using Slicers
Charts
Creating a Simple Chart
Charting Non-Adjacent Cells
Creating a Chart Using the Chart Wizard
Modifying Charts
Moving an Embedded Chart
Sizing an Embedded Chart
Changing the Chart Type
Chart Types
Changing the Way Data is Displayed
Moving the Legend
Formatting Charts
Adding Chart Items
Formatting All Text
Formatting and Aligning Numbers
Formatting the Plot Area
Formatting Data Markers
Pie Charts
Creating a Pie Chart
Moving the Pie Chart to its Own Sheet
Adding Data Labels
Exploding a Slice of a Pie Chart
types of Data Analysis
Data Analysis Process
Working with Range Names
Copying Name using Formula Autocomplete
Range Name Syntax Rules
Creating Range Names
Creating Names for Constants
Managing Names
Scope of a Name
Editing Names
Applying Names
Using Names in a Formula
Viewing Names in a Workbook
Copying Formulas with Names
Difference between Tables and Ranges
Create Table
Table Name
Managing Names in a Table
Table Headers replacing Column Letters
Propagation of a Formula in a Table
Resize Table
Remove Duplicates
Convert to Range
Table Style Options
Table Styles
Cleaning Data with Text Functions
Removing Unwanted Characters from Text
Extracting Data Values from Text
Formatting Data with Text Functions

Advance Excel Date Formats

Converting Dates in Serial Format to Month-Day-Year Format
Converting Dates in Month-Day-Year Format to Serial Format
Finding a Workday after Specified Days
Customizing the Definition of a Weekend
Number of Workdays between two given dates
Extracting Year, Month, Day from Date
Extracting Day of the Week from Date
Obtaining Date from Year, Month and Day
Calculating Years, Months and Days between two dates

Conditional Formatting

Highlight Cells Rules
Top / Bottom Rules
Data Bars
Color Scales
Icon Sets
New Rule
Clear Rules
Manage Rules

Sorting

Sort by Text
Sort by Numbers
Sort by Dates or Times
Sort by Cell Color
Sort by Font Color
Sort by Cell Icon
Sort by a Custom List
Sort by Rows
Sort by more than one Column or Row

Filtering

Filter by Selected Values
Filter by Text
Filter by Date
Data Analysis with Excel
Filter by Numbers
Filter by Cell Color
Filter by Font Color
Filter by Cell Icon
Clear Filter
Advanced Filtering
Filter Using Slicers

Other Topics

Subtotals with Ranges
Subtotals
Nested Subtotals
Quick Analysis
Quick Analysis with TOTALS
Sum
Average
Count
%Total
Running Total
Sum of Columns

Lookup Functions

Using the VLOOKUP Function
Using VLOOKUP Function with range lookup TRUE
Using VLOOKUP Function with range lookup FALSE
Using the HLOOKUP Function
Using HLOOKUP Function with range lookup FALSE
Using HLOOKUP Function with range lookup TRUE
Using the INDEX Function
Using MATCH Function

Pivoting

PivotTables
Creating PivotTable
Recommended PivotTables
PivotTable Fields
PivotTable Areas
Nesting in the PivotTable
Filters
Slicers
Summarizing Values by other Calculations
PivotTable Tools
Using Pictures in Column Charts
Band Chart

Syllabus for Power BI

Introduction to Power BI

Get Started with Power BI
Overview: Power BI concepts
Sign up for Power BI
Overview: Power BI data sources
Connect to a SaaS solution
Upload a local CSV file
Connect to Excel data that can be refreshed
Connect to a sample
Create a Report with Visualizations
Explore the Power BI portal

Viz and Tiles

Overview: Visualizations
Using visualizations
Create a new report
Create and arrange visualizations
Format a visualization
Create chart visualizations
Use text, map, and gauge visualizations and save a report
Use a slicer to filter visualizations
Sort, copy, and paste visualizations
Download and use a custom visual from the gallery

Reports and Dashboards

Modify and Print a Report
Rename and delete report pages
Add a filter to a page or report
Set visualization interactions
Print a report page
Send a report to PowerPoint
Create a Dashboard
Create and manage dashboards
Pin a report tile to a dashboard
Pin a live report page to a dashboard
Pin a tile from another dashboard
Pin an Excel element to a dashboard
Manage pinned elements in Excel
Add a tile to a dashboard
Build a dashboard with Quick Insights
Set a Featured (default) dashboard
Ask Questions about Your Data
Ask a question with Power BI Q&A
Tweak your dataset for Q&A
Enable Cortana for Power BI

Publishing Workbooks and Workspace

Share Data with Colleagues and Others
Publish a report to the web
Manage published reports
Share a dashboard
Create an app workspace and add users
Use an app workspace
Publish an app
Create a QR code to share a tile
Embed a report in SharePoint Online

Other Power BI Components and Table Relationship

Use Power BI Mobile Apps
Get Power BI for mobile
View reports and dashboards in the iPad app
Use workspaces in the mobile app
Sharing from Power BI Mobile
Use Power BI Desktop
Install and launch Power BI Desktop
Get data
Reduce data
Transform data
Relate tables
Get Power BI Desktop data with the Power BI service
Export a report from Power BI service to Desktop

DAX functions

New Dax functions
Date and time functions
Time intelligence functions
Filter functions
Information functions
Logical functions
Math & trig functions
Parent and child functions
Text functions

Syllabus for Tableau

Tableau Course Material

Start Page
Show Me
Connecting to Excel Files
Connecting to Text Files
Connect to Microsoft SQL Server
Connecting to Microsoft Analysis Services
Creating and Removing Hierarchies
Bins
Joining Tables
Data Blending

Learn Tableau Basic Reports

Parameters
Grouping Example 1
Grouping Example 2
Edit Groups
Set
Combined Sets
Creating a First Report
Data Labels
Create Folders
Sorting Data
Add Totals, Sub Totals and Grand Totals to Report

Learn Tableau Charts

Area Chart
Bar Chart
Box Plot
Bubble Chart
Bump Chart
Bullet Graph
Circle Views
Dual Combination Chart
Dual Lines Chart
Funnel Chart
Traditional Funnel Charts
Gantt Chart
Grouped Bar or Side by Side Bars Chart
Heatmap
Highlight Table
Histogram
Cumulative Histogram
Line Chart
Lollipop Chart
Pareto Chart
Pie Chart
Scatter Plot
Stacked Bar Chart
Text Label
Tree Map
Word Cloud
Waterfall Chart

Learn Tableau Advanced Reports

Dual Axis Reports
Blended Axis
Individual Axis
Add Reference Lines
Reference Bands
Reference Distributions
Basic Maps
Symbol Map
Use Google Maps
Mapbox Maps as a Background Map
WMS Server Map as a Background Map

Learn Tableau Calculations & Filters

Calculated Fields
Basic Approach to Calculate Rank
Advanced Approach to Calculate Rank
Calculating Running Total
Filters Introduction
Quick Filters
Filters on Dimensions
Conditional Filters
Top and Bottom Filters
Filters on Measures
Context Filters
Slicing Filters
Data Source Filters
Extract Filter

Learn Tableau Dashboards

Create a Dashboard
Format Dashboard Layout
Create a Device Preview of a Dashboard
Create Filters on Dashboard
Dashboard Object
Create a Story

Upcoming Batches

Schedule Your Batch at your convenient time.

Batch	Day	Timing
Weekdays	Monday, Wednesday, Friday	7 to 8.30AM, 9 to 10.30AM, 6 to 7.30PM ,8 to 9.30 PM
Weekend	Saturday	7 to 10 AM, 9 to 12 AM, 2 to 5 PM, 5 to 8 PM

Want to Book Your Seat?

Data Analyst Certification

All major global multinational corporations accept our certification. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees, by earning this certification, which is provided at the conclusion of the course.

You can increase the importance of your profile during interviews and gain access to a wide range of professional opportunities by combining this certificate with your CV.

The certification is only given upon the successful completion of our training and project-based projects with a practical component.

Our Recent Placements

Kalai

Emphasis

RPA Developer

Ranjan

Wipro

Data Science Engineer

Sanjai

TCS

Cloud Engineer

Gowsalya

Philips

Software Engineer

Richa

GPT Technologies

Java Developer

Krishna

Infosys

Python Developer

Naveen Reddy

YG Technologies

Python Fullstack Developer

Testimonial Reviews

Poovizhirajan R

I joined Fast Learning Technologies to learn Java Fullstack course. It was really an amazing experience and gained a lot of technical knowledge. My trainer Karthik sir teaches every concept with real time example which is very easy to understand. He also helps in clarifying doubts on time and he is very friendly. Thank you so much sir for your guidance. I also thank Fast Learning Technologies Team, Bangalore. Best training institute in Bangalore.

Daniel Be

I enrolled for Python fullstack course in Fast Learning Technologies Bangalore. It is such a wonderful place to learn and I gained great knowledge.Karthik sir explained everything on one to one basis very clearly, with extra time if I had doubt This gave me very good self-confidence. Thanks to Fast Learning Technologies Bangalore

Jai Sankar

I completed my full stack web development training here. The whole experience was extremely wonderful and knowledgeable. Training is completely hands on. You learn to code and work on projects. Sonu sir is one of the best trainer I studied from. The assignment given are really help to check what you learned. I got placed while training itself with a really good package. Overall I recommend Fast Learning Technologies for training and career development.

Prabakaran D

First of all I would like to thank FAST LEARNING TECHNOLOGIES team for their continuous support throughout out my learning. I did PYHON FULL STACK training and the instructor is excellent. He knew in and out of the concepts. The way he explains the concepts is very cool and he will make sure that all concepts are clear to the students. I will look forward for more courses.

Anbu Arasu

It's been an amazing experience with Fast Learning Technologies. My Trainer is Mr.Karthik, he is so friendly and trained us with more effort. I’m not from csc or IT background but the way she thought us made me to learn the course easily. Thank you My training institute Fast Learning Technologies Bangalore.

Sathish Kumar

Fast Learning Technologies is best Python Training in Bangalore .I attended python training in Fast Learning Technologies. Training class and all session was very well and acceptable. Trainer Clear my all queries and doubts very politely. Thanks to Fast Learning Technologies Bangalore.

Santhosh Nisha

AWS Training was excellent with good interaction. Knowledge sharing is good. Course was practical and informative. Staffs were enthusiastic and really aware of what they were explaining. The course helped to build confidence, Valuable experiences and learning. Overall very informative training sessions. Course content got well covered and also demonstrated the concept very well. Thanks for such an informative and concept-clearing training sessions .Thanks to Fast learning Technologies.

Frequently Asked Questions

Who are the Trainers?

Fast Learning Technologies instructors are all industry practitioners with at least 9-12 years of relevant IT experience. They are subject matter experts, who have been trained by Fast Learning Technologies to deliver an extraordinary learning experience.

What if I miss one (or) more class?

Not to worry. Fast Learning Technologies ensure that no single lecture topic is missed. With all such options, we will reschedule the classes at your convenience within the course duration. If necessary, you can attend that topic with any other batch.

Is this course available Online or offline?

All courses are available in both Online and offline mode.

How much is the fee for course?

It is mentioned on the course pages. Discount prices are only available for a limited time.

How long is the duration of the course?

Course duration for Training courses are 30 – 45 Hrs.
Course duration for Master courses are 90 – 135 Hrs.

For any queries?

For any queries please contact us +91 7418595544