Functional Application Consultant learning catalog

Are you an implementation expert for a business domain?

The following catalog is organized from core knowledge to specific domains, and from most basic to most advanced. If content exists in multiple formats, we'll let you know, so that you can choose the training format that best meets your needs.

For functional consultants, our job-task analysis research showed that everyone must understand the core content set as well as a domain area.

Get started

Content	Description	Format	Length
A walk through of Power BI most advanced features through Star Wars data - Gil Raviv	Be a Full Stack Power BI Jedi - A walk through of Power BI most advanced features through Star Wars data by Gil Raviv	YouTube video	58 min 51 sec
Getting Started with Power BI	Wondering how to get started with Power BI? How to connect to data and visualize it for the first time? Learn how to quickly get started with Power BI and get insights from your business data in no time.	Webinar
How to Become an Insights-Driven Business	It’s important for enterprises and large organizations to analyze their data and use it to create actionable insights. According to Forrester Research, these capabilities are key to becoming an insights-driven business. Watch this webinar to learn why business outcomes should be driven by insights.	Webinar
Learn to Navigate Your Way Through a Power BI Dashboard in 20 Minutes	Have you ever opened a Power BI Dashboard just to think, now what? How do I navigate through this to find the data that’s important to me? Do you limit your use of filters & slicers for fear of ‘breaking something’? Fear not, join us to learn how to navigate your way through a Power BI dashboard.	Webinar
Microsoft Power BI YouTube channel	YouTube channel with content from Microsoft's Power BI product team	Videos
Nine Trends Shaping the Future of Big Data Analytics	Register for this webinar to learn about nine important big data trends and challenges, according to CIOs and other IT leaders. Use their insights to improve your organization’s big data issues.	Webinar
Power BI and the Future of Modern and Enterprise BI	Watch this webinar to learn about the latest Power BI capabilities. Arun Ulagaratchagan, General Manager of Power BI Engineering, and Amir Netz, Chief Technology Officer of Power BI, will showcase these features and discuss what's coming next. You’ll also learn about the Power BI vision for unifying modern and enterprise BI, and expanding self-service BI for big data. Discover how Power BI enables you to build a data culture in your organization by empowering analysts and enabling agile enterprise BI.	Webinar
Power BI: Analytics Done Right	Calling all Analytics and Excel visionaries: learn how to make beautiful reports people want to use, share appealing insights that are easy to understand, and securely break silos of complex data to make it accessible. We'll share new product innovations and our vision for modern enterprise BI and self-service BI; enabling your organization to build a data-driven culture.	Webinar
Three Ways AI Is Changing BI	It’s crucial for analysts to investigate and visualize data to help their stakeholders find insights quickly and effectively. Business demands have evolved from executives asking what and when something happened, to asking why it happened—and what will occur in the future. Register for this webinar to learn about three data insight opportunities that blend AI with business intelligence (BI).	Webinar
Unleash the Power of Power BI – tips and tricks by Philip Seamark	Join Philip Seamark as he walks through some of the details around the largest deployment of Power BI in the Southern Hemisphere, how it's used, and how it meets their BI needs. This session will cover a variety of tips and tricks to help you enhance your Power BI reports.	Webinar	53 min 47 sec
What is Power BI?	Overview of Power BI	Website	3 minutes to read
Use DAX in Power BI Desktop	This learning path introduces Data Analysis Expressions (DAX) and provides you with foundational skills required to enhance data models with calculations.	Free, self-paced online learning path	4 hr 30 min

Best Practices

Content	Description	Format	Length
Power Tricks, Tips and Tools from the owners of PowerBI.Tips	Power Tricks, Tips and Tools from the owners of PowerBI.Tips In this very special user group meeting the owners of PowerBI.Tips and Power BI MVPs, Seth Baur and Mike Carlo will share with you their huge grab bag of Power Tricks, Tips and Tools they have published to http://PowerBI.Tips over the last 18 months. Demo’s to include their theme generator, adding data types within the query editor and their latest offering Power BI layouts (and a tour of their latest layout “Cool Blue”).	Webinar	1 hr 7 min 40 sec
Strengthen Your Data Modeling Skills with Power BI	Register for this webinar to take your Power BI modeling skills to the next level. Learn about the Power BI in-memory analytics engine, strategies for creating and managing data relationships, and how to use Data Analysis Expressions (DAX) filter context. Find out how to master any modeling challenge with Power BI or Azure Analysis Services.	Webinar
Transforming A Report From Good to GREAT...	Failing to deliver a well-designed Power BI Report is perhaps the most common reporting pitfall. What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view. This webinar will walk through the common dos and don’ts of reporting in Power BI, using easy-to-learn techniques that bring data to life.	Webinar

