Opinto-opas

Tavoitteet

Power BI is an analytics and reporting service provided by Microsoft that facilitates adopting business intelligence for companies, organizations, and enterprises. This course will teach the student how to work with all the important features in Power BI that allow to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully. After passing this course, the student will learn data visualization, data transformation, data modeling, and creating reports and dashboards through Power BI Desktop and Power BI service, and create opportunities for key decision makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.

Sisältö

Chapter 1: Introduction to Business Intelligence
What is Business Intelligence? – Business Intelligence vs. Business Analytics – Traditional vs. Modern BI – Overview of Data Analysis

Chapter 2: Getting Started with Power BI
What is Microsoft Power BI? – Parts of Power BI – How Power BI Matches Your Role – Set Up Power BI as Part of Your Organization – Set Up Power BI as an Individual – Sign Up for Power BI with a Microsoft 365 Trial – Install and Run Power BI Desktop

Chapter 3: Building Blocks of Power BI
Capacities and Workspaces – Datasets – Visualizations – Reports – Tiles – Dashboards – All Together

Chapter 4: Importing Data
Connect to Data Sources – Import Data from Excel – Import Text/CSV Data – Connect to a Web Data Source: Import a CSV File – Connect to a Web Data Source: Load a Web Page Data – Power BI Datasets: Create a Workspace – Power BI Datasets: Add a Dataset to Your Workspace – Connect to Power BI Datasets in Power BI Desktop

Chapter 5: Data Transformation
Power Query and Power Query Editor – General Transformations – Text Column Transformations – Number Column Transformations: Part 1 – Number Column Transformations: Part 2 – Combine Data – Combine Queries

Chapter 6: Data Visualization
Introduction to Visuals in Power BI – Create and Customize Simple Visualizations – Slicers – Map Visualizations – Metrics and Tables – Scatter Charts – Doughnut Charts – Waterfall and Funnel Charts – Treemaps – Color Modifications – Page Layout – Add Static Elements

Chapter 7: Data Modeling
Introduction – Model Relationships – Create and Manage Relationships – Create Calculated Columns – Create Calculated Tables – Apply Auto Date/Time – Create Measures – Use Quick Measures for Common Calculations – Optimize Data Models – Explore Time-based Data – What-if Parameters for Variable Visualization

Chapter 9: Creating Reports and Dashboards
Introduction to Power BI Service – Quick Insights – Introduction to dashboards – Create and Configure a Dashboard – Introduction to Power BI Q&A Visualizations – Create a Visual with Power BI Q&A – Create Custom Q&A Suggestions – Make Excel Data Work with Q&A – Edit Tile Details and Add Widgets

Chapter 10: Collaborate and Share
Share Dashboards with Your Organization – Publish Power BI Desktop Reports – Print and Export Dashboards and Reports – Publish to Web – Integrate OneDrive for Business with Power BI

Chapter 11: Final Tasks
Project – Self-study Essay

Aika ja paikka

Course is 100% online (Self-Study) course and it can be done in own pace. Study environment is TechClass -portal.

Oppimateriaalit

Lecture slides, tutorial videos, quizzes and exercises online in TechClass -portal.

Opetusmenetelmät

This course is 100% virtual, thanks to the comprehensive tutorial videos and content prepared for this course.

The student will pass this course after submitting the required quizzes, assignments, and the final project.

Harjoittelu- ja työelämäyhteistyö

N/A

Tenttien ajankohdat ja uusintamahdollisuudet

Online.

Kansainvälisyys

N/A

Toteutuksen valinnaiset suoritustavat

N/A

Opiskelijan ajankäyttö ja kuormitus

Lectures = 150h
Exercises = 90h
Self-study = 100h
Quizzes = 15h
Project = 40h
Total = 395 hours

Sisällön jaksotus

Up to Student her-/himself.

Lisätietoja opiskelijoille

Course is for Open UAS Students.

Enrolments via hakija työpöytä https://hakija.oma.metropolia.fi/

Arviointiasteikko

Hyväksytty/Hylätty

Arviointikriteerit, tyydyttävä (1)

- The student is familiar with the concepts of business intelligence (BI) and business analytics as well as their differences
- The student is familiar with the differences between traditional and modern BI solutions
- The student is familiar with the basic concepts involved in data analysis
- The student knows how to set up Power BI account and install and run Power BI Desktop
- The student is familiar with the building blocks of Power BI
- The student is familiar with importing basic datasets into Power BI

Arviointikriteerit, hyvä (3)

- The student understands the concepts of BI, business analytics, data analysis, and their differences
- The student understands the main building blocks of Power BI and how they are connected
- The student knows how to connect to data sources in Power BI Desktop
- The student knows how import text, CSV, and Excel data into Power BI Desktop
- The student knows how to apply transformations using Power Query Editor
- The student knows the basic practices of data modeling in Power BI such as create and manage relationships, using measures, and what-if parameters
- The student knows how to visualize data using simple plots such as scatter charts and slicers

Arviointikriteerit, kiitettävä (5)

- The student is proficient in importing different types of data into Power BI from local drive, web sources, and Power BI datasets
- The student understands the structure of Power Query Editor and how it works
- The student knows how to apply general transformations, text column transformations, number column transformations, and combine queries
- The student understands model relationships, calculated columns, measures, and what-if parameters
- The student knows how to perform data modeling using different practices
- The student can visualize data using different plots such as slicers, maps, scatter charts, doughnut charts, waterfall and funnel charts, and treemaps
- The student knows how to create dashboards, configure, and manage them
- The student is familiar with Power BI Q&A
- The student knows how to collaborate on reports and dashboards with colleagues
- The student knows how to export reports and dashboards and share them with people

Arviointimenetelmät ja arvioinnin perusteet

Exercises 60%
Quizzes 10%
Project 20%
Essay 10%

Lisätiedot

Course is for Open UAS Students.