Microsoft Power BI Desktop for Business Intelligence

In partnership With

Udemy

4.6

(50,673)

Topic:

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

What You'll Learn:

Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive dashboards
Design and implement the same B.I. tools used by professional analysts and data scientists
Showcase your skills with two full-scale course projects (with step-by-step solutions)
Understand the business intelligence workflow from end-to-end
Learn from a best-selling instructor and professional BI developer

Requirements:

Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)
Experience with Excel Power Query, Power Pivot & DAX is a plus, but not required

Description:

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 #1: Connect & 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!

Who this course is for:

Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Aspiring data professionals looking to master the #1 business intelligence tool on the market
Students who want a comprehensive, engaging, and highly interactive approach to training
Anyone looking to pursue a career in data analysis or business intelligence

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

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

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)