+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Power Pivoting Microsoft Power BI for Career Changers (/Thread-Power-Pivoting-Microsoft-Power-BI-for-Career-Changers)
Power Pivoting Microsoft Power BI for Career Changers - Farid - 10-09-2023
![[Image: PDpOam.v53cm0ask2ew.jpg]](https://i.im.ge/2023/10/09/PDpOam.v53cm0ask2ew.jpg)
Power Pivoting: Microsoft Power Bi For Career Changers
Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 19.76 GB | Duration: 28h 45m
Explore Power BI with tons of tutorials on data modeling, DAX, design, visualization, storytelling & BI career guidance
What you'll learn
Learn about what business intelligence professionals do and how their skills complement & overlap with other roles at data-driven companies
Learn how to utilize the Power Query Editor to clean, transform, and model data
Learn how to build and format a variety of different Power BI data visuals
Learn a variety of core design principles such as color theory, Gestalt design techniques, and visual encoding to design more visually impactful data tools
Learn how to make the user experience and interactivity of your tools more effective by utilizing bookmarks, tooltip pages, and drill-through pages
Learn how to write DAX measures utilizing a variety of common functions and apply them to different business scenarios including time-series data
Learn about AI-enabled "smart visuals" that combine the data visualization capabilities of Power BI with data science techniques
Enjoy a complete walkthrough of a Power BI from start to finish, beginning with the ingestion & modeling of data and ending with designing an amazing report
Requirements
There are no requirements for taking this course but it is highly encouraged that you download Power BI Desktop beforehand if you wish to following along with some of the content
Description
In this course, get ready to kick off your business intelligence career with a variety of focused content built to equip you with the skills you will need to break into a rewarding and competitive BI industry. Yes, it's yet another Intro to Power BI course-but this class will also focus on enhancing your burgeoning Power BI skills with a variety of other areas that are sure to elevate your dashboarding & reporting acumen beyond simple data charts and tables.Power Pivoting combines in-depth Power BI tutorials with business intelligence career discussion videos, demonstrations of impactful design and data storytelling techniques, intermediate-level tips and tricks for wowing your business users, almost a dozen hands-on DAX demonstrations, and a full-length Power BI walkthrough that will take you all the way from importing your data to building a tool that's ready to publish.If you are considering getting your hands dirty with data and transitioning from a non-data career into one where transforming data, calculating metrics, and telling complex data stories through simple visualizations are just another day in the office, this is the course for you. The road to a successful BI career transition can be a long and difficult one; this class will walk you through everything you need to know from a Power BI perspective alongside an instructor who went through that transition himself and never looked back.
Overview
Section 1: Instructor & Topic Introduction
Lecture 1 Instructor & Topic Introduction
Section 2: BI 101: Introduction to Business Intelligence
Lecture 2 Part 1: Introduction to Business Intelligence
Lecture 3 Part 2: What Does a BI Professional Actually Do?
Lecture 4 Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 1)
Lecture 5 Career Topic: Interview with BI Career Pivoter, Dr. Nina Marijanović (Part 2)
Section 3: BI 101: The Business Intelligence Career Toolkit
Lecture 6 The Business Intelligence Career Toolkit
Lecture 7 Career Topic: What Makes a Great BI Resume?
Section 4: BI 101: Introduction To Microsoft Power BI
Lecture 8 Introduction to Microsoft Power BI
Lecture 9 Walkthrough of a Microsoft Power BI Report Example
Lecture 10 Career Topic: Let's Talk About Business Intelligence Careers
Section 5: Data Modeling 101: Transforming Data with the Power Query Editor
Lecture 11 Transforming Data with the Power Query Editor
Lecture 12 Tutorial: Applying Power Query Editor Transformations to a Dataset
Lecture 13 Tutorial: Building a Date Table with the Power Query Editor
Section 6: Data Modeling 101: Data Modeling Concepts
Lecture 14 Data Modeling Concepts with the Power Query Editor
Lecture 15 Tutorial: Modeling an HR Dataset into a Star Schema
Lecture 16 Career Topic: What Makes a Great Power BI Portfolio?
Section 7: Front-End BI Design 101: Data Visualization 101
Lecture 17 Choosing the Right Data Visual
Lecture 18 Tutorial: Bar Charts
Lecture 19 Tutorial: Line Charts
Lecture 20 Tutorial: Area Charts
Lecture 21 Tutorial: Donut Charts & Cards
Lecture 22 Tutorial: Maps
Lecture 23 Tutorial: Tables & Matrices
Lecture 24 Tutorial: Scatter Plots
Lecture 25 Bonus Tutorial: Slicers
Section 8: Front-End BI Design 101: The Art of Designing BI Tools
Lecture 26 Design Techniques for Power BI
Lecture 27 Introduction to Data Storytelling
Lecture 28 Tutorial: Applying Gestalt Techniques
Section 9: Front-End BI Design 101: Data Visualization 102
Lecture 29 Applying Design Techniques to Data Visualization in Power BI
Lecture 30 Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 1)
Lecture 31 Tutorial: Enhancing a Report with Design & Data Storytelling Techniques (Part 2)
Section 10: Front-End BI Design 101: Building Power BI Tools for Interactivity
Lecture 32 Building Power BI Tools for Interactivity
Lecture 33 Tutorial: Deploying Buttons in Power BI
Lecture 34 Tutorial: Introduction to Power BI Bookmarks
Lecture 35 Clarification: Navigating Bookmark Settings
Lecture 36 Tutorial: Unlocking the Magic of Hovering with Tooltip Report Pages
Lecture 37 Tutorial: Get Drilling with Drill-Through Pages
Section 11: Intermediate Topics: Data Analysis Expression (DAX)
Lecture 38 The One About DAX
Lecture 39 Tutorial: Basic Measures
Lecture 40 Tutorial: Filter Functions
Lecture 41 Tutorial: Logical Functions
Lecture 42 Tutorial: Calculated Columns
Lecture 43 Tutorial: Text Functions
Lecture 44 Tutorial: Date Functions
Lecture 45 Tutorial: Time-Series Analysis Part 1
Lecture 46 Tutorial: Time-Series Analysis Part 2
Lecture 47 Tutorial: Advanced Aggregations
Lecture 48 Tutorial: Quick Measures
Section 12: Intermediate Topics: Smart Visuals and Intermediate Design Techniques
Lecture 49 Introduction
Lecture 50 Smart Visuals: Key Influencers
Lecture 51 Smart Visuals: Decomposition Tree
Lecture 52 Smart Visuals: Q&A Visual
Lecture 53 Smart Visuals: Smart Narrative
Lecture 54 Design Technique: Building a Slicer Panel
Lecture 55 Design Technique: Understanding Disconnected Slicers
Lecture 56 Design Technique: Field Parameters
Lecture 57 Design Technique: BYOB (Build Your Own Buttons)
Lecture 58 Design Technique: Building a Data Sandbox for Your Users
Section 13: Applying Power BI: Publishing Reports to the Power BI Service
Lecture 59 Publishing to the Power BI Service
Lecture 60 Tutorial: Walkthrough of the Power BI Service
Lecture 61 Career Topic: Preparing for the BI Interview
Section 14: Applying Power BI: Full-Length Tutorial (Toy Company Sales Dataset)
Lecture 62 Toy Company Sales Data Overview
Lecture 63 Designing Our Layout
Lecture 64 Importing Our Color Theme
Lecture 65 Modeling the Toy Company Sales Datasets
Lecture 66 Handling Background Images
Lecture 67 Building Our DAX Measure Tables
Lecture 68 Writing our DAX Sales Performance Measures
Lecture 69 Formatting Our Sales Performance Page
Lecture 70 Building a Product Performance Page
Lecture 71 Building a Store Performance Page
Lecture 72 Projecting Sales Performance Against an Annual Target
Section 15: Course Summary & Next Steps
Lecture 73 Course Summary & Wrap-Up
Lecture 74 Continuing Your Journey: The Microsoft Power Platform & Azure Synapse Analytics
This course is designed with career pivoters in mind but is designed for anyone who is looking for broad exposure to a wide range of Power BI and business intelligence concepts,In addition to Power BI curriculum, this course also includes videos oriented towards helping career changers understand business intelligence roles, resumes, interviews, and more
Power Pivoting Microsoft Power BI for Career Changers (19.76 GB)
KatFile Link(s)
RapidGator Link(s)