Data Analyst training in hyderabad | Best Data Analyst course in hyderabad

 

 

Kosmik Technologies is one of the best Data Analyst Training Institutes in KPHB, Hyderabad. Here the trainers are highly qualified working one of the MNCs. The Data Analyst Training class consists of more practical sessions

Data Analyst Course Content

 

 1.   Python

 2.   MS SQL Server

 3.   Power BI

 4.   Adv Excel

Python:

 

Welcome to the Python and Django Full Stack Web Developer Kosmik Technologies! In this course we cover everything you need to know to build a web application using Python, Django, and many more web technologies!

 

 

Python:     It would be used to implement the business logic to process the data.

 

 

 

 

Data Analyst Course Syllabus

 

 

Pre-work

1.  Introduction to programing

 

Introduction

2.  Learn about the course!

 

Course Set-Up and Installation

3.  Setup your computer for the course! 

 

Python Basics:

4.  Tokens

5.  Formatted Strings

6.  Operators

          •     Logical
          •     Comparison/Relational
          •     Identity
          •     Membership
          •     Ternary
          •     Short-Circuit Evolution
          •     bitwise

 

7.  Data types

8.  Conditional flow Statements

9.  Loops

          • While
          • While – else
          • For
          • For – else
          • Nested loops
          • Iterables

 

10.     Inbuilt Data Structures

          • List
          • Tuple
          • Set
          • frozen set
          • Dictionary
          • List comprehension
          • Dictionary Comprehension
          • Unpacking Operator
          • Nested data structures

 

11.    Functions

          • Defining functions
          • Arguments
          • Types of Functions
          • Positional arguments
          • Keyword arguments
          • Default Arguments
          • *args
          • **kwargs
          • Memory management in functions
          • Generators
          • Nested functions
          • Scope
          •       Global
          •       Local
          •       Non
          • -Local
          •       Built
          • -in
          • Closure
          • Decorators
          •       Chain of decorators
          •       Parameterized decorators
          • Lambda
          • Pipelining
          • Recursive
          • Map
          • Filter
          • Reduce
          • zip
 

12. File I/O

OOP’s:

13. OOPs Vs Procedure Oriented programming

14. Oops concepts

          • Class
          • Object
          • Inheritance
          • Polymorphism
          • Abstraction
          • Encapsulation

15. Constructor

16. Class Vs Instance attributes

17. Class Vs Instance methods

18. Static methods

19. Magic methods

20. Destructor

21. Data hiding

22. Operator Overloading

23. Method Overriding

24. Abstract Base Class

25. Property decorator

26. Message passing

27. Inner class

28. Exception handling

          • Exceptions
          • Handling Exceptions
          • Custom Exceptions
          • Raising Exceptions

 

29. Modules

          • Creating modules
          • Compiled python files
          • __name__
          • Python path
          • Packages
          • Sub packages
          • Dir function

 

Python Standard Library:

          • Regular expressions
          • OS
          • SYS
          • MySQL
          • Threading
          • PDB
          • Random

 

External Libraries (optional):

          • NumPy
          • Pandas
          • Matplotlib

 

What you'll learn

          • Programming
          • Logical thinking.
          • Practical knowledge with Realtime examples.

 

Who this course is for

          • Complete Beginners
          • Professionals looking to bridge gaps in their knowledge



MY SQL SERVER

 

MICROSOFT SQL SERVER (SQL + T-SQL)

Overview:

Microsoft SQL Server is one the most popular Relational Database Management System (RDBMS) used in Microsoft universe. It can be   used for data storage as well as for data reading for applications which can be either on desktop or API/Browse.

Course Objectives: Learn about SQL–Structured Query Language

Build database using Data Definition Language Statements Perform basic CRUD operations using Data Manipulation Language statements like Insert, Update and Delete Write and call Stored Procedures, Functions, Triggers, Cursors and Optimizations techniques in a database.

Pre-requisite / Target Audience:

 This sql server course can be taken by any beginner who wants to build career in Information Technology. The subscriber needs to have working knowledge of Windows Operating System.

Module 1:- Introduction to Basic Database Concepts

Overview of Data

          • Field, Record
          • Files
          • File Groups and database Limitations of File Management System.
          • Exploring Relational DBMS VS RDBMS Understanding Client And Server Architecture

 

Module 2:- Normalization

          • First Normal Form
          • Second Normal Form
          • Third Normal and EF
          • Cod rules Form Practically Normalizing Tables

Module 3:- Introduction to SQL Server

          • SQL Server Version history and different editions
          • Overview of Components, Tools and Software Installations Starting and Stopping SQL Server Instances / Services Introduction to Management Studio
          • Types of System Databases in SQL (Master, Model, MSDB, TempDB)

