Who Should Attend?
Business Analyst, Data Analysts, Data Scientist, or professionals responsible for reporting on your organization’s data.
Prerequisites
Before attending this course, you should have:
- A general knowledge of database concepts (fields, records, relationships)
- Awareness of key business priorities such as revenue, profitability, and
financial accounting - Comfort when using Excel
Course Outline
1. Introduction to business intelligence
2. Introduction to data analysis
3. Introduction to data visualization
4. Creating a Power BI report
5. Connecting to Power BI data
6. Create a Power BI dashboard
7. Using Excel as a data source for Power BI
8. The Power BI data model
9. The Power BI service
10.Importing Excel files into Power BI
11.Power BI desktop queries
12.Combining data
13.Shape Power BI data
14.Combine Power BI data
15.Calculations and measures
16.What is DAX (Overview)
17.Creating Calculated Columns (Basics)
18.Navigation Functions
19.Conditional and Logical Functions
20.Creating Calculated Measures
21.Time Intelligence (Overview)
22.Table Functions
23.DAX as a Query Language
24.Create relationships
25.Calculations
26.Managing Power BI web
27.Creating dashboards via web
28.Creating Interactive Reports
29.Using Power BI Service
30.Refreshing the Data
31.Designing Reports and Dashboards for Mobile
