Analyzing Data with Microsoft Power BI Video Course

DA-100: Analyzing Data with Microsoft Power BI

Your Microsoft DA-100 exam is just around the corner, right? So, it's high time to find an effective preparation tool! Our training course is what you really need! This is a series of videos led by the experienced IT instructors who will provide you with a detailed overview of the DA-100 certification test. Ace your Microsoft DA-100 at the first attempt and obtain the Analyzing Data with Microsoft Power BI credential with ease.

# of Students
103
# of Lectures
218
Course Length
23 h
Course Rating
5.0
Price $32.99
Today $29.99

Curriculum for DA-100 Video 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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  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
  Video Name Time
  1. ISERROR and LOOKUPVALUE 5:00
  2. Other functions 2:00
  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
  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
  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
  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
  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
  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
  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
  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
  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

5 Stars
4 Stars
3 Stars
2 Stars
1 Star
5.0
Rating: 5.0
Overall Rating: Good.

Similar Courses

Only Registered Members can View Training Courses

Please fill out your email address below in order to view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted by 1.2M IT Certification Candidates Every Month
  • Hundreds Hours of Videos
  • Instant download After Registration

Already Member? Click here to Login

A confirmation link will be sent to this email address to verify your login

1200+ IT Certification Exams available: Get a free sample of any exam right now!
Try Free Demo

Try Free Demo

  • ABA
  • ACAMS
  • ACFE
  • ACI
  • ACSM
  • Adobe
  • AHIMA
  • AHIP
  • AHLEI
  • AICPA
  • AIWMI
  • Alfresco
  • Alibaba
  • AMA
  • Amazon
  • AndroidATC
  • APBM
  • API
  • APICS
  • Apple
  • Arista
  • Aruba
  • ASIS
  • ASQ
  • Atlassian
  • Autodesk
  • Avaya
  • Axis Communications
  • BACB
  • BCS
  • BICSI
  • Blockchain
  • Blue Coat
  • Blue Prism
  • C++ Institute
  • CA Technologies
  • CertNexus
  • Checkpoint
  • CIMA
  • Cisco
  • Citrix
  • CIW
  • Cloudera
  • CNCF
  • CompTIA
  • CSA
  • CWNP
  • CyberArc
  • Dell
  • DMI
  • DSCI
  • EMC
  • Esri
  • Exin
  • Extreme Networks
  • F5
  • FileMaker
  • FINRA
  • Fortinet
  • GAQM
  • GARP
  • Genesys
  • GIAC
  • Google
  • Guidance Software
  • H3C
  • HashiCorp
  • HFMA
  • HIPAA
  • Hitachi
  • HP
  • HRCI
  • Huawei
  • IAPP
  • IBM
  • IFPUG
  • IIA
  • IIBA
  • Informatica
  • Isaca
  • iSAQB
  • ISC
  • iSQI
  • ISTQB
  • ITIL
  • Juniper
  • Lenovo
  • Linux Foundation
  • Logical Operations
  • LPI
  • Magento
  • Marketo
  • McAfee
  • Microsoft
  • Mulesoft
  • NACVA
  • NCMA
  • Network Appliance
  • NI
  • Nokia
  • Novell
  • Nuage Networks
  • Nutanix
  • OMG
  • Oracle
  • Palo Alto Networks
  • Pegasystems
  • PEOPLECERT
  • PMI
  • PRINCE2
  • Pulse Secure
  • Python Institute
  • QlikView
  • RedHat
  • Riverbed
  • RSA
  • Salesforce
  • SANS
  • SAP
  • SAS Institute
  • Scrum
  • SDI
  • ServiceNow
  • Six Sigma
  • Slack
  • SNIA
  • Snowflake
  • SOA
  • Software Certifications
  • SolarWinds
  • Splunk
  • SpringSource
  • Symantec
  • Teradata
  • Test Prep
  • The Open Group
  • Tibco
  • UiPath
  • Unity Certification
  • VCE
  • Veeam
  • Veritas
  • Vmedu
  • VMware
  • WatchGuard
  • WorldatWork
  • Zend
Next Step
Next Step

Try Free Demo

  • Microsoft
Next Step
Next Step

Get 10% Discount on Your Purchase When You Sign Up for Email

Passguide Products

Enter Your Email Address to Receive Your 10%
OFF
Discount Code Plus... Our Exclusive Weekly Deals

* We value your privacy. We will not rent or sell your email address