DATA ANALYTICS CLASS

Audience: Professionals, Students and Non-Tech Professionals

What you’ll learn in this Data Analytics Training

Explore our comprehensive Data Analytics class designed to empower you with essential skills in Advanced Excel, PowerBI, Tableau, and SQL.

Course Overview

  • No Prerequisite Knowledge required: Beginners to Pro
  • Live Online Session: Class is purely online on zoom on weekdays and weekends
  • Get Course content: Get downloadable course materials and recorded videos 
  • Purely Hands-on: Do a project work after each module to use as portfolio
  • Certificate of completion: Get a certificate of completion after the class
  • Master Advanced Excel: Functions and Formulas, macros, data validation, Pivot Table and advanced data visualization.
  • Harness PowerBI: Create interactive reports, connect to diverse data sources, perform transformations, and visualize data.
  • Explore Tableau: Create dynamic dashboards, connect to data sources, and tell compelling data stories.
  • Proficiency in SQL: Write queries to manage, analyze, and summarize data from relational databases.
  • Equip yourself for data-driven roles: Gain essential skills for career advancement in data analytics and decision-making.

What You will learn in Excel

Introduction to Data Analytics

  • Data analytics and Business Intelligence
  • Data Analysis Pipeline, Data Literacy, Data Privacy etc
  • Skills required as a Data Analyst

Microsoft Excel fundamentals

  • Working with sheets and workbooks
  • Excel formulas and functions

Advanced Excel formulas and Functions

  • Using Defined names
  • Dynamic Arrays

Analyzing Data with PivotTables and Charts

  • Analyzing data with PivotTables and charts
  • Slicers and Timelines

     

    What You will learn in Excel

    Introduction to Power Query

    • Working with External Data sources such as Databases, folders, PDF etc

    Cleaning and transforming Data

    • Data transformation
    • Merging and appending data
    • Grouping and summarizing data

    Data Modeling and Power Pivot

    • Introduction to Data Modeling
      • Dimensions and fact tables
      • Primary and foreign keys
      • Creating and managing relationships

    Excel Automation

    • Introduction to Macros

    What You will learn in PowerBI

    Get started with Microsoft data analytics

    • Getting started with Power BI
    • PowerBI Dashboard Overview

    Importing Data into Power BI

    • Work with external data sources such as databases, excel workbooks, PDFs, and folders.

    Cleaning and transforming Data

    • Basic Data transformation
    • Merging and appending data
    • Grouping and summarizing data

    Visualization in Power BI

    • Work with Power BI visuals
    • Improving users experience with Bookmarks, tooltips, drill-downs and buttons
    • Create a data-driven story with Power BI reports
    • Creating reports and dashboards in Power BI

    What You will learn in PowerBI

    Modeling data in Power BI

    • Design a data model in Power BI
    • Schemas: Star and snowflake schemas
    • Manage Relationships
    • Cardinality and Cross Filter Direction
     

    Analyzing Data with DAX

    • DAX Measures
    • Aggregate functions and iterators
    • Time Intelligence calculations
    • Logical and Conditional Functions
    • Calculate, Filters and Divide Functions
    • Calculated Columns and Calculated Tables

        Sharing and consuming Power BI Reports

        • Sharing reports on Microsoft Teams
        • Generating Power BI reports as PowerPoint slides for presentations
        • Sharing report on the web
        • Embedding reports on websites

        What You will learn in SQL

        Introduction to Databases, SQL, and Microsoft SQL Server

        • Installing SSMS and Azure Data Studio
        • Introduction to SQL, RDBMS, Databases and Tables
        • SQL Data Types and constraints
        • Creating Databases and Tables
        • Inserting, Updating and Deleting Records

        Data manipulation language

        • Querying data with SELECT
        • Filtering data with conditional statements- Where Clause, Operators etc
        • Sorting Data with OrdeBy
        • Aliases

        Introduction to Aggregate functions

        • Summarizing and aggregating data with aggregate functions

        Grouping and Filtering Data

        • GROUP BY with one column
        • GROUP BY with multiple columns
        • HAVING CLAUSE

        What You will learn in SQL

        SQL Joins

        • Types of SQL Joins
        • Analyzing data from multiple tables with Join

            Mastering SQL Advanced Queries

            • Case Statements
            • Subqueries
            • Creating SQL Views
            • CTEs

            Mastering Text/String/Date Functions

            • CONCAT, LEN, ROUND, COALESCE, UPPER etc
            • DATEPART, GETDATE, YEAR

            Working with Window functions

            • Partitioning data
            • Ranking data with RowNum, Rank and DENSE Rank
            • Time intelligence with LAG and LEAD