Best Microsoft Power Bi Courses

Find the best online Microsoft Power Bi Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Microsoft Power Bi Courses.

Microsoft Power BI – A Complete Introduction [2021 EDITION]

Learn how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Pro (Service) and PowerBI Developer

Created by Manuel Lorenz - Professional Business Analyst and Instructor

"]

Students: 170963, Price: $124.99

Students: 170963, Price:  Paid

[This course was completely updated (= re-recorded) to reflect all the latest Power BI Desktop, Power BI Pro (Service) and Power BI Mobile updates that took place recently. Enjoy this 100% up-to-date course]

---

You want to analyze data from single or multiple sources? You want to create your individual datasets based on these sources and transform your results into beautiful and easy-to-make visualizations? You also want to share your results with colleagues or collaborate on your projects? Finally, you want to be able to access your data from multiple devices?

Then the Power BI tools are the tools to choose for you!

In this course you will learn why Power BI offers you a comprehensive set of Business Intelligence tools for your data analysis goals and how to use these tools to fulfill all of the above tasks - and more. Imagine to quickly structure your data, to easily add calculations to it and to create and publish nice-looking charts in just a few minutes. 

This is what you will learn:

  • Get to know the different tools of the Power BI universe and learn how to use them

  • Understand Power BI Desktop and its components

  • Learn how to use the Query Editor to connect Power BI to various source types, how to work on the Data Model and understand the difference between those two steps

  • How to work in the different views of the Data Model

  • How to create calculated columns and measures

  • How to build relationships between different tables

  • How to create a report with different interactive visualization types

  • Learn how to use Power BI Service (= Power BI Pro) to create dashboards and to share and publish your results

  • How to access your results from multiple devices using Power BI Mobile

  • How to create custom visuals using typescript and the Power BI Developer Tools

  • And more!


This is what this course offers, but is this the right course for you?

If you...

  • ...never worked with the Power BI tools before

  • ...have a basic understanding of selected tools of the Power BI universe and want to learn how these tools work together

  • ...want to understand the latest updated version of Power BI Service, including the newly introduced App Workspaces and the creation and publishing of Apps including your dashboards, reports and datasets

  • ..want to understand the basic concepts regarding the creation of customized visuals using the Power BI Developer Tools

...then this is the right course for you.

I would be really happy to welcome you in this course!

Manuel

Microsoft Power BI Desktop for Business Intelligence

Master Power BI Desktop & learn advanced Power BI analysis & data visualization w/ a top Microsoft Power BI instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 141549, Price: $129.99

Students: 141549, Price:  Paid

Hear why this is one of the TOP-RATED Power BI courses on Udemy:

"Instructor is top notch - moves at the right pace and keeps it interesting. Best Power BI course on Udemy!"

-Adam Edwards

"Resources are awesome. Presenter is brilliant. I found this course more useful than the offical Power BI course from Microsoft. Things are easy to follow, and presentations are of high quality."

-Jacobus M.

"Chris is a skilled communicator and does a great job of explaining a complex tool like Microsoft Power BI. His 'pro-tips' are great for new user productivity and gaining a sense of the big picture, and I value his best practices on building and managing Power BI queries and reports. I'm feeling much more confident to dig in and use Power BI on my own projects!"

-Bill Jerrow

__________

COURSE DESCRIPTION:

If you're looking for a comprehensive, hands-on guide to learning Microsoft Power BI Desktop, you've come to the right place.

Power BI is quickly becoming the world's most powerful self-service business intelligence platform, and an absolutely essential tool for data professionals and beginners alike. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch -- all for free.

__________

THE COURSE PROJECT:

In this course, you'll be playing the role of Lead Business Intelligence Analyst for Adventure Works Cycles, a global manufacturing company. Your mission? To design and deliver a professional-quality, end-to-end business intelligence solution, armed only with Power BI and a handful of raw csv files.

But don't worry, I'll be guiding you through the ins-and-outs of Power BI Desktop, sharing crystal clear explanations and helpful pro tips each step of the way. We'll follow a steady, systematic progression through the Power BI workflow, and break down our project into FOUR KEY OBJECTIVES:

__________

POWER BI OBJECTIVE #1Connect & Transform the Raw Data

  • Intro to the Power BI Query Editor

  • Types of Power BI Data Connectors

  • Basic Table Transformations

  • Text, Number & Date Tools

  • Index & Conditional Columns

  • Grouping & Aggregating Data

  • Pivoting & Unpivoting

  • Modifying, Merging & Appending Queries

  • Connecting to Folders

  • Defining Hierarchies & Categories

  • Query Editing & Power BI Best Practices

__________

POWER BI OBJECTIVE #2: Build a Relational Data Model

  • Intro to Database Normalization

  • Data ("Fact") Tables vs. Lookup ("Dimension") Tables

  • Creating Power BI Table Relationships

  • "Star" vs. "Snowflake" Schemas

  • Active vs. Inactive Relationships

  • Relationship Cardinality

  • Connecting Multiple Data Tables

  • Filtering & Cross-Filtering

  • Hiding Fields from the Power BI Report View

  • Data Modeling & Power BI best Practices

__________

POWER BI OBJECTIVE #3: Add Calculated Fields with DAX

  • Intro to Data Analysis Expressions (DAX)

  • Calculated Columns vs. Measures

  • Row Context vs. Filter Context in Power BI

  • DAX Syntax & Operators

  • Common Power BI Functions

  • Basic Date & Time Formulas

  • Logical & Conditional Statements

  • Text, Math & Stats Functions

  • Joining Data with RELATED

  • CALCULATE, ALL & FILTER Functions

  • DAX Iterators (SUMX, AVERAGEX)

  • Time Intelligence Formulas

  • DAX & Power BI Best Practices

__________

POWER BI OBJECTIVE #4: Design Interactive Power BI Reports

  • Intro to the Power BI Report View

  • Adding Basic Charts to Power BI Reports

  • Formatting & Filtering Options

  • Matrix Visuals

  • Slicers & Timelines

  • Cards & KPIs

  • Power BI Map Visuals (Basic, Fill, ArcGIS)

  • Treemaps, Lines, Areas & Gauges

  • Editing Report interactions

  • Adding Drillthrough Filters

  • Linking to Report Bookmarks

  • Using "What-If" Parameters

  • Managing & Viewing Roles

  • PREVIEW: Publishing to Power BI Service

  • Power BI Data Viz Best Practices

__________

By the end of the Adventure Works project, not only will you have developed an entire business intelligence tool from the ground up using Power BI, but you will have gained the knowledge and confidence to apply these same concepts to your own Power BI projects.

For those looking for more opportunities to test their Power BI skills, I've also included an additional set of project files for a bonus Final Project. This is your chance to showcase all of the skills you've developed throughout the course, and apply them to a brand new data set from Maven Market, a global supermarket chain.

Whether you're a casual Power BI user, aspiring analyst, or data science professional, this course will give you the tools you need to become an absolute Power BI ROCK STAR -- guaranteed.

__________

Join today and get immediate, lifetime access to the following:

  • 100+ page Power BI ebook

  • Downloadable Power BI project files

  • Homework exercises & quizzes

  • 1-on-1 expert support

  • Course Q&A forum

  • 30-day money-back guarantee

See you in there!

