Back to Catalog

Business Intelligence: Capstone Project

Premium
AdvancedCourse

Gain hands-on experience in data analysis with Excel, PostgreSQL, and Tableau to execute a BI project and enhance decision-making and performance.

Language

  • English

Topic

  • Business Intelligence

Skills You Will Learn

  • Business Intelligence, Tableau, Dashboards, Data Visualization, Data Analysis

Offered By

  • SkillUpEdTech

Estimated Effort

  • 3 weeks

Platform

  • SkillsNetwork

Last Update

  • April 22, 2025
About this Course
Quickly gain the expertise you need to apply Business Intelligence (BI) techniques, derive insights, and uncover patterns in data using various tools like Excel, PostgreSQL, and Tableau. 
 
You will learn: 
 
  • How to apply data analysis techniques to real-world datasets and derive meaningful insights. 
  • Develop and execute a practical BI project using tools of the trade. 
  • Present project outcomes, highlighting their impact on decision-making and business performance. 
  • Showcase proficiency in using BI tools and technologies, such as data visualization tools and data management systems. 
 
Course Overview 
 
Learn essential data analysis techniques to extract meaningful insights and discover patterns. 
 
You will work with various tools such as Excel for data cleaning and basic visualizations, PostgreSQL and pgAdmin for data querying and complex analysis. 
 
By the end of the course, you will be prepared to present BI project outcomes in a way that showcases the impact on business performance, making you a valuable asset in data-driven organizations. 
 
Additionally, you will be equipped with a variety of artifacts showing your business intelligence skills that you can use in interviews. 


Course Syllabus

Module 0: Welcome 
  • Video: Course Introduction 
  • Reading: General Information 
  • Reading: Learning Objectives and Syllabus 
  • Reading: Grading Scheme 
  • Reading: Helpful Tips for Course Completion 
  • Reading: Business Scenario and Dataset Details 
Module 1: Data Cleaning and Preparation Using Excel 
  • Reading: Module 1 Introduction and Learning Objective 
  • Video: Assignment Overview: Data Cleaning and Preparation 
  • Lab: Data Cleaning and Preparation 
  • Video: Assignment Overview: Basic Analysis Using Pivot Tables 
  • Lab: Basic Analysis Using Pivot Tables 
  • Checklist: Module 1: Data Cleaning and Preparation Using Excel 
  • Graded Quiz: Module 1: Data Cleaning and Preparation Using Excel 
Module 2: Data Querying and Analysis Using PostgreSQL 
  • Reading: Module 2 Introduction and Learning Objective 
  • Video: Assignment Overview: Data Querying Using PostgreSQL 
  • Lab: Data Querying Using PostgreSQL 
  • Video: Assignment Overview: Data Analysis Using PostgreSQL 
  • Lab: Data Analysis Using PostgreSQL 
  • Checklist: Module 2: Data Querying and Analysis Using PostgreSQL 
  • Graded Quiz: Module 2: Data Querying and Analysis Using PostgreSQL 
Module 3: Data Visualization and Statistical Analysis 
  • Reading: Module 3 Introduction and Learning Objective 
  • Video: Assignment Overview: Data Visualization Using Excel 
  • Lab: Data Visualization Using Excel 
  • Video: Assignment Overview: Statistical Analysis Using Excel 
  • Lab: Statistical Analysis Using Excel 
  • Checklist: Module 3: Data Visualization and Statistical Analysis  
  • Graded Quiz: Module 3: Data Visualization and Statistical Analysis  
Module 4: Data Visualization and Dashboards with Tableau 
  • Reading: Module 4 Introduction and Learning Objective 
  • Video: Assignment Overview: Basic Tableau Visualizations 
  • Lab: Creating Basic Tableau Visualizations 
  • Video: Assignment Overview: Advanced Visualization Using Tableau 
  • Lab: Creating Interactive Dashboards in Tableau 
  • Checklist: Module 4: Data Visualization and Dashboards with Tableau 
  • Graded Quiz: Module 4: Data Visualization and Dashboards with Tableau 
Module 5: Present Your BI Analysis Findings 
  • Reading: Module 5 Introduction and Learning Objective 
  • Video: Structure of a Presentation 
  • Video: Best Practices for Presenting Your Findings 
  • Lab: (Optional): Getting Started with PowerPoint for the Web 
  • Lab: (Optional): Save Your PowerPoint Presentation as a PDF 
  • Reading: Assignment Overview 
  • Reading: Preparing Your Presentation 
  • Peer Review: Present Your BI Analysis Findings 
Module 6: Final Exam 
  • Reading: Module 6 Introduction and Learning Objective 
  • Reading: Final Exam Overview 
  • Graded Assignment: Final Exam 
  • Reading: Re-take Exam 
Module 7: Course Wrap up 
  • Reading: Congratulations and Next Steps 
  • Reading: Thanks from the Course Team 
  • Reading: Copyrights and Trademarks 
Module 7: Ace Your Job Hunt (Bonus Module) 
  • Reading: Module 8 Introduction and Learning Objective 
  • Reading: Creating Your Resume 
  • Video: Tips for Developing Your Portfolio 
  • Lab: Develop Your Personal Portfolio 
  • Video: Job Search Strategies for BI analysts 
  • Video: Networking and Building an Online Presence 
  • Video: Interview Preparation for BI Analysts 
Module 9: Course Rating & Feedback 
  • Reading: Feedback 
  • Badge 
  • Reading: How to Claim Your Certificate 

Recommended Skills Prior to Taking this Course

This course is designed for learners looking to apply their data analysis skills. Prior knowledge is required. 

Instructors

IBM Skills Network Team

Administrator

IBM Skills Network

Read more

Shubhra Das

IT-SME

I am a Senior Consultant with over 20 years of experience in IT project management, software testing, data science, and education. My career combines a proven ability to lead large-scale initiatives with a passion for mentoring and innovation, creating value in both financial outcomes and human capital. In my corporate career, I’ve transformed complex, high-risk projects into success stories. At IBM, I led a 500+ member testing team, saving $5.5M through Lean Six Sigma practices and establishing Testing Centers of Excellence (TCoEs). My expertise includes implementing Agile methodologies, automating workflows using tools like Selenium and JMeter, and resolving critical escalations. These efforts consistently delivered measurable success for clients across healthcare and IT sectors. As an educator, I’ve empowered 100+ students at The Princeton Review to achieve competitive GMAT, GRE, and SAT scores. Recently, I’ve extended my passion for teaching by developing IBM-collaborated data science courses for Coursera, crafting hands-on labs and projects in Python, R, and Tableau, combining real-world applications with academic rigor. Armed with a Master’s degree in Computer Science (Data Science) from the University of Illinois Urbana-Champaign, I specialize in data-driven problem-solving, machine learning, and deep learning for healthcare. My work bridges the gap between technology and education, ensuring impactful outcomes for both industries and individuals. Whether turning around “red alert” projects or mentoring the next generation, I thrive at the intersection of innovation and collaboration. Through my journey, I aim to inspire others to achieve excellence and unlock their full potential.

Read more