Power BI Course Outline

• Introduction to Power BI
• What is Power BI?
• Major Component: Power Pivot, Power View, Power Map, Power BI Desktop
• The First Experience
• Youˇll Need Just a Web Browser

Getting Data

• File Sources
• Folder as a Source
• Database Sources  
• Analysis Services Connection
• Web Source

Power Pivot for Data Modelling

• Relationships in Power Pivot
• Best practices
•  Introduction to DAX
• Calculated Members
• Advanced calculations using Calculate functions
• Time Functions
• DAX Advanced
• Power Pivot embedded in Power BI Desktop

Data Visualization with Power BI, Power View and Power Map

• Data Visualization Best Practices
• Power BI Desktop Visualization
• Custom Visuals in Power BI Desktop
• Formatting Visuals in Power BI Desktop
• 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
• 3D geo-spatial visualization with Power Map
• Best Practices to work with Power Map

Power BI Desktop: combination of three tools

• Power BI Desktop Introduction
• Getting data from different data sources
• Modelling data, and relationships
• Creating calculated measures
• Visualizing data in Power BI Desktop
• Power View difference in Power BI Desktop
• Best practices of designing solutions with Power BI
• Custom Visuals for Power BI Desktop

In this training course you will learn Power BI from beginner to advance. You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about five components of Power BI one by one. Power Query for data mash up, Power Pivot for Modelling, Power View and Power Map for data visualization, You will also learn about Power BI Desktop and Power BI apps with great new features added to this product. You will learn all the concepts with live demos. Expect learning best practices with great scenarios in this course.