Our classroom training provides you the opportunity to interact with
instructors and benefit from face-to-face instruction. Course Overview
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. 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
12
Views
14/12/2021 Last update