Microsoft Introduction to Power BI
This Introduction level Microsoft Power BI Training course will give you all the skills you need to jump-start your Power BI journey.
Förkunskaper
There are no prerequisites for attending this course. However, it is recommended that participants have basic knowledge of Excel and data analysis.
Utbildningsmål
It discusses in depth the industry-recognised steps from raw data to detailed analysis via five main stages:
Throughout the course, you will access data from a wide range of data sources and create Reports using the in-built visuals. You will also be shown how to format those visuals for maximum effect and how to import custom visuals to extend your reporting capability. You will gain an introduction to the M and DAX languages and then publish your masterpiece to a workspace in the Power BI Service, creating Dashboards, sharing Reports and Dashboards with colleagues, and concluding with scheduling a data refresh.
Kursfakta
Typ | Öppen |
---|---|
Längd | 3 dagar |
Ditt pris | 19 530 kr exkl. moms |
Klippkort | Ja |
Planerad |
1 orter 1 tillfällen |
- Loading data into Power BI from a wide range of data sources, such as CSV and XLS files
- Transforming data using Data Analysis Expressions (DAX), M, and Power Query languages
- Creating and extending a comprehensive data model with DAX
- Visualising data in Power BI desktop using built-in tools
- Sharing and collaborating with the Power BI service or Power BI server
- Create interactive visualisations to deliver business insights
- Extract business intelligence by using DAX, M and Power Query
- Share Datasets, Reports and Dashboards in the Power BI Service
- Pre-format and import data from an Excel Report using Power Query and M
- Add value with measures, calculated columns and calculated tables using DAX
- Import data from relational databases and integrate with other data sources
- Profile, shape and filter tables to prepare for analyses by fixing data issues
- Integrate data from csv files and Excel Workbooks
- Explore and extend a Power BI data model
Innehåll
Module 1: Power BI Overview
- Visual analysis and visual analytics
- Power BI Infrastructure
- Loading Data
- Introduction to Power BI Desktop
Module 2: Transforming Data
- Using Power Query to clean, transform and load data
- Profiling your data
- Resolve data quality issues
- Apply user-friendly names to Queries, tables, and columns
- Import data from an Excel formatted report
Module 3: Creating a Data Model
- Understand the role of the Data Model in Power BI
- Create table relationships
- Understand Cardinality and Cross Filtering
- Discuss Star and Snowflake schema
- Create a Date Dimension
- Build a Data Model from multiple Data sources
Module 4: Visualizing your Data
- Discuss Report settings
- Choosing the right visualisations
- Creating, formatting, and styling your reports
- Using Hierarchies and Drilldown
- Utilising Slicers and Filters
- Adding Custom Visualisations
Module 5: Introduction to DAX, Calculated Columns and Measures
- Gain an Introduction to DAX
- Differentiate between Calculated Columns and Measures
- Create Calculated Columns
- Create Measures
- Understand Filter and Row context
- Understand the power of the Calculate function
Module 6: Collaboration and Sharing (Publishing Reports and Creating Dashboards)
- Discuss the Power BI Service and Power BI Server
- Understand the main components of the Power BI Service
- Publish a Power BI Project to the Power BI Service
- Share Reports
- Build and Share Dashboards
Kursen levereras genom utbildningspartner : Learning Tree