Offered By: SkillUpEdTech
Business Intelligence: Capstone Project
Gain hands-on experience in data analysis with Excel, PostgreSQL, and Tableau to execute a BI project and enhance decision-making and performance.
Continue reading Premium
Course
Business Intelligence
At a Glance
Gain hands-on experience in data analysis with Excel, PostgreSQL, and Tableau to execute a BI project and enhance decision-making and performance.
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.
Estimated Effort
3 Weeks
Level
Advanced
Skills You Will Learn
Business Intelligence, Dashboards, Data Analysis, Data Visualization, Tableau
Language
English
Course Code
BI0301EN