Learn Microsoft Power BI

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations.

Acquire the Skills to Query Data, Transform it, Visualize it and Publish it.

Learn how to:

Query data from

  • Excel
  • Databases
  • Web
  • Web Services
  • Text files

Transform data by

  • Cleaning
  • Pivoting
  • Enriching
  • Calculating

Communicate insights by

  • Creating dashboards
  • Adding interactivity
  • Publishing dashboards for others to use


Power BI is a new tool that empowers you to be a master of data rather than a servant of it.

Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards.

The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you.

SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations.

The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations.

The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt

The files I use on the course are available for you to download..

It can take between 2 and 4 hours to take this course (including assignments).

There are over 2 hours of screencasts.

The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards.

The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data.

Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button.

Who this course is for:

  • This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10)
  • Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material.
  • If you have any doubt please sample one of the lectures.
  • If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions.

Expected Outcomes

  1. Transform data into interactive visualisations to tell a story Turn data into insight with Power BI and share it with others Develop data modelling skills Learn how to automate the cleansing of data Query data from sources such as Text Files, Excel, Databases, the Web Requirements Access to Windows 7 + is required. Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service. Internet Explorer 9+ is a prerequisite for Power BI Desktop For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so. During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source. Description This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations. Acquire the Skills to Query Data, Transform it, Visualize it and Publish it. Learn how to: Query data from Excel Databases Web Web Services Text files Transform data by Cleaning Pivoting Enriching Calculating Communicate insights by Creating dashboards Adding interactivity Publishing dashboards for others to use Power BI is a new tool that empowers you to be a master of data rather than a servant of it. Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards. The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you. SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations. The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations. The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt The files I use on the course are available for you to download.. It can take between 2 and 4 hours to take this course (including assignments). There are over 2 hours of screencasts. The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards. The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data. Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button. Who this course is for: This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10) Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material. If you have any doubt please sample one of the lectures. If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions. Show more Show less Course content 7 sections • 43 lectures • 2h 30m total length Expand all sections Getting Started 10 lectures • 27min What does the course cover? Preview 00:59 Objectives: Getting Started 00:54 Getting set up 01:05 Power BI install from the Microsoft Store (March 2018+) 01:37 First look at the user interface 07:27 Assignment 1: Getting Started 00:10 Your first visualization 04:32 Styling the visualization 09:17 Assignment 2: Create a basic visualization Preview 00:08 Summary: Getting Started 01:02 Creating professional dashboards 8 lectures • 25min Objectives: Creating professional dashboards 00:45 Creating a dashboard 07:01 Adding interactivity to dashboards Preview 04:25 Drill through features 03:19 Custom Visualisations 02:46 Dashboard design best practices 04:05 Assignment 3: Creating a well designed dashboard 01:12 Summary: Creating professional dashboards 01:17 Querying data from different sources 6 lectures • 20min Objectives: Querying data from different sources 01:03 Querying a SQL Server database 06:52 Querying a text file 01:54 Querying web pages Preview 05:24 Querying web API based data 03:11 Summary: Querying data from different sources 01:16 Cleaning & Transforming Data 5 lectures • 23min Objectives: Cleaning & Transforming data 01:22 Cleaning up web data 10:27 Transforming data 09:35 Assignment 4: Querying and Cleaning data 00:13 Summary: Cleaning & Transforming Data 01:31 Publishing visualisations on Power BI.com 6 lectures • 23min Objectives: Publishing Visualisations on Power BI.com 01:28 Publishing your visualisations 10:31 Refreshing data 04:47 Creating Content Packs 04:37 Assignment 5: Publishing and Sharing content 00:09 Summary: Publishing Visualisations on Power BI.com 01:30 Bonus Lectures 3 lectures • 15min Creating a data model 07:58 Creating calculated columns to enrich the data model 04:29 Importing an Excel data model 02:59 New features as of Oct-16 5 lectures • 17min Introduction to new features 01:29 Line Chart Drill Down 02:24 New Drill Down features 03:03 Slicer searching 03:36 Mobile Reporting 06:12 Instructor Lee Hawthorn Database professional 4.2 Instructor Rating 474 Reviews 4,537 Students 2 Courses I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards, cubes in a fully automated manner. I have given training to over 200 people on the Microsoft BI stack. I've received excellent feedback too. Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile. I have a passion for sharing knowledge as I know it has the power to change the world. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781360bce900696',m:'84dd17c999423e603cf67c0010bf177fde525390-1627843397-1800-AaaTuUiYQ4GFNwyQXsA8GNqhkqPhs6B1kius+UgfDhh6nIYbiLAoFpeFlIgUjBMU4eDNdaboR4vg9VMvRCzT0nFBVYBeAoW+XLOFIuuuy3D7EUO18FvxvEkHjd2YxgF7CXJBHsGtcWUlNweHp8KUWa8XNjAgI+UzKJJjdLl7kHFz',s:[0x8f9f227008,0x4c1229823c],}})();
  2. Turn data into insight with Power BI and share it with others Develop data modelling skills Learn how to automate the cleansing of data Query data from sources such as Text Files, Excel, Databases, the Web Requirements Access to Windows 7 + is required. Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service. Internet Explorer 9+ is a prerequisite for Power BI Desktop For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so. During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source. Description This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations. Acquire the Skills to Query Data, Transform it, Visualize it and Publish it. Learn how to: Query data from Excel Databases Web Web Services Text files Transform data by Cleaning Pivoting Enriching Calculating Communicate insights by Creating dashboards Adding interactivity Publishing dashboards for others to use Power BI is a new tool that empowers you to be a master of data rather than a servant of it. Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards. The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you. SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations. The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations. The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt The files I use on the course are available for you to download.. It can take between 2 and 4 hours to take this course (including assignments). There are over 2 hours of screencasts. The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards. The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data. Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button. Who this course is for: This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10) Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material. If you have any doubt please sample one of the lectures. If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions. Show more Show less Course content 7 sections • 43 lectures • 2h 30m total length Expand all sections Getting Started 10 lectures • 27min What does the course cover? Preview 00:59 Objectives: Getting Started 00:54 Getting set up 01:05 Power BI install from the Microsoft Store (March 2018+) 01:37 First look at the user interface 07:27 Assignment 1: Getting Started 00:10 Your first visualization 04:32 Styling the visualization 09:17 Assignment 2: Create a basic visualization Preview 00:08 Summary: Getting Started 01:02 Creating professional dashboards 8 lectures • 25min Objectives: Creating professional dashboards 00:45 Creating a dashboard 07:01 Adding interactivity to dashboards Preview 04:25 Drill through features 03:19 Custom Visualisations 02:46 Dashboard design best practices 04:05 Assignment 3: Creating a well designed dashboard 01:12 Summary: Creating professional dashboards 01:17 Querying data from different sources 6 lectures • 20min Objectives: Querying data from different sources 01:03 Querying a SQL Server database 06:52 Querying a text file 01:54 Querying web pages Preview 05:24 Querying web API based data 03:11 Summary: Querying data from different sources 01:16 Cleaning & Transforming Data 5 lectures • 23min Objectives: Cleaning & Transforming data 01:22 Cleaning up web data 10:27 Transforming data 09:35 Assignment 4: Querying and Cleaning data 00:13 Summary: Cleaning & Transforming Data 01:31 Publishing visualisations on Power BI.com 6 lectures • 23min Objectives: Publishing Visualisations on Power BI.com 01:28 Publishing your visualisations 10:31 Refreshing data 04:47 Creating Content Packs 04:37 Assignment 5: Publishing and Sharing content 00:09 Summary: Publishing Visualisations on Power BI.com 01:30 Bonus Lectures 3 lectures • 15min Creating a data model 07:58 Creating calculated columns to enrich the data model 04:29 Importing an Excel data model 02:59 New features as of Oct-16 5 lectures • 17min Introduction to new features 01:29 Line Chart Drill Down 02:24 New Drill Down features 03:03 Slicer searching 03:36 Mobile Reporting 06:12 Instructor Lee Hawthorn Database professional 4.2 Instructor Rating 474 Reviews 4,537 Students 2 Courses I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards, cubes in a fully automated manner. I have given training to over 200 people on the Microsoft BI stack. I've received excellent feedback too. Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile. I have a passion for sharing knowledge as I know it has the power to change the world. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781360bce900696',m:'84dd17c999423e603cf67c0010bf177fde525390-1627843397-1800-AaaTuUiYQ4GFNwyQXsA8GNqhkqPhs6B1kius+UgfDhh6nIYbiLAoFpeFlIgUjBMU4eDNdaboR4vg9VMvRCzT0nFBVYBeAoW+XLOFIuuuy3D7EUO18FvxvEkHjd2YxgF7CXJBHsGtcWUlNweHp8KUWa8XNjAgI+UzKJJjdLl7kHFz',s:[0x8f9f227008,0x4c1229823c],}})();
  3. Develop data modelling skills Learn how to automate the cleansing of data Query data from sources such as Text Files, Excel, Databases, the Web Requirements Access to Windows 7 + is required. Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service. Internet Explorer 9+ is a prerequisite for Power BI Desktop For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so. During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source. Description This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations. Acquire the Skills to Query Data, Transform it, Visualize it and Publish it. Learn how to: Query data from Excel Databases Web Web Services Text files Transform data by Cleaning Pivoting Enriching Calculating Communicate insights by Creating dashboards Adding interactivity Publishing dashboards for others to use Power BI is a new tool that empowers you to be a master of data rather than a servant of it. Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards. The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you. SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations. The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations. The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt The files I use on the course are available for you to download.. It can take between 2 and 4 hours to take this course (including assignments). There are over 2 hours of screencasts. The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards. The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data. Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button. Who this course is for: This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10) Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material. If you have any doubt please sample one of the lectures. If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions. Show more Show less Course content 7 sections • 43 lectures • 2h 30m total length Expand all sections Getting Started 10 lectures • 27min What does the course cover? Preview 00:59 Objectives: Getting Started 00:54 Getting set up 01:05 Power BI install from the Microsoft Store (March 2018+) 01:37 First look at the user interface 07:27 Assignment 1: Getting Started 00:10 Your first visualization 04:32 Styling the visualization 09:17 Assignment 2: Create a basic visualization Preview 00:08 Summary: Getting Started 01:02 Creating professional dashboards 8 lectures • 25min Objectives: Creating professional dashboards 00:45 Creating a dashboard 07:01 Adding interactivity to dashboards Preview 04:25 Drill through features 03:19 Custom Visualisations 02:46 Dashboard design best practices 04:05 Assignment 3: Creating a well designed dashboard 01:12 Summary: Creating professional dashboards 01:17 Querying data from different sources 6 lectures • 20min Objectives: Querying data from different sources 01:03 Querying a SQL Server database 06:52 Querying a text file 01:54 Querying web pages Preview 05:24 Querying web API based data 03:11 Summary: Querying data from different sources 01:16 Cleaning & Transforming Data 5 lectures • 23min Objectives: Cleaning & Transforming data 01:22 Cleaning up web data 10:27 Transforming data 09:35 Assignment 4: Querying and Cleaning data 00:13 Summary: Cleaning & Transforming Data 01:31 Publishing visualisations on Power BI.com 6 lectures • 23min Objectives: Publishing Visualisations on Power BI.com 01:28 Publishing your visualisations 10:31 Refreshing data 04:47 Creating Content Packs 04:37 Assignment 5: Publishing and Sharing content 00:09 Summary: Publishing Visualisations on Power BI.com 01:30 Bonus Lectures 3 lectures • 15min Creating a data model 07:58 Creating calculated columns to enrich the data model 04:29 Importing an Excel data model 02:59 New features as of Oct-16 5 lectures • 17min Introduction to new features 01:29 Line Chart Drill Down 02:24 New Drill Down features 03:03 Slicer searching 03:36 Mobile Reporting 06:12 Instructor Lee Hawthorn Database professional 4.2 Instructor Rating 474 Reviews 4,537 Students 2 Courses I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards, cubes in a fully automated manner. I have given training to over 200 people on the Microsoft BI stack. I've received excellent feedback too. Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile. I have a passion for sharing knowledge as I know it has the power to change the world. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781360bce900696',m:'84dd17c999423e603cf67c0010bf177fde525390-1627843397-1800-AaaTuUiYQ4GFNwyQXsA8GNqhkqPhs6B1kius+UgfDhh6nIYbiLAoFpeFlIgUjBMU4eDNdaboR4vg9VMvRCzT0nFBVYBeAoW+XLOFIuuuy3D7EUO18FvxvEkHjd2YxgF7CXJBHsGtcWUlNweHp8KUWa8XNjAgI+UzKJJjdLl7kHFz',s:[0x8f9f227008,0x4c1229823c],}})();
  4. Learn how to automate the cleansing of data Query data from sources such as Text Files, Excel, Databases, the Web Requirements Access to Windows 7 + is required. Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service. Internet Explorer 9+ is a prerequisite for Power BI Desktop For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so. During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source. Description This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations. Acquire the Skills to Query Data, Transform it, Visualize it and Publish it. Learn how to: Query data from Excel Databases Web Web Services Text files Transform data by Cleaning Pivoting Enriching Calculating Communicate insights by Creating dashboards Adding interactivity Publishing dashboards for others to use Power BI is a new tool that empowers you to be a master of data rather than a servant of it. Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards. The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you. SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations. The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations. The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt The files I use on the course are available for you to download.. It can take between 2 and 4 hours to take this course (including assignments). There are over 2 hours of screencasts. The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards. The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data. Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button. Who this course is for: This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10) Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material. If you have any doubt please sample one of the lectures. If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions. Show more Show less Course content 7 sections • 43 lectures • 2h 30m total length Expand all sections Getting Started 10 lectures • 27min What does the course cover? Preview 00:59 Objectives: Getting Started 00:54 Getting set up 01:05 Power BI install from the Microsoft Store (March 2018+) 01:37 First look at the user interface 07:27 Assignment 1: Getting Started 00:10 Your first visualization 04:32 Styling the visualization 09:17 Assignment 2: Create a basic visualization Preview 00:08 Summary: Getting Started 01:02 Creating professional dashboards 8 lectures • 25min Objectives: Creating professional dashboards 00:45 Creating a dashboard 07:01 Adding interactivity to dashboards Preview 04:25 Drill through features 03:19 Custom Visualisations 02:46 Dashboard design best practices 04:05 Assignment 3: Creating a well designed dashboard 01:12 Summary: Creating professional dashboards 01:17 Querying data from different sources 6 lectures • 20min Objectives: Querying data from different sources 01:03 Querying a SQL Server database 06:52 Querying a text file 01:54 Querying web pages Preview 05:24 Querying web API based data 03:11 Summary: Querying data from different sources 01:16 Cleaning & Transforming Data 5 lectures • 23min Objectives: Cleaning & Transforming data 01:22 Cleaning up web data 10:27 Transforming data 09:35 Assignment 4: Querying and Cleaning data 00:13 Summary: Cleaning & Transforming Data 01:31 Publishing visualisations on Power BI.com 6 lectures • 23min Objectives: Publishing Visualisations on Power BI.com 01:28 Publishing your visualisations 10:31 Refreshing data 04:47 Creating Content Packs 04:37 Assignment 5: Publishing and Sharing content 00:09 Summary: Publishing Visualisations on Power BI.com 01:30 Bonus Lectures 3 lectures • 15min Creating a data model 07:58 Creating calculated columns to enrich the data model 04:29 Importing an Excel data model 02:59 New features as of Oct-16 5 lectures • 17min Introduction to new features 01:29 Line Chart Drill Down 02:24 New Drill Down features 03:03 Slicer searching 03:36 Mobile Reporting 06:12 Instructor Lee Hawthorn Database professional 4.2 Instructor Rating 474 Reviews 4,537 Students 2 Courses I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards, cubes in a fully automated manner. I have given training to over 200 people on the Microsoft BI stack. I've received excellent feedback too. Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile. I have a passion for sharing knowledge as I know it has the power to change the world. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781360bce900696',m:'84dd17c999423e603cf67c0010bf177fde525390-1627843397-1800-AaaTuUiYQ4GFNwyQXsA8GNqhkqPhs6B1kius+UgfDhh6nIYbiLAoFpeFlIgUjBMU4eDNdaboR4vg9VMvRCzT0nFBVYBeAoW+XLOFIuuuy3D7EUO18FvxvEkHjd2YxgF7CXJBHsGtcWUlNweHp8KUWa8XNjAgI+UzKJJjdLl7kHFz',s:[0x8f9f227008,0x4c1229823c],}})();
  5. Query data from sources such as Text Files, Excel, Databases, the Web Requirements Access to Windows 7 + is required. Near the start of the course you'll be directed to download and install Power BI Desktop and sign up for the free Power BI.com service. Internet Explorer 9+ is a prerequisite for Power BI Desktop For lecture 17 (Refreshing Data) Power BI Professional (Paid version) is required. However, if you want to follow along without paying you may be able to start a 60 day trial if you have not previously done so. During the course I teach how to query SQL Server databases for the benefit of students who need to query this data source. However, if you don't have access to SQL Server there is no need to install it as the assignment doesn't use it as a data source. Description This course introduces you to Power BI from Microsoft. Power BI is easy to use software & services that can be used to turn data into actionable insight so that you can convey stories to yourself and others through the use of highly interactive visualisations. Acquire the Skills to Query Data, Transform it, Visualize it and Publish it. Learn how to: Query data from Excel Databases Web Web Services Text files Transform data by Cleaning Pivoting Enriching Calculating Communicate insights by Creating dashboards Adding interactivity Publishing dashboards for others to use Power BI is a new tool that empowers you to be a master of data rather than a servant of it. Previously these skills were limited to experts but with the modern software the technical barrier has been lowered to such an extent that most people are capable of producing and sharing dashboards. The only prerequisite I have is that students must be data literate. Excel users will have no problem learning Power BI. If you don't know what a table of data is this course isn't for you. SQL or BI developers probably won't get a lot from this course as there aren't any complex queries or calculations. The type of terminology used on this course includes, Tables, Relationships, Models, Calculations, Visualizations. The course is taught using screencasts, slides, with set assignments. I encourage you to have a go at the assignments as this will solidify what you've learnt The files I use on the course are available for you to download.. It can take between 2 and 4 hours to take this course (including assignments). There are over 2 hours of screencasts. The course is structured using key learning points, starting at the very beginning and progressing so that may the end of the course you'll have the skills to create data models with dashboards. The skills you'll gain on this course will help boost your career as you'll be seen as a powerful steward of data. Power BI is becoming increasingly in demand in organisations of all sorts of sizes. Take advantage of this opportunity today and hit that enroll button. Who this course is for: This course is targeted at Excel users who are able to format a table and write simple formulas such as SUM(A1:A10) Excel knowledge is not required. Anyone who understands basic tables should be fine with the course material. If you have any doubt please sample one of the lectures. If you are a BI or SQL developer this course is probably not for you as you won't find complex queries or functions. Show more Show less Course content 7 sections • 43 lectures • 2h 30m total length Expand all sections Getting Started 10 lectures • 27min What does the course cover? Preview 00:59 Objectives: Getting Started 00:54 Getting set up 01:05 Power BI install from the Microsoft Store (March 2018+) 01:37 First look at the user interface 07:27 Assignment 1: Getting Started 00:10 Your first visualization 04:32 Styling the visualization 09:17 Assignment 2: Create a basic visualization Preview 00:08 Summary: Getting Started 01:02 Creating professional dashboards 8 lectures • 25min Objectives: Creating professional dashboards 00:45 Creating a dashboard 07:01 Adding interactivity to dashboards Preview 04:25 Drill through features 03:19 Custom Visualisations 02:46 Dashboard design best practices 04:05 Assignment 3: Creating a well designed dashboard 01:12 Summary: Creating professional dashboards 01:17 Querying data from different sources 6 lectures • 20min Objectives: Querying data from different sources 01:03 Querying a SQL Server database 06:52 Querying a text file 01:54 Querying web pages Preview 05:24 Querying web API based data 03:11 Summary: Querying data from different sources 01:16 Cleaning & Transforming Data 5 lectures • 23min Objectives: Cleaning & Transforming data 01:22 Cleaning up web data 10:27 Transforming data 09:35 Assignment 4: Querying and Cleaning data 00:13 Summary: Cleaning & Transforming Data 01:31 Publishing visualisations on Power BI.com 6 lectures • 23min Objectives: Publishing Visualisations on Power BI.com 01:28 Publishing your visualisations 10:31 Refreshing data 04:47 Creating Content Packs 04:37 Assignment 5: Publishing and Sharing content 00:09 Summary: Publishing Visualisations on Power BI.com 01:30 Bonus Lectures 3 lectures • 15min Creating a data model 07:58 Creating calculated columns to enrich the data model 04:29 Importing an Excel data model 02:59 New features as of Oct-16 5 lectures • 17min Introduction to new features 01:29 Line Chart Drill Down 02:24 New Drill Down features 03:03 Slicer searching 03:36 Mobile Reporting 06:12 Instructor Lee Hawthorn Database professional 4.2 Instructor Rating 474 Reviews 4,537 Students 2 Courses I'm a business intelligence professional who has 10 years’ experience turning data into information. I work with companies in the UK & Ireland to help them by building systems that provide reports and dashboards, cubes in a fully automated manner. I have given training to over 200 people on the Microsoft BI stack. I've received excellent feedback too. Having worked for some of the largest organisations I’ve seen personally have BI can be used to improve business performance. I blog about BI & Data Analytics see blog link in my profile. I have a passion for sharing knowledge as I know it has the power to change the world. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781360bce900696',m:'84dd17c999423e603cf67c0010bf177fde525390-1627843397-1800-AaaTuUiYQ4GFNwyQXsA8GNqhkqPhs6B1kius+UgfDhh6nIYbiLAoFpeFlIgUjBMU4eDNdaboR4vg9VMvRCzT0nFBVYBeAoW+XLOFIuuuy3D7EUO18FvxvEkHjd2YxgF7CXJBHsGtcWUlNweHp8KUWa8XNjAgI+UzKJJjdLl7kHFz',s:[0x8f9f227008,0x4c1229823c],}})();