Business Intelligence Analyst Course Project
Welcome to the Business Intelligence Analyst Course Project repository! In this project, I took on the role of a Business Intelligence Analyst for AdventureWorks Cycles, a fictional manufacturing company. The goal was to transform raw data into professional-quality reports and dashboards to track KPIs, compare regional performance, analyze product-level trends, and identify high-value customers.
Course Overview: This project was completed as part of an online course focusing on business intelligence and data analytics. The course covered key stages of the business intelligence workflow and simulated real-world tasks that data professionals encounter on the job.
Key Stages: Connecting & Shaping Data:
Built automated workflows to extract, transform, and load project data using Power Query. Explored common data connectors, storage modes, and table transformations.
Creating a Relational Data Model:
Reviewed data modeling best practices and introduced topics like cardinality, normalization, and star schemas. Built the AdventureWorks data model from scratch. Adding Calculated Fields with DAX:
Introduced data analysis expressions (DAX) and created calculated columns and measures. Explored powerful tools like filter functions, iterators, and time intelligence patterns. Visualizing Data with Reports:
Brought data to life with reports and dashboards using Power BI. Applied data visualization best practices and added interactivity with bookmarks, slicers, and parameters. Course Completion: I successfully completed all stages of the course and gained hands-on experience in business intelligence tools and techniques. This repository showcases the projects and assignments completed throughout the course.
Project Structure: Stage-1 Connecting_Shaping_Data: Contains scripts and files related to Stage 1 of the project. Stage-2 Creating_Relational_Model: Contains scripts and files related to Stage 2 of the project. Stage-3 Adding_Calculated_Fields: Contains scripts and files related to Stage 3 of the project. Stage-4 Visualizing_Data: Contains scripts and files related to Stage 4 of the project.
Screenshots: Contains screenshots of reports and dashboards created during the project.
How to Use: Clone the repository to your local machine. Navigate to the desired stage folder to explore the scripts and files.