📊 IBM Business Intelligence (BI) Analyst Portfolio

🎯 Overview

Welcome to my comprehensive portfolio documenting the completion of the IBM Business Intelligence (BI) Analyst Professional Certificate! This repository showcases hands-on projects, labs, and assignments covering the complete BI workflow—from data warehousing and SQL querying to advanced data visualization and dashboard creation.

🏆 Professional Certificate Details

• Certificate: IBM Business Intelligence (BI) Analyst Professional Certificate
• Provider: IBM via Coursera
• Duration: 9 comprehensive courses
• Skills Acquired: Business Intelligence, Data Visualization, Tableau, Excel, SQL, Statistical Analysis, Data Warehousing, Dashboard Design, ETL, Data Modeling

📚 Course Structure & Portfolio Contents

1. 📊 Introduction to Business Intelligence (BI) Essentials

• Topics Covered: BI concepts, analytics types (descriptive, diagnostic, predictive, prescriptive), BI ecosystem, data governance, stakeholder communication
• Key Files:
  • Business Intelligence (BI) Essentials/Cheatsheet/ - Comprehensive course glossaries
  • Interactive Glossary/ - Searchable BI terminology database
  • Interactive Role Comparison Dashboard/ - Visual comparison of BI Analyst, Data Analyst, Data Engineer, and Data Scientist roles
  • Final Project - Scenario/ - Real-world BI project scenario application

2. 🐘 Introduction to Relational Databases (RDBMS)

• Topics Covered: Database design, normalization, ER diagrams, MySQL, PostgreSQL, keys and constraints, views, materialized views
• Key Projects:
  • Final Project - Database Design and Implementation: Complete coffee shop database design with ERD, implementing tables, views, and materialized views
  • Advanced Relational Model Concepts: Python scripts demonstrating database connectivity and operations
  • Views in PostgreSQL: Creating and managing views for data abstraction and security
  • Interactive RDBMS Glossary: Comprehensive database terminology reference

3. 📈 SQL: A Practical Introduction for Querying Databases

• Topics Covered: SELECT statements, JOINs, subqueries, stored procedures, transactions, aggregate functions, string patterns, grouping, sorting
• Key Projects:
  • Getting Started with SQL: Comprehensive exercises with San Francisco film locations dataset
  • Intermediate SQL: Built-in functions, subqueries, multiple table operations
  • Final Project - Advanced SQL Techniques: Chicago crime, school, and socioeconomic data analysis with views, stored procedures, and transactions
  • Interactive SQL Glossary: Complete SQL reference with examples

4. 📉 Statistical Analysis Fundamentals using Excel

• Topics Covered: Descriptive statistics, measures of dispersion, probability distributions, normal distribution, simple/multiple linear regression, pivot charts
• Key Projects:
  • Descriptive Statistics: Mean, median, mode, variance, standard deviation calculations
  • Measure of Dispersion: Quartiles, percentiles, interquartile range analysis
  • Probability Distribution: Normal distribution calculations and market return simulations
  • Simple & Multiple Linear Regression: Sales prediction models for Zen Pharma
  • Final Project: Comprehensive supermarket sales transaction analysis with regression modeling
  • Interactive Statistics Dashboard: Complete statistical concepts reference

5. 📱 Excel Basics for Data Analysis

• Topics Covered: Excel functions, data cleaning, filtering, sorting, pivot tables, VLOOKUP, XLOOKUP, COUNTIFS, SUMIFS
• Key Projects:
  • Advanced Excel Formulas Dashboard: Interactive reference for Excel functions
  • Data Cleaning Labs: Flash fill, text functions, removing duplicates
  • Pivot Table Analysis: Indian startup funding and customer demographics analysis
  • Final Project: Montgomery Fleet Equipment Inventory - complete data cleaning and analysis workflow

6. 📊 Data Visualization and Dashboards with Excel and Cognos

