DATA ANALYTICS
Unlock the power of data with Fusion Software
Institute’s Data Analytics Course.
WWW.fusion-institute.com
INTRODUCTION
In today’s data-driven world, the ability to analyze, visualize,
and interpret data is essential for making informed
decisions across industries. Fusion Software Institute's Data
Analytics Course equips you with the skills to succeed,
whether you’re new to the field or looking to enhance your
expertise. The course covers everything from foundational
concepts to advanced techniques, helping you thrive in
data-rich environments.
Through hands-on exercises, real-world case studies, and
industry expert-led sessions, you’ll gain proficiency in data
visualization, statistical analysis, and key business
intelligence (BI) tools like Tableau, Power BI, and Python
libraries such as Matplotlib and Seaborn. You’ll learn to turn
complex data into actionable insights and communicate
them effectively for decision-making.
With the increasing demand for data-driven insights, this
course opens doors to careers in fields like finance,
healthcare, marketing, and technology. You'll be
well-prepared for roles such as Data Analyst, Business
Intelligence Analyst, and Data Visualization Specialist,
ensuring a wide range of career possibilities in the growing
data analytics industry.
Join Fusion Software Institute today and take the first step
toward a rewarding career in data analytics!
Course Content
PYTHON
Introduction To Python-Installation
Notebook Intro, Variables
Data Types - Numbers-Methods
String - Methods
List-Methods
Tuple, Set, Dictionary - Methods
Statement, Indentation
Conditional Statements
Practical Assignment
For Loop
While Loop
Break, Continue, Pass, List Comprehension
Practical Assignment
Functions -User Define Function
Def - Conditional Statement, Loops
Lambda - Map, Filter, Reduce
Practical Assignment
Exception Handling
Practical Assignment
Doubt Session
Libraries: Numpy Intro - Array, Matrix
Indexing, Slicing, Random
Functions in Numpy
Practical Assignment
Pandas - Series, DataFrame
Add, Update, Drop Columns
Function In Pandas, Group by
Pandas Plotting
Import/Export csv, Data Cleaning
Analysis of Data
Matplotlib Plotting
Matplotlib Plotting, Editing, Filtering
Seaborm: Inbult Datasets
Seaborn Plotting
EDA
Project on Data Analysis
EXCEL/ADVANCE EXCEL
Excel Intro, Ribbon,Tab and Groups
Modify Worksheet, Creating Data, Data
Basic Formulas
Filtering Data, Charts
Pivot Table, 2 D Pivot
Pivot Charts
Vlookup
Hlookup, Match Function
Adv Excel Formulae with Condition
Data Tab - Power Query Editor
Import/Export Data, Data Cleaning
Charts, Dashboard
SQL
Database Fundamentals & SQL Basics
Why we use MySQL ?, Installation
RDBMS Concept, Normalization
MySQL-Data types, Commands Intro,
Constraints
Create Database, Create Table
Alter Table- ADD,DROP, MODIFY,
RENAME,TRUNCATE
SELECT, INSERT, UPDATE, DELETE
CLAUSE - FROM, WHERE, GROUPBY
HAVING, ORDERBY, AS
DCL, TCL
OPERATORS - Arthmatic, Comparision,
Logical
EXPRESSION- Numeric , Text, Date
Wild Cards
JOINS- INNER, LEFT, RIGHT, FULL,
UNION,UNION ALL
VIEWS - Create, Drop
FUNCTIONS- Aggregate, Scaler
Aliases , SQL Comments
POWER BI
Introduction Power BI - Installation
Introduction to Power BI Service
Introduction To Ribben
Importing Data from Various Sources,
Direct Query
Visualization: Bar Chart, Column Chart
100% stacked, Line Chart, Area Chart
Staked Area Chart,Line & Stacked, Line
& clustered chart
Ribben, Waterfall, Funnel Chart
Ccatter, Pie, Donut Chart, Treemap
Map, Filled Map
Gauage, Card, Multirow Card
KIP, Slicer, Table, Matrix
Key Influencer, New Card, New Slicer
Filter
Transform Data-Power Query Editor Intro
HOME
Transform - Any, Text, Number, Date & Time
Add column - General, Text, Number,
Date & Time
View - Data Preview, Columns,
Dependencies
Data cleaning on file,merge,append
Dax - Text Functions
Dax - Number Functions
Dax - Date Time Function
Dax - Calculate, Filter
Dax - Logical Functions
Dax Assignment
Dashboard
Our Placement Process
Enroll @Fusion
Software Institute
Intensive Practical
Sessions
Career Mentor
Guidance Session
Training on
Live Projects
Naukri/LinkedIn
Resume Profile Building Session
Preparation
HR/Grooming
Sessions
Mock
Interviews
Be Job Ready
Our Placement Companies
CONTACT US
+91 7498992609/7410577273/7058007273
enquiry@fusion-institute.com
www.fusion-institute.com
Office 101, 1st Floor, Stellar Spaces, Kharadi South Main Road,
opp. Zensar, IT Park, Kharadi, Pune, Maharashtra 411014
