- Understand Data Extraction
- Power BI Service Q & A and Data Insights
- Embedded Power BI with API & Power BI Mobile
- Understand Advance and Power BI Premium
- Use Salesforce Data, Azure SQL Database, and SQL Server analysis tabular data
- Deploy content packs to work with QuickBooks online and Adobe Analytics
- Work on live projects to get hands-on experience.
- An in-depth understanding of this BI tool and how it works in different scenarios
- Three vital components: Power BI Service, Desktop and Mobile Apps
- Visualize and analyze data and derive insights from Excel spreadsheets or local databases
- Create compelling reports and visualizations, derive real-time insights, and deploy them on demand
- Create, share, collaborate, and benefit from business information with purpose-built dashboards
- Get the work done without being a Business Intelligence professional
Description:
About Workday Power BI?
Power BI is a radically new tool in the hands of business enterprises who are overwhelmed with the amount of data at hand and until now did not have a cost-effective tool to extract insights from it. Upon the completion of this Power BI online course, as a trained professional, you can start using this BI tool, which is a set of tools and applications that let you extract data from multiple unrelated sources and convert it into a neatly managed and coherent set of information, visually appealing insights, interactive data, charts, graphs, and reports, etc. Further, you will get official training material issued by Microsoft for Analyzing Data with Power BI
Who should Learn Power BI?
- Marketing, finance, sales, and other domain professionals who need extensive Business Intelligence
- Statisticians aiming to implement their statistics skills to derive business insights
- Individuals looking for jobs as Business Analysts, Business Development Managers, etc.
- Graduates and Professionals looking to move to Workday Advanced Compensation
- Functional Lead
- Workday Administrators
- Executives
- Generalists
- Managers and Employees
- Project Managers
- IT Experts
- Freshers Generalists.
- IT Professionals.
- Leads.
- Managers and Employees.
- Project Managers.
Requirements:
You do not need any prior knowledge to benefit from this Microsoft Power BI online training.
Total: 38 Courses View all
Power BI Course Demo Video
Power BI Course Course Curriculum
1 Introduction to Business Intelligence (BI)
2 Stages of business intelligence (BI)
3 Use cases of BI
4 Various BI tools
5 Overview of Data warehouse & concepts
6 Introduction to Power BI
7 Why Power BI
8 Power BI Components
9 Power BI pricing structure
10 Building blocks of Power BI
11 Architecture of Power BI
12 Power BI vs Tableau vs QlikView
13 Introduction of Power BI Desktop
14 Installation of Power BI Desktop
15 The key features of Power BI workflow
16 Process of creating reports in Power BI
1 Overview of Power BI desktop
2 Data sources in Power BI
3 Using files (excel, pdf, csv, etc.) as a data source
4 Using SaaS connectors
5 Extracting data from folders, and databases
6 Working with Azure SQL database and database sources
7 Connecting to Analysis Services
8 Other data sources (OData, web, SharePoint etc.)
9 Python & R script in Power BI
10 Introduction of power query editor
11 Advance editor
12 Query dependency editor
1 Deep dive into Power BI data visualization
2 Understanding Power View and Power Map
3 Data visualization techniques
4 Page layout & Formatting
5 Power BI Desktop visualization
6 Formatting and customizing visuals
7 Visualization interaction
8 Custom visualization in Power BI
9 Top-down and bottom-up analytics
10 Drill down
11 Drill through
12 Page navigations
13 Bookmarks
14 Selection pane to show/hide visuals
15 Comparing volume and value-based analytics
16 Combinations charts (dual axis charts)
17 Filter pane
18 Slicers
19 Use of Hierarchies in drill down analysis
20 Theme for corporate standards
21 Power BI template for design reusability
22 Mastering the best practices
23 Performance analyzer in Power BI for monitoring performance of report
24 Power BI Q&A (Natural Language Query visual)
25 Sync slicers
26 Tooltips & custom tooltips
27 Tables & matrix
28 Conditional formatting on visuals
29 Waterfall chart, KPI, Donut chart, Scatter chart
30 Geographical data visualization using Maps
1 Shaping data using Power Query Editor
2 Formatting data
3 Transformation of data
4 Understanding of Data types
5 Data profiling for data quality check
6 Naming conventions & best practices to consider
7 Working with Parameters
8 Merge Query
9 Append Query
10 Group by of data (aggregation of data)
11 Applied steps (query settings)
12 Duplicate & Reference tables
13 Transpose of data
14 Fill
15 Pivot & Un-pivot of data
16 Custom columns
17 Conditional columns
18 Replace data from the tables
19 Split columns values
20 Move columns & sorting of data
21 Detect data type, count rows & reverse rows
22 Promote rows as column headers
23 Hierarchies in Power BI
24 M query
1 Introduction to Power BI Service
2 Introduction of workspaces
3 Dashboard
4 Creating & Configuring Dashboards
5 Dashboard theme
6 Reports vs Dashboards
7 Building workspace Apps
8 Sharing reports & dashboards
9 Introduction to Power Q & A
10 Ask questions about your data using Natural Query Language
11 Getting answers in the form of charts, graphs, and data discovery methodologies
12 Configure custom questions for Q&A like FAQ
13 Ad-hoc analytics building
14 Power Q&A best practices
15 Quick Insights
16 Subscribe, Alerts, Usage statics, Related content
17 Design reports on Power BI Service
18 Collaboration using Power BI Service
19 Row Level Security (RLS)
20 Introduction of Paginated Reports
21 Introduction of Power BI Report Server
1 Getting to understand Power BI Desktop settings
2 Aggregating data from multiple data sources
3 Power BI Service settings
4 Power BI Admin Portal
5 Administration activities
6 Power BI usage analysis
7 Introduction of Office 365 admin activities
8 Introduction of Data Gateway
9 Installation & Configuration of data gateways
10 Scheduling auto data refresh
11 Managing groups, row-level security, datasets, reports, and dashboards
12 Real time data analysis using Direct Connectivity
13 Direct Query vs Import Mode
1 Introduction to embedded Power BI
2 Create embedded code
3 Manage embedded code
4 Integration of Power BI in SharePoint
5 Introduction of Power BI API
6 Power BI Embedded playground
7 Introduction to Power BI Mobile
8 Creating mobile based reports & dashboards
9 Optimizing report for Power BI mobile app
10 Features of Power BI mobile app
11 Introduction of integrating Power BI & Excel
12 Power BI Analyze in Excel
1 Introduction of Power BI Premium
2 Power BI Premium per user
3 Power BI Premium features
4 Introduction to Data Flow
5 Create Data Flow
6 Advantages of Data Flow
7 Create reports using Data Flow
8 Introduction to Power BI Deployment Pipelines
9 Create Deployment Pipelines
10 Benefits of Deployment Pipelines
11 Introduction of Sensitivity Labels
12 Introduction of Power BI Goals feature
13 Incremental data load in Power BI
14 Power BI best practice rules to improve performance
1 Introduction of relationships
2 Creating relationships
3 Cardinality
4 Cross filter direction
5 Use of inactive relationships
6 Introduction of DAX
7 Why DAX is used
8 DAX syntax
9 DAX functions
10 Context in DAX
11 Calculated columns using DAX
12 Measures using DAX
13 Calculated tables using DAX
14 Learning about table, information, logical, text, iterator,
15 Time intelligence functions (YTD, QTD, MTD)
16 Cumulative values, calculated tables, and ranking and rank over groups
17 Date and time functions
18 DAX advanced features