Business Intelligence Class Audio Overviews (BUSI3013)

This episode provides a comprehensive technical roadmap for building a professional Business Intelligence (BI) tool from scratch, transitioning from a blank Google Colab notebook to a live, interactive Streamlit web application. Using the Thunder Bay Independent Coffee Association (TBICA) as a realistic case study, the discussion focuses on engineering a Product Velocity Index (PVI) —a composite s...

This episode provides a comprehensive overview of Big Data and Data Lakes , framing them as the structural foundation for modern data-driven industries. The discussion centers on the Seven V's of big data —volume, variety, velocity, veracity, variability, value, and visualization—explaining how these metrics shift when moving from traditional databases to massive, unstructured troves of data....

This podcast transcript provides a conceptual roadmap for implementing a data warehouse, using the Zagi retail company as a real-world case study to move from basic SQL table creation to the deployment of executive dashboards. The discussion details the ETL (Extraction, Transformation, and Load) process, emphasizing the strategic importance of being selective during extraction and using active and...

In this deep dive, we break down the technical roadmap for constructing a live, four-stage AI-powered sentiment analysis pipeline from scratch. Acting as analysts for a regional tourism board, students learn to navigate the extraction of live social media data from Blue Sky, clean it using pandas, and enrich it via the Anthropic API before visualizing results for specific Canadian cities. The epis...

In this episode, we dive into the "architecture of insight" by exploring the fundamental methodologies used to design analytical databases. We break down the core concepts of dimensional modeling , a specialized design technique that organizes information into fact tables containing numeric measures and dimension tables providing descriptive context. You will learn how these components f...

This chapter explores the fundamental concepts of data warehousing, emphasizing its role as a separate analytical data store designed to support complex decision-making through trend and pattern analysis. It highlights key functional and technical differences between application-oriented operational systems and subject-oriented data warehouses, which provide an integrated, historical, and time-var...

This analysis examines the shift from deterministic software to probabilistic Large Language Models (LLMs) . It details core mechanics like tokenization , vector embeddings , and Transformer self-attention . The text explores hierarchical training phases—pre-training, fine-tuning, and RLHF—while identifying enterprise deployment strategies like RAG . Beyond technical foundations, it addresses AI e...

This analysis examines the shift from deterministic software to probabilistic Large Language Models (LLMs) . It details core mechanics like tokenization , vector embeddings , and Transformer self-attention . The text explores hierarchical training phases—pre-training, fine-tuning, and RLHF—while identifying enterprise deployment strategies like RAG . Beyond technical foundations, it addresses AI e...

Chapter 4 explores the descriptive analytics continuum, focusing on data warehousing, business reporting, and visualization . It defines the data warehouse as an integrated repository of historical data that serves as the foundation for decision support. Key technical concepts covered include ETL (extraction, transformation, and load) , dimensional modeling through Star and Snowflake schemas, and...

Chapter 3 defines data as the essential " raw material " for business intelligence, emphasizing that it must be made " analytics ready " through rigorous preprocessing , cleaning, and transformation. It provides a taxonomy of structured and unstructured data and explores Big Data through its defining " Vs "—volume, variety, and velocity. The text introduces enabling technologies like Hadoop, Spark...

Chapter 2 explores the essentials of Artificial Intelligence (AI) , its major technologies, and its role in supporting business decision-making. It details key drivers, benefits, and foundational technologies, including machine learning , deep learning , NLP , computer vision , and robotics . The text distinguishes between human and machine intelligence and identifies three AI levels: assisted, au...

This chapter explores computerized support for managerial decision-making in complex, rapidly changing environments. It traces the evolution from early Management Information Systems to modern Business Intelligence, Analytics, and AI . Core concepts include Simon’s four-phase decision model (intelligence, design, choice, and implementation) and the three levels of analytics: descriptive, predictiv...