- Build professional-quality business intelligence reports from the ground up.
- Design and implement the same tools used by professional analysts.
- Explore powerful artificial intelligence tools.
- Explore advanced visualization techniques.
Power BI is a collection of software services, apps, and connectors that work together to turn various sources of data into static and interactive data visualizations. Data may be input by reading directly from a database, webpage, PDF, or structured files such as spreadsheets, CSV, XML, JSON, XLSX, and SharePoint.
- IT Freshers or Professionals.
- Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop.
- Aspiring data professionals looking to master the #1 business intelligence tool on the market.
- Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills.
- Overview of Business Intelligence (BI) and Power BI.
- Understanding the Power BI ecosystem.
- Installation and setup of Power BI Desktop.
- Power BI Service overview.
- "GET DATA" from various sources.
- Data Transformation, Benefits of Data Transformation.
- Shape or Transform Data using Power Query.
- Overview of Power Query / Query Editor, Query Editor User Interface.
- Ribbon (Home, Transform, Add Column, View Tabs).
- The Queries Pane, The Data View / Results Pane, The Query Settings Pane, Formula Bar.
- Saving the Work.
- Datatypes, Changing the Datatype of a Column Filter in Power Query.
- Copy Pasting Data.
- Auto Filter / Basic Filtering.
- Filter a Column (Text Filters, Number Filters, Date Filters).
- Filter Multiple Columns.
- Add, Remove, Merge, Name/Rename, Re-Order, PIVOT/UN-PIVOT, Transpose Columns.
- Header Row Promotion.
- Keep Top, Bottom, Range of Rows, Duplicates.
- Remove Top, Bottom, Range of Rows, Duplicates.
- Group Rows / Group By.
- ETL Operations with Power Query.
- Replace Nulls, Fill Up, Fill Down.
- Date and Time Transformations.
- Deriving Year, Quarter, Month, Day.
- Conditional Column transformation.
- Consolidate and Append Data.
- Append data from Excel tables within same Excel file.
- Text functions in Power Query.
- Date functions in Power Query.
- Conditional Functions in Power Query.
- Query Step Inserts and Step Edits.
- Using RELATED function - the lookup of Power Pivot.
- Modeling Data.
- Report View Options: Full, Fit Page, Width Scale.
- Report Design using Databases & Queries.
- Navigation Options and Report Refresh.
- Charts in Power BI (Line, Bar, Pie, Scatter, Waterfall, Funnel).
- Slicers in Power BI.
- Tables.
- Matrix.
- Cards.
- Map Visualizations, for Creating Dynamic Maps Connected to Location Mentioned in Data.
- Gauges and Single Number Cards.
- Understanding Multipliers.
- Field Properties: Axis, Legend, Value, Tooltip.
- Field Properties: Color Saturation, Filters Types.
- Formats: Legend, Axis, Data Labels, Plot Area.
- Data Labels: Visibility, Color and Display Units.
- Data Labels: Precision, Position, Text Options.
- Analytics: Constant Line, Position, Labels.
- Modifying Legends and Visual Filters - Options.
- Map Reports: Working with Map Reports.
- Hierarchies: Grouping Multiple Report Fields.
- Hierarchy Levels and Usages in Visualizations.
- Using Field Hierarchies with Chart Reports.
- Administer and manage Windows Server IaaS virtual machines remotely.
- Manage hybrid workloads with Azure Arc.
- Configure and manage Hyper-V.
- Configure and manage Hyper-V virtual machines.
- Secure Hyper-V workloads.
- Run containers on Windows Server.
- Orchestrate containers on Windows Server using Kubernetes.
- Data Modelling, Creating Relationships between data, and looking at Business Problem’s.
- Working with 1:1, 1:M, M:M tables.
- Understanding the Relationship Flow.
- Commonly Used DAX Functions.
- DAX efficiency.
- DAX contexts.
- DAX references.
- DAX best practices.
- Filter context.
- The Row Context.
- The Column Context.
- Measures and Calculated Columns.
- Filter and Row Context in a measure.
- CALCULATE function.
- Context transition.
- Filter expressions of CALCULATE.
- Rules of evaluation.
- CALCULATE and FILTER.
- Row context in Calculated Columns.
- Filter context in Calculated Columns.
- Relationships in Row contexts.
- RELATED function.
- RELATED TABLE function.
- Using RELATEDTABLE in a column.
- CALCULATED in row contexts.
- Row to filter context.
- Transformation.
- Duplicates in the transformation.
- LOOKUPVALUE function.
- Row contexts in measures.
- Simple iterator in a measure.
- Row context and a related table.
- Reuse measures.
- Implicit CALCULATE in a measure.
- Alternative approach using variable.
- Time Intelligence prerequisites.
- Time intelligence functions MTD, QTD, YTD, SamePeriodLastYear.
- Date (Dimension) tables.
- Using in-built TOTALYTD.
- Date modifier functions.
- DATESBETWEEN, DATEADD and DATESINPERIOD.
- Using date modifier DATESYTD.
- The magic behind date table functions.
- YTD, MTD with CALCULATE.
- Rolling totals for different periods.
- IF, HasOneValue.
- Using a Safe Divide Function.
- Using the Blank() Function.
- Calculations over weeks.
- MAX or LASTDATE.
- Build an Example Time Intelligence Report.
- Understanding the FILTER function.
- Contexts in the FILTER function.
- The filter context in functions.
- Simple filter expression.
- Comparing a value in the filter context.
- Adding another filter condition.
- The value of VALUES.
- Working with iterators.
- MINX and MAXX.
- Useful iterators.
- RANKX.
- ISINSCOPE.
- Summarising table.
- Using SUMMARIZE.
- Using ADDCOLUMNS and SUMMARIZE.
- Using SUMMARIZECOLUMNS as a better alternative.
- A summary table in a measure.
- Filtering a table.
- Ignoring filters.
- Mixing filters.
- Distinct.
- How many values for a column.
- ALLSELECTED.
- Tables and relationships.
- Table variables.
- Introduction to Table Joins.
- The Inner Join.
- A join on unrelated tables - TREATAS.
- The Outer Join.
- The Cross Join.
- Using GENERATE for Joins.
- Arguments in RANKX.
- Create a calculated column for ranking.
- Sort order of ranking.
- Definitions when ranking ties.
- Breaking Ties Manually.
- Creating a measure for ranking.
- Adjustments to make the RANKX measure work.
