Power BI Top Skills (2022)
1h 1mIntermediate2022-02-17
Authors
John David Ariansen
Helping organizations understand and use data
Madecraft
Full-Service Learning Content Company
Course details
You don’t need to have a team dedicated to analytics to unlock key insights in your data. All you need is Microsoft Power BI, the user-friendly, data analytics tool that can change your workflow and streamline it anew. In this course, instructor John David Ariansen teaches you the essential skills you need to know to analyze data correctly and effectively with Power BI.
Learn about importing data, manipulating data, managing relationships, working with Data Analysis Expressions (DAX), and building visualizations and reports. Get tips and insights on how to get the most out of this powerful analytic tool. Upon completing this course, you’ll be ready to start using Power BI for all your business intelligence and reporting needs.
Learn about importing data, manipulating data, managing relationships, working with Data Analysis Expressions (DAX), and building visualizations and reports. Get tips and insights on how to get the most out of this powerful analytic tool. Upon completing this course, you’ll be ready to start using Power BI for all your business intelligence and reporting needs.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
Introduction
- Top skills for Power BI
Foundations of Power BI
- What is Power BI
- Connecting to multiple data sources
- Data modeling
- DAX
- Data visualization
- Download and install Power BI
- Interface introduction
Connecting to Data
- How to connect to data
- Query Editor
- Basic tables transformations
- Date transformations
- Aggregation
- Text transformations
Data Modeling
- What is a data model
- Database normalization
- Types of tables
- Cardinality
- Creating a data model
DAX
- Introduction to DAX
- Calculated columns
- Measures
Data Visualization
- Report view interface
- Bar chart
- Line graph
- Map
- Building dashboards
- Creating slicers
- Customizing the view
Next Steps
- Next steps