
Explore how to download and install power bi desktop, load datasets, and build interactive reports and dashboards with tables, matrices, visualizations, and cross-filtering to analyze multiple data sources.
Download Power BI Desktop, the free version for dashboards and reports. Learn when to upgrade to Power BI service to share with your team, and install steps.
Learn to import data into Power BI from Excel and other sources, load three tables, transform as needed, and build visuals by dragging fields.
Explore building tables and matrices with real data, apply cross filtering, use filters on visuals and pages, and format tables to create a professional Power BI look.
Create and populate a Power BI table with profit, product category, and products container from the Excel stall data. Then apply formatting, titles, borders, and style options to improve readability.
learn to filter power bi visuals using profit filters, country and customer segment criteria, and compare aggregations such as sum, percentage of total, and average.
Master dynamic cross filtering and slicers to filter all visuals on a page, set interactions to none, and use slicers for ship date and product category.
Explore matrix visualizations in Power BI, breaking down regional sales by product category with drill down and drill through to reveal underlying business drivers.
Build a Power BI table of sales by product category and profit by region with shipment as a secondary row. Apply filters and a quantity slicer (5–20) to synchronize visuals.
Power BI essentials: explore cards and multiracial cards, bar and column charts, line graphs for time series, maps, tree maps, and scatterplots.
Learn how to use card visualizations in power bi to display key metrics like gross sales and gross profit on dashboards, format values as currency, and customize card visuals.
Explore how to build and format multi-row cards in Power BI to display related metrics like profit, sales, and shipping cost, including title, color, and left-bar styling.
Power BI cards activity: build a multi-row card for sales, profit, and shipping cost, format as USD with two decimals, and add a centered white-on-black title 'financials' at 25.
Master stacked and clustered bar charts in Power BI to visualize profit by customer segments and product categories, using data colors and labels for clear insights.
Explore stacked versus clustered bar charts and master cross filtering and cross highlighting in Power BI, observing how selections affect other visuals and the difference between filtering and highlighting.
Explore Power BI bar chart analytics by applying constant lines and min, max, average, and median and percentile references to a clustered column, with customizable colors, transparency, and labels.
Explore how 100% stacked bar charts show each product category's contribution to profit by customer segment as percentages, and understand their limitations in conveying total profit values.
Learn to build a stacked bar chart of sales by customer segment and a clustered column chart in Power BI, apply filters, add average line, and set interactions to filter.
Load the financial dataset in Power BI and create a line graph to analyze time series trends, seasonality, and hierarchical drill-down from year to quarter to month.
Explore filtering time series data in Power BI with line graphs and bar charts, using internal and cross filtering by country across year, quarter, and month hierarchies.
Explore time series analytics on a line graph by adding trend and constant lines, adjusting filters, and using forecast to project six months ahead.
Use area charts to visualize time series and sales over time, drill down to yearly levels, and split by country with stacked area charts for clear trends.
Explore time series analysis in Power BI by building a line chart of sales over time, enabling year–month detail, product filters, and an 80 percent forecast for six months.
Explore the remaining Power BI charts and graphs, including pie and doughnut charts, funnels, maps, and ribbon charts, and learn practical formatting and interpretation for sales and marketing data.
Explore how to create and use data relationships in Power BI by linking bike sales and products tables, and analyze cross-table metrics with visuals like pie charts and bar charts.
Discover how to create new calculated columns from existing data and simple calculated measures using the equals calculate formula in Power BI, and how basic coding expands your AI-enabled capabilities.
Create calculated columns in Power BI to compute cost of goods sold from units sold and unit cost, format as currency, calculate margin percentage, and use these fields in visuals.
Master calculated measures in Power BI using the equals calculate function, differentiate between calculated columns and measures, and refresh the data model to update visuals across tables.
Create a DAX-based profit percentage column from profit divided by sales, format as percent; then build a measure for overall cowriter product profit percentage and display it in a card.
Master the essentials of Power BI by loading data into models, building tables and measures, and exploring visuals, analytics, and relationships, plus basics of calculated columns and measures.
How would you like to be able to QUICKLY visualise your business data to extract GENUINE, VALUE ADDING insight, using a completely FREE tool, all WITHOUT needing to know ANY CODING at all?!
The problem you face is this – businesses create more data than at any other point in history. If you aren’t able to quickly turn this data into insight, your business and career are both going to suffer…
How much value could you add in your work if you could create powerful and sophisticated data visualisations using DRAG AND DROP functionality? In this course, that’s exactly what we are going to cover! In less than 2.5 hours, you will walk away able to take on ANY business data set and rapidly extract insight that will allow you to drive the creation of business value. What do you think this new-found ability would do for your career?!
Power BI is an incredibly powerful and free to use data visualisation platform, where you can easily and effortlessly load in your business data sets and create insightful visualisations all without needing to write a SINGLE line of code. So what exactly do we cover?
Loading in your EXISTING data sets, meaning you don’t have to waste time reformatting and cleansing data, meaning you can uncover value adding insights much quicker!
Create your visualisations using drag and drop technology, so you can conduct sophisticated data analysis without needing any coding experience!
Using analysis tools within the visualisations to uncover even deeper levels of insight, meaning you can shine a whole new light on your business data and uncover a world of new opportunities for improvement!
Formatting your visualisations to make them more visually appealing, meaning you can put your analysis in front of your superiors or clients at work without the analysis ever looking unprofessional!
Learn to filter and drill down on segments of your data so you can really get under the skin of what drives business value!
If the above sounds appealing, then sign up today as this course is for you!