Highlights
- Transform and present data for meaningful business intelligence
- Build optimal data models for analysis and dashboards
- Combine data from multiple sources to create a cohesive model
- Cleanse and shape tables by addressing common issues such as duplicates, nulls, and missing identity columns
- Merge tables and integrate diverse data sources
- Import and combine Excel spreadsheets into an efficient model
- Solve real-time challenges, such as handling different dates and time-spread events
- Automate data imports and report refreshes to keep dashboards up-to-date
Course Details
Data Modelling
- The importance of Data Modelling
- good models vs bad models
- Optimal model: Star model
- Denormalised model
Normalization vs Denormalization
- Extreme Denormalization: working with one table
- Finding balance between Normalised and “one Table schema”
- Dimension tables
- Fact table
- Granularity
- Guidelines for Selecting Fact Table Granularity
- Conformed dimensions
- Data dimension
Data Cleansing and preparation
- Import data from different sources (excel, SQL, Web etc) into Query Editor
Cleanse data and apply transformation to remove common problems:
- Deduplicate
- Remove nulls
- Unpivot tables
- Create new columns
- Create conditional columns
Common scenarios:
- Double fact table
- Multiple Fact table
- Multiple Date Dimensions
- Many to Many relationship
- Handle events spreading in time
Combine tables:
- Append
- Merge
Introduction to M query language
- Advance Editor Language structure
- Create new query
- Create M function
Create and use Dataflow:
- Pro and cons of using Dataflow
- Create a dataflow
- Cleanse data using Dataflow
- Connect PowerBi Desktop to dataflow
Who should attend
- Business Analysts
- Financial Analysts
- Quants
- Data Scientists
- Staff already using Power BI
- Developers and Super Users/Power Users seeking to maximise their use of Power BI
Note: This course requires delegates to run Power BI Desktop. Mac users must make arrangements to use a PC.
Feedback
4.8 out of 5 average
“Learning more about the query editor was very useful and especially the merge tables features. It was nice to see some really good examples of how it can be used to present your work". AG, Business Analyst, Power BI Advanced, February 2021
Client feedback from Data Analytics training courses:
