Hoofdstukken
Les 1 Creating and formatting a table visualization
- 1.1 Welcome to part 1 visualisation
- 1.2 Importing from Excel, and Creating our first visualization
- 1.3 Viewing data
- 1.4 Focus mode and Different visualizations
- 1.5 Why do I need a Work email address And how can I get one, if I don't have it
- 1.6 Saving visualization to the Desktop and to the Power BI service
- 1.7 Practice Activity Number 1 - The Solution
Les 3 Creating different visualizations Matrices and bar charts
- 3.1 Matrix
- 3.2 Drill down data, see data and records, and export data
- 3.3 Stacked bar charts and switch theme for reports
- 3.4 Bar Chart formatting
- 3.5 Configure interactions between visual (Edit interactions)
- 3.6 Clustered and 100% Stacked bar charts
- 3.7 Line and area charts, including Configure duplicate pages
- 3.8.Combo charts (Line and column charts)
- 3.9 Practice Activity Number 3 - The Solution
Les 4 Adding more control to your visualizations
- 4.1 Adding Text boxes, Images and Shapes
- 4.2 Visual level, page level and report level filters - basic filters
- 4.3 Advanced Filtering
- 4.4 Filter Top N Items
- 4.5 Slicer
- 4.6 Slicer Warning
- 4.7 Sort visuals
- 4.8 Use Bookmarks for reports
- 4.9 Drillthrough
- 4.10 Buttons and Actions
- 4.11 Enable Natural Language Queries (Ask A Question)
- 4.12 Tooltip Pages
- 4.13 Practice Activity Number 4 - The Solution
Les 8 Other Visualization Items for the DA-100 exam
- 8.1 Define quick measures
- 8.2 Export report data
- 8.3 Create reference lines by using Analytics pane
- 8.4 Design and configure for accessibility
- 8.5 Identify outliers
- 8.6 Use groupings and binnings
- 8.7 Use the Key Influencers to explore dimensional variances
- 8.8 Use the decomposition tree visual to break down a measure
- 8.9 R and Python Visualizations
- 8.10 End of part 1
Les 9 Get and Transform Data
- 9.1 Welcome to Part 2 Get and Transform Data
- 9.2 Introduction - let's Get some more Data
- 9.3 Exploring the Power Query Editor interface
- 9.4 Introducing the M language
- 9.5 Let's start look at the Home tab
- 9.6 Home menu - Manage Columns
- 9.7 Home menu - Reduce Rows and Use First Row as Headers
- 9.8 Practice Activity Number 8 - The Solution
Les 11 Getting Multiple files
- 11.1 Merge Queries and Expand Table
- 11.2 Merge Queries with Group By, and different types of Joins
- 11.3 Appending two queries together
- 11.4 Appending three or more queries together + resolving a problem with data types
- 11.5 Combine Files (getting information from a folder)
- 11.6 Practice Activity Number 10 - The Solution
Les 13 Transform - Text and Numbers
- 13.1 Transform Add Column - Text - Format
- 13.2 Transform Add Column - Text - Merge Columns
- 13.3 Transform Add Column - Text - Extract
- 13.4 Transform Add Column - Text - Parse
- 13.5 Transform Add Column - Number Column - Statistics and Standard
- 13.6 Transform Add Column - Other Number Column functions
- 13.7 Practice Activity Number 13 - The Solution
Les 17 Get other types of data
- 17.1 Introduction to SQL Server
- 17.2 Importing database data into Power BI, and Query Folding
- 17.3 Select a storage mode
- 17.4 Expanding multiple tables in SQL Server
- 17.5 Importing data from SQL Server Analysis Services (SSAS)
- 17.6 Setting up Azure SQL Database
- 17.7 Using Azure SQL Database in Power BI
- 17.8 Using Big Data
- 17.9 Use the Common Data Service (CDS)
Les 19 An introduction to DAX functions, An introduction to DAX functions, including Logical functions
- 19.1 Welcome to Part 3 - Modeling and DAX functions
- 19.2 Get multiple data sets, and connecting them together
- 19.3 The problems with direction of relationships between data sets
- 19.4 DAX functions - A useful Resource
- 19.5 Calculated columns - an introduction
- 19.6 Basic operators
- 19.7 IF, BLANK and ISBLANK
- 19.8 AND, OR and NOT
- 19.9 SWITCH
- 19.10 Other functions
Les 25 Time Intelligence Functions
- 25.1 Date and Time Functions
- 25.2 FIRSTDATE, LASTDATE
- 25.3 Start of... and End of...
- 25.4 Previous... and Next...
- 25.5 DATESINPERIOD
- 25.6 DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
- 25.7 Opening Balance and Closing Balance
- 25.8 Semi-additive Measures
- 25.9 SAMEPERIODLASTYEAR and PARALLELPERIOD
- 25.10 Other Time Intelligence Functions
Les 26 Other Modeling and DAX Topics for the DA-100 exam
- 26.1 Create calculated tables
- 26.2 Create a common date table
- 26.3 Define role-playing dimensions
- 26.4 Resolve many-to-many relationships - Joint Bank Accounts
- 26.5 Resolve many-to-many relationships - Different types of granularity
- 26.6 Improve cardinality levels through summarization and by changing data types
- 26.7 Identify poorly performing measures, relationships, and visuals
- 26.8 End of Part 3
Les 27 An Introduction to the Power BI Service
- 27.1 Welcome to Part 4 The Power BI Service
- 27.2 Introducing The Power BI Service
- 27.3 Logging into Power BI Service and a quick look around
- 27.4 Power BI Terminology
- 27.5 Datasets and Reports in the Power BI Service
- 27.6 Get Data - Other People's Data
- 27.7 Get Data - Your Data
- 27.8 The Navigation Pane, including Add a Quick Insights result to a report
Les 30 Dashboards
- 30.1 Differences between dashboards and reports
- 30.2 Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options
- 30.3 Dashboards Options
- 30.4 Pin a Live Report Page to a Dashboard
- 30.5 Use the Q&A Feature
- 30.6 Add a Dashboard Theme
- 30.7 Dashboard Data Classifications
- 30.8 Configure Data Alerts
Les 31 Manage datasets
- 31.1 Analyze in Excel
- 31.2 Promote or Certify (Endorse) a Dataset
- 31.3 Manually Refreshing data in the Power BI Service
- 31.4 Data Gateways; Providing Access to Datasets
- 31.5 Configure a Dataset Scheduled Refresh
- 31.6 Configure Incremental Refresh Settings - Step 1
- 31.7 Configure Incremental Refresh Settings - Step 2