• Topics Covered: Basic charts, advanced charts, pivot charts, dashboards, IBM Cognos Analytics, Google Looker Studio
• Key Projects:
  • Complete Excel Mastery Lab: Comprehensive Excel visualization workshop
  • Excel Keyboard Shortcuts Interactive Lab: Reference for Excel productivity
  • Cognos Analytics Dashboards: Interactive automotive industry dashboards
  • Google Looker Studio: Creating and configuring visualizations

7. 📈 Getting Started with Tableau

• Topics Covered: Tableau Public, data import, cleaning, visualizations, dashboards, stories, parameters, calculated fields
• Key Projects:
  • Cleaning Data and Creating Visualizations: Data preparation and chart creation
  • Crafting Interactive Visualizations: Interactive dashboard design
  • Creating and Customizing Stories: Narrative-driven data presentations
  • Designing Interactive Dashboards: Best practices in dashboard design
  • Final Project - World Happiness Report: Comprehensive analysis of global happiness drivers (2015-2023)

8. 📊 Advanced Data Visualization with Tableau

• Topics Covered: Hierarchies, dashboard actions, extensions, data modeling, calculated fields, advanced aggregations, dashboard optimization
• Key Projects:
  • Building Hierarchies: Hierarchical navigation in UFO sightings and sales data
  • Configuring Dashboard Actions: Interactive dashboards with cross-filtering
  • Adding Dashboard Extensions: Enhancing dashboards with external tools
  • Implementing Data Modeling: Multi-table data modeling with country indicators
  • Using Calculated Fields: Advanced analysis with GDP tiers and YoY growth
  • Final Project - New York Airbnb Pricing: Comprehensive pricing analysis with interactive dashboards

9. 🎓 The Business Intelligence (BI) Analyst Capstone Project

• Topics Covered: End-to-end BI workflow, data cleaning, SQL analysis, statistical analysis, Tableau visualization, dashboard creation, portfolio development
• Key Projects:
  • Data Cleaning & Preparation: Comprehensive data quality assessment and cleaning
  • Data Analysis Using PostgreSQL: Advanced SQL queries with ROLLUP and data cubes
  • Statistical Analysis Using Excel: Regression analysis and statistical interpretation
  • Data Visualization Using Excel: Pivot tables and advanced charting
  • Creating Basic Tableau Visualizations: Foundational visualization development
  • Creating Interactive Dashboards in Tableau: Comprehensive retail sales dashboard
  • Develop Your Personal Portfolio: Complete BI project documentation

📚 Bonus: Generative AI - Elevate your Business Intelligence Career

• Topics Covered: AI-powered data generation, cleansing, SQL generation, text summarization, dashboard creation
• Key Projects:
  • Data Generation and Cleansing: Synthetic data creation with AI assistance
  • Generating SQL Queries with AI: AI-assisted query development with heart disease dataset
  • Data Analysis Using Generative AI Tools: Customer transaction analysis with AI
  • Dashboards with AI: AI-enhanced dashboard design
  • Text Generation and Summarization: Business report generation with AI
  • Final Project - AI-Powered Visualizations: Superstore sales analysis with AI assistance

🛠️ Technical Skills Demonstrated

Data Visualization

Databases & SQL

Statistical Analysis

Tools & Platforms

Programming & Scripting

📁 Repository Structure

