default-logo


Book Free Demo

Data Analytics Training & Placemnet In Chennai

Looking to build a career in Data Analytics? Our Data Analytics Training & Placement program in Chennai is designed to equip you with industry-relevant skills and hands-on experience. Learn key tools like Excel, SQL, Python, Power BI, and Tableau, and gain expertise in data visualization, statistical analysis, and business intelligence. With expert-led training, real-time projects, and dedicated placement support, we ensure you are job-ready for top roles in the industry.

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

Master Data Analytics with hands-on training and real-world projects. Gain industry-relevant skills and secure top placements with expert guidance.


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

Introduction & Setup

  • Overview of Power BI and its capabilities
  • Installation and configuration of the software

Data Fundamentals

  • Understanding various data types and structures
  • Key principles of data modeling

DAX Functions

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

Time Intelligence Functions

  • Advanced date-based calculations for data analysis

Power Query & Data Processing

  • Connecting to diverse data sources, including files and databases
  • Transforming data: renaming, modifying types, handling duplicates, filtering, sorting, merging, pivoting, and unpivoting
  • Effective error management and data processing optimization

Data Structuring & Extraction

  • Organizing and managing dataset columns
  • Splitting, selecting, and performing join operations on data
  • Appending, duplicating, merging queries, and building dimension tables

Data Visualization & Dashboarding

  • Designing interactive dashboards with customized formatting
  • Integrating Power BI with cloud platforms for seamless reporting
  • Introduction to Tableau: Learn about the interface, available products, and essential desktop features.
  • Understanding Data Types: Explore different data types and their significance in visualization.
  • Data Connections: Discover various connection types for seamless data integration.
  • Dimensions & Measures: Learn to differentiate and utilize dimensions and measures effectively.
  • Discrete vs. Continuous Data: Understand their concepts and applications in Tableau.
  • File Extensions in Tableau: Get insights into supported file types and their functions.
  • Advanced Data Grouping: Work with groups, sets, parameters, hierarchies, and combined sets.
  • Filtering Techniques: Implement data source, extract, dimension, measure, cascading, and context filters.
  • Tableau Functions: Explore numerical, aggregate, logical, string, date functions, table calculations, and analytics.
  • Level of Detail (LOD) & Bins: Learn about LOD expressions and data binning techniques.
  • Axes & Charts: Master different chart types and axis configurations.
  • Maps & Filters: Implement interactive mapping and filtering methods.
  • Dashboard Development: Build interactive and engaging dashboards.
  • Dashboard Actions: Configure actions for enhanced interactivity.
  • Data Modeling: Understand relationships, joins, and data blending.
  • Joins & Cross-Database Joins: Learn to work with joins across databases.
  • Tableau Server & Tableau Online: Introduction to deployment, publishing, and management.
  • Embedded & Published Data Sources: Work with various data source configurations.
  • User Access & Security: Manage roles, access controls, and row-level security (RLS).
  • Alerts, Subscriptions & Metrics: Set up notifications, scheduled reports, and performance tracking.
  • Handling Extract Issues: Troubleshoot data extraction problems, including empty extracts.
  • Introduction and Fundamentals
  • Setup and Installation
  • Building Databases and Tables
  • Exploring Different Data Types
  • Effective Use of Operators
  • Text Formatting Functions (UPPER(), LOWER(), INITCAP())
  • String Handling Functions (SUBSTRING(), CONCAT(), LEN(), TRIM(), REPLACE())
  • Essential Functions (Date, Null Handling, Numeric, General)
  • Aggregation and Grouping (COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, HAVING)
  • Analytical and Window Functions
  • SQL Commands (DDL, DML, TCL, DQL)
  • Joins and Relationships (INNER, LEFT, RIGHT, FULL, CROSS)
  • Data Integrity and Constraints (NOT NULL, PRIMARY KEY, UNIQUE, FOREIGN KEY, DEFAULT, INDEX, CHECK)
  • Set Operators (UNION, UNION ALL, MINUS, INTERSECT)
  • Views and Materialized Views
  • Subqueries and Nested Queries
  • Special and Pseudo Columns (ROWID, ROWNUM, LEVEL, CONNECT_BY_ISLEAF, SYS_GUID())

Introduction

  • Setting up the environment and installation
  • Installing Python, Anaconda, and Jupyter Notebook

Programming Fundamentals

  • Understanding the difference between compilation and interpretation
  • Writing your first Python script
  • Creating a “Hello World” program

Core Python Concepts

  • Working with variables and assignments
  • Exploring different data types and their applications
  • Performing computations using operators

Control Flow & Functions

  • Implementing conditional statements: if, if-else, elif
  • Using loops: for loop, while loop
  • Defining functions and utilizing built-in methods

Data Structures & Iteration Tools

  • Understanding lists, tuples, sets, and dictionaries
  • Using iteration tools like map and filter

Advanced Python Topics

  • Implementing regular expressions
  • Managing modules, packages, and PIP

