Curriculum For This Course
Video tutorials list
-
Level 1: Creating and formatting a table visualization
Video Name Time 1. Welcome to Part 1: Visualizations 3:00 2. 1b. Importing from Excel, and Creating our first visualization 5:00 3. Viewing data 6:00 4. Focus mode and Different visualizations 3:00 5. Why do I need a Work email address? And how can I get one, if I don't have it? 7:00 6. 10b. Saving visualization to the Desktop and to the Power BI service 5:00 7. Practice Activity Number 1 - The Solution 7:00 -
Level 2: Formatting our first visualization
Video Name Time 1. Formatting font and font size 5:00 2. Formatting colors 5:00 3. Stylistic options 7:00 4. 8g. Position visuals 6:00 5. 8g. Align visuals 5:00 6. 8f. Configuring summarization, both default and in a specific visualization 10:00 7. 8i. Changing number and date formatting 7:00 8. Practice Activity Number 2 - The Solution 8:00 -
Level 3: 8a. Creating different visualizations: Matrices and bar charts
Video Name Time 1. Matrix 7:00 2. Drill down data, see data and records, and export data 8:00 3. Stacked bar charts and 8j. switch theme for reports 7:00 4. Bar Chart formatting 5:00 5. 8c. Configure interactions between visual (Edit interactions) 9:00 6. Clustered and 100% Stacked bar charts 6:00 7. Line and area charts, including 8b. Configure duplicate pages 5:00 8. Combo charts (Line and column charts) 6:00 9. Practice Activity Number 3 - The Solution 8:00 -
Level 4: Adding more control to your visualizations
Video Name Time 1. 11a. Adding Text boxes, Images and Shapes 7:00 2. 11b. Visual level, page level and report level filters - basic filters 7:00 3. Advanced Filtering 11:00 4. Filter Top N Items 5:00 5. Slicer 11:00 6. Slicer Warning 3:00 7. 8g. Sort visuals 7:00 8. 8j. Use Bookmarks for reports 6:00 9. Drillthrough 11:00 10. Buttons and Actions 14:00 11. 11e. Enable Natural Language Queries (Ask A Question) 8:00 12. Tooltip Pages 9:00 13. Practice Activity Number 4 - The Solution 11:00 -
Level 5: 8a. Other visualizations
Video Name Time 1. Ribbon charts 6:00 2. Waterfall charts 8:00 3. Scatter, bubble and dot charts 10:00 4. Pie charts and donut charts 4:00 5. Treemaps 2:00 6. Funnel charts 3:00 7. Adding Marketplace visualizations (Import a Custom Visual) 3:00 8. Practice Activity Number 5 - The Solution 7:00 -
Level 6: Mapping
Video Name Time 1. Maps 8:00 2. Formatting maps 5:00 3. 8g. Adding Data Categories 7:00 4. Filled Maps,Conditional Formatting, and color blindness 10:00 5. Creating hierarchies 7:00 6. ArcGIS Maps for Power BI 12:00 7. Practice Activity Number 6 - The Solution 12:00 -
Level 7: 6. Measure performance by using KPIs, gauges and…Section 8: Level 7: 6. Measure performance by using KPIs, gauges and cards
Video Name Time 1. Gauges 6:00 2. Cards and Multi-row cards 5:00 3. More conditional formatting 8:00 4. KPIs 4:00 5. Practice Activity Number 7 - The Solution 16:00 -
Part 1 Level 8: Other Visualization Items for the DA-100 exam
Video Name Time 1. Define quick measures 7:00 2. Export report data 4:00 3. Create reference lines by using Analytics pane 10:00 4. Design and configure for accessibility 6:00 5. Identify outliers 3:00 6. Use groupings and binnings 7:00 7. Use the Key Influencers to explore dimensional variances 9:00 8. Use the decomposition tree visual to break down a measure 6:00 9. R and Python Visualizations 4:00 10. End of Part 1 1:00 -
Part 2 Get and Transform Data: Level 1 - Home Part 1
Video Name Time 1. Welcome to Part 2: Get and Transform Data 2:00 2. Introduction - let's Get some more Data 5:00 3. Exploring the Power Query Editor interface 9:00 4. Introducing the M language 9:00 5. Let's start look at the Home tab 4:00 6. Home menu - Manage Columns 6:00 7. Home menu - Reduce Rows and Use First Row as Headers 7:00 8. Practice Activity Number 8 - The Solution 7:00 -
Part 2 Level 1 - Get Data - Home
Video Name Time 1. Sort and Filter 6:00 2. Split Column 7:00 3. Other Transform activities 10:00 4. Practice Activity Number 9 1:00 -
Part 2 Level 2 - Getting Multiple files
Video Name Time 1. Merge Queries and Expand Table 6:00 2. Merge Queries with Group By, and different types of Joins 7:00 3. Appending two queries together 5:00 4. Appending three or more queries together + resolving a problem with data types 7:00 5. Combine Files (getting information from a folder) 9:00 6. Practice Activity Number 10 - The Solution 16:00 -
Part 2 Level 3 - Transform Menu
Video Name Time 1. Transform - Table and Any Column 5:00 2. Pivot Column 10:00 3. Unpivot 11:00 4. Practice Activity 11 - The Solution 7:00 5. Unpivot in conjunction with other Transform features 10:00 6. Practice Activity 12 - The Solution 6:00 -
Part 2 Level 4 - Transform - Text and Numbers
Video Name Time 1. Transform/Add Column - Text - Format 6:00 2. Transform/Add Column - Text - Merge Columns 8:00 3. Transform/Add Column - Text - Extract 7:00 4. Transform/Add Column - Text - Parse 11:00 5. Transform/Add Column - Number Column - Statistics and Standard 6:00 6. Transform/Add Column - Other Number Column functions 5:00 7. Practice Activity Number 13 - The Solution 13:00 -
Part 2 Level 5 - Transform - Dates and Time
Video Name Time 1. Creating a list of dates 8:00 2. Transform/Add Column - Date 9:00 3. Transform/Add Column - Dates in other cultures/languages 9:00 4. Transform/Add Column - Time 6:00 5. Transform/Add column - Duration 3:00 6. Practice Activity Number 14 - The Solution 7:00 -
Part 2 Level 6- Add Columns, View and Help Menus
Video Name Time 1. Column from examples 13:00 2. Conditional Column 10:00 3. Resolving Errors from Conditional Columns 4:00 4. Index Column and Duplicate Column 4:00 5. Custom Column - If Then Else 9:00 6. Practice Activity Number 15 - The Solution 10:00 -
Part 2 Level 7 - View and Help menus and advanced functionality
Video Name Time 1. Other M Functions 6:00 2. View and Help menus, including Column Properties 5:00 3. Profile the data 2:00 4. Advanced Editor 4:00 5. Functions and Parameters 12:00 6. DateTimeZone date type and Functions 5:00 7. Worked Practice Activity 16 - Dividing Annual data into Months 11:00 -
Part 2 Level 8 - Get other types of data
Video Name Time 1. Introduction to SQL Server 6:00 2. Importing database data into Power BI, and Query Folding 6:00 3. Select a storage mode 5:00 4. Expanding multiple tables in SQL Server 7:00 5. Importing data from SQL Server Analysis Services (SSAS) 6:00 6. Setting up Azure SQL Database 7:00 7. Using Azure SQL Database in Power BI 6:00 8. Using Big Data 6:00 9. Use the Common Data Service (CDS) 3:00 -
Part 2 Level 9 - Other Get and Transform Topics for the DA-100 exam
Video Name Time 1. Resolve problems 5:00 2. Configure data loading 4:00 3. Identify query performance issues 5:00 4. Apply AI Insights 5:00 5. End of Part 2 2:00 -
Part 3 Level 1 - An introduction to DAX functions, includin…Section 20: Part 3 Level 1 - An introduction to DAX functions, including Logical functions
Video Name Time 1. Welcome to Part 3 - Modeling and DAX functions 2:00 2. Get multiple data sets, and connecting them together 7:00 3. The problems with direction of relationships between data sets 11:00 4. DAX functions - A useful Resource 2:00 5. Calculated columns - an introduction 4:00 6. Basic operators 5:00 7. IF, BLANK and ISBLANK 9:00 8. AND, OR and NOT 4:00 9. SWITCH 4:00 10. Other functions 3:00 -
Part 3 Level 2 - Statistical functions
Video Name Time 1. Measures - an introduction, with standard aggregations including Countblank 9:00 2. Aggregation of calculations 6:00 3. Other statistical functions 6:00 -
Part 3 Level 3 - Mathematical functions
Video Name Time 1. Rounding functions 8:00 2. Division functions - MOD and QUOTIENT 3:00 3. SIGN (and use with SWITCH) and ABS 6:00 4. Exponential functions 3:00 5. Other functions 3:00 -
Part 3 Level 4 - Text functions
Video Name Time 1. Text searching 8:00 2. Text extraction and substitution 7:00 3. Text conversion 8:00 4. Other functions 2:00 -
Part 3 Level 5 - Information Functions
Video Name Time 1. ISERROR and LOOKUPVALUE 5:00 2. Other functions 2:00 -
Part 3 Level 6 - Filter and Value Functions
Video Name Time 1. RELATED 5:00 2. RELATEDTABLE and COUNTROWS 7:00 3. Context 4:00 4. ALL 6:00 5. FILTER 3:00 6. CALCULATE 3:00 7. ALLEXCEPT 6:00 8. ALLSELECTED 9:00 9. Other functions 2:00 -
Part 3 Level 7 - Time Intelligence Functions
Video Name Time 1. Date and Time Functions 3:00 2. FIRSTDATE, LASTDATE 3:00 3. Start of... and End of... 6:00 4. Previous... and Next... 6:00 5. DATESINPERIOD 4:00 6. DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD 3:00 7. Opening Balance and Closing Balance 2:00 8. Semi-additive Measures 3:00 9. SAMEPERIODLASTYEAR and PARALLELPERIOD 3:00 10. Other Time Intelligence Functions 2:00 -
Part 3 Level 8 - Other Modeling and DAX Topics for the DA-1…Section 27: Part 3 Level 8 - Other Modeling and DAX Topics for the DA-100 exam
Video Name Time 1. Create calculated tables 6:00 2. Create a common date table 7:00 3. Define role-playing dimensions 7:00 4. Resolve many-to-many relationships - Joint Bank Accounts 6:00 5. Resolve many-to-many relationships - Different types of granularity 6:00 6. Improve cardinality levels through summarization and by changing data types 9:00 7. Identify poorly performing measures, relationships, and visuals 6:00 8. End of Part 3 1:00 -
Part 4 Section 1 - An Introduction to the Power BI Service
Video Name Time 1. Welcome to Part 4: The Power BI Service 2:00 2. Introducing The Power BI Service 4:00 3. Logging into Power BI Service and a quick look around 5:00 4. Power BI Terminology 11:00 5. Datasets and Reports in the Power BI Service 10:00 6. Get Data - Other People's Data 5:00 7. Get Data - Your Data 12:00 8. The Navigation Pane, including Add a Quick Insights result to a report 8:00 -
Part 4 Section 2 - Power BI Pro and adding users
Video Name Time 1. Signing up for Power BI Pro 6:00 2. Adding new users 8:00 3. Creating a new report 8:00 4. Sharing my new report 5:00 -
Part 4 Section 3 - Row Level Security
Video Name Time 1. Adding role-based Row Level Security 8:00 2. Adding Dynamic Row Level Security 10:00 3. Testing Dynamic Row Level Security in the Power BI Service 7:00 -
Part 4 Section 4 - Dashboards
Video Name Time 1. Differences between dashboards and reports 5:00 2. Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options 5:00 3. Dashboards: Options 4:00 4. Pin a Live Report Page to a Dashboard 4:00 5. Use the Q&A Feature 3:00 6. Add a Dashboard Theme 6:00 7. Dashboard Data Classifications 5:00 8. Configure Data Alerts 5:00 -
Part 4 Section 5 - Manage datasets
Video Name Time 1. Analyze in Excel 6:00 2. Promote or Certify (Endorse) a Dataset 6:00 3. Manually Refreshing data in the Power BI Service 4:00 4. Data Gateways; Providing Access to Datasets 10:00 5. Configure a Dataset Scheduled Refresh 7:00 6. Configure Incremental Refresh Settings - Step 1 7:00 7. Configure Incremental Refresh Settings - Step 2 8:00 -
Part 4 Section 6 - Create and manage workspaces
Video Name Time 1. Create and Configure a Workspace 5:00 2. Assign Workspace Roles 5:00 3. Providing Access to Datasets 5:00 4. Configure and Update a Workspace App 13:00 5. Publish, Import or Update Assets in a Workspace - Publish securely 6:00 6. Publish reports on the web, so the public can see 7:00
Add Comment