Learning Lab Home/Data Science/Microsoft Power BI Desktop for Business Intelligence

Microsoft Power BI Desktop for Business Intelligence

Course From:
Udemy

Welcome to the #1 best-selling Power BI Desktop course – completely rebuilt for 2023!

 

If you’re a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, you’ve come to the right place. With more than 50,000 perfect 5-star reviews from students around the world, this is the course you’ve been looking for.

 

Throughout the course, you’ll learn from top instructors on the Maven Analytics team and put your skills to the test with hands-on projects and unique, real-world assignments.

 

THE COURSE PROJECT:

 

You’ll play the role of Business Intelligence Analyst for AdventureWorks Cycles, a fictional manufacturing company. Your role is to transform raw data into professional-quality reports and dashboards to track KPIs, compare regional performance, analyze product-level trends, and identify high-value customers.

 

But don’t worry, we’ll be here to guide you along every step of the way, with intuitive, crystal clear explanations and helpful pro tips to take you from zero to expert – guaranteed.

 

This course is designed to follow the key stages of the business intelligence workflow, and simulate real-world tasks that data professionals encounter on the job:

 

STAGE 1: Connecting & Shaping Data

In this stage we’ll focus on building automated workflows to extract, transform, and load our project data using Power Query, and explore common data connectors, storage modes, profiling tools, table transformations, and more:

 

  • Data connectors

  • Storage & import modes

  • Query editing tools

  • Table transformations

  • Connecting to a database

  • Extracting data from the web

  • QA & Profiling tools

  • Text, numerical, date & time tools

  • Rolling calendars

  • Index & conditional columns

  • Grouping & aggregating

  • Pivoting & unpivoting

  • Merging & appending queries

  • Data source parameters

  • Importing Excel models

 

STAGE 2: Creating a Relational Data Model

In stage 2 we’ll review data modeling best practices, introduce topics like cardinality, normalization, filter flow and star schemas, and begin to build our AdventureWorks data model from the ground up:

 

  • Database normalization

  • Fact & dimension tables

  • Primary & foreign keys

  • Star & snowflake schemas

  • Active & inactive relationships

  • Relationship cardinality

  • Filter context & flow

  • Bi-directional filters

  • Model layouts

  • Data formats & categories

  • Hierarchies

 

STAGE 3: Adding Calculated Fields with DAX

In stage 3 we’ll introduce data analysis expressions (DAX). We’ll create calculated columns and measures, explore topics like row and filter context, and practice applying powerful tools like filter functions, iterators, and time intelligence patterns:

 

  • DAX vs. M

  • Calculated columns & measures

  • Implicit, explicit & quick measures

  • Measure calculation steps

  • DAX syntax & operators

  • Math & stats functions

  • Conditional & logical functions

  • The SWITCH function

  • Text functions

  • Date & time functions

  • The RELATED function

  • CALCULATE, FILTER & ALL

  • Iterator (X) functions

  • Time intelligence patterns

 

STAGE 4: Visualizing Data with Reports

Stage 4 is about bringing our data to LIFE with reports and dashboards. We’ll review data viz best practices, building and format basic charts, and add interactivity with bookmarks, slicer panels, parameters, tooltips, report navigation, and more:

 

  • Data viz best practices

  • Dashboard design framework

  • Cards & KPIs

  • Line charts, trend lines & forecasts

  • On-object formatting

  • Table & matrix visuals

  • Conditional formatting

  • Top N filtering

  • Map visuals

  • Drill up, drill down & drillthrough

  • Report slicers & interactions

  • Bookmarks & page navigation

  • Numeric & fields parameters

  • Custom tooltips

  • Importing custom visuals

  • Managing & viewing roles (RLS)

  • Mobile layouts

  • Publishing to Power BI Service

 

We’ll also introduce powerful artificial Intelligence tools like decomposition trees, key influencers, smart narratives and natural language Q&A, along with performance optimization techniques to keep your reports running smoothly at scale.

 

Ready to get started? Join today and get immediate, lifetime access to:

 

  • 15 hours of high-quality video

  • 200+ page Power BI ebook

  • 25 homework assignments & solutions

  • Downloadable course project files

  • Expert Q&A support forum

  • 30-day money-back guarantee

 

If you’re looking for the ONE course to help you build job-ready Power BI skills, you’ve come to the right place.

 

SHOW MORE

Course
Intermediate
Careers

Careers Related to Microsoft Power BI Desktop for Business Intelligence

Jobs

Jobs Related to Microsoft Power BI Desktop for Business Intelligence

Certifications

Certifications related to Data Modeling or Business Intelligence

Data Science Accelerator

General Assembly’s Data Science part-time course is a practical introduction to the interdisciplinary field of data science and machine learning, which lies at the intersection of computer science, statistics, and business. You will learn to use the Python programming language to acquire, parse, and model data for informing business strategy. 

This is a fast-paced course with some prerequisites. Students should be comfortable with programming fundamentals, core Python syntax, and basic statistics. There is an option to complete up to 25 hours of online preparatory lessons. Talk to the General Assembly Admissions team to discuss your background and confirm if this is the right fit for you..

 

What you'll accomplish