IBM-Business-Intelligence-Portfolio/
│
├── 📁 Business Intelligence (BI) Essentials/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Interactive Glossary/
│   ├── 📁 Interactive Role Comparison Dashboard/
│   └── 📁 Final Project - Scenario/
│
├── 📁 Introduction to Relational Databases (RDBMS)/
│   ├── 📁 CheatSheet/
│   ├── 📁 Final Project/
│   └── 📁 Labs/
│       ├── Advanced RDBMS Concepts Interactive Dashboard/
│       ├── Advanced Relational Model Concepts/
│       ├── Database Design Using ERDs/
│       ├── Getting Started with MySQL Command Line/
│       ├── Getting Started with PostgreSQL Command Line/
│       ├── Keys and Constraints in MySQL/
│       ├── RDBMS Glossary Interactive Dashboard/
│       ├── Relational Model Concepts/
│       └── Views in PostgreSQL/
│
├── 📁 SQL - A Practical Introduction for Querying Databases/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Getting Started with SQL/
│   ├── 📁 Intermediate SQL/
│   │   ├── Built-in functions/
│   │   ├── String Patterns, Sorting and Grouping/
│   │   ├── Sub-queries and Nested SELECTS/
│   │   └── Working with Multiple Tables/
│   ├── 📁 Introduction to Relational Databases and Tables/
│   │   ├── CREATE, ALTER, TRUNCATE, DROP/
│   │   ├── Create and Load Tables using SQL Scripts/
│   │   └── MySQL Interactive Learning Lab/
│   └── 📁 Working with real-world data sets, Final Project & Exam/
│       └── 📁 Final Project/
│           ├── Advanced Analytical Queries/
│           ├── Comprehensive Analysis Examples/
│           ├── Data Quality Considerations/
│           ├── Exercises/
│           ├── Key Insights and Patterns/
│           └── Performance Optimization/
│
├── 📁 Statistical Analysis Fundamentals using Excel/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Labs/
│   │   ├── Complete Statistics Mastery Lab/
│   │   ├── Data Visualization Using Pivot Chart/
│   │   ├── Data Visualization Using Statistical Charts/
│   │   ├── Descriptive Statistics/
│   │   ├── Measure of Dispersion/
│   │   ├── Multiple Linear Regression Analysis/
│   │   ├── Practice Project Guide/
│   │   ├── Probability Distribution/
│   │   ├── Simple Linear Regression Analysis/
│   │   └── Standard Normal Distribution/
│   ├── 📁 Final Project/
│   └── 📁 Interactive Statistics Fundamentals Dashboard/
│
├── 📁 Excel Basics for Data Analysis/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Data/
│   ├── 📁 Final Project/
│   │   ├── Part 1/
│   │   └── Part 2/
│   └── 📁 Labs/
│       └── Advanced Excel Formulas Dashboard/
│
├── 📁 Data Visualization and Dashboards with Excel and Cognos/
│   ├── 📁 Automotive_Industry/
│   ├── 📁 CheatSheet/
│   ├── 📁 Data/
│   └── 📁 Lab/
│       ├── Complete Excel Mastery Lab/
│       └── Excel Keyboard Shortcuts Interactive Lab/
│
├── 📁 Getting Started with Tableau/
│   ├── 📁 Cheatsheet/
│   └── 📁 Labs/
│       ├── Cleaning Data and Creating Visualizations in Tableau/
│       ├── Crafting Interactive Visualizations in Tableau/
│       ├── Creating a Simple Story in Tableau/
│       ├── Customizing Visualizations in Tableau/
│       ├── Customizing a Story in Tableau/
│       ├── Designing Interactive Dashboards in Tableau/
│       ├── Final Project - Working with the World Happiness Report in Tableau Public/
│       └── Importing and Exploring Data in Tableau/
│
├── 📁 Advanced Data Visualization with Tableau/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Labs/
│   │   ├── Adding Dashboard Extensions in Tableau/
│   │   ├── Building Hierarchies in Tableau/
│   │   ├── Configuring Dashboard Actions/
│   │   ├── Creating Visualizations with Calculations and Calculated Fields/
│   │   ├── Implementing Data Modeling in Tableau/
│   │   ├── Optimizing Visualizations and User Interaction/
│   │   ├── Practice Project - Exploring Socioeconomic Trends in US Counties/
│   │   └── Using Calculated Fields for Advanced Analysis/
│   └── 📁 Final Project - Working with the New York Airbnb Pricing Report in Tableau Public/
│
├── 📁 The Business Intelligence (BI) Analyst Capstone Project/
│   ├── 📁 Cheatsheet/
│   └── 📁 Labs/
│       ├── Basic Analysis Using Pivot Tables/
│       ├── Creating Basic Tableau Visualizations/
│       ├── Creating Interactive Dashboards in Tableau/
│       ├── Data Analysis Using PostgreSQL/
│       ├── Data Cleaning and Preparation/
│       ├── Data Querying Using PostgreSQL/
│       ├── Data Visualization Using Excel/
│       ├── Develop Your Personal Portfolio/
│       └── Statistical Analysis Using Excel/
│
├── 📁 Generative AI - Elevate your Business Intelligence Career/
│   ├── 📁 Cheatsheet/
│   ├── 📁 Labs/
│   │   ├── Dashboards with AI/
│   │   ├── Data Analysis Using Generative AI Tools/
│   │   ├── Data Generation and Cleansing/
│   │   ├── Final Project - AI-Powered Visualizations/
│   │   ├── Generating SQL Queries with AI/
│   │   ├── Interactive Glossary for Business Intelligence/
│   │   └── Text Generation and Summarization/
│   └── 📁 Production Application/
│
├── 📁 .vscode/
├── 📁 Image/
├── 📁 Complete Excel Glossary/
├── 📁 Complete Python Glossary/
├── 📁 E-commerce Database/
└── 📁 Interactive Glossaries/
    ├── Complete SQL Glossary.html
    ├── Statistics Fundamentals Glossary.html
    └── RDBMS Glossary Interactive Dashboard.html

