
Power-BI
Microsoft Power BI Training introduces you to Power BI Desktop and how it is used with Power Pivot for Data Modelling. This course enables you to learn about Data Analysis Expressions (DAX) and Data Visualization with Power BI Desktop. This course will also introduce you to Power BI Q&A, which enables you to discover, explore and visualize enterprise data using Natural Language.
Why Learn Power BI and How it helps an Organisation ?
Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator. Power BI provides cloud-based BI services – known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modelling capabilities including data preparation, data discovery and interactive dashboards.
Extracting business intelligence rapidly and accurately:
It helps in transforming your enterprise data into rich visuals, thus extracting business intelligence for enhanced decision making.
Balanced simplicity and performance:
The in-memory analysis technology and DAX scripting language are both exquisite examples of a balance between simplicity and performance.
Rich personalized dashboards:
The crowning feature of Power BI is the information dashboards, which can be customized to meet the exact need of any enterprise. You can easily embed the dashboards and BI reports in the applications to provide a unified user experience.
Publish reports securely:
The tool helps you to setup automatic data refresh and publish reports allowing all the users to avail the latest information.
No specialized technical support required:
Power BI provides agile inquiry and analysis without the need for specialized technical support. It supports a powerful natural language interface and the use of intuitive graphical designer tools.
Curriculum
- 19 Sections
- 85 Lessons
- 25 Hours
- Introduction to Data Warehousing Concepts8
- Data transformations using Power Query Editor12
- 2.0Familiarize the environment
- 2.1Text transformations 1
- 2.2Text transformations 2
- 2.3Text transformations 3
- 2.4Date transformations Part 1
- 2.5Date transformations Part 2
- 2.6Number transformations
- 2.7Grouping, transposing, and unpivoting data
- 2.8Adding columns in the power query
- 2.9Merge queries
- 2.10Data Profiling 1
- 2.11Data Profiling 2
- Introduction to Power View – Visualization basics9
- 3.1An overview of power apps, power automate, dataverse, etc.
- 3.2Creating basic charts – Part 1
- 3.3Creating basic charts – Part 2
- 3.4Formatting visuals part 1
- 3.5Formatting visuals part 2
- 3.6Formatting visuals part 3
- 3.7Formatting report page
- 3.8Applying themes to reports
- 3.9Data refresh using the power query editor
- The Sales dataset4
- Hierarchy2
- Introduction to DAX functions4
- Using Calculate function3
- Conditional Formatting2
- Grouping, Edit Interaction, Tooltips and Drill through reports5
- Using ALLSELECTED, ALL, and IF functions3
- Filtering reports and adding Custom visuals from AppSource5
- Navigating through the reports3
- Calculated Columns and Tables5
- Connecting to database4
- AI in Power BI6
- Analytics Pane2
- Securing Power BI reports2
- Publishing and sharing reports using Power BI Service5
- Paginated reports – An overview1