-Chris (Founder, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Master in Microsoft Power BI Desktop and Service

Hands-on Guide to Mastering Power BI Desktop and Power BI Service

Created by Learnsector LLP - Learn to Win

"]

Students: 108257, Price: $19.99

Students: 108257, Price:  Paid

More than +70,000 satisfied students worldwide have enrolled in this course, writing thousands of 5-star reviews.

"I recommend this course for anybody starting with Power BI. It touches all aspects of the desktop and online tool for visual development. If multiple data source examples are included then it would be very complete (like data gateway, data flow, etc.). Given the scope of the course, I still considered this one of the best available. I am able to follow at 2x speed and complete the course."

Vidya L

"If you want to know all about PowerBi, then this course for you. Concepts are explained in detail & simple as well, which makes us understand the concepts clearly. I strongly recommend this course for beginners, go for it !!!. Happy learning !!! Special Thanks to Navya Mam, for making this course and boosting my career skills."

Sundaram Subramanian

"The instructor has done a very good job by explaining all the features of Power BI in a much simpler way which anyone with any experience can understand easily. I am really happy and have all the required knowledge to implement for the real-time project."

Shani Jaiswal

"I think covering the entire (in true sense end to end) tool with an example makes a first-time viewer like me a good hold and develops an encouragement for its use. Nicely covered and an informative tutorial!"

Shreyas Shringi

"This is an excellent course to learn Power BI, its components, and various functionalities. All the modules are very clearly explained with examples."

Chiranjeevi Rao Boddu

"What a great course! The instructor was so detailed, showing us how to perform various functions from manual to automated. The case studies were very real and I can vouch for that as a data scientist with a business background. It is obvious that the lesson planning was done meticulously and if I could rate this 6 stars, I would."

Len Kwok

"One of the BEST resources to learn power Bi that I found in Udemy. thanks a lot and keep it up..."
Naag Sadineni

"Goes in-depth for even a person who just starts with PowerBI can follow. There are some issues with date formatting in few data sets (different sheets had different date formats), which I solved using the tips provided on date formatting in the 14 and 15 points. All in all very helpful for a person who is starting with PowerBI."

Yasintha Jayaratne

"Excellent course, excellent teacher. I appreciate following this course because the teacher knows and explains well the concepts."

Abdoul Traoré

And many thousands more...

Course Description

This Microsoft Power BI course will help you to become a Power BI expert. It will enhance your skills by offering you comprehensive knowledge on Power BI Desktop, Power BI Online, and the required hands-on experience for solving real-time industry-based Power BI projects.

As we progress through this course, you’ll learn to unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

In this course, you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services.

  • You will learn how to connect Power BI to different data sources.

  • You will be able to transform your data using Power Query and create data models.

  • You will also level-up your data analysis skills using DAX and create calculated columns and measures.

  • With the help of Reports and Visualization in Power BI, you will be able to present your data in an efficient and interactive way.

  • And lastly, you will learn how to publish your reports and dashboards to the Power BI online service.

Why Learn Power BI?

Power BI is a business intelligence tool by Microsoft that provides analytics services. It provides interactive dashboards and visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on anyone else as Power BI's artificial intelligence is there to help you out. Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modeling capabilities along with data preparation, data discovery, and interactive dashboards.

Why should you take up this Power BI course?

  • Worldwide Business Intelligence and Analytics Market to grow to $22.8 billion in the next 2 years – Gartner.

  • 70% of leading companies say that analytics is integral to how they make decisions – IBM Survey

  • A Senior Business Intelligence Analyst can earn $89,000 in the United States – Payscale

You get lifetime access and a 30 day, 100% money-back guarantee!

Power BI A-Z: Hands-On Power BI Training For Data Science!

Learn Microsoft Power BI for Data Science and Data Analytics. Build visualizations and BI reports with Power BI Desktop

Created by Kirill Eremenko - Data Scientist

"]

Students: 86535, Price: $109.99

Students: 86535, Price:  Paid

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.

You'll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.

Use Power BI to Analyze and Visualize Data So You Can Respond Accordingly

  • Connect Power BI to a Variety of Datasets
  • Drill Down and Up in Your Visualization and Calculate Data
  • Visualize Data in the Form of Various Charts, Plots, and Maps

Convert Raw Data Into Compelling Data Visualizations Using Power BI

Because every module of this course is independent, you can start in whatever section you wish, and you can do as much or as little as you like.

Each section provides a new data set and exercises that will challenge you so you can learn by immediately applying what you're learning.

Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.

Contents and Overview

This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.

To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and timeseries.

Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.

In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.

You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.

Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brickcharts and more.

By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.

You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.

Power BI – The Ultimate Orientation

Business Intelligence and data is here to stay. Get your Orientation to Self Service BI with Power BI

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 66892, Price: Free

Students: 66892, Price:  Free

Business Intelligence and data are here to stay.  Now with Power BI by Microsoft, costs and skills are no longer a barrier to entry.

Power BI is a self service business intelligence system, and best of all, it is free for all to use. 

COURSE OVERVIEW

The aim of this course Power BI - The Ultimate Orientation is to give you a solid orientation of Power BI. First you will learn how to download and install power bi desktop.  We will have a look around the user interface and then we will start to work with some data.

Using an example data set, we will connect to both excel and cvs files and you will get an introduction of the Query editor as we do some transformation on the data.  Then we will move on to a few calculations and you will be introduced to the concept of relationships and dax. Finally in powerbi desktop we will look at the visualisations side.

After we look at visualisations in Power Bi Desktop we will move on to power Bi services.  Its in services that you will get insights, have the ability to share reports, build dashboards and connect to data packs that contains prebuilt dashboards and reports.

 We will not be looking at any of this in detail as, this course is an orientation course, designed to get you familiar and comfortable with the Power BI user interface.  The aim of the course is to get you up and running.  To show you that Power BI offers a real solution, and give you ideas of how it can be used.

Complete Introduction to Microsoft Power BI [2021 Edition]

A comprehensive guide on how to import, transform & visualise data with Power BI, with practical exercises & case study.

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 40249, Price: $99.99

Students: 40249, Price:  Paid

If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you.  We've focused on providing you with the fundamentals you need to work with Power BI effectively!

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

  • "Amazing and captivating course! I have started it with a zero knowledge about Power BI. Now I feel very comfortable and knowledgeable to use it. Thank you for the great course. Highly recommended!"

  • "Best course content and trainer I have had. Can translate the new skills learnt directly into my role and elevate our business. Thank you"

  • "This was a very informative course even though I was already a user of Power BI and had followed another course previously. Enjoyed it and learnt a lot which will be useful in my day to day work! Thank you Ian :)"

WHAT YOU CAN EXPECT:

  • Understand the flow of using Power BI, from connecting to various data sources, importing these into Power BI, transforming the data and then presenting it effectively

  • Learn how to use Power BI Desktop, Power BI Query Editor & the Power BI Service

  • Learn how to create relationships between related data sources

  • Learn how to build reports with various types of aggregations and filters

  • Learn about the various types of visualizations possible in Power BI and how to use them

  • Learn how to create interactive dashboards with drill throughs and relative date filters

  • Learn how to publish dashboards to the web and mobile app

  • Learn how to use themes and custom visualizations

  • Learn about DAX and how to use it to build measures

  • Learn how to work with Excel & Power BI to create a dynamic and effective business solution

  • Learn how to put this all into practice with a case study about the Corona Virus. 

REQUIREMENTS:

  • You will need to have a PC/Windows laptop loaded with the latest version of Microsoft Power BI (available as a free download).  Note that Power BI does not currently run natively on a Mac.

  • Whilst this course is designed to cover Power BI from the ground up, some experience of working with data in Excel would be beneficial.

ABOUT THE TRAINER:

Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting.  He specialises in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight. 

Ian has over 100,000 students and 50,000 reviews and an average course rating of over 4.5 out of 5.  He has a reputation for delivering excellent, logically structured courses which are easy to follow and get the point across without wasting learners' time. 

You can see all of Ian's other Data Analysis courses by searching for his name on Udemy. 

WHY YOU SHOULD SIGN UP:

Learners buying this course get:

  • Full access to almost 7 hours of Full HD quality video

  • 5 downloadable resources and 13 articles

  • Lifetime access

  • Money-back guarantee (see Udemy terms and Conditions)

  • Certificate of completion upon course conclusion

COURSE ROADMAP:

This course will take you from beginner to intermediate level.  Look out for Ian's follow on courses to take your skills onto the next level!

  • Power BI Master Class - Query Editor [2020 Edition]

  • Power BI Master Class-Data Models and DAX Formulas 2020

  • Power BI Master Class - Dashboards and Power BI Service 2020

  • Introduction to Data Analysis with Microsoft Power BI

We look forward to having you on the course!

Microsoft Power BI DAX from Scratch

Hands-on guide to Microsoft Power BI DAX

Created by Learnsector LLP - Learn to Win

"]

Students: 39246, Price: $99.99

Students: 39246, Price:  Paid

If you are someone dealing with reporting, with the help of DAX functions you can unlock the advanced power of reporting in Power BI. These functions will help you get better data insights.

DAX or Data Analysis Expression is a library of functions and operators, using which you can create formulas and expressions. This will help you with creating powerful formulas to ease your data analysis and reporting process.

This course is designed in a Problem Statement - Solution format where we start with the problem to which a solution is sought with the help of DAX functions where each component of the expression is clearly explained in easy-to-understand terms,

What is in store for you?

In this course, you will

1. Understand the concept of DAX and how to create calculate column, measure, tables, and quick measures

2. From the exhaustive list of DAX functions, we will be looking into the most frequently used functions from the family of

  • Date and Time function - WEEKDAY,  EDATE, EOMONTH,  DATEDIFF, TODAY, NOW

  • Text function - FORMAT, COMBINEVALUES, LEFT, RIGHT, FIND, UPPER, LOWER, UNICHAR, REPT

  • Logical function - IF, Nested IF, AND, OR, SWITCH

  • Relationship function - RELATED, CROSSFILTER, RELATEDTABLE

  • X-function - SUMX, RANKX

  • Filter function - CALCULATE, ALL, EARLIER, FILTER, LOOKUPVALUE

  • Statistical function - DISTINCTCOUNT

  • Time intelligence function- DATESYTD, DATEADD, SAMEPERIODLASTYEAR

  • Information function- CONTAINS

  • Table manipulation function- SUMMARIZECOLUMNS

Microsoft Certified: Data Analyst Associate with Power BI

Analyzing and Visualizing Data with Microsoft Power BI - Exam Guide. Get Microsoft Certified in 30 days.

Created by John David Ariansen - Experienced Tableau Consultant and Analytics Educator

"]

Students: 39052, Price: $94.99

Students: 39052, Price:  Paid

The BI industry is booming, and every day, more hiring managers and recruiters are looking for professionals who not only know their way around BI tools, but have certifications to back their claims.

Knowing this, what are you doing to let everyone know you mean business?

Becoming Power BI certified is a must if you want to remain competitive in the analytics job market. Employers need to know that you can use their BI stack without training, and certifications do just that—they endorse the skills that can’t be measured on a resume, portfolio, or in an interview.

By mastering Power BI, you become more efficient at work and are able to communicate and uncover deeper insights than before. You also gain the confidence to lead more projects and solve complex business challenges.

And that's where this course comes into play.

The Microsoft Certified: Data Analyst Associate with Power BI course is modeled directly from the DA-100 exam structure, so you can rest assured that everything that you'll see in the Microsoft PowerBI exam, you'll also see it in the course, and in the same order!

So, get ready for your Power BI certification and master everything you need to know to pass the DA-100 exam. Learn to prepare, model, visualize, and analyze data; deploy and maintain deliverables in Power BI. Plus, DAX, advanced data visualization techniques, and more.

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.

Created by Phillip Burton - Best Selling Instructor - over 350,000 students so far

"]

Students: 25532, Price: $89.99

Students: 25532, Price:  Paid

This course covers the content required for the DA-100 certification exam, 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."

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. And if you are an American college student, you might even get college credit for passing that exam.

Microsoft Power BI – Up & Running With Power BI Service 2021

Master Power BI Service & learn advanced data analysis & data visualization w/ a top business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 24969, Price: $129.99

Students: 24969, Price:  Paid

IMPORTANT NOTE: 

In order to cover the latest features and provide the best learning experience for our students, this course was completely rebuilt in 2021, with all-new topics, resources, datasets and hands-on projects.

As a reminder, this is PART 2 of our Microsoft Power BI series, which covers Power BI Desktop (Part 1) and Power BI Service (Part 2). We strongly recommend completing our Power BI Desktop course before taking this one!

__________

This top-rated course offers a practical and project-based guide to mastering Power BI in the cloud, including powerful tools like gateways, dataflows, row-level security, data-driven alerts, and much more.

You’ll be playing the role of a data analyst for Maven Inspectional Services, a restaurant health inspection agency based in Los Angeles. Your objective? Use Power BI Service -- and the skills you develop throughout the course -- to build scalable reports & dashboards to deliver insights across the entire organization.

Here are just a few of the topics we’ll cover:

  • Administration Tools

    • Admin roles, tenant settings, custom branding, etc.

  • Connecting to Data

    • Connection types, gateways, dataflows, scheduled refresh, etc.

  • Reports & Dashboards

    • Data lineage, bookmarks, data-driven alerts, Q&A, mobile, etc.

  • Sharing & Collaboration

    • User roles, apps, publish to web, usage reports, etc.

  • Row-Level Security

    • Static vs. dynamic RLS, testing roles, etc.

  • PREVIEW: Premium Per User

    • Key features, incremental refresh, UX, etc.

By the end of the course, you’ll have a deep, practical understanding of Power BI Service, along with the skills and confidence you need to apply these tools to your own real-world projects and analyses.

Whether you're a casual Power BI user, aspiring analyst, or business intelligence professional, this course will give you the tools you need to become an absolute Power BI ROCKSTAR -- guaranteed.

__________

Join today and get immediate, lifetime access to the following:

  • 8+ hours of high quality videos

  • 100+ page Power BI Service ebook (PDF)

  • Power BI project files & sample data

  • Course quizzeshomework (with solutions)

  • Expert support & Q&A forum

  • 30-day money-back guarantee

We can't wait to see you in the course!

-Aaron (Lead Power BI Instructor, Maven Analytics)

__________

Hear why our Power BI Desktop and Power BI Service courses are the TOP-RATED on Udemy:

"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

-Ann S.

"Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI Service and in addition I have learned how to create a great course as well. Enjoyed the course from start to finish."

-Nikola H.

"Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"

-Jorge M.

"Where can I leave a 6 star rating?"

-Carlos B.

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Microsoft Power BI – Business Intelligence for Beginners

Beginner Course on Power BI : Business Intelligence & Data/Business Analysis with Microsoft Power BI

Created by BizticsCom King - Passionate data expert in Business Intelligence field.

"]

Students: 23267, Price: $109.99

Students: 23267, Price:  Paid

Learn to create stunning Dashboards and Reports using Microsoft's free Business Intelligence / Analytics tool, Power BI.

Do you want to build professional-quality Business Intelligence Reports from the ground up ? Do you want to blend and transform raw data into beautiful Interactive Dashboards ? Do you want to learn design and implement the same B.I. tools used by professional analysts and data scientists ? Do you want to understand the Business Intelligence workflow from end-to-end.

 Then Microsoft Power BI is the right tool for you and this comprehensive course will teach you everything you need to know to use Power BI. 

 This hands on (Beginner to Intermediate) course will prepare you to start your data analytics career and also will prepare you to Successfully  implement Power BI in your organization. Absolutely no experience is required. 25+ hours of HD videos of building 18  interactive Business Intelligence Reports and Dashboards (real-world examples) from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning .  You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements. 

By the time you complete this course, You'll be a highly proficient Power BI user. You'll be fully prepared to collect, clean, model and present data for any purpose.  You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease.

 Why should you consider a career as a Business Data Analyst? 

  • Salary. A Business Data Analyst is a well-paid career 

  • Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst. 

  • Advancement in Career : Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career.  Business Data Analyst get very visibility in corporations. Whole management depends on them.  

#microsoft #powerbi #data #business #intelligence #analysis

Course Curriculum:

Section 1: Business intelligence -

  • Introduction to Power BI

  • Business Analysis - Course Introduction

  • Thank you for enrolling - Must watch

  • Dashboard-in-a-day & Power BI Best Practices Introduction

  • Power Bi Introduction - 0

  • Power Bi Introduction - 1

  • Power Bi Introduction - 2

  • Why Microsoft Power BI

  • Power BI Family

  • Power BI Desktop

  • Power BI Service 1

  • Power BI Service 2

  • Descriptive-Predictive-Prescriptive Analytics

  • IT Challenges 0

  • IT Challenges 1

  • How to take the quizzes

Section 2: Data Analysis and Business Intelligence - Collect , Injest and  Import Data

  • Download Data files first

  • Import data from CSV files

  • Import data from Excel files

  • Import data from Web 1

  • Import data from Web 2

  • Import Real-time Streaming Data

  • Download and Install SQL Server Express

  • Download and Install Sample Databases

  • Import data from SQL Server

  • Import data from OData feed REST-API

  • Import Data from Folder

  • Dataflows - Introduction

  • Dataflows - Create Gateway from Scratch

  • Dataflows - Create Entities from CSV file

  • Dataflows - Create Entities Using SQL Server

Section 3: Prep, Clean and Shape Data

  • Download resources for this section.

  • Remove Rows

  • Remove Columns

  • Make first row as headers

  • How to create calculate columns

  • How to remove duplicates,  Unpivot columns and split columns

  • Change Data type, Replace Values and Rearrange the columns

  • Append Queries

  • Merge Queries

Section 4: Power BI Visuals

  • Download resources for this section.

  • Visuals Intro

  • Visuals-Bar Charts

  • Visuals-Line Charts

  • Visuals-Pie Chart

  • Stacked bar Chart

  • Clustered Column Chart

  • Visuals-Area Chart and Analytics Tab Explained-0

  • Visuals-Area Chart and Analytics Tab Explained-1

  • Visuals-Combo Chart

  • Visuals-Scatter Chart

  • Visuals-Treemap Chart

  • Visuals-funnel Chart

  • Visuals-Card and Multi-Row Card

  • Visuals-Gauge Card

  • Visuals-KPIs

  • Visuals-Matrix

  • Visuals-Table

  • Visuals-Text boxes - Shapes - Images

  • Visuals-Slicers

  • Visuals-Maps

  • Custom Visuals - Word Cloud

  • Visualization interactions

Section 5: Data Modeling

  • Our First Report-0

  • Our First Report-1

  • Our First Report-2

  • Our First Report-3

  • Publishing and Sharing your first report

  • Theme Download file

  • Modeling Basics-0

  • Modeling Basics-1

  • Modeling Basics-2

  • Modeling and Relationships-0

  • Modeling and Relationships-1

  • Other ways to create Relationship

  • Normalization - Denormalization-0

  • Normalization - Denormalization-1

  • OLTP vs OLAP

  • Star Schema vs Snowflake Schema-0

  • Star Schema vs Snowflake Schema-1

Section 6: Introduction to DAX

  • DAX101 - Importing Data for Dax Learning

  • DAX101 - Resources for Dax Learning

  • DAX101 - What is Dax

  • DAX101 - Dax Data Types

  • DAX101 - Dax Operators and Syntax

  • DAX101 - M vs Dax

  • DAX101 - Create a Column

  • DAX101 - Rules to Create Measures

  • DAX101 - Calculated Columns vs Calculated Measures-0

  • DAX101 - Calculated Columns vs Calculated Measures-1

  • DAX101 - Sum()

  • DAX101 - AVERAGE()-MIN()-MAX()

  • DAX101 - SUMX()

  • DAX101 - DIVIDE()

  • DAX101 - COUNT()-COUNTROWS()

  • DAX101 - CALCULATE()-0

  • DAX101 - CALCULATE()-1

  • DAX101 - FILTER()

  • DAX101 - ALL()

  • DAX101 - Time Intelligence - Create Date Table in M (important)

  • DAX101 - Time Intelligence - Create Date Table in DAX-0

  • DAX101 - Time Intelligence - Create Date Table in DAX-1

  • DAX101 - Time Intelligence - PREVIOUSMONTH()

  • DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()

  • DAX101 - Time Intelligence - TOTALYTD()

  • DAX101 - Display Last Refresh Date

  • DAX101 - Time Intelligence - DATEADD()

  • DAX101 - Quick Measures

Section 7: Hands-on Real-world Projects

  1. Delicious Pizza

  2. American Bank

  3. Financial Report

  4. Productivity in 2017

  5. Personality

  6. Tough Sport by Skill

  7. Natural Disasters

  8. Terrorism in World

  9. Procurement-spend Analysis

  10. Products Analysis

  11. Regional Analysis

  12. IT Tickets Analysis

  13. Human Resources 1

  14. Human Resources 2

  15. Human Resources 3

  16. Financial Data Report

  17. Sales Analysis

  18. Bank Report

Section 8: Personal - Enterprise Gateway

  • On-Premises Gateway

  • Personal vs Enterprise Gateway

  • Install and Configure Personal Gateway

  • Install and Configure Enterprise Gateway

  • Manage SQL Server Data Source thru Enterprise Gateway

Section 9: Power BI Service and Dashboards

  • PowerBI Reports

  • PowerBI Workspaces

  • PowerBI Datasets

  • What are Dashboards

  • How to create Workspace and Publish Report

  • Create dashboards 6 different ways-0

  • Create dashboards 6 different ways-1

  • Favorite dashboards, reports, and apps in Power BI

  • Subscribe to a Report or Dashboard

  • Rename Workspace or Report or Dashboard

  • Display Reports or Dashboards in Full screen mode

  • Delete Reports or Dashboards

  • Dashboard Menus

  • Quick Insights

  • Setting up Alerts on Cards

  • Q-A in Power BI

  • Analyze in Excel

  • File and View Options

  • Printing Dashboard and Reports

  • Row level security

  • Access Reports Dashboards using Mobile Devices

  • Report page tooltip-0

  • Report page tooltip-1

  • Filter- Page-Report-Visualization level-0

  • Filter- Page-Report-Visualization level-1

Section 10: Sharing and Collaboration

  • Sharing and Collaboration

  • Sharing Dashboard

  • Sharing Workspaces

  • Sharing App

  • Publish To Web

Section 11: Bonus Lectures

  • Download Materials

  • Power BI : Best Practices, Tips and Tricks 0

  • Power BI : Best Practices, Tips and Tricks 1

  • Power BI : Best Practices, Tips and Tricks 2

  • Power BI : Best Practices, Tips and Tricks 3

  • Power BI : Best Practices, Tips and Tricks 4

  • Power BI : Best Practices, Tips and Tricks 5

  • Dashboard-in-a-day : Download Material link

  • Dashboard-in-a-day : Introduction

  • Dashboard-in-a-day : Accessing Data

  • Dashboard-in-a-day : Data Preparation 0

  • Dashboard-in-a-day : Data Preparation 1

  • Dashboard-in-a-day : Data modeling and Exploration 0

  • Dashboard-in-a-day : Data modeling and Exploration 1

  • Dashboard-in-a-day : Data modeling and Exploration 2

  • Dashboard-in-a-day : Data modeling and Exploration 3

  • Dashboard-in-a-day : Data modeling and Exploration 4

  • Dashboard-in-a-day : Data Visualizations 0

  • Dashboard-in-a-day : Data Visualizations 1

  • Dashboard-in-a-day : Publishing Report

  • Dashboard-in-a-day : Creating Dashboards 0

  • Dashboard-in-a-day : Creating Dashboards 1

  • Dashboard-in-a-day : 6 ways to create Dashboards 0

  • Dashboard-in-a-day : 6 ways to create Dashboards 1

Advanced DAX for Microsoft Power BI Desktop

Master the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructor

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 17173, Price: $109.99

Students: 17173, Price:  Paid

Hear why our Power BI courses are the TOP-RATED on Udemy:

"I totally loved this Power BI course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much and had fun doing it. In fact, at the end of the day, I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

-Ann S.

"Amazing! 5+ stars if you ask me! Concise, superbly organized and prepared. I have learned a ton about Power BI and DAX and enjoyed the course from start to finish."

-Nikola H.

"Hands-down the best Power BI courses on Udemy. Courses are well prepared and very hands-on, and the instructor makes the whole experience easy and fun. I recommend it 100%!"

-Jorge M.

"Where can I leave a 6 star rating?"

-Carlos B.

__________

COURSE DESCRIPTION:

For users looking to take their Power BI skills to the next level, mastering Data Analysis Expressions (DAX) is a MUST. In this hands-on, project-based course, you'll put your DAX skills to the test and apply what you learn to some of the toughest real-world business intelligence use cases.

You'll be playing the role of Business Intelligence Analyst for Maven Roasters, a small-batch coffee chain based in New York City. Your goal? Use Power BI and DAX to answer key questions and deliver data-driven insights for the business, by analyzing product inventory, repeat customers, store-level performance, and everything in between.

We'll start by quickly reviewing prerequisite topics (evaluation context, filter flow, basic measures, etc.), then dive behind the scenes to explore how the DAX formula and storage engines actually work, including query evaluation, columnar structures, and VertiPaq compression and encoding.

From there we'll cover helpful tips and best practices for DAX power users, including variables, comments, query formatting and error handling, then dive deep into scalar functions, iterators, advanced time intelligence, calculated table joins, relationship functions, and much, much more. Last but not least, we'll share a sneak peek into performance tuning and DAX query optimization using DAX Studio and Power BI's Performance Analyzer tool.

If you're looking to build expert-level data analysis skills using DAX and Power BI, this is the course for you!

__________

FULL COURSE OUTLINE:

  • Prerequisite Skills Review

    • Review the core DAX concepts you should already know, including evaluation context, filter flow, measures, etc.

  • Course Project Intro

    • Introduce the Maven Roasters course project, and build the data model that we’ll analyze in Power BI Desktop

  • The DAX Engines

    • Understand the DAX formula and storage engines, data types, VertiPaq encoding & compression methods, etc.

  • DAX Tips & Best Practices

    • Review helpful tips for formatting DAX queries, adding comments, handling errors, and using DAX variables

  • Scalar Functions

    • Explore common DAX scalar functions, including rounding, information, conversion, and logical functions

  • Advanced CALCULATE

    • Review CALCULATE modifiers, context transition, interactions with tables, etc.

  • Table & Filter Functions

    • Create calculated tables, review common DAX filter functions, generate new data, etc.

  • Calculated Table Joins

    • Create calculated joins between physical and virtual tables in Power BI (UNION, EXCEPT, INTERSECT, etc.)

  • Relationship Functions

    • Explore expanded tables, physical & virtual relationships, common relationship functions, etc.

  • Iterator ("X") Functions

    • Explore iterator cardinality, nested iterators, context transition, RANKX, DAX calculation granularity, etc.

  • Advanced Time Intelligence

    • Build date tables with DAX, compare custom time periods, manage fiscal calendars, etc.

  • SNEAK PEEK: Performance Tuning

    • Introduce DAX Studio, the Power BI performance analyzer, and common DAX optimization techniques

__________

Join today and get immediate, lifetime access to the following:

  • 150+ page Power BI & DAX ebook

  • Downloadable datasets and Power BI project files

  • Homework assignments & quizzes

  • 1-on-1 expert support

  • Course Q&A forum

  • 30-day money-back guarantee

See you in there!

-Aaron (Power BI & DAX Instructor, Maven Analytics)

__________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Power BI Masterclass – beginners to advanced

Microsoft Power BI How to learn Power BI fast. The best Power BI Training online for beginners. Best Master Class

Created by Dan We - BI Expert, Trainer, Datalover

"]

Students: 15953, Price: $109.99

Students: 15953, Price:  Paid

Microsoft Power BI in 6 hours beginners to advanced

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. This will be the key advantage to succeed in business.

MS Power BI is an andvanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for datascience jobs.

That is why I created this course to help you get started to dive into on of the hottest and best business analytics / business intelligence software currently out there. Starting from scratch we will learn all the relevant PBI basics and also master more advanced concepts step by step. Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

There is no coding required! Power BI allows you to do that but it's not necessary.

In this guided learning course you will start form zero to hero in 6 hours and you will learn:

  • the ETL capabilities of Microsoft Power BI ("get messy data easily into the right format")

  • Master simple and very advanced DAX (Power BI language, similar to like excel formulas) calculations

  • Create outstanding visualisations and reports

  • Derive valuable highly profitalbe insights

What we learn in this course might also help you later with your Power BI certification exam.

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Much better then only reading a book right? Exited? You should be. So how to learn Microsoft Power BI Desktop? Buckle up and meet me in the first lecture starting today!

Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!

1.Power BI Masterclass - beginners to advanced

2.Microsoft Power BI Masterclass - Expand Excellence

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

 The complete Masterclass Series which covers all relevant features in Power BI consists of 13 courses now. This one is the first.The other  consecutive classes are available here on udemy.  Each course covers additional DAX insights, Power BI features, tips and tricks and best practices in report creation. If you find this course helpful then feel free to check them out as well. You can easily find them by checking out my Instructor profile.

best regards and happy learning.

Power BI Master Class-Data Models and DAX Formulas 2021

Learn how to create data models, relationships and use DAX formulas in Microsoft Power BI

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 15670, Price: $99.99

Students: 15670, Price:  Paid

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert

Great reports are built on great data models.  In this course, learn how to create relationships, create measures, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch!  This course has been updated (JUNE 2020) to the latest Power BI interface so you will be using the latest version available. 

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

WHAT STUDENTS ARE SAYING:

"Thanks..this is exactly what I was looking for.  So many questions are clarified now. This is really helpful for my day to day work!!"

"Very well organized. I like that it is "master" class, but you provide the instruction in such a way that it does not overwhelm you with new or complex information, BUT at the same time does not bore you with basic information that a somewhat experienced user should already know. A nice balance."

"Ian is a good instructor. I have completed 2 modules (Query Editor and DAX). Looking forward to completing the 3rd (Dashboards and Power BI Service)."

"Great course, great professor, I'm a beginner user and the course is really great as a first approach, it teaches you about the most important general aspects and functions, it is the perfect first step you should take if you want to dominate powerbi."

WHAT YOU CAN EXPECT:

  1. Introduction and Course Content

  2. Creating Calculated Columns - Basic calculations, using date fields and date tables

  3. Creating Measures - Aggregation measures, the =Calculate formula, the All and AllExcept formula, Time Intelligence, Customer Segmentation and many more

  4. Creating Relationships between tables and using relationship calculations

  5. Creating Virtual Tables and Calculations between Tables

  6. Creating and using hierarchies and data groups

  7. Case Studies on DirectQuery, Star Schemas and Quick Measures

ABOUT THE TRAINER

Ian Littlejohn has been a top-rated trainer on the Udemy platform for over 5 years and has more than 10 years' experience in training & management consulting. He specializes in Data Analysis, covering Excel, Power BI, Google Data Studio and Amazon Quicksight.

Ian has over 100,000 students and 50,000 reviews and an average course rating of over 4.5 out of 5. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners' time.

WHY YOU SHOULD SIGN UP:

Learners buying this course get:

  • Full access to almost 5 hours of HD quality video

  • 4 downloadable resources and 11 articles

  • Lifetime access

  • Money-back guarantee (see Udemy terms and Conditions)

  • Certificate of completion upon course conclusion

We look forward to having you on the course!

***************************************************************************************************************************************

DATA ANALYSIS COURSES ROADMAP:

This course is part of our Power BI Master Class series.  This series goes into a bit more depth about Power BI.    My other courses on Udemy are:

  • Power BI

    • Complete Introduction to Microsoft Power BI [2020 Edition]

    • Power BI Master Class - Query Editor [2020 Edition]

    • Power BI Master Class-Data Models and DAX Formulas 2020

    • Power BI Master Class - Dashboards and Power BI Service 2020

    • Introduction to Data Analysis with Microsoft Power BI

  • Excel

    • Complete Introduction to Excel Pivot Tables and Pivot Charts

    • Complete Introduction to Excel Power Pivot

    • Complete Introduction to Excel Power Query

    • Excel Interactive Dashboards and Data Analysis

    • Complete Introduction to Business Data Analysis

    • Tables and Formulas with Excel [2020 Edition]

  • Google Data Studio

    • Complete Introduction to Google Sheets Pivot Tables

    • Complete Introduction to Google Data Studio 2020 Edition

    • Google Analytics Reports and Dashboards with Data Studio

PL-900: Microsoft Power Platform Fundamentals

Learn about Power Apps, Power Automate, Power BI, the AI Builder and the Dataverse (CDS) - for Microsoft's PL-900 exam.

Created by Phillip Burton - Best Selling Instructor - over 300,000 students so far

"]

Students: 11629, Price: $99.99

Students: 11629, Price:  Paid

This course covers the content required for the PL-900 certification exam, current as per the PL-900 exam update of 10 March 2021.

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

What do people like you say about this course?

Halima says: "Excellent delivery! This course is quite up-to-date with all the new terminologies included. It was just what I needed to pass the PL-900 exam on first attempt. Thank you : )"

Vibhaw says: "Pin point course to crack Pl-900 exam.Today i write the exam and got 807 marks .Thanks for your teaching."

Madeline says: "Scored a 740 out of 700 with this course and a few weeks of hands on power BI. It was my very first MS test. Thanks for the course!"

-----

This course is the foundation for the Microsoft Certificate PL-900 "Microsoft Power Platform Fundamentals", and focuses on the various apps which make up the Power Platform, together with how they can be used by other programs, apps and services.

We'll start off with looking at Power BI. If you have a PC, we'll download for free Power BI Desktop, and look at the various processes which you can use on the Power BI Desktop. Then, we'll look at the Power BI Service (available through any modern web browser), see what you can do with this, and how they compare.

We'll then look at Power Apps. We'll get a free Developer edition and/or free trial of Power Apps, and get some sample data using the Dataverse (previously known as the Common Data Service). We'll then create each of the three different types of Power Apps: Canvas, model-driven, and portals, while looking at the various types of connectors you can use to connect to different data sources.

Next up is Power Automate. Using our free Developer edition, we'll create several automated flows, and the different triggers and actions you can use.

The next app is Power Virtual Agents. We'll create a basic chatbot which can ask and answer a few questions. We'll then see how you can find out how well it is performing.

We will have a brief look at the AI Builder, and how models such as the business card reader, object detection model, form processing model and prediction model can be integrated into Power Apps and Power Automate.

We'll finish off by looking at how Power Platform can extend other business solutions, and some Power Platform administration and security.

No prior knowledge is required - we'll even see how to get a free Power Platform trial!

There are regular quizzes to help you remember the information, so you can be sure that you are learning.

Once you have completed this course, you will have a good introductory knowledge of Power Platform and what the capacities of these different apps are. And with some practice, you could even go for the official Microsoft certification PL-900 - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.

So, without any further ado, let's have a look at how you can use Udemy interface, and then we'll have a look at the objectives for the exam and therefore the syllabus for this course.

Power BI Essentials 2020: Introduction to Microsoft Power BI

Microsoft Power BI Online Training: Comprehensive introduction to Power BI Desktop, Power BI service & Power BI mobile

Created by Grant Gamble - Developer, trainer and author

"]

Students: 10423, Price: $109.99

Students: 10423, Price:  Paid

The comprehensive introduction to Microsoft Power BI, fully updated for 2020 and covering many of the topics required for the exam DA-100.

Master  Power BI Desktop, the Power BI service & Power BI mobile. This user-friendly course is designed to familiarize you with Microsoft Power BI’s  business intelligence capabilities in the most logical order.

The course consists of 30 sections, arranged into seven groups that reflect the way in which Microsoft Power BI works and the order in which operations are carried out: Getting Started, Connecting to Data, Data Wrangling, Data Modelling, DAX formulas, Visualization, and Publishing & Sharing.

Each of the 30 sections in this course starts with an overview and ends with a section summary which recaps the key topics covered and reminds you where these techniques fit into the overall Microsoft Power BI cycle.

So, take your time and work your way slowly but surely through the course material; and when you’re done, you should find that you know Micrososft Power BI pretty well.

INTERACTIVE  PDF

The course also includes a fully interactive PDF file containing hundreds of backlinks to the exact point in the video where that topic was discussed.

EXAM DA-100 COVERAGE AND MAPPING

Although this course is aimed at beginners, it covers a lot of the topics required for the Microsoft DA-100 exam. At the end of each section, we'll highlight which topics have been covered, so you can start checking them off your list.

CUSTOMIZABLE COURSE DURATION

If you are too busy to complete the whole course straightaway, no problem. We have shortened versions of the course created for people just like you.

There are three of these shortened courses.

The Executive Overview course (6 hours) is designed for users who want to get up to speed on Power BI as quickly as possible, without going into too much detail.

The Report Developer course (6 hours) will suit anyone who will be focusing on creating Power BI reports based on datasets created by their IT department or by other colleagues.

And the Dataset Developer course (9 hours) is for people in the opposite camp, those who will be responsible for developing datasets from which their colleagues can build reports.

GETTING STARTED

The first group of sections is, naturally enough, Getting Started. This is where you’ll get up and running and download all of the resources you’ll need; and where you’ll get an overview of the Power BI product, Microsoft Power BI tenants and Power BI licenses.

CONNECTING TO DATA

Then we dive straight into using Power BI and the first business intelligence skill you need to master: connecting to data sources.

In these five sections, you’ll learn how to bring data into Power BI from Text Files, CSVs and Excel Files; as well as how to connect to a Folder of Data, either on your own file system or in a SharePoint library, and automatically combine all the files inside the folder into a single table.

You’ll also learn how to Connect to data on websites and how to scrape data from the web page itself.

And, naturally, you’ll get plenty of practice in connecting to Power BI’s most frequent data partner: SQL Server. You’ll learn how to work in import, DirectQuery and composite modes and how to retrieve data from both views and database tables, as well as by executing SQL statements.

DATA WRANGLING

Once you’re comfortable with getting data into Power BI, we’ll move on to the next stage in the Power BI cycle: Data Wrangling.

It’s very rare that the data you connect to is already optimized for reporting; so our four sections on data cleansing and transformation will fully familiarize you with using Power Query, the utility built into Power BI whose user-friendly interface allows you to carry out powerful and sophisticated transformation with just a few mouse clicks, as well as how to edit the underlying M language code generated by the interface.

DATA MODELLING

After mastering the first two steps in your Power BI journey, connecting to data and data cleansing, you’ll be ready to move on to the next stage: data modelling.

In this group of sections, you’ll learn how to combine the various tables that you need into a single entity called a data model.

DAX FORMULAS

Having created a data model, our next group of sections focuses on using the DAX language to add insights and enhancements.

We’ll look at the three types of calculation which you can create using the DAX language:

Calculated columns

Calculated tables

And measures

And we’ll get to grips with the most important function in the DAX language: the CALCULATE function.

And we’ll end the section by looking at DAX time intelligence functions which enable you to compare calculations based on different time periods, to provide such insights as year-on-year growth and year to date sales.

VISUALIZATION

Once we have built our data model, we’ll move on to the next phase in the Power BI development cycle: visualization and report creation.

We’ll start with what I like to call the big-picture visuals, those which give your audience with key metrics at a glance. As you’ll see in this section Power BI has three big picture visuals: the card, the KPI visual and the gauge.

And, of course, we’ll talk about many other visuals and visualization techniques as we work through these sections.

We’ll even look at using DAX measures to enhance the user experience by making titles change dynamically as users interact with them.

PUBLISHING AND SHARING

OK, so now we have a report, in our last group of sections, we will look at how we can make our content available to our intended audience.

First, we’ll look at publishing from Power BI Desktop into the Power BI service.

Then, you’ll learn how to create dashboards in the Power BI service and the different ways of adding content to them.

You’ll learn how to create app workspaces and how to grant access to fellow report developers, so that your team can collaborate on the creation of content; and how the different strategies for sharing that content throughout the entire organisation.

And, in our section on Power BI mobile, you’ll learn how to create reports and dashboards which are optimised for mobile viewing.

Power BI Masterclass from Scratch in 90 minutes [2021]

Learn how to use Microsoft Power BI Desktop, Power BI Services, Power BI Mobile in 90 Minutes

Created by Learn Anywhere - Learning for Anyone, Anywhere

"]

Students: 10329, Price: $19.99

Students: 10329, Price:  Paid

*********************Use this code for extra discount : MILEOFF

Earlier called as Power BI Masterclass from Scratch in 60 minutes  , Update now.

[Update : Course has been update with all the new features in 2021]

"Thank you so much. This course was very easy to grasp and informative. " - Rhea

"Short and crisp video to have a great start to learn Power BI." - Srividya

"I really liked this course, every feature of the program is explained in practical and easy way. Thank you." - Maria

If you want to learn how to visualize data and find insights from it, in shortest possible time, this course is for you.

This course cuts the flab and stick to what is most important and help you learn that. Same course can be taught in 5-10 hours but we have reduced it to 60 minutes course with all the details intact, we have removed the unnecessary details and tech jargon.

This course will help you in starting with Power BI in no time from scratch, you will learn :

-Installing Power BI

-Getting Data in Power BI from various sources

-Modify and clean the data as per the need

-Merging/Joining various data streams

-Visualizing data using various methods

-Using various features of Power BI to enrich the data/visualization

-Doing What-If Analysis on the data

-Publishing them to web

-Using Power BI services to find insights from Data

-Creating Power BI Reports and Dashboards

-Consuming Power BI on Mobile

Do we have any prerequisite for this course? Answer is NO.

This course for you if :

-You have no prior experience with Power BI or any other data visualization tool

-You have worked on other visualization tool, this course will help you in learning similar skills for Power BI

-You worked on Power BI in the past then this can be a good refresher course.

-

*********************************IMPORTANT************************************

Please check resource TAB for all the resource to get started with Power BI visualization

Microsoft Power BI Certification: DA-100 Exam Prep

Complete, hands-on guide to passing the DA-100 Power BI Exam and becoming a Microsoft Certified Data Analyst Associate

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 8891, Price: $99.99

Students: 8891, Price:  Paid

See why Maven Analytics courses are among the TOP-RATED and BEST-SELLING courses on Udemy:

"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.

"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.

"Excellent from start to finish. I picked up a bunch of techniques that will be useful in the workplace, from new chart templates to some very cool advanced visualizations. I loved all of it!" Robert C.

"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.

__________

COURSE DESCRIPTION:

This course is designed to help you build the exact skills you need to ace the Microsoft DA-100 exam, guaranteed.

With hands-on projects, downloadable study guides, and a full-length practice exam, this is the ONLY course you'll need to prepare for your Power BI certification!

Throughout the course, you’ll play the role of Lead BI Analyst for Maven Cycles, a boutique cycling shop. You’ll use Power BI Desktop and Service, along with the skills you learn throughout the course, to design and build an end-to-end business intelligence solution from the ground up. We'll guide you each step of the way, with crystal clear explanations and pro tips to help you build expert-level Power BI and DAX skills.

Our project will incorporate all of the skills covered on the DA-100 Exam, including data prep, modeling, visualization, and analysis, along with deploying and maintaining reports and deliverables:

  • Data Prep: Getting Data From Different Sources

    • Connect to data sources, choose a storage mode & define data source parameters

  • Data Prep: Profiling

    • Explore the view menu & data profiling tools like column quality and distribution

  • Data Prep: Cleaning, Transforming & Loading

    • Clean data, apply table transformations, merge & append queries, and modify custom M code

  • Data Modeling 101

    • Design data models, identify keys, establish table relationships, and review model optimization tips

  • Data Modeling: DAX Calculations

    • Create calculated columns & measures with DAX, including aggregation, table, and time intelligence functions

  • Data Visualization: Creating Reports & Dashboards

    • Insert & format visuals, edit report interactions, add filters & tooltips, and create reports and dashboards

  • Data Analysis: Enhancing Reports

    • Review chart analytics options, natural language queries, filtering options, and AI visuals

  • Deploying & Maintaining Deliverables

    • Implement scheduled & incremental refresh, configure row level security, explore sharing options, and more

We’ll also walk through everything you need to know about the DA-100 certification process itself, including:

  • Exam structure & details

  • Question Types & examples

  • Measured skills

  • Exam rules & results

  • Tips for success

Finally, we'll wrap things up with a full-length practice exam, with knowledge-based and case study questions designed to mirror the actual exam experience and make sure you're ready for the real deal.

If you're ready to level-up your Power BI skills, increase your earning potential, and become a Microsoft Certified Analyst, this is the course for you!

__________

Join today and get immediate, lifetime access to the following:

  • 7.5 hours of high-quality video

  • DA-100 Certification Prep study guide

  • Downloadable Power BI project files & solutions

  • Quizzes + full-length Practice Exam

  • Course Q&A forum

  • 30-day money-back guarantee

See you in the course!

-Aaron (Lead Power BI Instructor, Maven Analytics)

MICROSOFT POWER BI DA-100 EXAM: Advanced 2021 Practice Test

150 updated businesslike questions divided into six modules by the most relevant knowledge areas of Microsoft Power BI.

Created by Mariangela Toscano - Architect

"]

Students: 8764, Price: $34.99

Students: 8764, Price:  Paid

Are you planning to become a Microsoft Certified Data Analyst Associate?

This practice test will break down all the concepts covered in the Exam DA-100, giving you real know-how about analyzing and visualizing data in the Power BI platform.

But mostly: this practice test will prepare you to deal with the design of the questions for the Exam DA-100.

This is a key point: no matter how hard you study Microsoft Power BI documentation. If you plan to get the Power BI Certification you need to work by advanced usage of Power BI platform on practical business cases. This will really measure your Data Analysis skills.

Thus, in this test, you will not find just theory questions. You will achieve a proven experience in facing businesslike issues, needed to pass the Exam DA-100, and become a Microsoft Certified Data Analyst Associate.

To take the exam DA-100 and, mostly, to use profitably Power BI features, you need to gain experience in six knowledge areas:

  • Microsoft DAX language;

  • Microsoft Power Query features;

  • Data Modeling in Power BI;

  • Data Visualization in Power BI;

  • Manage Publishing and Sharing Power BI contents;

  • Manage Power BI Administration settings.

Who this course is for?

Professional Data Analysts, Junior Data Analysts, and anyone who manages data. No matters what is your professional role, if you want to experience all the features provided by Microsoft Power BI: it is the current all-in-one market leader solution in Analyzing and Visualizing Data. Taking the DA-100 exam accredits you as a Microsoft Data Analyst Associate. This is an advanced career pass that certifies your skills in designing and building data models, cleaning and transforming data, and using advanced analytic capabilities to enhance data-driven strategy inside profit and no-profit organizations.

Take a look at the video introduction to get a full overview of the course.

Power BI Master Class – Query Editor [2021 Edition]

Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 6451, Price: $99.99

Students: 6451, Price:  Paid

If you are new to Power BI or want to fill in some gaps in your knowledge, THIS is the course for you.  We've focused on providing you with the fundamentals you need to work with Power BI data effectively!

Don't sit through days of boring training to understand how Power BI works! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming a Power BI expert

This course has been updated for 2021 in full HD video quality, so you will learn on the latest Power BI interface. Students who have taken this course have this to say:

Recent reviews:

"I absolutely endorse the content of this course. Very well explained and good examples as well. Thank you so much!"

"The instructor is well knowledgeable to what he is sharing. Thank you. Even though, I am an intermediate user and use Power BI for over two years, I found some that I haven't known."

"He explains the concepts very well. I like that the course has short practical activities to practice what I learned."

**** Lifetime access to course materials and practice activities.****

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon QuickSight & his courses average over 4.5 stars out of 5. 

Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for the development of reports, data analysis and dashboards.

In this course you will learn the to use the AMAZING Power BI tool to transform and prepare your data for analysis.  You will learn to use the Query Editor to connect to data, perform advanced transformation and also to clean data.

In this course - which is part of the Power BI Master Class Series), you will cover:

  1. Introduction and Course Content

  2. Basic Data Transformations - Learn about filtering data, changing data types, adding new columns and removing columns

  3. Advanced Data Transformations - Merging data into one table, Appending data, Unpivoting data, Grouping data, conditional rules and custom fields

  4. Data Cleansing - Techniques and skills to clean up your data

  5. Connecting to Data Sources - Learn how to connect and access data from a variety of different data sources including, files, databases, web URL, JSON and Google Analytics

