Advanced Microsoft Power BI
Data visualization allows you to represent information digitally and graphically, to convey the results of data analysis. Microsoft Power BI is a suite of business analytics tools that help you gain insights from your data. The suite brings together familiar operations from well-known products—including Excel, Access, Power Query, and Power Pivot—to help you quickly get move the basics and on to comprehensive analysis. In this course, Helen Wall guides you through the advanced capabilities of the service. She shows how to work with calculations, leverage the DAX language, create advanced queries, and use the M language to improve the querying process. She demonstrates how to import data from various sources, compose advanced formulas, manage the fields and columns in tables, use X-factor functions, use conditional statements, filter results, design charts, and more.
Topics include:
- Power BI Desktop vs. Pro vs. Tableau
- Importing data from files or from online
- Using Query Editor
- Joining tables and creating tables
- Formulating via DAX logic
- CALCULATE, ALL, FILTER
- POWER, DIVIDE, BLANK
- SUMX and COUNTX
- DATEDIFF, DATESBETWEEN, DATEADD
- MTD, QTD, and YTD
- Using X-factor functions
- Using quick measures and dynamic measures
- Using conditional statements
- Working with disconnected tables
- Designing charts and visualizations
Không có trích dẫn