MS POWER BI & OTHER FINANCIAL REPORTING/ANALYTICS TOOLS
Registrations are closed
Live-Online Training: N175,000
Classroom Training: N 215,000
3 - 4 participants: 5% discount
5 or more participants: 10% discount
(Available also for Customised Training by Duration, Venue & Fee)
(PARTICIPANTS SHOULD BRING THEIR LAPTOP)
Course Contents
DAY ONE
Basic Facts on Data Analytics & Power BI
- Data analysis overview
- Roles in data
- Functions of Data Analysts
- Using Power BI
- Building Blocks of Power BI
- Power BI service
- Installing Power BI desktop
- Power BI service subscription types
- Other data analysis tools
- Power BI ecosystem.
DAY TWO
Getting and Preparing Data for Analysis
- Getting data from various sources
- Getting data from No SQL database
- Shape and simplify data structure
- Merging and appending data tables
- Data profiling
- Evaluate and change column data types
- The M code
- The Power Query editor and interface
- Basic data transformation and loading
- Advanced data transformation and loading.
DAY THREE
Data Modeling and DAX Language
- Tables, dimensions and data granularity
- Relationship and granularity
- Introduction to the DAX language
- Context and the calculation function
- Time intelligence measures in DAX
- Quick measures
- Calculated column vs measures
- Implicit and explicit measures.
DAY FOUR
Visualizing Data
- Choosing and adding visualization to reports
- Design a report layout
- Conditional formatting
- Slicing and filtering reports
- Dashboards and configurations
- Exploring data with questions and answers
- Working with Power BI service
- Data schedule and refresh
- Row level security
DAY FIVE
Advanced Analytics and Power BI Service
- Analytics and statistical summary
- Identifying outliers with visuals
- Clustering techniques, grouping ans bins
- Conducting time series analysis
- Applying AI insights
- Working with AI Visuals
- Key influencers and decomposition AI visuals
- Working with Power BI service
- Data schedule and refresh
- Row level security.