Exclusive SALE Offer Today

DA-100: Analyzing Data with Microsoft Power BI

Best Seller 217 Lectures 23h 3m
Prepare for your Microsoft examination with our training course. The DA-100 course contains a complete batch of videos that will provide you with profound and thorough knowledge related to Microsoft certification exam. Pass the Microsoft DA-100 test with flying colors.
$12.99$35.99
Curriculum For This Course

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