From Excel to Power BI

Focused View

Virginia Collins

4:30:35

35 View

1 - Introduction

1 - Course Introduction.mp4

07:00

2 - Outline Planning and Implementing data analytics.mp4

03:55

3 - Outline Demonstration of learning path for Excel users to become data analysts.mp4

04:18

4 - Course Resources.mp4

02:30

5 - Why do your business and business users need to develop data skills today.mp4

02:49

6 - Is data an asset of your company.mp4

01:36

7 - What data management process can we use.mp4

01:27

Files.zip

2 - History of Business Intelligence

8 - What is traditional business intelligence.mp4

02:22

9 - Why have business intelligence projects been historically unsuccessful.mp4

03:40

3 - What is Self Service Business Intelligence

10 - Why has SelfService Business Intelligence emerged.mp4

02:39

11 - What is SelfService Business Intelligence.mp4

02:37

12 - What are the limitations of Excel when it comes to working with data.mp4

02:26

13 - What are the data analysis tools that are available in Excel.mp4

01:57

14 - What do you need to know about Power Query.mp4

02:56

15 - What do you need to know about Power Pivot.mp4

01:37

4 - Planning For SelfService Business Intelligence

16 - How can you plan for SelfService BI.mp4

02:25

17 - What should your data literacy plan include.mp4

03:16

18 - What are some sample data strategies.mp4

03:09

19 - Why is Agile the project methodology for SelfService BI.mp4

05:46

20 - Why does Self Service BI need a new area of data governance.mp4

04:38

5 - Implementing SelfService Business Intelligence

3 - Implementing SelfService BI Quiz.html

21 - How can you implement SelfService BI.mp4

05:19

22 - Data Roles for SelfService BI.mp4

05:06

23 - How can you begin developing your data creators.mp4

04:35

24 - What is the Power Platform.mp4

03:49

25 - What are the components and building blocks of Power BI.mp4

05:14

26 - How does collaboration work in the Power BI Service.mp4

04:39

27 - How can different levels of data literacy communicate.mp4

05:16

28 - How can we adminster the Power BI ecosytem.mp4

04:20

29 - What are the steps in a data initiative.mp4

05:32

6 - Key Takeaways

30 - What do you need to get right to succeed in implementing data analytics.mp4

04:07

31 - What is the learning path for developing Your Data Creator Team.mp4

05:34

7 - Learning Path Begin with Excel

32 - Connectors Power Query Interface and Append Operation.mp4

13:15

33 - Transformations in Power Query.mp4

14:56

34 - Use Cases in Power Query.mp4

08:45

35 - Data Modeling in Power Pivot.mp4

20:12

8 - Learning Path Transition to Power BI Desktop

36 - DAX Measures Aggregators Iterators CALCULATE Time Intelligence Ranking.mp4

18:05

37 - Exploratory Analysis Anomaly and Forecasting.mp4

09:43

38 - Exploratory Analysis AI Visualizations.mp4

10:27

39 - Curating Visualizations Tooltips and Small Multiples.mp4

08:04

40 - Curating Visualizations Navigation Bookmarks and Buttons and Synch Slicers.mp4

06:45

41 - Curating Visualizations Hierarchies and Drill Throughs.mp4

04:01

9 - Learning Path Collaborate with Power BI Service

42 - Data Initiative Example.mp4

09:07

43 - Workspaces.mp4

05:18

44 - Report and Semantic Model.mp4

09:32

45 - APPS and Dashboards.mp4

06:44

46 - Dataflows.mp4

05:38

47 - Feature Review and Conclusion.mp4

03:29

Description

Planning and Implementing Self-Service BI with the Power BI Ecosystem

What You'll Learn?

Understand why your company and its employees must develop data skills today and begin treating data as an asset.
A review of the history of business intelligence (BI) is needed to understand the attributes and challenges of traditional BI.
Gain an understanding of why self-service BI has emerged and how it enables everyone in a company to work with data.
Learn how to turn your organization into a data-driven company by following the steps described for planning and implementing self-service BI.
Showcase a future learning path for Excel users to become data analysts using the low-code Power BI tools in Excel, Power BI Desktop, and Power BI Service.
Begin with Excel—Showcase Power Query and Power Pivot to connect to various data sources, transform the data, and model the data for analysis.
Transition to Power BI Desktop- Showcasing how to explore and analyze data with DAX functions, AI, and visualizations.
Collaborate in Power BI Service- Showcasing how Excel users transformed into data analysts can share content in the Power Platform with your data consumers.

Who is this for?

This course is for Excel users and small businesses interested in initiating their data analytics journey using Power BI.

What You Need to Know?

Experience with the tools and features of the Power BI ecosystem is optional. Knowledge of Excel is helpful.

More details

Description
In today's information age economy, data has become essential for business success. Your company and its employees must adapt by developing strong data skills and treating data as an asset.
Welcome to "From Excel to PBI: Planning and Implementing Self-Service BI with the Power BI Ecosystem," a course designed to empower everyone in your organization to harness the power of data using the low-code tools of the Power BI ecosystem.
Throughout this course, we'll delve into key topics essential for becoming a data-driven company:
Planning for Self-Service BI:
Investing in Data Literacy
Developing a Data Strategy
Adopting Agile Methodology
Implementing Data Governance
Implementing Self-Service BI:
Understanding Data Roles
Building a Data Creators' Team
Leveraging Power BI in the Cloud
Mastering Data Storytelling
Administering Power BI
Navigating the Workflow of a Data Initiative
Demonstrating the Learning Path for Excel Users:
Starting with Excel's Power Query and Power Pivot
Transitioning to Power BI Desktop for Advanced Analysis and Visualizations
Collaborating in Power BI Service as part of the Power Platform
I'm Virginia Collins, CPA, and Microsoft PL-300 Data Analytics Associate Certified. With years of experience developing CPE courses for CPAs in Excel and Power BI, I'm dedicated to enhancing your data skills.
By enrolling in this course, you'll kickstart your journey towards data literacy, empowering your company to thrive in the data-driven era. Don't miss this opportunity to unlock the potential of your dataâ€”click the buy button now!

Who this course is for:
This course is for Excel users and small businesses interested in initiating their data analytics journey using Power BI.

User Reviews

Rating

average 0

Total votes0

Focused display

Virginia Collins, CPA, CITP, founder of Numbers to Data, LLC, empowers Excel users and small businesses to embrace data literacy. With 30+ years in public accounting, she specializes in data analytics and business intelligence. Virginia's courses for CPAs and consultations with small businesses guide professionals and companies toward becoming data-driven decision-makers.

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.