Business Analyst Course in Nagpur, Data Analyst Course in Nagpur, Business Analytics Courses, Data Analytics Course
UFor Batches and Fees of Business Analytics Data Analyst course Contact Atlanta Computer Institute Nagpur..Atlanta Computer Institute Nagpur conducts Training Courses for Business Analyst and Data Analytics . For course fees and batches you can contact Atlanta Computer Institute Nagpur Centres..We conduct Offline and Online courses.
.
SQL
Introduction to MySQL. Installation of MySQL server. Download sample database .Load sample database to work
Module 2:
Writing Basic SQL
Basic SELECT Statement
Selecting All Columns
Selecting Specic Columns
Writing SQL Statements
Column Heading Defaults
Arithmetic Expressions
Using Arithmetic Operators
Operator Precedence
Using Parentheses
Dening a Null
Dening a Column Alias
Using Column Aliases
Concatenation Operator
Using the Concatenation Operator
Literal Character Strings
Using Literal Character Strings
Duplicate Rows
Eliminating Duplicate Rows
Module 3:
Restricting and Sorting Data
Limiting Rows Using a Selection
Limiting the Rows Selected
Using the WHERE Clause
Character Strings and Dates
Comparison Conditions
Using Comparison Conditions
Other Comparison Conditions
Using the BETWEEN Condition
Using the IN Condition
Using the LIKE Condition
Using the NULL Conditions
Logical Conditions
Using the AND Operator
Using the OR Operator
Using the NOT Operator
Rules of Precedence
ORDER BY Clause
Sorting in Descending Order
Sorting by Column Alias
Sorting by Multiple Columns
Module 4:
Working on DDL Commands
Relational Database Management System (RDBMS)
Normalization
Create Database objects
Data Types in SQL
Alter Table Statements
Drop Table Statements
Various Constraints
Creating Views
Module 5:
Working on DML statements
Data Manipulation Language
Adding a New Row to a Table
The INSERT Statement Syntax 8-5
Inserting New Rows
Inserting Rows with Null Values
Inserting Special Values
Inserting Specic Date Values
Creating a Script
Copying Rows from Another Table
Changing Data in a Table
The UPDATE Statement Syntax
Updating Rows in a Table
Updating Two Columns with a Subquery
Updating Rows Based on Another Table
Updating Rows: Integrity Constraint Error
Removing a Row from a Table
The DELETE Statement
Deleting Rows from a Table
Deleting Rows Based on Another Table
Deleting Rows: Integrity Constraint Error
Using a Subquery in an INSERT Statement
Module 6:
Working on multiple tables and Retrieve records from multiple tables
Self-Join
Inner Join
Left Join
Right Join
Cross Join
Module 7:
Working on multiple tables and Retrieve records from multiple tables
Self-Join
Inner Join
Left Join
Right Join
Cross Join
Module 8:
Working on multiple tables and Retrieve records from multiple tables
Self-Join
Inner Join
Left Join
Right Join
Cross Join
Module 9:
Working on subqueries
Using a Subquery to Solve a Problem
Subquery Syntax
Using a Subquery
Guidelines for Using Subqueries
Types of Subqueries
Single-Row Subqueries
Executing Single-Row Subqueries
Using Group Functions in a Subquery
The HAVING Clause with Subqueries
Multiple-Row Subqueries
Using the ANY Operator in Multiple-Row Subqueries
Using the ALL Operator in Multiple-Row Subqueries
Null Values in a Subquery
Module 10:
Use of built-in function in SQL
Conversion Function
Logical Functions
Math Function
Aggregate Functions
String Functions
Date Functions
Power BI
Introduction to Data warehouse
Data warehouse Tools
What is Power BI?
Power BI – Flow of Activity
Building Blocks of Power BI
Power BI – Primary Tools : Power Pivot, Power Query,
Power View, Power Map, Power Q&A, Power BI Desktop
Power BI Desktop
Power BI Desktop – Install
Data Sources and Connections
Connect to Data in Power BI Desktop
How to use Query Editor in Power BI
Advanced Data Changes and Transformation
Views in Power BI Desktop
Modeling Data - Manage Data Relationship,
Create Calculated Columns, Optimize Data Models
Data Analysis Expressions (DAX)
What is DAX?
Data Types in DAX
Calculation Types
DAX Functions : Date and Time, Time IIntelligence,
Information, Logical, Mathematical, Statistical, Text,
Aggregate Measures in DAX
Table Relationships and DAX
Data visualization
Why Data Visualization
Practices for Data Visualization
How to use Visual in Power BI
Reports in Power BI
Charts in Power BI (Scatter, Waterfall, Funnel)
Slicers
Map Visualizations
Gauges and Single Number Cards
Custom visualizations
What Are Custom Visuals?
Ofce Store
Downloading Custom Visuals
Importing Custom Visuals in Power BI Report
KPI Visuals
Data Binding in Power BI
Power BI Integration page And Administration
Data Gateways
Content packs
Power BI Report Server
Power BI Embedded
Power BI Embedded Conceptual Model
Workspace Collection
Adding Power BI content to a Workspace
Application Authentication Tokens
Parts of Power BI embedded - REST API
Power BI Embedding without an Embed Token
Power BI Embedding with an Embed Token
Power BI Q&A
Dashboard
Dashboard vs Reports
Creating a Dashboard
Dashboard Tiles
Pinning Tiles
Quick Insights with Power BI
Power BI Publisher for Excel
Tableau
Introduction to Tableau
Overview of Tableau
Data visualization and analytics
Elements of the Tableau dashboard
Understanding the signicance of Tableau Desktop and Tableau Server
Extensively work with data visualization using line, bar, area,
stacked bar, and multi line charts
Connecting with Excel data
Deep dive into Tableau Graphs
Various data representation techniques
Like Tables
Graphs and Maps understanding the basics of Tree Map
Histogram
Filled Map
Symbol Map
Pie Chart
Trend Lines
Normal Tables and Multi measure Tables
Tableau Table Joins
Understanding the conditions and methodology for joining Tables
Knowledge of Multi Table Joins
Working with Metadata
Working with Table
Creation of Calculated Fields
Duplicating and renaming columns
Conversion of data types
Default aggregation
Hierarchy & Groups
Tableau Hierarchy creation
Static Group creation
Deploying functions for Group creation
Tableau Sorting
The various options of Sorting in Tableau
Sorting of Multi-dimensional graph
Deploying combined elds and setting sorting priorities
Dual Axis Graphs
Working with Dual Line Charts
Multiline Chart
Donut Chart
Pie Chart
Working with Measure Name and Measure Values
Learning about the different type of Single Axis Histogram,
Dual Axis Histogram
Histogram
Learning about the different type of Single Axis Histogram
Dual Axis Histogram
Pareto Chart
Understanding how to design and work with Pareto Chart
Motion Chart
Deploying Motion Chart for data that changes over time using x and y axes
Box Plot
Representation of numerical data through quartiles using Box Plot
Funnel Chart
Working with Funnel Chart for data that progressively reduces with each stage.
Waterfall Chart
Deploying Waterfall Chart for understanding the cumulative effect of sequential values
Sets
Understanding the concept of Set which is an entity whose composition is based on a computed condition
String Calculated Fields
Learning how to perform various operations on Strings like concatenation Manipulation and analyzing with String Calculated Fields
Date Calculated Fields
Working with Date Calculated Fields for performing operations like parsing Modifying and analyzing
Tableau Parameters
Learning to use the dynamic values or parameters including
What if Analysis Column Selection Parameters,
Chart Selection Parameters
Tableau Actions
Tableau lets you add interactivity and context to your data using Filter Actions, URL Actions.
Dashboard Creation
Working with the Tableau Dashboard and understanding the various concepts like Formatting, Containers, Navigations and Actions.
Tableau Architecture
Understanding the basic Architecture of Tableau
Learning about Tableau Desktop features,Tableu Server,
working of Tableau and the various Tableau Products
Tableau Products
Tableau public Features
Tableau Desktop personal features
Tableau Desktop professional feature
Tableau Server Feature
Tableau File System
Tableau Working
Tableau Server Architecture
Connection Type
Tableau Connections –Live Connection and Data Extract Connection,
Comparing the two Live And Extract connection
Sharing Dashboard
Learning to work on Tableau by sharing the dashboard with ofine users
Data Blending
Methods to work with data from disparate sources,
dening the relationship between the data and combining it in the optimal way.
Dashboard Filter
Working with various Tableau Filter options, understanding the Filter Dimensions and ways to make the Filter Global.
Filter Deployment
Taking the various data sources and implementing to blend the graphs, using Global Fliter for blending graphs
Tableau LOD Expression
Tableau Level of Detail Expressions for combining aggregate and non-aggregate data, converting aggregate to non-aggregate data in Tableau 9.X
MapBox Integration
Integrating MapBox on Tableau for deploying Maps into Tableau Visualization
Table Calculation
Understanding Tableau Table Calculation, familiarizing with Graph and View, learning about Context lter
Aggregating Data
Understanding the concept of aggregating data in Tableau, dening Table Calculation, , Mark Labels, FORMAT function, working with String, Date and Logical Function, data disaggregating, forecasting.
Dening Table Calculation
Working with Drop Lines
Mark Labels
FORMAT function
Working with String
Date and Logical Function
Data disaggregating
Forecasting
Excel
Excel Introduction
Date And Time Functions
Customizing Excel
File Formats..
Advanced Paste Special Techniques
Using Basic Functions
New In Excel 2013 / 2016 & 365
Formatting And Proofing
New Charts - treemap & Waterfall
Using Power Map And Power View
Quick Analysis Tool
Mathematical Functions
Sorting And Filtering
Various Charts Gantt Chart, Doughnut Chart, Pie, Column & Area Chart
Sorting Data Using Custom Sort
Dashboard Designing
Data Validation, Creating Drop Down Lists Using Different Data Sources
Protecting Excel
Text Functions
Printing Workbooks
What If Analysis
Pivot Tables
Logical Functions
Arrays Functions
Data Validation
Charts And Slicers
Lookup Functions
Smart Lookup And Manage Store
Excel Dashboard
Introduction To Vba
Looping In Vba
Variables In Vba
Mail Functions – Vba
Message Box And Input Box
Worksheet / Workbook Operations
If And Select Statements
