Power BI Corporate Training
Turn your data
into meaningful
business insights.
Our trainers have over a decade of experience in data analysis & data visualization. We provide hands-on effective training with real time examples, which boost employee productivity to next level. We conduct interactive and instructor-led Microsoft Power BI Corporate In-house Training & Online Training.
Power BI Training for Corporate & Professionals:
Our Power Bi training course will provides an in-depth knowledge to Microsoft’s Power BI Desktop. Participants will learn to use the Power BI Desktop and Power BI online service to import, analyze, and visualize business data, and share with business users. Topics include an exploration of the evolution of relational databases, data warehouse and business intelligence; importing and combining data from diverse data sources; shaping and transforming data; modeling data; developing useful and insightful visualizations; creating and sharing reports and dashboards in the Power BI service; collaborating in the Power BI service; and Data Analysis Expressions (DAX).
Enquiry For Power BI Corporate Training: +91-8838 666 078
POWER BI TRAINING COURSE OUTLINE
LESSON 1: GETTING STARTED WITH POWER BI DESKTOP
- Introduction to Self-Service BI
- Introduction Power BI Desktop
- Power BI Workflow
- Power BI Architecture
- Power BI Services
- Power BI Components
- Visualizations, Filters & Fields Pane
LESSON 2: CONNECTING TO DATA SOURCES WITH POWER BI DESKTOP
- Data Sources Power BI Desktop will connect to
- On-Premises Data FilesDatabases
- Online Databases
- Software as a Service (SaaS) Providers
- Internet Data
- Data Types and Properties in Power BI Desktop
- Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Use Append Queries
- Merge Data Tables
- Working with Relationships in Data
LESSON 3: QUERYING AND SHAPING THE DATA
- Activities using Query Editor
- Filters
- Clean, Trim, Format and Replace
- Split Column or Extract Using Delimiters
- Column from Example
- UnPivot
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions and Formula
LESSON 4: DATA VISUALIZATIONS
- Overview of Data Visualizations
- Tables and Matrix Views
- Charts
- Bar/Column Charts
- Clustered
- Stacked
- 100% Stacked
- Ribbon Charts
- Waterfall Charts
- Line Chart
- Scatter Chart
- Area Charts
- Line-and-Column Charts
- Pie Charts
- Donut charts
- Map Charts
- Funnel Chart
- Gauge Chart
- Card Chart
- Multi-Row Card
- Tree Maps
- Charts from Marketplace
- Aster Plot
- Bullet Plot
- Chord
- Histogram
- Stream Graph
- Tornado
- Sankey
- Chart Formatting
- Sort Visuals by Values/Fields
- Inserting Text Box, Shapes & Images
- Applying Conditional Formatting
- Color Scale
- Rules
- By Field Values
- Icon Set
- Interactive Slicers
- Date Slicers – dropdowns and searches
- Number Slicers with value ranges
- Date Slicers with Relative filters
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in Visualizations
- Analytics Lines in Visualizations
- Forecast
- DAX
- Calculated Columns
- FORMAT
- REALTED
- DATEVALUE
- Create Measures
- SUM, COUNT, MAX, MIN
- COUNTROWS, DIVIDE
- DISTINCT COUNT
- SUMX, COUNTX, AVERAGEX
- CALCUATE
- IF ELSE
- AND, OR, NOT
- FILTER
- TIME SERIES FORMULAS
- Create a KPI Visualization
- Drill Visualizations to see underlying Data
- Visual Table and Data Point Table
- Date Hierarchies
- Q&A
- Decomposition Tree
- Data Categories, Geo-Data and Maps
LESSON 5: REPORTS AND OUTPUT OPTIONS
- Report Elements and Options
- Working with Pages
- Visual and Filter Settings
- Edit Interactions
- Bookmarks
- Synchronize Slicer
- Report Themes
- Buttons and Q&A
LESSON 6: PUBLISH & SHARING REPORTS
- Publish Report from Power Desktop
- Understanding Dashboards, Tiles, Reports, Datasets, workbooks
- Creating Dashboard
- Pinning Tiles to Dashboard
- Sharing Reports & Dashboards
- Publish Reports to Web
- Print or Save as PDF
- Exporting to Powerpoint
- Export Data from Visualization
- Refreshing Data Sets.