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











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.
Course 1
POWER BI + POWER BI SERVICE + SQL
-
30+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Course 2
POWER BI + POWER BI SERVICE + SQL + PYTHON
-
40+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Course 3
TAB + TAB SERVER + PBI + PBI SERVER + SQL + PYTHON
-
45+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Course 4
TABLEAU + TABLEAU SERVER + SQL
-
30+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Course 5
TABLEAU + TABLEAU SERVER + SQL+PYT
-
35+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Course 6
PBI + PBI SERVER + TAB + TAB SERVER + PYTHON
-
40+ Hours + Placement Training -
Live Projects & Assesments -
Assured Placements -
Offline | Online
Curriculum
Power BI Syllabus
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
Tableau Syllabus
- Introduction to Tableau – Overview of the interface, product features, and desktop functionalities.
- Understanding Data Types – Exploring various data types and their significance in Tableau.
- Data Connections – Learning about different types of data connections and their applications.
- Dimensions & Measures – Understanding their role in data analysis.
- Discrete & Continuous Data – Concepts and practical implementation.
- Tableau File Extensions – Overview and usage of different file formats.
- Advanced Data Manipulation – Utilizing groups, sets, combinations, parameters, combined sets, and hierarchies.
- Filtering Techniques – Implementing various filters such as data source, extract, dimension, measure, cascading, and context filters.
- Functions in Tableau – Working with numerical, aggregate, logical, string, table calculations, window functions, date functions, quick table calculations, null handling, and analytics.
- LOD Expressions & Bins – Understanding Level of Detail expressions and bins.
- Visual Representation – Exploring different axes, chart types, and mapping techniques.
- Filters & Mapping – Implementing interactive maps and filters in Tableau.
- Dashboard Development – Creating both basic and advanced dashboards.
- Dashboard Interactivity – Configuring actions to enhance user experience.
- Data Modeling – Understanding relationships, data blending, and best practices.
- Joins & Data Integration – Performing cross-database joins and understanding their applications.
- Tableau Server & Tableau Online – Introduction to publishing and managing data sources.
- Data Source Management – Working with embedded and published data sources.
- User Management & Security – Managing site roles, user access, and row-level security (RLS).
- Alerts & Automation – Implementing alerts, subscriptions, and performance metrics.
- Handling Data Extracts – Managing empty extracts and optimizing data workflows.
SQL Syllabus
- Introduction & Setup – Understanding the basics and setting up the SQL environment.
- Database & Table Creation – Learning to create and manage databases and tables.
- Data Types & Operators – Exploring different data types and working with operators.
- Text Functions – Utilizing functions like
UPPER(),LOWER(), andINITCAP()for text formatting. - String Functions – Handling strings with
SUBSTRING(),CONCAT(),LEN(),TRIM(), andREPLACE(). - Essential Functions – Working with date, numeric, null-handling, and general functions.
- Aggregation & Grouping – Using functions like
COUNT(),SUM(),AVG(),MIN(),MAX(), along withGROUP BYandHAVING. - Analytical & Window Functions – Performing advanced data analysis using built-in SQL functions.
- SQL Commands – Covering key commands for data definition, manipulation, transactions, and queries.
- Joins & Relationships – Understanding different join types (
INNER,LEFT,RIGHT,FULL,CROSS). - Constraints & Integrity Rules – Enforcing data integrity with constraints (
NOT NULL,PRIMARY,UNIQUE,FOREIGN,DEFAULT,INDEX,CHECK). - Set Operations – Learning operations like
UNION,UNION ALL,MINUS, andINTERSECT. - Views & Materialized Views – Creating and managing views for better data organization.
- Subqueries & Nested Queries – Writing efficient subqueries for complex data retrieval.
- Pseudo & Special Columns – Understanding special columns like
ROWID,ROWNUM,LEVEL,CONNECT_BY_ISLEAF, andSYS_GUID().
Python Syllabus
-
Environment Setup & Installation
-Setting up Python, Anaconda, and Jupyter Notebook -
Understanding Programming Basics
-Difference between Compilation and Interpretation
-Writing and Running Your First Python Program -
Fundamentals of Python
-Printing “Hello World”
-Variables and Data Types
-Operators and Their Applications -
Functions and Control Flow
-Defining and Using Functions & Methods
-Conditional Statements: if, if-else, elif
-Looping Constructs: while loop, for loop -
Python Data Structures
-Lists, Tuples, Sets, and Dictionaries
-Iteration Tools: Map and Filter -
Working with Regular Expressions
-
Modules, Packages, and Dependency Management
Installing and Managing Libraries with PIP -
Exception Handling in Python
-
Object-Oriented Programming (OOP) in Python
-Classes and Objects
-Constructors, Attributes, and Methods
-Key OOP Concepts: Inheritance, Encapsulation, Polymorphism -
Advanced Python Concepts
-Lambda (Anonymous) Functions
-Generators and Closures -
Exploring Popular Python Libraries
-Introduction to NumPy, Pandas, and Matplotlib
Power Automate Syllabus
- Automating email delivery to a Gmail account with an attachment from OneDrive.
- Creating new groups automatically using Microsoft Forms.
- Scheduling automated emails for birthday and wedding greetings.
- Configuring Power BI alert notifications for Microsoft Teams and Outlook.
- Managing dataset refresh processes efficiently.
- Applying aggregate and grouping functions such as COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.
Power Apps Syllabus
- Introduction
- Installation & Setup
- Developer Environment Overview
- Understanding Variables
- Working with Collections
–Creating, Accessing, Modifying, Iterating, and Clearing Collections - Automated Email Notifications for Birthdays & Key Events
- Canvas Apps & Model-Driven Apps
- Connecting to Data Sources
- Utilizing Controls & Expressions
- Managing Screens & Data Integration
- Dynamic Assignments & User Interactions
- Implementing Formulas, Variables, Collections, and Contextual Data
- Handling Controls, Properties, and User Inputs
- Functions Overview
–Data Manipulation Functions
-Control-Based Functions
-Mathematical & Logical Functions
-Text Formatting & Conversion Functions
-Date & Time Operations
-Input & Interaction Handling - Formulas & Expressions
–OnSelect, OnClick, Upper, Lower, Proper, Launch, Navigation, and more - Building a Canvas App with SQL & SharePoint
- Implementing Data Validation with SQL & SharePoint
- Developing Forms & Galleries
- Performing CRUD (Create, Read, Update, Delete) Operations
- Creating Cascading Dropdowns
- Integrating Power BI with Power Apps
- Designing & Publishing Power BI Reports
- Generating & Embedding Power BI Reports in Power Apps
- Configuring Interactive Features
- 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
- Introduction to Tableau – Overview of the interface, product features, and desktop functionalities.
- Understanding Data Types – Exploring various data types and their significance in Tableau.
- Data Connections – Learning about different types of data connections and their applications.
- Dimensions & Measures – Understanding their role in data analysis.
- Discrete & Continuous Data – Concepts and practical implementation.
- Tableau File Extensions – Overview and usage of different file formats.
- Advanced Data Manipulation – Utilizing groups, sets, combinations, parameters, combined sets, and hierarchies.
- Filtering Techniques – Implementing various filters such as data source, extract, dimension, measure, cascading, and context filters.
- Functions in Tableau – Working with numerical, aggregate, logical, string, table calculations, window functions, date functions, quick table calculations, null handling, and analytics.
- LOD Expressions & Bins – Understanding Level of Detail expressions and bins.
- Visual Representation – Exploring different axes, chart types, and mapping techniques.
- Filters & Mapping – Implementing interactive maps and filters in Tableau.
- Dashboard Development – Creating both basic and advanced dashboards.
- Dashboard Interactivity – Configuring actions to enhance user experience.
- Data Modeling – Understanding relationships, data blending, and best practices.
- Joins & Data Integration – Performing cross-database joins and understanding their applications.
- Tableau Server & Tableau Online – Introduction to publishing and managing data sources.
- Data Source Management – Working with embedded and published data sources.
- User Management & Security – Managing site roles, user access, and row-level security (RLS).
- Alerts & Automation – Implementing alerts, subscriptions, and performance metrics.
- Handling Data Extracts – Managing empty extracts and optimizing data workflows.
- Introduction & Setup – Understanding the basics and setting up the SQL environment.
- Database & Table Creation – Learning to create and manage databases and tables.
- Data Types & Operators – Exploring different data types and working with operators.
- Text Functions – Utilizing functions like
UPPER(),LOWER(), andINITCAP()for text formatting. - String Functions – Handling strings with
SUBSTRING(),CONCAT(),LEN(),TRIM(), andREPLACE(). - Essential Functions – Working with date, numeric, null-handling, and general functions.
- Aggregation & Grouping – Using functions like
COUNT(),SUM(),AVG(),MIN(),MAX(), along withGROUP BYandHAVING. - Analytical & Window Functions – Performing advanced data analysis using built-in SQL functions.
- SQL Commands – Covering key commands for data definition, manipulation, transactions, and queries.
- Joins & Relationships – Understanding different join types (
INNER,LEFT,RIGHT,FULL,CROSS). - Constraints & Integrity Rules – Enforcing data integrity with constraints (
NOT NULL,PRIMARY,UNIQUE,FOREIGN,DEFAULT,INDEX,CHECK). - Set Operations – Learning operations like
UNION,UNION ALL,MINUS, andINTERSECT. - Views & Materialized Views – Creating and managing views for better data organization.
- Subqueries & Nested Queries – Writing efficient subqueries for complex data retrieval.
- Pseudo & Special Columns – Understanding special columns like
ROWID,ROWNUM,LEVEL,CONNECT_BY_ISLEAF, andSYS_GUID().
-
Environment Setup & Installation
-Setting up Python, Anaconda, and Jupyter Notebook -
Understanding Programming Basics
-Difference between Compilation and Interpretation
-Writing and Running Your First Python Program -
Fundamentals of Python
-Printing “Hello World”
-Variables and Data Types
-Operators and Their Applications -
Functions and Control Flow
-Defining and Using Functions & Methods
-Conditional Statements: if, if-else, elif
-Looping Constructs: while loop, for loop -
Python Data Structures
-Lists, Tuples, Sets, and Dictionaries
-Iteration Tools: Map and Filter -
Working with Regular Expressions
-
Modules, Packages, and Dependency Management
Installing and Managing Libraries with PIP -
Exception Handling in Python
-
Object-Oriented Programming (OOP) in Python
-Classes and Objects
-Constructors, Attributes, and Methods
-Key OOP Concepts: Inheritance, Encapsulation, Polymorphism -
Advanced Python Concepts
-Lambda (Anonymous) Functions
-Generators and Closures -
Exploring Popular Python Libraries
-Introduction to NumPy, Pandas, and Matplotlib
- Automating email delivery to a Gmail account with an attachment from OneDrive.
- Creating new groups automatically using Microsoft Forms.
- Scheduling automated emails for birthday and wedding greetings.
- Configuring Power BI alert notifications for Microsoft Teams and Outlook.
- Managing dataset refresh processes efficiently.
- Applying aggregate and grouping functions such as COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.
- Introduction
- Installation & Setup
- Developer Environment Overview
- Understanding Variables
- Working with Collections
–Creating, Accessing, Modifying, Iterating, and Clearing Collections - Automated Email Notifications for Birthdays & Key Events
- Canvas Apps & Model-Driven Apps
- Connecting to Data Sources
- Utilizing Controls & Expressions
- Managing Screens & Data Integration
- Dynamic Assignments & User Interactions
- Implementing Formulas, Variables, Collections, and Contextual Data
- Handling Controls, Properties, and User Inputs
- Functions Overview
–Data Manipulation Functions
-Control-Based Functions
-Mathematical & Logical Functions
-Text Formatting & Conversion Functions
-Date & Time Operations
-Input & Interaction Handling - Formulas & Expressions
–OnSelect, OnClick, Upper, Lower, Proper, Launch, Navigation, and more - Building a Canvas App with SQL & SharePoint
- Implementing Data Validation with SQL & SharePoint
- Developing Forms & Galleries
- Performing CRUD (Create, Read, Update, Delete) Operations
- Creating Cascading Dropdowns
- Integrating Power BI with Power Apps
- Designing & Publishing Power BI Reports
- Generating & Embedding Power BI Reports in Power Apps
- Configuring Interactive Features
- 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.
Greens Technologies
Course Options:
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
Model Resume Download Links
Software Links
Software Download Links
SQL Compiler
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.
Job Portals
Job Portals list
- Data Analytics Jobs on Naukri
- Data Analytics Jobs on Indeed
- Data Analytics Jobs on LinkedIn
- Data Analyst Jobs on Shine
- Data Analyst Jobs on Foundit
- Data Analyst Jobs on TimesJobs
- Data Analyst Jobs on Glassdoor
- Data Analyst Jobs on Freshersworld
- Data Analyst Freelance Jobs on Upwork
- Data Analyst Jobs on HerKey
- Data Analyst Jobs on Cutshort
- Data Analyst Jobs on Jobsora
- Data Analyst Jobs on Quikr
- Data Analyst Jobs on Hirist
- Data Analyst Jobs on Snaphunt
- Data Analyst Jobs on WorkIndia
- Data Analyst Jobs on Foundit (Alternate)
- Data Analyst Jobs on Fishbowl
- Data Analyst Jobs on Wellfound
Tableau Class Task
Task 1: Introduction
- Display region-wise sales using a pie chart with profit and discount in the tooltip.
- Visualize date-wise sales with a line chart.
- Represent category and sub-category sales using a custom visualization.
- Create a Treemap with region and discount metrics.
- Develop a bubble chart with sub-category and profit as metrics.
- Design a box and whisker plot for state-wise sales.
- Generate 24 charts using custom metrics from the “Show Me” feature.
Task 2: Level of Detail (LOD) Calculations
- Identify the last order date for each product.
- Determine the last product purchased by each customer.
- Create a visualization with category, sub-category, state, and sales, including total sales breakdown by sub-category.
- Categorize product counts within the range of 0–1000.
Task 3: Analytics & Quick Table Calculations
- Forecast sales for 2021.
- Compare actual sales against target values.
- Cluster sub-categories based on data patterns.
- Create a text chart displaying region, segment, category, sub-category, and sales, with subtotal and row total calculations.
- Develop a bar chart showing average sales by region.
- Calculate the cumulative sales value for each customer.
- Compute the difference between previous and current sales by sub-category.
Task 4: Dual Axis, Blended, Sync, and Filters
- Create a single visualization incorporating sales, discount, profit, and category.
- Compare profit and sales for the current year in a single chart.
- Implement a context filter using category and sub-category.
- Design a cascading filter for category and sub-category.
Task 5: Grouping, Combining, Sets, Parameters & Hierarchies
- Identify and display the top-performing products based on profit.
- Show the top and bottom 5 sub-categories based on sales.
- Combine multiple graphs in a single sheet, utilizing profit, total sales, profit ratio, and sub-category.
- Implement a drill-down feature for product-related fields.
- Group and combine data using a custom visualization.
- Create a date parameter with the ship date, ensuring it updates across all charts.
Task 6: Functions & Calculations
- Display the last date of the current month.
- Calculate the remaining days until the end of the year.
- Identify the last purchase date for each customer.
- Count the number of records within each sub-category.
- Convert “appliances” to “Appliances” by capitalizing the first letter.
- Count the number of sales for each category.
- Count unique sales for each category without duplicates.
- Find the second order date for each customer.
- List all customers whose names start with “A.”
- List all customers whose names end with “H.”
- Extract the year from the order ID.
- Categorize sales ranges:
- >50,000: Good
- >100,000: Very Good
- >150,000: Excellent
Task 7: Dashboard Development
(A) Dashboard Requirements
-
Key Performance Indicators (KPIs):
- Total Sales
- Profit
- Sales per Customer
- Profit per Product
- 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
- Waterfall Chart
- Donut Chart
- Butterfly Chart
- Pyramid/Funnel Chart
- Histogram Chart
- 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 BI Class Task
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 Class Task
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:
- 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.
- Determine if the current date falls on a weekend or a weekday.
- Categorize employees based on experience: “Junior” (<2 years), “Mid-Level” (2-5 years), and “Senior” (>5 years).
- Display a message indicating whether each employee’s salary is above or below the average salary. Label the column as ‘Salary Status’.
- Use the CASE function to classify job titles: “Management” for titles containing “Manager”, “Technical” for titles containing “Engineer”, and “Other” for all other titles.
- Classify employees into salary bands: “Low” (<$40,000), “Medium” ($40,000-$80,000), and “High” (>$80,000).
CONVERT Function Questions:
- Convert the hire date column to ‘YYYY-MM-DD’ format as VARCHAR.
- Convert the Salary column to a currency format with two decimal places.
- Convert the hire date to “Month Day, Year” format (e.g., “August 22, 2024”).
Combining CASE and CONVERT Functions:
- 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.
Power BI Interview Questions
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?
Tableau Interview Questions
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.
Job Portals list
- Data Analytics Jobs on Naukri
- Data Analytics Jobs on Indeed
- Data Analytics Jobs on LinkedIn
- Data Analyst Jobs on Shine
- Data Analyst Jobs on Foundit
- Data Analyst Jobs on TimesJobs
- Data Analyst Jobs on Glassdoor
- Data Analyst Jobs on Freshersworld
- Data Analyst Freelance Jobs on Upwork
- Data Analyst Jobs on HerKey
- Data Analyst Jobs on Cutshort
- Data Analyst Jobs on Jobsora
- Data Analyst Jobs on Quikr
- Data Analyst Jobs on Hirist
- Data Analyst Jobs on Snaphunt
- Data Analyst Jobs on WorkIndia
- Data Analyst Jobs on Foundit (Alternate)
- Data Analyst Jobs on Fishbowl
- Data Analyst Jobs on Wellfound
Task 1: Introduction
- Display region-wise sales using a pie chart with profit and discount in the tooltip.
- Visualize date-wise sales with a line chart.
- Represent category and sub-category sales using a custom visualization.
- Create a Treemap with region and discount metrics.
- Develop a bubble chart with sub-category and profit as metrics.
- Design a box and whisker plot for state-wise sales.
- Generate 24 charts using custom metrics from the “Show Me” feature.
Task 2: Level of Detail (LOD) Calculations
- Identify the last order date for each product.
- Determine the last product purchased by each customer.
- Create a visualization with category, sub-category, state, and sales, including total sales breakdown by sub-category.
- Categorize product counts within the range of 0–1000.
Task 3: Analytics & Quick Table Calculations
- Forecast sales for 2021.
- Compare actual sales against target values.
- Cluster sub-categories based on data patterns.
- Create a text chart displaying region, segment, category, sub-category, and sales, with subtotal and row total calculations.
- Develop a bar chart showing average sales by region.
- Calculate the cumulative sales value for each customer.
- Compute the difference between previous and current sales by sub-category.
Task 4: Dual Axis, Blended, Sync, and Filters
- Create a single visualization incorporating sales, discount, profit, and category.
- Compare profit and sales for the current year in a single chart.
- Implement a context filter using category and sub-category.
- Design a cascading filter for category and sub-category.
Task 5: Grouping, Combining, Sets, Parameters & Hierarchies
- Identify and display the top-performing products based on profit.
- Show the top and bottom 5 sub-categories based on sales.
- Combine multiple graphs in a single sheet, utilizing profit, total sales, profit ratio, and sub-category.
- Implement a drill-down feature for product-related fields.
- Group and combine data using a custom visualization.
- Create a date parameter with the ship date, ensuring it updates across all charts.
Task 6: Functions & Calculations
- Display the last date of the current month.
- Calculate the remaining days until the end of the year.
- Identify the last purchase date for each customer.
- Count the number of records within each sub-category.
- Convert “appliances” to “Appliances” by capitalizing the first letter.
- Count the number of sales for each category.
- Count unique sales for each category without duplicates.
- Find the second order date for each customer.
- List all customers whose names start with “A.”
- List all customers whose names end with “H.”
- Extract the year from the order ID.
- Categorize sales ranges:
- >50,000: Good
- >100,000: Very Good
- >150,000: Excellent
Task 7: Dashboard Development
(A) Dashboard Requirements
-
Key Performance Indicators (KPIs):
- Total Sales
- Profit
- Sales per Customer
- Profit per Product
- 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
- Waterfall Chart
- Donut Chart
- Butterfly Chart
- Pyramid/Funnel Chart
- Histogram Chart
- 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:
- 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.
- Determine if the current date falls on a weekend or a weekday.
- Categorize employees based on experience: “Junior” (<2 years), “Mid-Level” (2-5 years), and “Senior” (>5 years).
- Display a message indicating whether each employee’s salary is above or below the average salary. Label the column as ‘Salary Status’.
- Use the CASE function to classify job titles: “Management” for titles containing “Manager”, “Technical” for titles containing “Engineer”, and “Other” for all other titles.
- Classify employees into salary bands: “Low” (<$40,000), “Medium” ($40,000-$80,000), and “High” (>$80,000).
CONVERT Function Questions:
- Convert the hire date column to ‘YYYY-MM-DD’ format as VARCHAR.
- Convert the Salary column to a currency format with two decimal places.
- Convert the hire date to “Month Day, Year” format (e.g., “August 22, 2024”).
Combining CASE and CONVERT Functions:
- 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”
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.
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
FAQ
What is Power BI, and why should I learn it?
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.
Who can enroll in this Power BI course?
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
What are the prerequisites for learning Power BI?
There are no strict prerequisites. However, a basic understanding of Excel, SQL, and data concepts can be helpful.
What topics are covered in this Power BI training?
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
Do you provide hands-on training?
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.
Will I get a certification after completing the course?
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.
What career opportunities are available after this training?
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
Do you provide placement assistance?
Yes, we provide placement support, including resume building, interview preparation, and job referrals to top companies hiring Power BI professionals.
What is the duration of the Power BI course?
The duration varies based on the training mode:
- Regular classroom training:
- Weekend batches:
- Fast-track training:
What are the training modes available?
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