Module 4: Introduction to SQL

          •  SQL Commands (DDL,DML,DQL,TCL,DCL)
          •   Data types, Operators types of Operators Exploring Commands with Examples

Module 5: Working with Constraints & Data Integrity

          • Primary Key, Unique, NULL, NOT NULL,CHECK, Default, Composite Key, Candidate Key and Foreign key
          •  Real time scenarios to create database and Objects

 

Module 6: Working with Queries (DQL)

          • Understanding Select Statement \ Query Processing steps
          •  Clauses (TOP, WHERE, GROUP BY, HAVING, Order By with Offset and fetch) with Operators CASE and IIF Statement

 

Module 7: Aggregate Functions / String Functions / Date & Time Functions

          •   Using String functions in Queries
          •      Count, Sum, Min, Max, Avg, Group by and Having Clauses Date time Functions
          •      Windows Functions / Analytical Functions  with Grouping sets, Rollup and Cube
          •       RANK Functions

 

Module 8: Set Operators

          •    Introduction of Set Operators and Types UNION, UNION ALL, INTERSECT, EXCEPT

Module 9: Sub Query’s

          • Introduction of Sub query’s
          •     Sub query’s, Co-Related Sub Query’s

Module 10: Joins

          •  Introduction to Joins and types
          •  Inner Join / Left Outer Join / Right Outer Join / Full Outer Join /Self-Join /Cross Join

 

Module 11: Table Expressions / Temporary tables

          • Derived Tables , Table variables, CTE (Common Table Expressions),Temporary Tables (Local,Global) PIVOT / UNPIVOT, Temporal tables.

Module 12: Working with Indexes

          • Heap structure vs. B-Tree Structure Format Types Of indexes
          • Clustered Index, Non-Clustered Index, Filter Index, Covering Index, Column Store index, Index Scan, Index Seek, Index Re-Organize and Index -Rebuild

Module 13: Implementing Views & partitions

          •    Introduction & Advantages of Views
          •    Types of Views (Simple / Complex / Materialized) Creating, Altering, Dropping Views
          •    SQL Server Catalogue Views (System Defined Views)

 

Module 14: Transactions

          •     ACID Properties, ISOLATION Levels, Locks.
          •    Transact-SQL (T-SQL)

Module 15: Basics of T-SQL Programming

          • Variables Introduction & Types of Variables and Usage IF – Else, While structure programs.
          • System functions

 

Module 16: Working with Stored Procedures (SP/Procs)

          • Introduction to stored procedures
          • Syntax of Creating, Executing, Altering, Dropping of Procedures Input–Output and Optional Parameters
          • Procedure Optimization techniques Error Handling in Stored Procedures
          • Stored procedures vs. User defined functions

 

Module 17: Working with Functions (UDF)

          • User Defined Functions and types Of UDF Creating, Altering and Dropping Functions
          •   Scalar Functions, Inline Table Valued Functions, Multi Statement Table Valued Functions

 

Module 18: Implementing Triggers

          • Introduction to triggers Constraints vs Triggers
          • Creating, Altering, Dropping triggers Magic Tables
          • Instead of Triggers

Module 19: Working with Cursors

          • Introduction of cursors , Advantages of cursors, Creating Cursors, Types of cursors, Locks on cursors

 

Module 20: Backup and Restore

          • Generating & executing SQL Script
          • Taking database Backup and Restoring database using backup

Module 21: Query Performance Techniques & XML Data Types

          • Query Optimization Techniques and SQL Profiler Overview.

Module 22: SQL Server Agent (Job Schedules)

          •    Introduction of SQL Server Agent
          •    Create a Job and Schedule a time to Process data automatically

Module 23: REAL-TIME PROJECT on BANKING / Retail Domain

 

 

Power BI

Power BI Complete Introduction

          • Power BI Introduction, Brief History of Power BI, Data, Data Visualization, Reporting, Business Intelligence (BI), Traditional BI,Self-Serviced BI, Cloud Based BI, On Premise BI.
          • Power BI Report Server, Power BI Service, Power BI Mobile, Paginated Reports
          • Flow of Work in Power BI / Power BI Architecture
          • Power BI Desktop Installation and Hands on practice

