About This Course
Who this course is for:
- Analysts (Business Intelligence Data /Reporting/MI Analysts)
- Accountants
- Project Managers
- Marketers
- Executive Assistants
What you’ll learn:
- Get familiar with the interface and views in Power BI
- Connecting to data, using Power Query and building tables
- Understanding relationships, measures and calculations
- Creating outputs with some of the key charts in Power BI.
- How can we publish and share our work
Requirements:
- You will need access to Power BI, which can be obtained for free online or a pro version from your company
Power BI is Microsoft’s play into the growing Business Intelligence reporting space, and they have created an incredible tool worthy of your attention. If your reporting requirements are more serious, that is you work with larger volumes of data, your data updates frequently, you create external facing reports/dashboards and need to share/publish your data online or via company intranets, then Power BI may be your best option for building robust MI.
We asked highly experienced BI Consultant, Andrew Ward to create this course and to bring you to an intermediate level of expertise. Andrew will guide you step by step and help you to create high value dashboards and reports by the end of this course.
Our Promise to You
By the end of this course, you will have learned to use Power BI.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about Power BI.
Course Curriculum
3h 49m
Section 1 - Introduction To Power BI | |||
The Power BI Interface | 00:00:00 | ||
The Three Main Views In Power BI · | 00:00:00 | ||
Getting Familiar With Power BI | 00:00:00 | ||
Section 2 - Working With Data In Power BI | |||
Connecting to Excel Data | 00:00:00 | ||
Getting Familiar With Power Query | 00:00:00 | ||
Building And Cleaning A Date Table | 00:00:00 | ||
Section 3 - Data Analysis with Power BI | |||
Understanding Relationships | 00:00:00 | ||
Introduction To Calculations | 00:00:00 | ||
Working With Measures· | 00:00:00 | ||
Measure For Total Profit· | 00:00:00 | ||
Measure For Previous Year Profit | 00:00:00 | ||
Using A Slicer To Filter Dates | 00:00:00 | ||
Section 4 - Power BI Dashboards | |||
Sales Summary: Dashboard Set Up | 00:00:00 | ||
Sales Summary: Line Chart | 00:00:00 | ||
Sales Summary: Donut Chart | 00:00:00 | ||
Sales Summary: Optional-More Donut Charts | 00:00:00 | ||
Profit Summary: Tweaking an Existing Dashboard | 00:00:00 | ||
Geography Summary: Introduction | 00:00:00 | ||
Geography Summary: Stacked Bar Chart | 00:00:00 | ||
Geography Summary: Maps | 00:00:00 | ||
Product Summary: Introduction | 00:00:00 | ||
Product Summary: Scatter Plot | 00:00:00 | ||
Product Summary: Tree Diagram | 00:00:00 | ||
Employee Summary: Introduction | 00:00:00 | ||
Employee Summary: Combination Chart | 00:00:00 | ||
Employee Summary: Stacked Column Chart | 00:00:00 | ||
Employee Summary: Waterfall Chart | 00:00:00 | ||
Employee Summary: Optional- Donut Chart | 00:00:00 | ||
Section 5 - Sharing And Publishing Power BI | |||
Introduction To Sharing And Publishing Dashboards | 00:00:00 | ||
Building Dashboards In Myworkspace | 00:00:00 | ||
Refreshing Data Sources | 00:00:00 | ||
The Benefits Of Reports | 00:00:00 | ||
The Power BI Community | 00:00:00 | ||
Pinning A Dashboard | 00:00:00 | ||
Sharing Your Dashboard | 00:00:00 |