Become a Microsoft Power BI Data Analyst

Focused View

Bluelime Learning Solutions

8:35:45

117 View

1. Introduction to Microsoft Data Analytics

1. Introduction.html

2. Microsoft Data Analytics.mp4

04:50

3. Overview of Data Analysis.mp4

08:14

4. Roles in Data Analysis.mp4

09:14

5. Tasks of a Data Analyst.mp4

10:38

6. Data Analytics Quiz.html

2. Power BI Setup

1. What is Power BI.mp4

05:47

2. What is Power BI Desktop.mp4

03:40

3. Install Power BI Desktop.mp4

02:55

4. Exploring Power BI Desktop Interface.mp4

05:02

5. Microsoft 365 Setup.mp4

03:43

6. Getting started with Microsoft 365.mp4

04:04

7. Creating a new user account in Microsoft 365.mp4

02:54

3. Building with Power BI

1. Power BI Overview Part 1.mp4

04:24

2. Power BI Overview Part 2.mp4

04:05

3. Power BI Overview Part 3.mp4

04:49

4. Parts of Power BI.mp4

02:57

5. Power BI Building blocks (Video).mp4

09:31

6. Exploring Power BI Service.mp4

04:28

7. Building blocks of Power BI.html

8. The flow of work in Power BI.html

9. Tour and use of Power BI Service.html

10. Update data in Power BI Service.html

11. Summary.html

12. Get started with Power BI.html

4. Connect & Transform Online Data

1. Connect to Web Data.mp4

05:07

2. Clean & transform data Part 1.mp4

07:12

3. Clean & transform data Part 2.mp4

09:45

4. Combine data sources.mp4

07:59

5. Creating Data Visuals Part 1.mp4

06:09

6. Creating Data Visuals Part 2.mp4

05:23

7. Publish report to Power BI Service.mp4

04:47

5. SQL Server Setup

1. What is SQL Server.mp4

02:57

2. SQL Server Editions.mp4

04:45

3. SQL Server Installation Requirements.mp4

04:21

4. Download SQL Server.mp4

04:31

5. SQL Server Installation.mp4

09:43

6. SQL Server Configuration Manager.mp4

08:10

7. Installing SQL Server Management Studio.mp4

05:48

8. Connect to SQL Server with SSMS.mp4

02:16

9.1 AdventureWorksDW2020.zip

9. Restore AdventureWorksDW2020 Database.mp4

03:41

10. Download Sample Database.mp4

05:49

6. Prepare data ( Get data from different data sources )

1. Introduction.html

2. Get data from online services.html

3. Get data from a NoSQL database.html

4. Create and save a new Power BI Desktop file.mp4

02:12

5. Set Power BI Desktop options.mp4

02:04

6. Get data from relational data sources.mp4

05:51

7. Preview SQL Server queries.mp4

10:16

8. Get data from files.html

9.1 ColorFormats.csv

9.2 ResellerSales 202006.csv

9.3 ResellerSalesTargets.csv

9. Get data from a CSV file.mp4

05:07

10. Get additional data from a CSV file.mp4

02:51

11. Change the source file.html

12. Selecting a storage mode.html

13. Get data from Azure Analysis Services.html

14. Fix performance issues.html

15. Resolve data import errors.html

16. Summary.html

17. Getting Data.html

7. Clean, transform, and load data in Power BI

1. Introduction.html

2. Shape the initial data.html

3. Configure the Salesperson query.mp4

08:31

4. Configure the SalespersonRegion query.mp4

01:50

5. Configure the Product query.mp4

07:22

6. Configure the Reseller query.mp4

04:58

7. Configure the Region query.mp4

02:40

8. Configure the Sales query.mp4

05:55

9. Configure the Targets query.mp4

05:50

10. Configure the ColorFormats query.mp4

00:42

11. Update the Product query.mp4

02:33

12. Update the ColorFormats query.mp4

01:49

13. Load and Transform Data.html

8. Model Data In Power BI Desktop

1. Introduction.html

2. Create Model Relationships.mp4

13:19

3. Configure the Product table.mp4

03:37

4. Configure the Region table.mp4

02:56

5. Configure the Reseller table.mp4

05:20

6. Configure the Sales table.mp4

02:48

7. Bulk update properties.mp4

03:07

8. Review the model interface.mp4

04:40

9. Create quick measures.mp4

06:36

10. Model Data In Power BI Desktop.html

11. Create a many-to-many relationship.mp4

10:03

12. Relate the Targets Table.mp4

01:56

13. Enforce row-level security.mp4

05:14

9. Introduction to DAX In Power BI Desktop

1. Create the Salesperson Calculated table.mp4

07:23

2. Create the Date calculated table.mp4

03:17

3. Create calculated columns.mp4

06:55

4. Complete the Date table.mp4

04:40

5. Mark the Date table.mp4

02:21

6. Create simple Measures.mp4

16:56

7. Create additional measures.mp4

11:07

10. Time Intelligence and Measures in DAX

1. Create a matrix visual.mp4

03:53

2. Manipulate filter context.mp4

15:40

3. Create a YTD measure.mp4

02:46

4. Create a YoY growth measure.mp4

06:45

5. Publish Power BI Desktop File.mp4

04:15

6. Time Intelligence Quiz.html

