DA-100: Analyzing Data with Microsoft Power BI

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.

$24.99 $32.49

Curriculum For This Course

7 lectures 36m
  • 1. Welcome to Part 1: Visualizations
    3m
  • 2. 1b
    5m
  • 3. Viewing data
    6m
  • 4. Focus mode and Different visualizations
    3m
  • 5. Why do I need a Work email address? And how can I get one, if I don't have it?
    7m
  • 6. 10b
    5m
  • 7. Practice Activity Number 1 - The Solution
    7m

7 lectures 48m
  • 1. Formatting font and font size
    5m
  • 2. Formatting colors
    5m
  • 3. Stylistic options
    7m
  • 4. 8g
    6m
  • 6. 8f
    10m
  • 7. 8i
    7m
  • 8. Practice Activity Number 2 - The Solution
    8m

9 lectures 1h 1m
  • 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

13 lectures 1h 50m
  • 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

8 lectures 43m
  • 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

7 lectures 1h 1m
  • 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

5 lectures 39m
  • 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

10 lectures 57m
  • 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

8 lectures 49m
  • 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

4 lectures 24m
  • 1. Sort and Filter
    6m
  • 2. Split Column
    7m
  • 3. Other Transform activities
    10m
  • 4. Practice Activity Number 9
    1m

6 lectures 50m
  • 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

6 lectures 49m
  • 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

7 lectures 56m
  • 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

6 lectures 42m
  • 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

6 lectures 50m
  • 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

7 lectures 45m
  • 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

9 lectures 52m
  • 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

5 lectures 21m
  • 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

10 lectures 51m
  • 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

3 lectures 21m
  • 1. Measures - an introduction, with standard aggregations including Countblank
    9m
  • 2. Aggregation of calculations
    6m
  • 3. Other statistical functions
    6m

5 lectures 23m
  • 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

4 lectures 25m
  • 1. Text searching
    8m
  • 2. Text extraction and substitution
    7m
  • 3. Text conversion
    8m
  • 4. Other functions
    2m

2 lectures 7m
  • 1. ISERROR and LOOKUPVALUE
    5m
  • 2. Other functions
    2m

9 lectures 45m
  • 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

10 lectures 35m
  • 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

8 lectures 48m
  • 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

8 lectures 57m
  • 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

4 lectures 27m
  • 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

3 lectures 25m
  • 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

8 lectures 37m
  • 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

7 lectures 48m
  • 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

6 lectures 41m
  • 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
Hot Exams

Free Test Engine Player

How to open .dumpsarena Files

Use FREE DumpsArena Test Engine player to open .dumpsarena files

Our test engine player will always be free.

DumpsArena Test Engine

Windows
Satisfaction Guaranteed

98.4% DumpsArena users pass

Our team is dedicated to delivering top-quality exam practice questions. We proudly offer a hassle-free satisfaction guarantee.

Why choose DumpsArena?

23,812+

Satisfied Customers Since 2018

  • Always Up-to-Date
  • Accurate and Verified
  • Free Regular Updates
  • 24/7 Customer Support
  • Instant Access to Downloads
Secure Experience

Guaranteed safe checkout.

At DumpsArena, your shopping security is our priority. We utilize high-security SSL encryption, ensuring that every purchase is 100% secure.

SECURED CHECKOUT
Need Help?

Feel free to contact us anytime!

Contact Support