POWER BI

Power BI is an amazing business analytics service that enables anyone to visualize and analyze data. Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you.

Power BI transforms your company’s data into rich visuals for you to collect and organize so you can focus on what matters to you. Stay in the know, spot trends as they happen, and push your business further.

COURSE SUMMARY:

What you’ll learn in Power BI Training Course?

In this Power BI training course, you will learn

• Power BI from beginner to advance.
• How to use Power BI for simple data analysis situations as well as complex business intelligence scenarios.
• Power BI Desktop, Power BI Website, and components of Power BI which are; Get and Transform (or Power Query), Modeling (or Power Pivot), and Visualization.
•  Power Query Formula Language (Called M informally), and DAX.

This course designed to give you an end to end view of Power BI, so you be able to use Power BI straight away in your everyday challenges for data analysis.

Introduction to Power BI: What is Power BI?

Introduction to Power BI Components: Power Query, Power Pivot, Power View, Power Map, and

Power Q&A.

What is Power Query: Introduction to Data Mash-Up Engine of Power BI

• Get Started with Power Query: Movies Data Mash-Up
• Power BI Get Data From Excel: Everything You Need to Know
• Definitive Guide to Power BI Personal Gateway
• File Sources
• A folder as a Source
• Database Sources
• Analysis Services Connection
• Different versions of Power Query
• Power Query Introduction
• Query Editor
• Transformation GUI
• Row Transformations
• Column Transformations
• Data Type
• Adding Column
• Text Transformations
• Number Column Calculations
• Date and Time Calculations
• Data types, Lists, Records, and tables in M
• M built-in functions
• Generators in M
• Writing Custom Functions
• Error handling

Power Pivot for Data Modelling

• Power Pivot xVelocity engine basics and concepts
• Different versions of Power Pivot
• Relationships in Power Pivot
• Best practices

Introduction to DAX

• Calculated Members
• Row Context vs Set Context
• Advanced calculations using Calculate functions
• Time Functions
• DAX Advanced
• Power Pivot embedded in Power BI Desktop
• Data Visualization with Power BI Desktop, Power View

Power View for Excel

• Charts, scorecards, and other visualization items in Power View
• Sorting, Filtering, and categorization with Power View
• Best Practices to work with Power View

Data Visualization with Data Visualization

• Power BI Desktop Visualization
• Custom Visuals in Power BI Desktop
• Formatting Visuals in Power BI Desktop
• Creating and Enhancing Dashboard in Power BI Desktop

Security

• Sharing Dashboards
• Groups in Power BI
• Row Level Security in Power BI
• Row Level Security with SSAS Tabular Live Connection
• Dynamic Row Level Security