Data Analyst
  • Data

Data Analyst

  • From Breitskills By From Breitskills
  • 10/09/2024
  • 150 Students

Course Description

​

What you'll learn?

​

How to gather, clean, and prepare data for analysis using tools like Excel, SQL, and Python.

Fundamental concepts of statistics, including probability, distributions, hypothesis testing, and regression analysis, to understand and interpret data.

Techniques to represent data visually using tools like Tableau, Power BI, or Matplotlib, to communicate insights effectively.

Writing SQL queries to extract and manipulate data from databases, and understanding relational databases.

Creating data models to identify patterns and relationships within data, and understanding how to structure data for analysis.

An introduction to basic machine learning concepts and algorithms, including classification, clustering, and predictive Modeling.

How to create comprehensive reports and dashboards, and communicate findings clearly to stakeholders.

Understanding the role of data in business decision-making and learning how to align data insights with business objectives.

​

Who learn Data Analyst?

​

  • Students and Fresh Graduates
  • ​Career Changers​
  • Accountants
  • Professionals
  • Working Professionals
  • IT and Software Professionals
  • Sales and Marketing Professionals
  • HR Professionals
  • Consultants
  • Researchers and Academics

Read the highlights which matters

Course Syllabus

Syllabus matches the industry level even you try to skip you can't because we take care of your journey.

  1. ​Intro about MySQL
  2. MySQL Features
  3. MySQL Advantages
  4. Download and Installation

  1. Create Database
  2. Drop Database
  3. Show Databases
  4. Select Database

  1. Create Tables
  2. Drop Tables
  3. Show Tables
  4. Alter Tables
  5. Insert Records
  6. Delete Record(s)
  7. Truncate Table
  8. Copy & View Tables

  1. What are Constraints?
  2. Types of Constraints
  3. Import Data
  4. Update Query
  5. Delete Query
  6. Select Query

  1. Where clause
  2. AND, OR
  3. IN & between
  4. Like Statement
  5. Limit the record
  6. Order by Clause
  7. Group by Clause
  8. Having Clause

  1. IS NULL
  2. IS NOT NULL
  3. CASE Statement
  4. IF Statement

  1. What is Joins?
  2. Types of Joins
  3. Inner Join / Join
  4. Left Join
  5. Right Join
  6. Natural Join
  7. Full Join
  8. Self Join
  9. Cross Join


  1. Count ()
  2. Sum ()
  3. Avg ()
  4. Max ()
  5. Min ()
  6. Sub-Queries ()
  7. Index
  8. Exists
  9. Show first record and last record
  10. Concatenate ()
  11. Round ()

  1. Union
  2. Union All
  3. Intersect
  4. Except

  1. Primary Key
  2. Foreign Key
  3. Composite Key

  1. Ranking Function
  2. Analytical Function
  3. Cast & convert
  4. Alias

  1. IN
  2. OUT
  3. IN OUT

  1. Date & Time Functions
  2. String Function
  3. Numerical Function

  1. Intro about Power BI
  2. PBI Features
  3. PBI Advantages
  4. PBI Components
  5. PBI Architecture
  6. Sample Dashboard
  7. Download and Installation

  1. All Bar & Columns Charts
  2. Pie Charts
  3. Donut Charts
  4. Funnel Charts
  5. Scatter and Bubble Charts

  1. Types of Map Charts
  2. Map with Pie Charts
  3. Formatting Maps

  1. Table Charts
  2. Formatting Tables
  3. Conditional Formatting in Table
  4. Aggregate Functions in Table
  5. Matrix Charts
  6. Conditional Formatting in Matrix
  7. Aggregate Function in Matrix
  8. Matrix Hierarchies

  1. Types of Cards
  2. Text Cards
  3. Formatting Cards
  4. Date Cards
  5. Number Cards

  1. Types in Filters
  2. Filters on Visual
  3. Filters in Page
  4. Filters in all Pages
  5. Drill through in Pages

  1. Types in Slicers
  2. Text Slicers
  3. Formatting Slicers
  4. Date Slicers
  5. Hierarchies in Slicers
  6. Number Slicers
  7. Sync Slicers

  1. Drill down Donut & Combo Charts
  2. Word Cloud
  3. Sankey Charts
  4. Play Axis
  5. Scroller
  6. Animated bar Charts

  1. Line Charts
  2. Area Charts
  3. Ribbon Charts

  1. Water Fall Charts
  2. Gauge
  3. KPI
  4. Tree Map
  5. Insert Image, Buttons and Types
  6. Shapes and Types
  7. Insert Text box
  8. Web URL action
  9. Page Navigations

  1. Merge
  2. Split and Trim
  3. Upper & Lower
  4. Prefix and Suffix
  5. Left, Right & Mid
  6. Extract data from delimiter

  1. Year
  2. Quarter
  3. Month
  4. Day
  5. Hour, Minute, Second
  6. Age

  1. Split & Merge Text
  2. Alphanumeric
  3. Date column

  1. One Column
  2. Two Column
  3. Compare Column
  4. Date Comparison

  1. Intro about DAX
  2. Data Modeling
  3. Basic DAX Function

  1. Date Functions in DAX
  2. Text Functions in DAX
  3. Logical Functions in DAX

  1. Columns vs Measures
  2. Types of Measures
  3. Analyze using Measures

  1. Previous day, month, qtr., year
  2. Next day, month, qtr., year
  3. Date-add function
  4. MTD, QTD, YTD
  5. Filter Function
  6. Calendar, Calendar auto ()

  1. Sample Report Creation
  2. Publish to PBI service account
  3. Export into PPT, PDF
  4. Dashboard
  5. Quick Insights
  6. Automatic Refresh using Gateway

  1. What is Data Flow?
  2. Parameters, IF Parameter
  3. Dynamic Titles
  4. Cross report drill through
  5. Extract data from web, server etc..
  6. AI in BI

  1. Remove rows and Keep rows
  2. Replace Errors and Values
  3. Remove and Go to Columns
  4. Fill up and down
  5. Grouping
  6. Transpose
  7. Pivot and Unpivot Columns

  1. What is Python?
  2. Advantages
  3. Download and install
  4. Basics
  5. Comments
  6. Variables

  1. Types of Data
  2. Numeric Data Type
  3. String Data Type
  4. List Data Type
  5. Tuple Data Type
  6. Set Data Type
  7. Dictionary Data Type
  8. Taking input (s) from user
  9. Formatting Output
  10. Format ()

  1. Arithmetic Operator
  2. Comparison Operator
  3. Logical Operator
  4. Assignment Operator
  5. Membership Operator
  6. Identity Operator

  1. If, If-elif, If-elif-else
  2. Break statement
  3. Continue statement
  4. For loop
  5. While loop

  1. Create Function
  2. Calling Function
  3. Arguments
  4. Number of Arguments
  5. Arbitrary Arguments *args
  6. Keyword Arguments
  7. Arbitrary Keyword Arguments **kwargs
  8. Class and Objects

  1. Open a File
  2. Read a File
  3. Write a File
  4. Print the File
  5. Close a File
  6. Exception – Try and Except

  1. Array
  2. Indexing
  3. Slicing
  4. Copy and View
  5. Array Join
  6. Split
  7. Search
  8. Sort
  9. Create Table in NumPy

  1. What are Pandas?
  2. Series
  3. DataFrame
  4. Read CSV
  5. Create Table using Pandas
  6. Variables

  1. Line Chart
  2. Markers, Labels, Colors, Grid
  3. Sub Plots
  4. Scatter
  5. Bar Chart
  6. Pie Chart

  1. Conditional Formatting
  2. Advance Filter
  3. Data Sorting
  4. Data Validation
  5. Data and Time Function
  6. Text Function
  7. Charts and Types
  8. Lookup, Hlookup, Vlookup
  9. IF Conditions
  10. Sum, Sumif, Sumifs
  11. Count, Countif, Countifs
  12. Pivot Table
  13. Slicer
  14. Index
  15. Match
  16. Goal Seeks
  17. Cell References
  18. Top Shortcuts
From Breitskills

From Breitskills

We are industry exports in Data Analyst are ready to teach you the lesson which matters, are you ready to learn the values. Tutor has 12+ years industry experience and Microsoft Certified

img
Course includes:
  • Lessons 4
  • Duration 3 Months
  • Language English - Tamil - Telugu
  • Certifications Yes
  • Resource Access Source files
Enquire Now

Download Course