Case Studies

Content	Description	Format	Length
Achieving a Win-Win for Consumer Packaged Goods Manufacturers and Retailers	With data volumes growing exponentially, technology is critical in helping manufacturers understand and react to the needs of consumers. It also helps them forge more effective relationships with their customers—the retailers and distributors. Register for this webinar featuring Thorogood, an independent consultancy specializing in business intelligence and analytics. Learn how the company has worked with global manufacturers to develop a Power BI-based solution, which utilizes data to improve strategic decisions.	Webinar
Applied Intelligence for Sales & Service	Customer experiences are the new competitive battleground. Consistent and relevant interactions unlock new value, increasing customer engagement, loyalty, and revenue. Learn how Avanade combines modern analytics, artificial intelligence, and automation to surface Next Best Action in context-whether in a marketing campaign, online customer self-service portal, or sales and service interactions.	Webinar
Build Impactful Financial Dashboards Using Microsoft Power BI	As a Financial analyst, rather than wrestling with data and queries, wouldn't you rather focus on serving your customer—the business—by providing smart analysis, insights and financial guidance? Meet Microsoft Power BI: the latest and greatest BI tool by Microsoft that's making waves. Power BI makes it super easy to clean up messy data; combine data from multiple sources (e.g., general ledger, personnel); define magical measures that you can use everywhere—say goodbye to filling your sheets with endless formulas; and create beautiful and impactful visualizations that you can interact with and ask questions (no more walking out of meetings with twenty action items). Discover all of this and more as we walk through building an actual financial dashboard using Power BI.	Webinar	1 hr 34 sec
Data Storytelling with Power BI by Tristan Malherbe	Data Storytelling with Power BI by Tristan Malherbe	YouTube video	59 min 54 sec
Digital transformation in Manufacturing - leverage analytics to maximize profitability	The fastest way to improve efficiency and profitability in manufacturing is to empower everyone, from the CEO to the line-technician, with real-time analysis of performance. Capturing your order-to-cash data isn't enough. Putting that data to work requires turning day-to-day transactions into visual elements that "touch a nerve.” In this webinar, Microsoft and Blue Margin, Inc. (Gold Partner in Data Analytics and Data Platform) will demonstrate how companies can transform into data-driven organizations in a matter of weeks. Hear directly from a $100M+ manufacturer who uses analytics to uncover the answers to difficult questions, and fix misalignments between production and demand."	Webinar
How to Get Insights from Your Workday HR Data	Human capital management (HCM) systems often lack flexibility when providing insights for strategic decision-making and analyzing workforce management. Join this webinar to find out how Microsoft partner Agile Analytics created its HR Analytics solution using Power BI. The solution enables you to pull information directly from Workday and easily combine it with other data to get real-time insights for optimization, forecasting, and reporting.	Webinar
Microsoft Runs on Power BI: Financial Planning & Analysis Made Easy	Register for this webinar to learn how Power BI helps you manage financial planning and analysis more easily and effectively. Connect to your data quickly, manage it, and customize it using content tailored to your audience—all with no coding.	Webinar
Microsoft Runs on Power BI: Using Power BI in Modern Treasury	Register for this webinar to learn how the Microsoft Treasury group changed how they analyze their business, managing $150 billion in assets and supporting operations in over 190 countries/regions, by moving their applications to the cloud, using Power BI for analytics and visualization.	Webinar
Power BI time intelligence for retail and wholesale industries w/ Matt Allington	Focusing on how time intelligence can be used for analysis in these industries.	Webinar	59 min
Proven Healthcare Solutions to Improve Both Patient Outcomes and Profitability	Healthcare organizations face the challenge of turning vast amounts of data into patient insights, and those insights into action. Register for this webinar to learn how to design meaningful healthcare reports that will help your organization convert data into useful patient insights. Get expert strategies and advice from US Medical IT founder and CEO Stephen Cracknell, Director of Healthcare IT Stuart Macanliss, and Texas-based rheumatologist Dr. John P. Lavery.	Webinar
See how PowerApps and Power BI can provide school teachers apps with reports	Education should be the #1 priority and school teachers should be provided all the tools they need. PowerApps, Flow and Power BI can be part of those tools. In this webinar Daniel Christian, Microsoft MVP will demonstrate how his educational app and report can help school teachers monitor the performance of their students. Daniel will demonstrate his PowerApp and Power BI report leverages the back end data to provide valuable insights.	Webinar	43 min 38 sec
Transform Your Customer Data into Retail Success	Register for this webinar and start putting your analytics to work. Angad Soni, an Enterprise Architect with Hitachi Solutions, will demonstrate how retail customers use analytics to improve both the bottom line and the customer experience. Find out how to enhance your pricing strategy, inventory optimization, and use of social data.	Webinar

