COURSE OVERVIEWPower BI is the newest Microsoft Business
Intelligence and Data Analysis tool. In this module we will go through
basics of this product, and introduce all five components of Power BI
(Power Query, Power Pivot, Power View, Power Map, and Power Q&A).
You will see some demos and introduction about Power BI desktop,
Office 365 Power BI subscription, and Power BI website, and mobile
apps. You will see some basic demos of how easy to use is Power BI in
some scenarios.
TARGET AUDIENCE:
The Power BI training is for all the professionals who are passionate
about business intelligence, data visualization, and data analytics.
*
Business Analysts
*
Business Intelligence Manager
*
Statisticians and Analysts
*
Data Scientists
*
Project Managers
LEARNING OBJECTIVES:
*
Understand primary features of a self-service Power BI solution
*
Utilize Power BI and its data sources
*
Combine, analyze, model, shape, and visualize data
*
Report data using rich dashboards
PREREQUISITES:
There are no prerequisites for this course.
COURSE MATERIALS:
Students will receive a course manual with presentation slides and
reference materials.
EXAMINATION:
No Exam
TECHNICAL REQUIREMENTS:
For eBooks:
Internet for downloading the eBook
Laptop, tablet, Smartphone, eReader (No Kindle)
Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)
eBook download and activation instructions
AGENDA:
MODULE 1: INTRODUCTION TO POWER BI
Power BI is the newest Microsoft Business Intelligence and Data
Analysis tool. In this module we will go through basics of this
product, and introduce all five components of Power BI (Power Query,
Power Pivot, Power View, Power Map, and Power Q&A). You will see some
demos and introduction about Power BI desktop, Office 365 Power BI
subscription, and Power BI website, and mobile apps. You will see some
basic demos of how easy to use is Power BI in some scenarios.
MODULE 2: GETTING DATA
Getting Data is the first experience of working with Power BI. You can
connect to many data sources on-premises or on cloud. For some data
sources you can have a live or direct connection, for some connection
works offline. For some connections you need a gateway or connector to
be installed. In this module you will learn everything about get data
experience of Power BI.
MODULE 3: POWER QUERY FOR DATA TRANSFORMATION
Data analysis and BI world starts from data extraction and
transformation. Power Query is the data transformation engine of Power
BI. Power Query comes as part of Excel 2016, or as an add-in for Excel
2013 and 2010. Power Query is also part of Power BI Desktop. In this
module you will learn about all different version of Power Query,
their similarities, and differences, as well as configuration and
requirements of using them.
Power Query uses a graphical user interface to apply transformations
on the dataset. However Power Query works with a functional scripting
language behind the scenes. The key to learn Power Query is learning
the functional language called M. There are many features in M that
are not available in the Power Query GUI. In this module you will
learn how to understand M, and how to write M scripts even from
scratch. You will learn writing custom functions in M as well as many
other useful features.
MODULE 4: POWER PIVOT FOR DATA MODELLING
Power Pivot is xVelocity in-memory data modelling engine of the Power
BI. Modelling effectively is the key of high performance BI solution.
In this module you will learn basics of Power Pivot such as creating
relationships, and calculated members, as well as advanced best
practices and DAX expressions. DAX is Data Analytical eXpression
language. DAX has similar structure to excel functions, but it is
different. In this module you will learn DAX from beginner to advance.
You will learn basic functions as well as complex functions and
scenarios of using them in real world challenges.
MODULE 5: DATA VISUALIZATION WITH POWER BI DESKTOP, POWER VIEW AND
POWER MAP
Data Visualization is the front end of any BI application, this is the
user view point of your system. It is critical to visualize measures,
and dimensions effectively so the BI system could tell the story of
the data clearly. In this module you will learn conceptual best
practices of data visualizations which is valid through all data
visualization tools. You will learn Power View and Power Map skills.
Power View is the interactive data visualization tool and Power Map is
3D geo-spatial data visualization tool. You will learn how to create
effective charts, and dashboards using these tools as well as best
practices for working with these tools. There are two version of Power
View; Power View for Excel, and Power View for SharePoint which will
be covered in this module as well.
MODULE 6: DESIGNING THE BEST SOLUTION WITH POWER Q&A
Power BI introduced a new engine for users which focus on users who
wants to play with the data more, and understand the story behind the
data better. Power Q&A is question and answering engine which works
based on human natural language. Power Q&A automatically will be
enabled on Power BI files deployed into Power BI website, or Office
365 subscription. However there are some tips and tricks about how to
design your model to get the best type of answers through Power Q&A.
In this module you will learn best practices for modelling that effect
on the response of Power Q&A.
MODULE 7: POWER BI DESKTOP; COMBINATION OF THREE TOOLS
Power BI Desktop (Previously was known as Power BI Designer) is the
new designer tool that enhance combination of three main Power BI
components; Power Query, Power Pivot, and Power View. Power BI Desktop
has great features that will be fully explored in this module. There
is slightly difference from components of Power BI desktop with their
original versions; in this module you will learn these differences.
You will learn how to use Power BI desktop to mash up data, model it,
and visualize it. Best practices of design will be all discussed with
demos.
MODULE 8: ADMINISTRATION
Power BI components can be deployed into different environments such
as Power BI website, Office 365 subscription, or even SharePoint
on-premises. In this module we will go through deployment options,
Configurations and requirements required for each environment. You
will learn how to deploy your Power BI files into Power BI website.
you will also learn how to build dashboards in the website, and how to
work with Mobile Apps for Apple, Android and Windows Phone.
culture
sports
5869
Views
06/06/2020 Last update