Power Bi Training PPT

1. Power BI Trainings Online Training @ hkrtrainings.com

2. About HKR Trainings HKR Trainings excel at providing you with the best online classes with high-quality facilities at a low price without any compromise on quality. What can you expect from us? A dedicated learning platform with 24*7 support, best in class training materials to help you learn advanced techniques and practical knowledge of all IT Technologies. Our courses are specifically curated for both professionals as well as job-seekers. Online classes conducted by the best knowledgeable and certified trainers help you earn certification at your convenience.

3. Table of contents Power BI Intro Objectives 01 02 Modules Course Info 03 04

4. Power Bi Training Gain a 360° overview of how to use Power BI to create effective reports. In this Power BI course, our trainer helps you to explore how to use this business intelligence platform through hands-on practice. The Power BI training begins by covering the web-based Power BI service, considering how to import data, create visualizations and reports. Next, you’ll acknowledge Power BI Mobile and how to use data modeling capabilities in Power BI Desktop. Each analysis is designed to drive your Power BI skills to the next level. With live Power BI training classes and multiple real-time projects, you’ll acquire the skills needed to pass the Microsoft Power BI Certification Exam.

5. Power BI Online Training Objectives • Who should take up take up this Power BI Training Course? • What are the prerequisites for taking up the Power BI Training online course? • How to start with the Power BI Training Course? • Who issues the course certification certificate? • Who delivers the Power BI Training Course? • What are the benefits of the certified Power BI training certification? • Do we provide job assistance for the power BI Training course?

6. Power BI Modules • Starting with Microsoft Power BI In this Power BI training course module, you'll learn how to navigate this easy application and gain a thorough understanding of Power BI's data, model, and report. You'll learn how to load multiple data sets, construct an interactive visualization, and build a data model. • What are Power BI Tools? • Installation of Power BI & Data Connection • The "Locale" used in the curriculum • Working with the query Editor • Working with the data model and creating a visualization

7. 2. Power BI desktop This Power BI training module will teach you what Power BI Desktop is, how it works, and how to use it to create robust data models and interactive reports that could help you boost your business intelligence. • Workflow overview in power bi desktop • Introduction to various data model views • Examining the query editor's Interface in detail • Settings for Power BI that are required

8. 3. Query Editor Power BI's Query Editor allows you to modify and load data, while DAX allows you to create data models with functions and formulas. Through hands-on labs and lectures, you'll learn everything there is to know about Power Query and DAX in this Power BI online course program. • Understanding query Editor? • Regarding the attached data • Using Power BI Desktop for connecting data • Rows Editing • What are Append Queries? • Columns Editing • Replacing Values • Formatting Data

9. Pivoting & Unpivoting Columns • Splitting Columns • Creating a new Group for the queries • Introduction to Star Schema • Queries Duplicating & Referencing • Manual Data Entry • Merging Queries • Index Column Creation • Duplicating Column and extracting info • Creating Conditional Columns • Performing Mathematical Operations at a Basic Level • Improving Performance and Loading Data into Data Model • Summary of the Module

10. 4. View of data relationships This Power BI Certification Course module will teach you about the structure of modeling in Power BI and the relevance of relationships. Also, learn how to use DAX to generate customized calculations. • Why is the Query Editor & the data model different? • Introduction to relationships • Editing relationships • Concepts are cardinality • Cross Filter selection & Many to many relationships • Active properties • How are M-Language & DAX different? • DAX, Measures & Calculated Values • DAX complex functions • Calculate

11. SUM • SUMX • RELATED • ALLEXCEPT • CONCATENATE • LOOKUPVALUE • IF • SEARCH • DATEADD • DIVIDE, and many more. • Categorizing Data

12. 5. Visualizing results in report view Any business intelligence applications front end is data visualization. This online Power BI training module covers the most common forms of Power BI visualizations, such as bar charts, line charts, and so on. You'll also learn about some of the most common tools for structuring visuals, as well as some best practices for using Power BI Desktop. • Viewing Reports interface • Creating visuals • Add tooltips and interactions/markings • Data color • Hierarchies & Drill-down • Formatting charts & Sorting • Introduction to slicers • Treemaps & Tables • Types of filters

13. Multi-row cards • Combined visuals & waterfalls

14. COURSE FEATURES 30 Hrs of instructor-led training Lifetime access to recorded sessions Certification pass guaranteed Real-world use-cases Certified Trainers 24*7 Support

15. Contact Info Ameerpet, Hyderabad India: +919711699759 info@hkrtrainings.com 40640 High Street Fremont, Illinois, Chicago. USA : +1(818)665 7216 Website: https://hkrtrainings.com/power-bi-training

16. Visit our website Power Bi Certification Course If you want to know more details about Power BI training, visit our website - www.hkrtrainings.com

17. Thanks! Do you have any questions? sales@hkrtrainings.com +91 9711699759 +1 (818) 665 7216 https://hkrtrainings.com i f t i