In this course, you'll learn how to use Power BI to create and maintain relationships in a data model and form a model using multiple Schemas. You'll explore the basics of DAX, Power BI's expression language, and add calculations to your model to create elements and analysis in Power BI. You'll discover how to configure the model to support Power BI features for insightful visualizations, analysis, and optimization.
通过 Coursera Plus 提高技能,仅需 239 美元/年(原价 399 美元)。立即节省
13 条评论
推荐体验
推荐体验
初级
Previous data analysis experience is not necessary. You need to be familiar with using computers and it helps if you enjoy questioning information.
13 条评论
推荐体验
推荐体验
初级
Previous data analysis experience is not necessary. You need to be familiar with using computers and it helps if you enjoy questioning information.
您将学到什么
How to form a model using a Star Schema.
How to write calculations DAX to create elements and analysis in Power BI.
How to optimize performance in a Power BI model.
您将获得的技能
您将学习的工具
要了解的详细信息

添加到您的领英档案
24 项作业
了解顶级公司的员工如何掌握热门技能

积累特定领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 获得可共享的职业证书

该课程共有4个模块
This module introduces data modeling and the schemas used to create them.
涵盖的内容
13个视频20篇阅读材料6个作业2个讨论话题
13个视频•总计68分钟
- Course introduction•4分钟
- Introduction to data models•5分钟
- Introduction to schemas•6分钟
- Setting up a Flat schema in Power BI•5分钟
- Understanding fact and dimension tables•4分钟
- Introduction to cardinality•5分钟
- Introduction to cross-filter direction•5分钟
- Defining data granularity•6分钟
- Setting up a Star schema in Power BI•6分钟
- Setting up a Snowflake schema•6分钟
- Why it is important to use Snowflake schema•4分钟
- Resolving challenges in data models•5分钟
- Module summary: Concepts for data modeling•6分钟
20篇阅读材料•总计225分钟
- Course syllabus•10分钟
- How to be successful in this course•10分钟
- How to open an image in a new tab•10分钟
- Setting up your Power BI environment•10分钟
- Additional resources: Concepts for data modeling•5分钟
- Model view in Power BI•10分钟
- Schemas cheatsheet•10分钟
- Table and column properties cheatsheet•10分钟
- Exercise: Configuring a Flat schema•30分钟
- Exemplar: Configuring a Flat schema•10分钟
- Activity: Configure a Flat schema with multiple sources•10分钟
- Additional resources: Introduction to data models•10分钟
- Normalization and denormalization•10分钟
- Managing model relationships•10分钟
- Model relationships cheatsheet•10分钟
- Additional resources: Introduction to cardinality and cross-filter direction•5分钟
- Exercise: Configuring a Star schema•30分钟
- Exemplar: Configuring a Star schema•10分钟
- Activity: Changing your Star schema into a Snowflake schema•10分钟
- Additional resources: Working with advanced data models•5分钟
6个作业•总计95分钟
- Module quiz: Concepts for data modeling•30分钟
- Self-review: Configuring a Flat schema•10分钟
- Knowledge check: Introduction to data models•15分钟
- Knowledge check: Introduction to cardinality and cross-filter direction•15分钟
- Self-review: Configuring a Star schema•10分钟
- Knowledge check: Working with advanced data models•15分钟
2个讨论话题•总计20分钟
- Discussion prompt: What do you hope to learn?•10分钟
- Why is data modeling important in the data analysis process?•10分钟
This module introduces the learner to the DAX (Data Analysis Expressions) language. The module explores the syntax of DAX using multiple business use cases. The module also integrates DAX with previous lessons on database tables and their use and introduces the concept of time intelligence.
涵盖的内容
23个视频20篇阅读材料10个作业1个讨论话题
23个视频•总计113分钟
- Introduction to Data Analysis Expressions (DAX)•6分钟
- Row context and filter context•6分钟
- Formulas and functions in DAX•5分钟
- Introduction to calculated tables•5分钟
- Creating calculated columns•5分钟
- Introduction to measures•5分钟
- Types of measures•5分钟
- Basic statistical functions•5分钟
- Context and DAX measures•4分钟
- Creating quick measures•6分钟
- Creating custom measures with DAX•4分钟
- Introduction to the CROSSFILTER function•5分钟
- Using CALCULATE with filters•5分钟
- Introduction to role-playing dimensions•6分钟
- Introduction to the USERELATIONSHIP function•5分钟
- Configuring role-playing dimensions•3分钟
- The importance of time intelligence•5分钟
- Using DAX for summarization over time•6分钟
- Using DAX for comparison over time•5分钟
- Setting up a common date table•5分钟
- Setting up a common date table with M and Power Query•4分钟
- Time intelligence in business•3分钟
- Module summary: Using DAX in Power BI•7分钟
20篇阅读材料•总计255分钟
- DAX cheatsheet•10分钟
- Cloning and calculating tables•10分钟
- Exercise: Adding a calculated table and column•30分钟
- Exemplar: Adding a calculated table and column•10分钟
- Additional resources: Introduction to DAX•5分钟
- Statistical functions cheatsheet•10分钟
- Additional resources: Introduction to measures•5分钟
- Exercise: Adding a measure•30分钟
- Exemplar: Adding a measure•10分钟
- Filter functions in CALCULATE•10分钟
- Activity: Using the CALCULATE function•10分钟
- Additional resources: Working with measures•5分钟
- Exercise: Adding a role-playing dimension•30分钟
- Exemplar: Adding a role-playing dimension•10分钟
- Additional resources: DAX and table relationships•5分钟
- Additional time intelligence functions•10分钟
- Exercise: Using time intelligence to compare to previous year•30分钟
- Exemplar: Using time intelligence to compare to previous year•10分钟
- Activity: Set up a common date table•10分钟
- Additional resources: Time intelligence and calculations in DAX•5分钟
10个作业•总计145分钟
- Module quiz: Using DAX in Power BI•30分钟
- Self-review: Adding a calculated table and column•10分钟
- Knowledge check: Using Data Analysis Expressions (DAX) in Power BI•15分钟
- Knowledge check: Introduction to measures•15分钟
- Self-review: Adding a measure•10分钟
- Knowledge check: Working with measures•15分钟
- Self-review: Adding a role-playing dimension•10分钟
- Knowledge check: DAX and table relationships•15分钟
- Self-review: Using time intelligence to compare to previous year•10分钟
- Knowledge check: Time intelligence calculations in DAX•15分钟
1个讨论话题•总计10分钟
- Which DAX features did you find most useful?•10分钟
This module explores the optimization process and examines the tools and methods to achieve this in Power BI, including using performance analyzer and DirectQuery features. This module also dives deeper into DAX and its use in the real world.
涵盖的内容
10个视频12篇阅读材料6个作业1个讨论话题
10个视频•总计59分钟
- What is optimization and why is it necessary?•7分钟
- Optimization by example•7分钟
- Resolving performance issues in the data model•5分钟
- Identifying and reducing cardinality levels•6分钟
- Behavior and limitations of DirectQuery connections•7分钟
- Optimizing DirectQuery performance with query reductions•4分钟
- Optimizing DirectQuery performance with table storage•6分钟
- What are aggregations and why use them?•6分钟
- Creating an aggregation•6分钟
- Module summary: Optimize a model for performance in Power BI•8分钟
12篇阅读材料•总计145分钟
- Exercise: Improving data model performance•30分钟
- Exemplar: Improving data model performance•10分钟
- Optimizing columns and metadata•10分钟
- Optimizing the Auto date/time feature•10分钟
- Activity: Optimizing the columns and Auto date/time•10分钟
- Additional resources: Optimize performance in a Power BI model•5分钟
- Walk-through: Optimizing a DirectQuery model•10分钟
- Additional resources: Optimize DirectQuery models•5分钟
- Exercise: Adding an aggregation•30分钟
- Exemplar: Adding an aggregation•10分钟
- How to manage aggregations step-by-step •10分钟
- Additional resources: Create and manage aggregations•5分钟
6个作业•总计95分钟
- Module quiz: Optimize a model for performance in Power BI•30分钟
- Self-Review: Improving data model performance•10分钟
- Knowledge check: Optimize a model for performance in Power BI•15分钟
- Knowledge check: Optimize DirectQuery models•15分钟
- Self-review: Adding an aggregation•10分钟
- Knowledge check: Create and manage aggregations•15分钟
1个讨论话题•总计10分钟
- How would performance and optimization impact different stakeholders?•10分钟
In this module, you will be assessed on the key skills covered in the course. This module summarizes the course and reflects on the primary learning objectives. The module also contains the project for the course, which encapsulates the learning into a practical whole.
涵盖的内容
2个视频4篇阅读材料2个作业1个讨论话题
2个视频•总计6分钟
- Course recap: Modeling data in Power BI•3分钟
- Congratulations!•3分钟
4篇阅读材料•总计60分钟
- About the final project and assessment: Modeling data in Power BI•10分钟
- Exercise: Building and optimizing a data model•30分钟
- Exemplar: Building and optimizing a data model•10分钟
- Next steps•10分钟
2个作业•总计105分钟
- Self-review: Building and optimizing a data model•15分钟
- Course quiz: Modeling data in Power BI•90分钟
1个讨论话题•总计10分钟
- Reflect on learning•10分钟
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师

