Power BI 精通 - 从零到精通数据技能
Power BI Mastery - Zero to Hero Data Skills
- 1. Introduction to Power BI
- 1. Introduction to Power BI
- 2. Download and installation
- 1. Download and installation
- 3. Basic Charts in Power BI
- 1. Column chart
- 2. Stacked column chart
- 3. Pie chart
- 4. Donut chart
- 5. Funnel chart
- 6. Ribbon chart
- 4. How to Create a Map in Power BI
- 1. Simple Map
- 2. Filled map
- 3. Map with pie chart
- 4. Formatting in map
- 5. Background changes in map
- 5. Table & Matrix in Power BI
- 1. Creating a simple table
- 2. Formatting in table
- 3. Conditional formatting in table
- 4. Changing aggregation in table
- 5. Creating a matrix in power bi
- 6. Conditional formatting in matrix
- 7. Automatic hierarchy in matrix
- 8. Subtotal and grand total
- 9. Number formatting in table and matrix
- 6. Cards & Filters in Power BI
- 1. Number card
- 2. Text card
- 3. Date card
- 4. Multi-row card
- 5. Filter on visual
- 6. Filter on page
- 7. Filter on all pages
- 7. Slicers in Power BI
- 1. Slicer for text
- 2. Format text slicer
- 3. Slicer for Date
- 4. Format date slicer
- 5. Number slicer
- 8. Advanced Charts in Power BI
- 1. Clear-RecycleBin -Confirm false
- 2. Drill down donut chart
- 3. Word cloud
- 4. Sankey chart
- 5. Infographic
- 6. Play axis
- 7. Scroller
- 8. Sunburst
- 9. Histogram
- 9. Objects & Actions (Hyperlinks)
- 1. Insert object
- 2. Insert text
- 3. Insert shapes
- 4. Insert buttons
- 5. Action-web URL
- 6. Page navigation
- 7. Bookmark
- 10. ower BI Service Introduction
- 1. Creating a superstore report
- 2. Publish report to power bi service account
- 3. Export(PPT,PDF,PBIX)report and share
- 4. Create a dashboard in power bi service
- 5. Problem in power bi dashboard and its solution
- 11. Text Functions in Power Query
- 1. Merge
- 2. Split and trim
- 3. Upper,lower and proper
- 4. Add suffix and prefix
- 5. Left,right and mid
- 6. Extract text with delimiter
- 12. Date Functions in Power Query
- 1. Year,quarter,month,day
- 2. Difference between dates,earliest and latest
- 3. Name of day and name of month
- 4. Day of weekmonthyear & week of monthyear
- 5. Extract date from date and time
- 6. Calculate age in 2 button clicks
- 7. Which day of year,quarter,month your date of birth is
- 13. Number Functions in Power Query
- 1. Add,subtract,divide,multiply
- 2. Percentage,percent of,modulo
- 3. Rounding the numbers
- 4. IsEven,IsOdd and sign
- 14. Appending Files & Tables in Power BI
- 1. Append multiple csv files from a folder
- 2. Append multiple excel tablessheets from single file
- 3. Append excel tables with different numbers of columns
- 4. Append multiple excel files from a folder
- 5. Append different data source files in power query
- 15. HR Data Analytics Project parts 1
- 1. HR Data Analytics Project parts 1
- 16. HR Data Analytics Project parts 2
- 1. HR Data Analytics Project parts 2