PBI Desktop & Power View Overview

          • Power BI Desktop Components (Power Query, Power Pivot, Power View, Power Map, Q&A, Data Gateway)
          • Building Blocks of Power BI (Fields, Filters, Visualizations, Reports, Data, Model Dashboards and Tiles)
          • Data Connectivity Modes (Import, Direct, Live & Composite Models)
          • Get Data Connecting Multiple source and represent the data
          • Overview of default and Custom visualizations
          • Power BI Desktop User Interface.
          •  Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas, Visual Edit Interactions, Sync Slicer, Selection Pane, Buttons, Book Marks, Conditional formatting.




Power View

          • Report View User Interface Fields Pane, Visualizations pane, Ribbon, Views, Pages Tab, Canvas, Visual Interactions, Interaction Type (Filter, Highlight, None) Visual Interactions Default Behaviour, Changing the Interaction.
          • Filter Types, Visual Level Filters, Page Level Filters, Report Level Filters, Drill Through Filters,
          •  Filter Sub Types, Basic Filtering, Advanced Filtering, Top N, Relative Date Filtering
          •  Numeric field filters, Text field filters, Date and Time field Filters

Hierarchies and Drill-Down Reports

          • Hierarchy Introduction, Default Date Hierarchy, Creating Hierarchy, Creating Custom Date Hierarchy, Change Hierarchy Levels, Drill-Up and Drill-Down Reports, Data Actions, Drill Down, Drill Up, Show Next Level, Expand Next Level, Drilling filters other visuals option

Power BI Visualizations

          • Visualizing Data
          •  Visualization types
          •  Field Values
          •  Visuals for Filtering
          •  Visualizing
          •  Categorical Data
          •  Visualizing Trend Dat
          •  Visualizing KPI Data
          •  Visualizing Tabular Data
          •  Visualizing Geographical Data
          •  Leveraging Power BI Custom Visuals

Visuals for Filtering

          •  Slicer / Sync Slicer Visualization
          •  When to use a Slice
          •  Create and format Slicer Visualization
          •  Hierarchy Slicer (Custom Visualization)
          •  When to use a Hierarchy Slicer
          •  Create and format Hierarchy Slicer
          •  Advantages of Hierarchy Slicer

Visualizing Categorical Data

          • Create and Format Bar and Column Charts, Create and Format Stacked Bar Chart Stacked Column Chart, Create and Format Clustered Bar Chart, Clustered Column Chart, Create and Format 100% Stacked Bar Chart, 100% Stacked Column Chart, Create and Format Pie and Donut Charts, Create and Format the Tree Map Visual, Create and Format Scatter Charts

Visualizing Trend Data

          •  Line Chart, Area Charts, Create and Format Line Chart, Area Chart, Stacked Area Chart, Combo Charts, Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart, Create and Format Ribbon Chart, Waterfall Chart, Funnel Chart

Visualizing KPI Data

          • Create and Format Gauge Visual, KPI Visual, Create and Format Card Visualization, Multi Row Card
          • Visualizing Tabular Data, Geographical Data & R Script Visual
          • Create and Format Table Visual, Matrix Visualization, Create and Format Map Visual, Filled Map Visual, Arc GIS Maps Visual, Create and Format R Script Visual
          • Interview Questions Discussion and Practical Scenario based Tasks

Power Query Editor \ Transform Editor

          • Introduction to Power Query – Extract, Transform and Load (ETL)
          • The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar, Advanced Editor – Complete ETL Code.
          • Overview of Power Query / Transform Editor
          • Data types, Changing the Data type of a Column
          • Filters in Power Query, Auto Filter / Basic Filtering, Filter a Column using Text Filters
          • Filter a Columns using Number, Date and Text

Inbuilt Column Transformations

          • Remove Columns / Remove Other Columns
          • Name / Rename a Column
          • Reorder Columns or Sort Columns
          • Add Column / Custom Column
          • Split Columns
          • Merge Columns
          • PIVOT, UNPIVOT Columns
          • Transpose Columns
          • Invoke functions

In built Row Transformations

          • Header Row or Use First Row as Headers
          • Keep Top Rows
          • Keep Bottom Rows
          • Keep Range of Rows
          • Keep Duplicates
          • Keep Errors
          • Remove Top Rows
          • Remove Bottom Rows
          • Remove Alternative Rows
          • Remove Duplicates
          • Remove Blank Rows
          • Remove Errors
          • Group Rows / Group By

Combine Queries (Append Queries & Merge Queries)

          • Append Queries, Append Queries as New
          • Append 2 or more files individually with different queries
          • Appending multiple files of same type from a folder using single query
          • Query Options
          • Copy Query
          • Paste Query
          • Delete Query
          • Rename Query
          • Enable Load
          • Include in report Refresh
          • Duplicate Query
          • Reference Query
          • Move to Group
          • Move Up
          • Move Down

 