A significant portion of the course is a hands- on approach to fundamental modeling techniques and machine learning algorithms. You’ll also practice communicating your results and insights by compiling technical documentation and a stakeholder presentation. Throughout this expert-designed program, you’ll:

  • Perform exploratory data analysis with Python.
  • Build and refine machine learning models to predict patterns
  • from data sets.
  • Communicate data-driven insights to technical and non-technical audiences alike.
  • Apply what you’ve learned to create a portfolio project: a predictive model that addresses a real-world data problem.

 

Why General Assembly

Since 2011, General Assembly has graduated more than 40,000 students worldwide from the full time & part time courses. During the 2020 hiring shutdown, GA's students, instructors, and career coaches never lost focus, and the KPMG-validated numbers in their Outcomes report reflect it. *For students who graduated in 2020 — the peak of the pandemic — 74.4% of those who participated in GA's full-time Career Services program landed jobs within six months of graduation. General Assembly is proud of their grads + teams' relentless dedication and to see those numbers rising. Download the report here.

 

Your next step? Submit an application to talk to the General Assembly Admissions team


 

Note: reviews are referenced from Career Karma - https://careerkarma.com/schools/general-assembly

 

General Assembly
Data Analytics Accelerator

General Assembly’s Data Analytics Immersive is designed for you to harness Excel, SQL, and Tableau to tell compelling stories with a data driven strategy. This program was created for analysts, digital marketers, sales managers, product managers, and data novices looking to learn the essentials of data analysis. 

 

What you'll accomplish

You will learn to use industry tools, Excel, and SQL to analyze large real world data sets and create data dashboards and visualizations to share your findings. The Data Analytics Accelerator culminates in a.

Throughout this expert-designed program, you’ll:

  • Use Excel, SQL, and Tableau to collect, clean, and analyze large data sets.
  • Present data-driven insights to key stakeholders using data visualization and dashboards.
  • Tell compelling stories with your data.
  • Graduate with a professional portfolio of projects that includes a capstone project applying rigorous data analysis techniques to solve a real-world problem

 

Why General Assembly

Since 2011, General Assembly has graduated more than 40,000 students worldwide from the full time & part time courses. During the 2020 hiring shutdown, GA's students, instructors, and career coaches never lost focus, and the KPMG-validated numbers in their Outcomes report reflect it. *For students who graduated in 2020 — the peak of the pandemic — 74.4% of those who participated in GA's full-time Career Services program landed jobs within six months of graduation. General Assembly is proud of their grads + teams' relentless dedication and to see those numbers rising. Download the report here.

 

Your next step? Submit an application to talk to the General Assembly Admissions team


 

Note: reviews are referenced from Career Karma - https://careerkarma.com/schools/general-assembly

 

General Assembly
Data Science Bootcamp

General Assembly’s Data Science Immersive is a transformative course designed for you to get the necessary skills for a data scientist role in three months. 

The Data Science bootcamp is led by instructors who are expert practitioners in their field, supported by career coaches that work with you since day one and enhanced by a career services team that is constantly in talks with employers about their tech hiring needs.

 

What you'll accomplish

As a graduate, you will be ready to succeed in a variety of data science and advanced analytics roles, creating predictive models that drive decision-making and strategy throughout organizations of all kinds. Throughout this expert-designed program, you’ll:

  • Collect, extract, query, clean, and aggregate data for analysis.
  • Gather, store and organize data using SQL and Git.
  • Perform visual and statistical analysis on data using Python and its associated libraries and tools.
  • Craft and share compelling narratives through data visualization.
  • Build and implement appropriate machine learning models and algorithms to evaluate data science problems spanning finance, public policy, and more.
  • Compile clear stakeholder reports to communicate the nuances of your analyses.
  • Apply question, modeling, and validation problem-solving processes to data sets from various industries to provide insight into real-world problems and solutions.
  • Prepare for the world of work, compiling a professional-grade portfolio of solo, group, and client projects.

 

Why General Assembly

Since 2011, General Assembly has graduated more than 40,000 students worldwide from the full time & part time courses. During the 2020 hiring shutdown, GA's students, instructors, and career coaches never lost focus, and the KPMG-validated numbers in their Outcomes report reflect it. *For students who graduated in 2020 — the peak of the pandemic — 74.4% of those who participated in GA's full-time Career Services program landed jobs within six months of graduation. General Assembly is proud of their grads + teams' relentless dedication and to see those numbers rising. Download the report here.

 

Your next step? Submit an application to talk to the General Assembly Admissions team


 

Note: reviews are referenced from Career Karma - https://careerkarma.com/schools/general-assembly

 

General Assembly
Courses

Courses related to Data Modeling or Business Intelligence

Intro to Data Analytics Webinar
General Assembly

Regardless of your industry or role, fluency in the language of data analytics will allow you to contribute to data driven decision making.

…

4.5
(462)
Intro to Data Science Webinar
General Assembly

In this two hour live workshop you will walk through the typical data science workflow and see how the pros identify powerful business predictions. You’ll get first-hand experience to explore the key tools and…

4.5
(462)
Statistics / Data Analysis in SPSS: Inferential Statistics
Udemy

This course is great for professionals, as it provides step by step instruction of tests with clear and accurate explanations. Get ahead of the competition and make these tests important parts of your data analytic toolkit!

…
Big Data Hadoop and Spark with Scala
Udemy

This course will make you ready to switch career on big data hadoop and spark.

After this watching this, you will understand about Hadoop, HDFS, YARN, Map reduce, python, pig, hive, oozie, sqoop, flume, HBase, No SQL, Spark, Spark sql,…