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 Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native 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
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-01-12 03:29:56
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft Power BI

Microsoft Certified: Data Analyst Associate with Power BI

Analyzing and Visualizing Data with Microsoft Power BI - Exam Guide. Get Microsoft Certified in 30 days.
Rating: 4.3 out of 54.3 (2,493 ratings)
35,987 students
Created by John David Ariansen, Ligency Team
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • How to connect to data
  • How to transform data sources
  • How to create a data model
  • How to build visualizations
  • How to share your insights with others in your organization
  • Learn all the topics covered in the Microsoft DA-100 PowerBI Exam
Curated for the Udemy for Business collection

Requirements

  • Have a computer with an internet connection

Description

In this course, the students will learn the entire Power BI interface. From connecting to a data source all the way through sharing insights with their organization. The main sections break down into connecting to data, building a data model, building visualizations, uncovering insights, and sharing insights.

These lectures will break down all the concepts covered in the Exam DA-100 in simple, easy to follow lectures. These concepts will then be applied to a case study where the students will get to reinforce their learning.

So why take this course?

Trust. Once you finish this course you will have all the knowledge necessary to clear the Power BI DA-100 exam. Not only will you have intermediate knowledge of Power BI but you will also have proof. This proof can help you land your next analytics job. Whether you're starting out or looking for a promotion, a certification in BI will go a long way. Hiring managers need to know that you can actually analyze data effectively and this new Certification will help calm this concern.

Easy to Follow. Power BI is a complex tool but this course breaks down all the components of Power BI into their base elements. Once you have a solid understanding of a component of Power BI, this course will then apply what you've learned to a real-world case study. Then finally, after you've learned about skill then successfully applied it, this course will test your level of understanding through Q&A. This course is laid out in a very logical way so that each lecture builds off the previous lecture. By the time you finish this course, you will have all the tools necessary to conduct effective analysis that will have a huge impact on your organization.

Applicable. This course is taught by a practicing professional. This means the case studies will be based on cutting-edge use cases that provide real-world value in the business world. No more learning basic, out of touch case studies from a book. This course will teach you all the fundamentals of Power BI plus give you some dashboard templates to help you tackle problems out in the business world.

Who this course is for:

  • Anyone interested in taking the Exam DA-100
  • Those Looking to Build Their Power BI Knowledge
  • Data Analysts
  • Business Analysts
  • Students Looking to Break into the Analytics Industry

Featured review

Ida Russell
Ida Russell
45 courses
3 reviews
Rating: 5.0 out of 56 months ago
I loved this course. It was fast and straight to the point. There is not a lot of "fluff" or over exaggerated explanations. The modules are short, and you can easily go back to a section to walk through a process without having to look at an entire presentation to find the one thing you were looking for.

Course content