We look forward to having you on our course as we learn and explore the incredible power of Microsoft Power BI.

Please note that this course is part of the Power BI Master Class series.  Search for my instructor profile to purchase these other courses.

  1. Power BI Master Class - Query Editor

  2. Power BI Master Class - Data Modeling and DAX Formulas

  3. Power BI Master Class - Dashboards and Power BI Service

Microsoft Power BI – The Complete Masterclass [2021 EDITION]

Master Power BI Desktop, Cloud & Mobile and advanced analytics with DAX (also Data Science)!

Created by Nikolai Schuler - Professional Data Scientist und BI Consultant

"]

Students: 5746, Price: $119.99

Students: 5746, Price:  Paid

Do you want to learn the skills to professionally analyze data?

Do you want to learn all the steps to create impressive reports?

Then Microsoft Power BI is the right tool for you!

In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.

That’s what you’ll learn:

Power BI Desktop, Power BI Cloud & Power BI Mobile!

✓ Understand everything from scratch – step by step, very structured and practice-oriented

Learn all the important tools – know when and how to use them properly

✓ Connect different data sources – from basics to advanced

Create your data model – and understand it

Master DAX – to do more advanced analysis on your data

Get to know all the different visualizations – and how to use them

Storytelling with data – learn how to visualize your data effectively

