Best Data Science Course in Noida | Placement Assistance

Introduction to Power BI

• Overview of BI concepts

• Why we need BI

• Introduction to SSBI

• SSBI Tools

• Why Power BI

• What is Power BI

• Building Blocks of Power BI

• Getting started with Power BI Desktop

• Get Power BI Tools

• Introduction to Tools and Terminology

• Dashboard in Minutes

• Interacting with your Dashboards

• Sharing Dashboards and Reports

Power BI Desktop

• Power BI Desktop

• Extracting data from various sources

• Workspaces in Power BI

Power BI Data Transformation

• Data Transformation

• Query Editor

• Connecting Power BI Desktop to our Data Sources

• Editing Rows

• Understanding Append Queries

• Editing Columns

• Replacing Values

• Formatting Data

• Pivoting and Unpivoting Columns

• Splitting Columns

• Creating a New Group for our Queries

• Introducing the Star Schema

• Duplicating and Referencing Queries

• Creating the Dimension Tables

• Entering Data Manually

• Merging Queries

• Finishing the Dimension Table

• Introducing the another DimensionTable

• Creating an Index Column

• Duplicating Columns and Extracting Information

• Creating Conditional Columns

• Creating the FACT Table

• Performing Basic Mathematical Operations

• Improving Performance and Loading Data into the Data Model

Modelling with Power BI

• Introduction to Modelling

• Modelling Data

• Manage Data Relationship

• Optimize Data Models

• Cardinality and Cross Filtering

• Default Summarization & Sort by

• Creating Calculated Columns

• Creating Measures & Quick Measures

Data Analysis Expressions (DAX)

• What is DAX

• Data Types in DAX

• Calculation Types

• Syntax, Functions, Context Options

• DAX Functions

• Date and Time

• Time Intelligence

• Information

• Logical

• Mathematical

• Statistical

• Text and Aggregate

• Measures in DAX

• Measures and Calculated Columns

• ROW Context and Filter Context in DAX

• Operators in DAX - Real-time Usage

• Quick Measures in DAX - Auto validations

• In-Memory Processing DAX Performance

Power BI Desktop Visualisations

• How to use Visual in Power BI

• What Are Custom Visuals

• Creating Visualisations and Colour Formatting

• Setting Sort Order

• Scatter & Bubble Charts & Play Axis

• Tooltips and Slicers, Timeline Slicers & Sync Slicers

• Cross Filtering and Highlighting

• Visual, Page and Report Level Filters

• Tables, Matrices & Conditional Formatting

• KPI's, Cards & Gauges

• Map Visualizations

• Custom Visuals

• Managing and Arranging

• Drill through and Custom Report Themes

• Grouping and Binning and Selection Pane, Bookmarks & Buttons

• Data Binding and Power BI Report Server

Introduction to Power BI Dashboard and Data Insights

• Why Dashboard and Dashboard vs Reports

• Creating Dashboards

• Conguring a Dashboard Dashboard Tiles, Pinning Tiles

• Power BI Q&A

• Quick Insights in Power BI

Direct Connectivity

• Custom Data Gateways

• Exploring live connections to data with Power BI

• Connecting directly to SQL Server

• Connectivity with CSV & Text Files

• Excel with Power BI Connect Excel to Power BI, Power BI Publisher for Excel

• Content packs

• Update content packs

Publishing and Sharing

• Introduction and Sharing Options Overview

• Publish from Power BI Desktop and Publish to Web

• Share Dashboard with Power BI Service

• Workspaces (Power BI Pro) and Content Packs (Power BI Pro)

• Print or Save as PDF and Row Level Security (Power BI Pro)

• Export Data from a Visualization

• Export to PowerPoint and Sharing Options Summary

Refreshing Datasets

• Understanding Data Refresh

• Personal Gateway (Power BI Pro and 64-bit Windows)

• Replacing a Dataset and Troubleshooting Refreshing

AI Integration in Power BI:

• Smart Narrative visual (AI-generated insights)

• Decomposition Tree (Root Cause Analysis)

• Q&A Visual (Natural Language Querying)

• Azure Cognitive Services integration

• Power BI Copilot (Preview): Report creation via prompts

• Integration with Power Automate for alerts and workflows

Introduction to Data Preparation using Tableau Prep

• Data Visualization

• Business Intelligence tools

• Introduction to Tableau

• Tableau Architecture

• Tableau Server Architecture

• VizQL Fundamentals

• Introduction to Tableau Prep

• Tableau Prep Builder User Interface

• Data Preparation techniques using Tableau Prep Builder tool

Data Connection with Tableau Desktop