提供方

提供方

Our goal at Microsoft is to empower every individual and organization on the planet to achieve more. In this next revolution of digital transformation, growth is being driven by technology. Our integrated cloud approach creates an unmatched platform for digital transformation. We address the real-world needs of customers by seamlessly integrating Microsoft 365, Dynamics 365, LinkedIn, GitHub, Microsoft Power Platform, and Azure to unlock business value for every organization—from large enterprises to family-run businesses. The backbone and foundation of this is Azure.
从 Data Analysis 浏览更多内容
状态:免费试用免费试用课程
状态:预览预览SSimplilearn
课程
状态:免费试用免费试用MMicrosoft
课程
状态:免费免费指导项目
人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.
常见问题
This program is for you:
● If you want to switch or start a career in the field of data analytics.
● If you are interested in the field of data analytics, just beginning to work with business intelligence and data analysis solutions and services, or new to Microsoft Power BI.
You don’t need any background knowledge to take this Professional Certificate. Whether you’re just starting out or a professional in a relevant field, this program can be the right fit for you.
It typically takes 5 months to complete the 8 courses. But some learners may go through the content faster.
Whether you’re looking to start a new career or change your current one, Professional Certificates help you become job ready. Apply your new skills on hands-on projects that showcase your expertise to potential employers and earn a career credential to kickstart your new career.
Once you have completed this Professional Certificate, you’ll have built a foundational knowledge of the key concepts and tools in Power BI and how they apply to a business environment including:
• The ability to implement best practices when conducting Data Analysis.
• The skills to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.
• The ability to provide valuable data insights that help to inform business decisions.
Power BI Data Analysts design, develop, and deploy business analytics dashboards using Microsoft Power BI. Data analysts are essential in helping organizations gain valuable insights into the expanse of data that they have, and they work closely with others in the organization to help reveal valuable information.
Data analysts and business intelligence analysts both help drive data-driven decision-making in their organizations. Data analysts tend to work more closely with the data itself, while business intelligence analysts tend to be more involved in using the results of data analysis to address business needs and recommend solutions. The Power BI data analyst is a combination of both of these roles. They work closely with business stakeholders to identify business requirements and collaborate with enterprise data analysts and data engineers to identify and acquire data. They also transform the data, create data models, visualize data, and share assets by using Power BI. These are all highly sort after roles.
Prepare for a career as a data analyst using Power BI. The Power BI skills you learn in this program prepare you for an entry-level role as a data analyst. An entry-level role as a data analyst is a great starting point and can be the first step towards building a career as a business intelligence analyst, data scientist or data engineer.
This course is completely online. You can access your lessons, readings, and assignments anytime and anywhere via the web or your mobile device.
We highly recommend taking the courses of each certificate program in the order they are presented. The content in the courses builds on information from earlier courses. The final course contains a practice exam that assesses your knowledge of the content covered in the previous courses. As such, it makes the most sense to take the courses in the order they are presented.
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
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.
更多问题
提供助学金,


