Analyzing Data with Power BI (20778)
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 3 days
Objectives :
After completing this course, students will be able to:
Course Details :
Module 1 : Power BI Desktop Data Transformations
Requirements :
In addition to their professional experience, students who attend this training should already have the
following technical knowledge:
Cours disponible en français ou en anglais - Training available in French or in English
Duration: 3 days
Objectives :
After completing this course, students will be able to:
- Import data into Power BI
- Describe Power BI desktop modelling
- Create a Power BI desktop visualization
- Implement the Power BI service
- Describe how to connect to Excel data
- Describe how to collaborate with Power BI data
- Describe connectivity options using Power BI
- Describe the Power BI developer API
- Describe the Power BI mobile app
Course Details :
Module 1 : Power BI Desktop Data Transformations
- What is Power BI?
- Power BI data
- Transformations
- Import Data to Power BI
- Import data to Power BI desktop
- Import data from CSV files
- Import data from a less structured file
- Optimizing data models
- Calculations
- Hierarchies
- Manage Power BI data
- Manage table relationships
- Last year comparison
- Year to date
- Market share
- Optimize the data model
- Visualizing your data
- Working with multiple visualizations
- Create reports with visualizations
- Cross-tabular reports
- Part-to-Whole reports
- Relationship reports
- Trend reports
- Rank reports
- Working with the Power BI service
- Configuring a dashboard
- Viewing a Power BI Dashboard
- Implementing the Power BI service
- Upload a Power BI report
- Share a Power BI dashboard
- Configure data refresh
- Importing data from excel
- Analyzing data in Excel
- Working with Excel
- Uploading an Excel file with an Excel table
- Uploading an Excel file with a data model
- Collaboration
- Content packs
- Working with Organization Content Packs
- Create a content pack
- Edit a content pack
- Share a content pack
- Cloud data
- Connecting to analysis services
- Direct Connectivity
- Direct connectivity from Power BI desktop
- Direct connectivity from the Power BI service
- The developer API
- Custom visuals
- Using the developer API
- Using custom visuals
- The Power BI mobile app
- Using the Power BI mobile app
- Power BI embedded
Requirements :
In addition to their professional experience, students who attend this training should already have the
following technical knowledge:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
- Some exposure to basic programming concepts (such as looping and branching).
- An awareness of key business priorities such as revenue, profitability, and financial accounting is
- desirable.
- Familiarity with Microsoft Office applications – particularly Excel.