Create interactive visualizations – with drill throughs and drill downs

Advanced analysis – learn how to use R Script in Power BI (Data Science)

Forecasting – Advanced analytics which can be helpful in Data Science

Row-Level Security – Implement the security concept to control access to the data

This course is right for you if...

... you have never worked with Power BI and want to learn everything hands-on in one course.

... OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.

This is the course that covers everything in Power BI to become an advanced report devolopper! 

Enroll now to get life long access!

Getting to Know Power BI

Answer Critical Business Questions with Power BI

Created by Gaelim Holland - Data Analyst

"]

Students: 5298, Price: Free

Students: 5298, Price:  Free

If you are familiar with the field of data visualization, you would have heard of Power BI as a visualization tool. However, this is not an equal comparison since data visualization is a small part of this tool and a data analyst work. Among data professionals such as analyst, DBA, and data science. Power BI provides a more robust set of solutions around data preparation and data modeling.

This is an overview course is design to help analysts develop a working knowledge of Microsoft Power BI.  This course will cover the fundamentals of loading data, transforming data, building graphs and dashboards. The course will allow the user to create interactivity for the end-users to deliver excellent business insights through data visualizations.

Microsoft Power BI Masterclass – Expand Excellence

Microsoft Power BI How to learn Power BI fast. The best Power BI Training online for beginners. Best Master Class