Merge Queries / Join Queries

          • Merge Queries, Merge Queries as New
          • Default Types of Joins / Join Kinds / Merge Type
          • Left Outer (all from first, matching from second)
          • Right Outer (all from second, matching from first)
          • Full Outer (all rows from both)
          • Inner (only matching rows)
          • Left Anti (rows only in first)
          • Right Anti (rows only in second)

Grouping, Binning & Sorting

          • Grouping and Binning Introduction
          •  Using grouping
          • Creating Groups on Text Columns
          • Using binning
          •  Creating Bins on Number Column and Date Columns
          •  Sorting Data in Visuals
          •  Changing the Sort Column
          •  Sort Order
          •  Sort using column that is not used in the Visualization
          •  Sort using the Sort by Column button

Power Pivot (DAX)

Power BI Data Modeling – Relationship View

          •  Data Modeling Introduction
          •    Relationship, Need of Relationship
          •    Relationship Types / Cardinality in General
          •    One-to-One, One-to-Many (or Many-to-One), Many-to-Many
          •    AutoDetect the relationship, Create a new relationship, Edit existing relationships
          •    Make Relationship Active or Inactive
          •    Delete a relationship
          •    Cross filter direction (Single, Both), Assume Referential Integrity

 

Enhancing the Data Model – DAX

          • Introduction of DAX, Calculated Columns, Measures, Example of Creating Calculated Columns, Creating Measures and Calculated Tables, Implicit Vs Explicit Measures, Row Filter vs. Context filters, DAX Operators, Types of Operators, Arithmetic Operators, Comparison Operators, Text Concatenation Operator, Logical Operators.

DAX Functions Categories

          • Date and Time Functions
          • Text Functions
          •    Logical Functions
          •    Aggregate Functions
          •    Filter Functions
          •    Information Functions
          •    Relationship Functions
          •    Time Intelligence Functions
          •    Table Manipulation Functions

Date & Time Functions 

          • YEAR, MONTH, DAY, WEEKDAY, WEEKNUM, FORMAT (Text Function) a Month Name, Weekday Name
          • DATE, TODAY, NOW, HOUR, MINUTE, SECOND, TIME,DATEDIFF, CALENDAR, Calendar Auto, Creating Date Dimension Table

Text Functions

          • COMBINEVALUES,CONCATENATE,CONCATENATEX,EXACT,FIND,FORMAT,LEFT,LEN,LOWER,REPLACE, RIGHT,SEARCH,SUBSTITUTE,TRIM,UPPER,VALUE
          • Logical Functions
          • IF, TRUE, FALSE, NOT, OR, IN, AND, IFERROR, SWITCH

Aggregate Functions

          • AVERAGE, AVERAGEA, AVERAGEX, COUNT, COUNTA, COUNTAX, COUNTBLANK, COUNTROWS, COUNTX, DISTINCTCOUNT, DISTINCTCOUNTNOBLANK ,MAX, MAXA, MAXX, MIN, MINA, MINX, SUM, SUMX.

 

Filter Functions

          • ALL,ALLCROSSFILTERED,ALLEXCEPT,ALLSELECTED,CALCULATE,CALCULATETABLE,EARLIER,EAR LIEST,FILTER, KEEPFILTERS,LOOKUPVALUE,SELECTEDVALUE

Information Functions

          • CONTAINS
          • HASONEFILTER
          • HASONEVALUE
          • ISBLANK
          • ISCROSSFILTERED
          • ISEMPTY
          • ISERROR
          • ISFIL TERED
          • SELE CTEDMEASURE
          • USERNAME
          • USEROBJECTID
          • USERPRINCIPALNAME.

Relationship Functions

          • CROSSFILTER
          • RELATED
          • RELATEDTABLE
          • USERELATIONSHIP

Time Intelligence Functions

          • CLOSINGBALANCEMONTH, CLOSINGBALANCEQUARTER, CLOSINGBALANCEYEAR, DATEADD, DATESBETWEEN, DATESINPERIOD, DATESMTD, DATESQTD, DATESYTD, ENDOFMONTH, ENDOFQUARTER, ENDOFYEAR, FIRS TDATE, FIRSTNONBLANK, LASTDATE, LASTNONBLANK, NEXTDAY, NEXTMONTH, NEXTQUARTER, NEXTYEAR, O PENINGBALANCEMONTH, OPENINGBALANCEQUARTER, OPENINGBALANCEYEAR, PARALLELPERIOD, PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR, SAMEPERIODLASTYEAR, STARTOFMONT H, STARTOFQUARTER, STARTOFYEAR, TOTALMTD, TOTALQTD, TOTALYTD

