Power BI Certification Training Course
4.6 /5- Offered byIntellipaat
Power BI Certification Training Course at Intellipaat Overview
Duration | 24 hours |
Total fee | ₹24,463 |
Mode of learning | Online |
Credential | Certificate |
Power BI Certification Training Course at Intellipaat Highlights
- Earn a certificate of completion from Intellipaat
- 30 Hours Project & Exercises
- Get job assistance after the program
- Get one to one doubt resolution sessions
- Gain expertise on skills like Connecting to data, Transforming data, Creating a data model, Working with DAX, Visualizing data
Power BI Certification Training Course at Intellipaat Course details
- For Individuals looking for jobs as Business Analysts, Business Development Managers, etc.
- For Statisticians aiming to implement their statistics skills to derive business insights.
- For Marketing, finance, sales, and other domain professionals who need extensive Business Intelligence can get this Power BI certification
- 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
- 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
- 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
- This course provides the facility to learn from Industry practitioners through online Power BI training and master Power BI architecture, Desktop, Service, Mobile Apps, visualizations & reports
- You will work on multiple real-life projects through our Power BI course and receive an e-book from Microsoft for Power BI that will help you crack the PL-300 Microsoft Power BI Data Analyst exam
- Upon the completion of this Power BI online course, you can start using this BI tool, to extract data from multiple unrelated sources
Power BI Certification Training Course at Intellipaat Curriculum
Module 1 - Introduction to Power BI
Introduction to Business Intelligence (BI)
Stages of business intelligence (BI)
Use cases of BI
Various BI tools
Overview of Data warehouse & concepts
Introduction to Power BI
Why Power BI
Power BI Components
Power BI pricing structure
Building blocks of Power BI
Architecture of Power BI
Power BI vs Tableau vs QlikView
Introduction of Power BI Desktop
Installation of Power BI Desktop
The key features of Power BI workflow
Process of creating reports in Power BI
Module 2 - Data Extraction
Overview of Power BI desktop
Data sources in Power BI
Using files (excel, pdf, csv, etc.) as a data source
Using SaaS connectors
Extracting data from folders, and databases
Working with Azure SQL database and database sources
Connecting to Analysis Services
Other data sources (OData, web, SharePoint etc.)
Python & R script in Power BI
Introduction of power query editor
Advance editor
Query dependency editor
Module 3 - Data Transformation ? Shaping & Combining Data
Shaping data using Power Query Editor
Formatting data
Transformation of data
Understanding of Data types
Data profiling for data quality check
Naming conventions & best practices to consider
Identify and create appropriate keys for joins
Working with Parameters
Merge Query
Append Query
Group by of data (aggregation of data)
Applied steps (query settings)
Duplicate & Reference tables
Transpose of data
Fill
Pivot & Un-pivot of data
Custom columns
Conditional columns
Replace data from the tables
Split columns values
Move columns & sorting of data
Detect data type, count rows & reverse rows
Promote rows as column headers
Hierarchies in Power BI
M query
Module 4 - Data Modelling & Dax
Introduction of relationships
Creating relationships
Cardinality
Cross filter direction
Use of inactive relationships
Introduction of DAX
Why DAX is used
DAX syntax
DAX functions
Context in DAX
Calculated columns using DAX
Measures using DAX
Calculated tables using DAX
Learning about table, information, logical, text, iterator,
Time intelligence functions (YTD, QTD, MTD)
Cumulative values, calculated tables, and ranking and rank over groups
Date and time functions
identify poorly performing measures, relationships, and visuals
DAX advanced features
Module 5 - Data Visualization With Analytics
Deep dive into Power BI data visualization
Understanding Power View and Power Map
Data visualization techniques
Page layout & Formatting
Power BI Desktop visualization
Formatting and customizing visuals
Visualization interaction
Custom visualization in Power BI
Top-down and bottom-up analytics
Drill down
Drill through
Page navigations
Bookmarks
Selection pane to show/hide visuals
Comparing volume and value-based analytics
Combinations charts (dual axis charts)
Filter pane
Slicers
Use of Hierarchies in drill down analysis
Theme for corporate standards
Power BI template for design reusability
Mastering the best practices
Performance analyzer in Power BI for monitoring performance of report
Power BI Q&A (Natural Language Query visual)
Sync slicers
Tooltips & custom tooltips
Tables & matrix
Conditional formatting on visuals
Waterfall chart, KPI, Donut chart, Scatter chart
Geographical data visualization using Maps
Module 6 - Power Bi Service (Cloud), Q & A And Data Insights
Introduction to Power BI Service
Introduction of workspaces
Dashboard
Creating & Configuring Dashboards
Dashboard theme
Reports vs Dashboards
Building workspace Apps
Sharing reports & dashboards
configure subscriptions and data alerts
Paginated report
Introduction to Power Q & A
Ask questions about your data using Natural Query Language
Getting answers in the form of charts, graphs, and data discovery methodologies
Configure custom questions for Q&A like FAQ
Ad-hoc analytics building
Power Q&A best practices
Quick Insights
Subscribe, Alerts, Usage statics, Related content
Design reports on Power BI Service
Collaboration using Power BI Service
Row Level Security (RLS)
Introduction of Paginated Reports
Introduction of Power BI Report Server
Other courses offered by Intellipaat
Student Forum
Anything you would want to ask experts?