Data Analysis and Visualization in Power BI

This course includes:

Our Data Analysis & Visualization in Power BI course is accredited by NITA

nita-logo

Course Information

Overview

Loaded with real-life business scenarios along with quizzes and projects to build, this course will
give you the solid understanding required to gain absolute control over your data and visualize it
aesthetically. We will not only train you how to design phenomenal dashboards, but we will also acquaint you with data modelling, data transformations, train you how to write DAX, configure calculated columns and measures, assign roles, and ultimately share your dashboards with your team or clients.

Delegates need to have good grounding on Excel Essentials concepts.

  • Power BI Overview
  • Power BI Data Sources
  • Shaping and Combining Data
  • Modelling data
  • Support time intelligence by extending databases
  • Interactive data visualizations
  • Publishing and sharing

Course Syllabus

• Introduction to Power BI and terminology
• Studying the Power BI suite of products
• Exploring the Power BI desktop interface
• Utilizing file types; pbix vs pbit
• Examining Power BI data sources
• Understanding Power BI workspaces
• Demo: sample Power BI dashboard
• Lab: creating a Power BI dashboard

• Connecting to files
• Using excel as a data source for Power BI
• Publishing to Power BI from excel
• Updating files in Power BI
• Data refresh
• The Power BI data model
• Managing data relationships
• Optimizing the model for reporting
• Creating hierarchies
• Using databases as a data source for Power BI
• Other data sources
• Configuring data for q&a
• Lab: importing data into Power BI

• Power bi desktop query editor
• Shaping data
• Formatting data
• Transforming data
• Combining data
• Lab: shaping and combining data

• Setting up and managing relationships
• Optimizing models for reporting
• Cardinality and cross filtering
• Data analysis expression language (dax) queries
• Calculated columns
• Calculated tables
• Calculated measures
• Using what if parameters
• Lab: modelling data

• Dax time intelligence support
• Dax time intelligence functions

• Creating Power BI reports
• Managing a Power BI solution
• Lab: creating a Power BI report
• Connecting to Power BI data
• Building Power BI reports
• Creating multiple interactive visualizations
• Creating a Power BI dashboard
• Lab: creating a Power BI dashboard

• Sharing options overview
• Creating menu navigations for dashboards
• Creating dynamic tiles
• Publishing from Power BI desktop
• Publishing reports to web
• Publishing to Microsoft SharePoint
• Sharing reports & dashboards (Power BI pro/premium)
• Configuring access to dashboards and app workspaces
• Configuring row level security (Power BI pro)
• Creating menu navigations for dashboards
• Lab: publishing reports and configuring security

Target Group

  • Everyone who deals with data
  • Power BI beginners
  • Analysts
  • Developers, IT Professionals, Solution
    Architects, Technical Specialists
  • Project Manager, Business
    Executives, C.I.O, C.T.O.

Expected Outcome

  • Use various techniques
    such as VLOOKUP and TEXT functions to manipulate data.
  • Present data summaries
    (reports) visually through
    charts and conditional
    formatting.
  • Use Pivot Tables to
    summarize large volumes of
    data.

or Call us

0716 568899

Fill out your contact details below so we can get in touch with you regarding your training requirements.