Created by Dan We - BI Expert, Trainer, Datalover

"]

Students: 5178, Price: $109.99

Students: 5178, Price:  Paid

Microsoft Power BI in 4 hours - Expand Excellenc

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster and smarter decisions. Therefore they rely heavily on data. Small company or Multinational -  data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself

MS Power BI is an andvanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for datascience jobs.

That is why I created the 6h Power BI Masterclass - beginners to advanced (master self service business intelligence in no time) course which is my first course to help you get started to dive into on of the hottest and best business analytics / business intelligence software currently out there. Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

Because of the great feedback and the request from students to learn more and explore more DAX and best practices I decided to create this 4+h follow up course Microsoft Power BI Masterclass - Expand Excellence. 

Together we continue our journey and increase our knowlege in DAX Calculations further to derive deep insights from our data. A great example dataset is included but you can also use your own data for exploration

In this course you will learn:

  • How to gain deeper insights in your data from a time aspect

  • How to evaluate your sales people

  • Additional advanced DAX measures which have not been covered in the first course yet

  • How to apply best practices when creating dashboards

  • How to improve the look and feel of your report to create the WOW Effect in your audience

What we learn in this course might also help you later with your Power BI certification exam.

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Exited! You should be. So how to learn Microsoft Power BI Desktop? Buckle up and meet me in the first lecture starting today!

Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!

