Mastering Power BI: A Beginner's Guide to Data Visualization

Focused View

Sunil Nair,ByteSize Trainings

5:39:23

70 View

1. Introduction to Power Bi

1. Power BI for Professionals.mp4

01:23

2. Power BI Applications.mp4

01:06

3. Getting Started with Power BI.mp4

02:07

4. Explore Power BI Desktop Interface.mp4

04:00

5. Data Files to Download.html

2. Data Models in Power Bi

1. Load a CSV to the Data Model.mp4

08:25

2. Configure Properties of the Data Model.mp4

07:34

3. Data Relationships in Model View.mp4

05:09

4. Activity - Configure Properties on the Data Set.mp4

00:28

5. Solution Video.mp4

02:35

3. Table Visualization

1. Create a Table Visualization.mp4

03:28

2. Format Visualization - Table.mp4

09:47

3. Conditional Formatting.mp4

04:40

4. Filters.mp4

07:26

5. Activity - Top 10 Loan Customers.mp4

01:14

6. Solution - Top 10 Loan Customers.mp4

05:28

7. Field Parameters.mp4

04:56

4. Matrix Visualization

1. Introduction to Matrix.mp4

10:18

2. Formatting and Edit Interactions.mp4

06:51

3. Activity.mp4

00:53

4. Solution.mp4

02:19

5. Using Field Parameters with Matrix.mp4

06:25

5. Cards and Slicers

1. Card.mp4

05:55

2. Multi-Row Card.mp4

04:52

3. Slicer - Category.mp4

05:11

4. Slicer - Date Hierarchy.mp4

06:16

6. Charts

1. Clustered Columns Charts.mp4

02:57

2. Chart Legend, Small Multiples and Tooltips.mp4

04:35

3. Clustered Chart Formatting.mp4

05:29

4. Parameters with Clustered Charts.mp4

04:13

5. Line Charts.mp4

02:53

6. Line Chart Formatting.mp4

03:27

7. Forecasting in Line Charts.mp4

06:34

8. Line and Clustered Column Chart.mp4

01:43

7. Others Charts

1. Ribbon Chart.mp4

04:06

2. Waterfall Chart.mp4

01:10

3. Funnel Chart.mp4

05:03

4. Pie, Donut and Tree Map.mp4

03:35

5. Scatter Chart.mp4

04:18

6.1 Data for Geo Map Visualization.html

6. Maps.mp4

07:45

7. Activity.mp4

01:30

8. Solution.mp4

08:57

8. Navigation and Drill Through

1. Bookmarks.mp4

03:24

2. Bookmark Navigator.mp4

03:47

3. Page Navigator and Other Buttons.mp4

05:26

4. Drill Through.mp4

07:26

9. AI Visualizations

1. Key Influencers.mp4

02:17

2. Q&A.mp4

05:01

3. Smart Narrative.mp4

05:08

10. Published Reports, Dashboards and Mobile View

1. Publish Report.mp4

04:10

2. Explore Power Bi Service.mp4

05:38

3. Creating Dashboards.mp4

08:26

4. Mobile Layouts.mp4

04:29

11. DAX Formulas

1. Introduction to DAX Formulas.mp4

01:33

2. New Column - COMBINEVALUES.mp4

06:03

3. New Column - SWITCH.mp4

07:36

4. New Measure - CALCULATE.mp4

09:00

5. New Measure - FILTER and COUNTROWS.mp4

03:52

6. Gauge Visualization with Measures.mp4

04:53

7. KPI Visualization with Measures.mp4

05:17

8. New Table - FILTER.mp4

03:16

9. New Table - FILTER and RELATED.mp4

05:02

10. New Table - ADDCOLUMNS.mp4

05:16

11. New Table - FILTER and ADDCOLUMNS.mp4

04:12

12. New Measure with Variables - SELECTCOLUMNS and TOPN.mp4

07:51

13. New Measure with Variables - CONCATENATEX.mp4

03:29

12. Data Transformation

1. Introduction to the Power Query Editor.mp4

02:06

2. Load Multiple Sheets from an Excel File.mp4

17:07

3. Load Multiple Excel Files from a Folder.mp4

10:37

Description

Transforming Raw Data into Actionable Insights

What You'll Learn?

