Data Analysis Course | Learn Advanced Excel, Power BI & Tableau

Instructor

Curriculum

Master data analysis with our course on Advanced Excel, Power BI, and Tableau. Learn to analyze, visualize, and interpret data to drive insights and business decisions. Enroll now to boost your data analysis skills!

Ratings

( 3.9 Ratings )

Live Online Classes starting on 08 January, 2025

Data Analysis (Advance Excel/Power BI /Tableau)

Advance Excel

Creation of personalized templates
Knowledge on how to work with sparklines
Basic knowledge on how to create and manage scenarios
Use of Goal Seek and Solver
Creation, management, and formatting pivot tables and pivot charts
Use of Excel mathematical functions
Creation and writing knowledge on complex formulas
Perform data lookups
Creation and use IF statements
Use of Excel’s data functions
Creation and use data validation rules
Application of custom and prebuilt conditional formatting
How to work with functions to manipulate strings of text and data
Creation and use of macros
Troubleshoot and audit formulas
Creation of pivot tables and pivot charts
Use of queries to import external data
Import and clean data
How to link and consolidate worksheets and workbooks

Power BI

An Introduction to Power BI
Extract, transform and load data
Creating a data model
Designing Reports
Using workspaces and dashboards

Tableau

Data Visualization
Business Intelligence tools
Introduction to Tableau
Tableau Architecture
Features of Tableau Desktop
Connect to data from File and Database
Types of Connections
Joins and Unions
Data Blending
Tableau Desktop User Interface
Visual Analytics
Basic Charts: Bar Chart, Line Chart, and Pie Chart
Hierarchies
Data Granularity
Highlighting
Sorting
Filtering
Grouping
Sets
Types of Calculations
Built-in Functions (Number, String, Date, Logical and Aggregate)
Operators and Syntax Conventions

(3.9 Ratings)

Download Course Contents

SpireTec Unique Features

1-On-1 Training

Benefit from our 1-On-1 Training for personalized, focused, and effective learning experiences.

Customized Training

Experience our Customized Training service tailored to meet your specific learning needs and goals

4 - Hours / Weekend Session

Join our Class featuring 4 - Hours / Weekend Session for in-depth learning and expert training.

Free Demo Class

Join our Free Demo Class to experience top-notch training and expert guidance first hand!

Purchase This Course

Add Exam

Live Online Training (Duration)

Guaranteed to run classes as per your convenient time zone

Industry experienced & certified trainers

Query Handling session by technical expert after 2 month completion of training

Career path counselling

Custom tailored training as per the requirement

Exam assistance

Exam Mock papers

100% Quality assurance with certified & industry experienced Trainer

4 Hours Week Days

8 Hours Weekends

Live Online Training (Duration)

Guaranteed to run classes as per your convenient time zone

Industry experienced & certified trainers

Query Handling session by technical expert after 2 month completion of training

Career path counselling

Custom tailored training as per the requirement

Exam assistance

Exam Mock papers

100% Quality assurance with certified & industry experienced Trainer

Request More Information

CERTIFICATE

Get Ahead With SpireTec Solutions
Training Certificate

Earn your Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Differentiate yourself with Masters Certificate

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Share your achievement

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Need Customized Curriculum?

Our course is exhaustive and this certificate is proof that you have taken a big leap in mastering the domain.

Talk To Adviser

Download Course Contents

Advance Excel

Creation of personalized templates
Knowledge on how to work with sparklines
Basic knowledge on how to create and manage scenarios
Use of Goal Seek and Solver
Creation, management, and formatting pivot tables and pivot charts
Use of Excel mathematical functions
Creation and writing knowledge on complex formulas
Perform data lookups
Creation and use IF statements
Use of Excel’s data functions
Creation and use data validation rules
Application of custom and prebuilt conditional formatting
How to work with functions to manipulate strings of text and data
Creation and use of macros
Troubleshoot and audit formulas
Creation of pivot tables and pivot charts
Use of queries to import external data
Import and clean data
How to link and consolidate worksheets and workbooks

Power BI

An Introduction to Power BI
Extract, transform and load data
Creating a data model
Designing Reports
Using workspaces and dashboards

Tableau

Data Visualization
Business Intelligence tools
Introduction to Tableau
Tableau Architecture
Features of Tableau Desktop
Connect to data from File and Database
Types of Connections
Joins and Unions
Data Blending
Tableau Desktop User Interface
Visual Analytics
Basic Charts: Bar Chart, Line Chart, and Pie Chart
Hierarchies
Data Granularity
Highlighting
Sorting
Filtering
Grouping
Sets
Types of Calculations
Built-in Functions (Number, String, Date, Logical and Aggregate)
Operators and Syntax Conventions

SpireTec solutions is the latest technology enabled I.Tmanagement training company specialized in offering 1500+ courses with the state of art training facilities backed by a team of industry experts in various domains with assuring best quality services.