Error Handling & Object-Oriented Programming

  • Handling exceptions effectively
  • Understanding OOP concepts: classes, objects, constructors, and attributes
  • Exploring inheritance, encapsulation, and polymorphism

Additional Python Features

  • Working with lambda (anonymous) functions
  • Utilizing essential Python libraries like NumPy, Pandas, and Matplotlib
  • Understanding generators and closures
  • Send automated emails to Gmail with file attachments from OneDrive.
  • Generate new groups dynamically using Microsoft Forms.
  • Schedule automated greeting emails for birthdays and weddings.
  • Set up Power BI alerts for notifications in Microsoft Teams and Outlook.
  • Automate dataset refresh operations seamlessly.
  • Utilize aggregate and grouping functions like COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.

Introduction
Begin your journey by setting up a seamless development environment and configuring essential tools.

Fundamental Concepts
Learn about variables, data structures, and managing collections, including creation, access, modification, iteration, and cleanup.

Application Development
Automate tasks like email generation for birthdays and key events while exploring Canvas and Model-Driven Apps. Work with data sources, controls, expressions, and screens for dynamic applications.

Seamless Data Integration & User Interaction
Utilize formulas, variables, and contextual data to enhance app functionality. Handle user inputs effectively with interactive elements.

Functions & Expressions
Understand key functions related to data, control, math, text, logic, and date/time operations. Use expressions like OnSelect, OnClick, Launch, and Navigation for dynamic responses.

Advanced Development Techniques
Build Canvas Apps integrated with SQL and SharePoint, implement data validation, design interactive forms and galleries, and perform CRUD operations.

Power BI Integration
Seamlessly connect Power BI with Power Apps, design interactive reports, generate embed codes, and configure dynamic features for an enhanced user experience.

Testing, Deployment & Implementation
Ensure a smooth launch by thoroughly testing, deploying, and finalizing app functionality for optimal performance.

Introduction & Setup

  • Overview of Power BI and its capabilities
  • Installation and configuration of the software

Data Fundamentals

  • Understanding various data types and structures
  • Key principles of data modeling

DAX Functions

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

Time Intelligence Functions

  • Advanced date-based calculations for data analysis

Power Query & Data Processing

  • Connecting to diverse data sources, including files and databases
  • Transforming data: renaming, modifying types, handling duplicates, filtering, sorting, merging, pivoting, and unpivoting
  • Effective error management and data processing optimization

Data Structuring & Extraction

  • Organizing and managing dataset columns
  • Splitting, selecting, and performing join operations on data
  • Appending, duplicating, merging queries, and building dimension tables

Data Visualization & Dashboarding

  • Designing interactive dashboards with customized formatting
  • Integrating Power BI with cloud platforms for seamless reporting
  • Introduction to Tableau: Learn about the interface, available products, and essential desktop features.
  • Understanding Data Types: Explore different data types and their significance in visualization.
  • Data Connections: Discover various connection types for seamless data integration.
  • Dimensions & Measures: Learn to differentiate and utilize dimensions and measures effectively.
  • Discrete vs. Continuous Data: Understand their concepts and applications in Tableau.
  • File Extensions in Tableau: Get insights into supported file types and their functions.
  • Advanced Data Grouping: Work with groups, sets, parameters, hierarchies, and combined sets.
  • Filtering Techniques: Implement data source, extract, dimension, measure, cascading, and context filters.
  • Tableau Functions: Explore numerical, aggregate, logical, string, date functions, table calculations, and analytics.
  • Level of Detail (LOD) & Bins: Learn about LOD expressions and data binning techniques.
  • Axes & Charts: Master different chart types and axis configurations.
  • Maps & Filters: Implement interactive mapping and filtering methods.
  • Dashboard Development: Build interactive and engaging dashboards.
  • Dashboard Actions: Configure actions for enhanced interactivity.
  • Data Modeling: Understand relationships, joins, and data blending.
  • Joins & Cross-Database Joins: Learn to work with joins across databases.
  • Tableau Server & Tableau Online: Introduction to deployment, publishing, and management.
  • Embedded & Published Data Sources: Work with various data source configurations.
  • User Access & Security: Manage roles, access controls, and row-level security (RLS).
  • Alerts, Subscriptions & Metrics: Set up notifications, scheduled reports, and performance tracking.
  • Handling Extract Issues: Troubleshoot data extraction problems, including empty extracts.
  • Introduction and Fundamentals
  • Setup and Installation
  • Building Databases and Tables
  • Exploring Different Data Types
  • Effective Use of Operators
  • Text Formatting Functions (UPPER(), LOWER(), INITCAP())
  • String Handling Functions (SUBSTRING(), CONCAT(), LEN(), TRIM(), REPLACE())
  • Essential Functions (Date, Null Handling, Numeric, General)
  • Aggregation and Grouping (COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, HAVING)
  • Analytical and Window Functions
  • SQL Commands (DDL, DML, TCL, DQL)
  • Joins and Relationships (INNER, LEFT, RIGHT, FULL, CROSS)
  • Data Integrity and Constraints (NOT NULL, PRIMARY KEY, UNIQUE, FOREIGN KEY, DEFAULT, INDEX, CHECK)
  • Set Operators (UNION, UNION ALL, MINUS, INTERSECT)
  • Views and Materialized Views
  • Subqueries and Nested Queries
  • Special and Pseudo Columns (ROWID, ROWNUM, LEVEL, CONNECT_BY_ISLEAF, SYS_GUID())

