default-logo


Book Free Demo

Power BI Training in Chennai

Greens Technology offers comprehensive Power BI training in Chennai, designed to equip learners with expertise in data visualization, reporting, and business intelligence. The training program includes hands-on experience with real-world projects, interactive sessions, and industry-relevant case studies. Covering essential concepts such as data modeling, DAX, Power Query, and dashboard creation, the structured curriculum is suitable for both beginners and professionals. With expert guidance and practical learning, this training empowers individuals to master Power BI and advance their careers in data analytics.

Technologies You Will Learn

Power BI Logo
SQL Logo
python Logo
Tableau Logo
power automate Logo
Power apps Logo

why to choose - Call to action Form Image


Greens Technologies

Popular Courses

Greens Technology offers Power BI Training in Chennai, covering data visualization, DAX, Power Query, and interactive dashboards. Gain hands-on experience with real-world projects and expert-led guidance to advance your career in data analytics.


Start Course

Power BI Combo 1

Course 1

POWER BI + POWER BI SERVICE + SQL


  • 30+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Power BI Combo 2

Course 2

POWER BI + POWER BI SERVICE + SQL + PYTHON


  • 40+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Data Analytics Combo 3

Course 3

TAB + TAB SERVER + PBI + PBI SERVER + SQL + PYTHON


  • 45+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Tableau Combo 4

Course 4

TABLEAU + TABLEAU SERVER + SQL


  • 30+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Tableau Combo 5

Course 5

TABLEAU + TABLEAU SERVER + SQL+PYT


  • 35+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Data Analytics Combo 6

Course 6

PBI + PBI SERVER + TAB + TAB SERVER + PYTHON


  • 40+ Hours + Placement Training

  • Live Projects & Assesments

  • Assured Placements

  • Offline | Online

Curriculum

 1.Overview & Introduction

  • Introduction to Power BI
  • Installing and setting up the software

2.Understanding Data Types and Data Modeling

  • Exploring different data types
  • Fundamentals of data modeling

3.DAX Functions

  • Aggregation Functions: SUM, AVERAGE, COUNT
  • Date & Time Functions: TODAY, YEAR, DATEADD
  • Logical Functions: IF, AND, OR, NOT
  • Filtering Functions: FILTER, ALL
  • Statistical Functions: MAX, MIN, MEDIAN
  • Text Functions: CONCATENATE, LEFT, RIGHT, MID
  • Information Functions: COLUMNNAME, COLUMNS, DATATABLE, ISBLANK, ISCOLUMN, ISERROR, ISEMPTY
  • Time Intelligence Functions

4.Power Query Editor

  • Data Source Connectivity: Importing data from files and databases
  • Data Transformation: Column renaming, data type modifications, duplicate removal, filtering, sorting, merging, pivoting, and unpivoting
  • Error handling techniques
  • Data loading and processing

5.Tracking Columns in Data

  • Column splitting and selection techniques
  • Join operations, data extraction, and formatting
  • Appending queries, duplicating queries, creating dimension tables, and merging queries

6.Data Visualization in Power BI

  • Dashboard creation and formatting

7.Power BI Service & Cloud Integration

  • Publishing reports and integrating with cloud platforms
  1. Introduction to Tableau – Overview of the interface, product features, and desktop functionalities.
  2. Understanding Data Types – Exploring various data types and their significance in Tableau.
  3. Data Connections – Learning about different types of data connections and their applications.
  4. Dimensions & Measures – Understanding their role in data analysis.
  5. Discrete & Continuous Data – Concepts and practical implementation.
  6. Tableau File Extensions – Overview and usage of different file formats.
  7. Advanced Data Manipulation – Utilizing groups, sets, combinations, parameters, combined sets, and hierarchies.
  8. Filtering Techniques – Implementing various filters such as data source, extract, dimension, measure, cascading, and context filters.
  9. Functions in Tableau – Working with numerical, aggregate, logical, string, table calculations, window functions, date functions, quick table calculations, null handling, and analytics.
  10. LOD Expressions & Bins – Understanding Level of Detail expressions and bins.
  11. Visual Representation – Exploring different axes, chart types, and mapping techniques.
  12. Filters & Mapping – Implementing interactive maps and filters in Tableau.
  13. Dashboard Development – Creating both basic and advanced dashboards.
  14. Dashboard Interactivity – Configuring actions to enhance user experience.
  15. Data Modeling – Understanding relationships, data blending, and best practices.
  16. Joins & Data Integration – Performing cross-database joins and understanding their applications.
  17. Tableau Server & Tableau Online – Introduction to publishing and managing data sources.
  18. Data Source Management – Working with embedded and published data sources.
  19. User Management & Security – Managing site roles, user access, and row-level security (RLS).
  20. Alerts & Automation – Implementing alerts, subscriptions, and performance metrics.
  21. Handling Data Extracts – Managing empty extracts and optimizing data workflows.
  1. Introduction & Setup – Understanding the basics and setting up the SQL environment.
  2. Database & Table Creation – Learning to create and manage databases and tables.
  3. Data Types & Operators – Exploring different data types and working with operators.
  4. Text Functions – Utilizing functions like UPPER(), LOWER(), and INITCAP() for text formatting.
  5. String Functions – Handling strings with SUBSTRING(), CONCAT(), LEN(), TRIM(), and REPLACE().
  6. Essential Functions – Working with date, numeric, null-handling, and general functions.
  7. Aggregation & Grouping – Using functions like COUNT(), SUM(), AVG(), MIN(), MAX(), along with GROUP BY and HAVING.
  8. Analytical & Window Functions – Performing advanced data analysis using built-in SQL functions.
  9. SQL Commands – Covering key commands for data definition, manipulation, transactions, and queries.
  10. Joins & Relationships – Understanding different join types (INNER, LEFT, RIGHT, FULL, CROSS).
  11. Constraints & Integrity Rules – Enforcing data integrity with constraints (NOT NULL, PRIMARY, UNIQUE, FOREIGN, DEFAULT, INDEX, CHECK).
  12. Set Operations – Learning operations like UNION, UNION ALL, MINUS, and INTERSECT.
  13. Views & Materialized Views – Creating and managing views for better data organization.
  14. Subqueries & Nested Queries – Writing efficient subqueries for complex data retrieval.
  15. Pseudo & Special Columns – Understanding special columns like ROWID, ROWNUM, LEVEL, CONNECT_BY_ISLEAF, and SYS_GUID().
  1. Environment Setup & Installation
    -Setting up Python, Anaconda, and Jupyter Notebook

  2. Understanding Programming Basics
    -Difference between Compilation and Interpretation
    -Writing and Running Your First Python Program

  3. Fundamentals of Python
    -Printing “Hello World”
    -Variables and Data Types
    -Operators and Their Applications

  4. Functions and Control Flow
    -Defining and Using Functions & Methods
    -Conditional Statements: if, if-else, elif
    -Looping Constructs: while loop, for loop

  5. Python Data Structures
    -Lists, Tuples, Sets, and Dictionaries
    -Iteration Tools: Map and Filter

  6. Working with Regular Expressions

  7. Modules, Packages, and Dependency Management
    Installing and Managing Libraries with PIP

  8. Exception Handling in Python

  9. Object-Oriented Programming (OOP) in Python

    -Classes and Objects
    -Constructors, Attributes, and Methods
    -Key OOP Concepts: Inheritance, Encapsulation, Polymorphism

  10. Advanced Python Concepts
    -Lambda (Anonymous) Functions
    -Generators and Closures

  11. Exploring Popular Python Libraries
    -Introduction to NumPy, Pandas, and Matplotlib

  1. Automating email delivery to a Gmail account with an attachment from OneDrive.
  2. Creating new groups automatically using Microsoft Forms.
  3. Scheduling automated emails for birthday and wedding greetings.
  4. Configuring Power BI alert notifications for Microsoft Teams and Outlook.
  5. Managing dataset refresh processes efficiently.
  6. Applying aggregate and grouping functions such as COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.
  1. Introduction
  2. Installation & Setup
  3. Developer Environment Overview
  4. Understanding Variables
  5. Working with Collections
    –
    Creating, Accessing, Modifying, Iterating, and Clearing Collections
  6. Automated Email Notifications for Birthdays & Key Events
  7. Canvas Apps & Model-Driven Apps
  8. Connecting to Data Sources
  9. Utilizing Controls & Expressions
  10. Managing Screens & Data Integration
  11. Dynamic Assignments & User Interactions
  12. Implementing Formulas, Variables, Collections, and Contextual Data
  13. Handling Controls, Properties, and User Inputs
  14. Functions Overview
    –
    Data Manipulation Functions
    -Control-Based Functions
    -Mathematical & Logical Functions
    -Text Formatting & Conversion Functions
    -Date & Time Operations
    -Input & Interaction Handling
  15. Formulas & Expressions
    –
    OnSelect, OnClick, Upper, Lower, Proper, Launch, Navigation, and more
  16. Building a Canvas App with SQL & SharePoint
  17. Implementing Data Validation with SQL & SharePoint
  18. Developing Forms & Galleries
  19. Performing CRUD (Create, Read, Update, Delete) Operations
  20. Creating Cascading Dropdowns
  21. Integrating Power BI with Power Apps
  22. Designing & Publishing Power BI Reports
  23. Generating & Embedding Power BI Reports in Power Apps
  24. Configuring Interactive Features
  25. Testing & Deployment

 1.Overview & Introduction

  • Introduction to Power BI
  • Installing and setting up the software

