1 / 25

Power BI Tutorial For Beginners | Learn Power BI Step By Step | Power BI Training | Simplilearn

Power BI is a powerful tool for business intelligence and reporting. This video on Power BI Tutorial will help you learn the basics of Power BI and its various features. Then, you will understand how to connect to different data sources in Power BI Desktop and manipulate data using Power Query Editor. Finally, you will build some charts and graphs in Power BI and get an idea about the Power BI Service.<br><br>Below topics are explained in this Power BI tutorial:<br>Introduction to Power BI<br>What is Power BI?<br>Benefits of Power BI<br>Connecting data to Power BI<br>Power BI demo<br><br>About Power BI Certification Training Course:<br>Learn data visualization and all of the critical features in Power BI in this Power BI Certification course, which allows you to explore, experiment, fix, prepare, and present data quickly and easily.<br><br>This Power BI Training course will help you get the most out of Power BI, enabling you to solve business problems and improve operations. The course helps you master the development of dashboards from published reports, discover better insight from your data, and create practical recipes on the various tasks that you can do with Microsoft Power BI.<br><br>Key Features:<br>- 6 hours of enriched learning<br>- Lifetime access to self-paced learning<br>- Industry recognized course completion certificate<br><br>Eligibility:<br>The Power BI certification training course is suitable for people who have never worked with Power BI but want to want to understand how to use the Power BI tools. This Power BI training course is also applicable for people who want to understand how to create customized visuals with the Power BI developer tools.<br><br>Learn more at: https://bit.ly/2zV3BLm<br>

Simplilearn
Download Presentation

Power BI Tutorial For Beginners | Learn Power BI Step By Step | Power BI Training | Simplilearn

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Power BI Tutorial

  2. What’s in it for you? What’s in it for you? What is Power BI? Benefits of Power BI Connecting data to Power BI Visualizations in Power BI Data Models in Power BI DAX in Power BI Power BI Demo

  3. What’s in it for you? What is Power BI? Power BI is a business intelligence tool to visualize your data and share insights across your organization

  4. Power BI Tutorial Click here to watch the video

  5. What’s in it for you? What is Power BI? Power BI is a business intelligence tool to visualize your data and share insights across your organization Data

  6. What’s in it for you? What is Power BI? Power BI is a business intelligence tool to visualize your data and share insights across your organization Data

  7. What’s in it for you? What is Power BI? Power BI is a business intelligence tool to visualize your data and share insights across your organization Data Visualization

  8. Benefits of Power BI Following are the benefits of Power BI: Extract intelligence rapidly and accurately Transforms your Enterprise data into rich visuals & accurate reports for enhanced decision making

  9. Benefits of Power BI Following are the benefits of Power BI: Extract intelligence rapidly and accurately Supports advanced data services Integrates seamlessly with advanced cloud services like Cortana, to provide results for the verbal data queries as well Transforms your Enterprise data into rich visuals & accurate reports for enhanced decision making

  10. Benefits of Power BI Following are the benefits of Power BI: Integrates seamlessly with existing applications Extract intelligence rapidly and accurately Supports advanced data services Adopts analytics & reporting capabilities easily to embed interactive visuals quickly in your applications Integrates seamlessly with advanced cloud services like Cortana, to provide results for the verbal data queries as well Transforms your Enterprise data into rich visuals & accurate reports for enhanced decision making

  11. Benefits of Power BI Following are the benefits of Power BI: Integrates seamlessly with existing applications Extract intelligence rapidly and accurately Supports advanced data services Rich personalized dashboards Adopts analytics & reporting capabilities easily to embed interactive visuals quickly in your applications Provides a unified user experience with the customized dashboard & reports that meet your exact needs Integrates seamlessly with advanced cloud services like Cortana, to provide results for the verbal data queries as well Transforms your Enterprise data into rich visuals & accurate reports for enhanced decision making

  12. Benefits of Power BI Following are the benefits of Power BI: Integrates seamlessly with existing applications Extract intelligence rapidly and accurately Secure report publishing Supports advanced data services Rich personalized dashboards Adopts analytics & reporting capabilities easily to embed interactive visuals quickly in your applications Provides a unified user experience with the customized dashboard & reports that meet your exact needs Sets up automatic data refresh & rapidly publishes reports, allowing all the users to avail the latest information Integrates seamlessly with advanced cloud services like Cortana, to provide results for the verbal data queries as well Transforms your Enterprise data into rich visuals & accurate reports for enhanced decision making

  13. Connecting Data to Power BI Power BI can connect to different data sources

  14. Connecting Data to Power BI Power BI can connect to different data sources In the Home menu, click on the Get Data tab. This will open a window where you can find the different types of data sources such as Excel, Text/CSV, JSON, PDF, SQL Server database, Access database, etc.

  15. Connecting Data to Power BI Power BI supports different types of charts, graphs, maps, and cards to visualize data and derive insights In the Visualizations pane, select the type of visualization you want to build to visualize your data

  16. Data Models in Power BI Data models are used to connect multiple data sources to build a relationship

  17. Data Models in Power BI Data models are used to connect multiple data sources to build a relationship Suppose there are 2 tables: AW_Products_Lookup and AW_Sales

  18. Data Models in Power BI Data models are used to connect multiple data sources to build a relationship Let’s calculate the total Order Quantity of each Product Name

  19. Data Models in Power BI Data models are used to connect multiple data sources to build a relationship Let’s calculate the total Order Quantity of each Product Name As you can see, the Order Quantity for each Product is the same. This is because the Product and Sales table are not connected and there’s no relationship between both the tables

  20. Data Models in Power BI Data models are used to connect multiple data sources to build a relationship You need to build a relationship between both the tables using a common key column ProductKey from both the tables are joined to form a relationship

  21. DAX in Power BI Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI Desktop

  22. DAX in Power BI Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI Desktop DAX allows you to create new calculated columns and measures Calculated Columns • Values are calculated based on information from each row of a table • Appends values to each row in a table and stores them in the model • Increases the file size Right click on any column to add a new column. Here, we have added QuantityType as the calculated column

  23. DAX in Power BI Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI Desktop DAX allows you to create new calculated columns and measures Measures • Values are calculated based on information from any filters in the report • Does not create new data in the tables themselves • Does not increase the file size In the report view, right click on any table name to add a new measure. Here, we have added Quantity Sold as the measure

  24. Types of DAX functions DAX allows you to create new calculated columns and measures Statistical Functions Information Functions Date and Time Logical Functions Text Functions • DATE • DATEDIFF • DAY • MONTH • HOUR • TODAY • TIME • WEEKDAY • AND • FALSE • IF • IN • NOT • OR • SWITCH • TRUE • BLANK • CODE • EXACT • FIND • CONCATENATE • LEN • LOWER • REPLACE • ADDCOLUMNS • AVERAGE • COUNT • MEDIAN • MAX • MIN • GENERATE • CROSSJOIN • CONTAINS • ISBLANK • ISERROR • ISEVEN • ISLOGICAL • ISTEXT • USERNAME • ISODD

  25. Join us to learn more! simplilearn.com UNITED STATES Simplilearn Solutions Pvt. Limited 201 Spear Street, Suite 1100 San Francisco, CA 94105 Phone: (415) 741-3319 INDIA Simplilearn Solutions Pvt. Limited #53/1C, 24th Main, 2nd Sector HSR Layout, Bangalore 560102 Phone: +91 8069999471 UNITED STATES Simplilearn Solutions Pvt. Limited 801 Corporate Center Drive, Suite 138 Raleigh, NC 27607 Phone: (919) 205-5565

More Related