image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

According to Microsoft, Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.  It is made up of three elements - a Windows desktop application called
Power BI Desktop
, an online software as a service (SaaS) service called the
Power BI service
and Power BI Mobile apps for Windows, iOS, and Android devices - all designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.
If you would like to become a Power BI master then this course will give you all the knowledge and skills you need!
COURSE CONTENT AND OUTCOMES:
Understand the flow of using Power BI, from connecting to various data sources, importing these into Power BI, transforming the data and then presenting it effectively
Learn how to use Power BI Desktop, Power BI Query Editor & the Power BI Service
Learn how to create relationships between related data sources
Learn how to build reports with various types of aggregations and filters
Learn about the various types of visualizations possible in Power BI and how to use them
Learn how to create interactive dashboards with drill throughs and relative date filters
Learn how to publish dashboards to the web and mobile app
Learn how to use themes and custom visualizations
Learn about DAX and how to use it to build measures
Learn how to work with Excel & Power BI to create a dynamic and effective business solution
Learn how to put this all into practice with a case study about the Corona Virus. 
REQUIREMENTS:
You will need to have a PC/Windows laptop loaded with the latest version of Microsoft Power BI (available as a free download).  Note that Power BI does not currently run natively on a Mac.
Whilst this course is designed to cover Power BI from the ground up, some experience of working with data in Excel would be beneficial.
ABOUT THE TRAINER
I am a Udemy Instructor Partner with more than 20 years' experience in training & management consulting. I specialise in training business users 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
It was a great course. Highly recommended for people interesting to develop new skills and knowledge in data analytics tools.
The step-by-step process along with the comparison to Excel helped tremendously in the understanding of the course.
This was an excellent course to learn Power BI. I loved the hands-on experience that this training provided. This course went at the right pace and gave me a solid starting foundation to use Power BI.
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
Google
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
Who this course is for:
All Excel users who work with data, reports or dashboards
All existing Business Intelligence developers and users
Anyone who wants to get an excellent foundation in how to use Power BI from beginner level

What you'll learn

Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P video

Learn to create POWERFUL reports and dashboards with Microsoft Power BI with a few clicks of the mouse

Gain valuable INSIGHT and INTELLIGENCE from your business and marketing data in a FRACTION of the time of traditional spreadsheets

PUBLISH reports and dashboards on the Internet and view using laptops, tablets or smartphones in minutes

Learn to create Data Models and use the DAX Formula language to develop POWERFUL calculations

Easily create a wide range of GRAPHS and VISUALISATIONS using drag and drop technologies

Use the Power BI Q & A feature to easily ask QUESTIONS of your data and provide new insight

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
3
1.1-Introduction to Power BI
1.2-About the Course
1.3-Download the Training Data Files
2-Sign Up for Power BI
4
2.1-Introduction to Signing Up for Power BI
2.2-Signing up for Power BI
2.3-Load Data into the Power BI Service
2.4-Practical Activity
3-The Power BI Desktop
3
3.1-Introduction to Power BI Desktop Section
3.2-Options and Settings
3.3-Overview of Power BI Desktop
4-Creating Tables in Power BI Desktop
14
4.1-Create Tables in Power BI Desktop Section
4.2-Creating Tables in Power BI
4.3-Table Styles and Formatting
4.4-Tables Practical Activity
4.5-Answers to Tables Practical Activity
4.6-Cross Filtering Tables
4.7-Changing the Method of Aggregation
4.8-Methods of Aggregation Practical Activity
4.9-Methods of Aggregation Challenge Completed
4.10-Matrix Visualization
4.11-Cards Visualization
4.12-Cards and Matrix Practical Activity
4.13-Cards and Matrix Completed Activity
4.14-Working with Dates
5-Visual Calculations
3
5.1-Introduction to Visual Calculations
5.2-Visual Calculations Part 1
5.3-Visual Calculations Part 2
6-Filters and Slicers
10
6.1-Introduction to Filters and Slicers
6.2-Using Slicers - Text
6.3-Using Slicers - Numeric
6.4-Using Slicers - Date
6.5-Visual Level Filters - Text
6.6-Visual Level Filters - Numeric
6.7-Visual Level Filters - Date
6.8-Filtering Data - Page and Report Filters
6.9-Practical Activity - Filters
6.10-Practical Activity Filters Completed
7-Graphs and Visualizations
11
7.1-Introduction to Graph Visualization Section
7.2-Clustered Column Graphs
7.3-Stacked and 100% Graphs
7.4-Column Graph Challenge
7.5-Column Graph Challenge Completed
7.6-Graph Options
7.7-Reference Lines
7.8-Trend Analysis Graphs
7.9-Trends and Forecasting
7.10-Area Graphs
7.11-Additional Graphs
8-Interactive Dashboards
11
8.1-Creating Interactive Dashboards
8.2-Challenge - Create an Interactive Report
8.3-Completed Challenge - How to Create an Interactive Report
8.4-Publishing Reports to the Power BI Service
8.5-Pinning Visualizations to Dashboards
8.6-Mobile Reports
8.7-Q and A
8.8-App Workspaces
8.9-Publishing an App
8.10-Using Custom Visualizations
8.11-Using Themes in Power BI
9-DAX Formulas
5
9.1-Introduction to Calculated Columns
9.2-DAX Calculated Columns
9.3-Date Functions
9.4-Formatting Dates
9.5-Date Master Tables
10-DAX Measures
6
10.1-Introduction to Measures Section
10.2-Introduction to DAX Measures
10.3-DAX Measures Practical Activity
10.4-DAX Measures Activity Completed
10.5-The =Calculate Formula
10.6-DAX Query View
11-Relationships
3
11.1-Relationships Section
11.2-Creating and Managing Relationships in Power BI
11.3-Relationship Calculations
12-Power BI Query Editor
4
12.1-Introduction to Power BI Query Editor
12.2-Basic Transformations - Part 1
12.3-Basic Transformations - Part 2
12.4-Summary Tables
13-Analyze Data with Excel
3
13.1-Introduction to Power BI and Excel
13.2-Power BI and Excel
13.3-Power BI and Power Point
14-Conclusion
2
14.1-Conclusion
14.2-Useful Resources and Links