Power BI

Course Description

Enter the world of data visualization and analytics with the PCS Fusion HUB Training Institute in Hyderabad. Our Power Business Intelligence  Training Program is meticulously designed to equip individuals with the skills and knowledge required to harness the power of Microsoft Power Business Intelligence. Whether you are a data enthusiast, business analyst, or IT professional, this course offers a comprehensive exploration of Power Business Intelligence’s capabilities for data analysis and visualization.

Course Highlights:

In-Depth Curriculum:Our training program covers the entire Power Business Intelligence ecosystem, including data modeling, report creation, dashboard design, data transformation, and integration with other data sources.

Expert Instructors: Learn from experienced Power Business Intelligence experts who provide practical insights, real-world examples, and best practices in data analysis and visualization.

Hands-On Learning: Engage in hands-on exercises, real-world data projects, and interactive labs to gain practical experience in data analysis and visualization.

Customization: Tailor your learning journey to match your career objectives, focusing on the aspects of Power Business Intelligence most relevant to your role or organization’s requirements.

Certification Preparation: Prepare for Microsoft Power Business Intelligence certification exams, validating your expertise and enhancing your career prospects in data analytics.

Data-Driven Decision-Making: Learn how to transform raw data into actionable insights, enabling data-driven decision-making within your organization.

Join us at PCS Fusion HUB Training Institute in Hyderabad, where knowledge meets data, and embark on a journey to become a proficient Power Business Intelligence user, capable of transforming data into meaningful visualizations that drive business success.

Course Content

Module 1 – Introduction to Power BI

In the first module of this Power Business Intelligence course, you will learn the basics of Power Business Intelligence

• Introduction to business intelligence (BI)
• Stages of business intelligence (BI)
• Use cases of BI
• Various BI tools
• Overview of data warehouse and 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 to Architecture of Power BI 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

In the second module of this Power Business Intelligence certification, you will learn the basics of 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 and 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 and 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 and 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 and sorting of data
• Detect data type, count rows, and reverse rows
• Promote rows as column headers
• Hierarchies in Power BI
• M query

Module 4 – Data Modelling and DAX

• Introduction to relationships
• Creating relationships
• Cardinality
• Cross-filter direction
• Use of inactive relationships
• Introduction of DAX
• Why is DAX 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 Business Intelligence data visualization
• Understanding Power View and Power Map
• Data visualization techniques
• Page layout and formatting
• Power Business Intelligence Desktop visualization
• Formatting and customizing visuals
• Visualization interaction
• Custom visualization in Power Business Intelligence
• 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 Business Intelligence template for design reusability
• Mastering the best practices
• Performance analyzer in Power Business Intelligence for monitoring performance of report
• Power Business Intelligence Q&A (Natural Language Query visual)
• Sync slicers
• Tooltips and custom tooltips
• Tables and 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 BI service
• Introduction of workspaces
• Dashboard
• Creating and configuring dashboards
• Dashboard theme
• Reports vs Dashboards
• Building workspace apps
• Sharing reports and 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 BI service
• Collaboration using BI service
• Row level security (RLS)
• Introduction of paginated reports
• Introduction of BI report server

Module 7 – Power BI Settings, Administration, and Direct Connectivity

• Understanding BI desktop settings
• Aggregating data from multiple data sources
• BI service settings
• BI admin portal
• Administration activities
• BI usage analysis
• Introduction of Office 365 admin activities
• Introduction of Data Gateway
• Installation and configuration of data gateways
• Scheduling auto data refresh
• Managing groups, row-level security, datasets, reports, and dashboards
• Real-time data analysis using direct connectivity
• Direct query vs import mode

Module 8 – Embedded Power BI with API and Power BI Mobile

• Introduction to embedded BI
• Create embedded code
• Manage embedded code
• Integration of BI in SharePoint
• Introduction of BI API
• BI embedded playground
• Introduction to BI Mobile
• Creating mobile-based reports and dashboards
• Optimizing report for BI mobile app
• Features of BI mobile app
• Introduction of integrating BI & Excel
• BI Analyze in Excel

Module 9 – Power BI Advance and Power BI Premium

Coming to the last module of this BI certification course, you will learn advanced BI and BI Premium.

• Introduction to BI Premium
• BI Premium per user
• BI Premium features
• Introduction to Data Flow
• Create data flow
• Advantages of data flow
• Create reports using data flow
• Introduction to BI deployment pipelines
• Create deployment pipelines
• Benefits of deployment pipelines
• Introduction of sensitivity labels
• Incremental data load in BI
• Use AI visuals
• Use the Forecast feature
• BI best practice rules to improve performance

Course Audience

Any Degree

Training Hours

• 7 am to 8 am
• 8 am to 9 am
• 6 pm to 9 pm