Course Outline for Microsoft Power BI - Beginner to Intermediate
This course has been designed to enable you to perform Business Intelligence Solutions, with Mocrosoft’sPower BI and raw csv files as the source of your data. We will be simulating our work with actual data and will be taking a hands-on approach to earning.
By the end of the course, you will have the following abilities if you follow along successfully:
- Understand the business intelligence workflow from end-to-end.
- Build business intelligence reports from scratch.
- Create interactive dashboards from raw data.
- Use B.I. tools used by professional analysts and data scientists to design and implement the solutions.
- Use DAX
Outline
The course will be delivered over a 3 day period. The course days have been itemized as follows:
Day-1 [Intro and Transformation]
- Learn about the editor and environment.
- Explore Connectors
- Basic Transformations
- String and Numeric tools
- Index & Conditional Columns
- Grouping & Aggregating Data
- Pivoting & Unpivoting
- Modifying, Merging & Appending Queries
- Connecting to Folders
- Defining Hierarchies & Categories
- Best Practices
Day-2 [RDM and DAX]
- Normalization
- Data ("Fact") Tables vs. Lookup ("Dimension") Tables
- Creating Relationships
- Schemas and comparisons
- Active vs. Inactive Relationships
- Relationship Cardinality
- Connecting Multiple Data Tables
- Filtering & Cross-Filtering
- Hiding Fields from the Power BI Report View
- DAx Intro
- Calculated Columns vs. Measures
- Row Context vs. Filter Context in Power BI
- Syntax for DAX
- Common Power BI Functions
- Basic Date & Time Formulas
Day-3 [DAX and Reporting]
- Logical & Conditional Statements
- Text, Math & Stats Functions
- Joining Data with RELATED
- CALCULATE, ALL & FILTER Functions
- Iterators
- Time Intelligence Formulas
- Reporting Intro
- Basic Charts
- Formatting & Filtering Options
- Matrix Visuals
- Slicers & Timelines
- Cards & KPIs
- Power BI Maps, Treemaps, Lines, Areas & Gauges
- Editing Report interactions
- Adding Drillthrough Filters
- Linking to Report Bookmarks
Practical, connected learning
My wider training approach brings hands-on implementation and systems thinking together, connecting technology with real operational needs.