Overview
Power BI is a powerful, Business Intelligence (BI) tool from Microsoft. Power BI is perfect for people with a limited technical background as it allows you to perform complex analyses in just a few clicks.
The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient in using Power Query and writing expressions by using DAX.
Certification
Program participants who successfully complete the course are issued a certificate of Completion from Global institute of Projects Management & Development – GIPMD
Curriculum
- 18 Sections
- 122 Lessons
- 18 Hours
- Creating and formatting a table visualization5
- Formatting our first visualization10
- 3.1• The New Format Pane
- 3.2• Formatting font and font size
- 3.3• Formatting colors
- 3.4• Stylistic options
- 3.5• Position visuals
- 3.6• Align visuals
- 3.7• Format Painter
- 3.8• Configuring summarization, both default and in a specific visualization
- 3.9• Changing number and date formatting
- 3.10• Custom number and date formatting
- Creating different visualizations: Matrices and bar charts7
- 4.1• Matrix
- 4.2• Drill down data, see data and records, and export data
- 4.3• Stacked bar charts and switch theme for reports
- 4.4• Bar Chart formatting, including continuous versus categorical axes
- 4.5• Configure interactions between visual (Edit interactions)
- 4.6• Clustered and 100% Stacked bar charts
- 4.7• Line and area charts, including 8b. Configure duplicate pages
- Adding more control to your visualizations11
- 5.1• Adding Text boxes, Images and Shapes
- 5.2• Visual level, page level and report level filters – basic filters
- 5.3• Advanced Filtering
- 5.4• Filter Top N Items
- 5.5• Slicer
- 5.6• Sort visuals
- 5.7• Configure small multiples
- 5.8• Use Bookmarks for reports
- 5.9• Group and layer visuals by using the Selection pane
- 5.10• Buttons and Actions
- 5.11• Tool tip Pages
- Other visualizations7
- Mapping6
- Measure performance by using KPIs, gauges and cards4
- Other Visualization Items for the exam11
- 9.1• Define quick measures
- 9.2• Export report data
- 9.3• Create reference lines by using Analytics pane, including the Forecast feature
- 9.4• Identify outliers
- 9.5• Use clustering
- 9.6• Use Anomaly Detection
- 9.7• Use groupings and binning’s
- 9.8• Use the AI Visual Key Influencers to explore dimensional variances
- 9.9• Use the Analyze feature in Power BI
- 9.10• Use the AI Visual decomposition tree visual to break down a measure
- 9.11• Creating a paginated report
- Additional Visualize and Analyze the Data5
- Get and Transform Data10
- 11.1• Welcome to Level 2: Get and Transform Data
- 11.2• Introduction – let’s Get some more Data
- 11.3• Exploring the Power Query Editor interface • Introducing the M language
- 11.4• Introducing the M language
- 11.5• Let’s start look at the home tab
- 11.6• Home menu – Manage Columns
- 11.7• Home menu – Reduce Rows and Use First Row as Headers
- 11.8• Sort and Filter
- 11.9• Split Column
- 11.10• Other Transform activities
- Getting Multiple files5
- Transform Menu4
- Transform - Text and Numbers6
- 14.1• Transform/Add Column – Text – Format
- 14.2• Transform/Add Column – Text – Merge Columns
- 14.3• Transform/Add Column – Text – Extract
- 14.4• Transform/Add Column – Text – Parse
- 14.5• Transform/Add Column – Number Column – Statistics and Standard
- 14.6• Transform/Add Column – Other Number Column functions
- Transform - Dates and Time5
- Add Columns, View and Help Menus6
- View and Help menus and advanced functionality6
- Get other types of data.9
- 18.1• Introduction to SQL Server
- 18.2• Importing database data into Power BI, and Query Folding
- 18.3• Select a storage mode
- 18.4• Expanding multiple tables in SQL Server
- 18.5• Importing data from SQL Server Analysis Services (SSAS)
- 18.6• Setting up Azure SQL Database
- 18.7• Using Azure SQL Database in Power BI
- 18.8• Use the Microsoft Data verse
- 18.9• Configure data loading
- Additional Get and Transform5
