CEP24 Scholarship on Data Analysis & Visualization with PowerBI
Learn how to analyse data using Microsoft Power BI and sharpen your business acumen. Acquire practical experience, uncover insightful information, and become an expert in data visualization.
CEP24 Partially Funded Scholarship on Data Analysis & Visualization with PowerBI
PowerBI Training
Get new abilities in data modeling, data analysis, and data visualisation with our Microsoft Power BI training program. You will acquire a thorough understanding of Power BI during this course, along with strategies for utilizing its ability to convert unprocessed data into insightful and actionable insights.
Physical/Online Classes
Feb. 1st – Mar. 1st 2024
Cost
N22,500
with CertificateÂ
Duration
4 Wks
Highlights
Course Details
Power BI Training Courses Introduction
- Power BIÂ – What is it and why use it?
- Power BIÂ Desktop vs Services – What is best for your use case?
- Power BIÂ vs other BI tools (Gartner Magic Quadrant)
- Power BI User Interface Training
- Customising Visuals vs Theme vs Data Model
- Power BI Course contents reviewÂ
Power BI Training for Desktop
- Data Models – How to structure your data using data science
-    Power BI’s Schemas – Data structure definition
- Â Â Â Relationships – How data in one table relates to another
- Â Â Â Connectivity – Connection options, e.g. real-time or stored/refreshed
- Â Â Â Design Environment – Learning how to build reports.
- Â Â Â Importing Data – How to get data into a data model.
- Â Â Â Dashboards in Desktop
- Â Â Â Get data from different sources
- Â Â Â Custom Colours
- Â Â Â Desktop Three views
- Â Â Â Data View: Column Sort, formatting, hiding columns
- Â Â Â Relationship view: create and manage relationships
- Â Â Â Create and format visuals
- Â Â Â Slicers
- Â Â Â Publish reports/Dashboards
More on "Power BI Training"
- Power BI Training with your data
- Query Editor in brief
- Query Design explained
- Query editors tabs and menus
- Best Practice for Queries
- Applied Steps
- Advanced Query Editor
- Data Transformations
- Data cleaning
- Dataset merges
- Accessing Excel and csv data
- Merging techniques
- Managing Columns
Power BI Dashboard, Reports & Visualisations
- Power BIÂ Reading View – Seeing what users see.
- Editing View – Customising user experience.
- Visualisations and Custom Visualisations – Telling a compelling story.
- Creating visuals (with no programming)
- Choosing the best visual
- Interactivity between visuals
- Formatting visuals and charts
- Types of Conditional Formatting
- Show matrix values on Rows vs Side by side
- Customise matrix column subtotals
- Matrix Drill-Down tools
- Viewing the Underlying Data Driving a Visualisation
DAX & Calculations in POWER BI
- Data Analysis Expressions – Powerful versatility at your command.
- Â Â Â Calculated Columns – Extending data tables.
- Â Â Â Measures – How your data is summarised.
- Â Â Â Â DAXÂ Syntax – Learning the basic grammar of formula writing.
- Â Â Â DAX Functions – Building blocks for data manipulation.
- Â Â Â Dax Operators
- Â Â Implicit Vs Explicit measures
- Â Â Â Measures vs Calculated Columns
- Â Â Â Commonly Used DAX Functions
- Â Â Â DAX Aggregate functions
- Â Â Â IF conditional statements
- Â Â Â Evaluating Context in the relationship
Importing & Transforming Datasets
- Queries & the Query Editor – Controlling the data import process
- Shaping & Cleansing Data – Making real-world data usable.
- Combining Datasets and data sources – Appending and merging data from different sources.
- Functions – The M library of powerful data manipulation capability.
- Loading Transformed Data – Populating the Power BI data model.
Who should attend
DAX & Calculations in POWER BI
The Power BI training course is beneficial for business analysts, financial analysts, quants, data scientists, financial traders, data engineers and staff members who need to use Microsoft Power BI for producing reports from Excel (Power Pivot), SQL Server, Python, and other databases and/or data sets.