Building Data Models and Table Relationships
Authoring Reports using Visualizations
Data Transformation using Multiple Use Cases
Solve Complex Data requirements using DAX Formulas

Who is this for?

Working professionals curious about Data Analytics

What You Need to Know?

Working knowledge of Excel Charts and Pivots

Understanding of Data Models and Relationships

More details

Description
If you are a working professional, join me in this exciting course on Power BI. It will help you easily analyze and visualize complex data from various sources, and turn it into meaningful insights and reports with a short learning curve.
As of May 2023, I have delivered in-person training to over 2,500 working professionals in skills across office productivity, programming, databases, analytics, and cloud computing, enabling rapid implementation of new skill sets.

Course Curriculum
Data Models and Relationships
Visualizations - Tables, Matrix, Cards
Slicers - Date Hierarchy and Categories
Charts
Navigation and Drill Through
AI Visualizations
Publishing Reports and Dashboards
Mobile Layout
DAX Formulas
Data Transformation

What this course contains
11 Sections with Easy-to-follow instructional videos
4 Assignments
Software and Credentials Required
You will need Power BI Desktop to follow all instructions in this course
A work email address would be required to sign in to Power BI Desktop and Power BI Service.
Without a work email address, you will not be able to publish reports created in Power BI Desktop to the Power BI Service.
Intended Course Outcome
Career growth: Learning Power BI can lead to better job opportunities and career growth, particularly in data analytics, business intelligence, and other related fields.
Competitive advantage: Having Power BI skills can give you a competitive advantage in the job market, particularly in data analytics and business intelligence roles.
Better decision-making: Power BI enables you to analyze data from multiple sources and gain valuable insights, leading to better and more informed decisions.
Improved productivity: With Power BI, you can automate manual data processing and create interactive dashboards and reports quickly, improving productivity.
Data visualization skills: Power BI helps you to create visually appealing charts, graphs, and other visuals, enabling you to communicate data insights effectively.
Data accuracy and consistency: With Power BI, you can ensure that data is accurate and consistent across multiple sources, avoiding errors and discrepancies.
Who this course is for:
Working professionals curious about Data Analytics

User Reviews

Rating

average 0

Total votes0

Focused display

Sunil Nair is an Edupreneur based in Dubai. With a will to educate, Sunil Nair moved from his 13-year career as an IT Professional to a full-time Educator. Since 2017, he has been mentoring both Children and Professionals alike with a focus on achieving rapid implementation of skills.For Professionals, he has developed and delivered high-in-demand IT courses in Programming, Office Applications, Databases, Analytics, Cloud Computing and New Technologies. Sunil's interactive style of teaching Professionals using custom-built Web Apps has helped working professionals implement new skills with ease.As of Feb 2023, Sunil Nair has designed content for 20+ courses and delivered over 700+ Training hours (ILT & VILT'S) to professionals across 50+ institutions primarily the Government sector, Banking, Insurance, Real Estate, FMCG & Media.For children, he has developed courses in Programming covering Web Design, Python, JavaScript and Web App Development. He revels as a mentor and helps children achieve their aspirations of joining top universities for Computer Science.Vinith Ramaswamy, Dubai International Academy, Dubai, UAE"I have heard back from 4 universities so far and have gotten accepted to all of them: Purdue, UIUC, Wisconsin-madison, and WPI, everything you taught me was definitely a huge part in it so thank you so much"Prateeti Saran, Dubai International Academy, Dubai, UAE"I just recently got into Columbia University for Computer Science and wanted to thank you for being the one who helped me get interested in and get started with CS. Your teaching was amazing, and really really developed my passion for CS, thank you so so much!"Josh Killa, Dubai College, Dubai"My top choices for receiving offers were from Imperial College London and Warwick university to study computer science. Thanks, Sunil your teaching has had a massive impact"When Sunil is not busy Educating, his keen interest is in practising classical hatha yoga or simply reading a book.

ByteSize Trainings

Instructor's Courses

At ByteSize, Educator and Author Sunil Nair designs in-demand IT courses across Programming, Office Applications, Databases, Analytics, Cloud Computing and New Technologies by breaking down their complexity. He then delivers it in Byte-Sized format in a highly interactive and engaging manner. The Byte-Sized training make learning easy and enable rapid implementation of new skills.

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.