Business Analytics and Data Visualization (Power BI and Tableau)
Description
Program summary
Format: Delivered online. If a specific program includes live sessions, an on-campus visit, or any in-person component, this will be clearly stated on the program page.
What you will gain:
• Design consistent KPI frameworks and metric dictionaries
• Build dashboard structures aligned with business questions
• Communicate insights clearly through data storytelling
• Reduce misinterpretation risks with visualization best practices
Who should attend:
Analysts, reporting teams, business stakeholders, product/growth teams, and managers who rely on dashboards.
Course outline
1. Analytics workflow: question → metric → data → insight → action
2. KPI design: metric dictionary, targets, thresholds
3. Dashboard principles: layout, hierarchy, filtering, usability
4. Power BI & Tableau: modeling concepts and visual selection
5. Data storytelling: executive-ready narratives and context
6. Applied practice: dashboard wireframes and critique
Modules
10
What is included
Lessons
150
Review the module structure and lesson flow before enrollment.
Content sections
4
Review the sections below and open only the one you need. The summary panel on the side keeps the long explanation separate and readable.
Course Curriculum
Module roadmap
Review the module structure and lesson flow before enrollment.
Module 1
Foundations of Business Analytics
Module 2
Data Preparation and Transformation
Module 3
Power BI: Core Skills and Interface
Next step
Add to Cart
You can add the product to your cart and proceed to the payment step.
Sample certificate
Preview the institution-issued certificate style learners can expect after successfully completing the program.
What is included
Course Curriculum
Review the module structure and lesson flow before enrollment.
What Is Business Analytics: Types, Applications and Value
The Analytics Landscape: Descriptive, Diagnostic, Predictive and Prescriptive
Data Thinking: Asking the Right Business Questions
Understanding Data Types: Structured, Unstructured and Semi-Structured
Data Sources in Business: Databases, APIs, Files and Streams
The Analytics Workflow: From Raw Data to Business Decision
Key Metrics and KPIs: Designing Meaningful Measures
Data Quality: Completeness, Accuracy, Consistency and Timeliness
Introduction to Statistics for Business Analysts
Probability and Distributions: What Every Analyst Must Know
Correlation, Causation and the Dangers of Spurious Relationships
Sampling and Estimation: Drawing Conclusions from Partial Data
Hypothesis Testing: Making Evidence-Based Decisions
Communicating Analytical Findings to Non-Technical Stakeholders
Ethics and Bias in Business Analytics
Data Collection and Integration: Connecting to Multiple Sources
Data Cleaning: Handling Missing Values, Duplicates and Errors
Data Transformation: Reshaping, Pivoting and Aggregating Data
Working with Dates and Times in Analytics
Text Data Preparation: Parsing, Splitting and Standardising
Data Normalisation and Standardisation for Analysis
Joining and Merging Data from Multiple Tables
Introduction to SQL for Business Analysts
Advanced SQL: Window Functions, CTEs and Subqueries
Excel for Data Preparation: Power Query and Data Transformation
Data Profiling: Understanding Your Dataset Before You Analyse It
Building Reusable Data Preparation Workflows
Data Governance and Documentation for Analytics Teams
Introduction to Python for Data Preparation
Introduction to R for Business Analytics
Data Wrangling with Python Pandas: Practical Techniques for Analysts
Power BI Ecosystem: Desktop, Service, Mobile and Embedded
Power BI Interface: Navigating Reports, Data and Model Views
Connecting to Data Sources in Power BI Desktop
Power Query in Power BI: Transforming Data Before It Loads
Building Your First Power BI Report: Fields, Visuals and Pages
The Power BI Data Model: Tables, Relationships and Cardinality
Introduction to DAX: Calculated Columns and Measures
DAX Fundamentals: CALCULATE, FILTER, ALL and Context
Time Intelligence in DAX: YTD, MTD, Rolling Averages and Growth
Advanced DAX: Variables, SWITCH, RANKX and Iterators
Row-Level Security in Power BI
Power BI Service: Publishing, Workspaces and Sharing
Scheduling Data Refresh and Gateway Configuration
Power BI Apps and Deployment Pipelines
Performance Optimisation in Power BI: Data Models and Visuals
Power BI Dataflows and Reusable Data Preparation at Scale
Custom Visuals in Power BI: AppSource and Building Your Own
Drill-Through, Drill-Down and Cross-Report Navigation
Bookmarks, Buttons and Conditional Formatting
Dynamic Titles, Tooltips and Report Personalisation
What-If Parameters and Scenario Analysis in Power BI
AI Visuals: Key Influencers, Decomposition Tree and Q&A
Power BI and Excel Integration: Analyse in Excel and Live Connections
Paginated Reports in Power BI: Pixel-Perfect Reporting
Power BI Embedded: Integrating Analytics into Applications
Power BI Administration: Tenant Settings, Capacity and Governance
Microsoft Fabric and the Future of Power BI
Real-Time Dashboards and Streaming Datasets in Power BI
Power BI for Finance: P&L, Balance Sheet and Cash Flow Reports
Power BI for Sales and Marketing Analytics
Power BI for Operations and Supply Chain Reporting
Tableau Ecosystem: Desktop, Server, Online and Public
Tableau Interface: Shelves, Cards, Marks and the Data Pane
Connecting to Data Sources in Tableau
Dimensions, Measures, Discrete and Continuous Fields
Building Your First Tableau Visualisation: Rows, Columns and Marks
Tableau Data Relationships, Joins and Blends
Calculated Fields in Tableau: Formulas, Logic and String Functions
Table Calculations: Running Total, Percent of Total and Rank
Level of Detail Expressions: FIXED, INCLUDE and EXCLUDE
Filters in Tableau: Extract, Data Source, Context and View Filters
Parameters and Dynamic Controls in Tableau
Sets and Groups: Segmenting Your Data for Analysis
Tableau Prep: Data Cleaning and Shaping for Tableau
Publishing to Tableau Server and Tableau Online
Tableau Data Extracts and Incremental Refresh Strategies
Dashboard Design in Tableau: Layout, Actions and Interactivity
Advanced Chart Types in Tableau: Bump Charts, Slope Charts and Sparklines
Mapping in Tableau: Geographic Visualisations and Spatial Analysis
Statistical Analysis in Tableau: Reference Lines, Bands and Box Plots
Forecasting and Trend Lines in Tableau
Cluster Analysis and Tableau's Built-In Analytics
Tableau Extensions and JavaScript API
Tableau Embedding and Integration with Web Applications
Performance Optimisation in Tableau: Extracts, Queries and Dashboards
Tableau Server Administration: Sites, Permissions and Content Management
Tableau for HR and People Analytics
Tableau for Operations and Supply Chain Analytics
Tableau vs Power BI: When to Use Which Tool
Storytelling with Data in Tableau: Storypoints and Narrative Flow
Tableau Pulse and AI-Powered Insights in Tableau Cloud
The Principles of Effective Data Visualisation
Choosing the Right Chart Type for Your Data and Message
Visual Perception: How the Brain Reads Charts and Graphs
Colour Theory for Data Visualisation: Scales, Palettes and Accessibility
Typography and Layout in Dashboard Design
Avoiding Common Visualisation Mistakes and Misleading Charts
Designing for Accessibility: Colour-Blindness, Screen Readers and Contrast
Mobile-First Dashboard Design: Responsive Layouts and Touch Interaction
Executive Dashboards vs Operational Dashboards: Design Principles
Self-Service Analytics: Designing Reports for Non-Technical Users
Data Storytelling: Structure, Narrative and Insight Communication
Annotating Charts and Guiding the Reader's Eye
Advanced Dashboard UX: Navigation, Filtering and User Experience
Benchmark and Comparison Visualisations: Before and After, Target vs Actual
Small Multiples and Faceted Charts for Multi-Dimensional Comparison
Exploratory Data Analysis: Finding Patterns Before You Build Reports
Cohort Analysis: Understanding Customer Behaviour Over Time
Funnel Analysis: Conversion, Drop-Off and Optimisation
RFM Analysis: Segmenting Customers by Recency, Frequency and Monetary Value
Pareto Analysis and the 80/20 Rule in Business Analytics
A/B Testing and Experimentation: Design, Analysis and Interpretation
Regression Analysis for Business: Predicting Outcomes from Data
Forecasting Methods: Moving Averages, Exponential Smoothing and ARIMA
Clustering and Segmentation: Grouping Customers and Products
Decision Trees and Classification for Business Problems
Natural Language Processing Basics for Analysts: Sentiment and Text Analysis
Anomaly Detection: Identifying Outliers and Unusual Patterns
Network Analysis and Relationship Mapping for Business
Monte Carlo Simulation for Business Risk Analysis
Data Warehouses and Data Marts: Architecture and Design Principles
Data Lakes and Lakehouses: Modern Data Storage for Analytics
ETL and ELT Pipelines: Moving and Transforming Data at Scale
Star Schema and Snowflake Schema: Dimensional Modelling for BI
Cloud Analytics Platforms: Azure Synapse, Google BigQuery and AWS Redshift
Data Mesh and Federated Analytics: Decentralised Data Ownership
Building a Data Catalogue and Metadata Management
Master Data Management: Consistency Across Systems and Reports
Analytics Maturity Model: Assessing and Improving Your Organisation
Data Strategy: Building an Analytics-Driven Organisation
BI Tool Selection and the Business Case for Analytics Investment
Managing the Analytics Team: Roles, Skills and Structures
Agile Analytics: Iterative Development for BI Projects
Financial Reporting Dashboard: P&L, Variance Analysis and Forecasting
Sales Performance Dashboard: Pipeline, Revenue and Team Analytics
Marketing Analytics Dashboard: Campaign, Channel and Funnel Analysis
HR and People Analytics Dashboard: Headcount, Turnover and Diversity
Supply Chain and Operations Dashboard: Inventory, Lead Time and Quality
Customer Analytics Dashboard: Churn, Lifetime Value and Segmentation
Healthcare Analytics Dashboard: Patient Outcomes and Operational KPIs
Retail Analytics Dashboard: Store Performance, Basket Analysis and Forecasting
Real Estate Analytics Dashboard: Portfolio, Valuation and Market Trends
End-to-End Analytics Project: From Business Question to Deployed Dashboard
Presenting Your Analytics Work: Building a Portfolio and Case Studies
Certification Pathways: PL-300 Power BI, Tableau Desktop Specialist and Beyond
Freelance and Consulting in Business Analytics: Getting Started
The Future of Business Analytics: AI Copilots, Augmented Analytics and Trends
AI and Generative Analytics: Copilot, NotebookLM and the Analyst of Tomorrow
Course Conclusion: Your Analytics Career Starts Here
Program details
Content sections
Review the sections below and open only the one you need. The summary panel on the side keeps the long explanation separate and readable.