• Features of Tableau Desktop

• Connect to data from File and Database

• Types of Connections

• Joins and Unions

• Data Blending

• Tableau Desktop User Interface

Basic Visual Analytics

• Visual Analytics

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

• Hierarchies

• Data Granularity

• Highlighting

• Sorting

• Filtering

• Grouping

• Sets

Calculations in Tableau

• Types of Calculations

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

• Operators and Syntax Conventions

• Table Calculations

• Level of Detail (LOD) Calculations

• Using R within Tableau for Calculations

Advanced Visual Analytics

• Parameters

• Tool tips

• Trend lines

• Reference lines

• Forecasting

• Clustering

Level of Detail (LOD) Expressions in Tableau

• Count Customer by Order

• Profit per Business Day

• Comparative Sales

• Profit Vs Target

• Finding the second order date

• Cohort Analysis

Geographic Visualizations in Tableau

• Introduction to Geographic Visualizations

• Manually assigning Geographical Locations

• Types of Maps

• Spatial Files

• Custom Geocoding

• Polygon Maps

• Web Map Services

• Background Images

Advanced charts in Tableau

• Box and Whiskers 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

Dashboards and Stories

• 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

Get Industry Ready

• Tableau Tips and Tricks

• Choosing the right type of Chart

• Format Style

• Data Visualization best practices

Exploring Tableau Online

• Publishing Workbooks to Tableau Online

• Interacting with Content on Tableau Online

• 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

AI Integration in Tableau:

• Ask Data: Natural Language Data Exploration

• Explain Data: Automatic statistical insights

• Tableau GPT (Einstein Copilot - Salesforce)

• AI forecasting in visualizations

• Integration with Python (TabPy) and R

Introduction to Machine Learning

• What is Machine Learning

• Machine Learning Use-Cases

• Machine Learning Process Flow

• Machine Learning Categories

Time Series Analysis

• What is Time Series Analysis

• Importance of TSA

• Components of TSA

• White Noise

• AR model

• MA model

• ARMA model

• ARIMA model

• Stationarity

• ACF & PACF

Statistical Foundations (Self-Paced)

• What is Exploratory Data Analysis

• EDA Techniques

• EDA Classification

• Univariate Non-graphical EDA

• Univariate Graphical EDA

• Multivariate Non-graphical EDA

• Multivariate Graphical EDA

• Heat Maps

Introduction to Text Mining and NLP

• Overview of Text Mining

• Need of Text Mining

• Natural Language Processing (NLP) in Text Mining

Introduction to Deep Learning

• What are the Limitations of Machine Learning

• What is Deep Learning

• Advantage of Deep Learning over Machine learning

• Reasons to go for Deep Learning

• Real-Life use cases of Deep Learning

Neural Networks & Deep Learning

• Understand The Inner Workings Of Neural Networks And Train Them With Keras.

• Introduction to Neural Networks & Deep Learning

• Activation Functions (ReLU, Sigmoid, Tanh)

• Feedforward Neural Network

• Fully Connected Layer Forward,Backward Pass

• Regularization Dropout, Batch Normalization

• Data Preprocessing & Data Augmentation

• Babysitting Learning: Overfit detection, TensorBoard Monitoring

Computer Vision

• Master CNNs, Object Detection, Segmentation, And Deployment.

• Basics of Images, Image Preprocessing

• Convolution: 2D Conv, Forward & Backward

• Pooling, Padding, Stride, Transposed Conv

• CNN Architectures: LeNet, AlexNet, VGG, ResNet

• GPU vs CPU for DL

• Transfer Learning: Inception, MobileNet, fine-tuning

• Semantic Segmentation using UNet

• Object Detection YOLO, SSD, Region Proposal

• Bounding Box Regressor

• Siamese Networks for Similarity Search

• Image Classification with CNN

• Object Detection with YOLOv8

• Visual Search with Embeddings

Natural Language Processing (NLP)

• Train Text Models From Scratch And With BERT.

• Introduction to NLP and Use Cases

• Preprocessing: Tokenization, Lemmatization, Stopwords, Normalization

• Feature Extraction: BOW, TF-IDF, N-Grams

• Word Embeddings: Word2Vec, GloVe, Dense Vectors

• POS Tagging, Named Entity Recognition

• RNN, LSTM Forward Pass and BPTT

• Advanced LSTM Applications + Architectures

• Attention Mechanism + Encoder-Decoder

• Transformers, BERT, Hugging Face Pipelines

• NLP Evaluation Metrics: BLEU, ROUGE

• Sentiment Classifier (LSTM or BERT)

• Deploy NLP Model with Streamlit

Capstone Project