8 sections • 142 lectures • 7h 25m total length

  • Preview02:10
  • A Note About the Course Structure
    01:43
  • Preview01:37
  • Preview02:27
  • Signing Up for Microsoft Trial Account
    00:06
  • Get the Materials
    00:05
  • Preview02:22
  • Setting Expectations
    03:47
  • Preview04:27
  • How to Get an Analytics Job Podcast
    00:05
  • BONUS: Learning Path
    00:33

  • Section Introduction
    01:21
  • Business Challenge Blueprint
    02:02
  • Prepare the Data
    02:33
  • Model the Data
    02:46
  • Visualize the Data
    02:31
  • Analyze the Data
    02:23
  • Deploy and Maintain Deliverables
    01:54

  • Section Introduction
    00:25
  • Get Data from Different Sources
    00:48
  • Choosing the Correct Type of Query
    02:02
  • Data Source Settings
    01:22
  • Select a Shared Dataset or Create a Local Data Set
    01:11
  • Select a Storage Mode
    02:17
  • Identify Query Perfomance Issues
    03:46
  • Use Parameters
    04:49
  • Profile The Data
    00:34
  • Identify Data Anomalies
    03:38
  • Examine Data Structures
    01:49
  • Interrogate Column Properties and Statistics
    02:41
  • Clean, Transform and Load the Data
    00:53
  • Resolve Inconsistencies, Unexpected or Null Values, and Data Quality Issues
    05:21
  • Apply User Friendly Value Replacements
    02:01
  • Identify and Create Appropriate Keys for Joins
    03:23
  • Evaluate and Transform Column Data Types
    03:12
  • Apply Data Shape Transformations to Table Structures
    04:48
  • Combine Queries Through Merge
    03:23
  • Combine Queries Through Append
    02:22
  • Apply User-Friendly Naming Conventions to Columns and Queries
    04:24
  • Leverage Advanced Editor to Modify Power Query M Code
    03:13
  • Configure Data Loading
    01:42
  • Resolve Data Import Errors
    02:59
  • Additional Prepare the Data Lectures
    00:52
  • Query Editor
    03:45
  • Changing Locale
    01:36
  • Basic Transformations
    03:08
  • Text Transformations
    04:55
  • Date Transformations
    04:37
  • Creating a Calculated Column
    02:26
  • Creating Conditional Columns
    04:15
  • Understanding Pivoting and Unpivoting
    04:30
  • Connecting to a Folder
    03:06
  • Query Dependency View
    01:59
  • Case Study Introduction
    00:55
  • Case Study Part 1.1
    06:53
  • Case Study Part 1.2
    10:22

  • Section Introduction
    00:37
  • What is a data model?
    03:41
  • Design a Data Model
    00:46
  • Define the Tables
    02:03
  • Configure Table and Column Properties
    05:00
  • Define Quick Measures
    04:05
  • Flatten Out a Parent Child Hierarchy
    04:12
  • Design the Data Model to Meet Performance Requirements
    02:16
  • Resolve Many to Many Relationships
    02:22
  • Create a Common Date Table
    03:42
  • Define the Appropriate Level of Data Granularity
    03:05
  • Create Calculated Tables
    02:24
  • Create Hierarchies
    04:29
  • Implement Row-Level Security Roles
    04:16
  • Set Up the Q&A Feature
    03:45
  • Create Measures by Using DAX
    02:57
  • Use DAX to Build Complex Measures
    02:58
  • Use CALCULATE to Manipulate Filters
    03:09
  • Implement Time Intelligence Using DAX
    03:48
  • Replace Numeric Columns with Measures
    03:36
  • Remove Unnecessary Rows and Columns
    02:43
  • Additional Model the Data Lectures
    00:51
  • Understanding Cardinality
    03:35
  • Types of Tables
    02:15
  • Filter Direction
    03:14
  • Two Way Filtering Direction
    02:00
  • Manage Query Group
    02:08
  • Case Study Part 2
    09:27

  • Section Introduction
    00:31
  • Create Reports
    00:59
  • Add Visualization Items to Reports
    02:41
  • Choose an Appropriate Visualization Type
    05:08
  • Format and Configure Visualizations
    03:11
  • Import a Custom Visual
    01:23
  • Apply Filtering
    05:41
  • Configure the Report Page
    03:35
  • Set Mobile View
    02:33
  • Use the Q&A Feature
    03:01
  • Create Custom Tooltips
    03:55
  • Edit and Configure Interactions Between Visuals
    01:54
  • Configure Sync Slicers
    01:47
  • Use the Selection Pane
    02:16
  • Drilldown into Data Using Interactive Visuals
    03:05
  • Export Report Data
    02:32
  • Additional Visualize the Data Lectures
    01:08
  • Use Drilldown Functionality within a Hierarchy
    03:06
  • Include and Exclude Data
    01:42
  • Creating Bar Charts
    07:25
  • Creating Line and Area Graphs
    03:57
  • Pie Charts, Donut Charts and Treemaps
    02:56
  • Focus Mode, See Data and Exporting Data
    02:02
  • Adding Shapes, Images and Textboxes
    02:16
  • Creating Maps
    03:22
  • Creating a Table and Matrix
    05:34
  • Case Study 3.1
    07:27
  • Case Study 3.2
    03:53
  • Case Study 3.3
    05:42

  • Section Introduction
    00:31
  • Enhance Reports to Expose Insights
    00:42
  • Color and Conditional Formatting
    03:36
  • Apply Slicers
    02:29
  • Perform Top N Analysis
    03:16
  • Create Reference Lines by Using Analytics Pane
    07:09
  • Use the Play Axis Feature of a Visualization
    01:59
  • Perform Advanced Analysis
    00:36
  • Conduct Time Series Analysis
    04:50
  • Grouping and Binning
    03:28
  • Use the Key Influencers to Explore Dimensional Variances and Outliers
    06:52
  • Use the Decomposition Tree Visual to Break Down Measure
    03:06
  • Apply AI Insights
    02:10
  • Case Study 4.1
    07:46
  • Case Study 4.2
    06:41
  • Case Study 4.3
    05:36

  • Section Introduction
    00:42
  • Manage Datasets
    00:48
  • Install a Gateway
    00:04
  • Configure a Dataset Scheduled Refresh
    02:49
  • Configure Row Level Security Membership
    01:13
  • Providing Access to a Dataset
    02:11
  • Endorse a Dataset
    02:25
  • Create and Manage Workspaces
    00:31
  • Create and Configure a Workspace
    01:52
  • Assign Workspace Roles
    01:30

  • Section Introduction
    00:52
  • Hiring Manager Interview: Emerging Trends in the Analytics Space
    28:21
  • Analytics Industry Veteran: Power BI vs. Tableau
    06:12

Instructors

John David Ariansen
Experienced Tableau Consultant and Analytics Educator
John David Ariansen
  • 4.3 Instructor Rating
  • 3,512 Reviews
  • 40,040 Students
  • 5 Courses

I tell stories through data. Currently I am the Director of Analytics and Co-founder of Silvertone Analytics. We focus on three main verticals - Manufacturing, Marketing and Nonprofit Impact Analysis.

Outside of my consultancy, I work with students helping them break into the analytics field and I am also on the Board of Directors for Triad Local First, a nonprofit that promotes localism here in the Greensboro, NC. On the board I advise on how to leverage data to drive strategy but I also teach classes available to the 360 local member businesses on how they can use their data to drive their decision making process. I love getting to work with these small businesses!

I post weekly content to my Youtube channel focused on Tableau and how you can grow your Analytics Career.


Ligency Team
Helping Data Scientists Succeed
Ligency Team
  • 4.5 Instructor Rating
  • 467,811 Reviews
  • 1,676,910 Students
  • 109 Courses

Hi there,

We are the Ligency PR and Marketing team. You will be hearing from us when new courses are released, when we publish new podcasts, blogs, share cheatsheets and more!

We are here to help you stay on the cutting edge of Data Science and Technology.

See you in class,

Sincerely,

The Real People at Ligency

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.