2.Understanding Data Types and Data Modeling

  • Exploring different data types
  • Fundamentals of data modeling

3.DAX Functions

  • Aggregation Functions: SUM, AVERAGE, COUNT
  • Date & Time Functions: TODAY, YEAR, DATEADD
  • Logical Functions: IF, AND, OR, NOT
  • Filtering Functions: FILTER, ALL
  • Statistical Functions: MAX, MIN, MEDIAN
  • Text Functions: CONCATENATE, LEFT, RIGHT, MID
  • Information Functions: COLUMNNAME, COLUMNS, DATATABLE, ISBLANK, ISCOLUMN, ISERROR, ISEMPTY
  • Time Intelligence Functions

4.Power Query Editor

  • Data Source Connectivity: Importing data from files and databases
  • Data Transformation: Column renaming, data type modifications, duplicate removal, filtering, sorting, merging, pivoting, and unpivoting
  • Error handling techniques
  • Data loading and processing

5.Tracking Columns in Data

  • Column splitting and selection techniques
  • Join operations, data extraction, and formatting
  • Appending queries, duplicating queries, creating dimension tables, and merging queries

6.Data Visualization in Power BI

  • Dashboard creation and formatting

7.Power BI Service & Cloud Integration

  • Publishing reports and integrating with cloud platforms
  1. Introduction to Tableau – Overview of the interface, product features, and desktop functionalities.
  2. Understanding Data Types – Exploring various data types and their significance in Tableau.
  3. Data Connections – Learning about different types of data connections and their applications.
  4. Dimensions & Measures – Understanding their role in data analysis.
  5. Discrete & Continuous Data – Concepts and practical implementation.
  6. Tableau File Extensions – Overview and usage of different file formats.
  7. Advanced Data Manipulation – Utilizing groups, sets, combinations, parameters, combined sets, and hierarchies.
  8. Filtering Techniques – Implementing various filters such as data source, extract, dimension, measure, cascading, and context filters.
  9. Functions in Tableau – Working with numerical, aggregate, logical, string, table calculations, window functions, date functions, quick table calculations, null handling, and analytics.
  10. LOD Expressions & Bins – Understanding Level of Detail expressions and bins.
  11. Visual Representation – Exploring different axes, chart types, and mapping techniques.
  12. Filters & Mapping – Implementing interactive maps and filters in Tableau.
  13. Dashboard Development – Creating both basic and advanced dashboards.
  14. Dashboard Interactivity – Configuring actions to enhance user experience.
  15. Data Modeling – Understanding relationships, data blending, and best practices.
  16. Joins & Data Integration – Performing cross-database joins and understanding their applications.
  17. Tableau Server & Tableau Online – Introduction to publishing and managing data sources.
  18. Data Source Management – Working with embedded and published data sources.
  19. User Management & Security – Managing site roles, user access, and row-level security (RLS).
  20. Alerts & Automation – Implementing alerts, subscriptions, and performance metrics.
  21. Handling Data Extracts – Managing empty extracts and optimizing data workflows.
  1. Introduction & Setup – Understanding the basics and setting up the SQL environment.
  2. Database & Table Creation – Learning to create and manage databases and tables.
  3. Data Types & Operators – Exploring different data types and working with operators.
  4. Text Functions – Utilizing functions like UPPER(), LOWER(), and INITCAP() for text formatting.
  5. String Functions – Handling strings with SUBSTRING(), CONCAT(), LEN(), TRIM(), and REPLACE().
  6. Essential Functions – Working with date, numeric, null-handling, and general functions.
  7. Aggregation & Grouping – Using functions like COUNT(), SUM(), AVG(), MIN(), MAX(), along with GROUP BY and HAVING.
  8. Analytical & Window Functions – Performing advanced data analysis using built-in SQL functions.
  9. SQL Commands – Covering key commands for data definition, manipulation, transactions, and queries.
  10. Joins & Relationships – Understanding different join types (INNER, LEFT, RIGHT, FULL, CROSS).
  11. Constraints & Integrity Rules – Enforcing data integrity with constraints (NOT NULL, PRIMARY, UNIQUE, FOREIGN, DEFAULT, INDEX, CHECK).
  12. Set Operations – Learning operations like UNION, UNION ALL, MINUS, and INTERSECT.
  13. Views & Materialized Views – Creating and managing views for better data organization.
  14. Subqueries & Nested Queries – Writing efficient subqueries for complex data retrieval.
  15. Pseudo & Special Columns – Understanding special columns like ROWID, ROWNUM, LEVEL, CONNECT_BY_ISLEAF, and SYS_GUID().
  1. Environment Setup & Installation
    -Setting up Python, Anaconda, and Jupyter Notebook

  2. Understanding Programming Basics
    -Difference between Compilation and Interpretation
    -Writing and Running Your First Python Program

  3. Fundamentals of Python
    -Printing “Hello World”
    -Variables and Data Types
    -Operators and Their Applications

  4. Functions and Control Flow
    -Defining and Using Functions & Methods
    -Conditional Statements: if, if-else, elif
    -Looping Constructs: while loop, for loop

  5. Python Data Structures
    -Lists, Tuples, Sets, and Dictionaries
    -Iteration Tools: Map and Filter

  6. Working with Regular Expressions

  7. Modules, Packages, and Dependency Management
    Installing and Managing Libraries with PIP

  8. Exception Handling in Python

  9. Object-Oriented Programming (OOP) in Python

    -Classes and Objects
    -Constructors, Attributes, and Methods
    -Key OOP Concepts: Inheritance, Encapsulation, Polymorphism

  10. Advanced Python Concepts
    -Lambda (Anonymous) Functions
    -Generators and Closures

  11. Exploring Popular Python Libraries
    -Introduction to NumPy, Pandas, and Matplotlib

  1. Automating email delivery to a Gmail account with an attachment from OneDrive.
  2. Creating new groups automatically using Microsoft Forms.
  3. Scheduling automated emails for birthday and wedding greetings.
  4. Configuring Power BI alert notifications for Microsoft Teams and Outlook.
  5. Managing dataset refresh processes efficiently.
  6. Applying aggregate and grouping functions such as COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.
  1. Introduction
  2. Installation & Setup
  3. Developer Environment Overview
  4. Understanding Variables
  5. Working with Collections
    –
    Creating, Accessing, Modifying, Iterating, and Clearing Collections
  6. Automated Email Notifications for Birthdays & Key Events
  7. Canvas Apps & Model-Driven Apps
  8. Connecting to Data Sources
  9. Utilizing Controls & Expressions
  10. Managing Screens & Data Integration
  11. Dynamic Assignments & User Interactions
  12. Implementing Formulas, Variables, Collections, and Contextual Data
  13. Handling Controls, Properties, and User Inputs
  14. Functions Overview
    –
    Data Manipulation Functions
    -Control-Based Functions
    -Mathematical & Logical Functions
    -Text Formatting & Conversion Functions
    -Date & Time Operations
    -Input & Interaction Handling
  15. Formulas & Expressions
    –
    OnSelect, OnClick, Upper, Lower, Proper, Launch, Navigation, and more
  16. Building a Canvas App with SQL & SharePoint
  17. Implementing Data Validation with SQL & SharePoint
  18. Developing Forms & Galleries
  19. Performing CRUD (Create, Read, Update, Delete) Operations
  20. Creating Cascading Dropdowns
  21. Integrating Power BI with Power Apps
  22. Designing & Publishing Power BI Reports
  23. Generating & Embedding Power BI Reports in Power Apps
  24. Configuring Interactive Features
  25. Testing & Deployment

Experience

Acquire practical experience through real-world Power BI projects, interactive dashboards, and industry-focused case studies to strengthen your data analytics skills.

Education

Our Data Analytics course delivers industry-relevant training, equipping you with the expertise to analyze, interpret, and visualize data for strategic decision-making.

Certificate

Obtain an internationally recognized Data Analytics certification, showcasing your expertise in data visualization, reporting, and business intelligence using Power BI.

Our Data Analytics Courses

Enhance your data expertise with our Power BI Training.



Get Started

Greens Technologies

Course Options:


Start Course

One-on-One Mentoring

Receive customized guidance through one-on-one mentoring with industry experts, ensuring tailored support to master Power BI and advance your data analytics skills.

Hybrid Learning

Our Power BI course features a hybrid learning approach, blending online and classroom training for a flexible and engaging experience.

Online Learning

Enjoy flexible and interactive online Power BI training with live instructor-led sessions and practical hands-on projects.

Fast-Track Courses

Our Fast-Track Power BI courses are structured for accelerated learning, enabling you to master data visualization and analytics efficiently.

Data Speaks Louder Than Words

Students Enrolled
0
+
Branches
0
Placed Students
0
+
Years Of Experience
0