Table Manipulation Functions

          • ADDCOLUMNS, CROSSJOIN, DISTINCTcolumn, DISTINCTtable, EXCEPT, FILTERS, GENERATESERIES, GROUPBY, I NTERSECT, NATURALINNERJOIN, NATURALLEFTOUTERJOIN, ROLLUP, ROLLUPGROUP, SELECTCOLUMNS, SU MMARIZE, SUMMARIZECOLUMNS, TOPN, UNION, VALUES

Power BI Service (Admin Activities)

Power BI Service Introduction

          • Power BI Service Introduction, Power BI Cloud Architecture, Creating Power BI Service Account, SIGN IN to Power BI Service Account, Publishing Reports to the Power BI service, Import / Getting the Report to PBI Service, My Workspace / App Workspaces Tabs, DATASETS, WORKBOOKS, REPORTS, DASHBOARDS, Working with Datasets, Creating Reports in Cloud using Published Datasets, Power BI Datasets Live Connection using Desktop, Working with Workbooks, working with Reports, Sharing Reports

Dashboards Development

          • Creating Dashboards, Pin Visuals and Pin LIVE Report Pages to Dashboard, Advantages of Dashboards, Interacting with Dashboards, Adding Tiles to Dashboards, Web Content, Image, Text Box, Video, Formatting Dashboard, Sharing Dashboard

 

Data Gateways

          • Introduction to Data Gateways, Download Data Gateway , Installing a Data Gateway, Types of Gateways, On-premises Data Gateway(Standard Gateway), On-premises Data Gateway (personal mode\Private),Data Gateways work Connect to an on premise Data Source by using a Data Gateway, Manage Data Gateway, Add and Remove Administrators, Add Data Source, Add or Remove Users to a Data Source, Refresh On Premise Data, Configuring Automatic Refresh using Schedules

 

Collaboration in Power BI using App Workspace

          • Introduction to App Workspaces, Create an App Workspace, Add Members to App Workspace to Collaborate, App Workspace Roles Access, Admin, Member, Contributor, Assign Workspace to Deployment Pipelines.

Sharing Power BI Content using Apps and Content Packs

          • Introduction to App, Publish an App, Update a Published App, Organization, Specific individuals or group, Un publishing an App, Content Pack Introduction, Create Content Pack, Sharing Content Packs, Specific Groups, My Entire Organization

Row Level Security in Power BI (RLS)

          •  Introduction to Row Level Security, Row Level Security (RLS) with DAX Dynamic & Static, Manage Roles, Creating Roles, Testing Roles, Adding Members to Roles in Power BI Service, Dynamic Row Level Security, Creating Users Table and Adding to the Model, Capturing users using Username () or UserPrincipalName () Functions.

Data Flows

          • Over view of Datasets & Data Flows.

 

Report Server, Report Builder

          • Need for Report Server in PROD, Install, Configure Report Server, Report Server DB, Temp Database, Web service URL, Web portal URL, Power BI DesktopRS, Uploading Interactive Reorts, Report Builder, Report Builder For Power BI Cloud, Designing Paginated Reports (RDL), Deploy to Power BI Report Server, Data Source Connections, Report, Power BI Report Server to Cloud, Tenant IDs, Mobile Report Publisher.

 

Real-time Projects on [Sales & Customers & Education] domains Resume, Project Oriented FAQs and Solutions

 

 

KOSMIKTECHNOLOGIES CLASS IS ONE OF THE BEST DATA ANALYST  OFFLINE & ONLINE TRAINING INSTITUTES IN HYDERABAD, KUKATPALLY/KPHB

Data Analyst training institutes Hyderabad, Kukatpally at kosmik Training Institute covers topics from beginner level to advanced level. Finally, by the end of Data Analyst Course in Hyderabad you can be confident with Data Analyst Training in hyderabad.

Data Analyst training in Kukatpally,KPHB consists of assignments and completely real-time practical Data Analyst job oriented training in Hyderabad . He explains the difficult topics for beginners with ease, provides best Data Analyst examples and makes the student comfortable with the Data Analyst computing training in hyderabad .

 

 

Kosmik is the best Data Analyst training institute Hyderabad,KPHB. We are providing Data Analyst Training in hyderabad & lab facilities with complete real-time Data Analyst training. Devops Training in Kukatpally is based on complete advance concepts. So that you can get easily "hands-on experience". We will give 100% job assistance.Data Analyst Training in kphb, Data Analyst Training in Kukatpally,Data Analyst Training in Telangana, Data Analyst training institutes in hyderabad, Data Analyst course in hyderabad.