Power BI in Mumbai

Data Analytics Course with Power BI, SQL, and Tableau

At the moment, data is the biggest asset on the internet. Whilst you are reading this, there will be zillions of data uploaded to the data pool already. But you know what goes behind the hottest buzzwords “data”, “data analysis”, and “data visualization”? The definite processes of extracting, scrutinizing, synthesizing, refining, evaluating, and statistically organizing data. Again, wondering how these processes seem to work? Well, there are a set of tools and techniques that follow the process depending on the type of data, organization, and the requirements based on the organizational or business purpose.

To traverse deeper in the world of data analytics course and its crucial tools, the team of TechData Solutions offers students and professionals one of the best online courses that focuses primarily on Data analysis with Power BI, SQL, and Tableau; the top tools you need to know as a novice in the dynamics of data visualization.

Data Analysis - Process

Technically, data analysis is a systematic process that involves cleaning, transforming, and data modeling to extract clean and necessary information that enables the decision-making for any business. In layman terms, we as humans take our daily decisions by analyzing what happened in the past while considering the future consequences to make the best decisions. The same goes when businesses, organizations, and enterprises decide to make the best decisions using the data available in any format.

This five-step cycle constitutes the data analysis process:

  1. Identity the right data
  2. Collecting data
  3. Cleaning and filtering data
  4. Analyzing data sets and results
  5. Interpret data results

And repeat.

Thus, if your business lacks the desired growth, you will have to take a step back, retrospect, follow the steps, and make a way out without repeating the same mistakes. And if your business is blooming, you will have to predict the future while analyzing the best processes and the data.

Online Data Analysis - Course Curriculum

1. Data Analysis with Power BI

Model Overview

Take data visualization and reporting to next-level with Power BI, a business intelligence tool that converts the data from diverse data sources into interactive dashboards. This module certification training covers most of this tool, enabling you to solve business problems, make better decisions, and enhance the business operations. It will also help you get hands-on training on Microsoft Power BI, master the dashboard building, derive better insights from the captured data, and a lot more.

  • Laptop
  • Stable and good internet connectivity

Course Content
Power BI Advanced
Data Modeling

Learn how you can build custom calculations on tables to derive data, relationships between the tables having data to

  • Create calculated tables
  • Create calculated columns
  • Derive and manage time-based data
Data Sources

Learn how to get data from various supported data sources to your Power BI desktop

  • Flat Files
  • SQL Database
  • Azure Cloud
  • OData Feed
  • Blank Query
Reporting and visualization

Learn how to create reports by integrating the excel data with Power BI

Data Analysis Expressions (DAX)

Get thorough understanding of the primary components:

  • Introduction
  • DAX Functions
    • ○ Text
    • ○ Date
    • ○ Logical
    • ○ Counting
Best Practices
Case Studies and Assignments

2. Data Analysis with Structured Query Language

Module Overview

In this course module, you will learn how to use SQL for data extraction and analyzing data stored in the tables or databases. You will get hands-on training on how to create tables, join tables with various operations, imply functions, and perform aggregations with the basic version. Then with the advanced module, you will get trained to perform more complex analysis, visualizations, and calculations using subqueries, stored procedures, views, temp tables, and window functions. By the end of this module, you will be efficiently able to write SQL queries to perform data analysis and data visualization tasks.

  • Laptop
  • Stable and good internet connectivity

Course Content

SQL Basics

Setup and Installation

      Introduction to SQL

      Download and Installation - SQL Server

      Install SQL Server Management Studio (SSMS)

      Connect SSMS to Installed version of SQL Server

      Install Sample Database

SQL Commands

Learn to write SQL queries using the SQL commands

      SELECT - extracts data from the database.

      UPDATE - updates data in the database.

      DELETE - deletes data from the database.

      INSERT INTO - inserts new data into the database.

      CREATE DATABASE - creates the new database.

      ALTER DATABASE - modifies the existing database.

      CREATE TABLE - creates new table

      ALTER TABLE - modifies a table

      DROP TABLE - deletes the existing table

      CREATE INDEX - creates an index

      DROP INDEX - deletes an index

Create SQL Statement using commands and query the data from the database

SQL Joins

Learn how to combine data from two or multiple tables using the SQL Joins


      LEFT JOINs



      SELF JOINs

SQL Aggregations

Learn how to use common SQL aggregations in commands






Also, learn how to work with NULL values and DATA functions

SQL Advanced

Subqueries and Temp Tables

Learn to write subqueries and nested queries to execute multiple queries together and use temp tables

SQL Operators

Learn how to perform various operations on queries and data using the various types of SQL operators

Arithmetic Operators






