Digital Tools in Business
| Rakennetyyppi: | Opintojakso |
|---|---|
| Koodi: | TI00BR51 |
| OPS: | IB 2025 |
| Taso: | Tradenomi (AMK) |
| Opiskeluvuosi: | 1 (2025-2026) |
| Lukukausi: | Kevät |
| Laajuus: | 5 op |
| Vastuuopettaja: | Wahlman, Erik |
| Opetuskieli: | Englanti |
Osaamistavoitteet
This course introduces students to essential digital tools used in modern business environments, including Excel, Power BI, and Power Query.
Students will learn to manage, clean, and analyse data effectively, utilizing advanced Excel functions, data transformation techniques, and visualization tools. By creating reports, dashboards, and solving real-world business cases, students will gain practical skills for leveraging digital tools to support data-driven decision-making in business contexts.
Upon successful completion of this course, students will be able to:
Understand and apply digital tools for data management and analysis. Demonstrate proficiency in Excel, including importing, cleaning, and organizing data for business applications. Utilize advanced Excel functions to analyse business data effectively. Apply formulas, pivot tables, and data analysis tools to extract meaningful insights. Transform and visualize data using Power BI and Power Query. Integrate, clean, and transform data, creating dynamic dashboards and reports for decision-making.
Opiskelijan työmäärä
Contact teaching 40 h
Independent work 95 h
Edeltävät opinnot / Suositellut valinnaiset opinnot
Basic knowledge of Microsoft Office Suite.
Sisältö
Introduction to Digital Tools: Overview of Excel, Power BI, and Power Query.
Data Management in Excel: Importing, cleaning, and organizing data.
Advanced Excel Functions: Formulas, pivot tables, and data analysis tools.
Introduction to Power BI: Basic navigation, data import, and integration with Excel.
Data Transformation with Power Query: Cleaning and transforming data.
Data Visualization in Power BI: Creating reports and dashboards.
Practical Applications: Real-world projects and case studies.