Since SpireTec provides 24X7 training and support for your training needs is very adaptable to your time availabilities and offers customized training programs according to your availability and time zones of your contingent.

Because SpireTec aims for the personal & professional growth of you as individual & corporate as a whole, providing training on the latest and updated versions in the designated domains.

It is preferable but not mandatory to have domain experience in the area of your interest in which you want to opt training, supported by good English communication skills, a good Wi-Fi and computer or laptop system in case you want remote training.

Spire Tec aims and ensure to offer finest and world-class training to the participants by giving them a proper counselling and a guided career path by our industry experts which leads guaranteed success for you in the corporate world.

We offer online training (1-1, Group training), Classroom training, Onsite training with state of art facilities.

AI - 102 : Designing and Implementing an Azure AI Solution

AI - 900 : Microsoft Azure AI Fundamentals

AZ - 1004 : Deploy and configure Azure Monitor

AZ - 104 : Microsoft Azure Administrator

AZ - 2001 : Implement Security through a Pipeline using Azure DevOps

AZ - 2002 : Develop an ASP.NET Core web app that consumes an API

AZ - 2003 : Deploy cloud-native apps using Azure Container Apps

AZ - 204 : Developing Solutions for Microsoft Azure

AZ - 400 : Microsoft Azure DevOps Engineer

AZ - 500 : Microsoft Azure Security Technologies

AZ - 801 : Configuring Windows Server Hybrid Advanced Services

Certified Associate in Project Management (CAPM)®

Project Management Professional (PMP)®

Program Management Professional (PgMP)®

Portfolio Management Professional (PfMP)®

PMI Professional in Business Analysis (PMI-PBA)®

PMI Risk Management Professional (PMI-RMP)®

PMI Agile Certified Practitioner (PMI-ACP)®

PRINCE2® Foundation

PRINCE2® Practitioner

PRINCE2 Agile®

MSP® Foundation

EC-Council CEH: Certified Ethical Hacker v12

EC-Council CCT : Certified Cybersecurity Technician

EC-Council Certified Incident Handler V3

EC-Council CND: Certified Network Defender v2

EC-Council CTIA: Certified Threat Intelligence Analyst

EC-Council Certified Ethical Hacker (CEH) Master

EC-Council CCSE: Certified Cloud Security Engineer

EC-Council Certified Ethical Hacker (CEH) Practical

EC-Council CCISO: Certified Chief Information Security Officer

EC-Council CHFI: Computer Hacking Forensic Investigator v10

EC-Council ECIH : Certified Incident Handler

ISO 9001 Quality Management System

ISO 21502 Project Management

ISO/IEC 27005 Information Security Risk Management

ISO/IEC 27033 Network Security

ISO/IEC 27035 Information Security Incident Management

ISO 22301 Business Continuity Management System

ISO 22317 Business Impact Analysis

ISO 31000 Risk Management

ISO 37301 Compliance Management System

ISO/IEC 38500 IT Governance

ISO/IEC 27701 Privacy Information Management System

CISA - Certified Information Systems Auditor

CISM - Certified Information Security Manager

CRISC - Certified in Risk and Information Systems Control

CDPSE - Certified Data Privacy Solutions Engineer

CGEIT - Certified in the Governance of Enterprise IT

CCAK - Certificate of Cloud Auditing Knowledge

COBIT 5 Foundation

COBIT 5 Implementation

CISSP - Certified Information Systems Security Professional

CCSP – Certified Cloud Security Professional

CGRC – Governance, Risk and Compliance Certification

ISSEP – Information Systems Security Engineering Professional

SSCP – Systems Security Certified Practitioner

VMware HCX : Deploy, Configure, Manage

VMware Site Recovery Manager : Install, Configure, Manage (V8.6)

VMware Aria Automation : Orchestration and Extensibility (V8.13)

VMware vSAN : Troubleshooting (V8)

VMware Aria Automation : Advanced Topics (v8.14)

VMware Cloud Foundation : Deploy, Configure, Manage (V5.0)

VMware vSphere : Design (V8)

VMware Cloud Director : Advanced Networking with NSX-T Data Center (V10.2)

VMware Cloud Director : Advanced Workshop (V10.2)

VMware Cloud Director : Install, Configure, Manage (V10.4)

VMware NSX Advanced Load Balancer : Web Application Firewall Security

AWS Certified Cloud Practitioner

AWS Certified Solutions Architect - Professional

AWS Certified DevOps Engineer - Professional

AWS Certified SysOps Administrator - Associate

AWS Certified Developer - Associate

AWS Certified Solutions Architect - Associate

AWS Certified Data Engineer - Associate

AWS Certified Advanced Networking - Specialty

AWS Certified Security - Specialty

Cloud Digital Leader

Cloud Engineer

Cloud Architect