Microsoft Training

Excel Power BI

pexels-emiliano-arano-1312488

Learn-Excel Power BI

Microsoft Power BI Fundamentals

2-DAY CLASS

LENGTH 14 HOUR CLASS TIME

Microsoft® Power Bi (Business Intelligence) “is a business analytics solution that lets you visualize your data
and share insights across your organization, or embed them in your app or website.” The solution comprises
several products and services, and value and versatility come from leveraging the individual elements, and
taking advantage of how they work together.
Upon completion of this course, you will be able to:

• Understand the differences between Power Bi and Excel
• Data model using DAX
• Enhance your reports and dashboards

Who Needs This?

7 reasons to use Power BI

How do you know whether Microsoft Power BI is right for you? Here are seven reasons to choose Power Bi:

1. A quick start. You’ll be able to get insights quickly with an uncomplicated setup, no required training,and included dashboards for services such as Sal esforce, Google Analytics, and Microsoft Dynamics.

2. Streamlined publication and distribution. Instead of emailing large files or putting them on a shared drive, analysts upload reports and visualizations to the Power BI service, and their data is refreshed whenever the underlying dataset is updated.

3. Real-time information. Dashboards update in real time, as data is pushed or streamed in, which gives viewers the ability to solve problems and identify opportunities quickly. Any report or dashboard can display and update real-time data and visuals. Sources of streaming data can be factory sensors, social media sources, or anything from which time-sensitive data can be collected or transmitted.

4. Ability to customize Power BI app navigation. An “app navigation experiences” feature gives report developers the power to customize navigation to help viewers find content quickly and understand the relationships between different reports and dashboards.

5. Ability to customize security features. Report developers can set up row-level security (RLS) access filters to ensure that viewers see only data relevant to them, mitigating the risk of people seeing data they shouldn’t.

6. Cortana integration. Power BI works with Microsoft’s digital assistant, Cortana. Users can verbally ask questions in natural language to access charts and graphs. This can be especially helpful for users with mobile devices.

7. Artificial Intelligence. Power BI users can access image recognition and text analytics, create machine learning models, and integrate with Azure Machine Learning.

Prerequisites:     

The prerequisites for this course are a solid working knowledge of Windows and the use of a keyboard and mouse. It is also essential that you understand the advanced concepts related to data integration and Excel concepts

Classroom Outline:


DATA ANALYSIS WITH POWER BI
•Defining BI / Data Analysis / Visualization
•Power BI Desktop

•Excel vs Power BI
•Power BI Interface

CONNECTING TO YOUR DATA
•Navigator Window
•Importing vs Live Connection

•Relationship Types
•Cross Filter Direction

TRANSFORMING YOUR DATA
•Data View to Transform
•Power Query Editor
•Close & Apply vs Saving

•Combining Queries
•Adv Editor & M Language

DATA MODELING WITH DAX
•What is DAX
•Formula Bar
•DAX Error Checking

•Calculated Columns vs Measures
•Table Unions

VISUALIZATIONS FOR YOUR REPORTS
•Visualizations, Filters & Fields Pane
•Types of Visuals

•Microsoft Marketplace
•Enhancing Your Reports / Dashboards

INTERACTIVE VISUALIZATIONS
•Hierarchies
•Filters & Slicers

•Drill Through Filters

PUBLISHING TO THE POWER BI WEB APP
•Using Workspaces •Power BI Mobil App

This outline is a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.