Introduction

  • Setting up the environment and installation
  • Installing Python, Anaconda, and Jupyter Notebook

Programming Fundamentals

  • Understanding the difference between compilation and interpretation
  • Writing your first Python script
  • Creating a “Hello World” program

Core Python Concepts

  • Working with variables and assignments
  • Exploring different data types and their applications
  • Performing computations using operators

Control Flow & Functions

  • Implementing conditional statements: if, if-else, elif
  • Using loops: for loop, while loop
  • Defining functions and utilizing built-in methods

Data Structures & Iteration Tools

  • Understanding lists, tuples, sets, and dictionaries
  • Using iteration tools like map and filter

Advanced Python Topics

  • Implementing regular expressions
  • Managing modules, packages, and PIP

Error Handling & Object-Oriented Programming

  • Handling exceptions effectively
  • Understanding OOP concepts: classes, objects, constructors, and attributes
  • Exploring inheritance, encapsulation, and polymorphism

Additional Python Features

  • Working with lambda (anonymous) functions
  • Utilizing essential Python libraries like NumPy, Pandas, and Matplotlib
  • Understanding generators and closures
  • Send automated emails to Gmail with file attachments from OneDrive.
  • Generate new groups dynamically using Microsoft Forms.
  • Schedule automated greeting emails for birthdays and weddings.
  • Set up Power BI alerts for notifications in Microsoft Teams and Outlook.
  • Automate dataset refresh operations seamlessly.
  • Utilize aggregate and grouping functions like COUNT(), SUM(), AVG(), MIN(), MAX(), GROUP BY, and HAVING.

Introduction
Begin your journey by setting up a seamless development environment and configuring essential tools.

Fundamental Concepts
Learn about variables, data structures, and managing collections, including creation, access, modification, iteration, and cleanup.

Application Development
Automate tasks like email generation for birthdays and key events while exploring Canvas and Model-Driven Apps. Work with data sources, controls, expressions, and screens for dynamic applications.

Seamless Data Integration & User Interaction
Utilize formulas, variables, and contextual data to enhance app functionality. Handle user inputs effectively with interactive elements.

Functions & Expressions
Understand key functions related to data, control, math, text, logic, and date/time operations. Use expressions like OnSelect, OnClick, Launch, and Navigation for dynamic responses.

Advanced Development Techniques
Build Canvas Apps integrated with SQL and SharePoint, implement data validation, design interactive forms and galleries, and perform CRUD operations.

Power BI Integration
Seamlessly connect Power BI with Power Apps, design interactive reports, generate embed codes, and configure dynamic features for an enhanced user experience.

Testing, Deployment & Implementation
Ensure a smooth launch by thoroughly testing, deploying, and finalizing app functionality for optimal performance.

Experience

Gain hands-on experience with real-world data analytics projects, guided by industry experts. Our training ensures you master key skills and secure top placements in leading companies.

Education

Master Data Analytics with expert-led training and hands-on projects. Secure top placements with our industry-focused guidance.

Certificate

Earn your Data Analytics Certification from Greens Technology and boost your career prospects. Our industry-recognized certification validates your expertise and enhances job opportunities.

Our Data Analytics Training

Take your data skills to the next level with our Data Analytics Training.



Get Started

Greens Technologies

Course Options:


Start Course

One-on-One Mentoring

Get personalized guidance with our One-on-One Mentoring in Data Analytics training. Our experts provide tailored support to help you master skills and secure top placements.

Hybrid Learning

Our Hybrid Learning approach offers the flexibility of both online and in-person sessions, ensuring you gain hands-on experience in Data Analytics while balancing your schedule. With expert-led training and real-world projects, you’ll be job-ready with placement support from Greens Technology.

Online Learning

Master Data Analytics with our comprehensive online training program. Gain in-demand skills and secure top placements with expert guidance.

Fast-Track Courses

Accelerate your career with our Fast-Track Data Analytics Training & Placement program. Gain industry-relevant skills quickly and secure job opportunities with expert guidance.

Data Speaks Louder Than Words

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

Features of Our Data Analytics Training & Placement

Expert-Led Training

Learn from industry-experienced professionals.

Hands-On Projects

Work on real-world data analytics tasks.

Certification Support

Get assistance for top industry certifications.

Job Assistance

Dedicated support for resume and interview prep.

Flexible Learning