Dashboards

Content	Description	Format	Length
Developing in Power BI with Streaming Datasets and Real-time Dashboards	This webinar by Power BI MVP, Ted Pattision, examines the three different types of realtime datasets including streaming datasets, push datasets and hybrid datasets. It shows how to create all three types of realtime datasets using the Power BI Service API as well as how to design realtime dashboards using streaming data tiles. The webinar also walks through the process of creating an Azure event hub and an Azure Streaming Analytics job and configuring them to push rows to a hybrid dataset inside an App workspace in Power BI.	Webinar	1 hr 14 sec
Zero to Dashboard in an Hour	During this session, we will walk through the process of creating a data model in Power BI Desktop and publishing it to the Power BI Service and SharePoint Online.	Webinar	1 hr 20 min 11 sec

Governance and deployment

Content	Description	Format	Length
Analytics in Azure virtual event: Accelerate time to insight with Azure Synapse Analytics	Register for this virtual event to learn how to simplify your data lake and data warehousing solutions with Azure Synapse Analytics. Query data on your terms using on-demand or provisioned resources. Experience a limitless analytics service built to ingest, prep, manage, and serve data, accelerating your time to insight.	Webinar
Get Started with the Power BI Mobile App	Watch this webinar to learn how to stay up to date with your data using your mobile device. Find out how to improve your experience by using mobile-optimized layouts, interact with your data on the go, get push notifications when your data needs attention, and share and collaborate with your colleagues from your mobile device.	Webinar
Next Generation Location and Data Analysis using Mapbox and Power BI	Join Charles Sterling and Sam Gehret as they walk through how Mapbox and Power BI can use location data to tell your story using next generation maps.	Webinar	36 min 32 sec
Power BI Adoption Framework Webinar Part 1: Adoption Adopt a data-driven culture	Shift your organization’s mindset to a data-driven culture and register for the Webinar series that gives you an adoption framework for Power BI from Microsoft. Self-service business intelligence (BI) adoption is challenging and getting the tools is only the first step of your journey. Successful adoption requires a change in people, processes, and technology. This webinar is the first in a five-part series that unlocks the potential of Power BI for your organization. In Part 1, learn how to build a structured approach to drive Power BI adoption and shift to a data-driven model for your organization.	Webinar
Power BI Adoption Framework Webinar Part 2: Governance	Roll out your self-service business intelligence (BI) adoption of Microsoft Power BI with success. Attend the webinar that outlines the role of governance in Power BI adoption. Learn the different governance approaches for different types of BI solutions, as well as the roles and responsibilities needed for an effective self-service BI practice.	Webinar
Power BI Adoption Framework Webinar Part 3: Service Management	Plan an effective rollout of Power BI for your organization and explore the nuances of effective software as a service (SaaS) management. This webinar is the third in a five-part series that unlocks the potential of Power BI for your organization. In Part 3, learn how to manage elements of tenant administration and gateway management and plan a smooth and successful rollout of Power BI.	Webinar
Power BI Adoption Framework Webinar Part 4: Security	This webinar is the fourth in a five-part series that unlocks the potential of Power BI for your organization. In Part 4, learn how to keep your data secure and to manage appropriate access to your data.	Webinar
Power BI Adoption Framework Webinar Part 5: Rollout	Transform your decision-making capabilities organization-wide and gain a complete adoption framework for Power BI from Microsoft. This webinar is the final session in a five-part series that unlocks the potential of Power BI for your organization. In Part 5, get clear guidance on your organization’s transition and drive a successful rollout from existing tools while empowering individuals to shift to a data-driven culture.	Webinar
Advanced data prep with Power BI data flows	Join Charles Sterling and Anton Fritz as they walk through Power BI data flow, whose public preview is just around the corner. In this session the product team will introduce you to the new and advanced capabilities for data prep in Power BI.	Webinar	56 min 2 sec
Scenario Analysis Patterns in Power BI using DAX - Free Training Workshop	We'll be reviewing a number of techniques specifically around scenarios analysis in Power BI. Don't just think Power BI is just a visualization tool, it is a powerful analytical engine that can produce amazing insights including running custom scenarios on your raw data.	Webinar	42 min 34 sec

