Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
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.
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.
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
Live-Online
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
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
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