Become A Microsoft Power BI Data Analyst
Become A Microsoft Power BI Data Analyst, available at $54.99, has an average rating of 4.3, with 108 lectures, based on 5 reviews, and has 20 subscribers.
You will learn about Connect to various data sources Ingest, clean, transform and model data Design and create reports for data analysis Model data for performance and scalability Manage and share report assets Create paginated reports in Power BI Report Builder Connect, Transform, Visualize and Publish Web Data Create measures using DAX formulas Work with time intelligence Transforming data in Power BI Desktop using Power Query Editor Model Data and create relationships This course is ideal for individuals who are Data professionals or Business intelligence professionals or Beginner Data Analyst or Beginner Power BI Data Analyst It is particularly useful for Data professionals or Business intelligence professionals or Beginner Data Analyst or Beginner Power BI Data Analyst.
Enroll now: Become A Microsoft Power BI Data Analyst
Summary
Title: Become A Microsoft Power BI Data Analyst
Price: $54.99
Average Rating: 4.3
Number of Lectures: 108
Number of Published Lectures: 108
Number of Curriculum Items: 108
Number of Published Curriculum Objects: 108
Original Price: $129.99
Quality Status: approved
Status: Live
What You Will Learn
- Connect to various data sources
- Ingest, clean, transform and model data
- Design and create reports for data analysis
- Model data for performance and scalability
- Manage and share report assets
- Create paginated reports in Power BI Report Builder
- Connect, Transform, Visualize and Publish Web Data
- Create measures using DAX formulas
- Work with time intelligence
- Transforming data in Power BI Desktop using Power Query Editor
- Model Data and create relationships
Who Should Attend
- Data professionals
- Business intelligence professionals
- Beginner Data Analyst
- Beginner Power BI Data Analyst
Target Audiences
- Data professionals
- Business intelligence professionals
- Beginner Data Analyst
- Beginner Power BI Data Analyst
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will also show how to build paginated reports .
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Prerequisites
-
Understanding core data concepts.
-
Knowledge of working with relational data.
-
Knowledge of working with non-relational data
-
Knowledge of data analysis and visualization concepts.
-
Understanding of Power BI is recommended
What You Will Learn
-
How to Ingest, clean, and transform data
-
How to Model data for performance and scalability
-
How to Design and create reports for data analysis
-
How to Apply and perform advanced report analytics
-
How to use DAX to create measures
-
How to Manage and share report assets
-
How to Create paginated reports in Power BI Report Builder
Course Curriculum
Chapter 1: Get Started with Microsoft Data Analytics
Lecture 1: Introduction
Lecture 2: What is Microsoft Data Analytics
Lecture 3: Overview of Data Analysis
Lecture 4: Roles in Data Analysis
Lecture 5: Tasks of a Data Analyst
Chapter 2: Power BI Setup
Lecture 1: What is Power BI
Lecture 2: What is Power BI Desktop
Lecture 3: Install Power BI Desktop
Lecture 4: Exploring Power BI Desktop Interface
Chapter 3: Microsoft 365 Setup
Lecture 1: Microsoft 365 Setup
Lecture 2: Getting started with Microsoft 365
Lecture 3: Creating a new user account in Microsoft 365
Chapter 4: Overview of Power BI
Lecture 1: Power BI Overview: Part 1
Lecture 2: Power BI Overview: Part 2
Lecture 3: Power BI Overview: Part 3
Lecture 4: Changing regional settings
Lecture 5: Parts of Power BI
Lecture 6: Power BI Building blocks
Lecture 7: Exploring Power BI Service
Chapter 5: Connect, Transform, Visualize and Publish Web Data
Lecture 1: Connect to Web Data
Lecture 2: Clean & transform data: Part 1
Lecture 3: Clean & transform data: Part 2
Lecture 4: Combine data sources
Lecture 5: Creating Data Visuals: Part 1
Lecture 6: Creating Data Visuals: Part 2
Lecture 7: Publish report to Power BI Service
Chapter 6: Microsoft SQL Server Setup
Lecture 1: What is SQL Server
Lecture 2: SQL Server Editions
Lecture 3: SQL Server Installation Requirements
Lecture 4: Download SQL Server
Lecture 5: SQL Server Installation
Lecture 6: SQL Server Configuration Manager
Lecture 7: Installing SQL Server Management Studio
Lecture 8: Connect to SQL Server with SSMS
Lecture 9: Restore AdventureWorksDW2020 Database
Chapter 7: Connect to data sources from Power BI
Lecture 1: Create a new Power BI Desktop file
Lecture 2: Set Power BI Desktop Options
Lecture 3: Get data from a relational database (SQL Server)
Lecture 4: Preview SQL Server queries
Lecture 5: Get data from a CSV file
Lecture 6: Get additional data from a CSV file
Chapter 8: Clean, transform and load data into Power BI
Lecture 1: Configure the Salesperson Region query
Lecture 2: Configure the SalespersonRegion query
Lecture 3: Configure the Product query
Lecture 4: Configure the Reseller query
Lecture 5: Configure the Region query
Lecture 6: Configure the Sales query
Lecture 7: Configure the Targets query
Lecture 8: Configure the ColorFormats query
Lecture 9: Update the Product query
Lecture 10: Update the ColorFormats query
Chapter 9: Model Data in Power BI Desktop
Lecture 1: Create Model Relationships
Lecture 2: Configure the Product table
Lecture 3: Configure the Region table
Lecture 4: Configure the Reseller table
Lecture 5: Configure the Sales table
Lecture 6: Bulk update properties
Lecture 7: Review the model interface
Lecture 8: Create quick measures
Lecture 9: Create a many-to-many relationship
Lecture 10: Relate the Targets Table
Lecture 11: Enforce row-level security
Chapter 10: Working with DAX in Power BI Desktop
Lecture 1: What is DAX
Lecture 2: Create the Salesperson Calculated table
Lecture 3: Create the Date calculated table
Lecture 4: Create calculated columns
Lecture 5: Complete the Date table
Lecture 6: Mark the Date table
Chapter 11: Time Intelligence and Measures
Lecture 1: Create simple Measures
Lecture 2: Create additional measures
Lecture 3: Create a matrix visual
Lecture 4: Manipulate filter context
Lecture 5: Create a YTD measure
Lecture 6: Create a YoY growth measure
Lecture 7: Publish Power BI Desktop File
Chapter 12: Design and Publish Reports in Power BI
Lecture 1: Create a new file
Lecture 2: Create a live connection
Lecture 3: Design page 1
Lecture 4: Design page 2
Lecture 5: Design page 3
Lecture 6: Publish report
Lecture 7: Explore the report
Lecture 8: Configure Sync Slicers
Lecture 9: Configure drill through page
Lecture 10: Add Conditional Formatting
Lecture 11: Add Bookmarks to Report
Lecture 12: Add Buttons to Report
Lecture 13: Publish Updated Report
Instructors
-
Tech Academy
Real Skills For The Real World
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 0 votes
- 4 stars: 4 votes
- 5 stars: 1 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024