Mastering Power BI:Data Analysis and Visualization(Oct 2024)

Focused View

Proton Expert Systems & Solutions

4:15:32

0 View

1 - Introduction to Power BI

1 -Introduction to Power BI.mp4

05:50

2 -AG 1-1.pdf

2 -Practice 1-1 Installing Power BI Desktop.mp4

03:32

3 -AG 1-2.pdf

3 -Practice 1-2 Connect Power BI to various data sources & Importload data from.mp4

09:34

2 - Lesson 2 Data Transformation and Modeling

1 -Lesson 2 Data Transformation and Modeling.mp4

06:15

2 -AG 2-1.pdf

2 -Practice 2-1.zip

2 -Practice 2-1 Cleaning and Transforming data using Power Query Editor.mp4

05:18

3 -Practice 2-1-1 Text Functions in Power Query - Merge Columns, Split & Trim Text.mp4

05:18

4 -Practice 2-1-2 Text Funtions in Power Query Left, Right, and Mid Functions.mp4

04:56

5 -Practice 2-1-3 Text FunctionsUppercase, lowercase, Propercase, Prefix & Suffix.mp4

03:36

6 -Practice 2-1-4 Number Functions in Power Query.mp4

08:35

7 -AG 2-2.pdf

7 -Practice 2-2.zip

7 -Practice 2-2 Date Functions using Power Query Editor.mp4

05:16

8 -AG 2-3.pdf

8 -Practice 2-3.zip

8 -Practice 2-3 Append data from multiple sources into a single table.mp4

04:08

9 -Practice 2-3-1 Appending Multiple CSV files in a folder.mp4

04:08

10 -Practice 2-3-2 Appending multiple Excel files from a folder.mp4

04:31

11 -Practice 2-3-3 Appending Multiple sheets & with different numbers of columns.mp4

04:00

12 -Practice 2-3-4 Appending different data sources.mp4

02:14

13 -AG 2-4.pdf

13 -Practice 2-4.zip

13 -Practice 2-4 Merge data from multiple sources.mp4

05:07

14 -Practice 2-4-1 Merging Data from sheets or tables.mp4

05:07

15 -Practice 2-4-2 Merging Data from Multiple Excel Files & Multiple Matching Colum.mp4

02:18

16 -Practice 2-4-3 Merging Data with Multiple Data Sources (Excel & MySQL Database).mp4

04:07

17 -AG 2-5.pdf

17 -Practice 2-5.zip

17 -Practice 2-5 Build a data model and create relationships between tables.mp4

04:44

3 - Lesson 3 Creating Visualizations

1 -Lesson 3 Creating Visualizations.mp4

06:31

2 -AG 3-1.pdf

2 -Practice 3-1.zip

2 -Practice 3-1 Create basic visualizations like charts - part 1.mp4

09:32

3 -AG 3-2.pdf

3 -Practice 3-2.zip

3 -Practice 3-2 Create basic visualizations like charts - part 2.mp4

04:36

4 -AG 3-3.pdf

4 -Practice 3-3.zip

4 -Practice 3-3 Use slicers and filters to interact with data.mp4

07:53

5 -Practice 3-3-1 Slicers in Power BI.mp4

07:53

6 -Practice 3-3-2 Filters in Power BI.mp4

04:39

7 -AG 3-4.pdf

7 -Practice 3-4.zip

7 -Practice 3-4 Implement advanced visualization techniques.mp4

04:54

8 -Practice 3-4-1 Drillthroughs in Power BI.mp4

04:54

9 -Practice 3-4-2 Conditional Formatting in Power BI.mp4

08:53

4 - Lesson 4 DAX for Calculations

1 -Lesson 4 DAX for Calculations.mp4

08:05

2 -AG 4-1.pdf

2 -Practice 4-1.zip

2 -Practice 4-1 Write basic DAX formulas for calculated columns and measures.mp4

04:45

3 -AG 4-2.pdf

3 -Practice 4-2 Basic DAX Functions & Advanced DAX Functions.mp4

04:31

4 -Practice 4-2-1 Basic DAX Functions - Aggregate Functions.mp4

04:31

5 -Practice 4-2-2 Basic DAX Functions - Logical Functions.mp4

03:33

6 -Practice 4-2-3 Basic DAX Functions Text Functions.mp4

03:05

7 -Practice 4-2-4 Basic DAX Functions Date and Time Functions.mp4

03:15

8 -Practice 4-2-5 Basic DAX Functions Mathematical Functions.mp4

02:10

9 -Practice 4-2-6 Advanced DAX Functions.mp4

03:36

10 -AG 4-3.pdf

