Hello & Welcome to this Microsoft Power BI course. If you're trying to quickly master the most suitable tool for connecting, transforming, visualising, and analysing your Data, you are in the right place. We will take you from zero to hero, through our practical learning approach, and will quickly get you up running & building analytical solutions for your organisation.My name is Abdelkarim M. MAHMOUD, and I am a Power BI certified Consultant. I have spent the last years empowering different type of organizations by helping them gain performance and competitivity through their Data. I had the chance and the pleasure to train dozens of teams from simple Power BI users to Chief Data Officers. I am here today to put all my expertise at your disposal in a simple and practical way.This in-depth training strikes the perfect balance between theory and practice, several PowerBI use cases are covered to allow you to get the most value from your data. Here's what we're gonna dive into:Introduction - What is Power BI ?More reasons to use Power BI ESPECIALLY if you use excelResources & Course StructureQuick tour & Interface overviewChapter 1 - Extract, Load, and Transform Data in Power QueryPower Query, Connecting to a Database and Data TypesFilteringRemoving & Ordering ColumnsConditional ColumnsConnecting to a folder as a Data SourceCombining DataDealing with less structured dataFixing ErrorsChapter 2 - Data Modeling ?Tables and RelationshipsBEST PRACTICE: Dimensional Modeling & Star SchemasBEST PRACTICE: Optimising The model for Development TimeChapter 3 - DAX for Data Analysis ExpressionsDAX, the "POWER" in POWER BIUsing Measures to create Calculations and KPIsComparing this year's Value to last year's valueYear over Year Varience, and Waterfall ChartsYear to Date with DAXChapter 4 - Data VizualisationWhy Data Visualisation Really MattersPie Chart and TreemapHierarchiesFiltering and TopNDual-Axis (Combo) ChartAdvances Visual Analytics Pane - Trends, Targets, Forecasts and moreArtificial Intelligence: Decomposition Tree, Q & A and Key InfluencersSlicersMAPS and Dynamic Coloring!Fancy TablesChapter 5 - Power BI ServiceSharing and Collaboration in Power BIHow to Publish a report to the Power BI serviceDeep Dive into the Power BI service