What background knowledge is necessary to enroll in this course?

There is no specific background knowledge required to enroll in this course. However, basic familiarity with data concepts such as tables, columns, and basic Excel functions will be helpful. The course is designed for beginners, so no prior experience with Power BI or data analysis is necessary.

Who is this course for?

This course is ideal for beginners and professionals who want to learn how to use Power BI for data analysis, reporting, and visualization. It’s suited for business analysts, data analysts, and anyone involved in decision-making processes who needs to understand and present data insights effectively.

How long does it take to complete the course?

The course consists of 7 hours of video content, but the time required to complete it will depend on your learning pace. It’s recommended to take your time with hands-on exercises to solidify the concepts, so you can expect it to take slightly longer than the video duration.

Can I preview a course before enrolling?

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

When will I have access to the lectures and assignments?

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

What will I get when I enroll?

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.

When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Master in Microsoft Power BI Desktop and Service

Master in Microsoft Power BI Desktop and Service

位教师：Packt - Course Instructors

包含在中

了解更多

7个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

7个模块

深入了解一个主题并学习基础知识。

中级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Understand how to connect various data sources to Power BI.
Master Power Query for cleaning and transforming data efficiently.
Create and manage complex data models and relationships in Power BI.
Design interactive, insightful reports and dashboards using Power BI.

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

该课程共有7个模块

This course features Coursera Coach!

A smarter way to learn with interactive, real-time conversations that help you test your knowledge, challenge assumptions, and deepen your understanding as you progress through the course. In this comprehensive course, you will gain a deep understanding of Microsoft Power BI and how to effectively use it for data analysis and visualization. The course covers everything from basic business intelligence concepts to more advanced topics such as data modeling, DAX functions, and creating interactive dashboards. By mastering these skills, you'll be able to make informed business decisions using powerful visualizations and data insights. The course begins with an introduction to business intelligence concepts, followed by detailed instructions on setting up and connecting Power BI with various data sources such as Excel, SQL Server, and web pages. You will then delve into Power Query for data transformation, learning how to manipulate and clean your data. As you continue, you'll explore data modeling techniques, building relationships between different data sets, and mastering DAX functions for creating calculated columns and measures. The course also covers visualization techniques, including creating tables, charts, and maps, and how to format and customize your reports for maximum impact. Finally, you'll learn how to publish and share your reports via Power BI Service, including setting up dashboards and using row-level security. This course is perfect for individuals looking to enhance their data analysis skills and gain a strong foundation in Power BI. Whether you're a business analyst, data professional, or someone looking to upskill in data visualization, this course will take you through the essential concepts and tools in Power BI. By the end of the course, you will be able to connect Power BI to multiple data sources, transform data using Power Query, build complex data models and relationships, create detailed reports and dashboards, and publish them securely using Power BI Service.

In this module, we will explore the essentials of Business Intelligence and how Microsoft Power BI empowers professionals to derive insights from data. We will break down BI concepts, data warehousing, and ETL processes in simple terms. Finally, you will get hands-on with Power BI Desktop installation, interface navigation, and connecting to multiple data sources.

涵盖的内容

5个视频1篇阅读材料

In this module, we will teach you how to connect Power BI to various data sources. You will learn how to import data from Excel, CSV files, SQL Server, and even directly from webpages. We’ll also cover how to enter data manually into Power BI Desktop, ensuring you’re ready to work with multiple data formats.

涵盖的内容

5个视频1个作业

In this module, we will dive deep into Power Query, the tool that allows you to prepare and transform your data before analysis. You’ll learn to clean and modify your data, perform calculations, merge queries, and create hierarchical structures. This section is designed to give you the skills to shape your data to meet your analysis needs.

涵盖的内容

10个视频1个作业

10个视频总计95分钟

Introduction to Power Query2分钟
Query Editor12分钟
Text Transformations18分钟
Number Column Calculations5分钟
Data Type6分钟
Date and Time Calculations13分钟
Append Queries and Merge Queries20分钟
Data Source Settings and Refresh Settings4分钟
Power Query Data Formatting8分钟
Hierarchy Creation in Power BI4分钟

1个作业总计15分钟

Power Query for Data Transformation - Assessment15分钟

In this module, we will introduce you to data modeling within Power BI. You’ll understand the importance of relationships between data tables, learn to build and manage these relationships, and explore the Snowflake Schema. By the end of this section, you’ll be able to create and optimize complex data models for analysis.

涵盖的内容

6个视频1个作业

6个视频总计33分钟

Data Modeling Introduction3分钟
Primary key Versus Foreign Key2分钟
Relationship build, Edit, Delete8分钟
Snowflake Scheme4分钟
Active Versus Inactive relationship4分钟
Relationship Primary Key with Multiple Foreign Keys from Different Data9分钟

