Microsoft Power BI - Data Analytics and Report Writing
The main purpose of the course is to give delegates a good understanding the power of Power BI to develop dashboards using large data sets.
Description
Microsoft Power BI is becoming the world’s most powerful self-service BI platform. This business analytical tool delivers insight into any organization and will give you the ability to drive and direct informed and agile business decisions. Power BI is the easiest to use data analysis, reporting and interactive tool. You can create your own dataset based on a single or multiple source and transform this data into professional-quality interactive dashboards.
Course Objectives
-
Learn Power BI Best Practice, Tips and Tricks
-
Understand Power BI Desktop and its components
-
Learn how to connect to different data sources using Query Editor
-
Learn how to work in different views of the Data Model
-
Learn to create calculated columns and measures
-
Learn to use the DAX Formula language to develop powerful calculations
-
Learn how to create a wide range of charts and visualizations
-
Learn how to create, modify and customize interactive dashboards, visualization and reports to convey specific business KPI and measures
How will this Training Course be Presented?
Live-Online
Prerequisites
-
Microsoft Power BI Desktop downloaded (free download) on a Window computer
-
You will need to know the basics of working with data in Excel
-
Basic understanding of data analysis is a plus but not required
-
No prior knowledge of Power BI required
Who is this Training Course for?
-
Anyone looking to pursue a career in data analysis or business intelligence
-
Data analysts and Excel users hoping to develop advanced data modelling, dashboard design and business intelligence skills
-
People who want to understand how to create customized visuals
-
All Excel users who work with data, reports and dashboards
-
Management Accountants who are required to report on transactional data sets
-
Marketing and Operational Analysts
-
Entrepreneurs / CEO /Accountants looking to master the Data Analysis process
-
Anyone wanting to transition into Business Analytics
The Course Content
Introducing Power BI Desktop
-
Understanding the Power BI tools
-
An Overview of the Workflow
-
Introducing the Different Views of the Data Model
An Introduction to the Query Editor (Extract, transform & Load)
-
What is the Query Editor
-
Looking at the Query Editor Interface
-
Types of Data Connectors
-
Transform basic tables
-
Formatting text, numbers and dates
-
Index and Conditional columns
-
Pivoting and unpivoting columns
-
Modifying, merging and appending queries
-
Query Editor and Power BI best practice
Working on the Data Model
-
Introduction to Database Normalization
-
FACT tables vs DIMENSION tables
-
Introducing and understanding relationships
-
Active vs Inactive Relationships
-
Understanding Cardinality
-
Star vs Snowflake Schemas
-
Connecting Multiple data tables
-
Cross filter selection and Many-to-many relationships
-
Hiding fields from the Report view
-
Data Modelling and Power BI best practices
Working with DAX
-
Introduction to DAX
-
DAX and calculated columns
-
DAX syntax and operators
-
Common Power BI functions
-
Date and Time intelligence formulas
-
Logical and Conditional Formulas
-
Text, Math and Stats functions
-
DAX and Power BI best practices
Working in Report View to Visualize our results
-
Introduction to Report View
-
Understand the Power View Interface
-
Adding basic charts
-
Formatting and filtering options
-
Matrix visuals
-
Slicers and Timelines
-
Creating Cards and KPI
-
Power BI Maps
-
Types of visualizations
-
Applying different filter types
-
Managing and Viewing roles
-
Data Visualization best practices