Advanced Data Science (Power BI / Tableau)

About this program

Master data analytics and visual storytelling with this hands-on program in Power BI and Tableau. Learn to analyse datasets, build dynamic dashboards, and deliver actionable business insights using industry-leading BI tools.

Learning Objectives

Develop a strong understanding of data analytics, data modelling, and business intelligence fundamentals.

Gain hands-on proficiency in Power BI and Tableau for creating interactive dashboards and analytical reports.

Apply data cleaning, transformation, and ETL workflows to prepare datasets for meaningful insights.

Use advanced visualisation techniques and DAX calculations to perform in-depth analytics.

Build end-to-end BI solutions using real-world case studies and industry datasets.

Implement data storytelling principles to communicate findings and support strategic decision-making.

Automate reporting workflows and integrate BI tools with organisational data systems.

Course Content:

Module 1: Foundations of Data Science for BI

Data Science Workflow: Data Collection → Cleaning → Analysis → Visualization → Insights.

Data Types: Structured, Semi-structured, Unstructured.

Relational Databases & SQL Essentials: Joins, Subqueries, Aggregations.

ETL Concepts: Extract, Transform, Load.

Data Quality & Governance: Missing values, Outliers, Metadata, Security.

Python/R Refresher: Pandas, NumPy, Basic Statistics for dashboards.

Module 2: Business Intelligence Concepts

Difference between BI, Traditional Reporting & Data Science.

KPIs & Metrics aligned with business goals.

Data Modeling: Star Schema, Snowflake Schema, Normalization.

Data Warehousing Basics: Fact & Dimension Tables, OLAP Cubes.

Cloud Data Sources: Azure, AWS Redshift, Google BigQuery.

Introduction to APIs for data ingestion.

Module 3: Power BI – Advanced Analytics

Power Query Editor & M Language for advanced data prep.

Data Modeling: Relationships, Hierarchies, Calculated Tables.

Advanced DAX: Calculated Columns & Measures.

Time-Intelligence Functions, Dynamic Filtering, Ranking.

Row-Level Security (RLS) & Data Roles.

Custom Visuals & Marketplace Extensions.

Data Model Performance Optimization.

Power BI Service: Publishing, Collaboration, Workspaces.

Module 4: Tableau – Advanced Analytics

Multi-source Data Connections, Joins & Blends.

Data Preparation using Tableau Prep.

Advanced Calculated Fields & Table Calculations.

Parameters & Dynamic Dashboards.

LOD Expressions (INCLUDE, EXCLUDE, FIXED).

Advanced Visualizations: Sankey, Gantt, Waterfall, Funnel, Maps.

Dashboard Storytelling & Design Principles.

Performance Optimization Techniques.

Tableau Server/Online: Publishing, Permissions, Scheduling.

Module 5: Statistical & Predictive Analytics

Exploratory Data Analysis (EDA) for BI.

Descriptive & Inferential Statistics: Mean, Variance, Hypothesis Testing.

Regression & Forecasting Models (Power BI/Tableau).

Clustering & Segmentation (K-Means, Hierarchical).

Anomaly Detection & Outlier Analysis.

Time-Series Analysis: ARIMA, ETS.

Integration with Python/R within BI tools.

Module 6: Data Engineering & Automation

Working with APIs, Web Data, JSON/XML.

Incremental Data Refresh & Scheduled Pipelines.

Data Lakes & Big Data Connectors: Spark, Hadoop, Snowflake.

Automation using Power Automate & Tableau Prep Flows.

Version Control with Git/GitHub for BI Projects.

CI/CD Pipelines for BI Development.

Module 7: Governance, Security & Compliance

Data Privacy Regulations: GDPR, HIPAA, DPDP Act.

Row-Level & Object-Level Security controls.

Audit Trails & Compliance Dashboards.

Performance Monitoring & Optimization.

Documentation & Metadata Management in BI.

Module 8: Capstone Projects & Industry Use-Cases

Retail Sales Forecasting Dashboard.

Financial KPI Executive Dashboard.

Healthcare Analytics Dashboard.

Marketing Campaign Effectiveness Dashboard.

Supply Chain Analytics & Predictive Maintenance.

Geo-Spatial Analytics (Route Optimization).

Final Capstone: End-to-end BI Project.

What you'll learn

Develop advanced data modelling and visualization skills using Power BI & Tableau.
Interpret datasets to generate actionable business insights.
Build interactive dashboards for performance tracking and decision support.
Apply data storytelling techniques for analytical presentations.

Tools you'll master

Power BI Tableau Excel Analytics DAX and Power Query SQL for Data Analytics

Meet your instructors

Author and Director

${first_instructor.get($

Mr. Joydeep Mukherjee

Joydeep Majumder is a senior finance and analytics professional with over 35 years of experience across costing systems, purchase accounting, budgeting, inventory control, debtor control, treasury, finalisation of accounts, contribution analysis, GST, corporate taxation, international taxation and transfer pricing, excise, sales tax, VAT, EXIM policies, M&A, state/central subsidies and payroll. He is an FCMA, B.Com (Hons), Graduate in Operational Research (Grad. OR) and holds a Post Graduate Diploma in Systems Management. Since 1987, he has extensively used computers and multiple technologies including FORTRAN, COBOL, Visual Basic, DBMS and all MS Office programs with Advanced Excel and VBA, as well as Power BI, Tableau, Tally, Zoho Books and SAP. Joydeep has worked for several leading MNCs in India in senior positions from Senior Manager to General Manager. As an in-house trainer and content developer, he has designed and delivered programs on Advanced Excel, Zoho Books, Tally, Power BI, Advanced and Business Accounts, Financial Modelling, GST, Income Tax, TDS, Auditing, Banking and SAP.

Who is this for?

Tech Enthusiasts, College Students, Fresh Graduates, Working Professionals, Data Analysts, Early-Career Employees