What is Power BI?
Power BI is Microsoft’s latest Business Intelligence (BI) and data visualisation and analytics tool that enables you to quickly develop stunning interactive dashboards that bring your data to life, and enable you to monitor your business on every device.
The free Power BI Desktop tool can get and model data from almost anywhere using the same Power Query and Power Pivot tools many Excel users will be familiar with. Then quickly create impressive interactive reports using the sophisticated charting and visualisation gallery. It also enables you to securely share your dashboards and reports with people inside and outside of your organisation with the online Power BI services or publish them to your website.
Who is it for?
This Power BI course is ideal for people who want to understand how to use this in demand Microsoft High-Tech tools and create customized visuals with Power BI developer tools. It is also suitable for Business Intelligence (BI) and reporting professionals, data analysts, and professionals working with data in any sector and any department.
Key Learning Outcomes:
When you complete this Power Query & Power BI course, you will be able to accomplish the following:
- Understand Big data cleaning, formatting and tasks automation
- Understand Power BI concepts like Microsoft Power BI desktop layouts, BI reports, dashboards, and Power BI DAX commands and functions
- Gain a competitive edge in creating customized visuals and deliver a reliable analysis of vast amount of data using Power BI
- Learn how to experiment, fix, prepare and present data quickly and easily
- Create a sales analysis report and a project management report
- Form relationships in your data model and learn data visualization best practices
Course contents
- What is Power BI Desktop and How to install
- Importing Excel Data inside Power BI
- Creating First Visualization (a bar chart) in Power BI and Formatting It
- Creating first Slicer in Power BI and Formatting it
- Creating First DAX calculated field in power BI
- Creating Slicers / Filter in Power BI and Formatting It
- How to create various Power BI Charts
- How to connect Power BI with different sources
- How include or exclude a part of visualization in power bi
- Power BI Q&A or Natural Language Processing (NLP)
- Power BI Decomposition Tree
- Power BI Key Influencer Chart Creation
- How to Create and Conditionally Format Power BI Matrix or Pivot Table
- How to Create and Conditionally Format Power BI Table
- How to Create and Format Power BI Indicator KPI Chart
- How to Create and Format Power BI Card KPI
- Power BI Gauge Chart Create and Format
- Power BI Maps Chart Creating and Customizing
- Power BI Treemap Chart Creating and Customizing
- Creating Hierarchies in Power BI
- Customizing Power BI Totals and Subtotals
- Power BI Number or Numeric Field Formatting and Conditional Formatting
- Connecting Power BI Report Pages with Drill Through
- Power BI Relative & Advanced Date Filter
- Power BI Selection Panel
- How to Create a New Measure in Power BI DAX Function Sum
- Power BI Dax Function Divide
- Power BI Min Dax Function to Find Min and Max values
- Power BI Dax Function to Conditionally Calculate and create New Measures
- Power BI Dax Function Average
- Power BI DAX Function All
- Power BI DAX Function AllSelected to get Grand Totals for Each Category
- Power BI CalculateTable function to create new virtual table and measure
- Power BI Dax Function Filter
- Power BI DAX Function SUM vs SUMX / Average vs AverageX
- Power BI Dax Function Min vs MinX / MAX vs MAXX
- Power BI IF and Nested IF Function
- Power BI – Conditional sum of two or more than two categories
- Power BI – Counting Distinct & Missing Values
- Power BI – How to Create Dynamic Calendar
- How to Calculate MTD (Month to Date) Rolling Total Values
- How to Calculate QTD (Quarter to Date) Rolling Total Values
- How to Calculate YTD (Year to Date) Rolling Sum
- Power BI Tools Tips and how to display very long tooltips
- Sorting Power BI Visualization
- Power BI Sync Slicer Option for create Slicer in Multiple Reports
- How to Display Image in Power BI chart background
- How to create Small multiple Chart or Trellis Chart and why they are Great
- Power BI Dynamic Report Title based on Selected Drill Through Value
- Power BI Card KPI Conditionally Format
- Power BI Quick Measure to Create Running Total Calculation
- Power BI advance data export to add additional column
- Power BI DAX function to find the value on last day of every month in Date Column
- Power BI DAX function to find the value at the last day of quarter
- Power BI DAX Date Add Function Calculation to Get Historical or Future Values
- Power BI DAX Date Function to Calculate or Summarize Values Between Two Dates
- Power BI DAX Date Function to Calculate Values in Specific Time Period using Dates In Period
- Power BI Sales Dashboard for Beginners
- Power BI DAX Function Closing Balance Year to Capture Values on the Last of Year