1.Power BI Masterclass - beginners to advanced

2.Microsoft Power BI Masterclass - Expand Excellence

4.Power BI Masterclass - DAX, Excel And More

5. The Power BI Masterclass - Additional Tips and Tricks

6. Power BI Desktop - Data Prep Challenges

7. Power BI Masterclass - DAX, R and Gateways

8. Power BI Masterclass - Python Finance and Advanced DAX

9. Power BI Masterclass - the next level

 The complete Masterclass Series which covers all relevant features in Power BI consists these courses now. This one is the second class.The other consecutive classes are available here on udemy.  Each course covers additional DAX insights, Power BI features, tips and tricks and best practices in report creation and design. If you find this course helpful then feel free to check them out as well. You can easily find them by checking out my Instructor profile.

best regards and happy learning.

Business Intelligence with Microsoft Power BI -With Material

Don't wait for another day to comeback . Start NOW

Created by Pavan Lalwani - Freelancer Instructor

"]

Students: 5132, Price: $19.99

Students: 5132, Price:  Paid

If you torture data long enough, it will confess to anything - Ronald Coase  [ Noble Prize-Winning Economist]

We would do the same thing here by torturing the data but with a new Business Intelligence tool by Microsoft i.e Power BI .

This course is designed from scratch right from downloading and installing a software to publishing and sharing dashboards to all end users.

