
Introduction to the video. Includes an overview of the BI Reporting certification and the course content.
In this lesson you will learn how to load an Excel spreadsheet into Power BI.
Introduction to using the Power BI Tables visualization
In this lesson you will learn how to create Tables using the Table visualization in Power BI.
In this lesson you will learn how to format and sort the Table visualization.
Practical activity for Tables visualization
In this lesson you will learn how to use the powerful cross filtering function in Tables
In this lesson you will learn how to use the main methods of aggregation - Sum, Count, Average, Max, Min and Distinct Count
Practical activity for Methods of Aggregation
Introduction to the Matrix and Card visualizations.
In this lesson you will learn how to create the Matrix visualization.
In this lesson we review how to create and configure the Card visualization.
Introduction to the Filters and Slicers section.
In this lesson you will learn how to use Text filters to filter your data.
In this lesson you will learn how to use numeric slicers to filter your data.
In this lesson you will learn how to use Date Slicers to filter your data.
In this lesson you will learn how to use the visual level text filter.
In this lesson you will learn how to use the visual level numeric filter.
In this lesson you will learn how to use the visual level date filter
In this lesson you will learn how to use the page and report level filters.
Introduction to the Column visualization section.
In this lesson you will learn how to use the Column visualization in Power BI.
In this lesson you will learn how to use the Stacked Column visualization
In this lesson we discuss the different filtering options that Slicers and cross filtering provide.
Practical activity for the column and bar visualiations
Introduction to the Trend Analysis.
In this lesson you will learn how to use the Line graph for trend analysis.
In this lesson you will learn how to use the Area graph for trend analysis
Practical activity for the trend analysis section.
The conclusion to the Trend Analysis section.
Introduction to the Interactive Reports section.
In this practical activity you will create an interactive report
In this lesson you will learn how to create an interactive report.
In this lesson you will learn how to publish the interactive report to the Power BI Service.
Introduction to the Power BI Service section.
In this lesson you will learn how to set up dashboards in the Power BI service.
In this lesson you will learn how to setup alerts and subscriptions in the Power BI Service.
In this lesson you will learn how to set up the mobile report view.
Skills in data analysis, reporting and the creation of dashboards are highly valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.
In this course you will learn the to use the amazing Power BI tool to create dashboards and how to use the power BI service to publish your work.
COURSE CONTENT AND OUTCOMES
Introduction and Course Content
Tables , Cards, Matrix and Multi Row Cards
Columns, Bar, Line, Pie, Treemap, graphs
Filters, Slicers and Asking questions of your data
Performing trend analysis
Creating Interactive Reports and Dashboards
Publishing to Power BI Service and Configuring Power BI Service
Creating Workspaces and publishing Apps
Using Custom visualizations and themes
Power BI and analyzing data with Microsoft Excel
ABOUT THE TRAINER
I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business professionals to learn powerful methods and techniques to transform data into useful information and intelligence as well as learning strong data analysis methodology using Microsoft Excel, Microsoft Power BI, Looker Studio (formerly Google Data Studio), Amazon QuickSight and ChatGPT.
WHAT STUDENTS ARE SAYING
Thanks for the course, I can now make reports come alive
The course really does go through everything you will need to know to start using Power BI. It will definitely help me to create some really good visuals which can be used to show visually how my team is progressing and completing the daily work. Would highly recommend this course for anyone who needs to analyse data.
Ian explained each and every detail. Gave me good insights and information required to start working on PowerBI.
DATA ANALYSIS COURSES ROADMAP
The tech industry is constantly evolving, there have been significant investments in the field of AI, machine learning and big data and this means there is a growing demand for data analysts. With the right skills and a proactive approach, a data analyst can reach unprecedented heights! I currently offer the following 14 courses on Udemy covering a wide variety of tools and skills that will empower you to confidently explore the dynamic realm of data analysis, gain valuable skills in data interpretation and drive intelligent, data driven decisions.
Microsoft Excel
Introduction to Analyzing Data with Excel Pivot Tables
Complete Introduction to Excel Power Pivot
Complete Introduction to Excel Power Query
Excel Interactive Dashboards and Data Analysis
Complete Introduction to Business Data Analysis
Tables and Formulas with Excel
Microsoft Power BI
Complete Introduction to Microsoft Power BI
Complete Introduction to Power BI Query Editor
Power BI Master Class-Data Models and DAX Formulas
Power BI Master Class - Dashboards and Power BI Service
Complete Introduction to Google Sheets Pivot Tables
Complete Introduction to Looker Studio (formerly Google Data Studio)
Amazon QuickSight
Complete Introduction to Amazon QuickSight
ChatGPT
Introduction to Analyzing Data with ChatGPT