PowerBI Certification Program

Explore Power BI and its Power Platform ecosystem to analyze data from ERP, CRM, and databases, delivering descriptive and diagnostic insights for data-driven decisions.

Explore Power BI Desktop basics by importing an Excel file, transforming data with Power Query, and using operations like merge, append, and fill to prepare call center data for analysis.

Learn to load and transform data in Power BI via Power Query, understand M language, manage date formats, remove blanks and duplicates, and create calculated columns for clean data.

Learn basic data operations in power BI during loading: transform data, create a joined table, and build a star schema by joining issue type and issue ID with proper relationships.

Create visuals by dragging fields and using maps for geography, then prepare data in Power Query by adding or removing columns and building relationships; get introduced to dex.

Explore loading and saving data, create a Power Query column for total time, and use a measure to express talk time as a percentage.

Explore diverse Power BI visuals from clustered column and bar charts to line charts with secondary axes, pie, treemap, maps, gauge, funnel, scatter, ribbon, and waterfall visuals.

Master creating measures in Power BI to summarize data, control distinct values, perform group-by operations with visuals and drill-downs, and compute remaining time as a percentage of total time.

Master creating new columns and measures, computing remaining time and percentage, and building pie and heatmap visuals with Power BI for certification readiness.

Explore more visuals in Power BI by creating and sorting custom date columns, joining tables, and building interactive visuals.

Learn the basics of SQL by installing the server express, creating a test database, building and querying tables, inserting data, and understanding primary keys, constraints, and nulls.

Learn to perform update, delete, and select operations in SQL with proper where clauses and primary key constraints, then import CSV data into SQL Server for Power BI.

Master the group by clause to summarize data, identify duplicates with distinct, and compute counts efficiently. Build tables, apply update statements, and design dimensions and fact tables for analytics.

Master group by scenarios in Power BI by exploring inner joins, left outer joins, full joins, and self joins, with practical filtering on clothing subcategories and city data.

Learn to detect and remove duplicates in Power BI data, using select distinct, group by, and having, with practical SQL-style validation and filtering for accurate city and region data.

Connect to SQL Server to load data, build and test a theme with visuals, and save it as a logo-enabled template for organization-wide use in PowerBI.

Create a date table in Power BI by building and customizing calendar data with add columns and date functions, then save as a reusable template for end users.

Customize teams in Power BI, then perform Power Query data preparation by building and relating tables such as customer, city, and articles, with custom columns.

Learn to create custom and index columns, join and clean data, remove duplicates, and pivot and unpivot transformations to shape Power BI reports.

Refine the data model by pruning unnecessary tables and columns, hiding unused fields, and preparing the data layer for efficient visualization and analysis.

Enhance the date table in Power BI by adding month, quarter, week start dates, and financial year columns, and apply time intelligence functions to build a robust calendar.

Create and correct date columns in Power BI to handle calendar and financial year starts, start and end of months, and accurate quarters and year ends.

Learn to calculate start and end of financial quarters in Power BI using DAX, with and without time intelligence, handling non-standard quarter starts and testing logic.

Learn to calculate and format date fields in Power BI, derive the financial year and month numbers, and explore calendar options including calendar auto and min/max date methods.

Calculate week dates in Power BI using time intelligence and today-based calendars, including independent calendars, week start, end of week, and end-of-period logic.

Develop a weekday start logic to build a calendar, selecting starts like Friday or Monday and adjusting with subtraction to align dates with weekdays for Power BI.

Explore power BI time intelligence for standard and non-standard calendars, build date tables (week, month, quarter), and apply column and week ranks with start dates and workdays.

Learn to enrich a Power BI date table by creating min date logic, ranking by date, correcting weekend tweaks, and building flags for this month, last month, and financial year.

Explore date references such as this month, yesterday, and this year, and learn lookups and creating related columns in Power BI with Power Query for one-to-many and many-to-one relationships.

Create a gross amount column from quantity and unit price, bucket discount percentages with static segmentation, and apply window functions to retrieve a customer's previous and last orders by date.

Explore date tables and cross-table operations in Power BI, including calculating next order dates, continuous workday logic, and using related functions to move data.

Explore core Power BI concepts by refining a data model, building dimensions in Power Query, and developing measures, gross, discount, net, and margin, using sumx and other x functions.

Learn to design and organize Power BI measures by creating a dedicated major table, compute discount percentage as discount amount over gross, and format and group measures for clear analysis.

Learn to configure table visuals by adjusting styles, grid lines, header and value formatting, tooltips, titles, and conditional formatting to control layout and readability.

Explore drilldown and pivot in Power BI by working with table and matrix visuals, drilling down through categories, adjusting rows and columns, and using sort and focus features.

Learn to format Power BI layouts by configuring metrics visuals, sorting totals and subtotals, and applying conditional formatting, tooltips, and axis options in matrix and clustered column charts.

Extend the range of the date table by correcting calendar mappings and handling blanks, then apply concatenated labels and sorting while exploring axis and small multiples in Power BI.

Create and customize stacked bar chart visuals in Power BI, adjusting axis categories and values, legends, titles, font size, colors, data labels, and percentage options.

Explore creating line charts with small multiples, tooltips, and multiple series, and learn to manage axes—continuous vs categorical, primary and secondary axes, plus zoom and log scale options.

Explore Power BI area visuals and donut/pie visuals, configuring constant and average lines, axes options, color schemes, and data labels to reveal insights and distributions.

Master PowerBI pie charts by adjusting legends, renaming categories, and configuring by region with conditional formatting; explore doughnut options, labels, and tooltips for clear data insights.

Explore how to build and interpret scatter charts in Power BI, using numeric axes, bubble size, color, and shape to analyze discount versus margin, growth, and top-line impact.

Explore Power BI visuals like histogram and multi-row card, tune interactions and filtering, and leverage conditional formatting and data labels for richer dashboards.

Explore how to configure the map visual in Power BI, including geocoding, city and state displays, bubble size, color, legend, conditional formatting, and zoom controls.

Power BI shape map visual lets you add a map with boundaries and keys, adjust color saturation and data color (diverging), and set min and max, titles, and transparency.

Explore how Power BI visuals interact through filtering, cross-filtering, and slicer settings; manage overlapping visuals, adjust display units, and design interactive dashboards.

Master Power BI visual interactions by configuring filters, separating visuals into non-interacting panels for two-brand comparisons, and using decomposition trees to explore drivers behind brand performance.

Explore Power BI visuals beyond tables, including sunburst and bullet charts, then add and configure visuals, using category, legends, and filters to drive interactive insights.