Training on Analyzing and Visualizing Data using Microsoft Power BI
Introduction
Data Visualization is the graphical representation of large datasets using graphs and charts such as bar charts, line graphs, scatterplots, etc. Learn how to elegantly present datasets that allow your audience to quickly digest, understand, and derive insights or see trends from the data. This course teaches students how to navigate the Microsoft Power BI software and to utilize this tool to create effective visualizations of datasets.
Course duration
5 days
What you will learn
By the end of this training the participants will be able to:
- Describe self-service BI.
- Describe the Power BI suite of products.
- Connect to data sources and optimize data models.
- Shape and combine data from different sources.
- Model data.
- Create reports and manage solutions.
- Model data with Power BI desktop
- Custom create data visualizations and style reports for lucid data representation
- Visualize data, author reports, and schedule automated refresh of your reports
- Create and share dashboards based on reports in Power BI desktop
- Share and collaborate with data with Power BI
- Understand Power BI Data Analysis Expression(DAX), and its functions
TOPICS TO BE COVERED
Overview of Power BI
- Components of Power BI
- Features of Power BI
- Power BI workflow
- Self Service ETL (Extract Transform Load)
- Setup and Configuration of Power BI
Connecting to Data Sources
- Excel
- Online sources
- SQL
Data Transformation
- Using first rows as headers
- Rename fields & replacing data values in cells, rows
- Changing data types & change order of columns
- Un-pivoting columns
- Grouping and splitting column into multiple
- extract feature (before /after delimiter)
- Adding new columns
- Filters and parameters
- View native queries vs unfold queries
Modeling
- Table relationship (one to one, one to many, many to many)
- Data Analysis Expression (DAX)
- Measures and calculated Columns
- Mastering DAX using quick measures
Visualization and Charts
- Stacked bar chart and stacked column chart
- Clustered bar chart and clustered column chart
- Line chart & area chart
- Line and clustered column chart
- Line and stacked column chart
- Ribbon & waterfall chart
- Funnel & tree map visuals
- Pie-chart and doughnut chart
- Table chart and matrix chart
- Slicer, gauge, card visuals
- Map and filled map
- ArcGIS maps for Power BI
- KPI
- Q & A visual
- Fine tune your visualization using parameters and slicers
- Deciding on when to use a particular visual
Building Dashboards
- Workspace
- Datasets
- Reports
- Create Dashboard
- Modify and update Dashboard
- Share your Dashboard
- Power Q&A and Insights
Data Security in Power BI
- Configuring row level security
- Setting up user roles
Configuring Data Refresh
- Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
- Understand & configure data management gateways
- Configuring & scheduling data refresh
Power BI for Mobile
- Configuring Power BI for Mobile
- Visualize dashboards and report on Power BI Mobile
- Commenting on eports and dashboards in Power BI Mobile
Excel Power BI
- Power Query and Power Pivot on Excel
- Visualize and Edit Power BI reports using excel analyzer
- Building reports on Excel and Publishing to Power BI service
Event Information
Event Date | 12-08-2024 |
Event End Date | 16-08-2024 |
Cut Off Date | 12-08-2024 |
Individual Price | $1,200.00 |