Power BI Top Skills

Description

In this course, you will learn:

• Power BI is a powerful data analytics tool that is streamlining the way business works with data
• the essential skills you need to analyze data effectively with Power BI. Explore the difference between Power BI Desktop and the Power BI service
• key skills, such as importing data, manipulating data, managing relationships, working with Data Analysis Expressions (DAX), and building visualizations and reports

Syllabus:

• Introduction
• Top skills for Power BI
   

1. Foundations of Power BI

• What is Power BI?
• Connecting to multiple data sources
• Data modeling
• Data Analysis Expressions (DAX)
• Data visualization
• Download and install Power BI
• Interface introduction
   

2. Connecting to Data

• How to connect to data
• Query Editor
• Basic table transformations
• Date transformations
• Aggregation
• Text transformations
   

3. Data Modeling

• What is a data model?
• Database normalization
• Types of tables
• Cardinality
• Creating a data model
   

4. DAX

• Introduction to DAX
• Calculated columns
• Measures
   

5. Data Visualization

• Report view interface
• Bar chart
• Line graph
• Map
• Building dashboards
• Creating slicers
• Customizing the view