Data Analyst Course
Power BI
Power BI Desktop
o Installing Power BI
desktop
o Import data from
different sources
o Creating .pbix
files
o Adding Charts and
Visualizations
o Transforming datasets
o Creating a data model
o Filtering data
o Security for roles,
columns and pages
o Creating reports and
check data
o Data analysis
expressions (DAX)
Power BI Cloud
o Workspaces
o Datasets & Semantic
model
o Reports
o Dashboards
o Workbook
Power BI Embedded
Power BI Mobile
Power BI Admin
Power BI Gateways
Power apps
Power automate
Power virtual agent
Power bi report builder
Power bi report server
Power Rest API
Tableau
Tableau Desktop
o Installing Tableau desktop
o Import data from different sources
o Data Connections in the Tableau
o Joining, Filters, Groups
o Sets, Bins, Hierarchy
o Formatting & Annotations
o Chart types
o Creating and using parameters
o Mapping
o Data preparation & Data analysis
o Actions & Calculated fields
o Creating Dashboards
Tableau Online / Server
o Projects
o Workbooks
o Edit reports
Tableau mobile
Tableau reader
Tableau public
Tableau bridge
Tableau prep
Tableau Admin
SQL Server
What is SQL Server
SQL Server History
SQL Server desktop parts
Commands
Data types
Date functions
Default databases
Tables
Joins
Operates
Temporary table
Union & Union all
Rank & Dense rank
Primary key & Foreign key
Execution plan & show plan
Synonym
Clauses
Views
Pivot table & Unpivot Tables
Sequence
Group by
Highest salary
Sub queries
Triggers
Running total
Excel
Creating Workbooks
Workbooks & Worksheets
Entering and Editing Data
Formulas
Functions
Formatting
Navigating and Selecting
Creating and Editing Charts
Sorting Data
Filtering Data
Ribbons, Tabs and Menus
Options
Macros
Python
Introduction to Python
First Python Program
Python Character Set
Variables
Rules for Identifiers
Data Types
Keywords
Print Sum
Comments in Python
Operators in Python
Type Conversion
Inputs in Python
Strings Statements
Conditional Statements
Lists in Python
Diff between Strings and Lists
List Slicing
List Methods
Tuples
Diff between Tuples and Lists
Tuple Slicing
Tuple Method
Dictionary &
Set in Python
Loops
Functions &
Recursion
File Input/output
OOPS
