Enrolment options
- Enrolled students: 3
Guests cannot access this course. Please log in.
Course content
Sections:
15
•
Activities:
0
•
Resources:
148
- 001-Motivation About this course
- 002-Tips to get the most out of the course
- 004-Understanding Power BI
- 005-Download Install
- 007-Get excited Challenge
- 008-The 3 Views in Power BI
- 010-Important Initial Settings
- 011-Our project getting data
- 012-Query Editor Basic data cleaning
- 013-Working with the attached project files
- 015-Edit rows columns
- 016-Data Types
- 017-Replacing values
- 019-Summary of today
- 021-Goals Day 2
- 022-Exctracting values
- 023-Split columns
- 024-Text operations
- 025-Numerical operations
- 026-Creating relationships data model
- 029-Solution Data Cleaning Relationship
- 030-Stacked column chart
- 031-The Format tab
- 032-Pie Chart Guidelines
- 033-Pie chart
- 035-Goals Day 3
- 036-Append Queries
- 038-Merge Group
- 039-Dates Hierarchies
- 040-Line Chart
- 042-Files from folder
- 043-Fact Dimension model
- 045-Edit relationships cardinality
- 046-Activate deactivate relationships
- 047-Manage autodetect relationships
- 049-Goals Day 4
- 050-Tables
- 051-Customizing tables
- 052-Conditional formatting
- 054-Merging Queries
- 055-Unpivot Pivot
- 056-Many to Many Relationship
- 057-Filter Visual
- 058-Edit page
- 060-Goals Day 5
- 061-Filters Pane-
- 062-TopN Filter
- 063-Sync Slicers
- 064-Treemap Visuals
- 065-Edit interactions
- 066-Drillthroughs
- 067-Keep filters with drillthroughs
- 068-Tooltips
- 070-Custom column
- 071-Enable Disable Load
- 072-References vs Duplicates
- 073-Columns from example
- 075-Goals Day 6
- 076-Visual Header Sorting
- 077-Conditional column
- 078-Maps
- 079-Filled Maps
- 080-Forecasts
- 081-Drillthrough with Button
- 082-Bookmarks
- 083-Challenge Top Products
- 084-Cards
- 085-Multi Row Cards
- 087-Goals Day 7
- 088-Tooltips Page
- 089-Working with templates
- 090-Visualizing using R scripts
- 092-Libraries Get data using R
- 093-Working with R to transform data
- 094-Working with parameters
- 096-Goals Day 8
- 097-Parameters with lists queries
- 098-Get data from a web page
- 099-Use parameters with web page
- 100-Challenge Solution
- 101-Invoking a custom function
- 103-Goals Day 9
- 104-Understanding Calculated Columns
- 105-Understanding Measures
- 106-AVERAGE
- 107-COUNT DISTINCTCOUNT COUNTROWS
- 108-SUMX
- 109-AVERAGEX ROUND
- 110-RELATED Data Model
- 111-CALCULATE
- 112-Filter problems
- 113-FILTER-
- 114-Logical operators
- 115-Formatting Commenting
- 118-Goals Day 10
- 119-ALL
- 120-ALL on columns
- 121-ALLEXCEPT
- 122-ALLSELECTED
- 123-DATEADD
- 124-Year to Date Month to Date
- 125-ROUNDING functions
- 126-FORMAT
- 130-Goals Day 11
- 131-How to go on from here
- 132-Power BI Pro vs Free vs Premium
- 133-Sign up for free
- 134-Alternative method without work mail
- 135-Quick Interface Tour
- 136-My workspace
- 137-Publishing reports
- 138-Editing reports
- 139-Updating reports with Power BI Desktop
- 140-Creating Exploring Workspaces
- 142-Goals Day 12
- 143-Installing using a Data Gateway
- 144-Scheduled refresh
- 145-Creating apps
- 146-Creating Dashboards
- 147-Get Quick Insights
- 148-Using Mobile App
- 149-Creating Mobile Layout
- 151-Goals for Day 13
- 152-Basic Row Level Security
- 153-Row Level Security in the clou
- 154-Data Model Row Level Security
- 155-Dynamic RLS
- 156-Many to Many RLS
- 157-Page Level Security
- 158-Goals for Day 14
- 159-Plan of action
- 160-Setting up Python for Power BI
- 161-Transforming data using Python-
- 163-Creating visualizations using Python
- 165-Violin plots pair plots ridge plots using Python-
- 167-Machine learning BayesTextAnalyzer using Python
- 168-Performance Troubleshooting
- 169-Loading data from web in JSON
- 170-Setting up a MySQL database
- 171-Loading data from SQL database
- 172-Goals for Day 15
- 173-What is the M language
- 174-Basics about the advanced editor
- 175-Values Lists
- 176-Table functions transforming columns
- 178-Each Table AddColumns
- 180-More functions Next steps
- 181-You made it