DA-100 - Analyzing Data with Microsoft Power BI Certification Video Training Course - CertBolt

Video Course
BEST SELLER

DA-100: Analyzing Data with Microsoft Power BI Certification Video Training Course

Looking for studying for DA-100: Analyzing Data with Microsoft Power BI certification training course. Our DA-100 certification video training course training course is your number one assistant. Pass with our DA-100: Analyzing Data with Microsoft Power BI certification training course on the first try and become a certified professional in no time.

  • 139 Students Enrolled
  • 218 Lectures
  • 23 Hours
  • 5.0 Rating
$27.49
$24.99

Curriculum For This Course

  • 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

Student Feedback

  1. 36%
  2. 63%
  3. 0%
  4. 0%
  5. 1%

Excellent Overall Rating

5.0

Add Comment

Rate Course *

Secure Code
Please enter security code exactly as shown

Log into your CertBolt Account

* Only Registered Members can Download Exam Questions & Answers

Create New CertBolt Account

or Login