1个作业总计15分钟

Power BI Data Modeling – Relationship View and PowerPivot - Assessment15分钟

In this module, we will focus on DAX (Data Analysis Expressions), the powerful language behind Power BI’s calculations. You will learn how to create calculated columns, measures, and use various DAX functions to manipulate and analyze data. We’ll also cover time intelligence functions and ranking, taking your data analysis to the next level.

涵盖的内容

13个视频1个作业

13个视频总计90分钟

Introduction to Data Analysis DAX)3分钟
Creating Calculated Columns, Creating Measures8分钟
DAX Date and Time Functions10分钟
DAX Text Functions6分钟
DAX Logical Functions13分钟
DAX Related Function9分钟
DAX Implicit Versus Explicit Measures3分钟
DAX Statistical Functions1分钟
DAX Filter Functions7分钟
DAX X-factor Functions5分钟
DAX Time Intelligence Functions10分钟
DAX Rank Functions5分钟
New Table and Quick Measure5分钟

1个作业总计15分钟

Data Analysis DAX- Assessment15分钟

In this module, we will explore the diverse visualization options available in Power BI. You’ll learn how to customize your reports using various charts, maps, KPIs, and slicers. We’ll also cover advanced features like conditional formatting and drill-through for building interactive, dynamic reports that provide deep insights.

涵盖的内容

23个视频1个作业

23个视频总计114分钟

Introduction to Reports and Visualization Types in Power BI1分钟
Page Settings5分钟
Getting started with color formatting and axis properties7分钟
Customize Visualization and X-axis and Y-axis properties8分钟
Filters in Power BI5分钟
Slicers in Power BI6分钟
Table and Matrix4分钟
Conditional Formatting on Visuals4分钟
Card and Multi-Row Card12分钟
Treemap2分钟
Combo Chart3分钟
Line chart, Area chart, and Stacked area chart2分钟
Gauge chart7分钟
KPI5分钟
Drill through4分钟
Map and Filled map6分钟
Pie chart and Doughnut charts3分钟
Ribbon charts4分钟
Waterfall Chart3分钟
Funnel chart2分钟
Import Data model to Power BI desktop2分钟
Phone layout2分钟
Bookmark7分钟

1个作业总计15分钟

Reports and Visualization Types in Power BI - Assessment15分钟

In this module, we will walk you through the process of publishing and sharing your reports in Power BI Service. You’ll learn how to create dashboards, analyze data in Excel, and use powerful features like usage metrics and Row-Level Security to control access. By the end of this section, you’ll have the skills to publish and manage reports effectively in Power BI Service.

涵盖的内容

17个视频3个作业

17个视频总计77分钟

Comparing Power BI Desktop and Power BI Service3分钟
Sign in to Power BI3分钟
Power BI Service walkthrough5分钟
Publishing a report from Power BI Desktop to Power BI Service7分钟
Create a Dashboard in Power BI Service5分钟
Power BI Service Workspace UI4分钟
Edit a Report in Power BI Service4分钟
Power BI Report - Reading View14分钟
Power BI Report - Usage Metrics3分钟
Analyze in Excel4分钟
Power BI Report - Quick Insights2分钟
Dashboard Walkthrough2分钟
Adding Tile in Dashboard3分钟
Q and A4分钟
Dataset Settings1分钟
Get More Visuals3分钟
Row-Level Security with Power BI4分钟

3个作业总计90分钟

Power BI Publishing - Reports - Assessment15分钟
Full Course Assessment60分钟
Full Course Practice Assessment15分钟

位教师

Packt - Course Instructors

Packt

1,186 门课程290,532 名学生

提供方

Packt

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

Microsoft Power BI is a business analytics tool that helps users visualize and share insights from their data. It enables the creation of interactive reports, dashboards, and data models. Power BI is relevant because it streamlines data analysis, making it easier for businesses to derive actionable insights from complex data, empowering informed decision-making.

This course, Master in Microsoft Power BI Desktop and Service, offers a comprehensive exploration of Power BI's capabilities, including connecting to data sources, transforming data, creating data models, building reports, and sharing them via Power BI Service. It covers both Power BI Desktop for local data visualization and Power BI Service for cloud-based collaboration, making it an all-encompassing guide to mastering the tool.

After completing this course, you will be proficient in connecting various data sources to Power BI, performing data transformations with Power Query, building complex data models using DAX (Data Analysis Expressions), creating a wide range of reports and visualizations, and sharing reports via Power BI Service. You will have the skills to perform end-to-end data analysis tasks and present your findings professionally.