70-778, DA-100: Analyzing and Visualizing Data with Power BI (Udemy.com)
Learn skills - Microsoft 70-778 + DA-100 certifications. Using the free Power BI Desktop, learn Power Query, DAX + more.
Created by: Phillip Burton
Produced in 2021
What you will learn
- Download for free and install and run the full version of Power BI Desktop, the BI and analysis software.
- Be able to create analyses, such as line charts, stacked bar charts, or geographic analyses using maps.
- You will be able to format numbers and dates, and add labels, tooltips and animation.
- You will be able to Get and Transform multiple sources of data, including merging multiple files from a folder, pivoting and unpivotting.
- Building and refine models, including adding calculated columns and measures.
- You will learn the important M and DAX functions, to enable you to build your own formulas.
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 90 / 100
Course Description
This course covers the content required for the Power BI 70-778 and the new DA-100 certification exams, current as per the DA-100 exam update of 24 September 2021.----------------What do students like you say about this course?
Girma says:"This is another great course taught by the instructor well-paced, every important aspects of Power BI are discussed in detail. I gained the real power of Power BI in this course."Mohan says: "Another Excellent course by Mr Burton. This course can be used as a refresher , manual reference to review, understand and use Power BI tools efficiently. Explanations are very clear and crisp. Can help from Beginner to Intermediate level learning."----------------Do you already use reporting software such as Access, SSRS, Tableau or WebI? Or is this your first reporting software tool? Either way, welcome.
In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft Power BI certification.
Power BI is one of the most requested reporting tools that are requested in the job market, and the ability to being able to use it now could be very useful for your current work, and your next job hunt.
This course comes in three parts:
Part 1 - Creating Visualizations (also known as Visualize the Data, and Analyze the Data)We'll download and install for free Power BIDesktop. We'll start by creating our firstvisualizations (vizzes) and investigate the Power BI interface.
We'll look at the various visualisations available, and go through their common properties. We'll createmaps, hierarchies, KPIs, guages, and all sorts of chart types. Part 2 - Get and Transform Data (also known as Prepare the Data)We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the Mlanguage.
Part 3 - Refining the model (also known as Model the Data)We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.
Part 4 - Power BIServiceWe'll then publish our visualisations onto the Power BIService (which you can sign up for free), and then from your reports create dashboards. With the Power BIPro (for which you can get a free trial), you can also create workspaces and apps.
The course will take around 24 hours to complete,but completing this will enable you to create vizzes, dashboards and storiesof your own, and know how to overcome common problems.
The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.
The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.
Please note: Microsoft will retire the 70-778 exam on 31 January 2021, and the DA-100 certification will be available from 2 April 2021. This course will be kept up to date with the latest requirements.
Who this course is for:
This reporting course is meant for anyone who has no prior experience of Power BI. It's also for you if you have used it, but never designed a report.
It's great if you have created analyses in other reporting tools, such as Microsoft Access, WebI, SSRS, Tableau or Yellowfin, but it not essential. If you have, then it will be another string to your bow.
It would also be good if you had prior experience in using Excel formulas, but again, that is not essential.
No prior experience in reporting tools or creating formulas is required.
This course is probably not for you if you always know how to use Power BI and know how to create reports, although we will be looking at some more advanced topics, including the M and DAX languages.
Girma says:"This is another great course taught by the instructor well-paced, every important aspects of Power BI are discussed in detail. I gained the real power of Power BI in this course."Mohan says: "Another Excellent course by Mr Burton. This course can be used as a refresher , manual reference to review, understand and use Power BI tools efficiently. Explanations are very clear and crisp. Can help from Beginner to Intermediate level learning."----------------Do you already use reporting software such as Access, SSRS, Tableau or WebI? Or is this your first reporting software tool? Either way, welcome.
In this course, learn the skills that Microsoft want you to know, and add another tool to your CV, and even go for the Microsoft Power BI certification.
Power BI is one of the most requested reporting tools that are requested in the job market, and the ability to being able to use it now could be very useful for your current work, and your next job hunt.
This course comes in three parts:
Part 1 - Creating Visualizations (also known as Visualize the Data, and Analyze the Data)We'll download and install for free Power BIDesktop. We'll start by creating our firstvisualizations (vizzes) and investigate the Power BI interface.
We'll look at the various visualisations available, and go through their common properties. We'll createmaps, hierarchies, KPIs, guages, and all sorts of chart types. Part 2 - Get and Transform Data (also known as Prepare the Data)We see how data can be transformed, saving you time in analysing the data. We'll look at sorting and filtering, split columns, and other transform activities. We'll merge, append and combine queries together. We'll Pivot and Unpivot, and transform text, numbers, dates and times, and create custom columns using the Mlanguage.
Part 3 - Refining the model (also known as Model the Data)We'll see how relationships can be made through multiple tables, and refine the data with custom columns and measures using the DAX language.
Part 4 - Power BIServiceWe'll then publish our visualisations onto the Power BIService (which you can sign up for free), and then from your reports create dashboards. With the Power BIPro (for which you can get a free trial), you can also create workspaces and apps.
The course will take around 24 hours to complete,but completing this will enable you to create vizzes, dashboards and storiesof your own, and know how to overcome common problems.
The course increases in difficulty slowly, so you'll create for instance a table or basic bar chart, then turn it into a stacked bar chart, and investigate more of their properties, step by step.
The course is fairly relaxed - there will be a few "wrong turns", so you can see what problems might arise, but every lesson works towards an end goal at a relatively slow pace, so you can follow on your own computer easily. I assume that you know how to use a computer, including installing programs, but the actual analysis will be at a basic level, and I'll introduce every component as we go on.
At the end of the course, you can download a certificate of completion, so you can show everyone your new-found skills, and be able to start creating analyses for yourselves.
Please note: Microsoft will retire the 70-778 exam on 31 January 2021, and the DA-100 certification will be available from 2 April 2021. This course will be kept up to date with the latest requirements.
Who this course is for:
This reporting course is meant for anyone who has no prior experience of Power BI. It's also for you if you have used it, but never designed a report.
It's great if you have created analyses in other reporting tools, such as Microsoft Access, WebI, SSRS, Tableau or Yellowfin, but it not essential. If you have, then it will be another string to your bow.
It would also be good if you had prior experience in using Excel formulas, but again, that is not essential.
No prior experience in reporting tools or creating formulas is required.
This course is probably not for you if you always know how to use Power BI and know how to create reports, although we will be looking at some more advanced topics, including the M and DAX languages.
Instructor Details
- 4.5 Rating
224 Reviews
Phillip Burton
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.
More courses by Phillip Burton
70-461, 761: Querying Microsoft SQL Server with Transact-SQL (2021)
4.6 (360 Reviews)
Provider: Udemy
Time: 29.5h
$11.99
SQL Server Integration Services (SSIS) - An Introduction (2021)
4.6 (355 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
70-462: SQL Server Database Administration (DBA) (2021)
4.5 (350 Reviews)
- Provider: Udemy
- Time: 9.5h
$11.99
Microsoft SQL Server Reporting Services (SSRS) (2021)
4.2 (338 Reviews)
- Provider: Udemy
- Time: 6h
$11.99
SQL Server SSAS (Multidimensional MDX) - an Introduction (2021)
4.5 (207 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
SQL Server Essentials in an hour: The SELECT statement (2021)
4.5 (183 Reviews)
- Provider: Udemy
- Time: 1h
$11.99
More data analysis courses
Microsoft Power BI - Up & Running With Power BI Desktop (2021)
4.8 (312 Reviews)
- Provider: Udemy
- Time: 10.5h
$11.99
Python Data Analysis & Visualization Bootcamp (2021)
4.8 (309 Reviews)
- Provider: Udemy
- Time: 8h
$11.99
![Complete Introduction to Microsoft Power BI [2021 Edition]](/programming/data-analysis/images/468172_d1c0_11.jpg?v=1789153474)
Complete Introduction to Microsoft Power BI [2021 Edition] (2021)
4.7 (312 Reviews)
- Provider: Udemy
- Time: 6.5h
$11.99
![[Intermediate] Spatial Data Analysis with R, QGIS & More](/programming/data-analysis/images/1030486_58a1_2.jpg?v=1789153427)
[Intermediate] Spatial Data Analysis with R, QGIS & More (2021)
4.7 (170 Reviews)
- Provider: Udemy
- Time: 5h
$11.99
Reviews
- Video Duration:
24h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
