About this training
The training will help you get acquainted with Power BI, provide basic DAX and Power Query skills, as well as improve your knowledge in structuring and processing data.
Duration and format
2 work days. Offline.
Intended for
Analysists, accountants, C-level professionals.
Contents
- basic information about Power BI: Power BI Desktop, Power BI Service, Power BI Mobile.
- overview of data sources: Excel, 1C (Odata channel), Microsoft Dynamics NAV (as SQL data base), Internet
- structuring and processing data using Power Query
- Overview of the types of relationships between data
- Working with data using DAX: building a calendar, creating calculated columns, working with measures
- Making visual elements: slices, matrix, pie chart, ring chart, histogram with grouping, tree chart, map, KPI, graph.
- Designing visual elements. For example, setting colors, fonts, sizes, grouping elements
- Microsoft Power BI cloud overview
- Q&A, recommendations
Results
You will be able to prepare reports by yourself using Power BI functionality.