11. Design a report in Power BI Desktop

1. Create a new file.mp4

00:41

2. Create a live connection.mp4

02:13

3. Design page 1.mp4

14:11

4. Design page 2.mp4

06:57

5. Design page 3.mp4

10:00

6. Publish report.mp4

01:17

7. Explore the report.mp4

05:23

8. Configure Sync Slicers.mp4

05:21

9. Configure drill through page.mp4

06:01

10. Add Conditional Formatting.mp4

04:28

11. Add Bookmarks to Report.mp4

05:30

12. Add Buttons to Report.mp4

04:30

13. Publish Updated Report.mp4

01:53

14. Power BI Dashboard.html

15. Explore Updated Report.mp4

02:53

16. Designing Reports.html

12. Create a Power BI dashboard (Create a sales monitoring dashboard)

1. Create a dashboard.mp4

07:21

2. Configure an alert.mp4

00:45

3.1 ResellerSales 202006.csv

3.2 updatedatabase-2.zip

3. Refresh the dataset.mp4

08:28

13. Perform data analysis in Power BI Desktop

1. Create the report.mp4

00:38

2. Connect to the Sales Analysis Dataset.mp4

01:18

3. Create an animated scatter chart.mp4

04:50

4. Create a forecast.mp4

05:31

5. Work with a decomposition tree.mp4

04:37

6. Work with key influencers.mp4

05:16

7. Perform data analysis in Power BI Desktop.html

14. Exam PL-300 Microsoft Power BI Data Analyst Preparation

1. Introduction.html

2. What is the exam Format.html

3. Prepare the Data (15-20%).html

4. Model the Data (30-35%).html

5. Visualize and Analyze the Data (25-30%).html

6. Deploy and Maintain Assets (20-25%).html

7. PL-300 Exam Braindumps.html

Description

Prepare Data | Model Data | Visualize and Analyse Data | Deploy and Maintain Assets

What You'll Learn?

Prepare the data
Get data from different data sources
Clean, transform, and load the data
Model the data
Design a data model
Develop a data model
Create model calculations by using DAX
Optimize model performance
Visualize and analyze the data
Create reports
Create dashboards
Enhance reports for usability and storytelling
Identify patterns and trends
Deploy and maintain assets
Manage files and datasets
Manage workspaces

Who is this for?

Beginner Data Analyst

Beginner Power BI Data Analyst

More details

Description
The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient using Power Query and writing expressions by using DAX.

Prepare the data -Â ( Get data from different data sources)
Identify and connect to a data source
Change data source settings
Select a shared dataset or create a local dataset
Select a storage mode
Use Microsoft Dataverse
Change the value in a parameter
Connect to a data flow

Clean, transform, and load the data
Profile the data
Resolve inconsistencies, unexpected or null values, and data quality issues
Identify and create appropriate keys for joins
Evaluate and transform column data types
Shape and transform tables
Combine queries
Apply user-friendly naming conventions to columns and queries
Configure data loading
Resolve data import errors

Model the dataÂ -Â ( Design a data model )
Define the tables
Configure table and column properties
Design and implement role-playing dimensions
Define a relationship's cardinality and cross-filter direction
Design a data model that uses a star schema
Create a common date table

Develop a data model
Create calculated tables
Create hierarchies
Create calculated columns
Implement row-level security roles
Use the Q&A feature
Create model calculations by using DAX
Create basic measures by using DAX
Use CALCULATE to manipulate filters
Implement Time Intelligence using DAX
Replace implicit measures with explicit measures
Use basic statistical functions
Create semi-additive measures
Use quick measures

Optimize model performance
Remove unnecessary rows and columns
Identify poorly performing measures, relationships, and visuals
Reduce cardinality levels to improve performance

Visualize and analyze the data ( Create reports & Dashboards)
Add visualization items to reports
Choose an appropriate visualization type
Format and configure visualizations
Use a custom visual
Apply and customize a theme
Configure conditional formatting
Apply slicing and filtering
Configure the report page
Use the Analyze in Excel feature
Choose when to use a paginated report
Manage tiles on a dashboard
Configure mobile view
Use the Q&A feature
Add a Quick Insights result to a dashboard
Apply a dashboard theme
Pin a live report page to a dashboard

Enhance reports for usability and storytelling
Configure bookmarks
Create custom tooltips
Edit and configure interactions between visuals
Configure navigation for a report
Apply sorting
Configure Sync Slicers
Group and layer visuals by using the selection pane
Drilldown into data using interactive visuals
Export report data
Design reports for mobile devices

Identify patterns and trends
Use the Analyze feature in Power BI
Identify outliers
Choose between continuous and categorical axes
Use groupings, binnings, and clustering
Use AI visuals
Use the Forecast feature
Create reference lines by using the Analytics pane

Deploy and maintain assetsÂ (Manage files, datasets and Manage workspaces)
Identify when a gateway is required
Configure a dataset scheduled refresh
Configure row-level security group membership
Provide access to datasets
Manage global options for files
Create and configure a workspace
Assign workspace roles
Configure and update a workspace app
Publish, import, or update assets in a workspace
Apply sensitivity labels to workspace content
Configure subscriptions and data alerts
Promote or certify Power BI content
Who this course is for:
Beginner Data Analyst
Beginner Power BI Data Analyst

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.