Power BI Intermediate: Learn the Finer Points of Power BI
Power BI Intermediate: Learn the Finer Points of Power BI, available at $79.99, has an average rating of 4.65, with 47 lectures, based on 33 reviews, and has 385 subscribers.
You will learn about Learn the finer points of Power BI Extend your knowledge of Power Query Quickly customize Power BI reports for different audiences Integrate Power BI with other Microsoft products Intermediate data modelling and DAX techniques This course is ideal for individuals who are Existing users of Power BI looking to extend their knowledge It is particularly useful for Existing users of Power BI looking to extend their knowledge.
Enroll now: Power BI Intermediate: Learn the Finer Points of Power BI
Summary
Title: Power BI Intermediate: Learn the Finer Points of Power BI
Price: $79.99
Average Rating: 4.65
Number of Lectures: 47
Number of Published Lectures: 47
Number of Curriculum Items: 47
Number of Published Curriculum Objects: 47
Original Price: $199.99
Quality Status: approved
Status: Live
What You Will Learn
- Learn the finer points of Power BI
- Extend your knowledge of Power Query
- Quickly customize Power BI reports for different audiences
- Integrate Power BI with other Microsoft products
- Intermediate data modelling and DAX techniques
Who Should Attend
- Existing users of Power BI looking to extend their knowledge
Target Audiences
- Existing users of Power BI looking to extend their knowledge
The Power BI Intermediate course by G Com Solutions is designed for users who are already familiar with Power BI and are looking to broaden their horizons when it comes to creating reports and dashboards.
The course will extend your knowledge of the Query Editor by showing your how to use query parameters and templates to add power and flexibility to your report creation. You will learn how to use query parameters to control data sources and to filter data as it’s loaded into the data model.
The course also discusses row-level security (RLS), the creation of roles and the implementation of RLS in the Power BI service. And we’ll also see how to leverage the DAX USERNAME function to create roles which are based on the user’s login.
We then move on to the integration of Power BI with other Microsoft products. We look at the incorporation of Excel solutions into Power BI workspaces and how to use the Analyze in Excel feature to build Excel reports driven by Power BI datasets. We also discuss the pinning of Excel content to Power BI dashboards and how to leverage Power BI’s dashboard subscription feature to distribute Excel content to a much wider audience than is normally possible.
We look at connecting to SharePoint folders and sub-folders, connecting to SharePoint lists and the security implications involved when embedding Power BI reports within SharePoint pages.
We also discuss PowerPoint integration: the tenant settings which control the ability to export reports to PowerPoint, the mechanism for exporting reports; and how to get the most out of this feature by optimizing your reports specifically for PowerPoint export.
The course then moves on to the configuration and implementation of drill-through pages and this includes a discussion of cross-report drill-through and how to overcome some of the limitations of this feature. And, we end this section with a look at a feature often used in conjunction with drill-through; customized tooltip pages.
Next, we talk about DAX what-if parameters and, after discussing the use of Power BI’s built-in feature, which can only be used with numeric parameters, the course shows you how to extend this feature by creating your own custom parameter tables.
And we use the parameters feature as a launchpad to the creation of a sophisticated currency conversion dashboard which gives us a chance to practice other useful techniques, such as the inclusion of custom visuals in your reports, the use of DAX variables to make your formulas clearer and easier to maintain, and how to provide useful interactive feedback to your users by creating dynamic titles driven by complex DAX formulas.
So, if you’ve already mastered the basics of Power BI and are looking to build on that knowledge, the Power BI Intermediate course by G Com Solutions could be exactly what you need.
Course Curriculum
Chapter 1: 01. Parameters
Lecture 1: 0100a-Welcome to the Course
Lecture 2: 0100b-Download the Course Files
Lecture 3: 0101-Overview of Parameters and Templates
Lecture 4: 0102-The Solution we will be Creating
Lecture 5: 0103-Creating Dynamic Titles
Lecture 6: 0104-Parameterizing a Filepath
Lecture 7: 0105-Creating Static List Parameters
Lecture 8: 0106-Creating Dynamic List Query Parameters
Lecture 9: 0107-Using Parameters to Filter Data
Lecture 10: 0108-Using Merge Queries for Filtering
Lecture 11: 0109-Exporting and Using a Power BI Template
Lecture 12: 0110-Modifying Parameters in the Power BI Service
Chapter 2: 02. Row-Level Security
Lecture 1: 0201-Row-Level Security Overview
Lecture 2: 0202-Creating Roles
Lecture 3: 0203-Implementing RLS in the Power BI Service
Lecture 4: 0204-Linking Row-Level Security to Login
Lecture 5: 0205-Implementing Username Rls in the Power BI Service
Chapter 3: 03. PowerPoint Integration
Lecture 1: 0301-Power BI’s Powerpoint Tenant Settings
Lecture 2: 0302-Preparing a Report for Export to Powerpoint
Lecture 3: 0303-Exporting Reports to Powerpoint
Chapter 4: 04. Excel Integration
Lecture 1: 0401-Importing Excel Tables
Lecture 2: 0402-Uploading Excel Workbooks
Lecture 3: 0403-Exporting Data
Lecture 4: 0404-Analyze in Excel
Chapter 5: 05. SharePoint Integration
Lecture 1: 0501-Connecting to Sharepoint Files
Lecture 2: 0502-Connecting to Sharepoint Folders
Lecture 3: 0503-Including Sub-Folders
Lecture 4: 0504-Connecting to a Sharepoint List
Lecture 5: 0505-Embedded a Report in a Sharepoint Page
Chapter 6: 06. Drillthrough and Tooltip Pages
Lecture 1: 0601-Basic Drill through Set up
Lecture 2: 0602-Customizing the Back Button
Lecture 3: 0603-Cross-Report Drill through
Lecture 4: 0604-Improving Cross-Report Drill through
Lecture 5: 0605-Using Drill through Buttons
Lecture 6: 0606-Creating Tooltip Pages
Chapter 7: 07. DAX What-If Parameters
Lecture 1: 0701-Creating a What-If Parameter
Lecture 2: 0702-Implementing a What-If Parameter
Chapter 8: 08. Further Practice
Lecture 1: 0801-The Solution We Will Be Creating
Lecture 2: 0802-Connecting to the Data
Lecture 3: 0803-Creating a Date Table
Lecture 4: 0804-Creating a Measures Table
Lecture 5: 0805-Creating a Reference to a Query
Lecture 6: 0806-The Chiclet Slicer Custom Visual
Lecture 7: 0807-The Timeline Slicer Custom Visual
Lecture 8: 0808-Creating Parameter Slicers
Lecture 9: 0809-Calculating the Offset Price
Lecture 10: 0810-Ceating a Dynamic Title
Instructors
-
Grant Gamble
Developer, trainer and author
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 1 votes
- 4 stars: 7 votes
- 5 stars: 25 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024