📊 Featured Dashboards & Visualizations

📈 Tableau Dashboards

New York Airbnb Pricing Dashboard & World Happiness Report Dashboard

Retail Sales Dashboard & US Socioeconomic Trends Dashboard

Interactive Dashboard & Dashboard with Actions

📊 Excel Dashboards

Indian Startup Funding Dashboard & Cognos Analytics Dashboard

🗄️ Database & SQL Projects

Coffee Shop ERD & Chicago Crime Analysis

🚀 Getting Started

Prerequisites

• Tableau Public (free account)
• Microsoft Excel (or Excel Online)
• PostgreSQL and pgAdmin
• Python 3.7+ (for AI labs)
• Web browser for interactive dashboards

Setup Instructions

1. Clone the repository:

   git clone https://github.com/yourusername/IBM-Business-Intelligence-Portfolio.git

2. Navigate to specific project folders
3. For Tableau projects, download the .twb or .twbx files and open in Tableau Public
4. For Excel projects, open .xlsx files in Microsoft Excel
5. For SQL projects, import the dump files into PostgreSQL
6. For interactive HTML dashboards, open in any web browser

📈 Key Achievements

✅ Completed 9-course professional certificate
✅ Built 50+ hands-on projects across the BI stack
✅ Created 20+ interactive Tableau dashboards
✅ Developed comprehensive SQL skills with real-world datasets
✅ Mastered statistical analysis using Excel
✅ Designed end-to-end BI solutions in capstone project
✅ Integrated AI tools for enhanced BI workflows
✅ Built interactive glossaries for BI, SQL, RDBMS, and Statistics
✅ Created complete database designs with ERDs and views

🎯 Learning Outcomes

• End-to-end BI workflow: From data sourcing to actionable insights
• Data visualization mastery: Tableau, Excel, Cognos, and Looker Studio
• Statistical analysis: Descriptive statistics, probability, regression modeling
• SQL proficiency: Complex queries, joins, subqueries, views, stored procedures
• Database design: Normalization, ERDs, keys, constraints, materialized views
• Dashboard design: Interactive, user-centric dashboards with storytelling
• AI-enhanced BI: Leveraging generative AI for data analysis and visualization
• Business communication: Translating data insights into business recommendations

🫱🏿‍🫲🏿 Contributing

This portfolio is a personal showcase of my learning journey through the IBM Business Intelligence Analyst Professional Certificate. While contributions aren't expected, feedback and suggestions are welcome!

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

📧 Contact

Your Name

• GitHub: @Willie-Conway
• LinkedIn: LinkedIn Profile
• Email: hire.willie.conway@gmail.com
• Tableau Public: Tableau Public

---

⭐ If you find this portfolio helpful, please give it a star! ⭐

---

Last Updated: February 2026
Status: 🟢 Active Development