Microsoft Power BI 2016/2019 Fundamentals

COURSE OUTLINE:

Course Description

Overview:As technology progresses and becomes more interwoven with our businesses and lives, more data is collected about business and personal activities. This era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.The creation of data-backed visualizations is a key way data scientists, or any professional, can explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources, and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action.Course Objectives:In this course, you will explore and visualize data with Power BI.You will:

Analyze data with self-service BI.
Connect to data sources.
Perform advanced data modeling and shaping.
Visualize data with Power BI.
Enhance data analysis.
Model data with calculations.
Create interactive visualizations.

Target Student:

This course is designed for professionals in a variety of job roles who are currently using a desktop or web-based data-management tools such as Microsoft Excel or SQL Server reporting server to perform numerical or general data analysis. They are responsible for conducting data analysis and providing reports about their analysis and are looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.

Prerequisites:

To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets. To meet this prerequisite, you can take any one or more of the following Logical Operations courses:

Microsoft® Office Excel® 2016/2019: Part 1 (Desktop/Office 365™)
Microsoft® Office Excel® 2016/2019/365: Part 2
Using Google G Suite

Optionally, having experience with other data analytics tools, such as Google Analytics™ or Customer Relationship Management (CRM) tools, as well as an understanding of database design concepts and basic programming constructs such as looping and branching, will help you get even more out of this course. The following courses are helpful but not required:

Google Analytics™: Foundation (Second Edition)
Database Design: A Modern Approach
Microsoft® Office Excel® 2016/2019: Data Analysis with Power Pivot

Course Content

Lesson 1: Analyzing Data with Self-Service BI

Topic A: Data Analysis and Visualization for Business Intelligence
Topic B: Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data

Topic A: Create Data Connections
Topic B: Model Data with Relationships
Topic C: Save Power BI Files

Lesson 3: Performing Advanced Data Modeling and Shaping

Topic A: Clean and Transform Data with the Query Editor
Topic B: Shape Data with the Query Editor
Topic C: Combine and Manage Data Rows

Lesson 4: Visualizing Data with Power BI

Topic A: Create Visualizations in Power BI
Topic B: Chart Data in Power BI

Lesson 5: Enhancing Data Analysis

Topic A: Enhance Analysis with Customized Visuals and Pages
Topic B: Enhance Analysis with Tooltips

Lesson 6: Modeling Data with Calculations

Topic A: Create Calculations with Data Analysis Expressions (DAX)
Topic B: Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualizations

Topic A: Create and Manage Data Hierarchies
Topic B: Filter and Slice Reports
Topic C: Create Dashboards in Power BI

RELATED COURSES

Database Training
SQL

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

Database Training
SQL

Developing Microsoft SQL Server 2014 Databases

In this course, you will be introduced to SQL Server, logical table design, indexing, query plans, and data and domain integrity. You will focus on creating database objects, including views, stored procedures, parameters, and functions. You will also learn procedure coding, such as indexes, concurrency, error handling, triggers, and SQL Common Language Runtime (CLR).

This course incorporates material from the Official Microsoft Learning Product 20464: Developing Microsoft SQL Server 2014 Databases. It covers the skills and knowledge measured by Exam 70-464 and along with on-the-job experience, helps you prepare for the exam.

Database Training
SQL

Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions

In this five-day instructor-led course, you will learn to design and maintainbusiness intelligence solutions for your organization using SQL Server 2008. Youwill learn how to use the SQL Server development tools to create AnalysisServices databases and OLAP cubes. In addition, you will learn to implementcomplete business intelligence solutions from design to development toproduction and, finally, end user analysis and reporting.

This course incorporates material from the Official Microsoft LearningProduct 6234: Implementing and Maintaining Microsoft SQL Server 2008 AnalysisServices.

Database Training
SQL

Designing a Data Solution with Microsoft SQL Server

In this course, you will learn to plan and implement enterprise database infrastructure solutions using Microsoft SQL Server 2012 and 2014. You will be introduced to Enterprise Data Architecture along with multi-server configuration management. You’ll then delve into database solutions including: consolidating database workloads, cloud data, Microsoft Azure services, high availability, clustering, AlwaysOn Availability, disaster recovery, and data replication.

This course incorporates material from the Official Microsoft Learning Product 20465 and covers the skills and knowledge measured by Exam 70-465: Designing Database Solutions for Microsoft SQL Server 2012 and, in conjunction with on-the-job experience, can help you prepare for the exam.