Bitwise Operators



      Exclusive OR

Comparison Operators

      Equal to         

      Greater than  

      Less than       

      Greater than or equal to       

      Less than or equal to 

      Not equal to

Logical Operators











SQL Stored Procedures

Learn reusability with the SQL queries

SQL Keys and Constraints

Learn how to specify rules for data in a SQL table


      NOT NULL





SQL Data Cleaning, Transforming, and Backup

Learn how to perform data maintenance, cleaning using SQL and take a backup of the data or database

Best practices

3. Data Analysis with Tableau

Module Overview

This interactive module helps you master the best BI, data visualization, and reporting tool - Tableau Desktop. Learn how to effectively use the tool to efficiently create interactive dashboards, illustrate data trends, and add dimensions to the data in formats of charts and graphs. Get trained and certified and accelerate your career in data analytics through our Data Analysis with Tableau online course module.

  • Laptop
  • Stable and good internet connectivity

  • Basic understanding of terminologies used in computer programming
  • Basic knowledge about various charts and graphs
  • SQL knowledge

Course Content

Tableau Basics

Introduction and Setup

      Introduction to Tableau

      Download and Installation

      Environment setup - Desktop and Public

File Types

Learn about various extensions used in the Tableau files


      Packaged Workbook

      Data Source

      Packaged Data source


      Data Extract


Data Types

Learn about how Tableau classifies the data into various data types







Learn how to perform specific mathematical or logical manipulations. Tableau has a number of operators used to create calculated fields and formulas.

      General Operators



      Arithmetic Operators





      Relational Operators

       Equal to

       Not Equal to

       Greater than

       Lesser than    

      Logical Operators




Tableau Advanced

Data Sources

Learn how to connect the data sources using tableau’s native connectors.

      File Systems (Excel, CSV, etc.)

      Relational Systems such as SQL server, Oracle, etc.

      Cloud data sources such as Google BigQuery, Google Cloud, AWS cloud etc.

      Other Sources using ODBC


Learn about the worksheets where you can create views for data analysis, how you can perform various operations such as:







Learn about the number of inbuilt Tableau functions which help in creating expressions for complex calculations.

      Number Functions




      String Functions





      Date Functions





      Logical Functions




      Aggregate Functions





Sorting and Filtering

Learn about the basic data sorting using two sorting methods:

      Computed sorting

      Manual sorting

Learn about the filters:

      Quick filters

      Basic filters

      Context filters

      Condition filters

      Top filters

and the operations

Best practices

Case Studies and Assignments


Benefits of Enrolling in the online Data Analysis with Power BI, SQL, and Tableau course

When it comes to online courses which involve technology and data, TechData Solutions offers the best data certification courses to students, graduates, and experienced professionals who have a knack of learning new skills and take their career to new heights. Our instructor-led training modules are curated by a team of industrial experts with several years of corporate experience and practical exposure. Become a data analytics professional by enrolling in this course and explore a plethora of benefits:

  • Affordable pricing for training and certification
  • Online training on data analysis
  • Online training on data visualization with top tools and techniques
  • High quality eLearning modules
  • Conceptual-based learning experience
  • Self-paced learning
  • Weekly assignments and assessments
  • One-to-one instructor training with guidance
  • Q&A sessions with 24*7 guidance
  • Resume building
  • Interview preparation

Job and Salary Perspectives

A novice, experienced candidate in the IT industry, or someone who is looking for a career switch; with our online data analysis certification course, you can land your dream job in several industries, that include science, healthcare, business, government, criminal justice, and finance. Big tech companies across the globe have been eyeing certified candidates with niche knowledge in the areas of data analysis, data engineering, data visualization, and the like.

With our online training and certification, you can be the best fit for job profiles with titles listed below:

  • Data Analyst
  • Power BI Data Analyst
  • Business Intelligence Analyst
  • Operations Research Analyst
  • Data Scientist
  • Data Engineer
  • Medical and Healthcare Analyst
  • Market Research Analyst
  • Business Analyst
  • Project Manager

and more.

An average salary of a data analyst in India ranges between Rs 1.9 Lakhs to Rs 11.6 Lakhs which is expected to grow in future considering the bloom of data and new dimensions of technologies.


Introduction : 1

  • Business Intelligence
  • Self Service Business Intelligence
  • SSBI Tools
  • Power BI vs Tableau vs QlikView
  • What is Power BI
  • Why Power BI?
  • Key Benefits of Power BI
  • Flow of Power BI
  • Components of Power BI
  • Architecture of Power BI
  • Building Blocks of Power BI
  • Question Bank