So here course is designed for any user having no coding knowledge or any prior knowledge of any tool.

90% of training would be by button clicks , so no coding .

By End of training, a person can learn Power BI and would be eligible to work in a company for cleaning data, creating reports and dashboards.

Here Power BI as a package is considered having various tools in it. This course would cover Power Query, Power View and Power BI Service.

So lets get ready !!!

Data Visualizations with POWER BI

Data Visualizations with POWER BI

Created by Rahim Zulfiqar Ali - Chief Executive Officer at Excel Basement (Private) Limited

"]

Students: 3949, Price: Free

Students: 3949, Price:  Free

Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. It's important to make the distinction between report designers and report consumers. If you are the person building or modifying the report, then you are a designer. Designers have edit permissions to the report and its underlying dataset. In Power BI Desktop, this means you can open the dataset in Data view and create visuals in Report view.

Microsoft Power BI Business Scenarios

Intermediate course for Power BI users to create real world Business Scenarios step-by-step using Microsoft free tools.

Created by BizticsCom King - Passionate data expert in Business Intelligence field.

"]

Students: 2753, Price: $139.99

Students: 2753, Price:  Paid

Description

**** Life time access to course materials. 100% money back guarantee ****

Companies are gathering more and more data everyday. Skills in data analysis, Business Intelligence / Business Analytics are highly in demand in today's job market. Microsoft Power BI is an advanced yet easy to use self service Business Intelligence / Business Analytics tool for that. It is same B.I. tools used by professional analysts and data scientists.

In this course together we will go over business scenarios where you will learn, how to use Power BI and advanced / complex DAX calculations further to derive more insights from data. We are using SQL Server Adventure Works Data warehouse as a sample database. We will hold your hand and walk you thru each scenario Step-by-step.

Not only you will learn Power BI Best Practices, Tip, Tricks and Case Studies that you won't find in ANY other course but also learn Microsoft's Popular Course DASHBOARD-IN-A-DAY at your own pace at home or at your office AS A BONUS. All of the exercises are designed by keeping the practical aspects of Power BI and DAX in mind. All exercises are 100% hands-on.

25+ hours of HD videos of building Business Scenarios using DAX and 10 interactive Business Intelligence Reports and Dashboards from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning . You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements.

By the time you complete this course, You'll be a highly proficient in DAX and Power BI user. You'll be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease.

Why should you consider a career as a Business Data Analyst?

  • Salary. A Business Data Analyst is a well-paid career

  • Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst.

  • Advancement in Career : Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them.

#microsoft #powerbi #data #business #intelligence #analysis #DAX

We are covering the following in this course.

Section 1: Advanced Microsoft Power BI Introduction

  • Advanced Microsoft Power BI Course Introduction

  • Why Microsoft Power BI

  • Microsoft Power BI Family

  • Microsoft Power BI Desktop

  • Microsoft Power BI Service (Cloud) 1

  • Microsoft Power BI Service (Cloud) 2

  • What is Descriptive, Predictive and Prescriptive Analytics

  • How to take the quizzes

Section 2: Advanced Microsoft Power BI - Collect , In-jest and Import Data

  • Import Data from CSV files in Microsoft

  • Import Data from Excel files in Microsoft Power BI Desktop

  • Import Real-time Streaming Data in Microsoft Power BI Service (Cloud)

  • Import Data from OData Feed REST-API in

  • Microsoft Power BI Desktop

  • Import Data from Folders in Microsoft Power BI Desktop

Section 3: Download and Install SQL Server and Sample Databases

  • Download and Install SQL Server

  • Download and Install Sample Database

  • Import Data from SQL Server in Microsoft Power BI Desktop

Section 4: Introduction to Power BI Dataflows

  • Power BI Dataflows - Introduction

  • Power BI Dataflows - Create Gateway from Scratch

  • Power BI Dataflows - Create Entities from CSV file

  • Power BI Dataflows - Create Entities using SQL Server

Section 5: Introduction to Data Modeling

  • Modeling Basics 0

  • Modeling Basics 1

  • Modeling Basics 2

  • Modeling and Relationships 0

  • Modeling and Relationships 1

  • Other ways to create Relationships

  • Normalization - Denationalization 0

  • Normalization - Denationalization 1

  • OLTP vs OLAP

  • Star Schema vs Snowflake Schema 0

  • Star Schema vs Snowflake Schema 1

Section 6: DAX Basics

  • DAX Basics - Importing Data for Dax Learning

  • DAX Basics - Resources for Dax Learning

  • DAX Basics - What is Dax

  • DAX Basics - Dax Data Types

  • DAX Basics - DAX Operators and Syntax

  • DAX Basics - M vs Dax

  • DAX Basics - Create a Column

  • DAX Basics - Rules to Create Measures

  • DAX Basics - Calculated Columns vs Calculated Measures-0

  • DAX Basics - Calculated Columns vs Calculated Measures-1

  • DAX Basics - Sum()

  • DAX Basics - AVERAGE()-MIN()-MAX()

  • DAX Basics - SUMX()

  • DAX Basics - DIVIDE()

  • DAX Basics - COUNT()-COUNTROWS()

  • DAX Basics - CALCULATE()-0

  • DAX Basics - CALCULATE()-1

  • DAX Basics - FILTER()

  • DAX Basics - ALL()

Section 7: Hands-on Real-word Projects

  • Procurement Spend Analysis

  • Products Analysis

  • Regional Analysis

  • IT Tickets Analysis

  • Human Resources Analysis 1

  • Human Resources Analysis 2

  • Human Resources Analysis 3

  • Financial Analysis

  • Sales/Marketing Analysis

  • Bank Demographic Report

Section 8: Personal - Enterprise Gateway On-Premises Gateway

  • Personal vs Enterprise Gateway

  • Install and Configure Personal Gateway

  • Install and Configure Enterprise Gateway

  • Manage SQL Server Data Source thru Enterprise Gateway

Section 9: Advanced Time-Intelligence

  • Create Date Table in DAX-0

  • Create Date Table in DAX-1

  • Dax Date Code

  • Create Date Table in M (important) 11min

  • Date Table Code in M

  • How to use PREVIOUS Function

  • How to use SAMEPERIODLASTYEAR Function

  • How to calculate Cumulative or Running totals TOTALXXX()

  • How to use DATEADD Function

  • How to add column DateLastPurchase in Customer Table

  • How to calculate Days to Ship and Delivery Status

  • How to calculate Spring-Summer-Autumn-Winter Sales for 2012

  • How to Calculate Customer Age and use it in charts and graphs

  • How to calculate Days till last purchase

  • How to calculate Month-Over-Month values

  • How to calculate Previous Week Sales

  • How to calculate Running Total 1

  • How to calculate Running Total 2

  • How to calculate sales for last N days

  • How to calculate Weekend - Weekday sales 1

  • How to calculate Weekend - Weekday sales 2

  • How to calculate Year-Over-Year Growth

  • How to calculate Year-To-Date with Different Fiscal Year

  • How to Calulate Thanksgiving-BlackFriday-CyberMonday 2 we…

  • How to compare Quarter over Quarter 01

  • How to compare Quarter over Quarter 02

  • How to compare Years-Quarters-Month better way

  • How to create Short Month Name for Fiscal Year

  • How to do Grouping and Segmenting 1

  • How to do Grouping and Segmenting 2

  • How to use specific relationships if you have more than 1 relationship

  • DAX - Quick Measures

  • Display Last Refresh Date

