Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA CompTIA Security+ Amazon AWS Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Mindfulness Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Freelancing Online Business Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-03-09 20:14:03
30-Day Money-Back Guarantee
IT & Software IT Certification Microsoft Certification

DA-100 certification: Analyzing Data with Microsoft Power BI

Learn skills for Microsoft DA-100 certification using the free Power BI Desktop. Learn Power Query, DAX, M and more.
Bestseller
Rating: 4.6 out of 54.6 (2,987 ratings)
14,513 students
Created by Phillip Burton
Last updated 3/2021
English
English, Spanish
30-Day Money-Back Guarantee

What you'll 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.
Curated for the Udemy for Business collection

Requirements

  • Before you begin this course, you should have a computer with access to the internet, and be able to install programs.
  • That's it! The more experience in reporting using other packages including Excel, the better, but it is not essential.

Description

This course covers the content required for the DA-100 certification exam, current as per the DA-100 exam update of 23 March 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."

Andrew says: "I took a similar Power BI course through my work and I think this one is better. Highly recommend this training. I am a Lead ERP Financial Systems Analyst who worked mostly with Oracle BI tools. Company wants to go in a different direction so I am learning Power BI."

----------------

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 BI Desktop. We'll start by creating our first visualizations (vizzes) and investigate the Power BI interface.

We'll look at the various visualisations available, and go through their common properties. We'll create maps, 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 M language.

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 BI Service

We'll then publish our visualisations onto the Power BI Service (which you can sign up for free), and then from your reports create dashboards. With the Power BI Pro (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 stories of 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 2020. 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.

Featured review

Saksit Srikosol
Saksit Srikosol
4 courses
3 reviews
Rating: 5.0 out of 54 months ago
I Passed the DA-100 with 100% in the Visualization part! This course is well defined. I started with 0 knowledge of Power BI after finish this course I only take 2 days of preparation for the exam. I think If this course has talked more about Azure and SSAS it would be great.

Course content

35 sections • 259 lectures • 25h 5m total length

  • Preview01:37
  • Welcome to Udemy
    01:08
  • The Udemy Interface
    02:00
  • Preview06:37
  • Preview05:21
  • Resources
    00:37

  • Welcome to Part 1: Visualizations
    02:48
  • 1b. Importing from Excel, and Creating our first visualization
    05:10
  • Viewing data
    05:37
  • Focus mode and Different visualizations
    03:06
  • Why do I need a Work email address? And how can I get one, if I don't have it?
    06:35
  • 10b. Saving visualization to the Desktop and to the Power BI service
    05:10
  • Practice Activity Number 1
    00:26
  • Practice Activity Number 1 - The Solution
    07:24

  • Formatting font and font size
    04:52
  • Formatting colors
    05:24
  • Stylistic options
    06:49
  • 8g. Position visuals
    05:45
  • 8g. Align visuals
    04:34
  • Format Painter
    02:45
  • 8f. Configuring summarization, both default and in a specific visualization
    10:01
  • 8i. Changing number and date formatting
    07:07
  • Practice Activity Number 2
    00:59
  • Practice Activity Number 2 - The Solution
    07:58

  • Matrix
    07:01
  • Drill down data, see data and records, and export data
    08:25
  • Stacked bar charts and 8j. switch theme for reports
    06:51
  • Bar Chart formatting
    04:51
  • 8c. Configure interactions between visual (Edit interactions)
    08:32
  • Clustered and 100% Stacked bar charts
    05:47
  • Line and area charts, including 8b. Configure duplicate pages
    05:16
  • Preview06:04
  • Practice Activity Number 3
    00:49
  • Practice Activity Number 3 - The Solution
    07:43

  • 11a. Adding Text boxes, Images and Shapes
    07:25
  • 11b. Visual level, page level and report level filters - basic filters
    06:58
  • Advanced Filtering
    10:40
  • Filter Top N Items
    05:29
  • Slicer
    10:34
  • Slicer Warning
    03:16
  • 8g. Sort visuals
    07:24
  • 8j. Use Bookmarks for reports
    06:12
  • Drillthrough
    10:59
  • Buttons and Actions
    14:00
  • 11e. Enable Natural Language Queries (Ask A Question)
    08:13
  • Tooltip Pages
    09:01
  • Practice Activity Number 4
    01:41
  • Practice Activity Number 4 - The Solution
    10:44

  • Ribbon charts
    06:22
  • Waterfall charts
    08:04
  • Scatter, bubble and dot charts
    09:39
  • Pie charts and donut charts
    03:33
  • Treemaps
    02:25
  • Funnel charts
    02:37
  • Adding Marketplace visualizations (Import a Custom Visual)
    03:05
  • Practice Activity Number 5
    00:50
  • Practice Activity Number 5 - The Solution
    07:27

  • Maps
    07:30
  • Formatting maps
    04:46
  • 8g. Adding Data Categories
    07:22
  • Preview10:10
  • Creating hierarchies
    07:24
  • ArcGIS Maps for Power BI
    10:44
  • Practice Activity Number 6
    01:26
  • Practice Activity Number 6 - The Solution
    12:28

  • Gauges
    06:02
  • Cards and Multi-row cards
    04:45
  • More conditional formatting
    07:56
  • KPIs
    04:14
  • Practice Activity Number 7
    01:30
  • Practice Activity Number 7 - The Solution
    16:02

  • Define quick measures
    07:16
  • Export report data
    03:56
  • Create reference lines by using Analytics pane
    09:37
  • Design and configure for accessibility
    05:45
  • Identify outliers
    03:23
  • Use groupings and binnings
    06:47
  • Use the Key Influencers to explore dimensional variances
    08:44
  • Use the decomposition tree visual to break down a measure
    06:04
  • R and Python Visualizations
    04:17
  • Use or create a PBIDS file
    03:03
  • Creating a paginated report
    06:00
  • Exploring Power BI Report Builder
    06:53
  • End of Part 1
    01:28

  • Welcome to Part 2: Get and Transform Data
    01:48
  • Introduction - let's Get some more Data
    04:51
  • Exploring the Power Query Editor interface
    09:06
  • Introducing the M language
    09:16
  • Let's start look at the Home tab
    04:19
  • Home menu - Manage Columns
    06:05
  • Home menu - Reduce Rows and Use First Row as Headers
    07:27
  • Practice Activity Number 8
    00:33
  • Practice Activity Number 8 - The Solution
    07:16

Instructor

Phillip Burton
Best Selling Instructor - over 300,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 45,035 Reviews
  • 309,044 Students
  • 47 Courses

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.

  • Udemy for 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
  • Featured courses
Udemy
© 2021 Udemy, Inc.