Joseph Yeates & John Lee – CFI Education – Power BI Case Study – CFI Capital Partners

Description

CFI Education – Power BI Case Study – CFI Capital Partners , Joseph Yeates & John Lee – CFI Education – Power BI Case Study – CFI Capital Partners download

Joseph Yeates & John Lee – CFI Education – Power BI Case Study – CFI Capital Partners

Power BI Case Study – CFI Capital Partners

Take on the role of a business intelligence analyst in an investment bank to develop a custom Power BI report to help CFI Capital Partners:

• experience real-world data scenarios
• create a professional-looking Power BI report
• practice modern user experience techniques for BI reporting

Overview

Power BI Case Study – CFI Capital Partners Overview

In this case study, you’ll take on the role of a business intelligence analyst in an investment bank. The sales and trading team at CFI Capital Partners needs you to develop a customized Power BI report to help with bespoke market analysis

You will need to connect to a variety of data sources for information about an investment portfolio, the securities in the portfolio, and the exchange on which the securities are traded. You will be required to transform and model data, create DAX measures, and build report visuals to satisfy the report requirements.

Power BI Case Study – CFI Capital Partners Learning Objectives

Upon completing this course, you will be able to:

• Transform data in Power Query and create a data model and DAX measures
• Analyze and visualize data by creating report visuals
• Build in better user experiences with functionality like Page Drillthrough, Bookmarks, and Conditional Formatting

Who should take this course?

This Power BI case study is perfect for those who want to put their knowledge about Power BI into practice with selected, real-life scenarios. This makes the course a great follow-up to CFI’s Power BI Fundamentals.

What you’ll learn

Case Study Introduction
Case Study Introduction
Learning Objectives
Downloadable Learner Files

Transform & Model Data
Chapter Introduction
Topics to Review
Task Overview – Transform & Model
Interactive Exercise – Transform & Model
factActivity
dimDate
dimExchange
dimSecurity
Data Model & Basic DAX Measures

Analyze & Visualize Data
Chapter Introduction
Topics to Review
Task Overview – Analyze & Visualize
Interactive Exercise – Analyze & Visualize
Exchange Visuals
Daily Volume Measures
YTD Daily Volume Measures
Security Visuals
Portfolio Weighting & Value
Current Price & Portfolio Value
Page Filters

User Experience
Chapter Introduction
Topics to Review
Task Overview – User Experience
Walkthrough

Conclusion
Case Study Summary

Qualified Assessment
Qualified Assessment

Commonly Asked Questions:

1. Business Model Innovation: Acknowledge the reality of a legitimate enterprise! Our approach involves the coordination of a collective purchase, in which the costs are shared among the participants. We utilize this cash to acquire renowned courses from sale pages and make them accessible to individuals with restricted financial resources. Our clients appreciate the affordability and accessibility we provide, despite the authors’ concerns.
2. CFI Education – Power BI Case Study – CFI Capital Partners Course

• There are no scheduled coaching calls or sessions with the author.
• Access to the author’s private Facebook group or web portal is not permitted.
• No access to the author’s private membership forum.
• There is no direct email support available from the author or their team.