Overall Key Features of Our Power BI Course

Hands-on Training

Gain hands-on experience through real-world projects and case studies.

Expert Instructors

Learn from seasoned industry experts with extensive experience.

Comprehensive Curriculum

Includes Power BI Desktop, DAX, Data Modeling, and Reporting.

Live Projects & Practical Exposure

Gain hands-on experience with real-world datasets and business scenarios.

Flexible Learning Options

Select from classroom, online, or accelerated training options.

Certification & Career Support

Gain a valued certification and receive job placement support.

Advanced Visualization Techniques

Gain expertise in interactive dashboards and data storytelling.

Placement Assistance

Receive expert interview guidance and job referrals from leading companies.

Student Hub

Model Resume Download Links

 

Software Download Links
Check Out Our SQL Compiler!

Greens Technology offers a powerful online SQL Compiler to help you practice and improve your SQL skills. Click the button below to get started.

Go to SQL Compiler

    Job Portals list

     

      Task 1: Introduction

      1. Display region-wise sales using a pie chart with profit and discount in the tooltip.
      2. Visualize date-wise sales with a line chart.
      3. Represent category and sub-category sales using a custom visualization.
      4. Create a Treemap with region and discount metrics.
      5. Develop a bubble chart with sub-category and profit as metrics.
      6. Design a box and whisker plot for state-wise sales.
      7. Generate 24 charts using custom metrics from the “Show Me” feature.

      Task 2: Level of Detail (LOD) Calculations

      1. Identify the last order date for each product.
      2. Determine the last product purchased by each customer.
      3. Create a visualization with category, sub-category, state, and sales, including total sales breakdown by sub-category.
      4. Categorize product counts within the range of 0–1000.

      Task 3: Analytics & Quick Table Calculations

      1. Forecast sales for 2021.
      2. Compare actual sales against target values.
      3. Cluster sub-categories based on data patterns.
      4. Create a text chart displaying region, segment, category, sub-category, and sales, with subtotal and row total calculations.
      5. Develop a bar chart showing average sales by region.
      6. Calculate the cumulative sales value for each customer.
      7. Compute the difference between previous and current sales by sub-category.

      Task 4: Dual Axis, Blended, Sync, and Filters

      1. Create a single visualization incorporating sales, discount, profit, and category.
      2. Compare profit and sales for the current year in a single chart.
      3. Implement a context filter using category and sub-category.
      4. Design a cascading filter for category and sub-category.

      Task 5: Grouping, Combining, Sets, Parameters & Hierarchies

      1. Identify and display the top-performing products based on profit.
      2. Show the top and bottom 5 sub-categories based on sales.
      3. Combine multiple graphs in a single sheet, utilizing profit, total sales, profit ratio, and sub-category.
      4. Implement a drill-down feature for product-related fields.
      5. Group and combine data using a custom visualization.
      6. Create a date parameter with the ship date, ensuring it updates across all charts.

      Task 6: Functions & Calculations

      1. Display the last date of the current month.
      2. Calculate the remaining days until the end of the year.
      3. Identify the last purchase date for each customer.
      4. Count the number of records within each sub-category.
      5. Convert “appliances” to “Appliances” by capitalizing the first letter.
      6. Count the number of sales for each category.
      7. Count unique sales for each category without duplicates.
      8. Find the second order date for each customer.
      9. List all customers whose names start with “A.”
      10. List all customers whose names end with “H.”
      11. Extract the year from the order ID.
      12. Categorize sales ranges:
      • >50,000: Good
      • >100,000: Very Good
      • >150,000: Excellent

      Task 7: Dashboard Development

      (A) Dashboard Requirements

      • Key Performance Indicators (KPIs):

        1. Total Sales
        2. Profit
        3. Sales per Customer
        4. Profit per Product
        5. Sales growth compared to the previous year
      • Additional Requirements:

        • Include two filters and one date parameter.
        • Develop at least six charts, including:
          • Year-over-Year (YOY) comparison
          • Four custom charts
          • One customized chart
          • One map visualization
        • Implement action filters for enhanced interactivity.

      Weekend Task 01: Customized Charts

      1. Waterfall Chart
      2. Donut Chart
      3. Butterfly Chart
      4. Pyramid/Funnel Chart
      5. Histogram Chart
      6. Heat Map & Tree Map using Profit and Sales

      Weekend Task 02: Dashboard Development

      • Create a dashboard using data from Tableau Public.
      • Implement two filters and a date parameter.

      Tableau Limitations

      • Maximum Rows: Unlimited
      • Maximum Columns: 50
      • Maximum Joins: 32 (Tables can be joined)
      • Default Join Type: Inner Join (modifiable)
      • Default Join in Blending: Left Outer Join
      • Maximum Worksheets: 155
      • Maximum Parameters: 155

      Power Query & Data Transformation

      • M Query & Power Query Editor
      • Data Modeling & DAX Functions
      • Power BI Visualization & Service

      Report & Data Views

      • Report View, Data View & Model View
      • Power Query Editor – ETL (Extract, Transform, Load)

      Data Transformation & Formatting

      • Transform Data Types (Whole Number, Decimal, Text, Date, Time, Boolean)
      • Modify & Format Data (Headers, Transpose, Rename, Replace, Fill, Move, Split, Merge)
      • Pivot & Unpivot Columns
      • Extract & Parse Data

      Statistical & Mathematical Functions

      • Sum, Minimum, Maximum, Average, Median, Standard Deviation
      • Count & Distinct Count
      • Addition, Subtraction, Multiplication, Division, Modulo, Percentages

      Scientific & Rounding Functions

      • Absolute Value, Power, Square Root, Logarithm, Factorial
      • Round, Round Up, Round Down

      Date & Time Functions

      • Age, Year, Month, Quarter, Week, Day, Start & End of Month
      • Date & Time Parsing, Hour, Minute, Second

      Data Column Management

      • Creating Custom, Index, Duplicate, Conditional, and Parameter Columns
      • Managing Data Sources, Entering Data, Refreshing & Editing Queries

      Merging & Appending Queries

      • Joins (Left, Right, Inner, Full Outer, Anti Joins)
      • Appending Multiple Data Tables

      DAX – Data Analytics Expressions

      • Calculated Columns vs. Measures
      • Date Functions (Today, Now, DateDiff, DateAdd, EOMonth)
      • Logical Functions (IF, AND, OR, IFERROR)
      • Text Functions (Upper, Lower, Trim, Concatenate, Search, Substitute)

      Time Intelligence Functions

      • Previous & Next Day, Month, Quarter, Year Comparisons
      • Year-to-Date (YTD), Quarter-to-Date (QTD), Month-to-Date (MTD)

      Data Filtering & Aggregation

      • Filters, ALL, ALLExcept, ALLSelected, VAR, ConcatenateX
      • Aggregate Functions (SUM, AVERAGE, MIN, MAX, COUNT, DISTINCT COUNT)
      • SUM vs. SUMX

      Data Visualizations & Reports

      • Chart Types, Filters, Relationships & Cardinality
      • Power BI Service Account Setup
      • Report Publishing, Sharing, Exporting, Downloading
      • Scheduled Refresh, Subscriptions, Alerts, Dashboard Creation

      SQL Overview

      SQL (Structured Query Language) is the standard language for database communication and management.

      Databases

      Databases are organized collections of structured data, managed by a DBMS. Common databases include Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and MongoDB.

      Tables

      Tables store data in a structured row-and-column format.

      Key SQL Components

      • Language: SQL
      • Database: SQL Server
      • Developer Tool: Microsoft SQL Server Management Studio

      SQL Usage

      • Store Data: Tables store information in a structured manner.
      • Manipulate Data: Modify, update, and organize data.
      • Retrieve Data: Use queries to extract specific information.

      SQL Tasks (Microsoft SQL Server & Management Studio)

      Day 1 – Restricting & Sorting Data (Part 1 & 2)

      • Write queries to filter data based on conditions.
      • Sort records in ascending or descending order.
      • Retrieve specific employee details based on criteria.
      • Display records for selected departments.
      • Use conditional operators to refine queries.

      Day 2 – Aggregate Functions

      • Count total employees.
      • Calculate average, highest, and lowest salaries.
      • Group data and filter results using WHERE and HAVING.
      • Summarize salary information by department and job roles.
      • Determine employee hiring trends by year, month, and weekday.

      Day 3 – Analytical vs. Aggregate Functions

      • Compare salary averages at different levels.
      • Compute cumulative sums and ranks for employees.
      • Use LAG and LEAD functions to track hiring trends.
      • Rank employees’ salaries within their respective departments.

      Day 4 – Date Functions

      • Extract and format dates.
      • Perform date arithmetic (add/subtract days, months, years).
      • Retrieve the first/last day of the month.
      • Calculate differences between dates in various formats.

      Day 5 – String Functions

      • Extract and modify text data.
      • Concatenate names and format phone numbers.
      • Search and filter records based on text patterns.
      • Replace or update specific words within text fields.
      • Extract domain names and substrings from email addresses.

      Day 6: CASE AND CONVERT FUNCTIONS

      CASE Function Questions:

      1. Write a query to display each employee’s last name and indicate whether they receive a commission. Show “No Commission” if the commission percentage is NULL and “YES Commission” otherwise.
      2. Determine if the current date falls on a weekend or a weekday.
      3. Categorize employees based on experience: “Junior” (<2 years), “Mid-Level” (2-5 years), and “Senior” (>5 years).
      4. Display a message indicating whether each employee’s salary is above or below the average salary. Label the column as ‘Salary Status’.
      5. Use the CASE function to classify job titles: “Management” for titles containing “Manager”, “Technical” for titles containing “Engineer”, and “Other” for all other titles.
      6. Classify employees into salary bands: “Low” (<$40,000), “Medium” ($40,000-$80,000), and “High” (>$80,000).

      CONVERT Function Questions:

      1. Convert the hire date column to ‘YYYY-MM-DD’ format as VARCHAR.
      2. Convert the Salary column to a currency format with two decimal places.
      3. Convert the hire date to “Month Day, Year” format (e.g., “August 22, 2024”).

      Combining CASE and CONVERT Functions:

      1. Use CASE to classify employees based on phone number length, then convert the length into a string.

      Day 7: DATA DEFINITION LANGUAGE (DDL)

      Creating and Modifying Tables:

      • Create an Employees table with columns: Employee ID (integer, primary key), First Name (VARCHAR(50)), Last Name (VARCHAR(50)), Hire Date (DATE), and Salary (DECIMAL(10,2)).
      • Modify the Employees table to add an Email Address column (VARCHAR(100)).
      • Alter the Salary column to allow NULL values.
      • Rename the Last Name column to Surname.

      Dropping and Renaming Tables:

      • Delete the Employees table from the database.
      • Rename the Employees table to Staff.

      Constraints and Indexes:

      • Add a unique constraint to the Email Address column.
      • Add a foreign key constraint to Employees referencing the Department ID column in the Departments table.
      • List all tables in the current database.
      • Create a Projects table with an ID (primary key), Project Name (VARCHAR(100)), Start Date (DATE), and Budget (DECIMAL(15,2)).

      Day 8: DATA MANIPULATION LANGUAGE (DML) & TRANSACTION CONTROL LANGUAGE (TCL)

      Data Manipulations:

      • Insert a new record into Employees: ID 101, First Name ‘John’, Last Name ‘Doe’, Hire Date ‘2023-05-15’, Salary 75000.
      • Update Employee ID 101’s Salary to 80000.
      • Delete Employee ID 101 from Employees.
      • Update Department ID to 5 for employees earning >70000.
      • Insert multiple records into Projects with appropriate values.
      • Select all employees and replace NULL values in Email Address with ‘No Email’.
      • Update all NULL values in Commission PCT to 0.
      • Insert multiple rows into Projects in a single query.
      • Delete records from Projects where Start Date < ‘2024-03-01’.
      • Update Email Address to ‘updated@example.com‘ for employees with Last Name ‘Doe’.

      Data Transactions:

      • Explain SQL transactions and their importance.
      • Describe the purpose of the COMMIT statement.
      • Explain the ROLLBACK statement.
      • Define a SAVEPOINT and its use in SQL Server.
      • Compare COMMIT, ROLLBACK, and SAVE TRANSACTION.

      Day 9: CONSTRAINTS

      Primary Key Constraints:

      • Create a Students table with Student ID (primary key), First Name, Last Name, and Date of Birth.

      Unique Constraints:

      • Create an Employees table with a unique Email column.

      Foreign Key Constraints:

      • Create Departments and Employees tables with a foreign key reference.

      Check Constraints:

      • Create a Products table with a check constraint ensuring Quantity >= 0 and Price > 0.
      • Modify Employees to add a check constraint on Salary (between 30,000 and 150,000).

      Default Constraints:

      • Create an Orders table with Status defaulting to ‘Pending’.
      • Add a default constraint to Order Date setting it to the current date if no value is provided.

      Composite Constraints:

      • Create a Course Enrollments table with a composite primary key (Student ID, Course ID).

      Unique Constraint:

      • Enforce uniqueness on First Name and Last Name combinations in Employees.

      Day 10: JOINS

      Part 1: Types of Joins

      • Inner Join: List employees and their department names.
      • Left Join: List employees and their job titles, including those without job titles.
      • Right Join: List departments and employees, including departments with no employees.
      • Full Outer Join: Show all employees and departments, even without assignments.
      • Self-Join: Display employees and their managers.
      • Cross Join: Generate all possible employee-department combinations.

      Part 2: SQL Queries

      • Display last name, department number, and name for all employees.
      • List unique job titles in department 80 and its location.

      Day 11-15: ADVANCED SQL CONCEPTS

      • Use UNION to combine two employee tables.
      • Use INTERSECT to find employees in both HR and IT departments.
      • Use EXISTS to check if a department has employees.
      • Create a view for active employees.
      • Create a stored procedure to insert employees.

      1. What is power query editor?
      2. What are the connection present in power bi?
      3. What is live connection?
      4. What is reference?
      5. What is duplicate?
      6. What is append and merge?
      7. What are the types of joins in power bi?
      8. What is query folding?
      9. What is m language?
      10. What is query dependency?
      11. What are the transformation will do in power query editor?
      12. What is dimension and measure?
      13. What is pivot and unpivot?
      14. What is groupbyfunction in power query editor?
      15. What is grouping and binning in power bi?
      16. What are the most common data shaping technique?
      17. What is data modelling
      18. What is dimension tableand fact table and also difference?
      19. What is star schema, snow flake schema?
      20. What is cardinality or relationship?
      21. How many cardinality are there in power bi?
      22. What relationship?
      23. How to implement relationship?
      24. How to implement many to many relationship?
      25. What bidirectional filter?
      26. How many active relationship we can create at a time during modelling?
      27. What is report view?
      28. What are the refresh in power bi?
      29. What is incremental refresh
      30. What is full refresh?
      31. How to implementation of incremental refresh?
      32. What is manage relationship? DATA VISUALISATION QUESTIONS:
      33. What is dax functions?
      34. What is rls and implementation
      35. Types of rls
      36. What is new column, new measure,new table?
      37. What calculated column, calculated measure?
      38. Diff sum between sumx?
      39. Diff between row context and filter context?
      40. Difff calculateand calculate table?
      41. Diff all, all except, all select & real time use case?
      42. What are the dax functions you have used?
      43. What are the functional groups in dax?
      44. What is time intelligence function ?
      45. How to connect relation in dax?
      46. What is cumulative dax functions
      47. Types of filter
      48. What is slicer and sync slicer?
      49. What is drill down and drill through
      50. Diff between filter and slicer
      51. What is book mark?
      52. What is book mark action?
      53. What is custom visuals?
      54. Explain what types charts have you used in your projects?
      55. Parameter (query parameter, visual parameter)
      56. What is performance tuning?
      57. What conditional formatting
      58. How you testing the reports?
      59. Difference between reports and dashboard?
      60. How you will get requirement or brd
      61. Limitation of import method?
      62. Maximum data size used in power bi
      63. What is summarize , summarizex?
      64. What is iteration function?
      65. What is power automate?
      66. What are the three fundamental concepts of dax
      67. Performance tuning (dax,datamodelling,visual,query editor)

      POWER BI SERVICE QUESTIONS:
      68. What is alert, subscription
      69. What is power bi service?
      70. What is gateway connectios and types?
      71. What is workspace?
      72. What is data flow?
      73. What is ccid pipeline?
      74. What is switch function?
      75. What is subscription and alert?
      76. Will you able create multiple workspace?
      77. What are the tabs available in power service?
      78. What is scd?
      79. What is paginated report?
      80. How to configure schedule refresh in power bi service? GENERAL QUESTIONS:
      81. What is power bi?
      82. Difference between power bi and tableau?
      83. Why you prefering power bi?
      84. Power bi latest version and updates
      85. What are the views present in power bi
      86. How to get data from data source?
      87. What is power q/a?
      88. What is power map?
      89. What are the components present in power bi?
      90. What is ssbi?
      91. What are the database have you used?
      92. Advantange and limitations of power bi?
      93. What data sources can power bi connect to?
      94. Where is data stored in power bi?

      Data warehousing questions
      1. What is data warehousing?
      2. Olap vs oltp
      3. Star schema and snowflake schema

      SQL interview question
      1. What are the available data types in SQL?
      2. What are the operators we have in SQL?
      3. What are the case manipulation functions?
      4. What are the character/string manipulation functions?
      5. What are the analytical functions in SQL,explain its types?
      6. What are the aggregate functions in SQL,explain its types?
      7. What are the null functions in SQL and explain its types?
      8. What are the date functions in SQL and explain its types?
      9. What is ddl, dml & tcl, dql commands?
      10. What are the joins available in SQL?
      11. What is a view & materialized view?
      12. What are the sub queries in SQL?
      13. What are the set operations?
      14. What are the pseudo columns?
      15. What is a like operator?
      16. What are the constraints

      SQL difference questions
      1. What is the difference between where and having?
      2. What is the difference between delete, drop & truncate?
      3. What is the difference between union and unionall?
      4. What is the difference between nvl, nvl2 & colasece?
      5. What is the difference b/w primary key & foreign key?
      6. What is the differences between in and equall to?
      7. What is the difference between case and decode?
      8. What is the difference between and and or?

      SQL queries
      1. Write query to find max salary from employee table?
      2. Write query to find 2nd max salary from employee table?
      3. Write query to find nth max salary from employee table?
      4. Write query to find max salary department wise?
      5. Write query to find nth max salary department wise?
      6. Write query to find employee & manager name?
      7. Write query to how to find and delete the duplicates?

      1. What is Tableau, Why it is used for
      2. What is data visualization
      3. What is Workbook, Worksheet, Dashboard and Story
      4. What are the data types in Tableau
      5. What is Dimensions and Measures
      6. What is Discrete and Continuous
      7. What is Aggregation and Disaggregation of data
      8. Types of file Extensions in Tableau
      9. What is Group and Combine
      10. What is Dynamic Group
      11. What is Set and Parameter
      12. What is Hierarchy and how you will create
      13. What are the types of connection in Tableau
      14. Types of Filters in Tableau
      15. What is Context filter and Cascading Filter
      16. Order of Execution of filterM
      17. What is Dual Axis, Blended Axis & Synchronizing Axis
      18. What are the Analytical Functions in Tableau
      19. What are the Dashboard Actions present in Tableau
      20. What are the Number Functions in Tableau
      21. What are the Aggregate Functions in Tableau
      22. What are the logical Functions in Tableau
      23. What are the String Functions in Tableau
      24. What are the Table calculation Function in Tableau
      25. What are the Date Functions in Tableau
      26. What is Data Blending
      27. What is Data Joining
      28. What is Relationship
      29. What is LOD and its types
      30. What is Bins
      31. What are the types of Joins
      32. What is Calculated Field
      33. What is Quick Table Calculation and types
      34. What are Worksheet Marks
      35. What are the Dashboard Actions
      36. What is Tiled and Floating
      37. How to increase Performance in Tableau/Performance Improvement
      38. How to overcome unknown location in Tableau
      39. What is Published Data Source
      40. What is Embedded Data Source
      41. What is KPI and What are the KPI’s used in your Project
      42. What are the Rank Functions in Tableau
      43. How is Context Filter different from other filter? What is the disadvantage of context filter
      44. What is Tableau Server
      45. What is User filter and Row level Security
      46. What is Incremental Refresh
      47. What is Tableau Data Engine/hyper
      48. Roles available in Tableau Server
      49. Limitations of Context Filter
      50. What is Data Extract in Tableau Server
      51. What is Alert and What is Subscription
      52. Performance tuning in Tableau
      53. How performance testing done in Tableau
      54. What is Normalization and Denormalization
      55. What is Granularity
      56. What is Boxplot Chart
      57. What is Scatter Chart
      58. What is Histogram Chart
      59. What is Dendogram Chart
      60. What is Waterfall Chart
      61. What is Referential Integrity
      62. What is cardinality
      63. What is set and where you have used
      64. What is Primary data and Secondary data
      65. How will you Change Primary and Secondary Data Source
      Difference between Questions
      1. Difference b/w twb and twbx
      2. Difference b/w Group and Combine
      3. Difference b/w Set and Parameter
      4. Difference b/w set and Group
      5. Difference b/w Heat map and Tree map
      6. Difference b/w Context filter and Cascading filter
      7. Difference b/w Dual Axis and Blended Axis
      8. Difference b/w Ceiling and Floor
      9. Difference b/w Ifnull, Isnull and Zn
      10. Difference b/w contains and endswith
      11. Difference b/w ltrim and rtrim
      12. Difference b/w first and last
      13. Difference b/w Rank and Rank_dence
      14. Difference b/w Today and Now
      15. Difference b/w Data blending and Data Joining
      16. Difference b/w live and Extract Connection
      17. Difference b/w Alert and Subscription
      18. Difference b/w Filters and Parameter
      Scenario Based Questions
      1. How to display top5 and bottom5 sales
      2. What are the KPI’s used in your Project
      3. What is the version you are using
      4. What are the unique features in every version of Tableau
      5. How to remove ‘All’ in Show Filters
      6. How to display * in measures
      7. How many data sources you can blend(5)
      8. How many tables you can Join(32)
      9. How many columns we can extend in Tableau(50) Default is (16)
      10. There are three customer in the super store data set. What percent of the total profits is associated with the corporate segment?
      Output:Consumer-46.83%
      Corporate-32.12%
      Home Office-21.05%
      11. How to remove ‘Abc’ from the table
      12. What is Empty Extract
      13. What Visualization will you suggest for the following Scenarios
      i) To Show aggregated sales totals across a range of product categories(Tree map)
      ii) To show the duration of events or activities(Gantt Chart)
      iii) To show quarter wise profit growth(Waterfall)
      14. What are the Special Chart you used in your Project
      15. Can we use group in calculated field
      16. There is a sale record in which dates are from Monday to Sunday. How can we take records from Wednesday to Sunday
      17. Top and bottom value how you will achieve
      18. Which chart will you prefer for time line scenario
      19. How will you Extract data from server
      20. Have you used forecast in your project
      21. What is the custom SQL you used in your project
      22. How will you neglect null values
      23. How to Change Start Date of week and Fiscal Date in the Data
      24. How will you find Second Order Date
      25. How to display Top20-30
      Other Questions
      1. What is the Difference Between Tableau and Other BI tools
      2. What are the Tableau Products
      3. What is ETL and What are the ETL toll you are using
      4. For what Tableau Server is used For
      5. Do parameter contains a Drop down list
      6. Drawbacks of Tableau
      7. Drawbacks of data blending
      8. What are the documents you will attached to client during deployment
      9. What is the default aggregation function
      10. What is the default chart
      11. How can you embed a webpage in a dashboard
      12. How can you Schedule a workbook in Tableau after publishing it
      13. What are difficulties faces/difficult Scenarios
      14. What is the data source you are using in your project
      15. What is data warehousing
      16. Have you used data blending
      17. Explain about your last project
      18. Have you created any data source
      19. What is the Best feature in Tableau
      20. Have you worked in Tableau.tdsx
      21. Tableau Architect
      22. Have you worked in Tableau Repository
      23. Metrics used in your project
      24. Advantages of Tableau
      25. What are all charts you have worked
      26. How do you optimize the visualization in Tableau
      27. What is server
      28. What is the Workflow method used in your Organization
      29. How long it will take to create a dashboard from scratch
      30. Color of Context Filter
      31. What is Book mark
      32. Escalation in Tableau Repository
      33. What is the color of Discrete and Continuous”

      Model Resume Download Links

       

      Software Download Links
      Check Out Our SQL Compiler!

      Greens Technology offers a powerful online SQL Compiler to help you practice and improve your SQL skills. Click the button below to get started.

      Go to SQL Compiler

        Job Portals list

         

          Task 1: Introduction

          1. Display region-wise sales using a pie chart with profit and discount in the tooltip.
          2. Visualize date-wise sales with a line chart.
          3. Represent category and sub-category sales using a custom visualization.
          4. Create a Treemap with region and discount metrics.
          5. Develop a bubble chart with sub-category and profit as metrics.
          6. Design a box and whisker plot for state-wise sales.
          7. Generate 24 charts using custom metrics from the “Show Me” feature.

          Task 2: Level of Detail (LOD) Calculations

          1. Identify the last order date for each product.
          2. Determine the last product purchased by each customer.
          3. Create a visualization with category, sub-category, state, and sales, including total sales breakdown by sub-category.
          4. Categorize product counts within the range of 0–1000.

          Task 3: Analytics & Quick Table Calculations

          1. Forecast sales for 2021.
          2. Compare actual sales against target values.
          3. Cluster sub-categories based on data patterns.
          4. Create a text chart displaying region, segment, category, sub-category, and sales, with subtotal and row total calculations.
          5. Develop a bar chart showing average sales by region.
          6. Calculate the cumulative sales value for each customer.
          7. Compute the difference between previous and current sales by sub-category.

          Task 4: Dual Axis, Blended, Sync, and Filters

          1. Create a single visualization incorporating sales, discount, profit, and category.
          2. Compare profit and sales for the current year in a single chart.
          3. Implement a context filter using category and sub-category.
          4. Design a cascading filter for category and sub-category.

          Task 5: Grouping, Combining, Sets, Parameters & Hierarchies

          1. Identify and display the top-performing products based on profit.
          2. Show the top and bottom 5 sub-categories based on sales.
          3. Combine multiple graphs in a single sheet, utilizing profit, total sales, profit ratio, and sub-category.
          4. Implement a drill-down feature for product-related fields.
          5. Group and combine data using a custom visualization.
          6. Create a date parameter with the ship date, ensuring it updates across all charts.

          Task 6: Functions & Calculations

          1. Display the last date of the current month.
          2. Calculate the remaining days until the end of the year.
          3. Identify the last purchase date for each customer.
          4. Count the number of records within each sub-category.
          5. Convert “appliances” to “Appliances” by capitalizing the first letter.
          6. Count the number of sales for each category.
          7. Count unique sales for each category without duplicates.
          8. Find the second order date for each customer.
          9. List all customers whose names start with “A.”
          10. List all customers whose names end with “H.”
          11. Extract the year from the order ID.
          12. Categorize sales ranges:
          • >50,000: Good
          • >100,000: Very Good
          • >150,000: Excellent

          Task 7: Dashboard Development

          (A) Dashboard Requirements

          • Key Performance Indicators (KPIs):

            1. Total Sales
            2. Profit
            3. Sales per Customer
            4. Profit per Product
            5. Sales growth compared to the previous year
          • Additional Requirements:

            • Include two filters and one date parameter.
            • Develop at least six charts, including:
              • Year-over-Year (YOY) comparison
              • Four custom charts
              • One customized chart
              • One map visualization
            • Implement action filters for enhanced interactivity.

          Weekend Task 01: Customized Charts

          1. Waterfall Chart
          2. Donut Chart
          3. Butterfly Chart
          4. Pyramid/Funnel Chart
          5. Histogram Chart
          6. Heat Map & Tree Map using Profit and Sales

          Weekend Task 02: Dashboard Development

          • Create a dashboard using data from Tableau Public.
          • Implement two filters and a date parameter.

          Tableau Limitations

          • Maximum Rows: Unlimited
          • Maximum Columns: 50
          • Maximum Joins: 32 (Tables can be joined)
          • Default Join Type: Inner Join (modifiable)
          • Default Join in Blending: Left Outer Join
          • Maximum Worksheets: 155
          • Maximum Parameters: 155

          Power Query & Data Transformation

          • M Query & Power Query Editor
          • Data Modeling & DAX Functions
          • Power BI Visualization & Service

          Report & Data Views

          • Report View, Data View & Model View
          • Power Query Editor – ETL (Extract, Transform, Load)

          Data Transformation & Formatting

          • Transform Data Types (Whole Number, Decimal, Text, Date, Time, Boolean)
          • Modify & Format Data (Headers, Transpose, Rename, Replace, Fill, Move, Split, Merge)
          • Pivot & Unpivot Columns
          • Extract & Parse Data

          Statistical & Mathematical Functions

          • Sum, Minimum, Maximum, Average, Median, Standard Deviation
          • Count & Distinct Count
          • Addition, Subtraction, Multiplication, Division, Modulo, Percentages

          Scientific & Rounding Functions

          • Absolute Value, Power, Square Root, Logarithm, Factorial
          • Round, Round Up, Round Down

          Date & Time Functions

          • Age, Year, Month, Quarter, Week, Day, Start & End of Month
          • Date & Time Parsing, Hour, Minute, Second

          Data Column Management

          • Creating Custom, Index, Duplicate, Conditional, and Parameter Columns
          • Managing Data Sources, Entering Data, Refreshing & Editing Queries

          Merging & Appending Queries

          • Joins (Left, Right, Inner, Full Outer, Anti Joins)
          • Appending Multiple Data Tables

          DAX – Data Analytics Expressions

          • Calculated Columns vs. Measures
          • Date Functions (Today, Now, DateDiff, DateAdd, EOMonth)
          • Logical Functions (IF, AND, OR, IFERROR)
          • Text Functions (Upper, Lower, Trim, Concatenate, Search, Substitute)

          Time Intelligence Functions

          • Previous & Next Day, Month, Quarter, Year Comparisons
          • Year-to-Date (YTD), Quarter-to-Date (QTD), Month-to-Date (MTD)

          Data Filtering & Aggregation

          • Filters, ALL, ALLExcept, ALLSelected, VAR, ConcatenateX
          • Aggregate Functions (SUM, AVERAGE, MIN, MAX, COUNT, DISTINCT COUNT)
          • SUM vs. SUMX

          Data Visualizations & Reports

          • Chart Types, Filters, Relationships & Cardinality
          • Power BI Service Account Setup
          • Report Publishing, Sharing, Exporting, Downloading
          • Scheduled Refresh, Subscriptions, Alerts, Dashboard Creation

          SQL Overview

          SQL (Structured Query Language) is the standard language for database communication and management.

          Databases

          Databases are organized collections of structured data, managed by a DBMS. Common databases include Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and MongoDB.

          Tables

          Tables store data in a structured row-and-column format.

          Key SQL Components

          • Language: SQL
          • Database: SQL Server
          • Developer Tool: Microsoft SQL Server Management Studio

          SQL Usage

          • Store Data: Tables store information in a structured manner.
          • Manipulate Data: Modify, update, and organize data.
          • Retrieve Data: Use queries to extract specific information.

          SQL Tasks (Microsoft SQL Server & Management Studio)

          Day 1 – Restricting & Sorting Data (Part 1 & 2)

          • Write queries to filter data based on conditions.
          • Sort records in ascending or descending order.
          • Retrieve specific employee details based on criteria.
          • Display records for selected departments.
          • Use conditional operators to refine queries.

          Day 2 – Aggregate Functions

          • Count total employees.
          • Calculate average, highest, and lowest salaries.
          • Group data and filter results using WHERE and HAVING.
          • Summarize salary information by department and job roles.
          • Determine employee hiring trends by year, month, and weekday.

          Day 3 – Analytical vs. Aggregate Functions

          • Compare salary averages at different levels.
          • Compute cumulative sums and ranks for employees.
          • Use LAG and LEAD functions to track hiring trends.
          • Rank employees’ salaries within their respective departments.

          Day 4 – Date Functions

          • Extract and format dates.
          • Perform date arithmetic (add/subtract days, months, years).
          • Retrieve the first/last day of the month.
          • Calculate differences between dates in various formats.

          Day 5 – String Functions

          • Extract and modify text data.
          • Concatenate names and format phone numbers.
          • Search and filter records based on text patterns.
          • Replace or update specific words within text fields.
          • Extract domain names and substrings from email addresses.

          Day 6: CASE AND CONVERT FUNCTIONS

          CASE Function Questions:

          1. Write a query to display each employee’s last name and indicate whether they receive a commission. Show “No Commission” if the commission percentage is NULL and “YES Commission” otherwise.
          2. Determine if the current date falls on a weekend or a weekday.
          3. Categorize employees based on experience: “Junior” (<2 years), “Mid-Level” (2-5 years), and “Senior” (>5 years).
          4. Display a message indicating whether each employee’s salary is above or below the average salary. Label the column as ‘Salary Status’.
          5. Use the CASE function to classify job titles: “Management” for titles containing “Manager”, “Technical” for titles containing “Engineer”, and “Other” for all other titles.
          6. Classify employees into salary bands: “Low” (<$40,000), “Medium” ($40,000-$80,000), and “High” (>$80,000).

          CONVERT Function Questions:

          1. Convert the hire date column to ‘YYYY-MM-DD’ format as VARCHAR.
          2. Convert the Salary column to a currency format with two decimal places.
          3. Convert the hire date to “Month Day, Year” format (e.g., “August 22, 2024”).

          Combining CASE and CONVERT Functions:

          1. Use CASE to classify employees based on phone number length, then convert the length into a string.

          Day 7: DATA DEFINITION LANGUAGE (DDL)

          Creating and Modifying Tables:

          • Create an Employees table with columns: Employee ID (integer, primary key), First Name (VARCHAR(50)), Last Name (VARCHAR(50)), Hire Date (DATE), and Salary (DECIMAL(10,2)).
          • Modify the Employees table to add an Email Address column (VARCHAR(100)).
          • Alter the Salary column to allow NULL values.
          • Rename the Last Name column to Surname.

          Dropping and Renaming Tables:

          • Delete the Employees table from the database.
          • Rename the Employees table to Staff.

          Constraints and Indexes:

          • Add a unique constraint to the Email Address column.
          • Add a foreign key constraint to Employees referencing the Department ID column in the Departments table.
          • List all tables in the current database.
          • Create a Projects table with an ID (primary key), Project Name (VARCHAR(100)), Start Date (DATE), and Budget (DECIMAL(15,2)).

          Day 8: DATA MANIPULATION LANGUAGE (DML) & TRANSACTION CONTROL LANGUAGE (TCL)

          Data Manipulations:

          • Insert a new record into Employees: ID 101, First Name ‘John’, Last Name ‘Doe’, Hire Date ‘2023-05-15’, Salary 75000.
          • Update Employee ID 101’s Salary to 80000.
          • Delete Employee ID 101 from Employees.
          • Update Department ID to 5 for employees earning >70000.
          • Insert multiple records into Projects with appropriate values.
          • Select all employees and replace NULL values in Email Address with ‘No Email’.
          • Update all NULL values in Commission PCT to 0.
          • Insert multiple rows into Projects in a single query.
          • Delete records from Projects where Start Date < ‘2024-03-01’.
          • Update Email Address to ‘updated@example.com‘ for employees with Last Name ‘Doe’.

          Data Transactions:

          • Explain SQL transactions and their importance.
          • Describe the purpose of the COMMIT statement.
          • Explain the ROLLBACK statement.
          • Define a SAVEPOINT and its use in SQL Server.
          • Compare COMMIT, ROLLBACK, and SAVE TRANSACTION.

          Day 9: CONSTRAINTS

          Primary Key Constraints:

          • Create a Students table with Student ID (primary key), First Name, Last Name, and Date of Birth.

          Unique Constraints:

          • Create an Employees table with a unique Email column.

          Foreign Key Constraints:

          • Create Departments and Employees tables with a foreign key reference.

          Check Constraints:

          • Create a Products table with a check constraint ensuring Quantity >= 0 and Price > 0.
          • Modify Employees to add a check constraint on Salary (between 30,000 and 150,000).

          Default Constraints:

          • Create an Orders table with Status defaulting to ‘Pending’.
          • Add a default constraint to Order Date setting it to the current date if no value is provided.

          Composite Constraints:

          • Create a Course Enrollments table with a composite primary key (Student ID, Course ID).

          Unique Constraint:

          • Enforce uniqueness on First Name and Last Name combinations in Employees.

          Day 10: JOINS

          Part 1: Types of Joins

          • Inner Join: List employees and their department names.
          • Left Join: List employees and their job titles, including those without job titles.
          • Right Join: List departments and employees, including departments with no employees.
          • Full Outer Join: Show all employees and departments, even without assignments.
          • Self-Join: Display employees and their managers.
          • Cross Join: Generate all possible employee-department combinations.

          Part 2: SQL Queries

          • Display last name, department number, and name for all employees.
          • List unique job titles in department 80 and its location.

          Day 11-15: ADVANCED SQL CONCEPTS

          • Use UNION to combine two employee tables.
          • Use INTERSECT to find employees in both HR and IT departments.
          • Use EXISTS to check if a department has employees.
          • Create a view for active employees.
          • Create a stored procedure to insert employees.

          1. What is power query editor?
          2. What are the connection present in power bi?
          3. What is live connection?
          4. What is reference?
          5. What is duplicate?
          6. What is append and merge?
          7. What are the types of joins in power bi?
          8. What is query folding?
          9. What is m language?
          10. What is query dependency?
          11. What are the transformation will do in power query editor?
          12. What is dimension and measure?
          13. What is pivot and unpivot?
          14. What is groupbyfunction in power query editor?
          15. What is grouping and binning in power bi?
          16. What are the most common data shaping technique?
          17. What is data modelling
          18. What is dimension tableand fact table and also difference?
          19. What is star schema, snow flake schema?
          20. What is cardinality or relationship?
          21. How many cardinality are there in power bi?
          22. What relationship?
          23. How to implement relationship?
          24. How to implement many to many relationship?
          25. What bidirectional filter?
          26. How many active relationship we can create at a time during modelling?
          27. What is report view?
          28. What are the refresh in power bi?
          29. What is incremental refresh
          30. What is full refresh?
          31. How to implementation of incremental refresh?
          32. What is manage relationship? DATA VISUALISATION QUESTIONS:
          33. What is dax functions?
          34. What is rls and implementation
          35. Types of rls
          36. What is new column, new measure,new table?
          37. What calculated column, calculated measure?
          38. Diff sum between sumx?
          39. Diff between row context and filter context?
          40. Difff calculateand calculate table?
          41. Diff all, all except, all select & real time use case?
          42. What are the dax functions you have used?
          43. What are the functional groups in dax?
          44. What is time intelligence function ?
          45. How to connect relation in dax?
          46. What is cumulative dax functions
          47. Types of filter
          48. What is slicer and sync slicer?
          49. What is drill down and drill through
          50. Diff between filter and slicer
          51. What is book mark?
          52. What is book mark action?
          53. What is custom visuals?
          54. Explain what types charts have you used in your projects?
          55. Parameter (query parameter, visual parameter)
          56. What is performance tuning?
          57. What conditional formatting
          58. How you testing the reports?
          59. Difference between reports and dashboard?
          60. How you will get requirement or brd
          61. Limitation of import method?
          62. Maximum data size used in power bi
          63. What is summarize , summarizex?
          64. What is iteration function?
          65. What is power automate?
          66. What are the three fundamental concepts of dax
          67. Performance tuning (dax,datamodelling,visual,query editor)

          POWER BI SERVICE QUESTIONS:
          68. What is alert, subscription
          69. What is power bi service?
          70. What is gateway connectios and types?
          71. What is workspace?
          72. What is data flow?
          73. What is ccid pipeline?
          74. What is switch function?
          75. What is subscription and alert?
          76. Will you able create multiple workspace?
          77. What are the tabs available in power service?
          78. What is scd?
          79. What is paginated report?
          80. How to configure schedule refresh in power bi service? GENERAL QUESTIONS:
          81. What is power bi?
          82. Difference between power bi and tableau?
          83. Why you prefering power bi?
          84. Power bi latest version and updates
          85. What are the views present in power bi
          86. How to get data from data source?
          87. What is power q/a?
          88. What is power map?
          89. What are the components present in power bi?
          90. What is ssbi?
          91. What are the database have you used?
          92. Advantange and limitations of power bi?
          93. What data sources can power bi connect to?
          94. Where is data stored in power bi?

          Data warehousing questions
          1. What is data warehousing?
          2. Olap vs oltp
          3. Star schema and snowflake schema

          SQL interview question
          1. What are the available data types in SQL?
          2. What are the operators we have in SQL?
          3. What are the case manipulation functions?
          4. What are the character/string manipulation functions?
          5. What are the analytical functions in SQL,explain its types?
          6. What are the aggregate functions in SQL,explain its types?
          7. What are the null functions in SQL and explain its types?
          8. What are the date functions in SQL and explain its types?
          9. What is ddl, dml & tcl, dql commands?
          10. What are the joins available in SQL?
          11. What is a view & materialized view?
          12. What are the sub queries in SQL?
          13. What are the set operations?
          14. What are the pseudo columns?
          15. What is a like operator?
          16. What are the constraints

          SQL difference questions
          1. What is the difference between where and having?
          2. What is the difference between delete, drop & truncate?
          3. What is the difference between union and unionall?
          4. What is the difference between nvl, nvl2 & colasece?
          5. What is the difference b/w primary key & foreign key?
          6. What is the differences between in and equall to?
          7. What is the difference between case and decode?
          8. What is the difference between and and or?

          SQL queries
          1. Write query to find max salary from employee table?
          2. Write query to find 2nd max salary from employee table?
          3. Write query to find nth max salary from employee table?
          4. Write query to find max salary department wise?
          5. Write query to find nth max salary department wise?
          6. Write query to find employee & manager name?
          7. Write query to how to find and delete the duplicates?

          1. What is Tableau, Why it is used for
          2. What is data visualization
          3. What is Workbook, Worksheet, Dashboard and Story
          4. What are the data types in Tableau
          5. What is Dimensions and Measures
          6. What is Discrete and Continuous
          7. What is Aggregation and Disaggregation of data
          8. Types of file Extensions in Tableau
          9. What is Group and Combine
          10. What is Dynamic Group
          11. What is Set and Parameter
          12. What is Hierarchy and how you will create
          13. What are the types of connection in Tableau
          14. Types of Filters in Tableau
          15. What is Context filter and Cascading Filter
          16. Order of Execution of filterM
          17. What is Dual Axis, Blended Axis & Synchronizing Axis
          18. What are the Analytical Functions in Tableau
          19. What are the Dashboard Actions present in Tableau
          20. What are the Number Functions in Tableau
          21. What are the Aggregate Functions in Tableau
          22. What are the logical Functions in Tableau
          23. What are the String Functions in Tableau
          24. What are the Table calculation Function in Tableau
          25. What are the Date Functions in Tableau
          26. What is Data Blending
          27. What is Data Joining
          28. What is Relationship
          29. What is LOD and its types
          30. What is Bins
          31. What are the types of Joins
          32. What is Calculated Field
          33. What is Quick Table Calculation and types
          34. What are Worksheet Marks
          35. What are the Dashboard Actions
          36. What is Tiled and Floating
          37. How to increase Performance in Tableau/Performance Improvement
          38. How to overcome unknown location in Tableau
          39. What is Published Data Source
          40. What is Embedded Data Source
          41. What is KPI and What are the KPI’s used in your Project
          42. What are the Rank Functions in Tableau
          43. How is Context Filter different from other filter? What is the disadvantage of context filter
          44. What is Tableau Server
          45. What is User filter and Row level Security
          46. What is Incremental Refresh
          47. What is Tableau Data Engine/hyper
          48. Roles available in Tableau Server
          49. Limitations of Context Filter
          50. What is Data Extract in Tableau Server
          51. What is Alert and What is Subscription
          52. Performance tuning in Tableau
          53. How performance testing done in Tableau
          54. What is Normalization and Denormalization
          55. What is Granularity
          56. What is Boxplot Chart
          57. What is Scatter Chart
          58. What is Histogram Chart
          59. What is Dendogram Chart
          60. What is Waterfall Chart
          61. What is Referential Integrity
          62. What is cardinality
          63. What is set and where you have used
          64. What is Primary data and Secondary data
          65. How will you Change Primary and Secondary Data Source
          Difference between Questions
          1. Difference b/w twb and twbx
          2. Difference b/w Group and Combine
          3. Difference b/w Set and Parameter
          4. Difference b/w set and Group
          5. Difference b/w Heat map and Tree map
          6. Difference b/w Context filter and Cascading filter
          7. Difference b/w Dual Axis and Blended Axis
          8. Difference b/w Ceiling and Floor
          9. Difference b/w Ifnull, Isnull and Zn
          10. Difference b/w contains and endswith
          11. Difference b/w ltrim and rtrim
          12. Difference b/w first and last
          13. Difference b/w Rank and Rank_dence
          14. Difference b/w Today and Now
          15. Difference b/w Data blending and Data Joining
          16. Difference b/w live and Extract Connection
          17. Difference b/w Alert and Subscription
          18. Difference b/w Filters and Parameter
          Scenario Based Questions
          1. How to display top5 and bottom5 sales
          2. What are the KPI’s used in your Project
          3. What is the version you are using
          4. What are the unique features in every version of Tableau
          5. How to remove ‘All’ in Show Filters
          6. How to display * in measures
          7. How many data sources you can blend(5)
          8. How many tables you can Join(32)
          9. How many columns we can extend in Tableau(50) Default is (16)
          10. There are three customer in the super store data set. What percent of the total profits is associated with the corporate segment?
          Output:Consumer-46.83%
          Corporate-32.12%
          Home Office-21.05%
          11. How to remove ‘Abc’ from the table
          12. What is Empty Extract
          13. What Visualization will you suggest for the following Scenarios
          i) To Show aggregated sales totals across a range of product categories(Tree map)
          ii) To show the duration of events or activities(Gantt Chart)
          iii) To show quarter wise profit growth(Waterfall)
          14. What are the Special Chart you used in your Project
          15. Can we use group in calculated field
          16. There is a sale record in which dates are from Monday to Sunday. How can we take records from Wednesday to Sunday
          17. Top and bottom value how you will achieve
          18. Which chart will you prefer for time line scenario
          19. How will you Extract data from server
          20. Have you used forecast in your project
          21. What is the custom SQL you used in your project
          22. How will you neglect null values
          23. How to Change Start Date of week and Fiscal Date in the Data
          24. How will you find Second Order Date
          25. How to display Top20-30
          Other Questions
          1. What is the Difference Between Tableau and Other BI tools
          2. What are the Tableau Products
          3. What is ETL and What are the ETL toll you are using
          4. For what Tableau Server is used For
          5. Do parameter contains a Drop down list
          6. Drawbacks of Tableau
          7. Drawbacks of data blending
          8. What are the documents you will attached to client during deployment
          9. What is the default aggregation function
          10. What is the default chart
          11. How can you embed a webpage in a dashboard
          12. How can you Schedule a workbook in Tableau after publishing it
          13. What are difficulties faces/difficult Scenarios
          14. What is the data source you are using in your project
          15. What is data warehousing
          16. Have you used data blending
          17. Explain about your last project
          18. Have you created any data source
          19. What is the Best feature in Tableau
          20. Have you worked in Tableau.tdsx
          21. Tableau Architect
          22. Have you worked in Tableau Repository
          23. Metrics used in your project
          24. Advantages of Tableau
          25. What are all charts you have worked
          26. How do you optimize the visualization in Tableau
          27. What is server
          28. What is the Workflow method used in your Organization
          29. How long it will take to create a dashboard from scratch
          30. Color of Context Filter
          31. What is Book mark
          32. Escalation in Tableau Repository
          33. What is the color of Discrete and Continuous”

          Data analytics in Greens Technologies -Power Bi training-power Bi courses

          Why Power BI Course?

          Power BI is a leading business intelligence tool that empowers professionals to analyze, visualize, and share data-driven insights efficiently. Our Power BI course in Chennai is designed to equip you with in-depth knowledge of data analytics, interactive dashboards, and reporting through hands-on training. Whether you’re a beginner or an experienced professional, this course offers industry-relevant skills to advance your career. Learn data modeling, DAX, Power Query, and real-time analytics, and gain job-ready expertise with expert-led sessions and practical projects.


          Start Course

          Google Reviews​


          • Perumbakkam Chennai

          0
          ★★★★★ 5/5
          2,394 Ratings
          “Recently I have joined Data analytics course in greens technology under the Team Ranjith Bro. Mentors are highly engaging and interactive. Completed my SQL course under the guidance of Mohan bro. He was an excellent SQL instructor. The course was well-structured and covered all the essential topics.
          His clear explanations and practical examples made learning SQL enjoyable and easy to understand.”
          ★★★★★ 5/5

          Dharshini asokan

          “It was nice experience to learn data analytics in your institute.The Teaching was very good and trainer also very sweet .the trainer should
          explain very well.whenever we ask doubt means they will explain.”
          ★★★★★ 5/5

          RAM SANJAY

          “I did course in data analytics under Ranjith team in greens technology. The trainers Ranjith for tableau and mohanraj for sql and powerbi helped me in understanding every aspects of the topic very clearly.
          Trainer Ranjith is very good at giving detailed understanding of tableau concepts.He never rushes through the topic and makes us understand even simple topics more clearly. ”
          ★★★★★ 5/5

          Neeraja chidambaram

          “I joined data analytics course in Greens technology. I should thank my tutor Mr.Ranjith sir. Thank you so much for explaining complex concepts in a way that is easy to understand in And every session went very well. He was very supportive and encouraging and helped me through the entire placement process step by step. Thank you Ranjith sir. Thanks for your patience and clarity.”

          Gayathri Sundaram

          ★★★★★ 5/5

          Our Branches

          Omr
          Adyar
          Tambaram
          Navalur
          Porur
          Perumbakkam
          Anna Nagar
          Velachery
          Vadapalani
          Perungudi
          Avadi
          Mugalivakkam
          Mount Road
          T Nagar
          Ambattur


          Start Course

          FAQ

          Power BI is a powerful business intelligence and data visualization tool from Microsoft. It enables professionals to analyze data, create interactive reports, and gain insights for better decision-making. Learning Power BI can enhance your career prospects in data analytics, business intelligence, and reporting.

          This course is ideal for:

          • Beginners looking to start a career in data analytics
          • Business analysts and data professionals
          • IT professionals and software developers
          • Anyone interested in learning data visualization and reporting

          There are no strict prerequisites. However, a basic understanding of Excel, SQL, and data concepts can be helpful.

          Our Power BI training covers:

          • Introduction to Power BI and its components
          • Data modeling and Power Query
          • DAX (Data Analysis Expressions)
          • Creating interactive dashboards and reports
          • Real-time analytics and publishing reports
          • Hands-on projects and case studies

          Yes, our Power BI training includes practical, hands-on exercises, real-time projects, and case studies to ensure you gain practical expertise.

          Power BI is a powerful business intelligence and data visualization tool from Microsoft. It enables professionals to analyze data, create interactive reports, and gain insights for better decision-making. Learning Power BI can enhance your career prospects in data analytics, business intelligence, and reporting.

          This course is ideal for:

          • Beginners looking to start a career in data analytics
          • Business analysts and data professionals
          • IT professionals and software developers
          • Anyone interested in learning data visualization and reporting

          There are no strict prerequisites. However, a basic understanding of Excel, SQL, and data concepts can be helpful.

          Our Power BI training covers:

          • Introduction to Power BI and its components
          • Data modeling and Power Query
          • DAX (Data Analysis Expressions)
          • Creating interactive dashboards and reports
          • Real-time analytics and publishing reports
          • Hands-on projects and case studies

          Yes, our Power BI training includes practical, hands-on exercises, real-time projects, and case studies to ensure you gain practical expertise.

          Yes, upon successful completion, you will receive a course completion certificate from Greens Technology. We also guide you on preparing for Microsoft’s official Power BI certification.

          Power BI skills are in high demand across various industries. Career opportunities include:

          • Data Analyst
          • Business Intelligence Analyst
          • Power BI Developer
          • Data Visualization Specialist
          • Reporting Analyst

          Yes, we provide placement support, including resume building, interview preparation, and job referrals to top companies hiring Power BI professionals.

          The duration varies based on the training mode:

          • Regular classroom training: 
          • Weekend batches: 
          • Fast-track training: 

          We offer:

          • Classroom training in Chennai
          • Live online training
          • Self-paced learning with recorded sessions

          Yes, upon successful completion, you will receive a course completion certificate from Greens Technology. We also guide you on preparing for Microsoft’s official Power BI certification.

          Power BI skills are in high demand across various industries. Career opportunities include:

          • Data Analyst
          • Business Intelligence Analyst
          • Power BI Developer
          • Data Visualization Specialist
          • Reporting Analyst

          Yes, we provide placement support, including resume building, interview preparation, and job referrals to top companies hiring Power BI professionals.

          The duration varies based on the training mode:

          • Regular classroom training: 
          • Weekend batches: 
          • Fast-track training: 

          We offer:

          • Classroom training in Chennai
          • Live online training
          • Self-paced learning with recorded sessions


          Upcoming Batch Dates  
            
            
               
                          

          Chennai

                   

                       

          91 9790147086




          Chennai


           91 9790147086


          WhatsApp-logo-button-image