10 -Practice 4-3 Context in DAX & Time Intelligence Functions & Table Functions.mp4

01:46

11 -Practice 4-3-1 Context in DAX.mp4

01:46

12 -Practice 4-3-2 Time Intelligence Functions in DAX.mp4

05:05

13 -Practice 4-3-3 Table Functions in DAX.mp4

04:21

14 -Practice 4-3-4 Variables in DAX.mp4

03:37

15 -AG 4-4.pdf

15 -Practice 4-4 DAX Query.mp4

05:48

5 - Lesson 5 Power BI Service

1 -Lesson 5 Power BI Service.mp4

06:02

2 -AG 5-1.pdf

2 -Practice 5-1.zip

2 -Practice 5-1 Publish a report to Power BI Service and create a dashboard.mp4

11:30

6 - Lesson 6 Power BI Integration with AZURE

1 -Lesson 6 Power BI Integration with AZURE.mp4

06:43

2 -AG 6-1.pdf

2 -Practice 6-1.zip

2 -Practice 6-1 Connect Power BI to Azure SQL Database and import data.mp4

09:21

3 -AG 6-2.pdf

3 -Practice 6-2 Create a real-time dashboard in Power BI Service using Azure.mp4

03:43

Description

Unlock the Power of Interactive Reports and Data Insights with Microsoft AZURE

What You'll Learn?

Gain a comprehensive understanding of Power BI and its core components.
Learn to transform and model data effectively using Power Query and data modeling techniques
Develop skills in creating interactive and insightful visualizations
Master DAX to perform complex calculations and data analysis
Explore the features and functionalities of Power BI Service for sharing and collaboration.
Understand the process of integrating Power BI with Azure services for enhanced data capabilities

Who is this for?

Business Analysts

Data Analysts

Data Scientists

IT Professionals

What You Need to Know?

Basic Understanding of Data

Fundamental Excel Skills

Interest in Data Analysis

Curiosity and Enthusiasm

More details

Description
Dive into the world of data with our "Mastering Power BI: Data Analysis and Visualization" course. This comprehensive program is designed to guide you through the essentials of Microsoft Power BI, a leading business analytics tool. You will start by gaining a deep understanding of Power BIâ€™s core components and functionalities, setting a solid foundation for effective data analysis and visualization.
In the initial phase of the course, you'll explore the Power BI interface and learn how to connect to various data sources. This includes understanding how to navigate the tool and import data from different platforms. You will become familiar with essential concepts and tools that will be used throughout the course to prepare and structure data for analysis.
As the course progresses, you will focus on data transformation and modeling. Learn how to use Power Query for data cleaning and transformation, and how to build and manage robust data models. You will gain practical skills in creating relationships, hierarchies, and calculated columns to ensure your data is accurately represented and ready for insightful analysis.
The next segment of the course is dedicated to creating interactive and visually engaging reports and dashboards. You will master the art of visualization by learning how to design dashboards that effectively communicate data insights. The course covers a range of visualization tools and techniques, including the use of slicers, filters, and drill-throughs to enhance the interactivity and depth of your reports.
A significant focus of the course is on Data Analysis Expressions (DAX), a powerful formula language used in Power BI. You will learn to write and optimize DAX measures to perform complex calculations and derive meaningful insights from your data. This section includes practical exercises to help you apply DAX functions and time intelligence in real-world scenarios.
The course concludes with an exploration of Power BI Service and its integration with Azure. You will understand how to publish and share your reports through Power BI Service, manage workspaces, and collaborate with team members. Additionally, you will learn how to connect Power BI with Azure services, enhancing your data capabilities and leveraging cloud-based resources for advanced analytics.
Who this course is for:
Business Analysts
Data Analysts
Data Scientists
IT Professionals

User Reviews

Rating

average 0

Total votes0

Focused display

Data Visualization

Proton Expert Systems & Solutions

Instructor's Courses

Proton Expert Systems & Solutions is an ISO 9001:2015 Certified IT Consulting and Services firm, specializing in Cloud Computing, Enterprise Applications, Data Science, Machine Learning, Block Chain, IOT, Web/Mobile App Designing and IT Consulting Solutions.SPECIALIZED IN SERVICES & SOLUTIONCloud Computing – AWS, GCP, OCI, Docker, Kubernetes, Devops, Ansible, TerraformData Science – Big Data – Hadoop full Stack , Spark, Python, R Programming, Machine Learning, Data VisualizationBlock Chain – Hyperledger and IOTOracle CPQ Cloud, Oracle Sales CloudMobile App, Web App Design, SEO and SMM

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.