Power BI Zero to Pro w/ Data Analysis Masterclass & ChatGPT

Focused View

Irfan Sharif ACA ACCA

10:14:09

0 View

1. Introduction & Getting Started

1. Introducing Power BI - Download & Install.mp4

03:14

2.1 Business Data lecture file.xlsx

2. Download the course data file.html

3. Welcome to Power BI! Getting started.mp4

06:39

4. Formatting the Data.mp4

08:48

5. Adding the Calendar Table.mp4

08:55

6. Connecting the Tables - Data Modeling.mp4

08:50

7. Adding & Exploring our first Visual.mp4

24:03

8. Formatting the Visual.mp4

19:19

9. Quick yet Amazing Dashboard.mp4

54:07

2. Exploring Other Amazing Visuals & Features

1. Introduction to the section.mp4

00:58

2. Tables - Reorganize Data & Make it Insightful!.mp4

27:58

3. Slicers - Look at any specific parameters.mp4

17:33

4. Drill through - From Dashboard to underlying transaction in a second.mp4

13:23

5. Filters - Filter out clutter.mp4

06:27

6. Matrix - The Magical Way to Prepare Insightful Reports!.mp4

14:47

7. Bar & Column Chart - StackedClustered100% Stacked.mp4

07:43

8. LineAreaStacked Area100% Stacked Area Chart - Tracing Trends.mp4

19:59

9. Line & Column Chart - The Most Powerful Chart to Corelate things.mp4

06:58

10. Ribbon Chart - Visualizing the Change in Relative Position.mp4

15:17

11. Waterfall Chart - Identify the Drivers of Change!.mp4

12:35

12. Funnel Chart - The Way to Measure Conversion.mp4

06:31

13. Scatter Chart - Unveil Patters & Correlations.mp4

18:26

14. PieDonut Chart & Tree Map - Show Composition.mp4

08:33

15. Cards & Multirow Cards - Present the Absolute Value.mp4

07:48

16. Maps & Filled Maps - Show Values over Map.mp4

07:52

17. Other Charts and the plan.mp4

02:13

3. Calculations in Power BI with DAX

1. Introduction to DAX.mp4

09:55

2. Adding columns with DAX - Part 1.mp4

07:45

3. Adding Columns with DAX - Part 2.mp4

11:06

4. Adding columns with DAX - Part 3 - Conditional Columns.mp4

11:06

5. IF Statement IF OR IF OR IN.mp4

10:11

6. IF AND.mp4

05:30

7. Homework - IF OR AND.html

8. Homework answers - IF OR AND.mp4

03:03

9. Merging Columns - CONCATENATE.mp4

04:42

10. Data from Other Tables - RELATED.mp4

04:51

11. Basic Calculations in Calculated Columns.mp4

06:02

12. Adding Calendar Table with DAX.mp4

06:53

13. LookupValue.mp4

04:35

14.1 3. Section 3.zip

14. Section file.html

4. Calculations in Power BI - Measures

1. Introducing Measures.mp4

08:16

2. AVERAGE.mp4

02:40

3. SUMX - Row by row calculation first, then Sum.mp4

06:09

4. RELATED in Measures.mp4

05:22

5. Practice - SUMX & RELATED, and transforming the data in professional way.mp4

11:02

6. Section files.html

7. Getting ready for our next DAX Measures.mp4

03:14

8. CALCULATE - The Golden DAX function - Filter data like a pro!.mp4

06:40

9. Homework answers - CALCULATE.mp4

05:07

10. DIVIDE.mp4

05:52

11. Dividing in Matrix.mp4

09:30

12. MIN & MAX.mp4

04:01

13. ALL - Bypassing Filters.mp4

07:00

14. Section end file.html

Files.zip

5. Measures with DAX - Part 2 - Time Intelligence

1. Introduction to the section.mp4

03:56

2. YTD - Year to date totals.mp4

04:42

3. QTD - Quarter to date MTD - Month to date.mp4

03:14

4. TTD - Total to date.mp4

06:15

5. Rolling Sum & Moving Average.mp4

11:52

6. Rolling Sum & Moving Average - Excluding Initial Days.mp4

04:13

7. Homework.html

8. Homework Answers.mp4

04:51

9. Section file.html

Files.zip

6. Measures with DAX - Comparative Values

1. Previous Period Value.mp4

04:33

2. Making PP Dynamic - Calculating Dynamic Number of Months in the Period.mp4

05:22

3. Period on Period Growth.mp4

05:20

4. Previous Corresponding Period Value.mp4

07:56

5. PCP Growth.mp4

04:43

6. Visualizing these Values in a Stunning Chart.mp4

10:39

7. Section end file.html

Files.zip

7. Other Amazing DAX formulas & concepts that you MUST know

1. Homework Ready your Power BI file for the section.html

2. Introduction and setting up the file.mp4

05:17

3. SWITCH - The magical way to conditional calculations!.mp4

09:45

4. Homework SWITCH.html

5. Homework answers and SWITCH with OR.mp4

04:15

6. VAR in DAX.mp4

04:38

7. Challenge Homework.html

8. Homework answers.mp4

05:53

9. Incorporating Dynamic Holidays.mp4

17:17

