Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Power BI 365 Intermediate
Learn how to connect to different datasets and modify, model, and report your data in Power BIPreview the first lesson free — get full access to all 56 lessons.
Intermediate Provider : Elizabeth Vergara 7 chapters · 56 Lessons · 3h 7m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Microsoft Power BI is a powerful tool that can be used to gain useful insights into different sets of data. Knowing how to connect to different databases can help you extract useful information and give you a better understanding of different business processes and functions. Also, by learning how to customize queries and use the advanced functions offered by Power BI, you will be able to gain a deeper insight into different data sets and organizational operations. Power BI can be a powerful tool for any organization and can help you transform data into powerful visuals and charts.
This course on Microsoft Power BI 365 Intermediate will build on your understanding of Power BI by explaining how to connect to various external datasets and modify and report on datasets. By the end of this course, you will have the skills you need to access and utilize data modeling techniques and advanced reporting features in Power BI.
What You'll Learn
- Connect to different external data sets including XML, JSON, Power BI datasets, R scripts, and Python scripts
- Modify columns, functions, and queries using the Advanced Editor, parameters, custom functions, and conditional columns
- Apply data modeling techniques such as many-to-many and bidirectional filters, aggregations, and security
- Build advanced reports using custom visuals, R visuals, Python visuals, and the Analytics Pane
- Use reporting features like conditional formatting, key influencers, decomposition tree, grouping and binning, and drill through
- Manage data with incremental refresh, query dependencies, and importing and exporting templates
Key Takeaways
- Power BI can connect to a range of external data sources, helping you extract useful information from different databases.
- Customizing queries and using advanced functions in Power BI lets you gain deeper insight into different data sets and organizational operations.
- Data modeling and reporting techniques can be used to create better reports and data models.
- Power BI can transform data into powerful visuals and charts for any organization.
- This intermediate course builds on prior Power BI understanding to cover connecting to, modifying, and reporting on datasets.
Frequently Asked Questions
Who is this course for?
This intermediate course builds on an existing understanding of Power BI, making it suited to learners who already know the basics and want to access and utilize data modeling techniques and advanced reporting features.
What will I be able to do by the end of the course?
By the end of the course, you will have the skills you need to access and utilize data modeling techniques and advanced reporting features in Power BI.
What data connections does the course cover?
The course covers connecting to external datasets including XML, JSON, a Power BI Dataset, an R Script, and a Python Script.
What advanced reporting features are taught?
Topics include custom visuals, R visuals, Python visuals, the Analytics Pane, conditional formatting, key influencers, the decomposition tree, grouping and binning, and drill through.
What skills are associated with this course?
Associated skills include Microsoft Business Intelligence, Microsoft Dynamics 365, Microsoft Power BI Embedded, Microsoft Power BI Report Server, Power BI, and SAS Business Intelligence (BI).
