Data Analysis and Visualization in Power BI
This course includes:
- Downloadable Resources
- Certificate of completion
Our Data Analysis & Visualization in Power BI course is accredited by NITA
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.