Section 10: Advanced Scenarios

  • Create new table for Scenarios Measures

  • How to calculate number of order per customers

  • How to add calculated column in Employee table

  • How to add calculated column in Resellers table

  • How to calculate Customers (using TOPN) for Target Marketing

  • How to calculate and display Profit Margins

  • How to calculate and display sales growth

  • How to calculate how many items bought by Customers Multple times

  • How to calculate how many Resellers sold specific Item more than 5 times

  • How to calculate Moving Average 1

  • How to calculate Moving Average 2

  • How to calculate number of Products - Customers Sales Trend

  • How to calculate Profit or Margin Variance Month-Over-Month

  • How to calculate Trend on Profit for Internet Sales

  • How to categorize Employees on Sales

  • How to categorize Re-sellers

  • How to create Product Segment

  • How to export measures from Power BI file

  • How to see top N Products 01 Statically

  • How to see top N Products 02 Dynamically

  • How to calculate and show Profits

  • How to calculate Best Product Sales Day

  • How to calculate Dynamic TOPN product or Customers

  • How to calculate Hot Selling Products

  • How to calculate how many unique Customers bought specific Product

  • How to calculate how many unique Products bought by each Customer

  • How to calculate product sales growth

  • How to calculate Re-seller 01 Sales Growth Year-Over-Year

  • How to calculate Re-seller 02 Sales Growth Year-Over-Year

  • How to calculate Revenue Forecast using Analytics Tab

  • How to calculate Revenue Forecast using What If Parameter

  • How to calculate Top Employees

  • How to calculate which Re-seller selling what Products

  • How to show Products quantity forecast using Analytics Tab

  • How to show Products quantity forecast using using What If Parameter

  • How to smooth the trend using Moving Averages

Section 11: Sharing and Collaboration in Power BI

  • Sharing and Collaboration

  • Sharing Dashboards

  • Sharing Workspaces

  • Sharing Apps

  • Publish to web

Section 12: Bonus - Power BI Best Practices

  • Power BI Best Practices 0

  • Power BI Best Practices 1

  • Power BI Best Practices 2

  • Power BI Best Practices 3

  • Power BI Best Practices 4

  • Power BI Best Practices 5

Section 13: Bonus - Dashboard-in-a-day (Same as actual Microsoft class)

  • Power BI Dashboard-in-a-day class 0 - Introduction

  • Power BI Dashboard-in-a-day class 1 - Accessing Data

  • Power BI Dashboard-in-a-day class 2 - Data Preparation

  • Power BI Dashboard-in-a-day class 3 - Data Preparation

  • Power BI Dashboard-in-a-day class 4 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 5 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 6 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 7 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 8 - Modeling and Data Exploration

  • Power BI Dashboard-in-a-day class 9 - Visualization

  • Power BI Dashboard-in-a-day class 10 - Visualization

  • Power BI Dashboard-in-a-day class 11 - Publishing Report

  • Power BI Dashboard-in-a-day class 12 - Creating Dashboards

  • Power BI Dashboard-in-a-day class 13 - Creating Dashboards

  • Power BI Dashboard-in-a-day class 14 - Creating Dashboards

Best Regards

Biztics Team

Microsoft Power BI – Master Power BI in 90 Minutes!

Master Microsoft Power BI, Power Query, Power Pivot & Power View! Power BI web or desktop. Power BI for Office 365.

Created by MyExcelOnline John Michaloudis - Chief Inspirational Officer at MyExcelOnline

"]

Students: 2383, Price: $89.99

Students: 2383, Price:  Paid

You’re Just Seconds Away From Leveraging Excel & Power BI That Will Make It Possible For YOU To:

  1. Increase your Excel & Power BI SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!

  2. Become more PRODUCTIVE at using Power BI which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!

  3. Use Power BI with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!

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

*** This entire courses can be DOWNLOADED for offline viewing on the Udemy mobile app (Android & iOS)! ***

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

If you want to get better at Microsoft Power BI so you get a better paying job or just get answers & insights from your data FAST with Power BI Dashboards, then you are in the right place!

No matter if you are an Power BI Beginner or NEVER USED POWER BI before, you are sure to benefit from this quick course which goes through the MUST KNOW Power BI features.

You will be able to master straight away the following (in just 90 minutes):

  • Everything about Power BI Dashboards

  • Power Query

  • Power Pivot

  • Power View

In Just 90 Minutes You Will Walk Away With...

  • MORE TIME (Who doesn’t want that?)

  • Create your own Power BI Dashboard from scratch in just 90 minutes!

  • Understand the essence of the Power BI visualizations, and see them in action!

  • See how Power BI is used with real examples!

  • Understand how Power Query, Power View, and Power Pivot are used together!

After this class you will be able to:

  • Actually SMILE when you start creating Power BI Dashboards :-)

  • Get valuable data insights & answers anytime you want from your raw data!

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

Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Power BI skills...

…saving HOURS each day, DAYS each week and WEEKS each year…

...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…

...All whilst impressing your boss and STANDING OUT from your colleagues and peers...

...THEN THIS COURSE IS FOR YOU!

Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft skills and JOB OPPORTUNITIES!

To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...

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

>> Get LIFETIME Course access including ALL downloadable video tutorials, Exercises, 1-on-1 instructor SUPPORT and a 100% money-back guarantee!

>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Microsoft Power BI

Microsoft Power BI-A Complete Data Analysis Training Package

Create stunning Power BI reports and analyze business data with Hands-on Power BI projects|Personalized training support

Created by Deepesh Vashistha - Data Analyst/ BI developer, Data Enthusiast

"]

Students: 1939, Price: $94.99

Students: 1939, Price:  Paid

*** Note After enrolling into this course you will get full-time personal assistance and support from instructor with additional projects after the course ***

DESCRIPTION:    

Taking data driven decisions has been very easy with the help of Microsoft Power BI. As per my experience, business intelligence and data analysis companies are searching and preferring those candidates who can work in Power BI. There are tons of jobs available in the market for it.

       

This course is created with all the latest features of Microsoft Power BI (latest updates). So, you will learn to create business reports with all the latest Power BI features. Power BI provides amazing features updates every month So, I will be updating this course every month with all the important features of Power BI.   

In this course you will become Master of:

 

1. How to work in Power BI and creating reports right from the scratch.   

2. There are 2 projects in this course which are created in such a way that you will cover most of the aspects on how to create a report in Power BI desktop and then publish it to share it with others.

You will be analyzing Sales data. As a data analyst, firstly you will learn how to clean and transform data, then you will do various types of analysis like clustering, regression, sentiment analysis etc to gain insights from your sales data in Power BI.   

You will also perform website performance analysis to analyze how a particular website is performing across various locations.

3. We will learn how to use Query Editor to clean and transform our data as per our need.

 

4. Power BI provides amazing updates every month. In this course all the tutorial videos are as per latest Power BI updates and I will keep on updating it every month, so you will never lag.   

5. These projects will teach you different kinds of business analysis and using different visualizations as per your data and requirement.

 

6. We will then also learn how to create calculated DAX measures and columns. DAX measures are used to do some advanced calculations as per our requirement.

 

7. After creating our report in Power BI desktop, we will publish it to Power BI service from where we will create Power BI dashboard and then we will see how we can share it with others.

 

8. There are quizzes in each section which will help you to check your knowledge in Power BI.   

After completing the first project only, you will be very proud of yourself as you would have built stunning feature rich Power BI report and you won’t be able to stop yourself from creating these addictive Power BI reports.     

So, this is what the course is offering. If you are new to Power BI or you have some basic understanding to Power BI but want to improve yourself in it and want to stand out from the crowd. Also, if you are looking yourself in data analysis career, then this is the right course for you.

Why students consider this as the best Power BI course of 2018:

"The course content is really engaging and fresh. Projects are very appealing and a lot of analysis could be learned from them. One could easily learn visualization and analysis from Power BI through this course." - George

"So far a good course. Instructor is teaching at a good pace. Happy to enroll in this course" - Alicia Weber

"I was looking for a fresh Power BI course which can help me create reports with all the new updates. This course is amazing for that. I would recommend anyone who is learning data visualization in Power BI to enroll in this course." - Vijay 

Hope to see you inside the course, let’s begin our journey.

 

Introduction to Data Analysis with Microsoft Power BI

Move beyond BASIC reports and learn data ANALYSIS. Learn to easily turn data into information, insight and intelligence

Created by Ian Littlejohn - Excel Power Tools, Power BI and Google Data Studio Trainer

"]

Students: 1403, Price: $99.99

Students: 1403, Price:  Paid

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 125 000 enrollments & 100 000 students on Udemy. Ian specialises in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI and Google Data Studio & his courses average over 4.5 stars out of 5. 

What students are saying:

"Fantastic course that definitely enhanced my knowledge of data analysis using Power BI. Highly recommend for anyone wanting to learn Power BI."

"This course was an excellent complement to the beginner's course by same instructor. A few concepts overlapped and reinforced what I had learned. The data analysis perspective was refreshing as compared to many courses that focus on features and functions of software tools. Ian Littlejohn is probably one of the best technology instructors on Udemy. I have purchased several of his courses and look forward to completing all of them. Money well spent!!"

"Great practical course which explains the topics."

**** Life time access to course materials and practice activities.  ****

Introduction to Data Analysis with Microsoft Power BI teaches you how to apply different methods of data analysis to turn your data into new insight and intelligence.

The ability to ask questions of your data is a powerful competitive advantage, resulting in new income streams, better decision making and improved productivity. A recent McKinsey Consulting report has identified that data analysis is one of the most important skills required in the global economy at the current time.

During the course you will understand why the form of analysis is important and also provide examples of analysis using Power BI:

The following methods of analysis are included:

  1. Preparing Data for analysis

  2. Key Metrics

  3. Comparison Analysis

  4. Trend Analysis

  5. Ranking Analysis

  6. Interactive Dashboards

  7. Contribution Analysis

  8. Variance Analysis

  9. Frequency Analysis

  10. Correlation Analysis

  11. Table Summary and Relationships

Introduction to Data Analysis with Microsoft Power BI is designed for all business professionals who want to take their ability to turn data into information to the next level. If you are an Excel user then you will want to learn the easy to use techniques that are taught in this course.

Learn Microsoft Power BI

Learn how to turn data into information by creating dashboards to share with your colleagues/friends

Created by Lee Hawthorn - Database professional

"]

Students: 1248, Price: $19.99

Students: 1248, Price:  Paid

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.