Description

2 courses in 1: Starting from Zero, Master Power BI & Data Analysis in Power BI, leveraging tools like DAX, & ChatGPT

What You'll Learn?

Power BI Visualizations - Charts & Graphs
Power BI Dashboards
Formulas and Functions with DAX
Drill Down Capability
Preparation of Reports
Data Cleaning and Data Transformation

Who is this for?

Data Analysts looking to enhance their data visualization and reporting skills.

Business Intelligence professionals seeking to leverage Power BI for advanced analytics.

Financial Analysts wanting to create detailed financial reports and dashboards.

Managers and Executives aiming to make data-driven decisions with powerful insights.

IT Professionals interested in integrating Power BI with other data systems and solutions.

Marketing Analysts needing to track and visualize marketing performance metrics.

Sales Professionals who want to monitor sales data and trends effectively.

Students and Graduates aiming to build a career in data analysis and business intelligence.

Anyone interested in learning data analysis and visualization

What You Need to Know?

Windows laptop OR Mac with Windows app compatibility

No Data Analysis skills required

No Power BI knowledge required

More details

Description
Unlock the full potential of your data with our "Power BI for Beginners with Data Analysis Masterclass." This comprehensive course is designed for anyone looking to harness the power of Microsoft Power BI for data analysis, business intelligence, and financial analysis.
What You Will Learn:
Introduction to Power BI: Start with the basics and get comfortable with Power BIâ€™s user-friendly interface. Learn how to connect to various data sources and understand the fundamentals of data transformation and cleansing.
Creating Stunning Visualizations: Discover how to create engaging and interactive visualizations that effectively communicate your data story. Explore different types of charts, graphs, and maps to make your reports stand out.
Building Interactive Dashboards: Dive into the world of interactive dashboards. Learn to combine multiple visuals, apply filters, and create dynamic reports that can be shared with your team or stakeholders.
Advanced Analytics with DAX: Master Data Analysis Expressions (DAX) to perform complex calculations and data modeling. Gain insights into advanced analytics techniques that will help you extract deeper and more meaningful insights from your data.
Why Choose This Course?
Comprehensive Curriculum: Our course covers everything from the basics to advanced analytics, ensuring you become proficient in Power BI and data analysis.
Expert Instructor: Learn from industry expert who brings real-world experience and insights into the classroom.
Hands-On Learning: Engage in practical exercises and real-world projects that reinforce your learning and help you apply your skills immediately.
Career Advancement: Whether you're looking to advance in your current role or switch to a data-driven career, mastering Power BI will open up new opportunities in business intelligence and financial analysis.

Who should learn Power BI:
Data Analysts looking to enhance their data visualization and reporting skills.
Business Intelligence professionals seeking to leverage Power BI for advanced analytics.
Financial Analysts wanting to create detailed financial reports and dashboards.
Managers and Executives aiming to make data-driven decisions with powerful insights.
IT Professionals interested in integrating Power BI with other data systems and solutions.
Marketing Analysts needing to track and visualize marketing performance metrics.
Sales Professionals who want to monitor sales data and trends effectively.
Students and Graduates aiming to build a career in data analysis and business intelligence.
Entrepreneurs and Small Business Owners looking to analyze and visualize their business data.
Anyone interested in learning data analysis and visualization, regardless of their current role or industry.

Prerequisite:
None!
Money-Back Guarantee:Â
Nothing to lose! If you will not be satisfied with the course, Udemy offers 30 days money-back guarantee!
Who this course is for:
Data Analysts looking to enhance their data visualization and reporting skills.
Business Intelligence professionals seeking to leverage Power BI for advanced analytics.
Financial Analysts wanting to create detailed financial reports and dashboards.
Managers and Executives aiming to make data-driven decisions with powerful insights.
IT Professionals interested in integrating Power BI with other data systems and solutions.
Marketing Analysts needing to track and visualize marketing performance metrics.
Sales Professionals who want to monitor sales data and trends effectively.
Students and Graduates aiming to build a career in data analysis and business intelligence.
Anyone interested in learning data analysis and visualization

User Reviews

Rating

average 0

Total votes0

Focused display

Chartered Accountant with 12 years experience in Accounting, Finance, and Business Intelligence. I am a Chartered Accountant from ICAEW (Institute of Chartered Accountants of England and Wales) and a Chartered Certified Accountant from ACCA (Association of Chartered Certified Accountants in England) . I also have a Bachelors degree in Commerce. I started my professional career with PwC as a Functional Consultant, later moved to at FTSE 100 FMCG as a Finance Manager, then working a General Manager developed an outsourcing hub 'Excelsious' for US and UK accounting firms, and finally cofounded Receipt Bot - an accounting automation company which is automating some tedious aspects of Accounting for clients from 21 countries. Right from the beginning of my career, my role has been to improve the Accounting and Reporting systems. From automating data entry and bookkeeping to the preparation of interactive business analysis dashboards for the senior management, I have led multiple assignments. Over my professional career of 12 years, I have been teaching several programs of Accounting and BI at some reputed institutes. Over this time, I have trained 20,000+ students from 50+ countries. I am absolutely delighted to share my skills and experience with you on the Udemy platform!

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.