Course code: MBI0020
Power BI Fundamentals provides hands on training for new Power BI users and developers.
Power BI Developers
Power BI Analysts
Power BI Users who want to better understand, produce and manipulate reports and dashboards
iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835
Hands on Power BI workshop for those with none, to little experience explore the essential facets to fully harness the potential and value from Power BI. Integrated hands on labs will build on best practice to enable attendees to develop reports and build KPIs that will deliver specific business needs on return to their workplace.
This course has been designed to covered both Power BI, data modeling concepts and DAX essentials to provide a rounded tool box of skills for those starting on their Power BI path. iTrain also provide both more advanced training and a one day course focussed more squarely Power BI cloud users.
Following the course attendees will be able to convert data into information and effectively distribute this across the business.
Power BIProduct setLandscapeObjectivesPower BI Cloud ServiceCloud Service overviewRole and Functionality for ConsumersCFO DashboardsNavigationDashboard FlowPower BI MobileObtaining Value from Quick InsightsContent PacksDemo SamplesNatural Language QueriesPowerPoint (exporting to)Publish to web (Embedded View)
Power BI DesktopOverview of Power BI DesktopSimilarities to Excel Power PivotSimilarities to Excel Power QueryTechnical Options & SettingsMonthly UpdatesFacts & DimensionsData Modeling BasicsBuilding a Robust Star Schema
Data - Source, Import, TransformSourcesDirect QueriesIntroduction to Query EditorQuery Design & the ETL ProcessQuery BuildingApplied StepsData Transformations– Cleaning data (covers many different methods)– Merging Datasets– Unpivoting Data– Combining Files from a Folder– Appending Datasets– Creating Columns from ExamplesUsing a Dynamic Fiscal Calendar TableParametersData ModellingRelationships Between TablesMultiple Relationships with the Fact TableDefault Summarization of FieldsCustom Sorting of ColumnsData Types Data FormattingReport Building BasicsImplicit Vs Explicit MeasuresCalculated Measures & Calculated ColumnsBase Measures & MetricsKey DAX Functions- Sum, Average, Count, DistinctCount- Time Intelligence (MTD, QTD, YTD, Prior Year)- Understanding ‘Calculate’ and the ﬁlter context- IF, HasOneValue- Using a Safe Divide Function- UserRelationship Function- Using the Blank() FunctionOptimizing Measures for Self-Service BICopying and Moving MeasuresQuick MeasuresDynamic Headings & DatesTypes of Slicers and FiltersKPI cardsUsing Field, Format, Analytics PaneTabular ReportsReplicating Excel Pivot TablesConditional FormattingOptimizing the Matrix LayoutsReport Functionality icon
Drill-Through ReportsFocus ModeFiltering Reports by Relative DatesUnderlying DataReport CustomizationData ExportsHistorical Categorical TrendsBuilding Reports using Q&AReport SlicersCross Highlighting or Cross Filtering
Report VisualisationsChoosing Visuals Based on ContextUsing Custom VisualsMapsWaterfall ChartsGetting Value from Scatter, Ribbon & Bullet Charts
Design Optimization Adding & Optimizing Tool TipsFormat PainterVisual Alignment TipsCustom Page SizingLogos & Custom IconsShapes and LinesFormatting Tips & TricksBest Practice - Discussion and TipsData Model Redundancies
Governance & DistributionUnderstanding Row Level SecuritySecurity RolesPublishing Models to the Cloud ServiceAdding Users to Security Deﬁned RolesBasic Sharing of Dashboards & ReportsReport Collaboration Users & Editing WorkspacesConnecting to AppsOrganisational Content Packs
Data RefreshingThe Data GatewayScheduling Data RefreshesRefreshing On-Demand
Terms and Conditions
© 2020 iTrain. All rights reserved.