Microsoft Power BI Desktop allows users to be completely autonomous at every stage of creation in their analysis and dashboards, from the recovery and consolidation of multiple data sources to the definition of business models and calculations.
Prerequisite : Very good mastery of Excel.
Content
Whose address is Power BI Desktop?
- What is Power BI Desktop?
- Power BI components
- To each his Power BI
- Install Power BI
Connect to data with or without the assistant
- Data files: Excel, .csv, .txt, etc.
- Database : Access, SQL, Oracle
- Online service : Liste SharePoint online
- Other: Web, Microsoft Exchange, OData feed, etc.
Power BI Desktop presentation
- Discover the Power BI interface
- Query editor
- The View « Report »
- The View « Data »
- The View « Relations »
Transform your data into the query editor
- Formatting requests
- Aggregating data
- Combine multiple queries
- Manage requests
- Set the level of confidentiality
- Load data
Managing relationships
- Reminder and definition of relationships
- Create a relationship
- Cardinality and join
- Edit Relationship
- Hide table in Report view
Data View
- Add a calculated column
- Create a new measure
- Create a hierarchy
- Create a new table
- Introduction to DAX
- Functions Relationship
- Text functions
- Functions Date
- Functions Filter
- Context (line, filter)
- Group concept
- Role management
View of « Reports » or how to create dynamic relationships?
- Create matrices, tables, segments
- Create Key Performance Indicators (KPI)
- Apply conditional formatting on data
- Create reports as graphs
Publish and Share
- Save data in format. Pbix
- Export to the Power BI Model
- Presentation of the various means of publication
- Publish in BI Service
- Publish in SharePoint Online
Jurisdiction
- Connect to multiple source data of different types
- Transform, reorganize data
- Building relationships
- Build dynamic dashboards and graphs
- Publish and share results
Price: EUR 1500
Duration 2 days
Inscription contact@ sogesti.fr