Introduction to Python

  • Introduction to Power BI Preview
  • Download the Training Data Files
  • Introduction to Signing Up for
  • Power
  • Signing up for Power BI Preview
  • Load Data into the Power BI
  • Service Preview
  • Practical Activity

The Power BI Desktop

  • Intro to Power BI Desktop Section
  • Introduction to the Power BI Desktop Preview

Creating Reports in Power BI Desktop

  • Create Reports in Power BI Desktop Section
  • Creating Tables in Power BI
  • Table Styles and Formatting Preview
  • Matrix Visualization 06:11
  • Tables and Metrics Practical Activity
  • Answers to Tables and Metrics Practical Activity
  • Changing the Method of Aggregation
  • Methods of Aggregation Challenge
  • Methods of Aggregation Challenge Completed
  • Cards and Multi Row Cards
  • Cards, Matrix and Multi Row Card Challenge
  • Answers to Cards Challenge
  • Percentage Calculations
  • Filtering Data -Using Slicers
  • Filtering Data -Visual Filters
  • Filtering Data -Page Filters
  • Filtering Data -Drill Through Filter
  • Practical Activity -Filters
  • Practical Activity Filters Completed

DAX Measures

  • Introduction to Measures Section
  • Introduction to DAX Measures
  • DAX Measures Practical Activity
  • DAX Measures Activity Completed
  • The =Calculate Formula


  • Relationships Section
  • Creating and Managing Relationships in Power BI
  • Relationship Calculations
Power BI Query Editor:
  • Introduction to Power BI Query Editor
  • Basic Transformations -Part 1
  • Basic Transformations - Part 2
  • Aggregating Data

Graphs and Visualizations

  • Introduction to Visualization Section
  • Clustered Column Graphs
  • Stacked and 100% Graphs
  • Column Graph Challenge
  • Column Graph Challenge Completed
  • Graph Options
  • Analysis Graphs
  • Area Graphs
  • Ribbon Graphs
  • Additional Graphs
  • Scatterplots and Bubble

Interactive Dashboards

  • Creating Interactive Dashboards
  • Challenge -Create an Interactive Report
  • Completed Challenge -How to Create an Interactive Report
  • Publishing Reports to the Power BI Service
  • Pinning Visualizations to Dashboards
  • Mobile Reports
  • Q and A
  • App Workspaces
  • Publishing an App
  • Using Themes in Power BI
  • Using Custom Visualizations

DAX Formula

  • DAX Formulas Section
  • DAX Formulas
  • Date Functions
  • Formatting Dates
  • Date Master Table


  • What is a Database?
  • What is SQL?
  • Database Design Tutorial
  • What is Normalization?
  • Create Table
  • SELECT Statement
  • WHERE Clause — AND, OR, IN, NOT IN Query Example
  • INSERT INTO Query — How to add Row in Table (Example)
  • DELETE Query — How to Delete Row from a Table
  • UPDATE Query — Learn with Example
  • ORDER BY — DESC & ASC Query with EXAMPLE


  • GROUP BY and HAVING Clause - Learn with Example
  • JOINING the tables -INNER
  • Wildcards Tutorial - Like, NOT
  • Like, Escape, ( % ), ( _ )
  • Regular Expressions (REGEXP) -
  • What is, Syntax and Examples
  • SQL Functions - String, Numeric,
  • User-Defined, Stored
  • SQL Aggregate Functions Tutorial - SUM, AVG, MAX, MIN , COUNT, DISTINCT

Introduction to Tableau

  • Introduction to Tableau?
  • Tableau desktop Installation
  • Why Tableau is important?
  • Tableau interface
  • File type in Tableau

Tableau – Data Visualization

  • Connect Tableau to various Datasets: Excel and CSV files
  • Create Bar charts
  • Create Area Charts
  • Create Maps
  • Create Scatterplots
  • Create Pie charts
  • Create Tree maps
  • Create Interactive Dashboards
  • Create Storylines
  • Understand Types of Joins and how they work
  • Work with Data Blending in Tableau
  • Create Table Calculations

Tableau – Data Visualization

  • Work with Parameters
  • Create Dual Axis Charts
  • Create Calculated Fields
  • Create Calculated Fields in a Blend
  • Export Results from Tableau into Powerpoint, Word, and other software
  • Work with Timeseries Data (two methods)
  • Creating Data Extracts in Tableau
  • Understand Aggregation, Granularity, and Level of Detail
  • Adding Filters and Quick Filters
  • Create Data Hierarchies

Tableau – Data Visualization

  • Adding Actions to Dashboards (filters & highlighting)
  • Assigning Geographical Roles to Data Elements
  • Advanced Data Preparation
Enquire Now