Enjoying the preview?
This is the free first lesson. Get full access — request a demo or sign in.
Microsoft Power BI 365 Advanced
Using advanced techniques to connect, modify and visualize dataPreview the first lesson free — get full access to all 25 lessons.
Advanced Provider : Elizabeth Vergara 5 chapters · 25 Lessons · 1h 30m in Arabic, German, English, Spanish, French, Portuguese, Chinese
Course Description
Power BI is an interactive data visualization software developed by Microsoft. It is used for seeing the big picture when it comes to business intelligence and enabling users and business leaders to make better business decisions. Microsoft Power BI provides users with a powerful suite of tools to connect, transform, model, and interactively visualize and share data. This course is for designed for intermediate to advanced users of the software.
In this advanced Power BI course, users will have the ability to utilize advanced features and techniques to concatenate, configure and classify data. You’ll will learn to connect, model, visualize, and share data within the program's software. Using data source files, you will learn to automate the data connection process and specify privacy levels for data sources. You will also learn various techniques for modeling data, such as performing query diagnostics, working with Data Analysis Expression (DAX) functions, operators and variables, as well as writing and formatting DAX queries. By the end of the course, you will also have a better understanding for including/excluding data points, customizing themes, working with maps, relative data filtering and more.
What You'll Learn
- Automate the data connection process using data source files and export PBIDS and Power BI Desktop files
- Specify privacy levels for data sources to control how data is combined
- Perform query diagnostics and apply techniques for modeling data
- Write, evaluate, and format DAX queries using functions, operators, and variables
- Customize the current theme and work with maps, clustering, and smart narratives
- Apply relative date filtering, automatic page refresh, grouping visualizations, and What If parameters
Key Takeaways
- Power BI is an interactive data visualization software developed by Microsoft used for business intelligence and to help users and business leaders make better business decisions.
- This course is designed for intermediate to advanced users and covers advanced features to concatenate, configure, and classify data.
- Learners use data source files to automate the data connection process and specify privacy levels for data sources.
- The course covers Data Analysis Expression (DAX) functions, operators, and variables, along with writing and formatting DAX queries.
- Additional topics include including or excluding data points, customizing themes, working with maps, and relative data filtering.
Frequently Asked Questions
Who is this Power BI course designed for?
It is designed for intermediate to advanced users of the software who want to utilize advanced features and techniques to concatenate, configure, and classify data.
What is Power BI used for?
Power BI is an interactive data visualization software developed by Microsoft, used for seeing the big picture in business intelligence and enabling users and business leaders to make better business decisions. It provides tools to connect, transform, model, and interactively visualize and share data.
What DAX topics does the course cover?
The course covers DAX functions, operators, and variables, evaluating DAX in DAX Studio or SSMS, defining DAX statements, DMV queries, and writing and formatting DAX queries.
What visualization and modeling skills will I gain?
You will learn techniques for modeling data such as query diagnostics, plus customizing themes, working with maps, clustering, smart narratives, including or excluding data points, relative date filtering, automatic page refresh, grouping visualizations, and What If parameters.
What skills are associated with this course?
The course covers Business Intelligence Tools, Microsoft Business Intelligence, Microsoft Power BI Embedded, Microsoft Power BI Report Server, Microsoft Power Platform, and Power BI.