Integration

Content	Description	Format	Length
Advanced Analytics with Excel and Power BI	Join us for this webinar to learn how Microsoft Excel and Power BI bring advanced analytics to the daily business decision process, allowing users to extract useful knowledge from data to solve problems.	Webinar
Automate Day-to-Day Business Processes with Power BI, PowerApps, and Microsoft Flow	Power BI enables millions of people to convert data into valuable business insights in minutes. Register for this webinar to learn how Power BI combines PowerApps and Microsoft Flow—the other components of the Microsoft Power platform—to help you do even more. Find out how to create your own business apps and automate your day-to-day business processes to streamline your business and accelerate innovation.	Webinar
Better Together: 5 Benefits Excel Users Will Get From Using Power BI	Excel is one of the most popular programs in the world. Millions of individuals and businesses use it for everything from simple data entry and accounting to more advanced statistical and data analytics. However, many people don’t realize that they can dramatically extend the functionality of Excel—as well as save time and increase their efficiency—when they pair it with another Microsoft program: Power BI. We’re going to explore five distinct reasons why you and your business can benefit from using Excel and Power BI together. By the end, you should have all the knowledge you need to jumpstart your organization’s ability to analyze, interpret, and capitalize on your data.	Webinar
Beyond the Spreadsheet	Calling all Excel users and Analysts: work smarter, deliver more value, and focus on what matters. Learn how to make beautiful reports people want to use, share data visually in a way that colleagues can understand without an explanation, and make insights accessible to everyone that needs to make sense of information - wherever they are. See Microsoft Power BI in action in this online session.	Webinar
Draw the right insights with Power BI and Visio	Join us for this webinar to learn how to combine Power BI dashboards and Microsoft Visio diagrams to create powerful visual insights. Visio and Power BI are highly visual and naturally complementary. Visio lets you create illustrative diagrams, such as interconnected workflows and real-world layouts. Power BI helps you build intuitive dashboards using charts and maps to measure key performance indicators and track goals.	Webinar
Power BI, Excel, and Microsoft 365: Optimize Your Enterprise Data	In this demo-rich session, learn how to use the unique strength of Microsoft Excel in Power BI to boost your business analytics and insights.	Webinar
Using Power BI with Dynamics 365 Finance and Operations	Register for this webinar to learn how Power BI reporting solutions can be embedded and managed within Dynamics 365 Finance and Operations using Azure Data Lake. Find out how to quickly deliver actionable insights without service disruptions and share analytical solutions to the enterprise using Power BI.	Webinar

Security

Content	Description	Format	Length
How Microsoft Is Changing BI Data Protection	Register for this webinar to learn how to help keep your BI data protected even when it is exported. Enable sensitivity classifications and real-time risk analysis to define access permissions.	Webinar	18 min 49 sec
Power BI security deep dive by Kasper de Jonge	One hot topic with Power BI is security, and in this deep dive session we will look at all the aspects of security of Power BI. Kasper will discuss logging where and how your data is stored, and look at how to leverage additional Azure services to make your information even more secure.	Webinar	1 hr 7 min 38 sec

Visualizations

Content	Description	Format	Length
Get actionable insights using real-world visualizations in your Power BI dashboard	Join Charles Sterling and Shakun Grover as they walk through using real-world visualizations in your Power BI dashboard. Microsoft Visio offers the perfect canvas for visually contextualizing data and depicting process flows. Using the new Visio visual for Power BI, you can easily bring alive Visio's powerful visualization capabilities right within your Power BI dashboards to drive insights and action.	Webinar	34 min 19 sec
Make Your Power BI Data Visual: Core Chart Types and How to Use Them	Chart type is one the most fundamental building blocks of visual analytics. With the right usage of charts, we create the right patterns and clarity, and provide the right answers for our users.	Webinar
Simply Compelling—Tips for Better Visualization Design	The human visual system has its own rules—we can easily see patterns presented to us in certain ways, but in other ways they're invisible. Therefore, we can apply rules for displaying information so that the important and informative patterns stand out. This session will walk you through a series of before-and-after case studies and teach you how to use visual perception to influence audience attention in data visualization design.	Webinar
Visualize public or private datasets with the new Power BI and data.world connector	In collaboration with data.world, Microsoft has released a new data connector that allows you to import data.world datasets into Power BI Desktop. Together with data.world, we’re excited to help data fans more easily collect, manage, explore, visualize and share insights with others.	Webinar