Intro to SQL

SQL for Visualization

Intermediate SQL

Advanced SQL Queries

Excel for Visualization Engineers

Intermediate Excel Concepts

Advanced Excel Concepts

Fundamentals of Data Science

Introduction to Business Intelligence (BI)

What is Power BI

Why Power BI?

Components of Power BI

The architecture of Power BI

SSBI Tools

Building blocks of Power BI

The flow of Power BI

Power BI vs. Tableau vs. QlikView

Key Benefits of Power BI

Hands-On Practical's

Interview Questions

Overview of Power BI desktop

Data sources in Power BI

Using files (excel, pdf, csv, etc.) as a data source

Using SaaS connectors

Extracting data from folders, and databases

Connecting to Analysis Services

Other data sources (web, SharePoint, etc.)

Introduction of the power query editor

Advanced editor

Query dependency editor

Hands-On Practical's

Interview Questions

Clean and Transform your data with Query Editor

Combining Data – Merging and Appending

Cleaning irregularly formatted data

Views in Power BI Desktop

Modelling Data

Manage Data Relationship

Automatic Relationship Updates

Template Apps

Cross Filter Direction

Create calculated tables and measures

Optimizing Data Models

PBIDS Files

Overview of Power BI Desktop

Data Sources in Power BI Desktop

Connecting to a data Sources

Query Editor in Power BI

Query Ribbon

Hands-On Practicals

Interview Questions

Why is DAX important?

DAX Syntax

Data Types in DAX

Essential concepts in DAX

Measures in DAX

DAX Operators

DAX tables and filtering

DAX queries

Ranking and rank over groups

Filter and evaluation context

Context interactions

Calculation Types

DAX Functions

Create simple & compound measures

Schema relations

Star schema design

DAX Parameter Naming

Hands-On Practical's

Interview Questions

Introduction to visuals in Power BI

What Are Custom Visuals?

Page layout and formatting

KPI Visuals

Z-Order

Explore time-based data

AppSource

Charts in Power BI

Gauges and Single Number Cards

Create scatter, waterfall, and funnel charts

Modifying colors in charts and visuals

Shapes, text boxes, and images

Matrixes and tables

Slicers

Map Visualizations

Hands On Practical’s

Interview Questions

Introduction to Power BI Service

Introduction of workspaces

Dashboard vs. Reports

Quick Insights in Power BI

Creating Dashboards

Configuring a Dashboard

Power BI Q&A

Ask questions of your data with natural language

Power BI embedded

Create custom Q&A suggestions

Edit tile details and add widgets

Build apps

Integrate One Drive for Business with Power BI

Question Bank

Case Study

Hands-On Practical's

Interview Questions

Introduction to embedded Power BI

Create embedded code

Manage embedded code

Integration of Power BI in SharePoint

Introduction of Power BI API

Power BI Embedded playground

Introduction to Power BI Mobile

Creating mobile based reports & dashboards

Optimizing report for Power BI mobile app

Features of Power BI mobile app

Introduction of integrating Power BI & Excel

Power BI Analyze in Excel

Introduction to using Excel data in Power BI

Exploring live connections to data with Power BI

Connecting directly to My SQL

Introduction to Power BI Development API

Import Power View and Power Pivot to Power BI

Data caching and refresh

Introducing Power BI Mobile

Question Bank

Hands-On Practical's

Interview Questions

Report Server Basics

Web Portal

Paginated Reports

Row-level Security

Data Gateways

Scheduled Refresh

Configure scheduled refresh

Create a publish-to-web embed code

Customize the sample Power BI file

Hands-On Practical's

Interview Questions

Creating visuals using Python

Hands-On Practical's

Interview Questions

Using Parameters

Create a data flow

Introduction to Anomaly Detection

Introduction to Smart Narrative

Introduction to Sensitivity labels in Power BI

Deployment Pipeline

Hands-On Practical's

Interview Questions

5+ Real-time projects with real world scenario

Data Visualization

Business Intelligence tools

Introduction to Tableau

Tableau Architecture

Tableau Server Architecture

VizQL

Introduction to Tableau Prep

Tableau Prep Builder User Interface

Data Preparation techniques using Tableau Prep Builder tool

Hands-On Practical's

Interview Questions

Features of Tableau Desktop

Connect to data from File and Database

Types of Connections

Joins and Unions

Data Blending

Tableau Desktop User Interface

Basic project: Create a workbook and publish it on Tableau Online

Hands-On Practical's

Interview Questions

Visual Analytics

Basic Charts: Bar Chart, Line Chart, and Pie Chart

Hierarchies

Data Granularity

Highlighting

Sorting

Filtering

Grouping

Sets

Hands-On Practical's

Interview Questions

Types of Calculations

Built-in Functions (Number, String, Date, Logical, & Aggregate)

Operators and Syntax Conventions

Table Calculations

Level Of Detail (LOD) Calculations

Using R within Tableau for Calculations

Hands-On Practical's

Interview Questions

Parameters

Tool tips

Trend lines

Reference lines

Forecasting

Clustering

Hands-On Practical's

Interview Questions

Introduction to Geographic Visualizations

Manually assigning Geographical Locations

Types of Maps

Spatial Files

Custom Geocoding

Polygon Maps

Web Map Services

Background Images

Hands-On Practical's

Interview Questions

Box and Whisker’s Plot

Bullet Chart

Bar in Bar Chart

Gantt Chart

Waterfall Chart

Pareto Chart

Control Chart

Funnel Chart

Bump Chart

Step and Jump Lines

Word Cloud

Donut Chart

Introduction to Dashboards

The Dashboard Interface

Dashboard Objects

Building a Dashboard

Dashboard Layouts and Formatting

Interactive Dashboards with actions

Designing Dashboards for devices

Story Points

Demonstrate how to add objects to a Dashboard

Build a simple Dashboard (using Layouts and Formatting features)

Create Interactive Dashboards using actions

Learn to create a Dashboard for devices using Device Designer

Build Stories with Dashboards In-class

In-class Project 2- Domain: Retail Industry

Tableau Tips and Tricks

Choosing the right type of Chart

Format Style

Data Visualization best practices

Prepare for Tableau Interview

Hands-on experience on various tips and tricks with Tableau

Publishing Workbooks to Tableau Online

Interacting with Content

Data Management through Tableau Catalog

AI-Powered features in Tableau Online (Ask Data and Explain Data)

Understand Scheduling

Managing Permissions on Tableau Online

Data Security with Filters in Tableau Online

Hands-On Practical's

Interview Questions

5+ Real-time projects with one Capstone Project

Interview preparation - recently asked questions in an interview

Interview Tips

GitHub profile building

Resume building

LinkedIn profile building