Choose classroom or online training options.

Live Case Studies

Analyze real industry datasets and trends.

Advanced Tools

Master Python, SQL, Excel, and Power BI.

One-on-One Mentorship

Personalized guidance from analytics experts.

Practical Experience

Work on live industry projects hands-on.

Lifetime Access

Revisit course materials anytime for revisions.

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
      • Visualize region-wise sales using a pie chart with tooltips showing profit and discounts.
      • Represent date-wise sales through a line chart.
      • Design a distinctive chart to display sales by category and sub-category.
      • Create a treemap using Region and Discount as key metrics.
      • Develop a bubble chart showcasing Subcategory and Profit.
      • Analyze state-wise sales using a box-and-whisker plot.
      • Generate 24 charts utilizing custom metrics from the “Show Me” panel.
      Task 2: Level of Detail (LOD)
      • Identify the last order date for each product.
      • Determine the most recent purchase for each customer.
      • Visualize total sales at the sub-category level using Category, Sub-Category, State, and Sales.
      • Classify product count based on defined sales ranges (0–1000).
      Task 3: Analytics & Quick Table Calculations
      • Forecast sales trends for 2021.
      • Compare actual sales against a chosen target value.
      • Cluster sub-categories based on data trends.
      • Create a text-based chart incorporating Region, Segment, Category, Sub-Category, and Sales with row and sub-totals.
      • Develop a bar chart to display average sales by Region.
      • Calculate cumulative sales for each customer.
      • Determine the sales difference between previous and current values at the sub-category level.
      Task 4: Dual/Blended/Sync Filters
      • Design a single visualization incorporating Sales, Discount, Profit, and Category.
      • Compare current-year profit and sales within one chart.
      • Implement a context filter for Category and Sub-Category.
      • Set up a cascading filter for Category and Sub-Category.
      Task 5: Grouping, Sets, Parameters, and Hierarchies
      • Identify top-performing products based on Profit and Product.
      • Display the top and bottom five sub-categories by sales.
      • Enable multiple graphs on a single sheet using metrics such as Profit, Total Sales, and Profit Ratio.
      • Implement drill-down functionality for all product-related fields.
      • Develop a grouped and combined visualization using a customized approach.
      • Create a date parameter using Ship Date to reflect across all charts.
      Task 6: Functions
      • Show the last date of the current month.
      • Calculate remaining days until the year’s end.
      • Identify the most recent purchase date for each customer.
      • Count total records per sub-category.
      • Convert “appliances” to “Appliances” (capitalize first letter).
      • Display total sales for each category.
      • Count sales per category while excluding duplicates.
      • Retrieve the second order date for each customer.
      • List all customers whose names begin with “A.”
      • Identify customers whose names end with “H.”
      • Extract the year from the Order ID.
      • Categorize sales into three ranges:
        • Above 50,000: Good
        • Above 100,000: Very Good
        • Above 150,000: Excellent
      Task 7: Dashboard Creation

      Key Performance Indicators (KPIs):

      • Sales
      • Profit
      • Sales per Customer
      • Profit per Product
      • Sales Growth Compared to the Previous Year

      Dashboard Components:

      • Include two filters and a date parameter.
      • Incorporate at least six charts:
        • Year-over-Year (YOY) Analysis
        • Four custom-designed charts
        • One tailored visualization
        • One map-based chart
      • Enable action filters for interactive data analysis.
      Weekend Task 01: Custom Charts
      • Waterfall Chart
      • Donut Chart
      • Butterfly Chart
      • Pyramid/Funnel Chart
      • Histogram Chart
      • Heat Map and Treemap using Profit and Sales
      Weekend Task 02: Dashboard Development
      • Source data from Tableau Public and build a detailed dashboard.
      • Apply two filters and a date parameter for dynamic interaction.
      Tableau Limitations
      • Maximum Rows: Unlimited
      • Maximum Columns: 50
      • Maximum Table Joins: 32
      • Default Join Type: Inner Join (modifiable)
      • Blended Data Join: Left Outer Join by default
      • Maximum Worksheets: 155
      • Maximum Parameters: 155
      Power Query
      • Efficient data transformation and connectivity.
      Data Visualization & Power BI Desktop
      • Create dynamic reports and dashboards.
      M Query
      • Automate and optimize data processing.
      Power Query Editor
      • Extract, transform, and load (ETL) data efficiently.
      Data Modeling
      • Build structured relationships for insightful analysis.
      DAX Functions
      • Perform advanced calculations and aggregations.
      Power BI Visuals
      • Enhance reports with interactive charts and graphs.
      Power BI Service
      • Publish, share, and collaborate on reports online.
      Report Views
      • Customize layouts for better data presentation.
      Data View
      • Explore raw data in structured format.
      Model View
      • Manage relationships between multiple datasets.
      Transform Data
      • Modify and optimize existing data structures.
      Add Column
      • Create customized columns for analysis.
      Transformation Options
      • Various tools for reshaping and organizing data.
      Data Types
      • Supports numeric, text, date, and Boolean formats.
      Data Operations
      • Perform header adjustments, transpositions, and modifications.
      Formatting Options
      • Change case, trim, merge, and parse data.
      Statistical Functions
      • Calculate sum, average, median, and deviations.
      Mathematical & Scientific Functions
      • Perform standard and advanced calculations.
      Standard Calculations
      • Execute addition, subtraction, and percentage functions.
      Scientific Operations
      • Compute power, logarithm, and square root values.
      Rounding Functions
      • Round up, down, or to the nearest value.
      Date & Time Functions
      • Extract and manipulate date and time components.
      Column Operations
      • Create custom, conditional, and indexed columns.
      Data Management & Queries
      • Manage data connections and refresh data.
      Home Functions
      • Sort, filter, remove, and group data efficiently.
      Merging & Appending Queries
      • Merge and append datasets using various joins.
      DAX – Data Analytics Expressions
      • Perform complex calculations with optimized performance.
      Calculated Columns & Measures
      • Create memory-efficient calculations and aggregations.
      Date & Logical Functions
      • Apply conditional logic and date-based calculations.
      Text Functions
      • Format and manipulate text data effectively.
      Time Intelligence Functions
      • Analyze trends with YTD, QTD, and MTD calculations.
      Information & Aggregate Functions
      • Validate data and perform filtering operations.
      Power BI Service
      • Publish, share, and refresh reports seamlessly.

      SQL Tasks – Hands-On Practice

      Day 1: Filtering and Sorting Data

      • Retrieve names beginning with ‘S’.
      • Find names starting with ‘S’ and ending with ‘n’.
      • List employees in department 90 whose names start with ‘S’.
      • Display employees from departments 10, 20, 50, and 90.
      • Retrieve names, salaries, and department IDs outside these departments.
      • Find employees with salaries between 5000 and 7000.
      • List employees without managers.
      • Retrieve all employee records sorted by first name.
      • Display department ID and salary, sorted by department (asc) and salary (desc).
      • Find employees earning more than $12,000.
      • Retrieve last name and department number for employee ID 176.
      • Show employees hired between Feb 20, 2003, and May 1, 2005.
      • List employees from departments 20 and 50 in alphabetical order.
      • Show job titles of employees without managers.
      • Display salary and commission details for employees receiving commissions.

      Day 2: Aggregate Functions

      • Count total employees.
      • Calculate the average salary.
      • Identify highest and lowest salaries.
      • Determine the average salary per department.
      • Find departments with more than 5 employees.
      • Compute the average salary for those earning above $50,000.
      • Calculate total salary expense per department.
      • Count employee hires per year, month, and weekday.
      • Count employees with the same job title.
      • Display max, min, sum, and average salaries.
      • Find salary statistics per job type.
      • Compute the difference between highest and lowest salaries.
      • Count total managers.

      Day 3: Analytical vs. Aggregate Functions

      • Compute the organization’s average salary.
      • Calculate department-wise average salary.
      • Show average salary alongside each employee.
      • Find cumulative salary per department and company-wide.
      • Rank employee salaries within departments.
      • Identify the highest and lowest salaries per department.
      • Find oldest and newest employees per department.

      Day 4: Date Functions

      • Retrieve the current date and time.
      • Extract year, month, and day from a date.
      • Calculate the difference between two dates in days.
      • Format dates in SQL Server.
      • Add and subtract days from a date.
      • Identify the first and last day of the current month.
      • Extract the quarter of the year from a date.
      • Determine the number of weeks between two dates.
      • Compute hours, minutes, and seconds between two timestamps.

      Day 5: String Functions

      • Extract first names from full names.
      • Convert employee names to uppercase.
      • Retrieve employees with names starting with ‘J’.
      • Concatenate first and last names.
      • Format phone numbers with dashes.
      • Find employees with specific email domains.
      • Identify last names with exactly five characters.
      • Extract the domain from email addresses.
      • Replace specific characters in strings.
      • Reverse characters in last names.

      Day 6: Case & Convert Functions

      • Indicate whether employees receive commissions.
      • Classify employees based on experience levels.
      • Categorize employee salaries as Low, Medium, or High.
      • Convert hire dates into various formats.
      • Use CASE to label employees by job title.

      Day 7: Data Definition Language (DDL)

      Creating and Modifying Tables
      • Create an Employees table with EmployeeId, FirstName, LastName, HireDate, and Salary.
      • Add an EmailAddress column to the Employees table.
      • Allow NULL values in the Salary column.
      • Rename the LastName column to Surname.
      Dropping and Renaming Tables
      • Remove the Employees table from the database.
      • Rename the Employees table to Staff.
      Constraints and Indexes
      • Apply a unique constraint to the EmailAddress column.
      • Establish a foreign key linking Employees and Departments.
      • Retrieve a list of all tables in the database.
      • Create a Projects table with ID, ProjectName, StartDate, and Budget.

      Day 8: Data Manipulation Language (DML) & Transaction Control Language (TCL)

      Data Manipulation
      • Insert a new employee with EmployeeId 101.
      • Update EmployeeId 101’s salary to 80,000.
      • Delete EmployeeId 101 from Employees.
      • Assign DepartmentId 5 to employees earning above 70,000.
      • Insert multiple records into Projects.
      • Fetch all Employees and replace NULL values in EmailAddress.
      • Set NULL CommissionPCT values to 0.
      • Bulk insert into Projects in a single query.
      • Delete Projects with StartDate before 2024-03-01.
      • Update EmailAddress for employees with LastName ‘Doe’.
      Transactions
      • Define transactions and their significance in SQL Server.
      • Explain the COMMIT statement.
      • Describe the ROLLBACK function.
      • Discuss SAVEPOINT and its applications.
      • Compare COMMIT, ROLLBACK, and SAVE TRANSACTION.

       

      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
          • Visualize region-wise sales using a pie chart with tooltips showing profit and discounts.
          • Represent date-wise sales through a line chart.
          • Design a distinctive chart to display sales by category and sub-category.
          • Create a treemap using Region and Discount as key metrics.
          • Develop a bubble chart showcasing Subcategory and Profit.
          • Analyze state-wise sales using a box-and-whisker plot.
          • Generate 24 charts utilizing custom metrics from the “Show Me” panel.
          Task 2: Level of Detail (LOD)
          • Identify the last order date for each product.
          • Determine the most recent purchase for each customer.
          • Visualize total sales at the sub-category level using Category, Sub-Category, State, and Sales.
          • Classify product count based on defined sales ranges (0–1000).
          Task 3: Analytics & Quick Table Calculations
          • Forecast sales trends for 2021.
          • Compare actual sales against a chosen target value.
          • Cluster sub-categories based on data trends.
          • Create a text-based chart incorporating Region, Segment, Category, Sub-Category, and Sales with row and sub-totals.
          • Develop a bar chart to display average sales by Region.
          • Calculate cumulative sales for each customer.
          • Determine the sales difference between previous and current values at the sub-category level.
          Task 4: Dual/Blended/Sync Filters
          • Design a single visualization incorporating Sales, Discount, Profit, and Category.
          • Compare current-year profit and sales within one chart.
          • Implement a context filter for Category and Sub-Category.
          • Set up a cascading filter for Category and Sub-Category.
          Task 5: Grouping, Sets, Parameters, and Hierarchies
          • Identify top-performing products based on Profit and Product.
          • Display the top and bottom five sub-categories by sales.
          • Enable multiple graphs on a single sheet using metrics such as Profit, Total Sales, and Profit Ratio.
          • Implement drill-down functionality for all product-related fields.
          • Develop a grouped and combined visualization using a customized approach.
          • Create a date parameter using Ship Date to reflect across all charts.
          Task 6: Functions
          • Show the last date of the current month.
          • Calculate remaining days until the year’s end.
          • Identify the most recent purchase date for each customer.
          • Count total records per sub-category.
          • Convert “appliances” to “Appliances” (capitalize first letter).
          • Display total sales for each category.
          • Count sales per category while excluding duplicates.
          • Retrieve the second order date for each customer.
          • List all customers whose names begin with “A.”
          • Identify customers whose names end with “H.”
          • Extract the year from the Order ID.
          • Categorize sales into three ranges:
            • Above 50,000: Good
            • Above 100,000: Very Good
            • Above 150,000: Excellent
          Task 7: Dashboard Creation

          Key Performance Indicators (KPIs):

          • Sales
          • Profit
          • Sales per Customer
          • Profit per Product
          • Sales Growth Compared to the Previous Year

          Dashboard Components:

          • Include two filters and a date parameter.
          • Incorporate at least six charts:
            • Year-over-Year (YOY) Analysis
            • Four custom-designed charts
            • One tailored visualization
            • One map-based chart
          • Enable action filters for interactive data analysis.
          Weekend Task 01: Custom Charts
          • Waterfall Chart
          • Donut Chart
          • Butterfly Chart
          • Pyramid/Funnel Chart
          • Histogram Chart
          • Heat Map and Treemap using Profit and Sales
          Weekend Task 02: Dashboard Development
          • Source data from Tableau Public and build a detailed dashboard.
          • Apply two filters and a date parameter for dynamic interaction.
          Tableau Limitations
          • Maximum Rows: Unlimited
          • Maximum Columns: 50
          • Maximum Table Joins: 32
          • Default Join Type: Inner Join (modifiable)
          • Blended Data Join: Left Outer Join by default
          • Maximum Worksheets: 155
          • Maximum Parameters: 155
          Power Query
          • Efficient data transformation and connectivity.
          Data Visualization & Power BI Desktop
          • Create dynamic reports and dashboards.
          M Query
          • Automate and optimize data processing.
          Power Query Editor
          • Extract, transform, and load (ETL) data efficiently.
          Data Modeling
          • Build structured relationships for insightful analysis.
          DAX Functions
          • Perform advanced calculations and aggregations.
          Power BI Visuals
          • Enhance reports with interactive charts and graphs.
          Power BI Service
          • Publish, share, and collaborate on reports online.
          Report Views
          • Customize layouts for better data presentation.
          Data View
          • Explore raw data in structured format.
          Model View
          • Manage relationships between multiple datasets.
          Transform Data
          • Modify and optimize existing data structures.
          Add Column
          • Create customized columns for analysis.
          Transformation Options
          • Various tools for reshaping and organizing data.
          Data Types
          • Supports numeric, text, date, and Boolean formats.
          Data Operations
          • Perform header adjustments, transpositions, and modifications.
          Formatting Options
          • Change case, trim, merge, and parse data.
          Statistical Functions
          • Calculate sum, average, median, and deviations.
          Mathematical & Scientific Functions
          • Perform standard and advanced calculations.
          Standard Calculations
          • Execute addition, subtraction, and percentage functions.
          Scientific Operations
          • Compute power, logarithm, and square root values.
          Rounding Functions
          • Round up, down, or to the nearest value.
          Date & Time Functions
          • Extract and manipulate date and time components.
          Column Operations
          • Create custom, conditional, and indexed columns.
          Data Management & Queries
          • Manage data connections and refresh data.
          Home Functions
          • Sort, filter, remove, and group data efficiently.
          Merging & Appending Queries
          • Merge and append datasets using various joins.
          DAX – Data Analytics Expressions
          • Perform complex calculations with optimized performance.
          Calculated Columns & Measures
          • Create memory-efficient calculations and aggregations.
          Date & Logical Functions
          • Apply conditional logic and date-based calculations.
          Text Functions
          • Format and manipulate text data effectively.
          Time Intelligence Functions
          • Analyze trends with YTD, QTD, and MTD calculations.
          Information & Aggregate Functions
          • Validate data and perform filtering operations.
          Power BI Service
          • Publish, share, and refresh reports seamlessly.

          SQL Tasks – Hands-On Practice

          Day 1: Filtering and Sorting Data

          • Retrieve names beginning with ‘S’.
          • Find names starting with ‘S’ and ending with ‘n’.
          • List employees in department 90 whose names start with ‘S’.
          • Display employees from departments 10, 20, 50, and 90.
          • Retrieve names, salaries, and department IDs outside these departments.
          • Find employees with salaries between 5000 and 7000.
          • List employees without managers.
          • Retrieve all employee records sorted by first name.
          • Display department ID and salary, sorted by department (asc) and salary (desc).
          • Find employees earning more than $12,000.
          • Retrieve last name and department number for employee ID 176.
          • Show employees hired between Feb 20, 2003, and May 1, 2005.
          • List employees from departments 20 and 50 in alphabetical order.
          • Show job titles of employees without managers.
          • Display salary and commission details for employees receiving commissions.

          Day 2: Aggregate Functions

          • Count total employees.
          • Calculate the average salary.
          • Identify highest and lowest salaries.
          • Determine the average salary per department.
          • Find departments with more than 5 employees.
          • Compute the average salary for those earning above $50,000.
          • Calculate total salary expense per department.
          • Count employee hires per year, month, and weekday.
          • Count employees with the same job title.
          • Display max, min, sum, and average salaries.
          • Find salary statistics per job type.
          • Compute the difference between highest and lowest salaries.
          • Count total managers.

          Day 3: Analytical vs. Aggregate Functions

          • Compute the organization’s average salary.
          • Calculate department-wise average salary.
          • Show average salary alongside each employee.
          • Find cumulative salary per department and company-wide.
          • Rank employee salaries within departments.
          • Identify the highest and lowest salaries per department.
          • Find oldest and newest employees per department.

          Day 4: Date Functions

          • Retrieve the current date and time.
          • Extract year, month, and day from a date.
          • Calculate the difference between two dates in days.
          • Format dates in SQL Server.
          • Add and subtract days from a date.
          • Identify the first and last day of the current month.
          • Extract the quarter of the year from a date.
          • Determine the number of weeks between two dates.
          • Compute hours, minutes, and seconds between two timestamps.

          Day 5: String Functions

          • Extract first names from full names.
          • Convert employee names to uppercase.
          • Retrieve employees with names starting with ‘J’.
          • Concatenate first and last names.
          • Format phone numbers with dashes.
          • Find employees with specific email domains.
          • Identify last names with exactly five characters.
          • Extract the domain from email addresses.
          • Replace specific characters in strings.
          • Reverse characters in last names.

          Day 6: Case & Convert Functions

          • Indicate whether employees receive commissions.
          • Classify employees based on experience levels.
          • Categorize employee salaries as Low, Medium, or High.
          • Convert hire dates into various formats.
          • Use CASE to label employees by job title.

          Day 7: Data Definition Language (DDL)

          Creating and Modifying Tables
          • Create an Employees table with EmployeeId, FirstName, LastName, HireDate, and Salary.
          • Add an EmailAddress column to the Employees table.
          • Allow NULL values in the Salary column.
          • Rename the LastName column to Surname.
          Dropping and Renaming Tables
          • Remove the Employees table from the database.
          • Rename the Employees table to Staff.
          Constraints and Indexes
          • Apply a unique constraint to the EmailAddress column.
          • Establish a foreign key linking Employees and Departments.
          • Retrieve a list of all tables in the database.
          • Create a Projects table with ID, ProjectName, StartDate, and Budget.

          Day 8: Data Manipulation Language (DML) & Transaction Control Language (TCL)

          Data Manipulation
          • Insert a new employee with EmployeeId 101.
          • Update EmployeeId 101’s salary to 80,000.
          • Delete EmployeeId 101 from Employees.
          • Assign DepartmentId 5 to employees earning above 70,000.
          • Insert multiple records into Projects.
          • Fetch all Employees and replace NULL values in EmailAddress.
          • Set NULL CommissionPCT values to 0.
          • Bulk insert into Projects in a single query.
          • Delete Projects with StartDate before 2024-03-01.
          • Update EmailAddress for employees with LastName ‘Doe’.
          Transactions
          • Define transactions and their significance in SQL Server.
          • Explain the COMMIT statement.
          • Describe the ROLLBACK function.
          • Discuss SAVEPOINT and its applications.
          • Compare COMMIT, ROLLBACK, and SAVE TRANSACTION.

           

          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 Data Analytics Training?

          Data analytics is a high-demand skill that helps businesses make data-driven decisions. With structured training, you gain expertise in data visualization, SQL, Python, and business intelligence tools. This course enhances career opportunities, offering hands-on experience and placement support to secure top analytics roles.


          Start Course

          Google Reviews​


          • Velachery Chennai

          0
          ★★★★★ 5/5
          2,394 Ratings
          “WITH TRAINER Mr. VELUMANI in Velachery Branch Very Good
          Experience and Gain the knowledge in Tableau, power bi,sql and very good trainer”
          ★★★★★ 5/5

          Akshuu

          “WITH trainer Mr. VELUMANI in Velachery Branch i am really delighted about with my data analytics tools(python,sql, power bi, tableau) Training course and i am surprised to see the depth of your knowledge”
          ★★★★★ 5/5

          Janani Priya

          “Greens technologies Velachery is ah best training institute for professional courses like data analytics, app development and web development, i am doing here data analytics course thanks to trainers, theirs teching and practical session are good. I recommend freshers and people who are looking for carrier change, greens technologies Velachery is best place for that.”
          ★★★★★ 5/5

          Harish Harish

          “I had a valuable learning experience with the DATA ANALYTICS TEAM – DAS
          WITH TRAINER Mr. VELUMANI in Velachery Branch This opportunity allowed me to enhance my skills in Tableau, SQL, Power BI, and Python, providing hands-on experience in data analytics.”

          Akshaya Malu

          ★★★★★ 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

          Anyone interested in data analytics, including fresh graduates, working professionals, and career switchers.

          No, our training covers everything from basics to advanced concepts, making it beginner-friendly.

          You’ll gain expertise in SQL, Python, Excel, Power BI, and other industry-standard analytics tools.

          We offer both online and classroom training options for flexible learning.

          Yes, you’ll work on real-world projects and case studies to build practical skills.

          Anyone interested in data analytics, including fresh graduates, working professionals, and career switchers.

          No, our training covers everything from basics to advanced concepts, making it beginner-friendly.

          You’ll gain expertise in SQL, Python, Excel, Power BI, and other industry-standard analytics tools.

          We offer both online and classroom training options for flexible learning.

          Yes, you’ll work on real-world projects and case studies to build practical skills.

          Yes, you’ll receive a course completion certificate along with guidance for industry-recognized certifications.

          Yes, we offer resume building, interview preparation, and job placement support.

          The duration varies based on the learning mode, typically ranging from 2 to 4 months.

          You can pursue roles like Data Analyst, Business Analyst, or BI Analyst in top companies.

          You can contact us through our website or visit our center for enrollment details and fee structure.

          Yes, you’ll receive a course completion certificate along with guidance for industry-recognized certifications.

          Yes, we offer resume building, interview preparation, and job placement support.

          The duration varies based on the learning mode, typically ranging from 2 to 4 months.

          You can pursue roles like Data Analyst, Business Analyst, or BI Analyst in top companies.

          You can contact us through our website or visit our center for enrollment details and fee structure.


          Upcoming Batch Dates  
            
            
               
                          

          Chennai

                   

                       

          91 9677273272




          Chennai


           91 9677273272


          WhatsApp-logo-button-image