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
- 15 Sections
- 91 Lessons
- 18 Hours
- Creating a Data Model4
- An introduction to DAX functions, including Logical functions7
- Statistical functions3
- Mathematical functions5
- Text functions4
- Filter and Value Functions10
- Time Intelligence Functions10
- 8.1• Date and Time Functions
- 8.2• FIRSTDATE, LASTDATE
- 8.3• Start of… and End of…
- 8.4• Previous… and Next…
- 8.5• DATESINPERIOD
- 8.6• DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
- 8.7• Opening Balance and Closing Balance
- 8.8• Semi-additive Measures
- 8.9• SAMEPERIODLASTYEAR and PARALLELPERIOD
- 8.10• SAMEPERIODLASTYEAR and PARALLELPERIOD
- Other Modeling and DAX Topics for the exam7
- 9.1• Create calculated tables
- 9.2• Create a common date table
- 9.3• Define role-playing dimensions
- 9.4• Resolve many-to-many relationships – Joint Bank Accounts
- 9.5• Resolve many-to-many relationships – Different types of granularities
- 9.6• Improve cardinality levels through summarization and by changing data types
- 9.7• Identify poorly performing measures, relationships, and visuals
- An Introduction to the Power BI Service8
- 10.1• Welcome to Part 4: The Power BI Service
- 10.2• Introducing The Power BI Service
- 10.3• Logging into Power BI Service and a quick look around
- 10.4• Power BI Terminology
- 10.5• Datasets and Reports in the Power BI Service
- 10.6• Get Data – Other People’s Data
- 10.7• Get Data – Your Data
- 10.8• The Navigation Pane, including Add a Quick Insights result to a report
- Power BI Pro and adding users4
- Row and Object Level Security3
- Dashboards9
- 13.1• Differences between dashboards and reports
- 13.2• Manage Tiles on a Dashboard, Set Mobile View, and other Tiles options
- 13.3• Dashboards: Options
- 13.4• Configure Subscriptions
- 13.5• Pin a Live Report Page to a Dashboard
- 13.6• Use the Q&A Feature
- 13.7• Add a Dashboard Theme
- 13.8• Apply or Change Sensitivity Labels
- 13.9• Configure Data Alerts
- Manage datasets7
- 14.1• Analyze in Excel
- 14.2• Promote or Certify (Endorse) a Dataset
- 14.3• Manually Refreshing data in the Power BI Service
- 14.4• Data Gateways; Providing Access to Datasets
- 14.5• Configure a Dataset Scheduled Refresh
- 14.6• Configure Incremental Refresh Settings – Step 1
- 14.7• Configure Incremental Refresh Settings – Step 2
- Create and manage workspaces8
- 15.1• Create and Configure a Workspace
- 15.2• Assign Workspace Roles
- 15.3• Providing Access to Datasets
- 15.4• Configure and Update a Workspace App
- 15.5• Promote or certify Power BI report or app
- 15.6• Publish, Import or Update Assets in a Workspace – Publish securely
- 15.7• Publish reports on the web, so the public can see
- 15.8• Create and manage workspaces
- Other Power BI Service Topics•2
