Overview

Data visualization is the standard way to communicate complex information into meaningful visuals that have a long-lasting impact. Gone are the days when data analysis was restricted to a spreadsheet and limited graphing capabilities. The current era of business intelligence has equipped business professionals with state-of-the-art analytical tools such as Power BI allowing them to visually see the state of the business and identify patterns to bolster successful strategies.Microsoft Power BI (business intelligence) is a powerful visualization and analytics tool that helps companies of all sizes analyze their data and share insights. With this technology, enterprises can monitor their business more closely and get instant answers with rich dashboards available for every device.The course Power BI for business professionals is designed for anyone who wants to create impactful visualizations and reports that utilize the underlying data and convey the message that has a long-lasting impact. The course is organized in small bitesize lectures in order to retain the attention of the student. The course begins by covering the core concepts of Power BI and data visualization. It then covers the specific visualization and their purposes. Many sections in the course contain practical activity files to help students test and apply their knowledge in a real scenario.Course Outline (Detailed)IntroductionIn this video instructors are introduced as well as how the course is organized is explained2.1Introduction to Power BIIn this video the instructor will narrate the Lesson 2 outlineLesson 2: Signing Up for Power BI and Loading Data2.2Downloading Power BI DesktopIn this video the instructor will narrate the basic steps and system requirements to download Power BI2.3Login into Power BI onlineIn this video the instructor will outline the procedure to Login into Power BI2.4Loading Data into Power BIIn this video the instructor will give a demo on how to load data in Power BI2.5Recap & ConclusionIn this video the instructor will recap and conclude Lesson 2Lesson 3: Power BI Tables3.1Introduction to Power BI TablesIn this video the guide will narrate the Lesson 3 outline3.2Creating your first table in Power BIIn this video the narrator will exhibit the course of actions taken to create a table in Power BI3.3Formatting and sorting TablesIn this video the instructor will narrate the ways to format and sort tables in Power BI3.4Using Multiple Measures in TablesIn this video the narrator will demonstrate the process to insert multiple measures in a single table3.5Cross Filtering TablesIn this video the guide will instruct on how to cross filter tables in Power BI3.6Practical Activity - TablesPractical Activity testing understanding of tables3.7Methods of AggregationIn this video the instructor will exhibit the techniques to compile information from databases in Power BI3.8Practical Activity - Methods of AggregationPractical Activity testing how information can be aggregated and presented in Power BI3.9Percentage CalculationsIn this video the narrator will illustrate the ways to calculate percentages of data in Power BI3.10Conclusion to Tables SectionIn this video the guide will recap and conclude Lesson 3Lesson 4:Matrix and Cards4.1Introduction to Matrix and CardsIn this video the instructor will narrate the Lesson 4 outline4.2Creating the Matrix VisualizationIn this video students will learn how matrix tables can be visualized on Power BI canvas4.3Methods of Aggregation for MatrixStudents will learn how information could be added to give an sum view of the data presented on a matrix table4.4Percentage of Calculations for the MatrixStudents will learn how numbers presented on a matrix table can be converted to percentages4.5Multi Row VisualizationKPI cards are good way to present numbers. In this video student will learn how to use KPIs to create multi row visualizations4.6Card VisualizationCard visualization covered in this video will demonstrate how to present and label a single KPI on the Power BI canvas4.7Practical Activity - Cards, Multi Row and MatrixPractical activity testing knowledge of Cards, Multi Row and Matrix4.8Conclusion to Matrix and Card VisualizationsTopic is summarized in this videoLesson 5: Filters and Slicers5.1Introduction to Filters and SlicersThe video introduces the important concept of filters and slices which when applied can create visualizations which are more specific to user needs5.2Text SlicersThis video demonstrates how slicers could be applied to text to filter information5.3Numeric SlicersThis video demonstrates how slicers could be applied to numbers to filter information5.4Date SlicersThis video covers how a date can be filtered by using date slicers5.5Visual Level Text FiltersThis video demonstrates how visuals could show customized information by applying visual level text filters5.6Visual Level Numeric FilterThe video is an extension to visual level filters demonstrating how numeric filters can be applied to a visual5.7Visual Level Date FiltersThe video is an extension to visual level filters demonstrating how datefilters can be applied to a visual5.8Page and Report Level FiltersThe video is an extension to visual level filters demonstrating how datefilters can be applied to a visual5.9Practical Activity - FiltersPractical activity testing knowledge of filters5.10Conclusion to Filters and SlicersChapter round up of lesson 5Lesson 6:Column Visualizations6.1Introduction to Column VisualizationsColumn visualization are introduced and expectations of videos coming in lesson is set6.2Column VisualizationsHow to make a basic column visualization is covered6.3Stacked Column VisualizationsStacked column visualization is covered. Students learn what is the difference between the 2 types of column visualization and when to use them6.4Cross Filtering and SlicersHow to set cross filters to slicers to add more interactivity to visualizations6.5Practical Activity - Column and Bar VisualizationsPractical Activity testing knowledge of Column and Bar Visualizations6.6Graph OptionsDifferent types of graph visualizations available in Power BI6.7Analytics PaneHow the analytics pane can add dynamic reference lines to visuals, and provide focus for important trends or insights6.8Practical Activity - Graph OptionsPractical Activity testing understanding of Graph Options in Power BI6.9Conclusion to the Column Visualizations SectionLesson round-up video summarizing what is taughtLesson 7:Trend Analysis7.1Introduction to Trend AnalysisHow trend analysis can enrich the current visualization in power bi7.2Line GraphsLearn how to add line graphs in power BI7.3Area GraphsHow lines can be converted to area charts7.4Ribbon GraphsHow to make ribbon graphs in power bi7.5Practical Activity - Trend AnalysisPractical Activity testing understanding of Trend analysis in Power BI7.6Conclusion to Trend Analysis SectionLesson round up video summarizing what is taughtLesson 8:Other Graph Types8.1Introduction to Other Graph TypesIntroduction to other types of charts used in Power BI8.2Waterfall and KPI VisualizationsHow waterfall and KPI charts could help us create a visualization8.3Combination GraphsIn this video combination charts are explained in Power BI. How they can be helpful in conveying greater detail in the same visualization8.4Pie GraphsHow pie charts are made in power bi are explained in this video8.5Tree map GraphsHow tree map visualization is created in power bi is explained in this video8.6Geographical GraphsHow information such as name of cities and countries can help present companies' information on a map8.7Scatterplots and Bubble plotsOther charts such as Scatterplots and Bubble plots are explained in this video8.8Practical Activity - ScatterplotsPractical Activity - Scatterplots test students understanding from previous videos8.9Practical Activity Scatterplots TutorialThis video contains answers to the practical activity conducted8.10Conclusion to Other GraphsChapter Roundup summarizing the concepts learned in previous videosLesson 9: Interactive Dashboards9.1Introduction to Interactive Reports/DashboardsIn this lesson we cover the objectives of how the previously acquired knowledge could be used to create interactive reports in power bi9.2DIY Worldwide LLCA scenario of a fictitious company Worldwide LLC where information could be used to create a report9.3Drill Through FiltersIn this video concept of how a visual can provide a more focused information using drill though filters9.4Advanced ToolTipsAdvance tool tips help to create a custom information to be shown as a tool tip of a visualization9.5BookmarksHow information or a visual could be bookmarked to create a story line effect in Power BI9.6Publishing reportsHow reports in desktop could be published to power BI online9.7Conclusion to Interactive DashboardsChapter roundup summarizing the core concepts learnedLesson 10: Power BI Service10.1Introduction to Power BI ServicePower BI online service is introduced in this lesson10.2Setting Up DashboardsHow different visuals from multiple reports could be combined in the form a dashboard in power bi10.3Dashboards V ReportsMajor differences between dashboard and report is identified10.4Set up Alerts and SubscriptionsHow can we setup alerts for a visuals or subscriptions for updates on data models is created in Power BI10.5Getting Insight from your DataHow the analytics engine of power BI can generate insights in Power BI online10.6Setting up the Mobile ViewThe video aims to discuss how reports and dashboards are best optimized for mobile views10.7Natural Language QueriesThe NLP is a brand-new feature of Power BI which helps us ask questions from the data source by typing English sentences.10.8Practical Activity - Natural LanguagePractical Activity - Natural Language testing understanding of10.9Conclusion to the Power BI ServiceConclusion video summarizing what is covered in previous videos of the lessonLesson 11:Power BI Security, Workspaces and Refresh11.1Introduction to Power BI Security, Workspaces and RefreshIn this video the security features and data refresh options of power bi are introduced11.2Data GatewaysIn this video the instructor explained how data gateway can help sync data that is lying on local machine to power BI online11.3Row Level SecurityHow information could be kept secure by restricting access applied on certain rows of data in Power BI11.4Creating workspaces in Power BIHow workspaces are created in Power BI online to share and collaborate with others11.5Publishing AppsHow publishing apps can help broadcast our reports and dashboard and share with entire organization.11.6Conclusion to Power BI Security, Workspaces and RefreshConclusion video summarizing what is covered in previous videos of the lessonLesson 12:Power BI and Excel12.1Introduction to Power BI and ExcelLesson introductory video highlighting how power BI reports could be further analyzed in excel12.2Power BI and Excel Pivot TablesHow Power BI reports could be exported and analyzed in excel pivot tables12.3Pinning Excel RangesHow reports analyzed in excel could be pinned to Power BI12.4Excel Online WorkbooksHow source file could be analyzed in online excel12.5Conclusion to Power BI and ExcelConclusion video summarizing what is covered in previous videos of the lessonLesson 13:Custom Visualizations13.1Introduction to Custom VisualizationsHow visuals can be made more customized are introduces in this video13.2Custom VisualizationsDifferent types of customization option available in Power BI are discussed in this video13.3ThemesHow different themes could be added to a report in Power BI13.4Conclusion to Custom VisualizationsConclusion video summarizing what is covered in previous videos of the lessonLesson 14:Publish and Embed Dashboards14.1Introduction to Publish and EmbedHow reports could be published or embedded to other platforms such as power point14.2Publish and Embed DashboardsHow dashboards could be published or embedded to other platforms such as power point14.3Power BI Usage ReportsHow activity of work done in Power BI could be monitored such as how many times a report is viewed.14.4Conclusion to Publish and Embed DashboardsConclusion video summarizing what is covered in previous videos of the lessonLesson 15: Course Conclusion15.1Course ConclusionIn this video a brief summary of each Lesson is given to give a small recap to students.

Skills

Reviews