Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Đề cương khóa học
MODULE 1: POWER BI
In this module, we will explain what Power BI provides, examine the available products and their benefits, and cover how Power BI updates are delivered.
Lessons
- What is Power BI?
- Examining the Power BI Suite of Products
- Identifying Differences Between Products
- Understanding Power BI Updates
Lab 1: POWER BI
None
After completing this module, students will be able to:
- Understand Power BI.
- Understand the differences between products.
- Understand Power BI updates.
MODULE 2: POWER BI DESKTOP
In this module, we will examine the steps necessary to install Power BI Desktop, explore the interface, discuss the available file types and data sources, and discuss how to configure data refresh settings. We will also cover the available data types and discuss best practices in utilizing them.
Lessons
- Installing Power BI Desktop
- Exploring the Power BI Desktop Interface
- Utilizing File Types: PBIX vs PBIT
- Examining Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- After completing this module, students will be able to:
- Understand and utilize installing Power BI Desktop.
- Understand and utilize PBIX and PBIT file types.
- Understand data sources, data refresh, and data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
In this module, we will examine importing, transforming, and loading data using CSV, TXT, and Excel Worksheets. Power BI handles these file types with ease.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Appending Operations
- Working with Folders and Files
- Using Pivot Tables
After completing this module, students will be able to:
- Understand and utilize importing, transforming, and loading data.
- Understand and utilize appending operations.
- Understand and utilize working with folders and files.
- Understand and utilize using Pivot Tables.
MODULE 4: CONNECTING TO DATABASES
In this module, we will explore the process of connecting to databases and also examine relationships.
Lessons
- Working with Relational Data
- Understanding Relationships
- Importing from SQL Server Analysis Services Multidimensional and Tabular
Lab 4: CONNECTING TO DATABASES
- Importing From SQL Server and Examining Relationships
- Importing From SSAS Multidimensional
After completing this module, students will be able to:
- Understand and utilize importing from SQL Server and examining relationships.
- Understand relationships.
- Understand and utilize importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
In this module, we will discuss why merges have been difficult in the past, examine how much easier they are to utilize today, and explore grouping, summarizing and calculating options.
Lessons
- Understanding the Issues with Merges
- Performing Merges
- Grouping Options
- Summarizing
- Calculating
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Performing Merges
- Grouping and Summarizing
- Calculating
After completing this module, students will be able to:
- Understand and utilize performing merges.
- Understand and utilize grouping and summarizing.
- Understand and utilize calculating.
MODULE 6: REPORTING
In this module, we will create a report and examine the visualization options.
Lessons
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
Lab 6: REPORTING
- Creating Reports
- Utilizing the Matrix Visualization
- Utilizing the Map Visualization
- Utilizing the Card Visualization
- Utilizing the Chart Visualization
- Utilizing Slicers
- Publishing to Power BI Online
- After completing this module, students will be able to:
- Understand and utilize creating reports.
- Understand and utilize the matrix visualization.
- Understand and utilize the map visualization.
- Understand and utilize the card visualization.
- Understand and utilize the chart visualization.
- Understand and utilize slicers.
- Understand and utilize publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
In this module, we will explore what Power BI Online is and examine the features available, then discuss mobile options.
Lessons
- Introduction to Power BI Online
- Importing Data
- Creating Reports
- Configuring Dashboards
- Sharing Reports and Dashboards
- Exploring Power BI Mobile
Lab 7: POWER BI ONLINE
- Exploring the Power BI Online Interface
- Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files
- Creating a Report
- Adding Filters to a Report
- Adding KPIs to a Report
- Creating a Dashboard
- Pinning Tiles
After completing this module, students will be able to:
- Understand and utilize exploring the Power BI Online interface.
- Understand and utilize importing data.
- Understand and utilize creating reports.
- Understand and utilize adding filters to a report.
- Understand and utilize adding KPI’s to a report.
- Understand and utilize creating a dashboard.
- Understand and utilize pinning tiles.
Requirements
Một sự hiểu biết cơ bản về Excel và Databases
14 Hours
Testimonials (7)
Khobeib thật tuyệt vời, rất lịch sự, bình tĩnh và chuyên nghiệp. Luôn sẵn sàng giúp đỡ hoặc chậm lại nếu cần thiết.
Nicole - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
công cụ本身及其我可以不知道它可以为我们做什么 Correction: công cụ itself và những gì tôi không biết về những gì nó có thể làm cho chúng ta Final Natural Flow: công cụ này và những gì tôi chưa biết về khả năng của nó đối với chúng ta
Sam - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
Tốc độ, hoạt động và phản chiếu màn hình. Power Bi là cái mới đối với tôi và tôi rất mong được làm việc nhiều hơn với nó.
Michelle - Childhood Development Initiative CLG
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
Tôi thích mọi thứ!
Chana Wertheimer - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
Tính chất tương tác. Rất nhiều ví dụ thực hành và không chỉ là giảng dạy truyền thống và phát tài liệu. Tôi học tốt hơn khi được làm việc theo cách mà chúng tôi được hướng dẫn.
Derek Brown - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
Rất tương tác, giảng viên luôn sẵn sàng trả lời câu hỏi và hỗ trợ nếu chúng tôi bị落后。感激他们能够根据我们的需求定制培训并使用我们提供的数据集。 (Note: The last sentence was partially translated to maintain the structure as requested. However, for full coherence and accuracy in Vietnamese, it should be entirely translated as follows:) Rất tương tác, giảng viên luôn sẵn sàng trả lời câu hỏi và hỗ trợ nếu chúng tôi bị落后。感激他们能够根据我们的需求定制培训并使用我们提供的数据集。 Corrected fully coherent translation: Rất tương tác, giảng viên luôn sẵn sàng trả lời câu hỏi và hỗ trợ nếu chúng tôi bị tụt hậu. Rất cảm kích khi họ có thể tùy chỉnh khóa đào tạo theo nhu cầu của chúng tôi và sử dụng các bộ dữ liệu mà chúng tôi cung cấp.
Audrey Bernard - Environment and Climate Change Canada
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
Có thể làm theo các ví dụ thực hành
Robin White - Environment and Climate Change Canada
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
