Discover how you can use Power BI to help your organization to become more data driven. Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this video shows you how to use Microsoft Power BI with confidence.
In this video, learn ways to import data from various sources as well as how to transform and cleanse data prior to loading it to a …
Discover how you can use Power BI to help your organization to become more data driven. Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this video shows you how to use Microsoft Power BI with confidence.
In this video, learn ways to import data from various sources as well as how to transform and cleanse data prior to loading it to a report-ready, self-service-enabled data model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using the various features in the Power BI service.
Using his years of experience teaching Power BI to a variety of learners, Microsoft Certified Trainer Chris Sorensen explains the core concepts of Power BI to expose you to the most widely used features and functions in Power BI. He carefully explains the “why” behind using those features, not just the “how.” In his engaging style grounded in real-world scenarios, Chris gives you the confidence to navigate and build effective Power BI solutions, quickly and effectively. Build good habits and develop in your career as a business analyst or data-driven business user.
Visit the author’s GitHub site to download companion files:
https://github.com/IterationInsights/Microsoft-Press-Introduction-to-Microsoft-Power-BI
.
About the Instructor
Chris Sorensen CPA, CGA, is the Founder and President of Iteration Insights, a tech-enabled data analytics solutions provider based in Calgary, Alberta. In his career, he has led numerous Analytics projects in more than 15 industries across small to enterprise-sized organizations.
He is a Microsoft Certified Data Analyst Associate and Microsoft Certified Trainer with a combined 20+ years of industry-solution delivery and teaching experience. He has evangelized both Excel and Power BI with Microsoft since July 2015 and is the author of the Microsoft Press Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel and co-author of Data Analysis Fundamentals with Excel (Video) published by Microsoft Press.
Skill Level
Organizations increasingly expect employees to deliver data-driven insights as part of their job. This is almost everyone in an organization, including:
Business users who need to level up their data knowledge and experience with business intelligence (BI) tools
Business analysts who need to work on end-to-end data analysis with Microsoft Power BI and develop best practices for building and sharing reports and visualizations
IT professionals or analysts who use Excel or other BI tools to analyze data and want to learn the foundations of how to deliver compelling, easy to maintain solutions using Power BI
Course Requirements
Introduction
Introduction to Microsoft Power BI: Introduction
Lesson 1: Getting started with Power BI
Learning objectives
1.1 Introduce the Data Lifecycle
1.2 Introduce the Power BI environment
1.3 Introduce Power BI licensing
1.4 Introduce Power BI release cycles
1.5 Set up your environment
Lesson 2: Importing and transforming data using Power Query Editor
Learning objectives
2.1 Navigate the Power Query Editor
2.2 Explore data sources
2.3 Load data from a website
2.4 Load data from files
2.5 Load a folder of data
2.6 Explore data source settings
2.7 Rename columns and set data types
2.8 Reduce rows
2.9 Manage columns
2.10 Append queries
2.11 Add columns
2.12 Merge queries
2.13 Transform and cleanse data
2.14 Organize and manage queries
Lesson 3: Building a Data Model to support self-service reporting
Learning objectives
3.1 Navigate the Power BI Desktop
3.2 Introduce Dimensional Modeling
3.3 Create relationships and manage settings
3.4 Modify column properties
3.5 Modify column formatting
3.6 Create hierarchies
3.7 Introduce DAX
3.8 Create basic DAX expressions
3.9 Understand contexts
3.10 Introduce time intelligence
3.11 Introduce CALCULATE
3.12 Introduce quick measures
3.13 Discuss data model cleanup
Lesson 4: Developing reports and visualizations using the Power BI Desktop
Learning objectives
4.1 Navigate the Power BI Desktop report view
4.2 Use a page background and theme
4.3 Create a clustered column chart
4.4 Create a funnel chart
4.5 Explore drill through
4.6 Create a line chart
4.7 Explore drill down
4.8 Create a card and KPI visualization
4.9 Create slicers
4.10 Explore the filter pane
4.11 Edit interactions between visuals
4.12 Create bookmarks
4.13 Explore the structure of a pbix file
Lesson 5: Enhancing the experience in the Power BI Service
Learning objectives
5.1 Publish to my workspace
5.2 Explore the Power BI Service
5.3 Create a report in the Power BI Service
5.4 Build a dashboard
5.5 Explore Power BI Mobile
5.6 Configure tiles
5.7 Use quick insights
5.8 Setup and use Q
5.9 Set alerts on a tile
Lesson 6: Securing, Sharing and Collaborating using the Power BI Service
Learning objectives
6.1 Share dashboards and reports
6.2 Explore comments in reports and dashboards
6.3 Setup row level security
Summary
Introduction to Microsoft Power BI: Summary